or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 742

Total elapsed time: 2.4129989147186

# Query Time
(1) connect 0.032839059829712
(2) DESCRIBE `cruises` 0.009260892868042
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76402, 85107, 76357, 76356, 61517, 76414, 84401, 61418, 72817, 76358)) ORDER BY FIND_IN_SET(id, '76402,85107,76357,76356,61517,76414,84401,61418,72817,76358') 0.0084841251373291
(4) DESCRIBE `cruises` 0.026662826538086
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76402') 0.017338991165161
(6) DESCRIBE `ships` 0.0058689117431641
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0035650730133057
(8) DESCRIBE `ships` 0.0064210891723633
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0026841163635254
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0040810108184814
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046014785766602
(12) DESCRIBE `itineraries` 0.0031640529632568
(13) DESCRIBE `ports` 0.0037658214569092
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0017480850219727
(15) DESCRIBE `ports` 0.002964973449707
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0037350654602051
(17) DESCRIBE `ports` 0.0027260780334473
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00056099891662598
(19) DESCRIBE `sailingdates` 0.0026998519897461
(20) DESCRIBE `ports` 0.0025711059570312
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051307678222656
(22) DESCRIBE `ports` 0.002345085144043
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0056881904602051
(24) DESCRIBE `ports` 0.012795925140381
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.006619930267334
(26) DESCRIBE `ports` 0.0025031566619873
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00057291984558105
(28) DESCRIBE `ports` 0.0037491321563721
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00079894065856934
(30) DESCRIBE `ports` 0.0067830085754395
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0069260597229004
(32) DESCRIBE `ports` 0.058973073959351
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.0025079250335693
(34) DESCRIBE `ports` 0.008965015411377
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.001227855682373
(36) DESCRIBE `ports` 0.003119945526123
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.005856990814209
(38) DESCRIBE `ports` 0.0043768882751465
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00062894821166992
(40) DESCRIBE `ports` 0.0025150775909424
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055599212646484
(42) DESCRIBE `ports` 0.004141092300415
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0062289237976074
(44) DESCRIBE `avid_specials` 0.0029120445251465
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76402 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002263069152832
(46) DESCRIBE `cruiselines` 0.016297817230225
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00077486038208008
(48) DESCRIBE `orchid_image` 0.0041368007659912
(49) DESCRIBE `cruiselines` 0.01118803024292
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0065059661865234
(51) DESCRIBE `cruises` 0.0047688484191895
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85107') 0.00073599815368652
(53) DESCRIBE `ships` 0.0050878524780273
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.028239965438843
(55) DESCRIBE `ships` 0.011709213256836
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.0037109851837158
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060296058654785
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050187110900879
(59) DESCRIBE `itineraries` 0.0042159557342529
(60) DESCRIBE `ports` 0.013283967971802
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00083589553833008
(62) DESCRIBE `ports` 0.0037341117858887
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.019325971603394
(64) DESCRIBE `ports` 0.012647867202759
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0010159015655518
(66) DESCRIBE `sailingdates` 0.0026860237121582
(67) DESCRIBE `ports` 0.0038979053497314
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00070500373840332
(69) DESCRIBE `ports` 0.0039811134338379
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0007328987121582
(71) DESCRIBE `ports` 0.0066661834716797
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.0007328987121582
(73) DESCRIBE `ports` 0.0091099739074707
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.0012938976287842
(75) DESCRIBE `ports` 0.003587007522583
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00068211555480957
(77) DESCRIBE `ports` 0.0034809112548828
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00193190574646
(79) DESCRIBE `ports` 0.022217988967896
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0014939308166504
(81) DESCRIBE `ports` 0.0036039352416992
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0028059482574463
(83) DESCRIBE `ports` 0.0025818347930908
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00061917304992676
(85) DESCRIBE `ports` 0.002335786819458
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00472092628479
(87) DESCRIBE `ports` 0.021620035171509
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0031509399414062
(89) DESCRIBE `ports` 0.0032970905303955
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00069594383239746
(91) DESCRIBE `ports` 0.0045888423919678
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00063896179199219
(93) DESCRIBE `ports` 0.0053141117095947
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00060510635375977
(95) DESCRIBE `ports` 0.002640962600708
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00060701370239258
(97) DESCRIBE `ports` 0.0024130344390869
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055909156799316
(99) DESCRIBE `avid_specials` 0.0020740032196045
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85107 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018961429595947
(101) DESCRIBE `cruiselines` 0.003497838973999
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00058698654174805
(103) DESCRIBE `orchid_image` 0.0025739669799805
(104) DESCRIBE `cruiselines` 0.0040698051452637
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0010988712310791
(106) DESCRIBE `cruises` 0.005324125289917
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76357') 0.010861873626709
(108) DESCRIBE `ships` 0.0046820640563965
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.010640859603882
(110) DESCRIBE `ships` 0.0074269771575928
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.001101016998291
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049591064453125
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00043511390686035
(114) DESCRIBE `itineraries` 0.0073978900909424
(115) DESCRIBE `ports` 0.0028247833251953
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00072908401489258
(117) DESCRIBE `ports` 0.0030009746551514
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00065517425537109
(119) DESCRIBE `ports` 0.0029928684234619
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00052309036254883
(121) DESCRIBE `sailingdates` 0.0022540092468262
(122) DESCRIBE `ports` 0.0027809143066406
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00064802169799805
(124) DESCRIBE `ports` 0.0026450157165527
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.0005650520324707
(126) DESCRIBE `ports` 0.00313401222229
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00077390670776367
(128) DESCRIBE `ports` 0.0051431655883789
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00072598457336426
(130) DESCRIBE `ports` 0.0030879974365234
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00096392631530762
(132) DESCRIBE `ports` 0.012684106826782
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00063300132751465
(134) DESCRIBE `ports` 0.006443977355957
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.0007481575012207
(136) DESCRIBE `ports` 0.0030641555786133
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.0012249946594238
(138) DESCRIBE `ports` 0.010683059692383
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.0010981559753418
(140) DESCRIBE `ports` 0.0039880275726318
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.0016179084777832
(142) DESCRIBE `ports` 0.00282883644104
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0012891292572021
(144) DESCRIBE `ports` 0.0040709972381592
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00090813636779785
(146) DESCRIBE `ports` 0.0062129497528076
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00086712837219238
(148) DESCRIBE `ports` 0.003040075302124
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.000640869140625
(150) DESCRIBE `ports` 0.0046029090881348
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00078105926513672
(152) DESCRIBE `ports` 0.0060648918151855
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00078511238098145
(154) DESCRIBE `ports` 0.0055780410766602
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00059318542480469
(156) DESCRIBE `ports` 0.0029571056365967
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00065302848815918
(158) DESCRIBE `ports` 0.0023849010467529
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00069880485534668
(160) DESCRIBE `ports` 0.0036709308624268
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.0007479190826416
(162) DESCRIBE `ports` 0.0036699771881104
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00074100494384766
(164) DESCRIBE `ports` 0.0030910968780518
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00067400932312012
(166) DESCRIBE `ports` 0.0045950412750244
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00074100494384766
(168) DESCRIBE `ports` 0.0048611164093018
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00064516067504883
(170) DESCRIBE `ports` 0.0032110214233398
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00072789192199707
(172) DESCRIBE `ports` 0.0028119087219238
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00081205368041992
(174) DESCRIBE `ports` 0.0058281421661377
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.00086212158203125
(176) DESCRIBE `ports` 0.0051648616790771
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.00074100494384766
(178) DESCRIBE `ports` 0.01948094367981
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.013753890991211
(180) DESCRIBE `ports` 0.0030949115753174
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00067496299743652
(182) DESCRIBE `ports` 0.0030238628387451
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.0007169246673584
(184) DESCRIBE `ports` 0.0030810832977295
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.00066089630126953
(186) DESCRIBE `ports` 0.0029881000518799
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 689))) 0.00074315071105957
(188) DESCRIBE `ports` 0.0028641223907471
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '689') 0.00057101249694824
(190) DESCRIBE `ports` 0.0022649765014648
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00058102607727051
(192) DESCRIBE `ports` 0.0022351741790771
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.0005037784576416
(194) DESCRIBE `ports` 0.0022158622741699
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00054502487182617
(196) DESCRIBE `ports` 0.0047378540039062
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.0006411075592041
(198) DESCRIBE `ports` 0.0033559799194336
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00068402290344238
(200) DESCRIBE `ports` 0.0038909912109375
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00060200691223145
(202) DESCRIBE `ports` 0.003892183303833
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00061798095703125
(204) DESCRIBE `ports` 0.0094399452209473
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00074982643127441
(206) DESCRIBE `ports` 0.0031459331512451
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00069999694824219
(208) DESCRIBE `ports` 0.002763032913208
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00054311752319336
(210) DESCRIBE `ports` 0.002392053604126
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00074005126953125
(212) DESCRIBE `ports` 0.002903938293457
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00065803527832031
(214) DESCRIBE `ports` 0.0030100345611572
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00060200691223145
(216) DESCRIBE `ports` 0.0035800933837891
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00049495697021484
(218) DESCRIBE `ports` 0.0024449825286865
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00054001808166504
(220) DESCRIBE `ports` 0.0022389888763428
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00047206878662109
(222) DESCRIBE `ports` 0.0021851062774658
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00056004524230957
(224) DESCRIBE `ports` 0.0027329921722412
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00058197975158691
(226) DESCRIBE `avid_specials` 0.001971960067749
(227) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76357 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020599365234375
(228) DESCRIBE `cruiselines` 0.0035190582275391
(229) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00064992904663086
(230) DESCRIBE `orchid_image` 0.0031981468200684
(231) DESCRIBE `cruiselines` 0.0040249824523926
(232) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00053191184997559
(233) DESCRIBE `cruises` 0.0055398941040039
(234) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76356') 0.00081896781921387
(235) DESCRIBE `ships` 0.0058310031890869
(236) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00068092346191406
(237) DESCRIBE `ships` 0.0075750350952148
(238) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0037250518798828
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00064992904663086
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00096678733825684
(241) DESCRIBE `itineraries` 0.0043411254882812
(242) DESCRIBE `ports` 0.0032620429992676
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.0006251335144043
(244) DESCRIBE `ports` 0.0025410652160645
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.0010080337524414
(246) DESCRIBE `ports` 0.0034201145172119
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00063896179199219
(248) DESCRIBE `sailingdates` 0.002938985824585
(249) DESCRIBE `ports` 0.0025110244750977
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00056290626525879
(251) DESCRIBE `ports` 0.0034050941467285
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00066399574279785
(253) DESCRIBE `ports` 0.0083279609680176
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00063204765319824
(255) DESCRIBE `ports` 0.0026459693908691
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00067591667175293
(257) DESCRIBE `ports` 0.0023081302642822
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00052809715270996
(259) DESCRIBE `ports` 0.0024890899658203
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00057482719421387
(261) DESCRIBE `ports` 0.0026261806488037
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00066900253295898
(263) DESCRIBE `ports` 0.0032908916473389
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00057601928710938
(265) DESCRIBE `ports` 0.0027279853820801
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.0005950927734375
(267) DESCRIBE `ports` 0.002877950668335
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00047683715820312
(269) DESCRIBE `ports` 0.0022830963134766
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00047206878662109
(271) DESCRIBE `ports` 0.0026009082794189
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00044989585876465
(273) DESCRIBE `ports` 0.0033071041107178
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00059390068054199
(275) DESCRIBE `ports` 0.0024878978729248
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00052905082702637
(277) DESCRIBE `ports` 0.0029678344726562
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00069499015808105
(279) DESCRIBE `ports` 0.0026628971099854
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00061893463134766
(281) DESCRIBE `ports` 0.0029799938201904
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00062799453735352
(283) DESCRIBE `ports` 0.007317066192627
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00065994262695312
(285) DESCRIBE `ports` 0.0022571086883545
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00071215629577637
(287) DESCRIBE `ports` 0.0023319721221924
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00052309036254883
(289) DESCRIBE `ports` 0.0024800300598145
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00063109397888184
(291) DESCRIBE `ports` 0.0027031898498535
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00054001808166504
(293) DESCRIBE `ports` 0.0026490688323975
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00061297416687012
(295) DESCRIBE `ports` 0.0029010772705078
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.0005488395690918
(297) DESCRIBE `ports` 0.0023179054260254
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00056600570678711
(299) DESCRIBE `ports` 0.00301194190979
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00076889991760254
(301) DESCRIBE `avid_specials` 0.0025520324707031
(302) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76356 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022292137145996
(303) DESCRIBE `cruiselines` 0.0041728019714355
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00077414512634277
(305) DESCRIBE `orchid_image` 0.0033929347991943
(306) DESCRIBE `cruiselines` 0.0042679309844971
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00072407722473145
(308) DESCRIBE `cruises` 0.0069100856781006
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61517') 0.00078892707824707
(310) DESCRIBE `ships` 0.0056948661804199
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00095486640930176
(312) DESCRIBE `ships` 0.0050668716430664
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00071096420288086
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054717063903809
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00061821937561035
(316) DESCRIBE `itineraries` 0.0029869079589844
(317) DESCRIBE `ports` 0.0027551651000977
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00080513954162598
(319) DESCRIBE `ports` 0.0031399726867676
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00070309638977051
(321) DESCRIBE `ports` 0.0029909610748291
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00064587593078613
(323) DESCRIBE `sailingdates` 0.0026111602783203
(324) DESCRIBE `ports` 0.0034129619598389
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00075578689575195
(326) DESCRIBE `ports` 0.0030279159545898
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00068402290344238
(328) DESCRIBE `ports` 0.0028808116912842
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00070405006408691
(330) DESCRIBE `ports` 0.0029661655426025
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00055408477783203
(332) DESCRIBE `ports` 0.002316951751709
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00061678886413574
(334) DESCRIBE `ports` 0.0025019645690918
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00058102607727051
(336) DESCRIBE `ports` 0.0044431686401367
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00091195106506348
(338) DESCRIBE `ports` 0.0040178298950195
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00072097778320312
(340) DESCRIBE `ports` 0.0029678344726562
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.0007469654083252
(342) DESCRIBE `ports` 0.0028328895568848
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00068211555480957
(344) DESCRIBE `ports` 0.0029327869415283
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00072693824768066
(346) DESCRIBE `ports` 0.0028600692749023
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00063014030456543
(348) DESCRIBE `ports` 0.0063130855560303
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0014591217041016
(350) DESCRIBE `ports` 0.0040600299835205
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00064396858215332
(352) DESCRIBE `ports` 0.0035479068756104
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00088095664978027
(354) DESCRIBE `ports` 0.0043070316314697
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00062894821166992
(356) DESCRIBE `ports` 0.0029370784759521
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00062894821166992
(358) DESCRIBE `ports` 0.022937059402466
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0006561279296875
(360) DESCRIBE `ports` 0.0030391216278076
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00084996223449707
(362) DESCRIBE `ports` 0.0027451515197754
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.014066934585571
(364) DESCRIBE `ports` 0.0065178871154785
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0085060596466064
(366) DESCRIBE `ports` 0.0035281181335449
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00071191787719727
(368) DESCRIBE `ports` 0.0033469200134277
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0065650939941406
(370) DESCRIBE `ports` 0.0031239986419678
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0006871223449707
(372) DESCRIBE `ports` 0.0033700466156006
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.0081977844238281
(374) DESCRIBE `ports` 0.003525972366333
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00090503692626953
(376) DESCRIBE `ports` 0.0036129951477051
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0021078586578369
(378) DESCRIBE `ports` 0.0027430057525635
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00058889389038086
(380) DESCRIBE `ports` 0.0025279521942139
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0021018981933594
(382) DESCRIBE `ports` 0.0025949478149414
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00064897537231445
(384) DESCRIBE `ports` 0.0029940605163574
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00086212158203125
(386) DESCRIBE `ports` 0.0029571056365967
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00075602531433105
(388) DESCRIBE `avid_specials` 0.0025379657745361
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61517 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021669864654541
(390) DESCRIBE `cruiselines` 0.0040080547332764
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00071811676025391
(392) DESCRIBE `orchid_image` 0.0033600330352783
(393) DESCRIBE `cruiselines` 0.0042638778686523
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00063014030456543
(395) DESCRIBE `cruises` 0.0065808296203613
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76414') 0.00077295303344727
(397) DESCRIBE `ships` 0.0059359073638916
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.0009770393371582
(399) DESCRIBE `ships` 0.0058810710906982
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.0010678768157959
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050902366638184
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00048089027404785
(403) DESCRIBE `itineraries` 0.0026841163635254
(404) DESCRIBE `ports` 0.0031678676605225
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00060296058654785
(406) DESCRIBE `ports` 0.002377986907959
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00068306922912598
(408) DESCRIBE `ports` 0.0030269622802734
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00061392784118652
(410) DESCRIBE `sailingdates` 0.0019891262054443
(411) DESCRIBE `ports` 0.0026319026947021
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00047492980957031
(413) DESCRIBE `ports` 0.0022170543670654
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00056886672973633
(415) DESCRIBE `ports` 0.0028879642486572
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00065898895263672
(417) DESCRIBE `ports` 0.0026631355285645
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00054788589477539
(419) DESCRIBE `ports` 0.0025870800018311
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00056099891662598
(421) DESCRIBE `ports` 0.0020849704742432
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00038909912109375
(423) DESCRIBE `ports` 0.0024328231811523
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.0005030632019043
(425) DESCRIBE `ports` 0.0025808811187744
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00057101249694824
(427) DESCRIBE `ports` 0.0029261112213135
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00053191184997559
(429) DESCRIBE `ports` 0.0026960372924805
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00055098533630371
(431) DESCRIBE `ports` 0.0025241374969482
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00065302848815918
(433) DESCRIBE `ports` 0.0029370784759521
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00066900253295898
(435) DESCRIBE `ports` 0.0026798248291016
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00062108039855957
(437) DESCRIBE `ports` 0.0027360916137695
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00039291381835938
(439) DESCRIBE `ports` 0.002730131149292
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00064396858215332
(441) DESCRIBE `ports` 0.0027179718017578
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00055599212646484
(443) DESCRIBE `ports` 0.0030720233917236
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00051403045654297
(445) DESCRIBE `ports` 0.0028939247131348
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00061607360839844
(447) DESCRIBE `ports` 0.0027921199798584
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00067806243896484
(449) DESCRIBE `ports` 0.0026431083679199
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00058603286743164
(451) DESCRIBE `ports` 0.0020430088043213
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053000450134277
(453) DESCRIBE `ports` 0.0020630359649658
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0005800724029541
(455) DESCRIBE `avid_specials` 0.0017340183258057
(456) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76414 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017440319061279
(457) DESCRIBE `cruiselines` 0.0027589797973633
(458) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00045084953308105
(459) DESCRIBE `orchid_image` 0.0022139549255371
(460) DESCRIBE `cruiselines` 0.0030989646911621
(461) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048112869262695
(462) DESCRIBE `cruises` 0.0045571327209473
(463) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84401') 0.00050902366638184
(464) DESCRIBE `ships` 0.004734992980957
(465) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00056004524230957
(466) DESCRIBE `ships` 0.0037639141082764
(467) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00050997734069824
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036406517028809
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037884712219238
(470) DESCRIBE `itineraries` 0.002129077911377
(471) DESCRIBE `ports` 0.0020310878753662
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00051784515380859
(473) DESCRIBE `ports` 0.0021018981933594
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00054693222045898
(475) DESCRIBE `ports` 0.0020890235900879
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00056695938110352
(477) DESCRIBE `sailingdates` 0.0017349720001221
(478) DESCRIBE `ports` 0.0019080638885498
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00045108795166016
(480) DESCRIBE `ports` 0.0021429061889648
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00038409233093262
(482) DESCRIBE `ports` 0.0063879489898682
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059))) 0.0005958080291748
(484) DESCRIBE `ports` 0.0032949447631836
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059') 0.00099587440490723
(486) DESCRIBE `ports` 0.0025432109832764
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.00069403648376465
(488) DESCRIBE `ports` 0.0024769306182861
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.00055408477783203
(490) DESCRIBE `ports` 0.0022521018981934
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00072383880615234
(492) DESCRIBE `ports` 0.0022718906402588
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.0006868839263916
(494) DESCRIBE `ports` 0.0031871795654297
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00093388557434082
(496) DESCRIBE `ports` 0.00295090675354
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00062799453735352
(498) DESCRIBE `ports` 0.0030159950256348
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0010190010070801
(500) DESCRIBE `ports` 0.0029280185699463
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00056290626525879
(502) DESCRIBE `ports` 0.0026149749755859
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00099802017211914
(504) DESCRIBE `ports` 0.0030460357666016
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00062799453735352
(506) DESCRIBE `ports` 0.0029690265655518
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00065994262695312
(508) DESCRIBE `ports` 0.0030980110168457
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00059604644775391
(510) DESCRIBE `ports` 0.0030219554901123
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00097918510437012
(512) DESCRIBE `ports` 0.0034279823303223
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0007469654083252
(514) DESCRIBE `ports` 0.0033719539642334
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.00088000297546387
(516) DESCRIBE `ports` 0.0034329891204834
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.0007021427154541
(518) DESCRIBE `ports` 0.0034050941467285
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00090122222900391
(520) DESCRIBE `ports` 0.0031299591064453
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00081491470336914
(522) DESCRIBE `avid_specials` 0.0029330253601074
(523) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84401 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0025780200958252
(524) DESCRIBE `cruiselines` 0.0046820640563965
(525) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.001007080078125
(526) DESCRIBE `orchid_image` 0.0036849975585938
(527) DESCRIBE `cruiselines` 0.0048360824584961
(528) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00086116790771484
(529) DESCRIBE `cruises` 0.0057318210601807
(530) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61418') 0.00076603889465332
(531) DESCRIBE `ships` 0.0059010982513428
(532) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00096511840820312
(533) DESCRIBE `ships` 0.0056631565093994
(534) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00070309638977051
(535) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053787231445312
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060081481933594
(537) DESCRIBE `itineraries` 0.0028688907623291
(538) DESCRIBE `ports` 0.0033528804779053
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0007779598236084
(540) DESCRIBE `ports` 0.0029969215393066
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00072312355041504
(542) DESCRIBE `ports` 0.0029230117797852
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00072503089904785
(544) DESCRIBE `sailingdates` 0.0026218891143799
(545) DESCRIBE `ports` 0.0027849674224854
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00066590309143066
(547) DESCRIBE `ports` 0.0032331943511963
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00075006484985352
(549) DESCRIBE `ports` 0.0030989646911621
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00084805488586426
(551) DESCRIBE `ports` 0.0030598640441895
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00068283081054688
(553) DESCRIBE `ports` 0.0030331611633301
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00074887275695801
(555) DESCRIBE `ports` 0.002957820892334
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00076413154602051
(557) DESCRIBE `ports` 0.0029480457305908
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00079107284545898
(559) DESCRIBE `ports` 0.0031900405883789
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00071001052856445
(561) DESCRIBE `ports` 0.0031230449676514
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00080704689025879
(563) DESCRIBE `ports` 0.0031349658966064
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00072407722473145
(565) DESCRIBE `ports` 0.0031368732452393
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.0008392333984375
(567) DESCRIBE `ports` 0.0037329196929932
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.0013267993927002
(569) DESCRIBE `ports` 0.0043809413909912
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00073790550231934
(571) DESCRIBE `ports` 0.0069291591644287
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00072097778320312
(573) DESCRIBE `ports` 0.0030601024627686
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00079107284545898
(575) DESCRIBE `ports` 0.0031189918518066
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00065398216247559
(577) DESCRIBE `ports` 0.0030031204223633
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00067901611328125
(579) DESCRIBE `ports` 0.0023729801177979
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00060606002807617
(581) DESCRIBE `ports` 0.0022099018096924
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00063014030456543
(583) DESCRIBE `ports` 0.0023109912872314
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00069785118103027
(585) DESCRIBE `ports` 0.0031611919403076
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00074005126953125
(587) DESCRIBE `ports` 0.0028910636901855
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00063204765319824
(589) DESCRIBE `avid_specials` 0.0025811195373535
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61418 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.002255916595459
(591) DESCRIBE `cruiselines` 0.0042450428009033
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00095105171203613
(593) DESCRIBE `orchid_image` 0.0029311180114746
(594) DESCRIBE `cruiselines` 0.004072904586792
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00066900253295898
(596) DESCRIBE `cruises` 0.0048449039459229
(597) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72817') 0.00066304206848145
(598) DESCRIBE `ships` 0.00547194480896
(599) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00096297264099121
(600) DESCRIBE `ships` 0.0057220458984375
(601) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00075507164001465
(602) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052404403686523
(603) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060415267944336
(604) DESCRIBE `itineraries` 0.0028829574584961
(605) DESCRIBE `ports` 0.0031678676605225
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00072693824768066
(607) DESCRIBE `ports` 0.002910852432251
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0007171630859375
(609) DESCRIBE `ports` 0.0032539367675781
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00064587593078613
(611) DESCRIBE `sailingdates` 0.0026490688323975
(612) DESCRIBE `ports` 0.0028979778289795
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00067496299743652
(614) DESCRIBE `ports` 0.0025379657745361
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00056290626525879
(616) DESCRIBE `ports` 0.002312183380127
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00066685676574707
(618) DESCRIBE `ports` 0.0023159980773926
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00050687789916992
(620) DESCRIBE `ports` 0.0025379657745361
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00051712989807129
(622) DESCRIBE `ports` 0.0028250217437744
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.000640869140625
(624) DESCRIBE `ports` 0.0029089450836182
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00074601173400879
(626) DESCRIBE `ports` 0.0029079914093018
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00059199333190918
(628) DESCRIBE `ports` 0.0030310153961182
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00075316429138184
(630) DESCRIBE `ports` 0.0029809474945068
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00066804885864258
(632) DESCRIBE `ports` 0.0029339790344238
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00075602531433105
(634) DESCRIBE `ports` 0.0030009746551514
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0006251335144043
(636) DESCRIBE `ports` 0.0029771327972412
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00071191787719727
(638) DESCRIBE `ports` 0.0029950141906738
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00075101852416992
(640) DESCRIBE `ports` 0.0029160976409912
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.001183032989502
(642) DESCRIBE `ports` 0.0030548572540283
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00067782402038574
(644) DESCRIBE `ports` 0.0030801296234131
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00077486038208008
(646) DESCRIBE `ports` 0.0030159950256348
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00064921379089355
(648) DESCRIBE `avid_specials` 0.0026950836181641
(649) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72817 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021960735321045
(650) DESCRIBE `cruiselines` 0.0042018890380859
(651) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00080084800720215
(652) DESCRIBE `orchid_image` 0.0033600330352783
(653) DESCRIBE `cruiselines` 0.0043280124664307
(654) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00070405006408691
(655) DESCRIBE `cruises` 0.0063841342926025
(656) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76358') 0.00064301490783691
(657) DESCRIBE `ships` 0.0065100193023682
(658) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00089192390441895
(659) DESCRIBE `ships` 0.0054991245269775
(660) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00073981285095215
(661) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054502487182617
(662) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044107437133789
(663) DESCRIBE `itineraries` 0.0024161338806152
(664) DESCRIBE `ports` 0.010620832443237
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.0029299259185791
(666) DESCRIBE `ports` 0.00376296043396
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.0089130401611328
(668) DESCRIBE `ports` 0.00876784324646
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.0082061290740967
(670) DESCRIBE `sailingdates` 0.0021970272064209
(671) DESCRIBE `ports` 0.0094830989837646
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.0083770751953125
(673) DESCRIBE `ports` 0.0034348964691162
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.014188051223755
(675) DESCRIBE `ports` 0.003119945526123
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.0066571235656738
(677) DESCRIBE `ports` 0.0094108581542969
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.0045821666717529
(679) DESCRIBE `ports` 0.00301194190979
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.0074310302734375
(681) DESCRIBE `ports` 0.012917041778564
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.0053038597106934
(683) DESCRIBE `ports` 0.0022978782653809
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.012006044387817
(685) DESCRIBE `ports` 0.0036711692810059
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.012174129486084
(687) DESCRIBE `ports` 0.0060710906982422
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 689))) 0.0063490867614746
(689) DESCRIBE `ports` 0.0032939910888672
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '689') 0.010519981384277
(691) DESCRIBE `ports` 0.0030710697174072
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.015393972396851
(693) DESCRIBE `ports` 0.0028951168060303
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.00086593627929688
(695) DESCRIBE `ports` 0.0053780078887939
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.015588998794556
(697) DESCRIBE `ports` 0.0026919841766357
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.0011918544769287
(699) DESCRIBE `ports` 0.013247966766357
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.013507127761841
(701) DESCRIBE `ports` 0.0031089782714844
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.0072989463806152
(703) DESCRIBE `ports` 0.0032749176025391
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.015447854995728
(705) DESCRIBE `ports` 0.0066690444946289
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.0063049793243408
(707) DESCRIBE `ports` 0.0029749870300293
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0078928470611572
(709) DESCRIBE `ports` 0.0023741722106934
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0081648826599121
(711) DESCRIBE `ports` 0.005634069442749
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.0022881031036377
(713) DESCRIBE `ports` 0.0033340454101562
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.0066859722137451
(715) DESCRIBE `ports` 0.0075461864471436
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0018410682678223
(717) DESCRIBE `ports` 0.0025870800018311
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0039842128753662
(719) DESCRIBE `ports` 0.0049769878387451
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0059821605682373
(721) DESCRIBE `ports` 0.0034129619598389
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0056579113006592
(723) DESCRIBE `ports` 0.0026218891143799
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.005640983581543
(725) DESCRIBE `ports` 0.0031130313873291
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0078001022338867
(727) DESCRIBE `avid_specials` 0.002593994140625
(728) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76358 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0094499588012695
(729) DESCRIBE `cruiselines` 0.006580114364624
(730) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.018903017044067
(731) DESCRIBE `orchid_image` 0.0035250186920166
(732) DESCRIBE `cruiselines` 0.0058348178863525
(733) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.011008024215698
(734) DESCRIBE `ships` 0.017750978469849
(735) SELECT `ships`.* FROM `ships` WHERE (id IN ('966', '850', '1319', '1108', '508', '394')) ORDER BY FIND_IN_SET(id, '966,850,1319,1108,508,394') 0.0071971416473389
(736) DESCRIBE `cruisetypes` 0.0073349475860596
(737) DESCRIBE `destinations` 0.0089690685272217
(738) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '26', '2', '37', '38', '35', '43', '28', '21', '11', '49', '45', '48', '8', '10', '30', '52', '25', '34', '32')) ORDER BY FIND_IN_SET(id, '22,12,40,26,2,37,38,35,43,28,21,11,49,45,48,8,10,30,52,25,34,32') 0.010702133178711
(739) DESCRIBE `cruiselines` 0.0095770359039307
(740) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00097990036010742
(741) DESCRIBE `cruiselines` 0.016013145446777
(742) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00081300735473633