or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Total elapsed time: 0.50010395050049

# Query Time
(1) connect 0.00072693824768066
(2) DESCRIBE `cruises` 0.001741886138916
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68568, 68929, 34164, 67703, 73712, 59134, 60710, 62516, 64063, 65451)) ORDER BY FIND_IN_SET(id, '68568,68929,34164,67703,73712,59134,60710,62516,64063,65451') 0.0010659694671631
(4) DESCRIBE `cruises` 0.0012969970703125
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68568') 0.00020599365234375
(6) DESCRIBE `ships` 0.0012750625610352
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 285))) 0.00028109550476074
(8) DESCRIBE `ships` 0.0012490749359131
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '285') 0.00019192695617676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017619132995605
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(12) DESCRIBE `itineraries` 0.0006561279296875
(13) DESCRIBE `ports` 0.00070095062255859
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020599365234375
(15) DESCRIBE `ports` 0.00074195861816406
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00019311904907227
(17) DESCRIBE `ports` 0.00070309638977051
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017690658569336
(19) DESCRIBE `sailingdates` 0.0005950927734375
(20) DESCRIBE `ports` 0.00068402290344238
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020003318786621
(22) DESCRIBE `ports` 0.00065493583679199
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00020909309387207
(24) DESCRIBE `ports` 0.00066494941711426
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2157))) 0.00020289421081543
(26) DESCRIBE `ports` 0.0006561279296875
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2157') 0.00025105476379395
(28) DESCRIBE `ports` 0.00067281723022461
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0001990795135498
(30) DESCRIBE `ports` 0.00065398216247559
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00017786026000977
(32) DESCRIBE `ports` 0.00065493583679199
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0001978874206543
(34) DESCRIBE `ports` 0.00065517425537109
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0001828670501709
(36) DESCRIBE `ports` 0.0006561279296875
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00018906593322754
(38) DESCRIBE `ports` 0.00065493583679199
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017404556274414
(40) DESCRIBE `ports` 0.00065779685974121
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00022196769714355
(42) DESCRIBE `ports` 0.00065493583679199
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00018405914306641
(44) DESCRIBE `ports` 0.0006711483001709
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00018596649169922
(46) DESCRIBE `ports` 0.00065088272094727
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00017094612121582
(48) DESCRIBE `ports` 0.00071310997009277
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00019598007202148
(50) DESCRIBE `ports` 0.00068783760070801
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018787384033203
(52) DESCRIBE `ports` 0.00065398216247559
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00023293495178223
(54) DESCRIBE `ports` 0.00069403648376465
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017094612121582
(56) DESCRIBE `avid_specials` 0.00060200691223145
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68568 and class = 'Cruise') OR (item_id = 285 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 26 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.00095009803771973
(58) DESCRIBE `cruiselines` 0.00095415115356445
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00020694732666016
(60) DESCRIBE `orchid_image` 0.00076484680175781
(61) DESCRIBE `cruiselines` 0.00091004371643066
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00022196769714355
(63) DESCRIBE `cruises` 0.0012621879577637
(64) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68929') 0.00018501281738281
(65) DESCRIBE `ships` 0.001291036605835
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 711))) 0.00022792816162109
(67) DESCRIBE `ships` 0.0012738704681396
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '711') 0.00017309188842773
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00019097328186035
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00016212463378906
(71) DESCRIBE `itineraries` 0.00064206123352051
(72) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68929') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013000965118408
(73) DESCRIBE `ports` 0.0011708736419678
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00029897689819336
(75) DESCRIBE `ports` 0.00083589553833008
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0002589225769043
(77) DESCRIBE `ports` 0.00074887275695801
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00021100044250488
(79) DESCRIBE `sailingdates` 0.00065398216247559
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68929') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062298774719238
(81) DESCRIBE `ports` 0.0007328987121582
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020384788513184
(83) DESCRIBE `ports` 0.00066208839416504
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017905235290527
(85) DESCRIBE `ports` 0.00072312355041504
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3294))) 0.00022602081298828
(87) DESCRIBE `ports` 0.00089287757873535
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3294') 0.00023007392883301
(89) DESCRIBE `ports` 0.00066685676574707
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 661))) 0.00019598007202148
(91) DESCRIBE `ports` 0.00067996978759766
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '661') 0.00020384788513184
(93) DESCRIBE `ports` 0.00066208839416504
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019407272338867
(95) DESCRIBE `ports` 0.00072813034057617
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023198127746582
(97) DESCRIBE `ports` 0.0006859302520752
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 922))) 0.00022602081298828
(99) DESCRIBE `ports` 0.00092101097106934
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '922') 0.00023603439331055
(101) DESCRIBE `ports` 0.00089097023010254
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2487))) 0.00026297569274902
(103) DESCRIBE `ports` 0.00090599060058594
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2487') 0.00021791458129883
(105) DESCRIBE `ports` 0.0009300708770752
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00023603439331055
(107) DESCRIBE `ports` 0.00066900253295898
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0001828670501709
(109) DESCRIBE `ports` 0.00070905685424805
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00021004676818848
(111) DESCRIBE `ports` 0.00085592269897461
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00023508071899414
(113) DESCRIBE `ports` 0.00069999694824219
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019598007202148
(115) DESCRIBE `ports` 0.00066494941711426
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00021600723266602
(117) DESCRIBE `ports` 0.00087594985961914
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00023603439331055
(119) DESCRIBE `ports` 0.00070595741271973
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00017309188842773
(121) DESCRIBE `ports` 0.00084090232849121
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2799))) 0.00020098686218262
(123) DESCRIBE `ports` 0.00069403648376465
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2799') 0.00019001960754395
(125) DESCRIBE `ports` 0.00070691108703613
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020289421081543
(127) DESCRIBE `ports` 0.00066685676574707
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001990795135498
(129) DESCRIBE `avid_specials` 0.00075793266296387
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68929 and class = 'Cruise') OR (item_id = 711 AND class = 'Ship') OR (item_id = 28 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.0013229846954346
(131) DESCRIBE `cruiselines` 0.0013458728790283
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00029993057250977
(133) DESCRIBE `orchid_image` 0.0010368824005127
(134) DESCRIBE `cruises` 0.0024230480194092
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34164') 0.00035190582275391
(136) DESCRIBE `ships` 0.0019688606262207
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 35))) 0.0003960132598877
(138) DESCRIBE `ships` 0.0019369125366211
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '35') 0.00025796890258789
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023794174194336
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021100044250488
(142) DESCRIBE `itineraries` 0.00099802017211914
(143) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34164') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086784362792969
(144) DESCRIBE `ports` 0.0012800693511963
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00032901763916016
(146) DESCRIBE `ports` 0.0010080337524414
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00026297569274902
(148) DESCRIBE `ports` 0.00094795227050781
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0002739429473877
(150) DESCRIBE `sailingdates` 0.00086188316345215
(151) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34164') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073790550231934
(152) DESCRIBE `ports` 0.001317024230957
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00034093856811523
(154) DESCRIBE `ports` 0.0010349750518799
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00027608871459961
(156) DESCRIBE `ports` 0.00098490715026855
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00029301643371582
(158) DESCRIBE `ports` 0.00099802017211914
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00025200843811035
(160) DESCRIBE `ports` 0.0009608268737793
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00027799606323242
(162) DESCRIBE `ports` 0.0010180473327637
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00027990341186523
(164) DESCRIBE `ports` 0.00095200538635254
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00028610229492188
(166) DESCRIBE `ports` 0.00093889236450195
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00024199485778809
(168) DESCRIBE `ports` 0.00094509124755859
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00026798248291016
(170) DESCRIBE `ports` 0.00097107887268066
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00024294853210449
(172) DESCRIBE `ports` 0.00098800659179688
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00026583671569824
(174) DESCRIBE `ports` 0.00096297264099121
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00023818016052246
(176) DESCRIBE `ports` 0.00099802017211914
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00026106834411621
(178) DESCRIBE `ports` 0.00096487998962402
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00024318695068359
(180) DESCRIBE `ports` 0.00097799301147461
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00029110908508301
(182) DESCRIBE `ports` 0.00094699859619141
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00026798248291016
(184) DESCRIBE `ports` 0.00093293190002441
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00026297569274902
(186) DESCRIBE `ports` 0.00093603134155273
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00023484230041504
(188) DESCRIBE `ports` 0.0009610652923584
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00026512145996094
(190) DESCRIBE `ports` 0.0010049343109131
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00024294853210449
(192) DESCRIBE `ports` 0.00095081329345703
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00026392936706543
(194) DESCRIBE `ports` 0.0009770393371582
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00023508071899414
(196) DESCRIBE `ports` 0.00096416473388672
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00026297569274902
(198) DESCRIBE `ports` 0.00099277496337891
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00024294853210449
(200) DESCRIBE `ports` 0.00095510482788086
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00026798248291016
(202) DESCRIBE `ports` 0.00095605850219727
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00023484230041504
(204) DESCRIBE `ports` 0.00095391273498535
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00026488304138184
(206) DESCRIBE `ports` 0.00095701217651367
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00023698806762695
(208) DESCRIBE `ports` 0.00094699859619141
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00026416778564453
(210) DESCRIBE `ports` 0.0010418891906738
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00026106834411621
(212) DESCRIBE `ports` 0.00099897384643555
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00027799606323242
(214) DESCRIBE `ports` 0.00097107887268066
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00024700164794922
(216) DESCRIBE `ports` 0.00098991394042969
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.0002748966217041
(218) DESCRIBE `ports` 0.00097203254699707
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00026988983154297
(220) DESCRIBE `ports` 0.00094199180603027
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00026297569274902
(222) DESCRIBE `ports` 0.00093817710876465
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00023603439331055
(224) DESCRIBE `ports` 0.00094103813171387
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00026297569274902
(226) DESCRIBE `ports` 0.00095796585083008
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00024700164794922
(228) DESCRIBE `ports` 0.00092506408691406
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.0002739429473877
(230) DESCRIBE `ports` 0.0009610652923584
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.000244140625
(232) DESCRIBE `ports` 0.00094199180603027
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00027203559875488
(234) DESCRIBE `ports` 0.00097990036010742
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00024199485778809
(236) DESCRIBE `avid_specials` 0.00084900856018066
(237) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34164 and class = 'Cruise') OR (item_id = 35 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.0016269683837891
(238) DESCRIBE `cruiselines` 0.001446008682251
(239) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00033283233642578
(240) DESCRIBE `orchid_image` 0.0010850429534912
(241) DESCRIBE `cruiselines` 0.0013980865478516
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00027918815612793
(243) DESCRIBE `cruises` 0.0018899440765381
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67703') 0.00031709671020508
(245) DESCRIBE `ships` 0.0019350051879883
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 973))) 0.00028085708618164
(247) DESCRIBE `ships` 0.0014779567718506
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '973') 0.00024700164794922
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018811225891113
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022196769714355
(251) DESCRIBE `itineraries` 0.0008399486541748
(252) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67703') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065398216247559
(253) DESCRIBE `ports` 0.00092291831970215
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00026297569274902
(255) DESCRIBE `ports` 0.00072407722473145
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00021505355834961
(257) DESCRIBE `ports` 0.00076103210449219
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00020003318786621
(259) DESCRIBE `sailingdates` 0.00062108039855957
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67703') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055193901062012
(261) DESCRIBE `ports` 0.0007779598236084
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00022792816162109
(263) DESCRIBE `ports` 0.00069212913513184
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00019097328186035
(265) DESCRIBE `ports` 0.00067400932312012
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020503997802734
(267) DESCRIBE `ports` 0.00067901611328125
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00019192695617676
(269) DESCRIBE `ports` 0.00067400932312012
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2964))) 0.0002448558807373
(271) DESCRIBE `ports` 0.00069189071655273
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2964') 0.00018596649169922
(273) DESCRIBE `ports` 0.0006721019744873
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00020503997802734
(275) DESCRIBE `ports` 0.00073599815368652
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00019288063049316
(277) DESCRIBE `ports` 0.00067305564880371
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1596))) 0.00020098686218262
(279) DESCRIBE `ports` 0.00072717666625977
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1596') 0.00019001960754395
(281) DESCRIBE `ports` 0.00084900856018066
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00020909309387207
(283) DESCRIBE `ports` 0.00067400932312012
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018692016601562
(285) DESCRIBE `ports` 0.0006711483001709
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00024986267089844
(287) DESCRIBE `ports` 0.00072312355041504
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00018596649169922
(289) DESCRIBE `ports` 0.00069999694824219
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.0002140998840332
(291) DESCRIBE `ports` 0.00067305564880371
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00018501281738281
(293) DESCRIBE `ports` 0.0007481575012207
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020384788513184
(295) DESCRIBE `ports` 0.00069999694824219
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00018811225891113
(297) DESCRIBE `ports` 0.00071096420288086
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00023818016052246
(299) DESCRIBE `ports` 0.00075316429138184
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018596649169922
(301) DESCRIBE `ports` 0.00097107887268066
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00021696090698242
(303) DESCRIBE `ports` 0.00068092346191406
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00018692016601562
(305) DESCRIBE `ports` 0.00071406364440918
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020384788513184
(307) DESCRIBE `ports` 0.00071287155151367
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00019001960754395
(309) DESCRIBE `ports` 0.00068211555480957
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020217895507812
(311) DESCRIBE `ports` 0.00095200538635254
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00018787384033203
(313) DESCRIBE `avid_specials` 0.00060892105102539
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67703 and class = 'Cruise') OR (item_id = 973 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 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.00097179412841797
(315) DESCRIBE `cruiselines` 0.0011711120605469
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00027799606323242
(317) DESCRIBE `orchid_image` 0.00086116790771484
(318) DESCRIBE `cruiselines` 0.0010180473327637
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00020194053649902
(320) DESCRIBE `cruises` 0.0013179779052734
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73712') 0.00023484230041504
(322) DESCRIBE `ships` 0.0013010501861572
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 968))) 0.0002748966217041
(324) DESCRIBE `ships` 0.0012860298156738
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '968') 0.00026106834411621
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024199485778809
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022006034851074
(328) DESCRIBE `itineraries` 0.000885009765625
(329) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73712') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013740062713623
(330) DESCRIBE `ports` 0.0012669563293457
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024604797363281
(332) DESCRIBE `ports` 0.00071382522583008
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(334) DESCRIBE `ports` 0.00071406364440918
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020718574523926
(336) DESCRIBE `sailingdates` 0.0006260871887207
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73712') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062179565429688
(338) DESCRIBE `ports` 0.00073480606079102
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002131462097168
(340) DESCRIBE `ports` 0.00075697898864746
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001978874206543
(342) DESCRIBE `ports` 0.00072503089904785
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00021004676818848
(344) DESCRIBE `ports` 0.0006859302520752
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00019192695617676
(346) DESCRIBE `ports` 0.00073409080505371
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 583))) 0.00022602081298828
(348) DESCRIBE `ports` 0.00073504447937012
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '583') 0.00021886825561523
(350) DESCRIBE `ports` 0.0007321834564209
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002140998840332
(352) DESCRIBE `ports` 0.00071287155151367
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001981258392334
(354) DESCRIBE `ports` 0.00070381164550781
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024795532226562
(356) DESCRIBE `ports` 0.00086092948913574
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018715858459473
(358) DESCRIBE `ports` 0.00067281723022461
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00020503997802734
(360) DESCRIBE `ports` 0.00067400932312012
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00019216537475586
(362) DESCRIBE `ports` 0.00069594383239746
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.000244140625
(364) DESCRIBE `ports` 0.00078701972961426
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00022792816162109
(366) DESCRIBE `ports` 0.0010759830474854
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00028204917907715
(368) DESCRIBE `ports` 0.00096702575683594
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00023388862609863
(370) DESCRIBE `ports` 0.0010149478912354
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00026702880859375
(372) DESCRIBE `ports` 0.00095891952514648
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00023889541625977
(374) DESCRIBE `ports` 0.00094509124755859
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026512145996094
(376) DESCRIBE `ports` 0.00096487998962402
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027585029602051
(378) DESCRIBE `avid_specials` 0.00086808204650879
(379) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73712 and class = 'Cruise') OR (item_id = 968 AND class = 'Ship') OR (item_id = 8 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.00160813331604
(380) DESCRIBE `cruiselines` 0.0014019012451172
(381) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00031208992004395
(382) DESCRIBE `orchid_image` 0.001121997833252
(383) DESCRIBE `cruiselines` 0.00093984603881836
(384) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00020408630371094
(385) DESCRIBE `cruises` 0.0012719631195068
(386) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59134') 0.00021600723266602
(387) DESCRIBE `ships` 0.0012879371643066
(388) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 332))) 0.0002598762512207
(389) DESCRIBE `ships` 0.0012588500976562
(390) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '332') 0.00019001960754395
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002140998840332
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00023102760314941
(393) DESCRIBE `itineraries` 0.00090980529785156
(394) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59134') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00095891952514648
(395) DESCRIBE `ports` 0.0010759830474854
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00024509429931641
(397) DESCRIBE `ports` 0.00077390670776367
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00024604797363281
(399) DESCRIBE `ports` 0.00098085403442383
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00020217895507812
(401) DESCRIBE `sailingdates` 0.00061202049255371
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59134') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040698051452637
(403) DESCRIBE `ports` 0.00071406364440918
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022602081298828
(405) DESCRIBE `ports` 0.00068402290344238
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019502639770508
(407) DESCRIBE `ports` 0.00089097023010254
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021100044250488
(409) DESCRIBE `ports` 0.00068497657775879
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019097328186035
(411) DESCRIBE `ports` 0.00067305564880371
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00020718574523926
(413) DESCRIBE `ports` 0.00068211555480957
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00019311904907227
(415) DESCRIBE `ports` 0.00069189071655273
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020885467529297
(417) DESCRIBE `ports` 0.00067305564880371
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018787384033203
(419) DESCRIBE `ports` 0.00067496299743652
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00022292137145996
(421) DESCRIBE `ports` 0.0006709098815918
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018501281738281
(423) DESCRIBE `ports` 0.00068902969360352
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020408630371094
(425) DESCRIBE `ports` 0.00069093704223633
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018596649169922
(427) DESCRIBE `ports` 0.0006711483001709
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1063))) 0.00020313262939453
(429) DESCRIBE `ports` 0.0006718635559082
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1063') 0.00018501281738281
(431) DESCRIBE `ports` 0.00066900253295898
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1059))) 0.00020480155944824
(433) DESCRIBE `ports` 0.0007929801940918
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1059') 0.00018620491027832
(435) DESCRIBE `ports` 0.00079917907714844
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00026607513427734
(437) DESCRIBE `ports` 0.00092101097106934
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00022411346435547
(439) DESCRIBE `avid_specials` 0.00071310997009277
(440) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59134 and class = 'Cruise') OR (item_id = 332 AND class = 'Ship') OR (item_id = 14 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.0010409355163574
(441) DESCRIBE `cruiselines` 0.0013058185577393
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 14))) 0.00037598609924316
(443) DESCRIBE `orchid_image` 0.0012099742889404
(444) DESCRIBE `cruiselines` 0.0014040470123291
(445) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '14') 0.00028300285339355
(446) DESCRIBE `cruises` 0.0023448467254639
(447) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60710') 0.00032496452331543
(448) DESCRIBE `ships` 0.0019659996032715
(449) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1156))) 0.00029087066650391
(450) DESCRIBE `ships` 0.0013868808746338
(451) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1156') 0.00020503997802734
(452) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(454) DESCRIBE `itineraries` 0.00069808959960938
(455) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60710') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066804885864258
(456) DESCRIBE `ports` 0.0012969970703125
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00033712387084961
(458) DESCRIBE `ports` 0.0010180473327637
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00029802322387695
(460) DESCRIBE `ports` 0.0010340213775635
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00026202201843262
(462) DESCRIBE `sailingdates` 0.00089001655578613
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60710') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067901611328125
(464) DESCRIBE `ports` 0.0011980533599854
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00032210350036621
(466) DESCRIBE `ports` 0.0010371208190918
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00026202201843262
(468) DESCRIBE `ports` 0.0010461807250977
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00027084350585938
(470) DESCRIBE `ports` 0.0010008811950684
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00028204917907715
(472) DESCRIBE `ports` 0.0010340213775635
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0002899169921875
(474) DESCRIBE `ports` 0.0010509490966797
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0002598762512207
(476) DESCRIBE `ports` 0.0010058879852295
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00027894973754883
(478) DESCRIBE `ports` 0.0010221004486084
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00024509429931641
(480) DESCRIBE `ports` 0.00098109245300293
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0003349781036377
(482) DESCRIBE `ports` 0.0010061264038086
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00025606155395508
(484) DESCRIBE `ports` 0.000946044921875
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00028085708618164
(486) DESCRIBE `ports` 0.0010030269622803
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00024890899658203
(488) DESCRIBE `ports` 0.001025915145874
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00027704238891602
(490) DESCRIBE `ports` 0.0010690689086914
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00024795532226562
(492) DESCRIBE `ports` 0.0010018348693848
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.0002751350402832
(494) DESCRIBE `ports` 0.0010139942169189
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00025296211242676
(496) DESCRIBE `ports` 0.0010168552398682
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00029277801513672
(498) DESCRIBE `ports` 0.0010719299316406
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00025296211242676
(500) DESCRIBE `ports` 0.0010099411010742
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00028300285339355
(502) DESCRIBE `ports` 0.0010230541229248
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00025486946105957
(504) DESCRIBE `ports` 0.0010099411010742
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00028204917907715
(506) DESCRIBE `ports` 0.0010230541229248
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00025486946105957
(508) DESCRIBE `ports` 0.0010251998901367
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00028014183044434
(510) DESCRIBE `ports` 0.0010209083557129
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00025200843811035
(512) DESCRIBE `avid_specials` 0.00093293190002441
(513) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60710 and class = 'Cruise') OR (item_id = 1156 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0018010139465332
(514) DESCRIBE `cruiselines` 0.0015909671783447
(515) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00041079521179199
(516) DESCRIBE `orchid_image` 0.0011680126190186
(517) DESCRIBE `cruiselines` 0.0014760494232178
(518) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00030398368835449
(519) DESCRIBE `cruises` 0.0022070407867432
(520) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62516') 0.00036787986755371
(521) DESCRIBE `ships` 0.0020318031311035
(522) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00037407875061035
(523) DESCRIBE `ships` 0.0019631385803223
(524) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00029683113098145
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023984909057617
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022697448730469
(527) DESCRIBE `itineraries` 0.0011131763458252
(528) DESCRIBE `ports` 0.0010180473327637
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00031399726867676
(530) DESCRIBE `ports` 0.0010221004486084
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00028800964355469
(532) DESCRIBE `ports` 0.0010149478912354
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00027298927307129
(534) DESCRIBE `sailingdates` 0.00089788436889648
(535) DESCRIBE `ports` 0.001107931137085
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0003352165222168
(537) DESCRIBE `ports` 0.00098299980163574
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0002589225769043
(539) DESCRIBE `ports` 0.00097799301147461
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0002899169921875
(541) DESCRIBE `ports` 0.00098204612731934
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00024700164794922
(543) DESCRIBE `ports` 0.00099897384643555
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0002751350402832
(545) DESCRIBE `ports` 0.00098991394042969
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00024700164794922
(547) DESCRIBE `ports` 0.00098705291748047
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00028181076049805
(549) DESCRIBE `ports` 0.0009911060333252
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00028896331787109
(551) DESCRIBE `ports` 0.00097417831420898
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0002739429473877
(553) DESCRIBE `ports` 0.00098991394042969
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00024604797363281
(555) DESCRIBE `ports` 0.00096893310546875
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00027799606323242
(557) DESCRIBE `ports` 0.0010201930999756
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00024199485778809
(559) DESCRIBE `ports` 0.00096583366394043
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0002751350402832
(561) DESCRIBE `ports` 0.00099492073059082
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00025081634521484
(563) DESCRIBE `ports` 0.00096416473388672
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00027203559875488
(565) DESCRIBE `ports` 0.00098204612731934
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00025296211242676
(567) DESCRIBE `avid_specials` 0.00087594985961914
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62516 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.00164794921875
(569) DESCRIBE `cruiselines` 0.0014140605926514
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003359317779541
(571) DESCRIBE `orchid_image` 0.001107931137085
(572) DESCRIBE `cruiselines` 0.0013771057128906
(573) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028014183044434
(574) DESCRIBE `cruises` 0.0019009113311768
(575) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64063') 0.00033783912658691
(576) DESCRIBE `ships` 0.001986026763916
(577) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1495))) 0.0004570484161377
(578) DESCRIBE `ships` 0.0019989013671875
(579) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1495') 0.00029397010803223
(580) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024104118347168
(581) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022792816162109
(582) DESCRIBE `itineraries` 0.0010271072387695
(583) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64063') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076198577880859
(584) DESCRIBE `ports` 0.0012140274047852
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.0003359317779541
(586) DESCRIBE `ports` 0.0010678768157959
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.00029206275939941
(588) DESCRIBE `ports` 0.00099301338195801
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24') 0.00027799606323242
(590) DESCRIBE `sailingdates` 0.00088000297546387
(591) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64063') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071907043457031
(592) DESCRIBE `ports` 0.00118088722229
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.0003359317779541
(594) DESCRIBE `ports` 0.0010771751403809
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24') 0.00028610229492188
(596) DESCRIBE `ports` 0.0010139942169189
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2610))) 0.00034403800964355
(598) DESCRIBE `ports` 0.0010678768157959
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2610') 0.00028085708618164
(600) DESCRIBE `ports` 0.001025915145874
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5203))) 0.00030398368835449
(602) DESCRIBE `ports` 0.0010139942169189
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5203') 0.0002598762512207
(604) DESCRIBE `ports` 0.0010359287261963
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2545))) 0.00029492378234863
(606) DESCRIBE `ports` 0.0010020732879639
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2545') 0.00026798248291016
(608) DESCRIBE `ports` 0.0010159015655518
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3371))) 0.00030708312988281
(610) DESCRIBE `ports` 0.0011060237884521
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3371') 0.00043797492980957
(612) DESCRIBE `ports` 0.0011348724365234
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1238))) 0.00036907196044922
(614) DESCRIBE `ports` 0.0010659694671631
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1238') 0.00027203559875488
(616) DESCRIBE `ports` 0.0009911060333252
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1239))) 0.00029611587524414
(618) DESCRIBE `ports` 0.0010349750518799
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1239') 0.00027084350585938
(620) DESCRIBE `ports` 0.0010309219360352
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1233))) 0.00029110908508301
(622) DESCRIBE `ports` 0.00098085403442383
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1233') 0.00028896331787109
(624) DESCRIBE `ports` 0.00097107887268066
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1240))) 0.00028014183044434
(626) DESCRIBE `ports` 0.00097179412841797
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1240') 0.000244140625
(628) DESCRIBE `ports` 0.00096821784973145
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2539))) 0.00027203559875488
(630) DESCRIBE `ports` 0.00099301338195801
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2539') 0.00025105476379395
(632) DESCRIBE `ports` 0.00098586082458496
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2611))) 0.00029706954956055
(634) DESCRIBE `ports` 0.00099992752075195
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2611') 0.00026988983154297
(636) DESCRIBE `ports` 0.00098896026611328
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1663))) 0.00027894973754883
(638) DESCRIBE `ports` 0.00097107887268066
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1663') 0.00025105476379395
(640) DESCRIBE `ports` 0.00097012519836426
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1241))) 0.00028586387634277
(642) DESCRIBE `ports` 0.0010020732879639
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1241') 0.00025606155395508
(644) DESCRIBE `ports` 0.0010249614715576
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1235))) 0.00027799606323242
(646) DESCRIBE `ports` 0.00096988677978516
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1235') 0.00024294853210449
(648) DESCRIBE `ports` 0.00096487998962402
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00029683113098145
(650) DESCRIBE `ports` 0.0010530948638916
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00026988983154297
(652) DESCRIBE `avid_specials` 0.00091910362243652
(653) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64063 and class = 'Cruise') OR (item_id = 1495 AND class = 'Ship') OR (item_id = 181 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.0016770362854004
(654) DESCRIBE `cruiselines` 0.0015099048614502
(655) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00037217140197754
(656) DESCRIBE `orchid_image` 0.001234769821167
(657) DESCRIBE `cruiselines` 0.0013959407806396
(658) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00030207633972168
(659) DESCRIBE `cruises` 0.0015888214111328
(660) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65451') 0.00024795532226562
(661) DESCRIBE `ships` 0.0013740062713623
(662) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1189))) 0.00028395652770996
(663) DESCRIBE `ships` 0.0013530254364014
(664) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1189') 0.00020313262939453
(665) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00019598007202148
(666) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00017595291137695
(667) DESCRIBE `itineraries` 0.000762939453125
(668) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65451') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001060962677002
(669) DESCRIBE `ports` 0.001121997833252
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 453))) 0.00031113624572754
(671) DESCRIBE `ports` 0.00094485282897949
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 453))) 0.00025606155395508
(673) DESCRIBE `ports` 0.00082206726074219
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '453') 0.00025701522827148
(675) DESCRIBE `sailingdates` 0.00075793266296387
(676) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65451') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071310997009277
(677) DESCRIBE `ports` 0.0010020732879639
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 453))) 0.00029802322387695
(679) DESCRIBE `ports` 0.00078010559082031
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '453') 0.00025296211242676
(681) DESCRIBE `ports` 0.00091409683227539
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3061))) 0.00020885467529297
(683) DESCRIBE `ports` 0.00094103813171387
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3061') 0.00020194053649902
(685) DESCRIBE `ports` 0.00094294548034668
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5491))) 0.0003049373626709
(687) DESCRIBE `ports` 0.001007080078125
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5491') 0.00023603439331055
(689) DESCRIBE `ports` 0.00089502334594727
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5492))) 0.00028085708618164
(691) DESCRIBE `ports` 0.00099492073059082
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5492') 0.00024986267089844
(693) DESCRIBE `ports` 0.0010080337524414
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5133))) 0.00029706954956055
(695) DESCRIBE `ports` 0.00099301338195801
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5133') 0.00024795532226562
(697) DESCRIBE `ports` 0.0010020732879639
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5493))) 0.00020813941955566
(699) DESCRIBE `ports` 0.00068092346191406
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5493') 0.00018811225891113
(701) DESCRIBE `ports` 0.00067496299743652
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2761))) 0.0002138614654541
(703) DESCRIBE `ports` 0.0006709098815918
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2761') 0.00018501281738281
(705) DESCRIBE `ports` 0.00094890594482422
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2760))) 0.00028395652770996
(707) DESCRIBE `ports` 0.00097894668579102
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2760') 0.00024104118347168
(709) DESCRIBE `ports` 0.00097012519836426
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 440))) 0.00026917457580566
(711) DESCRIBE `ports` 0.0009758472442627
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '440') 0.00024104118347168
(713) DESCRIBE `ports` 0.00098919868469238
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00020813941955566
(715) DESCRIBE `ports` 0.00084400177001953
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.00018787384033203
(717) DESCRIBE `ports` 0.00071597099304199
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1899))) 0.00025105476379395
(719) DESCRIBE `ports` 0.00084805488586426
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1899') 0.00021791458129883
(721) DESCRIBE `ports` 0.00084495544433594
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1324))) 0.00025105476379395
(723) DESCRIBE `ports` 0.00084900856018066
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1324') 0.00021910667419434
(725) DESCRIBE `ports` 0.00086092948913574
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00025200843811035
(727) DESCRIBE `ports` 0.00067806243896484
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00018501281738281
(729) DESCRIBE `avid_specials` 0.00060796737670898
(730) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65451 and class = 'Cruise') OR (item_id = 1189 AND class = 'Ship') OR (item_id = 29 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.00097107887268066
(731) DESCRIBE `cruiselines` 0.0009620189666748
(732) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00023102760314941
(733) DESCRIBE `orchid_image` 0.00075507164001465
(734) DESCRIBE `cruiselines` 0.0011157989501953
(735) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '96', '144', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '118', '24', '220', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '170', '180', '59', '115', '225', '229', '140', '95', '219', '57', '108', '231', '269', '184', '52', '132', '248', '276', '88', '275', '38', '182', '261', '264', '244', '82', '230', '105', '116', '266', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,96,144,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,118,24,220,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,170,180,59,115,225,229,140,95,219,57,108,231,269,184,52,132,248,276,88,275,38,182,261,264,244,82,230,105,116,266,39,64,48,119,240,224,245,210,134,251') 0.003896951675415
(736) DESCRIBE `ships` 0.0025060176849365
(737) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '22', '1424', '461', '1599', '28', '21', '817', '1422', '1594', '393', '1419', '1420', '1423', '1418', '1421', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '439', '1574', '9', '10', '207', '542', '1067', '1245', '585', '674', '770', '330', '404', '1272', '455', '974', '124', '1455', '1460', '792', '1215', '553', '797', '5', '739', '871', '116', '573', '1572', '25', '3', '520', '855', '1607', '14', '78', '711', '1193', '340', '434', '1021', '1302', '1402', '253', '1586', '390', '1284', '748', '1172', '43', '559', '580', '1581', '462', '765', '285', '791', '1320', '1323', '874', '658', '405', '1139', '590', '678', '286', '582', '883', '119', '327', '526', '731', '859', '970', '454', '854', '406', '81', '823', '610', '722', '850', '1236', '1027', '1569', '114', '993', '1348', '1319', '1415', '1614', '30', '31', '34', '35', '36', '37', '38', '82', '378', '403', '1008', '1012', '1326', '1327', '1678', '39', '160', '333', '547', '1330', '451', '1205', '1325', '163', '348', '351', '784', '966', '1454', '338', '657', '84', '262', '701', '1575', '325', '521', '683', '1143', '732', '287', '352', '1318', '4', '111', '508', '1088', '1108', '1151', '1157', '1471', '1579', '389', '1032', '1075', '1134', '1367', '290', '314', '751', '1214', '1233', '1308', '335', '1145', '1223', '1345', '93', '1013', '1321', '1405', '162', '1137', '1344', '1376', '291', '394', '483', '651', '673', '1144', '1343', '1587', '45', '852', '1604', '545', '988', '1149', '1452', '1453', '1615', '152', '401', '1025', '1090', '1095', '1136', '1283', '1724', '98', '441', '882', '968', '1168', '1243', '1373', '1413', '626', '716', '768', '1163', '1301', '1398', '59', '148', '149', '150', '769', '986', '1382', '1417', '1492', '1526', '75', '151', '639', '669', '905', '1150', '1176', '1226', '1292', '1448', '201', '1449', '324', '776', '973', '1647', '223', '417', '601', '616', '837', '996', '1241', '1458', '1552', '1602', '108', '313', '467', '1026', '1411', '266', '341', '857', '1231', '1489', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '74', '421', '666', '704', '851', '1055', '1152', '1362', '1368', '1372', '480', '885', '1230', '1260', '1384', '1516', '105', '147', '574', '888', '1383', '1408', '1470', '1628', '1717', '503', '790', '1054', '1154', '1208', '1224', '1518', '749', '1505', '1571', '208', '1672', '205', '332', '494', '652', '796', '884', '1253', '1501', '1521', '1611', '422', '618', '811', '818', '836', '985', '1148', '123', '493', '1068', '1486', '1517', '1522', '1632', '204', '212', '423', '937', '938', '1409', '1612', '1682', '448', '485', '1138', '1593', '1639', '994', '995', '1410', '66', '972', '1141', '375', '1017', '1303', '1461', '1539', '1627', '1064', '1601', '420', '1073', '1437', '1514', '1028', '1229', '1254', '1481', '1515', '1613', '1716', '453', '487', '665', '1259', '1412', '1684', '1175', '1189', '1262', '1619', '70', '717', '795', '958', '1159', '1713', '1715', '775', '1053', '1266', '1439', '1714', '715', '738', '1011', '1240', '1704', '1274', '1606', '69', '419', '1106', '1110', '1192', '1360', '1361', '1385', '1459', '944', '1183', '1184', '1347', '808', '1058', '1089', '1338', '1339', '1342', '1474', '1543', '1545', '1160', '1195', '1322', '1708', '62', '488', '798', '886', '1071', '1298', '1311', '1404', '1723', '225', '1158', '1310', '1645', '1649', '1697', '1729', '17', '299', '300', '997', '1043', '1087', '1132', '1355', '1358', '1451', '1629', '479', '672', '821', '1023', '1063', '1217', '1257', '1312', '1540', '288', '555', '692', '707', '1047', '1109', '1140', '1282', '1329', '1350', '1426', '1546')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,22,1424,461,1599,28,21,817,1422,1594,393,1419,1420,1423,1418,1421,1135,349,1359,452,780,113,766,265,24,11,439,1574,9,10,207,542,1067,1245,585,674,770,330,404,1272,455,974,124,1455,1460,792,1215,553,797,5,739,871,116,573,1572,25,3,520,855,1607,14,78,711,1193,340,434,1021,1302,1402,253,1586,390,1284,748,1172,43,559,580,1581,462,765,285,791,1320,1323,874,658,405,1139,590,678,286,582,883,119,327,526,731,859,970,454,854,406,81,823,610,722,850,1236,1027,1569,114,993,1348,1319,1415,1614,30,31,34,35,36,37,38,82,378,403,1008,1012,1326,1327,1678,39,160,333,547,1330,451,1205,1325,163,348,351,784,966,1454,338,657,84,262,701,1575,325,521,683,1143,732,287,352,1318,4,111,508,1088,1108,1151,1157,1471,1579,389,1032,1075,1134,1367,290,314,751,1214,1233,1308,335,1145,1223,1345,93,1013,1321,1405,162,1137,1344,1376,291,394,483,651,673,1144,1343,1587,45,852,1604,545,988,1149,1452,1453,1615,152,401,1025,1090,1095,1136,1283,1724,98,441,882,968,1168,1243,1373,1413,626,716,768,1163,1301,1398,59,148,149,150,769,986,1382,1417,1492,1526,75,151,639,669,905,1150,1176,1226,1292,1448,201,1449,324,776,973,1647,223,417,601,616,837,996,1241,1458,1552,1602,108,313,467,1026,1411,266,341,857,1231,1489,954,1029,1034,1285,1366,1496,1609,1711,74,421,666,704,851,1055,1152,1362,1368,1372,480,885,1230,1260,1384,1516,105,147,574,888,1383,1408,1470,1628,1717,503,790,1054,1154,1208,1224,1518,749,1505,1571,208,1672,205,332,494,652,796,884,1253,1501,1521,1611,422,618,811,818,836,985,1148,123,493,1068,1486,1517,1522,1632,204,212,423,937,938,1409,1612,1682,448,485,1138,1593,1639,994,995,1410,66,972,1141,375,1017,1303,1461,1539,1627,1064,1601,420,1073,1437,1514,1028,1229,1254,1481,1515,1613,1716,453,487,665,1259,1412,1684,1175,1189,1262,1619,70,717,795,958,1159,1713,1715,775,1053,1266,1439,1714,715,738,1011,1240,1704,1274,1606,69,419,1106,1110,1192,1360,1361,1385,1459,944,1183,1184,1347,808,1058,1089,1338,1339,1342,1474,1543,1545,1160,1195,1322,1708,62,488,798,886,1071,1298,1311,1404,1723,225,1158,1310,1645,1649,1697,1729,17,299,300,997,1043,1087,1132,1355,1358,1451,1629,479,672,821,1023,1063,1217,1257,1312,1540,288,555,692,707,1047,1109,1140,1282,1329,1350,1426,1546') 0.025982856750488
(738) DESCRIBE `cruisetypes` 0.0012609958648682
(739) DESCRIBE `destinations` 0.0015490055084229
(740) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '28', '26', '55', '11', '21', '38', '40', '49', '7', '44', '48', '30', '29', '10', '56', '45', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,28,26,55,11,21,38,40,49,7,44,48,30,29,10,56,45,34,52,46,32') 0.0016558170318604