or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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: 938

Total elapsed time: 0.59306883811951

# Query Time
(1) connect 0.00095701217651367
(2) DESCRIBE `cruises` 0.002079963684082
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (61173, 70391, 70392, 64468, 64471, 66737, 62747, 58845, 64876, 34171)) ORDER BY FIND_IN_SET(id, '61173,70391,70392,64468,64471,66737,62747,58845,64876,34171') 0.001032829284668
(4) DESCRIBE `cruises` 0.0024621486663818
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61173') 0.00034785270690918
(6) DESCRIBE `ships` 0.0019829273223877
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 258))) 0.00028610229492188
(8) DESCRIBE `ships` 0.0014638900756836
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '258') 0.00027012825012207
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020503997802734
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019598007202148
(12) DESCRIBE `itineraries` 0.00098085403442383
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61173') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079798698425293
(14) DESCRIBE `ports` 0.0010349750518799
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029897689819336
(16) DESCRIBE `ports` 0.00075292587280273
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002439022064209
(18) DESCRIBE `ports` 0.00093197822570801
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002129077911377
(20) DESCRIBE `sailingdates` 0.00058603286743164
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61173') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058794021606445
(22) DESCRIBE `ports` 0.00078201293945312
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00022101402282715
(24) DESCRIBE `ports` 0.00065994262695312
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018191337585449
(26) DESCRIBE `ports` 0.00060701370239258
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019693374633789
(28) DESCRIBE `ports` 0.00062298774719238
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017189979553223
(30) DESCRIBE `ports` 0.00059199333190918
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00018715858459473
(32) DESCRIBE `ports` 0.00062298774719238
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0001680850982666
(34) DESCRIBE `ports` 0.00059199333190918
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00018501281738281
(36) DESCRIBE `ports` 0.00058889389038086
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0001680850982666
(38) DESCRIBE `ports` 0.0005800724029541
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00018501281738281
(40) DESCRIBE `ports` 0.00063920021057129
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00017023086547852
(42) DESCRIBE `ports` 0.00058197975158691
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00018596649169922
(44) DESCRIBE `ports` 0.00058603286743164
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00016307830810547
(46) DESCRIBE `ports` 0.00061392784118652
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00019598007202148
(48) DESCRIBE `ports` 0.00058507919311523
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00016593933105469
(50) DESCRIBE `ports` 0.00058293342590332
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00018095970153809
(52) DESCRIBE `ports` 0.00060796737670898
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00016498565673828
(54) DESCRIBE `ports` 0.00059294700622559
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020003318786621
(56) DESCRIBE `ports` 0.00058603286743164
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016403198242188
(58) DESCRIBE `ports` 0.00058102607727051
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00017714500427246
(60) DESCRIBE `ports` 0.00059795379638672
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00016999244689941
(62) DESCRIBE `ports` 0.00065183639526367
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00018906593322754
(64) DESCRIBE `ports` 0.00058197975158691
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00017309188842773
(66) DESCRIBE `ports` 0.00064301490783691
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018787384033203
(68) DESCRIBE `ports` 0.00060296058654785
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(70) DESCRIBE `ports` 0.00065898895263672
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00022506713867188
(72) DESCRIBE `ports` 0.00081610679626465
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00022983551025391
(74) DESCRIBE `ports` 0.00086593627929688
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 454))) 0.00026702880859375
(76) DESCRIBE `ports` 0.00092005729675293
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '454') 0.00024294853210449
(78) DESCRIBE `ports` 0.00065493583679199
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00027108192443848
(80) DESCRIBE `ports` 0.00084209442138672
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.0001828670501709
(82) DESCRIBE `ports` 0.00059318542480469
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00028610229492188
(84) DESCRIBE `ports` 0.0006101131439209
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00016117095947266
(86) DESCRIBE `ports` 0.00068807601928711
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00018310546875
(88) DESCRIBE `ports` 0.00058794021606445
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00016498565673828
(90) DESCRIBE `ports` 0.00061798095703125
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00021815299987793
(92) DESCRIBE `ports` 0.00061798095703125
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00020909309387207
(94) DESCRIBE `ports` 0.00075221061706543
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00018715858459473
(96) DESCRIBE `ports` 0.00060606002807617
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00016403198242188
(98) DESCRIBE `ports` 0.0006110668182373
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020194053649902
(100) DESCRIBE `ports` 0.00093197822570801
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017619132995605
(102) DESCRIBE `ports` 0.0006411075592041
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023412704467773
(104) DESCRIBE `ports` 0.0012390613555908
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0002901554107666
(106) DESCRIBE `avid_specials` 0.00083708763122559
(107) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61173 and class = 'Cruise') OR (item_id = 258 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 40 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.0016138553619385
(108) DESCRIBE `cruiselines` 0.0015139579772949
(109) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00048184394836426
(110) DESCRIBE `orchid_image` 0.001115083694458
(111) DESCRIBE `cruiselines` 0.0011818408966064
(112) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00027608871459961
(113) DESCRIBE `cruises` 0.0018799304962158
(114) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70391') 0.00040388107299805
(115) DESCRIBE `ships` 0.0018520355224609
(116) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 775))) 0.0069379806518555
(117) DESCRIBE `ships` 0.0020589828491211
(118) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '775') 0.00032806396484375
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018119812011719
(121) DESCRIBE `itineraries` 0.00093698501586914
(122) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70391') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008389949798584
(123) DESCRIBE `ports` 0.0098240375518799
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044918060302734
(125) DESCRIBE `ports` 0.0009911060333252
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025200843811035
(127) DESCRIBE `ports` 0.00082015991210938
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022482872009277
(129) DESCRIBE `sailingdates` 0.00072407722473145
(130) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70391') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061297416687012
(131) DESCRIBE `ports` 0.00093293190002441
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002739429473877
(133) DESCRIBE `ports` 0.00084090232849121
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024294853210449
(135) DESCRIBE `ports` 0.00090384483337402
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020503997802734
(137) DESCRIBE `ports` 0.00062704086303711
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00017714500427246
(139) DESCRIBE `ports` 0.00058889389038086
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00018882751464844
(141) DESCRIBE `ports` 0.00058698654174805
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017189979553223
(143) DESCRIBE `ports` 0.00062394142150879
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00019001960754395
(145) DESCRIBE `ports` 0.0006110668182373
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00018095970153809
(147) DESCRIBE `ports` 0.00058484077453613
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00018811225891113
(149) DESCRIBE `ports` 0.00064706802368164
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00023293495178223
(151) DESCRIBE `ports` 0.00065112113952637
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00018501281738281
(153) DESCRIBE `ports` 0.00065398216247559
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00017285346984863
(155) DESCRIBE `ports` 0.0006110668182373
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00022006034851074
(157) DESCRIBE `ports` 0.00082898139953613
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016903877258301
(159) DESCRIBE `ports` 0.0007789134979248
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025010108947754
(161) DESCRIBE `ports` 0.00063490867614746
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021791458129883
(163) DESCRIBE `ports` 0.00079011917114258
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00026106834411621
(165) DESCRIBE `ports` 0.00083303451538086
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018596649169922
(167) DESCRIBE `ports` 0.00082206726074219
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00029492378234863
(169) DESCRIBE `ports` 0.00094413757324219
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.0001981258392334
(171) DESCRIBE `ports` 0.00089216232299805
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00021195411682129
(173) DESCRIBE `ports` 0.00081515312194824
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00022411346435547
(175) DESCRIBE `ports` 0.00073003768920898
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00028181076049805
(177) DESCRIBE `ports` 0.00072002410888672
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.0001671314239502
(179) DESCRIBE `ports` 0.00086522102355957
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.0003199577331543
(181) DESCRIBE `ports` 0.00093913078308105
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00023198127746582
(183) DESCRIBE `ports` 0.0008389949798584
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00026607513427734
(185) DESCRIBE `ports` 0.00088596343994141
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00023579597473145
(187) DESCRIBE `ports` 0.00086593627929688
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00028705596923828
(189) DESCRIBE `ports` 0.00084710121154785
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00021910667419434
(191) DESCRIBE `ports` 0.00089502334594727
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00029993057250977
(193) DESCRIBE `ports` 0.001309871673584
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00020885467529297
(195) DESCRIBE `ports` 0.00067400932312012
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022196769714355
(197) DESCRIBE `ports` 0.00066995620727539
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023102760314941
(199) DESCRIBE `ports` 0.00061297416687012
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00021696090698242
(201) DESCRIBE `ports` 0.00080108642578125
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00023603439331055
(203) DESCRIBE `ports` 0.00069499015808105
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020408630371094
(205) DESCRIBE `ports` 0.0010240077972412
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00026297569274902
(207) DESCRIBE `ports` 0.00099396705627441
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00027799606323242
(209) DESCRIBE `ports` 0.00087213516235352
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00021100044250488
(211) DESCRIBE `ports` 0.00083088874816895
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025796890258789
(213) DESCRIBE `ports` 0.00084209442138672
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002291202545166
(215) DESCRIBE `ports` 0.00084805488586426
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022006034851074
(217) DESCRIBE `ports` 0.00067591667175293
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021910667419434
(219) DESCRIBE `avid_specials` 0.00057196617126465
(220) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70391 and class = 'Cruise') OR (item_id = 775 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 38 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.00092411041259766
(221) DESCRIBE `cruiselines` 0.00090503692626953
(222) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00024890899658203
(223) DESCRIBE `orchid_image` 0.00075507164001465
(224) DESCRIBE `cruiselines` 0.0010840892791748
(225) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00023412704467773
(226) DESCRIBE `cruises` 0.0017578601837158
(227) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70392') 0.0002589225769043
(228) DESCRIBE `ships` 0.0019869804382324
(229) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 775))) 0.00040292739868164
(230) DESCRIBE `ships` 0.0022909641265869
(231) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '775') 0.00041007995605469
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018811225891113
(234) DESCRIBE `itineraries` 0.00084495544433594
(235) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70392') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069093704223633
(236) DESCRIBE `ports` 0.0012519359588623
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032711029052734
(238) DESCRIBE `ports` 0.00081706047058105
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002901554107666
(240) DESCRIBE `ports` 0.0009610652923584
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021505355834961
(242) DESCRIBE `sailingdates` 0.00084590911865234
(243) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70392') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051403045654297
(244) DESCRIBE `ports` 0.001021146774292
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025486946105957
(246) DESCRIBE `ports` 0.00064706802368164
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00020384788513184
(248) DESCRIBE `ports` 0.0007171630859375
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020313262939453
(250) DESCRIBE `ports` 0.00062084197998047
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00019288063049316
(252) DESCRIBE `ports` 0.00065994262695312
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020313262939453
(254) DESCRIBE `ports` 0.00063705444335938
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00016903877258301
(256) DESCRIBE `ports` 0.00061392784118652
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00020408630371094
(258) DESCRIBE `ports` 0.00063920021057129
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0001828670501709
(260) DESCRIBE `ports` 0.00061678886413574
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00018692016601562
(262) DESCRIBE `ports` 0.0006561279296875
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00017213821411133
(264) DESCRIBE `ports` 0.00062894821166992
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00019502639770508
(266) DESCRIBE `ports` 0.00075793266296387
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00023698806762695
(268) DESCRIBE `ports` 0.00089883804321289
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00028109550476074
(270) DESCRIBE `ports` 0.00072097778320312
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018000602722168
(272) DESCRIBE `ports` 0.00059819221496582
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019097328186035
(274) DESCRIBE `ports` 0.00061202049255371
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017285346984863
(276) DESCRIBE `ports` 0.00066900253295898
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00019001960754395
(278) DESCRIBE `ports` 0.00059199333190918
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00023102760314941
(280) DESCRIBE `ports` 0.00059103965759277
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00019216537475586
(282) DESCRIBE `ports` 0.00060510635375977
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00016999244689941
(284) DESCRIBE `ports` 0.00058603286743164
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00018906593322754
(286) DESCRIBE `ports` 0.00062894821166992
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00016903877258301
(288) DESCRIBE `ports` 0.00065112113952637
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.0001828670501709
(290) DESCRIBE `ports` 0.00060296058654785
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.0001680850982666
(292) DESCRIBE `ports` 0.00081396102905273
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.0002140998840332
(294) DESCRIBE `ports` 0.00063395500183105
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00018596649169922
(296) DESCRIBE `ports` 0.0006558895111084
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00022602081298828
(298) DESCRIBE `ports` 0.0006411075592041
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.0001978874206543
(300) DESCRIBE `ports` 0.00069499015808105
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0001990795135498
(302) DESCRIBE `ports` 0.0006859302520752
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018095970153809
(304) DESCRIBE `ports` 0.0005950927734375
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00018906593322754
(306) DESCRIBE `ports` 0.00060200691223145
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0001680850982666
(308) DESCRIBE `ports` 0.00063896179199219
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00021886825561523
(310) DESCRIBE `ports` 0.00063610076904297
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0001838207244873
(312) DESCRIBE `ports` 0.00065302848815918
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00030803680419922
(314) DESCRIBE `ports` 0.00066018104553223
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00019097328186035
(316) DESCRIBE `avid_specials` 0.00055408477783203
(317) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70392 and class = 'Cruise') OR (item_id = 775 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 38 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.00088191032409668
(318) DESCRIBE `cruiselines` 0.00098299980163574
(319) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00023198127746582
(320) DESCRIBE `orchid_image` 0.0007169246673584
(321) DESCRIBE `cruiselines` 0.0014321804046631
(322) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00023317337036133
(323) DESCRIBE `cruises` 0.0017750263214111
(324) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64468') 0.00033187866210938
(325) DESCRIBE `ships` 0.001378059387207
(326) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1325))) 0.00035500526428223
(327) DESCRIBE `ships` 0.0016191005706787
(328) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1325') 0.00032401084899902
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00020217895507812
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0001530647277832
(331) DESCRIBE `itineraries` 0.00079798698425293
(332) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64468') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085091590881348
(333) DESCRIBE `ports` 0.000946044921875
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030899047851562
(335) DESCRIBE `ports` 0.0006718635559082
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018119812011719
(337) DESCRIBE `ports` 0.00060701370239258
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017619132995605
(339) DESCRIBE `sailingdates` 0.00054001808166504
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64468') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039505958557129
(341) DESCRIBE `ports` 0.00070405006408691
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(343) DESCRIBE `ports` 0.00064611434936523
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021505355834961
(345) DESCRIBE `ports` 0.000823974609375
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00025582313537598
(347) DESCRIBE `ports` 0.00094199180603027
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00025200843811035
(349) DESCRIBE `ports` 0.00093889236450195
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00027704238891602
(351) DESCRIBE `ports` 0.00096583366394043
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00026893615722656
(353) DESCRIBE `ports` 0.00094199180603027
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.0002129077911377
(355) DESCRIBE `ports` 0.00066804885864258
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00018095970153809
(357) DESCRIBE `ports` 0.00062298774719238
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00026106834411621
(359) DESCRIBE `ports` 0.00068020820617676
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00022697448730469
(361) DESCRIBE `ports` 0.00069093704223633
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00028204917907715
(363) DESCRIBE `ports` 0.00078082084655762
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00023102760314941
(365) DESCRIBE `ports` 0.00094819068908691
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00032496452331543
(367) DESCRIBE `ports` 0.0010049343109131
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0002439022064209
(369) DESCRIBE `ports` 0.00072884559631348
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00030899047851562
(371) DESCRIBE `ports` 0.00092482566833496
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00032305717468262
(373) DESCRIBE `ports` 0.0010879039764404
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00030207633972168
(375) DESCRIBE `ports` 0.0010318756103516
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00027012825012207
(377) DESCRIBE `ports` 0.00090217590332031
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00026202201843262
(379) DESCRIBE `ports` 0.00088810920715332
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.0002591609954834
(381) DESCRIBE `ports` 0.00089001655578613
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1048))) 0.0003209114074707
(383) DESCRIBE `ports` 0.0008540153503418
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1048') 0.00024986267089844
(385) DESCRIBE `ports` 0.00091791152954102
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00023007392883301
(387) DESCRIBE `ports` 0.00093197822570801
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0002448558807373
(389) DESCRIBE `ports` 0.00093603134155273
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00023698806762695
(391) DESCRIBE `ports` 0.0007479190826416
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00023293495178223
(393) DESCRIBE `ports` 0.00091981887817383
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00027894973754883
(395) DESCRIBE `ports` 0.00092506408691406
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00025391578674316
(397) DESCRIBE `ports` 0.00097107887268066
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4133))) 0.00030088424682617
(399) DESCRIBE `ports` 0.00082015991210938
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4133') 0.00022697448730469
(401) DESCRIBE `ports` 0.0007472038269043
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4083))) 0.00030899047851562
(403) DESCRIBE `ports` 0.00075221061706543
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4083') 0.00019311904907227
(405) DESCRIBE `ports` 0.00068807601928711
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1047))) 0.00021600723266602
(407) DESCRIBE `ports` 0.00065112113952637
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1047') 0.00022411346435547
(409) DESCRIBE `ports` 0.000762939453125
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00020790100097656
(411) DESCRIBE `ports` 0.00076198577880859
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00022602081298828
(413) DESCRIBE `ports` 0.0008549690246582
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028800964355469
(415) DESCRIBE `ports` 0.001007080078125
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022315979003906
(417) DESCRIBE `avid_specials` 0.00084590911865234
(418) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64468 and class = 'Cruise') OR (item_id = 1325 AND class = 'Ship') OR (item_id = 28 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.0017580986022949
(419) DESCRIBE `cruiselines` 0.0013558864593506
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00039291381835938
(421) DESCRIBE `orchid_image` 0.0010678768157959
(422) DESCRIBE `cruises` 0.002032995223999
(423) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64471') 0.00035405158996582
(424) DESCRIBE `ships` 0.0019900798797607
(425) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1325))) 0.00045108795166016
(426) DESCRIBE `ships` 0.0020499229431152
(427) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1325') 0.00043296813964844
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00022315979003906
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00020503997802734
(430) DESCRIBE `itineraries` 0.0010359287261963
(431) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64471') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058102607727051
(432) DESCRIBE `ports` 0.0011780261993408
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032520294189453
(434) DESCRIBE `ports` 0.00098490715026855
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002439022064209
(436) DESCRIBE `ports` 0.00095200538635254
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024318695068359
(438) DESCRIBE `sailingdates` 0.0008552074432373
(439) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64471') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049805641174316
(440) DESCRIBE `ports` 0.0011820793151855
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(442) DESCRIBE `ports` 0.00088810920715332
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022983551025391
(444) DESCRIBE `ports` 0.00084519386291504
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00025701522827148
(446) DESCRIBE `ports` 0.00082802772521973
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00018596649169922
(448) DESCRIBE `ports` 0.0006251335144043
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00025701522827148
(450) DESCRIBE `ports` 0.00061798095703125
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00018882751464844
(452) DESCRIBE `ports` 0.00083112716674805
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00023508071899414
(454) DESCRIBE `ports` 0.00093293190002441
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00022220611572266
(456) DESCRIBE `ports` 0.00089406967163086
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00028085708618164
(458) DESCRIBE `ports` 0.0009758472442627
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00028419494628906
(460) DESCRIBE `ports` 0.000885009765625
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00023293495178223
(462) DESCRIBE `ports` 0.00070905685424805
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00019097328186035
(464) DESCRIBE `ports` 0.00063490867614746
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00023603439331055
(466) DESCRIBE `ports` 0.00065493583679199
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00021791458129883
(468) DESCRIBE `ports` 0.00073695182800293
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0002291202545166
(470) DESCRIBE `ports` 0.00075483322143555
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00020003318786621
(472) DESCRIBE `ports` 0.00079798698425293
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00039196014404297
(474) DESCRIBE `ports` 0.00090789794921875
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00026702880859375
(476) DESCRIBE `ports` 0.00084304809570312
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00023102760314941
(478) DESCRIBE `ports` 0.00087499618530273
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00022792816162109
(480) DESCRIBE `ports` 0.0008699893951416
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1048))) 0.00026297569274902
(482) DESCRIBE `ports` 0.00085711479187012
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1048') 0.00022983551025391
(484) DESCRIBE `ports` 0.00095510482788086
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00025391578674316
(486) DESCRIBE `ports` 0.00072407722473145
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00019502639770508
(488) DESCRIBE `avid_specials` 0.00079798698425293
(489) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64471 and class = 'Cruise') OR (item_id = 1325 AND class = 'Ship') OR (item_id = 28 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.0010848045349121
(490) DESCRIBE `cruiselines` 0.00096392631530762
(491) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00028204917907715
(492) DESCRIBE `orchid_image` 0.00073504447937012
(493) DESCRIBE `cruises` 0.0014419555664062
(494) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66737') 0.00029206275939941
(495) DESCRIBE `ships` 0.0018520355224609
(496) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 618))) 0.00028705596923828
(497) DESCRIBE `ships` 0.0016021728515625
(498) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '618') 0.00031495094299316
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022387504577637
(500) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001828670501709
(501) DESCRIBE `itineraries` 0.0010209083557129
(502) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66737') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080609321594238
(503) DESCRIBE `ports` 0.0010068416595459
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00028705596923828
(505) DESCRIBE `ports` 0.00069093704223633
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020813941955566
(507) DESCRIBE `ports` 0.00067496299743652
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00017905235290527
(509) DESCRIBE `sailingdates` 0.0005490779876709
(510) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66737') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055718421936035
(511) DESCRIBE `ports` 0.00077509880065918
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00021815299987793
(513) DESCRIBE `ports` 0.00065803527832031
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018000602722168
(515) DESCRIBE `ports` 0.00081610679626465
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020098686218262
(517) DESCRIBE `ports` 0.00065302848815918
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018000602722168
(519) DESCRIBE `ports` 0.00071501731872559
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00024604797363281
(521) DESCRIBE `ports` 0.00093388557434082
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00022006034851074
(523) DESCRIBE `ports` 0.00087618827819824
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00026893615722656
(525) DESCRIBE `ports` 0.00094389915466309
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00023412704467773
(527) DESCRIBE `ports` 0.00065898895263672
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00020408630371094
(529) DESCRIBE `ports` 0.00066208839416504
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00017595291137695
(531) DESCRIBE `ports` 0.00060296058654785
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2373))) 0.00020384788513184
(533) DESCRIBE `ports` 0.00066494941711426
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2373') 0.00017285346984863
(535) DESCRIBE `ports` 0.00062298774719238
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00020003318786621
(537) DESCRIBE `ports` 0.00060391426086426
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00019717216491699
(539) DESCRIBE `ports` 0.00072598457336426
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00020408630371094
(541) DESCRIBE `ports` 0.00076794624328613
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00020313262939453
(543) DESCRIBE `ports` 0.00063109397888184
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002591609954834
(545) DESCRIBE `ports` 0.00072097778320312
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018095970153809
(547) DESCRIBE `ports` 0.0008389949798584
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00022411346435547
(549) DESCRIBE `ports` 0.000823974609375
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00021886825561523
(551) DESCRIBE `ports` 0.00071001052856445
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00024199485778809
(553) DESCRIBE `ports` 0.00068998336791992
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00018692016601562
(555) DESCRIBE `ports` 0.00065898895263672
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00020909309387207
(557) DESCRIBE `ports` 0.00069689750671387
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00021696090698242
(559) DESCRIBE `ports` 0.00088191032409668
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 883))) 0.00027608871459961
(561) DESCRIBE `ports` 0.00084304809570312
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '883') 0.00023913383483887
(563) DESCRIBE `ports` 0.00081110000610352
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 883))) 0.00026988983154297
(565) DESCRIBE `ports` 0.00086498260498047
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '883') 0.00023102760314941
(567) DESCRIBE `ports` 0.00095105171203613
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2899))) 0.00034785270690918
(569) DESCRIBE `ports` 0.0010700225830078
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2899') 0.0002739429473877
(571) DESCRIBE `ports` 0.00093197822570801
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00029182434082031
(573) DESCRIBE `ports` 0.00089097023010254
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00026106834411621
(575) DESCRIBE `ports` 0.00082993507385254
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00031900405883789
(577) DESCRIBE `ports` 0.00093793869018555
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.0003819465637207
(579) DESCRIBE `ports` 0.00085902214050293
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.0002601146697998
(581) DESCRIBE `ports` 0.00083804130554199
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00024294853210449
(583) DESCRIBE `ports` 0.00091886520385742
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00027298927307129
(585) DESCRIBE `ports` 0.0009009838104248
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00021600723266602
(587) DESCRIBE `avid_specials` 0.00066804885864258
(588) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66737 and class = 'Cruise') OR (item_id = 618 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 7 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.00093483924865723
(589) DESCRIBE `cruiselines` 0.00091886520385742
(590) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00022292137145996
(591) DESCRIBE `orchid_image` 0.00077509880065918
(592) DESCRIBE `cruiselines` 0.0013308525085449
(593) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00029206275939941
(594) DESCRIBE `cruises` 0.0016171932220459
(595) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62747') 0.00025701522827148
(596) DESCRIBE `ships` 0.0016250610351562
(597) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1299))) 0.00038790702819824
(598) DESCRIBE `ships` 0.0018038749694824
(599) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1299') 0.00030612945556641
(600) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020384788513184
(601) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018715858459473
(602) DESCRIBE `itineraries` 0.00093698501586914
(603) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62747') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078606605529785
(604) DESCRIBE `ports` 0.0010988712310791
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.0002892017364502
(606) DESCRIBE `ports` 0.00094890594482422
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00028300285339355
(608) DESCRIBE `ports` 0.0009160041809082
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00028109550476074
(610) DESCRIBE `sailingdates` 0.00084590911865234
(611) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62747') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005490779876709
(612) DESCRIBE `ports` 0.0010280609130859
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00032782554626465
(614) DESCRIBE `ports` 0.00084805488586426
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00026082992553711
(616) DESCRIBE `ports` 0.00077104568481445
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00021815299987793
(618) DESCRIBE `ports` 0.00069189071655273
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.0001828670501709
(620) DESCRIBE `ports` 0.00066614151000977
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4825))) 0.00021696090698242
(622) DESCRIBE `ports` 0.00068807601928711
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4825') 0.0001988410949707
(624) DESCRIBE `ports` 0.00066304206848145
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4823))) 0.00019288063049316
(626) DESCRIBE `ports` 0.000640869140625
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4823') 0.0002448558807373
(628) DESCRIBE `ports` 0.00069022178649902
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.00022196769714355
(630) DESCRIBE `ports` 0.00064396858215332
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00023007392883301
(632) DESCRIBE `ports` 0.00086593627929688
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3516))) 0.00020003318786621
(634) DESCRIBE `ports` 0.00061416625976562
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3516') 0.00016689300537109
(636) DESCRIBE `ports` 0.00067806243896484
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3159))) 0.00023603439331055
(638) DESCRIBE `ports` 0.00089001655578613
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3159') 0.00022315979003906
(640) DESCRIBE `ports` 0.00071883201599121
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3160))) 0.00025606155395508
(642) DESCRIBE `ports` 0.0008549690246582
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3160') 0.00024199485778809
(644) DESCRIBE `ports` 0.0010550022125244
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00021195411682129
(646) DESCRIBE `ports` 0.00070405006408691
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00023317337036133
(648) DESCRIBE `ports` 0.0006868839263916
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00028896331787109
(650) DESCRIBE `ports` 0.00065493583679199
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00028300285339355
(652) DESCRIBE `ports` 0.00087809562683105
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00026917457580566
(654) DESCRIBE `ports` 0.00084495544433594
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00027608871459961
(656) DESCRIBE `ports` 0.00086808204650879
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00025391578674316
(658) DESCRIBE `ports` 0.00088000297546387
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00022697448730469
(660) DESCRIBE `ports` 0.0009009838104248
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4824))) 0.00025391578674316
(662) DESCRIBE `ports` 0.00092101097106934
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4824') 0.00019598007202148
(664) DESCRIBE `ports` 0.00068211555480957
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00020909309387207
(666) DESCRIBE `ports` 0.00080609321594238
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00018310546875
(668) DESCRIBE `ports` 0.0006561279296875
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00020718574523926
(670) DESCRIBE `ports` 0.00071001052856445
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00021505355834961
(672) DESCRIBE `ports` 0.00088214874267578
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00025415420532227
(674) DESCRIBE `ports` 0.00079607963562012
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00020480155944824
(676) DESCRIBE `ports` 0.00090217590332031
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00032687187194824
(678) DESCRIBE `ports` 0.00092506408691406
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00025200843811035
(680) DESCRIBE `avid_specials` 0.00078105926513672
(681) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62747 and class = 'Cruise') OR (item_id = 1299 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine') OR (item_id = 54 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.0015490055084229
(682) DESCRIBE `cruiselines` 0.0013320446014404
(683) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00031018257141113
(684) DESCRIBE `orchid_image` 0.00099897384643555
(685) DESCRIBE `cruiselines` 0.0014550685882568
(686) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00037717819213867
(687) DESCRIBE `cruises` 0.0020279884338379
(688) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58845') 0.00034999847412109
(689) DESCRIBE `ships` 0.0018589496612549
(690) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00036811828613281
(691) DESCRIBE `ships` 0.0018861293792725
(692) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00034999847412109
(693) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020599365234375
(694) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019598007202148
(695) DESCRIBE `itineraries` 0.00096797943115234
(696) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58845') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007328987121582
(697) DESCRIBE `ports` 0.0011110305786133
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029683113098145
(699) DESCRIBE `ports` 0.00084590911865234
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.000244140625
(701) DESCRIBE `ports` 0.00084495544433594
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00022387504577637
(703) DESCRIBE `sailingdates` 0.00076198577880859
(704) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58845') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058698654174805
(705) DESCRIBE `ports` 0.00099611282348633
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027298927307129
(707) DESCRIBE `ports` 0.00086402893066406
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002291202545166
(709) DESCRIBE `ports` 0.00087499618530273
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00025701522827148
(711) DESCRIBE `ports` 0.00087785720825195
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00023698806762695
(713) DESCRIBE `ports` 0.00086808204650879
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2226))) 0.00025415420532227
(715) DESCRIBE `ports` 0.00088810920715332
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2226') 0.00023317337036133
(717) DESCRIBE `ports` 0.00086116790771484
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00028681755065918
(719) DESCRIBE `ports` 0.00086498260498047
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00021815299987793
(721) DESCRIBE `ports` 0.00084590911865234
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00023913383483887
(723) DESCRIBE `ports` 0.0008699893951416
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00021910667419434
(725) DESCRIBE `ports` 0.0008389949798584
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00025200843811035
(727) DESCRIBE `ports` 0.00086188316345215
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0002291202545166
(729) DESCRIBE `ports` 0.00084781646728516
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00025606155395508
(731) DESCRIBE `ports` 0.00084590911865234
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0002138614654541
(733) DESCRIBE `ports` 0.00079989433288574
(734) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00024890899658203
(735) DESCRIBE `ports` 0.00081920623779297
(736) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00021982192993164
(737) DESCRIBE `ports` 0.00082898139953613
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0002589225769043
(739) DESCRIBE `ports` 0.00083184242248535
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00022292137145996
(741) DESCRIBE `ports` 0.00081396102905273
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00025081634521484
(743) DESCRIBE `ports` 0.0008389949798584
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026297569274902
(745) DESCRIBE `ports` 0.0009608268737793
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030899047851562
(747) DESCRIBE `ports` 0.00095105171203613
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00024700164794922
(749) DESCRIBE `ports` 0.00081491470336914
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026392936706543
(751) DESCRIBE `ports` 0.00082683563232422
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020790100097656
(753) DESCRIBE `ports` 0.0007779598236084
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003809928894043
(755) DESCRIBE `ports` 0.00088596343994141
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(757) DESCRIBE `avid_specials` 0.00073599815368652
(758) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58845 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 43 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.0016720294952393
(759) DESCRIBE `cruiselines` 0.0014162063598633
(760) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00048089027404785
(761) DESCRIBE `orchid_image` 0.0015349388122559
(762) DESCRIBE `cruiselines` 0.0014309883117676
(763) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00029993057250977
(764) DESCRIBE `cruises` 0.002310037612915
(765) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64876') 0.00037980079650879
(766) DESCRIBE `ships` 0.0021882057189941
(767) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00045585632324219
(768) DESCRIBE `ships` 0.0021638870239258
(769) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.00035810470581055
(770) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022697448730469
(771) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021100044250488
(772) DESCRIBE `itineraries` 0.0010828971862793
(773) DESCRIBE `ports` 0.0012381076812744
(774) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033688545227051
(775) DESCRIBE `ports` 0.00098896026611328
(776) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00027108192443848
(777) DESCRIBE `ports` 0.00094413757324219
(778) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028109550476074
(779) DESCRIBE `sailingdates` 0.00094509124755859
(780) DESCRIBE `ports` 0.001230001449585
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003058910369873
(782) DESCRIBE `ports` 0.00065803527832031
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017714500427246
(784) DESCRIBE `ports` 0.00060606002807617
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00025105476379395
(786) DESCRIBE `ports` 0.00070500373840332
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023508071899414
(788) DESCRIBE `ports` 0.0009148120880127
(789) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021100044250488
(790) DESCRIBE `ports` 0.00090312957763672
(791) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026106834411621
(792) DESCRIBE `ports` 0.00093603134155273
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00027108192443848
(794) DESCRIBE `ports` 0.0009758472442627
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00025200843811035
(796) DESCRIBE `ports` 0.00087594985961914
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00026917457580566
(798) DESCRIBE `ports` 0.00096797943115234
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00023698806762695
(800) DESCRIBE `ports` 0.0008549690246582
(801) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00025796890258789
(802) DESCRIBE `ports` 0.00087213516235352
(803) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00024795532226562
(804) DESCRIBE `ports` 0.00089001655578613
(805) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00026106834411621
(806) DESCRIBE `ports` 0.00092315673828125
(807) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00023317337036133
(808) DESCRIBE `ports` 0.0008540153503418
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025796890258789
(810) DESCRIBE `ports` 0.00086498260498047
(811) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022101402282715
(812) DESCRIBE `ports` 0.00085902214050293
(813) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00026512145996094
(814) DESCRIBE `ports` 0.00088596343994141
(815) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023603439331055
(816) DESCRIBE `avid_specials` 0.00084209442138672
(817) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64876 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0015628337860107
(818) DESCRIBE `cruiselines` 0.0013868808746338
(819) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031304359436035
(820) DESCRIBE `orchid_image` 0.0010390281677246
(821) DESCRIBE `cruiselines` 0.0013048648834229
(822) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00026392936706543
(823) DESCRIBE `cruises` 0.0018219947814941
(824) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34171') 0.0003058910369873
(825) DESCRIBE `ships` 0.0018658638000488
(826) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 39))) 0.00033807754516602
(827) DESCRIBE `ships` 0.0019998550415039
(828) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '39') 0.00028705596923828
(829) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020599365234375
(830) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019598007202148
(831) DESCRIBE `itineraries` 0.0009920597076416
(832) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34171') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083088874816895
(833) DESCRIBE `ports` 0.0011720657348633
(834) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00029897689819336
(835) DESCRIBE `ports` 0.00087785720825195
(836) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00024509429931641
(837) DESCRIBE `ports` 0.00087308883666992
(838) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00023198127746582
(839) DESCRIBE `sailingdates` 0.00078392028808594
(840) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34171') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095009803771973
(841) DESCRIBE `ports` 0.0012152194976807
(842) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00030303001403809
(843) DESCRIBE `ports` 0.00085687637329102
(844) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00022387504577637
(845) DESCRIBE `ports` 0.00084900856018066
(846) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00025391578674316
(847) DESCRIBE `ports` 0.00084805488586426
(848) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00021791458129883
(849) DESCRIBE `ports` 0.00084400177001953
(850) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00025582313537598
(851) DESCRIBE `ports` 0.00086092948913574
(852) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00025010108947754
(853) DESCRIBE `ports` 0.00084781646728516
(854) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.0002448558807373
(855) DESCRIBE `ports` 0.00085902214050293
(856) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00024199485778809
(857) DESCRIBE `ports` 0.00084209442138672
(858) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.0002439022064209
(859) DESCRIBE `ports` 0.00085115432739258
(860) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00023198127746582
(861) DESCRIBE `ports` 0.00085186958312988
(862) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00024199485778809
(863) DESCRIBE `ports` 0.0008549690246582
(864) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00021719932556152
(865) DESCRIBE `ports` 0.00084209442138672
(866) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00024700164794922
(867) DESCRIBE `ports` 0.00086688995361328
(868) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00021505355834961
(869) DESCRIBE `ports` 0.00084209442138672
(870) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00025081634521484
(871) DESCRIBE `ports` 0.00066184997558594
(872) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00017285346984863
(873) DESCRIBE `ports` 0.00059294700622559
(874) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00019407272338867
(875) DESCRIBE `ports` 0.00060319900512695
(876) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00016903877258301
(877) DESCRIBE `ports` 0.00058984756469727
(878) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00018310546875
(879) DESCRIBE `ports` 0.0005958080291748
(880) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00019001960754395
(881) DESCRIBE `ports` 0.00065302848815918
(882) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00018787384033203
(883) DESCRIBE `ports` 0.00065493583679199
(884) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00017094612121582
(885) DESCRIBE `ports` 0.00066304206848145
(886) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020790100097656
(887) DESCRIBE `ports` 0.00076389312744141
(888) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00017499923706055
(889) DESCRIBE `ports` 0.00062990188598633
(890) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00023984909057617
(891) DESCRIBE `ports` 0.00075697898864746
(892) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00017213821411133
(893) DESCRIBE `ports` 0.00061511993408203
(894) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00020313262939453
(895) DESCRIBE `ports` 0.00062203407287598
(896) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00016498565673828
(897) DESCRIBE `ports` 0.00063514709472656
(898) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00018692016601562
(899) DESCRIBE `ports` 0.00060009956359863
(900) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00016403198242188
(901) DESCRIBE `ports` 0.00058507919311523
(902) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00018501281738281
(903) DESCRIBE `ports` 0.00063204765319824
(904) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00017189979553223
(905) DESCRIBE `ports` 0.00062179565429688
(906) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00018501281738281
(907) DESCRIBE `ports` 0.00063395500183105
(908) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00017690658569336
(909) DESCRIBE `ports` 0.00068283081054688
(910) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00023198127746582
(911) DESCRIBE `ports` 0.00059890747070312
(912) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00016593933105469
(913) DESCRIBE `ports` 0.00066399574279785
(914) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00021982192993164
(915) DESCRIBE `ports` 0.00063705444335938
(916) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00020694732666016
(917) DESCRIBE `ports` 0.00063085556030273
(918) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00022006034851074
(919) DESCRIBE `ports` 0.0007021427154541
(920) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00048708915710449
(921) DESCRIBE `ports` 0.0011041164398193
(922) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00028204917907715
(923) DESCRIBE `ports` 0.00090694427490234
(924) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00024294853210449
(925) DESCRIBE `avid_specials` 0.00082898139953613
(926) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34171 and class = 'Cruise') OR (item_id = 39 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.001446008682251
(927) DESCRIBE `cruiselines` 0.0012950897216797
(928) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00030708312988281
(929) DESCRIBE `orchid_image` 0.00096011161804199
(930) DESCRIBE `cruiselines` 0.0013139247894287
(931) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00026702880859375
(932) DESCRIBE `cruiselines` 0.0012359619140625
(933) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '120', '101', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '225', '229', '140', '170', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '177', '224', '245', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,120,101,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,225,229,140,170,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,177,224,245,257,210,223,263,251') 0.0035398006439209
(934) DESCRIBE `ships` 0.0024940967559814
(935) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '974', '10', '349', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '520', '817', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '30', '31', '37', '573', '1285', '1586', '36', '38', '39', '378', '434', '590', '792', '34', '35', '1012', '1376', '327', '526', '970', '43', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1176', '1292', '1382', '1405', '338', '716', '1088', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '610', '852', '966', '1095', '1284', '59', '93', '403', '451', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '9', '75', '616', '666', '784', '1150', '1301', '1501', '503', '996', '1587', '81', '455', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1241', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1087', '1172', '1454', '335', '938', '994', '66', '70', '341', '790', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1262', '1439', '715', '973', '1023', '1043', '1144', '1481', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1543', '1594', '448', '717', '1090', '1110', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '858', '915', '916', '926', '1001', '1072', '1082', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,974,10,349,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,520,817,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,30,31,37,573,1285,1586,36,38,39,378,434,590,792,34,35,1012,1376,327,526,970,43,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1176,1292,1382,1405,338,716,1088,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,610,852,966,1095,1284,59,93,403,451,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,9,75,616,666,784,1150,1301,1501,503,996,1587,81,455,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1241,1366,1372,1411,1571,108,313,776,1141,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,823,883,1253,74,98,147,394,937,1579,1087,1172,1454,335,938,994,66,70,341,790,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1262,1439,715,973,1023,1043,1144,1481,1545,494,673,1136,1137,1240,1282,1303,1437,1543,1594,448,717,1090,1110,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,858,915,916,926,1001,1072,1082,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811') 0.025315999984741
(936) DESCRIBE `cruisetypes` 0.0011610984802246
(937) DESCRIBE `destinations` 0.0013430118560791
(938) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.001276969909668