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

Total elapsed time: 1.0154919624329

# Query Time
(1) connect 0.0022108554840088
(2) DESCRIBE `cruises` 0.0067958831787109
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75900, 78325, 34711, 52512, 56846, 57661, 59425, 63227, 63335, 73753)) ORDER BY FIND_IN_SET(id, '75900,78325,34711,52512,56846,57661,59425,63227,63335,73753') 0.0040490627288818
(4) DESCRIBE `cruises` 0.0050020217895508
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75900') 0.00062012672424316
(6) DESCRIBE `ships` 0.0053470134735107
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 266))) 0.00085806846618652
(8) DESCRIBE `ships` 0.0053589344024658
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '266') 0.00077009201049805
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0004730224609375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00055599212646484
(12) DESCRIBE `itineraries` 0.0026907920837402
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75900') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001068115234375
(14) DESCRIBE `sailingdates` 0.0028119087219238
(15) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75900') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012447834014893
(16) DESCRIBE `itineraries` 0.0038039684295654
(17) DESCRIBE `itineraries` 0.0023720264434814
(18) DESCRIBE `avid_specials` 0.002701997756958
(19) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75900 and class = 'Cruise') OR (item_id = 266 AND class = 'Ship') OR (item_id = 49 AND class = 'CruiseLine') OR (item_id = 28 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.0024468898773193
(20) DESCRIBE `cruiselines` 0.0040371417999268
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.00096511840820312
(22) DESCRIBE `orchid_image` 0.0027589797973633
(23) DESCRIBE `cruiselines` 0.0030510425567627
(24) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.00053119659423828
(25) DESCRIBE `cruises` 0.0041549205780029
(26) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78325') 0.00059008598327637
(27) DESCRIBE `ships` 0.0045459270477295
(28) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1404))) 0.00064992904663086
(29) DESCRIBE `ships` 0.0043830871582031
(30) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1404') 0.00072407722473145
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00051498413085938
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0007328987121582
(33) DESCRIBE `itineraries` 0.0029079914093018
(34) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78325') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0023319721221924
(35) DESCRIBE `ports` 0.0023720264434814
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00063896179199219
(37) DESCRIBE `ports` 0.0026910305023193
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00086688995361328
(39) DESCRIBE `ports` 0.0042009353637695
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00070595741271973
(41) DESCRIBE `sailingdates` 0.0027310848236084
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78325') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013630390167236
(43) DESCRIBE `ports` 0.0029330253601074
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00094985961914062
(45) DESCRIBE `ports` 0.0027000904083252
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00063395500183105
(47) DESCRIBE `ports` 0.002540111541748
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00048089027404785
(49) DESCRIBE `ports` 0.0021090507507324
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00066208839416504
(51) DESCRIBE `ports` 0.0023448467254639
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 659))) 0.00054311752319336
(53) DESCRIBE `ports` 0.0020589828491211
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '659') 0.00068807601928711
(55) DESCRIBE `ports` 0.002683162689209
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1971))) 0.00070500373840332
(57) DESCRIBE `ports` 0.0024368762969971
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1971') 0.00063896179199219
(59) DESCRIBE `ports` 0.0027420520782471
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2991))) 0.0012619495391846
(61) DESCRIBE `ports` 0.0027580261230469
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2991') 0.00063109397888184
(63) DESCRIBE `ports` 0.0028941631317139
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 660))) 0.00065398216247559
(65) DESCRIBE `ports` 0.0026159286499023
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '660') 0.00059700012207031
(67) DESCRIBE `ports` 0.0027220249176025
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 658))) 0.00060701370239258
(69) DESCRIBE `ports` 0.0024540424346924
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '658') 0.00062012672424316
(71) DESCRIBE `avid_specials` 0.0023109912872314
(72) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78325 and class = 'Cruise') OR (item_id = 1404 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 49 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.0022008419036865
(73) DESCRIBE `cruiselines` 0.0037720203399658
(74) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00070905685424805
(75) DESCRIBE `orchid_image` 0.0028781890869141
(76) DESCRIBE `cruiselines` 0.0038149356842041
(77) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00073099136352539
(78) DESCRIBE `cruises` 0.0043690204620361
(79) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34711') 0.00057411193847656
(80) DESCRIBE `ships` 0.0045711994171143
(81) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 24))) 0.00080490112304688
(82) DESCRIBE `ships` 0.0050430297851562
(83) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '24') 0.00074911117553711
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046491622924805
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045394897460938
(86) DESCRIBE `itineraries` 0.0023131370544434
(87) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34711') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011589527130127
(88) DESCRIBE `ports` 0.002669095993042
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.0006098747253418
(90) DESCRIBE `ports` 0.0024621486663818
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00067305564880371
(92) DESCRIBE `ports` 0.0029029846191406
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00053715705871582
(94) DESCRIBE `sailingdates` 0.0024738311767578
(95) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34711') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0030889511108398
(96) DESCRIBE `ports` 0.0028951168060303
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.0005500316619873
(98) DESCRIBE `ports` 0.002202033996582
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00042390823364258
(100) DESCRIBE `ports` 0.0022079944610596
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00073003768920898
(102) DESCRIBE `ports` 0.0026059150695801
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00060200691223145
(104) DESCRIBE `ports` 0.0025291442871094
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00057196617126465
(106) DESCRIBE `ports` 0.0032849311828613
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00064802169799805
(108) DESCRIBE `avid_specials` 0.0022730827331543
(109) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34711 and class = 'Cruise') OR (item_id = 24 AND class = 'Ship') OR (item_id = 218 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.0017189979553223
(110) DESCRIBE `cruiselines` 0.0033600330352783
(111) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00071501731872559
(112) DESCRIBE `orchid_image` 0.0030360221862793
(113) DESCRIBE `cruiselines` 0.0033130645751953
(114) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00063514709472656
(115) DESCRIBE `cruises` 0.0045070648193359
(116) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52512') 0.00066113471984863
(117) DESCRIBE `ships` 0.0056891441345215
(118) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 9))) 0.00084018707275391
(119) DESCRIBE `ships` 0.0055868625640869
(120) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '9') 0.00069403648376465
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049114227294922
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048303604125977
(123) DESCRIBE `itineraries` 0.0027539730072021
(124) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52512') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015451908111572
(125) DESCRIBE `ports` 0.0027341842651367
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00074911117553711
(127) DESCRIBE `ports` 0.002655029296875
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00059700012207031
(129) DESCRIBE `ports` 0.0030009746551514
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00073003768920898
(131) DESCRIBE `sailingdates` 0.0026199817657471
(132) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52512') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001906156539917
(133) DESCRIBE `ports` 0.0033931732177734
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00081300735473633
(135) DESCRIBE `ports` 0.0027360916137695
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00055384635925293
(137) DESCRIBE `ports` 0.0025970935821533
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00063896179199219
(139) DESCRIBE `ports` 0.0027270317077637
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00080013275146484
(141) DESCRIBE `ports` 0.002979040145874
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00095605850219727
(143) DESCRIBE `ports` 0.0029091835021973
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00064897537231445
(145) DESCRIBE `ports` 0.0028791427612305
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00062084197998047
(147) DESCRIBE `ports` 0.0029351711273193
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00066399574279785
(149) DESCRIBE `avid_specials` 0.0029799938201904
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52512 and class = 'Cruise') OR (item_id = 9 AND class = 'Ship') OR (item_id = 218 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.0023031234741211
(151) DESCRIBE `cruiselines` 0.0040061473846436
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00071406364440918
(153) DESCRIBE `orchid_image` 0.0029351711273193
(154) DESCRIBE `cruiselines` 0.0040791034698486
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00074911117553711
(156) DESCRIBE `cruises` 0.0053269863128662
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56846') 0.00064897537231445
(158) DESCRIBE `ships` 0.0053989887237549
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 25))) 0.00086808204650879
(160) DESCRIBE `ships` 0.0048389434814453
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '25') 0.0007941722869873
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050902366638184
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049281120300293
(164) DESCRIBE `itineraries` 0.003101110458374
(165) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56846') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016880035400391
(166) DESCRIBE `ports` 0.0030231475830078
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00085282325744629
(168) DESCRIBE `ports` 0.0030620098114014
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00083303451538086
(170) DESCRIBE `ports` 0.0033960342407227
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00063896179199219
(172) DESCRIBE `sailingdates` 0.0024020671844482
(173) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56846') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016038417816162
(174) DESCRIBE `ports` 0.0033590793609619
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00077390670776367
(176) DESCRIBE `ports` 0.0030639171600342
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00064516067504883
(178) DESCRIBE `ports` 0.0025889873504639
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00060701370239258
(180) DESCRIBE `ports` 0.0024769306182861
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00051689147949219
(182) DESCRIBE `ports` 0.0024549961090088
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00054407119750977
(184) DESCRIBE `ports` 0.0024502277374268
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00052118301391602
(186) DESCRIBE `ports` 0.0024490356445312
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00065398216247559
(188) DESCRIBE `ports` 0.0024981498718262
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00058913230895996
(190) DESCRIBE `avid_specials` 0.0021591186523438
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56846 and class = 'Cruise') OR (item_id = 25 AND class = 'Ship') OR (item_id = 218 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.0013060569763184
(192) DESCRIBE `cruiselines` 0.003399133682251
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00066208839416504
(194) DESCRIBE `orchid_image` 0.0022878646850586
(195) DESCRIBE `cruiselines` 0.0033249855041504
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00069689750671387
(197) DESCRIBE `cruises` 0.0057690143585205
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57661') 0.00049710273742676
(199) DESCRIBE `ships` 0.0042610168457031
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 857))) 0.00056886672973633
(201) DESCRIBE `ships` 0.0041160583496094
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '857') 0.00046205520629883
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039196014404297
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(205) DESCRIBE `itineraries` 0.002100944519043
(206) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009310245513916
(207) DESCRIBE `ports` 0.0020961761474609
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00047707557678223
(209) DESCRIBE `ports` 0.0019669532775879
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00055789947509766
(211) DESCRIBE `ports` 0.0020930767059326
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00044107437133789
(213) DESCRIBE `sailingdates` 0.0017259120941162
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57661') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014491081237793
(215) DESCRIBE `ports` 0.002871036529541
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.0005800724029541
(217) DESCRIBE `ports` 0.0023131370544434
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00062108039855957
(219) DESCRIBE `ports` 0.0023930072784424
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00063896179199219
(221) DESCRIBE `ports` 0.0024459362030029
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00050091743469238
(223) DESCRIBE `ports` 0.0022909641265869
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00066995620727539
(225) DESCRIBE `ports` 0.0024020671844482
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00052714347839355
(227) DESCRIBE `ports` 0.002410888671875
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.0006561279296875
(229) DESCRIBE `ports` 0.0027389526367188
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00058817863464355
(231) DESCRIBE `ports` 0.0027430057525635
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00061893463134766
(233) DESCRIBE `ports` 0.0026578903198242
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00061607360839844
(235) DESCRIBE `avid_specials` 0.0016510486602783
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57661 and class = 'Cruise') OR (item_id = 857 AND class = 'Ship') OR (item_id = 195 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.0013260841369629
(237) DESCRIBE `cruiselines` 0.0028460025787354
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00047993659973145
(239) DESCRIBE `orchid_image` 0.0020129680633545
(240) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '195') 0.05599308013916
(241) DESCRIBE `cruiselines` 0.0034651756286621
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00063395500183105
(243) DESCRIBE `cruises` 0.0044550895690918
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59425') 0.0006258487701416
(245) DESCRIBE `ships` 0.0063650608062744
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1420))) 0.00084900856018066
(247) DESCRIBE `ships` 0.004666805267334
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1420') 0.00065779685974121
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044608116149902
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042414665222168
(251) DESCRIBE `itineraries` 0.0023739337921143
(252) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59425') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090193748474121
(253) DESCRIBE `sailingdates` 0.0021920204162598
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59425') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016179084777832
(255) DESCRIBE `itineraries` 0.0025689601898193
(256) DESCRIBE `itineraries` 0.002345085144043
(257) DESCRIBE `avid_specials` 0.0022268295288086
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59425 and class = 'Cruise') OR (item_id = 1420 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.0018320083618164
(259) DESCRIBE `cruiselines` 0.0033349990844727
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.0007789134979248
(261) DESCRIBE `orchid_image` 0.0027520656585693
(262) DESCRIBE `cruiselines` 0.0034070014953613
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00060796737670898
(264) DESCRIBE `cruises` 0.0043931007385254
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63227') 0.00059700012207031
(266) DESCRIBE `ships` 0.0046930313110352
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1040))) 0.00071287155151367
(268) DESCRIBE `ships` 0.004619836807251
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1040') 0.00056695938110352
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043201446533203
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048398971557617
(272) DESCRIBE `itineraries` 0.0023360252380371
(273) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63227') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011429786682129
(274) DESCRIBE `ports` 0.002601146697998
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00059318542480469
(276) DESCRIBE `ports` 0.0025911331176758
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0016789436340332
(278) DESCRIBE `ports` 0.0028018951416016
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00060701370239258
(280) DESCRIBE `sailingdates` 0.0022361278533936
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63227') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011570453643799
(282) DESCRIBE `ports` 0.0028069019317627
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0006558895111084
(284) DESCRIBE `ports` 0.0027251243591309
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00056219100952148
(286) DESCRIBE `ports` 0.0034711360931396
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.0008690357208252
(288) DESCRIBE `ports` 0.0037500858306885
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.00074100494384766
(290) DESCRIBE `ports` 0.0031788349151611
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.0007929801940918
(292) DESCRIBE `ports` 0.0032341480255127
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00080108642578125
(294) DESCRIBE `ports` 0.0032479763031006
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00080513954162598
(296) DESCRIBE `ports` 0.0031371116638184
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.00075387954711914
(298) DESCRIBE `ports` 0.0030741691589355
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00059390068054199
(300) DESCRIBE `ports` 0.002424955368042
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00046420097351074
(302) DESCRIBE `ports` 0.0022051334381104
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00059390068054199
(304) DESCRIBE `ports` 0.0020339488983154
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00044989585876465
(306) DESCRIBE `avid_specials` 0.0016219615936279
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63227 and class = 'Cruise') OR (item_id = 1040 AND class = 'Ship') OR (item_id = 144 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.0012390613555908
(308) DESCRIBE `cruiselines` 0.0028212070465088
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00092101097106934
(310) DESCRIBE `orchid_image` 0.0028049945831299
(311) DESCRIBE `cruiselines` 0.0035209655761719
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00049805641174316
(313) DESCRIBE `cruises` 0.0041279792785645
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63335') 0.00062179565429688
(315) DESCRIBE `ships` 0.0051679611206055
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1048))) 0.00082302093505859
(317) DESCRIBE `ships` 0.004586935043335
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1048') 0.00056004524230957
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042486190795898
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040817260742188
(321) DESCRIBE `itineraries` 0.0023159980773926
(322) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63335') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009911060333252
(323) DESCRIBE `ports` 0.0025100708007812
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00055718421936035
(325) DESCRIBE `ports` 0.0024449825286865
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00062394142150879
(327) DESCRIBE `ports` 0.0023300647735596
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00066304206848145
(329) DESCRIBE `sailingdates` 0.0020499229431152
(330) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63335') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00096511840820312
(331) DESCRIBE `ports` 0.0025670528411865
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00064396858215332
(333) DESCRIBE `ports` 0.00242018699646
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00053787231445312
(335) DESCRIBE `ports` 0.0024881362915039
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00064396858215332
(337) DESCRIBE `ports` 0.0028281211853027
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00060796737670898
(339) DESCRIBE `ports` 0.002608060836792
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00056719779968262
(341) DESCRIBE `ports` 0.0025980472564697
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00092792510986328
(343) DESCRIBE `ports` 0.003352165222168
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1068))) 0.00087094306945801
(345) DESCRIBE `ports` 0.0023698806762695
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1068') 0.00071096420288086
(347) DESCRIBE `ports` 0.002763032913208
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00094985961914062
(349) DESCRIBE `ports` 0.0028882026672363
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00065302848815918
(351) DESCRIBE `avid_specials` 0.0024969577789307
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63335 and class = 'Cruise') OR (item_id = 1048 AND class = 'Ship') OR (item_id = 144 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.002263069152832
(353) DESCRIBE `cruiselines` 0.0039000511169434
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00072097778320312
(355) DESCRIBE `orchid_image` 0.0028259754180908
(356) DESCRIBE `cruiselines` 0.0035369396209717
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00059199333190918
(358) DESCRIBE `cruises` 0.0046899318695068
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73753') 0.00061798095703125
(360) DESCRIBE `ships` 0.0052559375762939
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 439))) 0.00077605247497559
(362) DESCRIBE `ships` 0.006026029586792
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '439') 0.00098299980163574
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055694580078125
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004570484161377
(366) DESCRIBE `itineraries` 0.0030038356781006
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73753') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012519359588623
(368) DESCRIBE `ports` 0.0032210350036621
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0007021427154541
(370) DESCRIBE `ports` 0.0028519630432129
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00069499015808105
(372) DESCRIBE `ports` 0.0061221122741699
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00081110000610352
(374) DESCRIBE `sailingdates` 0.0028891563415527
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73753') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0023529529571533
(376) DESCRIBE `ports` 0.0029590129852295
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00083494186401367
(378) DESCRIBE `ports` 0.0031650066375732
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00080299377441406
(380) DESCRIBE `ports` 0.0046031475067139
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0098190307617188
(382) DESCRIBE `ports` 0.012900114059448
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.002155065536499
(384) DESCRIBE `ports` 0.0028209686279297
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00063896179199219
(386) DESCRIBE `ports` 0.0091450214385986
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00074100494384766
(388) DESCRIBE `avid_specials` 0.0031650066375732
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73753 and class = 'Cruise') OR (item_id = 439 AND class = 'Ship') OR (item_id = 218 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.002946138381958
(390) DESCRIBE `cruiselines` 0.0096049308776855
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00925612449646
(392) DESCRIBE `orchid_image` 0.0032501220703125
(393) DESCRIBE `cruiselines` 0.0046331882476807
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00066494941711426
(395) DESCRIBE `cruiselines` 0.0035858154296875
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '144', '12', '23', '183', '20', '101', '120', '31', '18', '8', '131', '7', '96', '171', '170', '103', '206', '33', '156', '15', '50', '262', '191', '29', '195', '258', '91', '16', '37', '153', '14', '28', '24', '208', '187', '36', '114', '47', '49', '251', '141', '88', '212', '151', '181', '110', '118', '4', '264', '30', '216', '59', '140', '108', '115', '73', '159', '48', '211', '213', '147', '35', '38', '113', '276', '90', '95', '180', '57', '52', '244', '64', '172', '257', '261', '184', '82', '134', '245', '105', '177', '209')) ORDER BY FIND_IN_SET(id, '77,218,19,26,144,12,23,183,20,101,120,31,18,8,131,7,96,171,170,103,206,33,156,15,50,262,191,29,195,258,91,16,37,153,14,28,24,208,187,36,114,47,49,251,141,88,212,151,181,110,118,4,264,30,216,59,140,108,115,73,159,48,211,213,147,35,38,113,276,90,95,180,57,52,244,64,172,257,261,184,82,134,245,105,177,209') 0.0098061561584473
(397) DESCRIBE `ships` 0.0062730312347412
(398) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '517', '1744', '732', '737', '1417', '726', '1324', '1554', '1588', '207', '1555', '1794', '1594', '454', '977', '1717', '521', '780', '1237', '1272', '974', '871', '258', '1032', '1359', '1424', '797', '265', '22', '404', '461', '21', '330', '770', '1292', '393', '28', '716', '1766', '1348', '1677', '1419', '1423', '520', '1420', '1422', '1418', '1421', '349', '857', '1205', '858', '1415', '1501', '333', '11', '986', '1682', '715', '738', '1067', '439', '739', '9', '10', '674', '25', '24', '855', '163', '837', '542', '1260', '1678', '455', '3', '1607', '882', '1768', '1008', '113', '407', '1402', '434', '1141', '610', '1135', '1773', '553', '480', '627', '332', '503', '792', '1742', '573', '1569', '160', '352', '386', '766', '817', '1454', '63', '1455', '66', '1721', '711', '1168', '1233', '1372', '1602', '198', '626', '657', '883', '1021', '1284', '285', '385', '585', '1413', '1410', '1599', '1302', '1411', '462', '1193', '1308', '1738', '111', '124', '526', '1259', '1266', '1320', '1323', '1579', '314', '1822', '286', '970', '1811', '43', '854', '1088', '327', '390', '582', '590', '1063', '1552', '1733', '485', '1145', '1586', '441', '748', '1068', '405', '944', '1321', '34', '38', '791', '1149', '31', '37', '119', '1492', '1722', '70', '678', '958', '1208', '1245', '1291', '1463', '1587', '1782', '14', '114', '162', '378', '406', '545', '616', '1028', '1711', '4', '351', '644', '658', '1027', '1412', '69', '335', '635', '850', '1157', '1672', '451', '1289', '1318', '1139', '1199', '1303', '1319', '401', '704', '1461', '341', '547', '722', '1108', '340', '580', '701', '1236', '1398', '105', '325', '403', '683', '1330', '601', '652', '966', '1013', '1408', '98', '148', '508', '1159', '1188', '1326', '1327', '1367', '1526', '201', '394', '651', '1151', '1575', '287', '348', '389', '818', '1172', '78', '291', '639', '1040', '39', '212', '338', '776', '1019', '1801', '30', '35', '36', '84', '123', '262', '988', '1012', '1037', '1043', '1743', '1809', '852', '1223', '1344', '1426', '1715', '27', '45', '266', '290', '673', '775', '1160', '1217', '1405', '1704', '1716', '1808', '483', '751', '1029', '1143', '1144', '1163', '1343', '1452', '1453', '1226', '1229', '1282', '1325', '1373', '1604', '574', '1358', '1724', '1730', '768', '968', '1095', '1283', '1409', '1740', '1772', '82', '905', '1035', '1137', '1152', '417', '769', '972', '1136', '1448', '108', '223', '253', '709', '1025', '1045', '1055', '1090', '1150', '1474', '151', '324', '851', '885', '1026', '1206', '1351', '150', '643', '663', '973', '1681', '1771', '116', '559', '884', '1230', '1231', '1458', '1713', '1750', '954', '1048', '1154', '1366', '1676', '1714', '1751', '1042', '1071', '1368', '1632', '1723', '208', '467', '665', '666', '924', '1049', '1196', '1322', '1360', '1361', '1362', '1459', '1708', '93', '784', '790', '920', '1051', '1052', '1140', '1148', '1483', '1609', '1649', '423', '921', '923', '996', '1293', '1301', '1580', '703', '888', '915', '1072', '1352', '1758', '147', '453', '916', '926', '930', '931', '1020', '1146', '1274', '1329', '75', '707', '1047', '1224', '1340', '1596', '1601', '1679', '1807', '1833', '205', '796', '886', '1004', '1039', '1073', '1109', '1241', '1262', '1389', '1445', '1468', '1519', '1539', '1571', '1791', '152', '422', '717', '1036', '1050', '1339', '1350', '516', '1054', '1075', '1486', '1574', '1749', '149', '730', '1044', '1294', '1759', '1767', '1788', '1806', '74', '81', '300', '656', '671', '672', '1232', '1256', '1572', '1664', '1673', '1816', '299', '1005', '1060', '1138', '1437', '1451', '1540', '1781', '1805', '420', '795', '821', '1225', '1254', '1444', '1823', '375', '448', '487', '743', '761', '982', '1011', '1663', '419', '493')) ORDER BY FIND_IN_SET(id, '1761,517,1744,732,737,1417,726,1324,1554,1588,207,1555,1794,1594,454,977,1717,521,780,1237,1272,974,871,258,1032,1359,1424,797,265,22,404,461,21,330,770,1292,393,28,716,1766,1348,1677,1419,1423,520,1420,1422,1418,1421,349,857,1205,858,1415,1501,333,11,986,1682,715,738,1067,439,739,9,10,674,25,24,855,163,837,542,1260,1678,455,3,1607,882,1768,1008,113,407,1402,434,1141,610,1135,1773,553,480,627,332,503,792,1742,573,1569,160,352,386,766,817,1454,63,1455,66,1721,711,1168,1233,1372,1602,198,626,657,883,1021,1284,285,385,585,1413,1410,1599,1302,1411,462,1193,1308,1738,111,124,526,1259,1266,1320,1323,1579,314,1822,286,970,1811,43,854,1088,327,390,582,590,1063,1552,1733,485,1145,1586,441,748,1068,405,944,1321,34,38,791,1149,31,37,119,1492,1722,70,678,958,1208,1245,1291,1463,1587,1782,14,114,162,378,406,545,616,1028,1711,4,351,644,658,1027,1412,69,335,635,850,1157,1672,451,1289,1318,1139,1199,1303,1319,401,704,1461,341,547,722,1108,340,580,701,1236,1398,105,325,403,683,1330,601,652,966,1013,1408,98,148,508,1159,1188,1326,1327,1367,1526,201,394,651,1151,1575,287,348,389,818,1172,78,291,639,1040,39,212,338,776,1019,1801,30,35,36,84,123,262,988,1012,1037,1043,1743,1809,852,1223,1344,1426,1715,27,45,266,290,673,775,1160,1217,1405,1704,1716,1808,483,751,1029,1143,1144,1163,1343,1452,1453,1226,1229,1282,1325,1373,1604,574,1358,1724,1730,768,968,1095,1283,1409,1740,1772,82,905,1035,1137,1152,417,769,972,1136,1448,108,223,253,709,1025,1045,1055,1090,1150,1474,151,324,851,885,1026,1206,1351,150,643,663,973,1681,1771,116,559,884,1230,1231,1458,1713,1750,954,1048,1154,1366,1676,1714,1751,1042,1071,1368,1632,1723,208,467,665,666,924,1049,1196,1322,1360,1361,1362,1459,1708,93,784,790,920,1051,1052,1140,1148,1483,1609,1649,423,921,923,996,1293,1301,1580,703,888,915,1072,1352,1758,147,453,916,926,930,931,1020,1146,1274,1329,75,707,1047,1224,1340,1596,1601,1679,1807,1833,205,796,886,1004,1039,1073,1109,1241,1262,1389,1445,1468,1519,1539,1571,1791,152,422,717,1036,1050,1339,1350,516,1054,1075,1486,1574,1749,149,730,1044,1294,1759,1767,1788,1806,74,81,300,656,671,672,1232,1256,1572,1664,1673,1816,299,1005,1060,1138,1437,1451,1540,1781,1805,420,795,821,1225,1254,1444,1823,375,448,487,743,761,982,1011,1663,419,493') 0.11085295677185
(399) DESCRIBE `cruisetypes` 0.0020351409912109
(400) DESCRIBE `destinations` 0.0047919750213623
(401) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '37', '2', '8', '44', '53', '55', '39', '28', '38', '26', '11', '40', '48', '7', '45', '21', '29', '49', '30', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,37,2,8,44,53,55,39,28,38,26,11,40,48,7,45,21,29,49,30,34,52,10,46,56,32') 0.005551815032959