or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 0.57608866691589

# Query Time
(1) connect 0.0015139579772949
(2) DESCRIBE `cruises` 0.0041358470916748
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72374, 79033, 79035, 80637, 23656, 52647, 56886, 59167, 59436, 69356)) ORDER BY FIND_IN_SET(id, '72374,79033,79035,80637,23656,52647,56886,59167,59436,69356') 0.0025739669799805
(4) DESCRIBE `cruises` 0.0033309459686279
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72374') 0.00043702125549316
(6) DESCRIBE `ships` 0.0033531188964844
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00052714347839355
(8) DESCRIBE `ships` 0.0035321712493896
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00039482116699219
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029993057250977
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031614303588867
(12) DESCRIBE `itineraries` 0.0016388893127441
(13) DESCRIBE `ports` 0.0022299289703369
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004270076751709
(15) DESCRIBE `ports` 0.0017428398132324
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034594535827637
(17) DESCRIBE `ports` 0.0014910697937012
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00032377243041992
(19) DESCRIBE `sailingdates` 0.0013771057128906
(20) DESCRIBE `ports` 0.001474142074585
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037384033203125
(22) DESCRIBE `ports` 0.0014188289642334
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00033998489379883
(24) DESCRIBE `ports` 0.0015859603881836
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00037288665771484
(26) DESCRIBE `ports` 0.0016279220581055
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00036096572875977
(28) DESCRIBE `ports` 0.0019781589508057
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00034284591674805
(30) DESCRIBE `ports` 0.0014820098876953
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0003049373626709
(32) DESCRIBE `ports` 0.0013859272003174
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00034308433532715
(34) DESCRIBE `ports` 0.0014688968658447
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0002892017364502
(36) DESCRIBE `ports` 0.0013389587402344
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034213066101074
(38) DESCRIBE `ports` 0.0013539791107178
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003209114074707
(40) DESCRIBE `avid_specials` 0.0014679431915283
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72374 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0018939971923828
(42) DESCRIBE `cruiselines` 0.0026919841766357
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00048494338989258
(44) DESCRIBE `orchid_image` 0.0015969276428223
(45) DESCRIBE `cruiselines` 0.0027718544006348
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00044012069702148
(47) DESCRIBE `cruises` 0.0036590099334717
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79033') 0.00036120414733887
(49) DESCRIBE `ships` 0.0029950141906738
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1268))) 0.00046300888061523
(51) DESCRIBE `ships` 0.0032360553741455
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1268') 0.00048112869262695
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032591819763184
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(55) DESCRIBE `itineraries` 0.0017108917236328
(56) DESCRIBE `ports` 0.0016121864318848
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00038814544677734
(58) DESCRIBE `ports` 0.0014281272888184
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00036001205444336
(60) DESCRIBE `ports` 0.0013828277587891
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00031518936157227
(62) DESCRIBE `sailingdates` 0.0011918544769287
(63) DESCRIBE `ports` 0.0014500617980957
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00039100646972656
(65) DESCRIBE `ports` 0.0015718936920166
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00041985511779785
(67) DESCRIBE `ports` 0.0018219947814941
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00048398971557617
(69) DESCRIBE `ports` 0.0017290115356445
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00046110153198242
(71) DESCRIBE `ports` 0.0015420913696289
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00044989585876465
(73) DESCRIBE `ports` 0.00152587890625
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00034999847412109
(75) DESCRIBE `ports` 0.0017271041870117
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00042295455932617
(77) DESCRIBE `ports` 0.0016608238220215
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00048089027404785
(79) DESCRIBE `ports` 0.0016300678253174
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00057411193847656
(81) DESCRIBE `ports` 0.0020489692687988
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00044584274291992
(83) DESCRIBE `avid_specials` 0.0017988681793213
(84) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79033 and class = 'Cruise') OR (item_id = 1268 AND class = 'Ship') OR (item_id = 239 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.0018689632415771
(85) DESCRIBE `cruiselines` 0.0027091503143311
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00065493583679199
(87) DESCRIBE `orchid_image` 0.0022091865539551
(88) DESCRIBE `cruiselines` 0.0021519660949707
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00049209594726562
(90) DESCRIBE `cruises` 0.0038399696350098
(91) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79035') 0.0004580020904541
(92) DESCRIBE `ships` 0.0033359527587891
(93) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1561))) 0.00047516822814941
(94) DESCRIBE `ships` 0.0025730133056641
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1561') 0.00035500526428223
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028705596923828
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(98) DESCRIBE `itineraries` 0.00130295753479
(99) DESCRIBE `ports` 0.0016088485717773
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00046896934509277
(101) DESCRIBE `ports` 0.0015599727630615
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00032305717468262
(103) DESCRIBE `ports` 0.0014121532440186
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00039911270141602
(105) DESCRIBE `sailingdates` 0.0017740726470947
(106) DESCRIBE `ports` 0.0014829635620117
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00050187110900879
(108) DESCRIBE `ports` 0.001676082611084
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00034785270690918
(110) DESCRIBE `ports` 0.0013511180877686
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00043487548828125
(112) DESCRIBE `ports` 0.0014791488647461
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00031900405883789
(114) DESCRIBE `ports` 0.001533031463623
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00040292739868164
(116) DESCRIBE `ports` 0.0015039443969727
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00031089782714844
(118) DESCRIBE `ports` 0.0014159679412842
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00032186508178711
(120) DESCRIBE `ports` 0.0015261173248291
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00033402442932129
(122) DESCRIBE `ports` 0.0013790130615234
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.0004279613494873
(124) DESCRIBE `ports` 0.0016899108886719
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00037598609924316
(126) DESCRIBE `avid_specials` 0.0015380382537842
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79035 and class = 'Cruise') OR (item_id = 1561 AND class = 'Ship') OR (item_id = 239 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.0013618469238281
(128) DESCRIBE `cruiselines` 0.0022897720336914
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00043511390686035
(130) DESCRIBE `orchid_image` 0.0018720626831055
(131) DESCRIBE `cruiselines` 0.0019447803497314
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00048089027404785
(133) DESCRIBE `cruises` 0.0027320384979248
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80637') 0.00032997131347656
(135) DESCRIBE `ships` 0.0027670860290527
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00045490264892578
(137) DESCRIBE `ships` 0.0026359558105469
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00034284591674805
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002901554107666
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036215782165527
(141) DESCRIBE `itineraries` 0.0019528865814209
(142) DESCRIBE `ports` 0.0015361309051514
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034213066101074
(144) DESCRIBE `ports` 0.0013668537139893
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00033092498779297
(146) DESCRIBE `ports` 0.0013539791107178
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00031685829162598
(148) DESCRIBE `sailingdates` 0.00130295753479
(149) DESCRIBE `ports` 0.0018110275268555
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037002563476562
(151) DESCRIBE `ports` 0.0015439987182617
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003199577331543
(153) DESCRIBE `ports` 0.0014369487762451
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00036883354187012
(155) DESCRIBE `ports` 0.0014610290527344
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00029110908508301
(157) DESCRIBE `ports` 0.0014700889587402
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030398368835449
(159) DESCRIBE `ports` 0.0013840198516846
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0003359317779541
(161) DESCRIBE `ports` 0.0014259815216064
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0003209114074707
(163) DESCRIBE `ports` 0.0013890266418457
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00030088424682617
(165) DESCRIBE `ports` 0.0013530254364014
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003209114074707
(167) DESCRIBE `ports` 0.0014162063598633
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00030994415283203
(169) DESCRIBE `avid_specials` 0.0012578964233398
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80637 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.0014669895172119
(171) DESCRIBE `cruiselines` 0.001964807510376
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042605400085449
(173) DESCRIBE `orchid_image` 0.0015950202941895
(174) DESCRIBE `cruiselines` 0.0019021034240723
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00032210350036621
(176) DESCRIBE `cruises` 0.0026841163635254
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '23656') 0.00048112869262695
(178) DESCRIBE `ships` 0.0031118392944336
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 749))) 0.00057888031005859
(180) DESCRIBE `ships` 0.0038089752197266
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '749') 0.00046515464782715
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003809928894043
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(184) DESCRIBE `itineraries` 0.002039909362793
(185) DESCRIBE `ports` 0.0018961429595947
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00057101249694824
(187) DESCRIBE `ports` 0.0019478797912598
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00044393539428711
(189) DESCRIBE `ports` 0.0019259452819824
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00034499168395996
(191) DESCRIBE `sailingdates` 0.0013120174407959
(192) DESCRIBE `ports` 0.0017690658569336
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00043582916259766
(194) DESCRIBE `ports` 0.0013980865478516
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00033187866210938
(196) DESCRIBE `ports` 0.0014140605926514
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2205))) 0.00048303604125977
(198) DESCRIBE `ports` 0.0013630390167236
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2205') 0.00042080879211426
(200) DESCRIBE `ports` 0.001478910446167
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00033903121948242
(202) DESCRIBE `ports` 0.0014829635620117
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00031208992004395
(204) DESCRIBE `ports` 0.0013329982757568
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00034308433532715
(206) DESCRIBE `ports` 0.0013880729675293
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00026488304138184
(208) DESCRIBE `ports` 0.0014569759368896
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3100))) 0.00034999847412109
(210) DESCRIBE `ports` 0.0013389587402344
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3100') 0.00029087066650391
(212) DESCRIBE `ports` 0.0014479160308838
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00036001205444336
(214) DESCRIBE `ports` 0.0013730525970459
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00036501884460449
(216) DESCRIBE `ports` 0.0015218257904053
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00043797492980957
(218) DESCRIBE `ports` 0.0019938945770264
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.0003359317779541
(220) DESCRIBE `avid_specials` 0.0012729167938232
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 23656 and class = 'Cruise') OR (item_id = 749 AND class = 'Ship') OR (item_id = 174 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.0012290477752686
(222) DESCRIBE `cruiselines` 0.0020160675048828
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00043702125549316
(224) DESCRIBE `orchid_image` 0.0017139911651611
(225) DESCRIBE `cruiselines` 0.002086877822876
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00049400329589844
(227) DESCRIBE `cruises` 0.0040600299835205
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52647') 0.00055599212646484
(229) DESCRIBE `ships` 0.0037529468536377
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 21))) 0.00065183639526367
(231) DESCRIBE `ships` 0.0042071342468262
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '21') 0.00057792663574219
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040388107299805
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042319297790527
(235) DESCRIBE `itineraries` 0.0021088123321533
(236) DESCRIBE `ports` 0.0020759105682373
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00053000450134277
(238) DESCRIBE `ports` 0.0020589828491211
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00050997734069824
(240) DESCRIBE `ports` 0.0020029544830322
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00041604042053223
(242) DESCRIBE `sailingdates` 0.0017781257629395
(243) DESCRIBE `ports` 0.0024518966674805
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00052690505981445
(245) DESCRIBE `ports` 0.0034239292144775
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00052905082702637
(247) DESCRIBE `ports` 0.0016617774963379
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00060391426086426
(249) DESCRIBE `ports` 0.0014309883117676
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00036001205444336
(251) DESCRIBE `ports` 0.0018799304962158
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00044488906860352
(253) DESCRIBE `ports` 0.0015220642089844
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00031089782714844
(255) DESCRIBE `avid_specials` 0.0012609958648682
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52647 and class = 'Cruise') OR (item_id = 21 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.0016710758209229
(257) DESCRIBE `cruiselines` 0.0027761459350586
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00049281120300293
(259) DESCRIBE `orchid_image` 0.0021789073944092
(260) DESCRIBE `cruiselines` 0.0023128986358643
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00033807754516602
(262) DESCRIBE `cruises` 0.0028190612792969
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56886') 0.00033807754516602
(264) DESCRIBE `ships` 0.0073249340057373
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00046992301940918
(266) DESCRIBE `ships` 0.0047919750213623
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00040793418884277
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(270) DESCRIBE `itineraries` 0.0020220279693604
(271) DESCRIBE `ports` 0.0015010833740234
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043702125549316
(273) DESCRIBE `ports` 0.0013718605041504
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033807754516602
(275) DESCRIBE `ports` 0.0015840530395508
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00029397010803223
(277) DESCRIBE `sailingdates` 0.0018510818481445
(278) DESCRIBE `ports` 0.0018820762634277
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042414665222168
(280) DESCRIBE `ports` 0.0014660358428955
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00032711029052734
(282) DESCRIBE `ports` 0.0013570785522461
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00032496452331543
(284) DESCRIBE `ports` 0.0014381408691406
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00036501884460449
(286) DESCRIBE `ports` 0.0018870830535889
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00034785270690918
(288) DESCRIBE `ports` 0.0014009475708008
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0010790824890137
(290) DESCRIBE `avid_specials` 0.00148606300354
(291) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56886 and class = 'Cruise') OR (item_id = 461 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.0010669231414795
(292) DESCRIBE `cruiselines` 0.0023698806762695
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00035214424133301
(294) DESCRIBE `orchid_image` 0.001471996307373
(295) DESCRIBE `cruiselines` 0.0024480819702148
(296) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00041794776916504
(297) DESCRIBE `cruises` 0.0029239654541016
(298) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59167') 0.00039911270141602
(299) DESCRIBE `ships` 0.0031020641326904
(300) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.00046610832214355
(301) DESCRIBE `ships` 0.002781867980957
(302) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00042200088500977
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030303001403809
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002899169921875
(305) DESCRIBE `itineraries` 0.0014731884002686
(306) DESCRIBE `ports` 0.0017061233520508
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00041890144348145
(308) DESCRIBE `ports` 0.0014090538024902
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.0003199577331543
(310) DESCRIBE `ports` 0.0015521049499512
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00028586387634277
(312) DESCRIBE `sailingdates` 0.0011751651763916
(313) DESCRIBE `ports` 0.0020639896392822
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00044393539428711
(315) DESCRIBE `ports` 0.0013711452484131
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00031614303588867
(317) DESCRIBE `ports` 0.0013918876647949
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003509521484375
(319) DESCRIBE `ports` 0.001439094543457
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003049373626709
(321) DESCRIBE `ports` 0.0018439292907715
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00048398971557617
(323) DESCRIBE `ports` 0.0016019344329834
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00033378601074219
(325) DESCRIBE `ports` 0.0016980171203613
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00033903121948242
(327) DESCRIBE `ports` 0.0013630390167236
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00027894973754883
(329) DESCRIBE `avid_specials` 0.0012390613555908
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59167 and class = 'Cruise') OR (item_id = 480 AND class = 'Ship') OR (item_id = 108 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.0011959075927734
(331) DESCRIBE `cruiselines` 0.0020411014556885
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00037598609924316
(333) DESCRIBE `orchid_image` 0.001910924911499
(334) DESCRIBE `cruiselines` 0.0025579929351807
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.00043201446533203
(336) DESCRIBE `cruises` 0.0036699771881104
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59436') 0.00035905838012695
(338) DESCRIBE `ships` 0.0026988983154297
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1424))) 0.00052809715270996
(340) DESCRIBE `ships` 0.0028800964355469
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1424') 0.00052404403686523
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029301643371582
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030183792114258
(344) DESCRIBE `itineraries` 0.0016040802001953
(345) DESCRIBE `ports` 0.0018198490142822
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00050616264343262
(347) DESCRIBE `ports` 0.0017430782318115
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0004580020904541
(349) DESCRIBE `ports` 0.0016000270843506
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0004429817199707
(351) DESCRIBE `sailingdates` 0.0014488697052002
(352) DESCRIBE `ports` 0.0016422271728516
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00036311149597168
(354) DESCRIBE `ports` 0.0013439655303955
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00032496452331543
(356) DESCRIBE `ports` 0.001478910446167
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00032687187194824
(358) DESCRIBE `ports` 0.0014169216156006
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00027108192443848
(360) DESCRIBE `ports` 0.0013020038604736
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00029993057250977
(362) DESCRIBE `ports` 0.0013351440429688
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00026512145996094
(364) DESCRIBE `ports` 0.0014309883117676
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00038290023803711
(366) DESCRIBE `ports` 0.0014200210571289
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00037598609924316
(368) DESCRIBE `ports` 0.0014288425445557
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00040602684020996
(370) DESCRIBE `ports` 0.0013139247894287
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00028681755065918
(372) DESCRIBE `ports` 0.0014059543609619
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.0003211498260498
(374) DESCRIBE `ports` 0.00148606300354
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00029301643371582
(376) DESCRIBE `avid_specials` 0.0012040138244629
(377) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59436 and class = 'Cruise') OR (item_id = 1424 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.001162052154541
(378) DESCRIBE `cruiselines` 0.001939058303833
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00037384033203125
(380) DESCRIBE `orchid_image` 0.0015029907226562
(381) DESCRIBE `cruiselines` 0.0020079612731934
(382) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00042104721069336
(383) DESCRIBE `cruises` 0.0027740001678467
(384) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69356') 0.00034809112548828
(385) DESCRIBE `ships` 0.0028340816497803
(386) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00045609474182129
(387) DESCRIBE `ships` 0.002636194229126
(388) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00036883354187012
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029492378234863
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027704238891602
(391) DESCRIBE `itineraries` 0.0013039112091064
(392) DESCRIBE `ports` 0.001417875289917
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00033402442932129
(394) DESCRIBE `ports` 0.0013561248779297
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00034523010253906
(396) DESCRIBE `ports` 0.0013341903686523
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00029301643371582
(398) DESCRIBE `sailingdates` 0.0012500286102295
(399) DESCRIBE `ports` 0.0014231204986572
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00033783912658691
(401) DESCRIBE `ports` 0.0013189315795898
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.0002892017364502
(403) DESCRIBE `ports` 0.00136399269104
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00030612945556641
(405) DESCRIBE `ports` 0.0013489723205566
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00029087066650391
(407) DESCRIBE `ports` 0.0016279220581055
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00032496452331543
(409) DESCRIBE `ports` 0.0014340877532959
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00029206275939941
(411) DESCRIBE `ports` 0.0013208389282227
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00032401084899902
(413) DESCRIBE `ports` 0.0013229846954346
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00028514862060547
(415) DESCRIBE `avid_specials` 0.0011539459228516
(416) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69356 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.0010581016540527
(417) DESCRIBE `cruiselines` 0.0018730163574219
(418) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00033402442932129
(419) DESCRIBE `orchid_image` 0.0018219947814941
(420) DESCRIBE `cruiselines` 0.0021450519561768
(421) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00037693977355957
(422) DESCRIBE `cruiselines` 0.0019960403442383
(423) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '183', '19', '23', '12', '7', '20', '131', '18', '8', '144', '171', '221', '31', '103', '101', '268', '15', '232', '156', '96', '258', '239', '50', '251', '29', '206', '33', '191', '114', '91', '212', '14', '24', '120', '28', '37', '187', '16', '170', '262', '49', '256', '36', '204', '110', '47', '208', '195', '240', '146', '220', '181', '153', '118', '174', '229', '30', '151', '88', '108', '128', '141', '159', '35', '216', '236', '168', '196', '4', '249', '38', '200', '264', '90', '211', '238', '73', '225', '140', '113', '147', '39', '275', '57', '132', '184', '59', '213', '48', '257', '64', '276', '261', '182', '219', '230', '115', '188', '237', '95', '180', '231', '248', '52', '116', '266', '209', '105', '82', '235', '244', '62', '134', '119', '177', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,26,183,19,23,12,7,20,131,18,8,144,171,221,31,103,101,268,15,232,156,96,258,239,50,251,29,206,33,191,114,91,212,14,24,120,28,37,187,16,170,262,49,256,36,204,110,47,208,195,240,146,220,181,153,118,174,229,30,151,88,108,128,141,159,35,216,236,168,196,4,249,38,200,264,90,211,238,73,225,140,113,147,39,275,57,132,184,59,213,48,257,64,276,261,182,219,230,115,188,237,95,180,231,248,52,116,266,209,105,82,235,244,62,134,119,177,210,224,245') 0.0084869861602783
(424) DESCRIBE `ships` 0.0031309127807617
(425) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1324', '1555', '1272', '517', '1794', '780', '986', '974', '1032', '258', '1292', '22', '461', '21', '797', '393', '330', '28', '977', '207', '1599', '1205', '480', '349', '11', '10', '439', '1291', '737', '333', '1010', '9', '404', '739', '1199', '1588', '1135', '1417', '265', '726', '817', '1677', '14', '855', '24', '882', '25', '770', '454', '711', '1607', '3', '113', '731', '1067', '1481', '859', '1359', '1372', '34', '38', '31', '37', '657', '837', '378', '585', '1461', '1744', '985', '1237', '1768', '1239', '542', '1163', '66', '1526', '1413', '748', '390', '1320', '1411', '1579', '1323', '1402', '1424', '332', '526', '970', '1410', '1419', '1420', '1422', '1423', '1594', '43', '573', '327', '854', '1418', '1421', '582', '1773', '39', '407', '1012', '1454', '30', '36', '590', '958', '27', '1013', '1586', '674', '791', '792', '1284', '1415', '1308', '580', '1303', '1326', '1327', '84', '114', '1552', '441', '1183', '335', '455', '1184', '1587', '1682', '35', '1245', '1193', '1236', '1742', '386', '162', '1348', '160', '325', '722', '1412', '385', '639', '434', '521', '601', '1408', '1678', '81', '1168', '452', '683', '852', '857', '1172', '1215', '1382', '1501', '858', '1021', '1176', '775', '1019', '1289', '1376', '119', '1574', '78', '201', '338', '658', '1008', '1160', '1405', '1716', '285', '673', '766', '1159', '1217', '1229', '1604', '1373', '1426', '1782', '610', '776', '1095', '1226', '1743', '111', '462', '850', '1137', '1141', '1711', '69', '211', '644', '678', '1136', '1319', '1325', '1448', '163', '286', '1383', '1384', '1628', '45', '253', '520', '851', '1358', '403', '818', '266', '314', '651', '749', '1068', '1259', '1266', '1455', '151', '968', '1458', '1569', '1630', '451', '508', '1108', '1632', '348', '467', '626', '1516', '1572', '4', '150', '1302', '1330', '1360', '1361', '1362', '63', '324', '375', '405', '869', '966', '1260', '1368', '1459', '1627', '70', '148', '389', '421', '485', '616', '663', '768', '944', '1639', '1751', '1760', '116', '262', '291', '553', '885', '1064', '1148', '1517', '1562', '1672', '1708', '108', '1301', '1322', '123', '340', '1139', '1195', '1614', '1721', '124', '287', '1343', '1452', '1521', '1580', '1581', '98', '703', '784', '954', '1088', '1717', '198', '883', '1020', '152', '290', '1212', '1321', '1575', '1724', '635', '652', '1208', '1486', '1492', '1611', '1722', '1750', '1781', '516', '1344', '1601', '147', '483', '1615', '394', '401', '796', '1150', '1398', '1714', '1738', '341', '1143', '1231', '1269', '1437', '1445', '1522', '223', '406', '559', '1230', '1496', '1539', '1771', '1040', '1075', '1268', '149', '886', '1262', '1444', '1571', '1679', '1681', '547', '717', '1151', '1270', '1557', '1593', '1673', '1684', '545', '656', '704', '716', '1367', '982', '1254', '1318', '1676', '74', '105', '761', '1740', '1766', '494', '1043', '1073', '1514', '1518', '1645', '75', '205', '574', '1144', '1157', '1218', '1566', '1704', '1767', '751', '790', '1223', '1561', '1728', '715', '1027', '1029', '1063', '1213', '1389', '82', '351', '627', '795', '808', '1082', '1453', '1471', '1540', '93', '212', '687', '868', '1025', '1090', '1146', '1158', '1283', '1612', '1613', '1706', '1709', '1729', '1772', '479', '503', '823', '1055', '1713', '1715', '665', '905', '996', '1026', '1214', '1233', '1282', '1316', '1342', '1515', '1791', '493', '767', '1145', '1188', '1297', '1409', '1783', '884', '888', '973', '1034', '1089', '1149', '1156', '1341', '1351', '1366', '1404', '1609', '695', '707', '979', '988', '1024', '1049', '1155', '1196', '1216', '1222', '1345', '1647', '1710', '1730', '417', '666', '685', '920', '921', '927', '931', '1047', '1113', '1296', '1311', '1340', '1354', '1788')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1324,1555,1272,517,1794,780,986,974,1032,258,1292,22,461,21,797,393,330,28,977,207,1599,1205,480,349,11,10,439,1291,737,333,1010,9,404,739,1199,1588,1135,1417,265,726,817,1677,14,855,24,882,25,770,454,711,1607,3,113,731,1067,1481,859,1359,1372,34,38,31,37,657,837,378,585,1461,1744,985,1237,1768,1239,542,1163,66,1526,1413,748,390,1320,1411,1579,1323,1402,1424,332,526,970,1410,1419,1420,1422,1423,1594,43,573,327,854,1418,1421,582,1773,39,407,1012,1454,30,36,590,958,27,1013,1586,674,791,792,1284,1415,1308,580,1303,1326,1327,84,114,1552,441,1183,335,455,1184,1587,1682,35,1245,1193,1236,1742,386,162,1348,160,325,722,1412,385,639,434,521,601,1408,1678,81,1168,452,683,852,857,1172,1215,1382,1501,858,1021,1176,775,1019,1289,1376,119,1574,78,201,338,658,1008,1160,1405,1716,285,673,766,1159,1217,1229,1604,1373,1426,1782,610,776,1095,1226,1743,111,462,850,1137,1141,1711,69,211,644,678,1136,1319,1325,1448,163,286,1383,1384,1628,45,253,520,851,1358,403,818,266,314,651,749,1068,1259,1266,1455,151,968,1458,1569,1630,451,508,1108,1632,348,467,626,1516,1572,4,150,1302,1330,1360,1361,1362,63,324,375,405,869,966,1260,1368,1459,1627,70,148,389,421,485,616,663,768,944,1639,1751,1760,116,262,291,553,885,1064,1148,1517,1562,1672,1708,108,1301,1322,123,340,1139,1195,1614,1721,124,287,1343,1452,1521,1580,1581,98,703,784,954,1088,1717,198,883,1020,152,290,1212,1321,1575,1724,635,652,1208,1486,1492,1611,1722,1750,1781,516,1344,1601,147,483,1615,394,401,796,1150,1398,1714,1738,341,1143,1231,1269,1437,1445,1522,223,406,559,1230,1496,1539,1771,1040,1075,1268,149,886,1262,1444,1571,1679,1681,547,717,1151,1270,1557,1593,1673,1684,545,656,704,716,1367,982,1254,1318,1676,74,105,761,1740,1766,494,1043,1073,1514,1518,1645,75,205,574,1144,1157,1218,1566,1704,1767,751,790,1223,1561,1728,715,1027,1029,1063,1213,1389,82,351,627,795,808,1082,1453,1471,1540,93,212,687,868,1025,1090,1146,1158,1283,1612,1613,1706,1709,1729,1772,479,503,823,1055,1713,1715,665,905,996,1026,1214,1233,1282,1316,1342,1515,1791,493,767,1145,1188,1297,1409,1783,884,888,973,1034,1089,1149,1156,1341,1351,1366,1404,1609,695,707,979,988,1024,1049,1155,1196,1216,1222,1345,1647,1710,1730,417,666,685,920,921,927,931,1047,1113,1296,1311,1340,1354,1788') 0.05599308013916
(426) DESCRIBE `cruisetypes` 0.0017268657684326
(427) DESCRIBE `destinations` 0.0022029876708984
(428) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '9', '37', '43', '2', '8', '39', '44', '53', '55', '26', '28', '38', '49', '11', '21', '40', '7', '48', '56', '46', '30', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,9,37,43,2,8,39,44,53,55,26,28,38,49,11,21,40,7,48,56,46,30,29,45,34,10,52,32') 0.0022919178009033