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

Total elapsed time: 0.36154985427856

# Query Time
(1) connect 0.00054693222045898
(2) DESCRIBE `cruises` 0.0020768642425537
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (54738, 60014, 64318, 50048, 61213, 43424, 55135, 62110, 55529, 46038)) ORDER BY FIND_IN_SET(id, '54738,60014,64318,50048,61213,43424,55135,62110,55529,46038') 0.0016040802001953
(4) DESCRIBE `cruises` 0.0021569728851318
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54738') 0.00041604042053223
(6) DESCRIBE `ships` 0.0021910667419434
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00043582916259766
(8) DESCRIBE `ships` 0.0020859241485596
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00048589706420898
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001990795135498
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(12) DESCRIBE `itineraries` 0.0010418891906738
(13) DESCRIBE `ports` 0.0012400150299072
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035595893859863
(15) DESCRIBE `ports` 0.00095605850219727
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024104118347168
(17) DESCRIBE `ports` 0.00082993507385254
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0055050849914551
(19) DESCRIBE `sailingdates` 0.0010080337524414
(20) DESCRIBE `ports` 0.0013120174407959
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030398368835449
(22) DESCRIBE `ports` 0.00083303451538086
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00023317337036133
(24) DESCRIBE `ports` 0.00081682205200195
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00024509429931641
(26) DESCRIBE `ports` 0.00079011917114258
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0002138614654541
(28) DESCRIBE `ports` 0.00077009201049805
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00024199485778809
(30) DESCRIBE `ports` 0.0008540153503418
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00025415420532227
(32) DESCRIBE `ports` 0.00082302093505859
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025606155395508
(34) DESCRIBE `ports` 0.00084304809570312
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00022602081298828
(36) DESCRIBE `avid_specials` 0.00084900856018066
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54738 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0015439987182617
(38) DESCRIBE `cruiselines` 0.0013449192047119
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033998489379883
(40) DESCRIBE `orchid_image` 0.0010788440704346
(41) DESCRIBE `cruiselines` 0.0013418197631836
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00048208236694336
(43) DESCRIBE `cruises` 0.0020430088043213
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60014') 0.00038003921508789
(45) DESCRIBE `ships` 0.0020649433135986
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00044083595275879
(47) DESCRIBE `ships` 0.0022408962249756
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00037097930908203
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022101402282715
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(51) DESCRIBE `itineraries` 0.0010979175567627
(52) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60014') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007472038269043
(53) DESCRIBE `ports` 0.00118088722229
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00034713745117188
(55) DESCRIBE `ports` 0.001086950302124
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029993057250977
(57) DESCRIBE `ports` 0.00099396705627441
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00029921531677246
(59) DESCRIBE `sailingdates` 0.00086188316345215
(60) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60014') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081396102905273
(61) DESCRIBE `ports` 0.0011911392211914
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00030708312988281
(63) DESCRIBE `ports` 0.00098204612731934
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00025701522827148
(65) DESCRIBE `ports` 0.000946044921875
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00030398368835449
(67) DESCRIBE `ports` 0.00092005729675293
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00020408630371094
(69) DESCRIBE `ports` 0.00079107284545898
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00028395652770996
(71) DESCRIBE `ports` 0.00085306167602539
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00023603439331055
(73) DESCRIBE `ports` 0.0009310245513916
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00028896331787109
(75) DESCRIBE `ports` 0.00095701217651367
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00025796890258789
(77) DESCRIBE `avid_specials` 0.00079989433288574
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60014 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0013620853424072
(79) DESCRIBE `cruiselines` 0.0014200210571289
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00036001205444336
(81) DESCRIBE `orchid_image` 0.0010559558868408
(82) DESCRIBE `cruiselines` 0.001417875289917
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030684471130371
(84) DESCRIBE `cruises` 0.001939058303833
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64318') 0.00034499168395996
(86) DESCRIBE `ships` 0.0018110275268555
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 123))) 0.00037503242492676
(88) DESCRIBE `ships` 0.0015459060668945
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '123') 0.00025296211242676
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(92) DESCRIBE `itineraries` 0.00093197822570801
(93) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64318') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005500316619873
(94) DESCRIBE `ports` 0.0009310245513916
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00028109550476074
(96) DESCRIBE `ports` 0.00085806846618652
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00021600723266602
(98) DESCRIBE `ports` 0.00075912475585938
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00021886825561523
(100) DESCRIBE `sailingdates` 0.00077080726623535
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64318') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064992904663086
(102) DESCRIBE `ports` 0.0012450218200684
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00032711029052734
(104) DESCRIBE `ports` 0.00098013877868652
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0011789798736572
(106) DESCRIBE `ports` 0.0010387897491455
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00028896331787109
(108) DESCRIBE `ports` 0.0009770393371582
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00024199485778809
(110) DESCRIBE `ports` 0.00093698501586914
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030303001403809
(112) DESCRIBE `ports` 0.0011107921600342
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00024604797363281
(114) DESCRIBE `ports` 0.00087285041809082
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00031590461730957
(116) DESCRIBE `ports` 0.00085997581481934
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00023889541625977
(118) DESCRIBE `avid_specials` 0.00082898139953613
(119) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64318 and class = 'Cruise') OR (item_id = 123 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015270709991455
(120) DESCRIBE `cruiselines` 0.0013358592987061
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033092498779297
(122) DESCRIBE `orchid_image` 0.0009920597076416
(123) DESCRIBE `cruiselines` 0.0012600421905518
(124) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029397010803223
(125) DESCRIBE `cruises` 0.0020749568939209
(126) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50048') 0.00048112869262695
(127) DESCRIBE `ships` 0.0021598339080811
(128) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286))) 0.00046801567077637
(129) DESCRIBE `ships` 0.0021100044250488
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.00036191940307617
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002140998840332
(133) DESCRIBE `itineraries` 0.0013058185577393
(134) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '50048') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056815147399902
(135) DESCRIBE `ports` 0.0011870861053467
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00030899047851562
(137) DESCRIBE `ports` 0.0010511875152588
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00026702880859375
(139) DESCRIBE `ports` 0.0010330677032471
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00028109550476074
(141) DESCRIBE `sailingdates` 0.00087594985961914
(142) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '50048') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071501731872559
(143) DESCRIBE `ports` 0.0011968612670898
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00031590461730957
(145) DESCRIBE `ports` 0.0008699893951416
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023818016052246
(147) DESCRIBE `ports` 0.00092482566833496
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0002739429473877
(149) DESCRIBE `ports` 0.00090193748474121
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00024294853210449
(151) DESCRIBE `ports` 0.00094890594482422
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00027203559875488
(153) DESCRIBE `ports` 0.00094103813171387
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00028395652770996
(155) DESCRIBE `ports` 0.0010299682617188
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00028800964355469
(157) DESCRIBE `ports` 0.00089001655578613
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0002439022064209
(159) DESCRIBE `ports` 0.00094318389892578
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00029897689819336
(161) DESCRIBE `ports` 0.00096583366394043
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00024795532226562
(163) DESCRIBE `ports` 0.0009310245513916
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00026798248291016
(165) DESCRIBE `ports` 0.00084686279296875
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00022792816162109
(167) DESCRIBE `ports` 0.00084400177001953
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00027894973754883
(169) DESCRIBE `ports` 0.00088787078857422
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00025796890258789
(171) DESCRIBE `avid_specials` 0.00083684921264648
(172) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50048 and class = 'Cruise') OR (item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014309883117676
(173) DESCRIBE `cruiselines` 0.0014669895172119
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031805038452148
(175) DESCRIBE `orchid_image` 0.0011320114135742
(176) DESCRIBE `cruiselines` 0.001446008682251
(177) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028610229492188
(178) DESCRIBE `cruises` 0.0020091533660889
(179) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61213') 0.00026917457580566
(180) DESCRIBE `ships` 0.0013902187347412
(181) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1323))) 0.00034880638122559
(182) DESCRIBE `ships` 0.0016589164733887
(183) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1323') 0.00029516220092773
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00023293495178223
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018811225891113
(186) DESCRIBE `itineraries` 0.00090408325195312
(187) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61213') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054383277893066
(188) DESCRIBE `ports` 0.0010559558868408
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003049373626709
(190) DESCRIBE `ports` 0.00084185600280762
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026512145996094
(192) DESCRIBE `ports` 0.00092315673828125
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019598007202148
(194) DESCRIBE `sailingdates` 0.00055885314941406
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61213') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073385238647461
(196) DESCRIBE `ports` 0.0014479160308838
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034308433532715
(198) DESCRIBE `ports` 0.0011289119720459
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030899047851562
(200) DESCRIBE `ports` 0.0010440349578857
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00029087066650391
(202) DESCRIBE `ports` 0.00089788436889648
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00020694732666016
(204) DESCRIBE `ports` 0.00076508522033691
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00027894973754883
(206) DESCRIBE `ports` 0.00099611282348633
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00025296211242676
(208) DESCRIBE `ports` 0.00096702575683594
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00028395652770996
(210) DESCRIBE `ports` 0.00096607208251953
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.000244140625
(212) DESCRIBE `ports` 0.0011329650878906
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028204917907715
(214) DESCRIBE `ports` 0.0010068416595459
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024008750915527
(216) DESCRIBE `avid_specials` 0.00095987319946289
(217) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61213 and class = 'Cruise') OR (item_id = 1323 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015280246734619
(218) DESCRIBE `cruiselines` 0.0012640953063965
(219) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00030517578125
(220) DESCRIBE `orchid_image` 0.0011019706726074
(221) DESCRIBE `cruiselines` 0.0014078617095947
(222) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029301643371582
(223) DESCRIBE `cruises` 0.0018160343170166
(224) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43424') 0.00031304359436035
(225) DESCRIBE `ships` 0.0015718936920166
(226) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00040411949157715
(227) DESCRIBE `ships` 0.0017759799957275
(228) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00031185150146484
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(231) DESCRIBE `itineraries` 0.00094795227050781
(232) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43424') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059890747070312
(233) DESCRIBE `ports` 0.0012400150299072
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00033116340637207
(235) DESCRIBE `ports` 0.00086379051208496
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025606155395508
(237) DESCRIBE `ports` 0.00089788436889648
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00024008750915527
(239) DESCRIBE `sailingdates` 0.0008242130279541
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43424') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058698654174805
(241) DESCRIBE `ports` 0.00077080726623535
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023078918457031
(243) DESCRIBE `ports` 0.00066399574279785
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022315979003906
(245) DESCRIBE `ports` 0.000885009765625
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00027608871459961
(247) DESCRIBE `ports` 0.00090694427490234
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00024700164794922
(249) DESCRIBE `ports` 0.00091218948364258
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00026988983154297
(251) DESCRIBE `ports` 0.0008699893951416
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00023102760314941
(253) DESCRIBE `ports` 0.00089907646179199
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00026988983154297
(255) DESCRIBE `ports` 0.00090885162353516
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00025200843811035
(257) DESCRIBE `ports` 0.00087213516235352
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00026583671569824
(259) DESCRIBE `ports` 0.00075721740722656
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0001981258392334
(261) DESCRIBE `avid_specials` 0.00074911117553711
(262) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43424 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.0013000965118408
(263) DESCRIBE `cruiselines` 0.0011970996856689
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032401084899902
(265) DESCRIBE `orchid_image` 0.0011489391326904
(266) DESCRIBE `cruiselines` 0.0011780261993408
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023794174194336
(268) DESCRIBE `cruises` 0.0013229846954346
(269) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55135') 0.00027298927307129
(270) DESCRIBE `ships` 0.0015771389007568
(271) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 658))) 0.00029182434082031
(272) DESCRIBE `ships` 0.0019149780273438
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '658') 0.00036382675170898
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(276) DESCRIBE `itineraries` 0.0011069774627686
(277) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55135') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061583518981934
(278) DESCRIBE `ports` 0.00092411041259766
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026392936706543
(280) DESCRIBE `ports` 0.0007622241973877
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00018596649169922
(282) DESCRIBE `ports` 0.0007779598236084
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018906593322754
(284) DESCRIBE `sailingdates` 0.00055980682373047
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55135') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063991546630859
(286) DESCRIBE `ports` 0.00085210800170898
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027203559875488
(288) DESCRIBE `ports` 0.00074505805969238
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022792816162109
(290) DESCRIBE `ports` 0.00069808959960938
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00019001960754395
(292) DESCRIBE `ports` 0.00060796737670898
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00019001960754395
(294) DESCRIBE `ports` 0.00065302848815918
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020313262939453
(296) DESCRIBE `ports` 0.00065517425537109
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017881393432617
(298) DESCRIBE `ports` 0.00064396858215332
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026202201843262
(300) DESCRIBE `ports` 0.0010039806365967
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024604797363281
(302) DESCRIBE `avid_specials` 0.00084018707275391
(303) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55135 and class = 'Cruise') OR (item_id = 658 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014910697937012
(304) DESCRIBE `cruiselines` 0.0014088153839111
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031590461730957
(306) DESCRIBE `orchid_image` 0.0011820793151855
(307) DESCRIBE `cruiselines` 0.0013899803161621
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028014183044434
(309) DESCRIBE `cruises` 0.0018491744995117
(310) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62110') 0.00033807754516602
(311) DESCRIBE `ships` 0.0020020008087158
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00047588348388672
(313) DESCRIBE `ships` 0.002187967300415
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.0003960132598877
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(317) DESCRIBE `itineraries` 0.00093698501586914
(318) DESCRIBE `ports` 0.00068211555480957
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023603439331055
(320) DESCRIBE `ports` 0.00066590309143066
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018811225891113
(322) DESCRIBE `ports` 0.0007328987121582
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002288818359375
(324) DESCRIBE `sailingdates` 0.00065493583679199
(325) DESCRIBE `ports` 0.00081610679626465
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026798248291016
(327) DESCRIBE `ports` 0.00063776969909668
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(329) DESCRIBE `ports` 0.00068902969360352
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00022292137145996
(331) DESCRIBE `ports` 0.00091218948364258
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00026607513427734
(333) DESCRIBE `ports` 0.00098299980163574
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00022101402282715
(335) DESCRIBE `ports` 0.00067901611328125
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00020599365234375
(337) DESCRIBE `ports` 0.00064802169799805
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00019383430480957
(339) DESCRIBE `ports` 0.00063800811767578
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0001828670501709
(341) DESCRIBE `ports` 0.00058913230895996
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00024509429931641
(343) DESCRIBE `ports` 0.00060105323791504
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00016689300537109
(345) DESCRIBE `ports` 0.00081110000610352
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00028491020202637
(347) DESCRIBE `ports` 0.00098013877868652
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00019598007202148
(349) DESCRIBE `ports` 0.00072884559631348
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00021910667419434
(351) DESCRIBE `ports` 0.00073504447937012
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0001678466796875
(353) DESCRIBE `ports` 0.00059604644775391
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00018596649169922
(355) DESCRIBE `ports` 0.00068402290344238
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017499923706055
(357) DESCRIBE `ports` 0.00064182281494141
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019288063049316
(359) DESCRIBE `ports` 0.00060701370239258
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017118453979492
(361) DESCRIBE `avid_specials` 0.00058197975158691
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62110 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 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.00094008445739746
(363) DESCRIBE `cruiselines` 0.0013010501861572
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00030803680419922
(365) DESCRIBE `orchid_image` 0.0010769367218018
(366) DESCRIBE `cruiselines` 0.001323938369751
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027608871459961
(368) DESCRIBE `cruises` 0.0012030601501465
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55529') 0.00020599365234375
(370) DESCRIBE `ships` 0.0011110305786133
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1236))) 0.00024604797363281
(372) DESCRIBE `ships` 0.0018379688262939
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1236') 0.00028896331787109
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(376) DESCRIBE `itineraries` 0.00074601173400879
(377) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55529') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00036406517028809
(378) DESCRIBE `ports` 0.00069808959960938
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.0002129077911377
(380) DESCRIBE `ports` 0.00062203407287598
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.0002140998840332
(382) DESCRIBE `ports` 0.0006561279296875
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00017499923706055
(384) DESCRIBE `sailingdates` 0.00054001808166504
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55529') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077104568481445
(386) DESCRIBE `ports` 0.00075888633728027
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00023388862609863
(388) DESCRIBE `ports` 0.00067305564880371
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00017189979553223
(390) DESCRIBE `ports` 0.00059199333190918
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00019097328186035
(392) DESCRIBE `ports` 0.00060582160949707
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017285346984863
(394) DESCRIBE `ports` 0.00064516067504883
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00025200843811035
(396) DESCRIBE `ports` 0.00092387199401855
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00019216537475586
(398) DESCRIBE `ports` 0.0006411075592041
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00017714500427246
(400) DESCRIBE `ports` 0.00059700012207031
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00015997886657715
(402) DESCRIBE `ports` 0.00059103965759277
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00021004676818848
(404) DESCRIBE `ports` 0.00060009956359863
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00019693374633789
(406) DESCRIBE `ports` 0.00060296058654785
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00018095970153809
(408) DESCRIBE `ports` 0.00064492225646973
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00019717216491699
(410) DESCRIBE `ports` 0.00061297416687012
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00019097328186035
(412) DESCRIBE `ports` 0.00060200691223145
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00022387504577637
(414) DESCRIBE `ports` 0.00090479850769043
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00026392936706543
(416) DESCRIBE `ports` 0.00094199180603027
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00023007392883301
(418) DESCRIBE `avid_specials` 0.0005650520324707
(419) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55529 and class = 'Cruise') OR (item_id = 1236 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013329982757568
(420) DESCRIBE `cruiselines` 0.0010659694671631
(421) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00023102760314941
(422) DESCRIBE `orchid_image` 0.00069499015808105
(423) DESCRIBE `cruiselines` 0.0008699893951416
(424) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0001981258392334
(425) DESCRIBE `cruises` 0.0011889934539795
(426) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46038') 0.000244140625
(427) DESCRIBE `ships` 0.0011861324310303
(428) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00025010108947754
(429) DESCRIBE `ships` 0.0012340545654297
(430) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00019311904907227
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001528263092041
(433) DESCRIBE `itineraries` 0.00064301490783691
(434) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46038') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052404403686523
(435) DESCRIBE `ports` 0.00075006484985352
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00021195411682129
(437) DESCRIBE `ports` 0.00064396858215332
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0001838207244873
(439) DESCRIBE `ports` 0.0006411075592041
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017690658569336
(441) DESCRIBE `sailingdates` 0.00054097175598145
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46038') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050616264343262
(443) DESCRIBE `ports` 0.00084805488586426
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00024008750915527
(445) DESCRIBE `ports` 0.00064992904663086
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017499923706055
(447) DESCRIBE `ports` 0.00063610076904297
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00021910667419434
(449) DESCRIBE `ports` 0.00067615509033203
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.0002129077911377
(451) DESCRIBE `ports` 0.00070405006408691
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00023913383483887
(453) DESCRIBE `ports` 0.0006721019744873
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00017285346984863
(455) DESCRIBE `ports` 0.00060606002807617
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00017690658569336
(457) DESCRIBE `ports` 0.00060415267944336
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00016188621520996
(459) DESCRIBE `ports` 0.00063204765319824
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00018692016601562
(461) DESCRIBE `ports` 0.0005948543548584
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00016498565673828
(463) DESCRIBE `ports` 0.00065112113952637
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00018310546875
(465) DESCRIBE `ports` 0.00063991546630859
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00016403198242188
(467) DESCRIBE `ports` 0.00059390068054199
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018501281738281
(469) DESCRIBE `ports` 0.00061798095703125
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016999244689941
(471) DESCRIBE `avid_specials` 0.00055408477783203
(472) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46038 and class = 'Cruise') OR (item_id = 403 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094699859619141
(473) DESCRIBE `cruiselines` 0.00095415115356445
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00025701522827148
(475) DESCRIBE `orchid_image` 0.00080299377441406
(476) DESCRIBE `cruiselines` 0.00089192390441895
(477) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00019407272338867
(478) DESCRIBE `ships` 0.0015149116516113
(479) SELECT `ships`.* FROM `ships` WHERE (id IN ('393', '113', '330', '748', '791', '1323', '1586', '590', '526', '116', '124', '119', '286', '1236', '285', '403', '114', '1330', '389', '1571', '1141', '123', '287', '658', '262')) ORDER BY FIND_IN_SET(id, '393,113,330,748,791,1323,1586,590,526,116,124,119,286,1236,285,403,114,1330,389,1571,1141,123,287,658,262') 0.0012431144714355
(480) DESCRIBE `cruisetypes` 0.0008080005645752
(481) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.031007051467896
(482) DESCRIBE `destinations` 0.0011529922485352
(483) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '22', '35', '10', '43', '2', '11', '26', '38', '28', '8', '25', '21', '34', '29', '48')) ORDER BY FIND_IN_SET(id, '12,9,22,35,10,43,2,11,26,38,28,8,25,21,34,29,48') 0.0011248588562012
(484) DESCRIBE `cruiselines` 0.0010972023010254
(485) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00023007392883301
(486) DESCRIBE `cruiselines` 0.0015859603881836
(487) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032401084899902