or, enquire about your chosen options

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

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

 
 

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

Database Profiling Report

Total queries executed: 472

Total elapsed time: 0.55749225616455

# Query Time
(1) connect 0.0012660026550293
(2) DESCRIBE `cruises` 0.0040230751037598
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57674, 59424, 38147, 40592, 45260, 52653, 59343, 59431, 69209, 71097)) ORDER BY FIND_IN_SET(id, '57674,59424,38147,40592,45260,52653,59343,59431,69209,71097') 0.0016109943389893
(4) DESCRIBE `cruises` 0.0029439926147461
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57674') 0.00039410591125488
(6) DESCRIBE `ships` 0.0027720928192139
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00053286552429199
(8) DESCRIBE `ships` 0.0024781227111816
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00031304359436035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025582313537598
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00082612037658691
(12) DESCRIBE `itineraries` 0.0013439655303955
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57674') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070381164550781
(14) DESCRIBE `ports` 0.0014009475708008
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00035786628723145
(16) DESCRIBE `ports` 0.001417875289917
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00034785270690918
(18) DESCRIBE `ports` 0.0012791156768799
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00035285949707031
(20) DESCRIBE `sailingdates` 0.0012788772583008
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57674') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016632080078125
(22) DESCRIBE `ports` 0.0017819404602051
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0012118816375732
(24) DESCRIBE `ports` 0.002190113067627
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00098586082458496
(26) DESCRIBE `ports` 0.0020201206207275
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00099897384643555
(28) DESCRIBE `ports` 0.0013360977172852
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00031805038452148
(30) DESCRIBE `ports` 0.00090885162353516
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00039482116699219
(32) DESCRIBE `ports` 0.0016350746154785
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00012397766113281
(34) DESCRIBE `ports` 0.00160813331604
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0003960132598877
(36) DESCRIBE `ports` 0.0027241706848145
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00065112113952637
(38) DESCRIBE `ports` 0.0020201206207275
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00045299530029297
(40) DESCRIBE `ports` 0.001953125
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038290023803711
(42) DESCRIBE `ports` 0.001835823059082
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00045084953308105
(44) DESCRIBE `ports` 0.0017931461334229
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00038385391235352
(46) DESCRIBE `avid_specials` 0.0016071796417236
(47) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57674 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018560886383057
(48) DESCRIBE `cruiselines` 0.0026340484619141
(49) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00052499771118164
(50) DESCRIBE `orchid_image` 0.0020661354064941
(51) DESCRIBE `cruiselines` 0.0025410652160645
(52) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00047779083251953
(53) DESCRIBE `cruises` 0.0035519599914551
(54) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59424') 0.00042605400085449
(55) DESCRIBE `ships` 0.0029449462890625
(56) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1419))) 0.0005190372467041
(57) DESCRIBE `ships` 0.0027179718017578
(58) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1419') 0.00034308433532715
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029516220092773
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(61) DESCRIBE `itineraries` 0.0018789768218994
(62) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59424') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00094795227050781
(63) DESCRIBE `ports` 0.0019350051879883
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00043892860412598
(65) DESCRIBE `ports` 0.0017318725585938
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00024199485778809
(67) DESCRIBE `ports` 0.0011091232299805
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00033283233642578
(69) DESCRIBE `sailingdates` 0.0017311573028564
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59424') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011839866638184
(71) DESCRIBE `ports` 0.0018081665039062
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00043702125549316
(73) DESCRIBE `ports` 0.0016040802001953
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00013399124145508
(75) DESCRIBE `ports` 0.001784086227417
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00042104721069336
(77) DESCRIBE `ports` 0.0017881393432617
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00034689903259277
(79) DESCRIBE `ports` 0.0017139911651611
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.0003809928894043
(81) DESCRIBE `ports` 0.0014419555664062
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00029087066650391
(83) DESCRIBE `ports` 0.0012519359588623
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00032591819763184
(85) DESCRIBE `ports` 0.0014321804046631
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00026583671569824
(87) DESCRIBE `ports` 0.0016779899597168
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0004270076751709
(89) DESCRIBE `ports` 0.001572847366333
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00029277801513672
(91) DESCRIBE `ports` 0.0013010501861572
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00029492378234863
(93) DESCRIBE `ports` 0.0013182163238525
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00026702880859375
(95) DESCRIBE `ports` 0.0013091564178467
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00031614303588867
(97) DESCRIBE `ports` 0.0012969970703125
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00028300285339355
(99) DESCRIBE `avid_specials` 0.001410961151123
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59424 and class = 'Cruise') OR (item_id = 1419 AND class = 'Ship') OR (item_id = 31 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012619495391846
(101) DESCRIBE `cruiselines` 0.0026612281799316
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00048708915710449
(103) DESCRIBE `orchid_image` 0.0014529228210449
(104) DESCRIBE `cruiselines` 0.0018720626831055
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00038409233093262
(106) DESCRIBE `cruises` 0.0024230480194092
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38147') 0.00030612945556641
(108) DESCRIBE `ships` 0.0024819374084473
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00038695335388184
(110) DESCRIBE `ships` 0.0026869773864746
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00037813186645508
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035786628723145
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003199577331543
(114) DESCRIBE `itineraries` 0.0018582344055176
(115) DESCRIBE `ports` 0.0013191699981689
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00038504600524902
(117) DESCRIBE `ports` 0.0014100074768066
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00030183792114258
(119) DESCRIBE `ports` 0.0015861988067627
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00035500526428223
(121) DESCRIBE `sailingdates` 0.0012800693511963
(122) DESCRIBE `ports` 0.0014858245849609
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00034904479980469
(124) DESCRIBE `ports` 0.0013148784637451
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00027990341186523
(126) DESCRIBE `ports` 0.0013689994812012
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00036406517028809
(128) DESCRIBE `ports` 0.0012328624725342
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.0003209114074707
(130) DESCRIBE `ports` 0.0013558864593506
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00032997131347656
(132) DESCRIBE `ports` 0.0012640953063965
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.0002739429473877
(134) DESCRIBE `ports` 0.0013229846954346
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.00038003921508789
(136) DESCRIBE `ports` 0.0014879703521729
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00034117698669434
(138) DESCRIBE `ports` 0.0012800693511963
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00030899047851562
(140) DESCRIBE `ports` 0.0016989707946777
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.0002751350402832
(142) DESCRIBE `ports` 0.0013110637664795
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00028896331787109
(144) DESCRIBE `ports` 0.0012609958648682
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00036382675170898
(146) DESCRIBE `avid_specials` 0.001168966293335
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38147 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 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.0010740756988525
(148) DESCRIBE `cruiselines` 0.0020849704742432
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00038409233093262
(150) DESCRIBE `orchid_image` 0.0014870166778564
(151) DESCRIBE `cruiselines` 0.0018398761749268
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00032711029052734
(153) DESCRIBE `cruises` 0.0029749870300293
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40592') 0.00040292739868164
(155) DESCRIBE `ships` 0.0024838447570801
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00045609474182129
(157) DESCRIBE `ships` 0.0028340816497803
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0003209114074707
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028800964355469
(161) DESCRIBE `itineraries` 0.0015311241149902
(162) DESCRIBE `ports` 0.001366138458252
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00039315223693848
(164) DESCRIBE `ports` 0.0012969970703125
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0003049373626709
(166) DESCRIBE `ports` 0.0012469291687012
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00033998489379883
(168) DESCRIBE `sailingdates` 0.0011100769042969
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '40592') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095081329345703
(170) DESCRIBE `ports` 0.0017199516296387
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00038385391235352
(172) DESCRIBE `ports` 0.0014050006866455
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00034594535827637
(174) DESCRIBE `ports` 0.0013189315795898
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0
(176) DESCRIBE `ports` 0.0010859966278076
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00032496452331543
(178) DESCRIBE `ports` 0.0018959045410156
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00039005279541016
(180) DESCRIBE `ports` 0.0012907981872559
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00030899047851562
(182) DESCRIBE `ports` 0.0006110668182373
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00030899047851562
(184) DESCRIBE `ports` 0.0014011859893799
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00036907196044922
(186) DESCRIBE `avid_specials` 0.00094699859619141
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40592 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0017199516296387
(188) DESCRIBE `cruiselines` 0.0022211074829102
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 6.6995620727539E-5
(190) DESCRIBE `orchid_image` 0.0018160343170166
(191) DESCRIBE `cruiselines` 0.0019829273223877
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0011768341064453
(193) DESCRIBE `cruises` 0.0028271675109863
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00040006637573242
(195) DESCRIBE `ships` 0.003018856048584
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00041413307189941
(197) DESCRIBE `ships` 0.0025250911712646
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00045204162597656
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032901763916016
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025701522827148
(201) DESCRIBE `itineraries` 0.0013868808746338
(202) DESCRIBE `ports` 0.002129077911377
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0
(204) DESCRIBE `ports` 0.0012660026550293
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00028896331787109
(206) DESCRIBE `ports` 0.001291036605835
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028300285339355
(208) DESCRIBE `sailingdates` 0.0011160373687744
(209) DESCRIBE `ports` 0.0018191337585449
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045490264892578
(211) DESCRIBE `ports` 0.0013320446014404
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028610229492188
(213) DESCRIBE `ports` 0.0013651847839355
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00029301643371582
(215) DESCRIBE `ports` 0.0012619495391846
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00030016899108887
(217) DESCRIBE `ports` 0.0015959739685059
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031399726867676
(219) DESCRIBE `ports` 0.0013370513916016
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00026893615722656
(221) DESCRIBE `ports` 0.0013861656188965
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00032210350036621
(223) DESCRIBE `ports` 0.001305103302002
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00026607513427734
(225) DESCRIBE `ports` 0.0013039112091064
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00028800964355469
(227) DESCRIBE `ports` 0.0012731552124023
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00028491020202637
(229) DESCRIBE `ports` 0.0013167858123779
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029206275939941
(231) DESCRIBE `ports` 0.0013301372528076
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027179718017578
(233) DESCRIBE `avid_specials` 0.0011589527130127
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0010528564453125
(235) DESCRIBE `cruiselines` 0.0018599033355713
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00031304359436035
(237) DESCRIBE `orchid_image` 0.0013930797576904
(238) DESCRIBE `cruiselines` 0.0018689632415771
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00027203559875488
(240) DESCRIBE `cruises` 0.0016751289367676
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52653') 0.00030016899108887
(242) DESCRIBE `ships` 0.0025410652160645
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 22))) 0.00041913986206055
(244) DESCRIBE `ships` 0.0026168823242188
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '22') 0.00040006637573242
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037908554077148
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(248) DESCRIBE `itineraries` 0.001366138458252
(249) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52653') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068879127502441
(250) DESCRIBE `ports` 0.0012969970703125
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00032615661621094
(252) DESCRIBE `ports` 0.0012619495391846
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030112266540527
(254) DESCRIBE `ports` 0.0012369155883789
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00027203559875488
(256) DESCRIBE `sailingdates` 0.0011730194091797
(257) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52653') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013771057128906
(258) DESCRIBE `ports` 0.0022311210632324
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00050783157348633
(260) DESCRIBE `ports` 0.0017728805541992
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039005279541016
(262) DESCRIBE `ports` 0.001680850982666
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00045609474182129
(264) DESCRIBE `ports` 0.0022709369659424
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00033998489379883
(266) DESCRIBE `ports` 0.0016632080078125
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030016899108887
(268) DESCRIBE `ports` 0.00067305564880371
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00026583671569824
(270) DESCRIBE `avid_specials` 0.0018560886383057
(271) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52653 and class = 'Cruise') OR (item_id = 22 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.00065183639526367
(272) DESCRIBE `cruiselines` 0.001945972442627
(273) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0003359317779541
(274) DESCRIBE `orchid_image` 0.0015478134155273
(275) DESCRIBE `cruiselines` 0.0018830299377441
(276) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00029611587524414
(277) DESCRIBE `cruises` 0.0025260448455811
(278) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59343') 0.00032520294189453
(279) DESCRIBE `ships` 0.0028810501098633
(280) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1417))) 0.00039386749267578
(281) DESCRIBE `ships` 0.0029768943786621
(282) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1417') 0.00032901763916016
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029087066650391
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025320053100586
(285) DESCRIBE `itineraries` 0.0012550354003906
(286) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59343') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00013279914855957
(287) DESCRIBE `ports` 0.0015349388122559
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00073885917663574
(289) DESCRIBE `ports` 0.001284122467041
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00030994415283203
(291) DESCRIBE `ports` 0.0012540817260742
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00033402442932129
(293) DESCRIBE `sailingdates` 0.0012221336364746
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59343') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010120868682861
(295) DESCRIBE `ports` 0.0019130706787109
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0004279613494873
(297) DESCRIBE `ports` 0.0017938613891602
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00036001205444336
(299) DESCRIBE `ports` 0.0016078948974609
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00034999847412109
(301) DESCRIBE `ports` 0.001370906829834
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00034713745117188
(303) DESCRIBE `ports` 0.0015292167663574
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00037598609924316
(305) DESCRIBE `ports` 0.0014698505401611
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00028014183044434
(307) DESCRIBE `ports` 0.001384973526001
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.00029897689819336
(309) DESCRIBE `ports` 0.001291036605835
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.00026893615722656
(311) DESCRIBE `ports` 0.0013220310211182
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00041794776916504
(313) DESCRIBE `ports` 0.0017409324645996
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00035190582275391
(315) DESCRIBE `ports` 0.0017428398132324
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00039911270141602
(317) DESCRIBE `ports` 0.0018210411071777
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00036001205444336
(319) DESCRIBE `avid_specials` 0.0015590190887451
(320) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59343 and class = 'Cruise') OR (item_id = 1417 AND class = 'Ship') OR (item_id = 170 AND class = 'CruiseLine') OR (item_id = 44 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.0016529560089111
(321) DESCRIBE `cruiselines` 0.0025742053985596
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 170))) 0.00043702125549316
(323) DESCRIBE `orchid_image` 0.0015079975128174
(324) DESCRIBE `cruiselines` 0.0019068717956543
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '170') 0.00032711029052734
(326) DESCRIBE `cruises` 0.0026049613952637
(327) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59431') 0.00034403800964355
(328) DESCRIBE `ships` 0.0024938583374023
(329) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1419))) 0.00043511390686035
(330) DESCRIBE `ships` 0.0038580894470215
(331) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1419') 0
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032687187194824
(334) DESCRIBE `itineraries` 0.0023009777069092
(335) DESCRIBE `ports` 0.0021779537200928
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00043296813964844
(337) DESCRIBE `ports` 0.0017330646514893
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 8.1062316894531E-6
(339) DESCRIBE `ports` 0.0017380714416504
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0012450218200684
(341) DESCRIBE `sailingdates` 0.0011229515075684
(342) DESCRIBE `ports` 0.0021369457244873
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00018596649169922
(344) DESCRIBE `ports` 0.0017321109771729
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0002899169921875
(346) DESCRIBE `ports` 0.0015609264373779
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00033998489379883
(348) DESCRIBE `ports` 0.0015580654144287
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0
(350) DESCRIBE `ports` 0.0014698505401611
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00037407875061035
(352) DESCRIBE `ports` 0.00066804885864258
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00027203559875488
(354) DESCRIBE `ports` 0.0012640953063965
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0
(356) DESCRIBE `ports` 0.0012280941009521
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00026297569274902
(358) DESCRIBE `ports` 0.0019938945770264
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00029397010803223
(360) DESCRIBE `ports` 0.0013911724090576
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00028300285339355
(362) DESCRIBE `ports` 0.0012919902801514
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00034999847412109
(364) DESCRIBE `ports` 0.0014309883117676
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00033307075500488
(366) DESCRIBE `avid_specials` 0.0016558170318604
(367) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59431 and class = 'Cruise') OR (item_id = 1419 AND class = 'Ship') OR (item_id = 31 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017719268798828
(368) DESCRIBE `cruiselines` 0.0023012161254883
(369) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00034999847412109
(370) DESCRIBE `orchid_image` 0.0014050006866455
(371) DESCRIBE `cruiselines` 0.0017671585083008
(372) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00035190582275391
(373) DESCRIBE `cruises` 0.0030238628387451
(374) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69209') 0.00043582916259766
(375) DESCRIBE `ships` 0.0027389526367188
(376) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 817))) 0.00042200088500977
(377) DESCRIBE `ships` 0.0026190280914307
(378) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '817') 0.00035786628723145
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002748966217041
(380) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003199577331543
(381) DESCRIBE `itineraries` 0.0013501644134521
(382) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69209') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072598457336426
(383) DESCRIBE `ports` 0.0013980865478516
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033402442932129
(385) DESCRIBE `ports` 0.001291036605835
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030303001403809
(387) DESCRIBE `ports` 0.0013670921325684
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028300285339355
(389) DESCRIBE `sailingdates` 0.0011098384857178
(390) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69209') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00091719627380371
(391) DESCRIBE `ports` 0.0015139579772949
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038790702819824
(393) DESCRIBE `ports` 0.0012891292572021
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00029802322387695
(395) DESCRIBE `ports` 0.0012450218200684
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00032210350036621
(397) DESCRIBE `ports` 0.0015461444854736
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00034594535827637
(399) DESCRIBE `ports` 0.001317024230957
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00029897689819336
(401) DESCRIBE `ports` 0.0012679100036621
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00025820732116699
(403) DESCRIBE `ports` 0.0012907981872559
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.0002901554107666
(405) DESCRIBE `ports` 0.0012710094451904
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.0002751350402832
(407) DESCRIBE `ports` 0.0013279914855957
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00029587745666504
(409) DESCRIBE `ports` 0.001338005065918
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00027680397033691
(411) DESCRIBE `ports` 0.0013418197631836
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00029087066650391
(413) DESCRIBE `ports` 0.001270055770874
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00026988983154297
(415) DESCRIBE `ports` 0.001276969909668
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030803680419922
(417) DESCRIBE `ports` 0.0019009113311768
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00040888786315918
(419) DESCRIBE `avid_specials` 0.0012428760528564
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69209 and class = 'Cruise') OR (item_id = 817 AND class = 'Ship') OR (item_id = 118 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.0010228157043457
(421) DESCRIBE `cruiselines` 0.0019841194152832
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 118))) 0.00040698051452637
(423) DESCRIBE `orchid_image` 0.0014848709106445
(424) DESCRIBE `cruiselines` 0.001845121383667
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '118') 0.00032305717468262
(426) DESCRIBE `cruises` 0.0018649101257324
(427) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71097') 0.00034093856811523
(428) DESCRIBE `ships` 0.0031321048736572
(429) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.0004580020904541
(430) DESCRIBE `ships` 0.0031800270080566
(431) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00037503242492676
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025320053100586
(434) DESCRIBE `itineraries` 0.0014011859893799
(435) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71097') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077199935913086
(436) DESCRIBE `ports` 0.0014088153839111
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0004119873046875
(438) DESCRIBE `ports` 0.0014810562133789
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00030684471130371
(440) DESCRIBE `ports` 0.0012719631195068
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00029611587524414
(442) DESCRIBE `sailingdates` 0.0012791156768799
(443) DESCRIBE `ports` 0.0014100074768066
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00035190582275391
(445) DESCRIBE `ports` 0.0013189315795898
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00035500526428223
(447) DESCRIBE `ports` 0.0012519359588623
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00030708312988281
(449) DESCRIBE `ports` 0.0013010501861572
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00027298927307129
(451) DESCRIBE `ports` 0.0012631416320801
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00033378601074219
(453) DESCRIBE `ports` 0.0013718605041504
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00030016899108887
(455) DESCRIBE `ports` 0.0014100074768066
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043106079101562
(457) DESCRIBE `ports` 0.0013790130615234
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00032305717468262
(459) DESCRIBE `avid_specials` 0.0014090538024902
(460) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71097 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 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.0010719299316406
(461) DESCRIBE `cruiselines` 0.0025582313537598
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00042510032653809
(463) DESCRIBE `orchid_image` 0.0016927719116211
(464) DESCRIBE `cruiselines` 0.0020120143890381
(465) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00033402442932129
(466) DESCRIBE `cruiselines` 0.0019769668579102
(467) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '8', '7', '131', '96', '171', '103', '33', '156', '120', '15', '262', '191', '29', '31', '258', '91', '208', '50', '28', '14', '187', '251', '114', '49', '212', '24', '47', '37', '206', '16', '153', '151', '36', '170', '110', '118', '181', '264', '195', '4', '30', '88', '59', '108', '159', '141', '140', '73', '35', '216', '90', '147', '211', '113', '57', '180', '64', '257', '261', '38', '48', '115', '276', '213', '184', '95', '105', '52', '82', '244', '209', '177', '134', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,144,183,12,23,20,101,18,8,7,131,96,171,103,33,156,120,15,262,191,29,31,258,91,208,50,28,14,187,251,114,49,212,24,47,37,206,16,153,151,36,170,110,118,181,264,195,4,30,88,59,108,159,141,140,73,35,216,90,147,211,113,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0053439140319824
(468) DESCRIBE `ships` 0.0031309127807617
(469) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '1744', '1588', '977', '517', '1594', '1555', '454', '1794', '1237', '780', '1272', '974', '1717', '1032', '1359', '258', '797', '1292', '22', '461', '21', '330', '770', '393', '404', '28', '1677', '986', '1348', '1205', '716', '1415', '349', '674', '333', '11', '10', '207', '739', '1067', '439', '521', '9', '715', '25', '24', '163', '738', '882', '3', '480', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '792', '1768', '265', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '285', '1163', '1410', '14', '1068', '1302', '1411', '1413', '1526', '314', '526', '748', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1417', '34', '38', '43', '327', '582', '854', '1063', '1259', '31', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1208', '1266', '678', '1139', '1157', '1492', '114', '1587', '1766', '401', '406', '850', '1245', '1318', '4', '335', '351', '451', '545', '616', '1028', '1412', '1672', '386', '704', '1461', '212', '547', '658', '1722', '39', '84', '722', '1236', '1326', '1327', '1782', '30', '35', '36', '148', '340', '403', '1012', '1040', '1289', '385', '988', '1330', '1398', '1408', '325', '601', '1108', '1303', '1575', '1711', '27', '287', '683', '966', '291', '652', '1043', '1172', '105', '201', '389', '508', '627', '639', '78', '818', '1168', '394', '1223', '111', '852', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '1740', '123', '290', '673', '1029', '1160', '1217', '1282', '1343', '1418', '1421', '1424', '1452', '1453', '1801', '1037', '1229', '1426', '1604', '266', '1373', '1405', '45', '348', '701', '1095', '1226', '1704', '559', '768', '905', '1137', '1283', '1358', '1809', '253', '972', '1136', '1448', '223', '1150', '69', '341', '574', '851', '968', '98', '151', '651', '709', '973', '1409', '324', '1055', '1724', '1808', '108', '150', '643', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '857', '858', '954', '996', '1714', '75', '663', '769', '885', '1035', '1042', '1206', '1632', '1751', '467', '884', '1154', '1360', '1361', '1368', '1459', '1574', '1609', '1708', '1723', '1750', '666', '1049', '1362', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '423', '790', '1051', '1681', '147', '703', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '375', '1054', '152', '422', '483', '516', '707', '1075', '1224', '1486', '1601', '81', '1047', '1052', '1445', '1676', '796', '886', '937', '1036', '1572', '1679', '93', '116', '1048', '1138', '1262', '1351', '1437', '1465', '1781', '1045', '1329', '1539', '1673', '74', '149', '420', '1519', '1807', '644', '1060', '1109', '1146', '1444', '1468', '198', '503', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '656', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '1053', '1158', '1241', '1626', '671', '883', '1156', '1195', '1316', '1571', '1709', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1792', '299', '300', '685', '692', '1451', '1710')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,1744,1588,977,517,1594,1555,454,1794,1237,780,1272,974,1717,1032,1359,258,797,1292,22,461,21,330,770,393,404,28,1677,986,1348,1205,716,1415,349,674,333,11,10,207,739,1067,439,521,9,715,25,24,163,738,882,3,480,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,792,1768,265,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,285,1163,1410,14,1068,1302,1411,1413,1526,314,526,748,1320,1323,1579,855,286,390,405,573,970,1417,34,38,43,327,582,854,1063,1259,31,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1552,1284,1811,119,162,441,1159,1193,1208,1266,678,1139,1157,1492,114,1587,1766,401,406,850,1245,1318,4,335,351,451,545,616,1028,1412,1672,386,704,1461,212,547,658,1722,39,84,722,1236,1326,1327,1782,30,35,36,148,340,403,1012,1040,1289,385,988,1330,1398,1408,325,601,1108,1303,1575,1711,27,287,683,966,291,652,1043,1172,105,201,389,508,627,639,78,818,1168,394,1223,111,852,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,1740,123,290,673,1029,1160,1217,1282,1343,1418,1421,1424,1452,1453,1801,1037,1229,1426,1604,266,1373,1405,45,348,701,1095,1226,1704,559,768,905,1137,1283,1358,1809,253,972,1136,1448,223,1150,69,341,574,851,968,98,151,651,709,973,1409,324,1055,1724,1808,108,150,643,1230,1231,1458,1474,1501,1713,1730,1767,82,857,858,954,996,1714,75,663,769,885,1035,1042,1206,1632,1751,467,884,1154,1360,1361,1368,1459,1574,1609,1708,1723,1750,666,1049,1362,1772,1148,1322,1483,1771,665,888,944,423,790,1051,1681,147,703,717,784,1020,1071,1188,1293,1301,1580,70,375,1054,152,422,483,516,707,1075,1224,1486,1601,81,1047,1052,1445,1676,796,886,937,1036,1572,1679,93,116,1048,1138,1262,1351,1437,1465,1781,1045,1329,1539,1673,74,149,420,1519,1807,644,1060,1109,1146,1444,1468,198,503,1039,1050,1143,1196,1232,1350,205,419,656,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,1053,1158,1241,1626,671,883,1156,1195,1316,1571,1709,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1792,299,300,685,692,1451,1710') 0.046130895614624
(470) DESCRIBE `cruisetypes` 0.0015718936920166
(471) DESCRIBE `destinations` 0.0017819404602051
(472) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '40', '48', '7', '29', '21', '45', '44', '30', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,2,37,8,39,53,26,28,38,49,55,11,40,48,7,29,21,45,44,30,34,10,52,46,56,32') 0.0022249221801758