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

Total elapsed time: 1.0143842697144

# Query Time
(1) connect 0.0012540817260742
(2) DESCRIBE `cruises` 0.004317045211792
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71918, 34171, 75764, 76520, 78628, 75141, 75015, 45864, 52324, 74667)) ORDER BY FIND_IN_SET(id, '71918,34171,75764,76520,78628,75141,75015,45864,52324,74667') 0.0020170211791992
(4) DESCRIBE `cruises` 0.0041320323944092
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71918') 0.0003969669342041
(6) DESCRIBE `ships` 0.0040349960327148
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00061702728271484
(8) DESCRIBE `ships` 0.0040948390960693
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00059700012207031
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033903121948242
(12) DESCRIBE `itineraries` 0.0017271041870117
(13) DESCRIBE `ports` 0.0020811557769775
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00045013427734375
(15) DESCRIBE `ports` 0.0019950866699219
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00041818618774414
(17) DESCRIBE `ports` 0.0019829273223877
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00043702125549316
(19) DESCRIBE `sailingdates` 0.0027351379394531
(20) DESCRIBE `ports` 0.0021088123321533
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00045990943908691
(22) DESCRIBE `ports` 0.001690149307251
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00037789344787598
(24) DESCRIBE `ports` 0.001662015914917
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00038313865661621
(26) DESCRIBE `ports` 0.0016899108886719
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040292739868164
(28) DESCRIBE `ports` 0.0018241405487061
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00042510032653809
(30) DESCRIBE `ports` 0.001788854598999
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00040197372436523
(32) DESCRIBE `ports` 0.0019419193267822
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00066494941711426
(34) DESCRIBE `ports` 0.0022609233856201
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00051403045654297
(36) DESCRIBE `ports` 0.0019299983978271
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00045895576477051
(38) DESCRIBE `ports` 0.001802921295166
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00039219856262207
(40) DESCRIBE `ports` 0.0018680095672607
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00041389465332031
(42) DESCRIBE `ports` 0.0019538402557373
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00037908554077148
(44) DESCRIBE `ports` 0.001816987991333
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00043416023254395
(46) DESCRIBE `ports` 0.0014770030975342
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00036001205444336
(48) DESCRIBE `ports` 0.0014441013336182
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00038409233093262
(50) DESCRIBE `ports` 0.0015068054199219
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00032305717468262
(52) DESCRIBE `ports` 0.0014009475708008
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00039482116699219
(54) DESCRIBE `ports` 0.0014450550079346
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0003349781036377
(56) DESCRIBE `ports` 0.0017271041870117
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00036001205444336
(58) DESCRIBE `ports` 0.0014591217041016
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00035309791564941
(60) DESCRIBE `ports` 0.001594066619873
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00040411949157715
(62) DESCRIBE `ports` 0.0019450187683105
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00057196617126465
(64) DESCRIBE `ports` 0.0018439292907715
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00061202049255371
(66) DESCRIBE `ports` 0.001884937286377
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00036120414733887
(68) DESCRIBE `ports` 0.0015151500701904
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00037503242492676
(70) DESCRIBE `ports` 0.001957893371582
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00046777725219727
(72) DESCRIBE `ports` 0.0018379688262939
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00043201446533203
(74) DESCRIBE `ports` 0.0015230178833008
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00049090385437012
(76) DESCRIBE `ports` 0.0017919540405273
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00042200088500977
(78) DESCRIBE `ports` 0.0019481182098389
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00039911270141602
(80) DESCRIBE `ports` 0.0019569396972656
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00041103363037109
(82) DESCRIBE `ports` 0.0017361640930176
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00034213066101074
(84) DESCRIBE `ports` 0.0014939308166504
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0003809928894043
(86) DESCRIBE `ports` 0.0017120838165283
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00034809112548828
(88) DESCRIBE `ports` 0.0015230178833008
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00036287307739258
(90) DESCRIBE `ports` 0.0018670558929443
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00047016143798828
(92) DESCRIBE `avid_specials` 0.001723051071167
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71918 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 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.0016200542449951
(94) DESCRIBE `cruiselines` 0.0026769638061523
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00047802925109863
(96) DESCRIBE `orchid_image` 0.0020840167999268
(97) DESCRIBE `cruiselines` 0.002338171005249
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00045180320739746
(99) DESCRIBE `cruises` 0.0036840438842773
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34171') 0.00041604042053223
(101) DESCRIBE `ships` 0.0034918785095215
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 39))) 0.00060701370239258
(103) DESCRIBE `ships` 0.0033049583435059
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '39') 0.00045895576477051
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035190582275391
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042986869812012
(107) DESCRIBE `itineraries` 0.0015099048614502
(108) DESCRIBE `ports` 0.0017988681793213
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045585632324219
(110) DESCRIBE `ports` 0.0017299652099609
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00036787986755371
(112) DESCRIBE `ports` 0.0013759136199951
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00035905838012695
(114) DESCRIBE `sailingdates` 0.001194953918457
(115) DESCRIBE `ports` 0.0021450519561768
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00053811073303223
(117) DESCRIBE `ports` 0.0018270015716553
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0003969669342041
(119) DESCRIBE `ports` 0.0017139911651611
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00043487548828125
(121) DESCRIBE `ports` 0.0016639232635498
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00040912628173828
(123) DESCRIBE `ports` 0.001945972442627
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00046300888061523
(125) DESCRIBE `ports` 0.0016758441925049
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.0004270076751709
(127) DESCRIBE `ports` 0.0020320415496826
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.0010499954223633
(129) DESCRIBE `ports` 0.0019941329956055
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0003960132598877
(131) DESCRIBE `ports` 0.0018119812011719
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00040006637573242
(133) DESCRIBE `ports` 0.0015969276428223
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00030398368835449
(135) DESCRIBE `ports` 0.0013828277587891
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00034809112548828
(137) DESCRIBE `ports` 0.0013649463653564
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00027704238891602
(139) DESCRIBE `ports` 0.0015201568603516
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00039315223693848
(141) DESCRIBE `ports` 0.0015671253204346
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00036311149597168
(143) DESCRIBE `ports` 0.0016489028930664
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00032305717468262
(145) DESCRIBE `ports` 0.0014381408691406
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00032806396484375
(147) DESCRIBE `ports` 0.0014779567718506
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00030088424682617
(149) DESCRIBE `ports` 0.0014729499816895
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00029587745666504
(151) DESCRIBE `ports` 0.0015838146209717
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00033092498779297
(153) DESCRIBE `ports` 0.0013689994812012
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00029492378234863
(155) DESCRIBE `ports` 0.0013420581817627
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00032496452331543
(157) DESCRIBE `ports` 0.0018420219421387
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.0004429817199707
(159) DESCRIBE `ports` 0.0018758773803711
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00042390823364258
(161) DESCRIBE `ports` 0.0018870830535889
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00066804885864258
(163) DESCRIBE `ports` 0.0021481513977051
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00050711631774902
(165) DESCRIBE `ports` 0.0019521713256836
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00039911270141602
(167) DESCRIBE `ports` 0.0018258094787598
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00041294097900391
(169) DESCRIBE `ports` 0.0018961429595947
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.0004730224609375
(171) DESCRIBE `ports` 0.0019950866699219
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00043678283691406
(173) DESCRIBE `ports` 0.0020720958709717
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00057792663574219
(175) DESCRIBE `ports` 0.0022809505462646
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00047898292541504
(177) DESCRIBE `ports` 0.0019369125366211
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00027203559875488
(179) DESCRIBE `ports` 0.0014979839324951
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00037312507629395
(181) DESCRIBE `ports` 0.0014979839324951
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00032782554626465
(183) DESCRIBE `ports` 0.0014710426330566
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00036191940307617
(185) DESCRIBE `ports` 0.001446008682251
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00032401084899902
(187) DESCRIBE `ports` 0.0015659332275391
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00036501884460449
(189) DESCRIBE `ports` 0.001492977142334
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00034999847412109
(191) DESCRIBE `ports` 0.0014369487762451
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00039505958557129
(193) DESCRIBE `ports` 0.0013818740844727
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00039005279541016
(195) DESCRIBE `ports` 0.001798152923584
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004119873046875
(197) DESCRIBE `ports` 0.0017058849334717
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00037312507629395
(199) DESCRIBE `avid_specials` 0.0014371871948242
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34171 and class = 'Cruise') OR (item_id = 39 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00174880027771
(201) DESCRIBE `cruiselines` 0.0026750564575195
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.0004580020904541
(203) DESCRIBE `orchid_image` 0.0021450519561768
(204) DESCRIBE `cruiselines` 0.0027370452880859
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00043606758117676
(206) DESCRIBE `cruises` 0.0074968338012695
(207) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75764') 0.00042390823364258
(208) DESCRIBE `ships` 0.0031378269195557
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1723))) 0.00049400329589844
(210) DESCRIBE `ships` 0.0039410591125488
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1723') 0.00043010711669922
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003509521484375
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(214) DESCRIBE `itineraries` 0.0017869472503662
(215) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75764') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098586082458496
(216) DESCRIBE `ports` 0.0014140605926514
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00039792060852051
(218) DESCRIBE `ports` 0.001474142074585
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00033712387084961
(220) DESCRIBE `ports` 0.0018410682678223
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00047707557678223
(222) DESCRIBE `sailingdates` 0.0017359256744385
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75764') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001194953918457
(224) DESCRIBE `ports` 0.002094030380249
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00047802925109863
(226) DESCRIBE `ports` 0.0015161037445068
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00035190582275391
(228) DESCRIBE `ports` 0.001276969909668
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030398368835449
(230) DESCRIBE `ports` 0.0015490055084229
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00032401084899902
(232) DESCRIBE `ports` 0.001784086227417
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00036287307739258
(234) DESCRIBE `ports` 0.0014119148254395
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0004270076751709
(236) DESCRIBE `ports` 0.0016870498657227
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00030684471130371
(238) DESCRIBE `ports` 0.0015618801116943
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00028109550476074
(240) DESCRIBE `ports` 0.0013489723205566
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0004119873046875
(242) DESCRIBE `ports` 0.0017449855804443
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00043511390686035
(244) DESCRIBE `ports` 0.0018789768218994
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00042295455932617
(246) DESCRIBE `ports` 0.0018229484558105
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00040316581726074
(248) DESCRIBE `ports` 0.0018000602722168
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00045990943908691
(250) DESCRIBE `ports` 0.0020101070404053
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00044107437133789
(252) DESCRIBE `ports` 0.0020620822906494
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0005028247833252
(254) DESCRIBE `ports` 0.0017549991607666
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00034499168395996
(256) DESCRIBE `ports` 0.0018951892852783
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00043606758117676
(258) DESCRIBE `ports` 0.0015559196472168
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0003049373626709
(260) DESCRIBE `ports` 0.0013408660888672
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1022))) 0.00031208992004395
(262) DESCRIBE `ports` 0.0012691020965576
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1022') 0.00033307075500488
(264) DESCRIBE `ports` 0.0014758110046387
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00032496452331543
(266) DESCRIBE `ports` 0.001488208770752
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00032210350036621
(268) DESCRIBE `ports` 0.0014150142669678
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00020790100097656
(270) DESCRIBE `ports` 0.0013949871063232
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00027799606323242
(272) DESCRIBE `ports` 0.0016210079193115
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0004270076751709
(274) DESCRIBE `ports` 0.0015439987182617
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00030803680419922
(276) DESCRIBE `ports` 0.0016720294952393
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0003669261932373
(278) DESCRIBE `ports` 0.0016798973083496
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00034713745117188
(280) DESCRIBE `avid_specials` 0.001194953918457
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75764 and class = 'Cruise') OR (item_id = 1723 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017240047454834
(282) DESCRIBE `cruiselines` 0.0022368431091309
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00045895576477051
(284) DESCRIBE `orchid_image` 0.0021488666534424
(285) DESCRIBE `cruiselines` 0.002701997756958
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00040197372436523
(287) DESCRIBE `cruises` 0.0041439533233643
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76520') 0.00051593780517578
(289) DESCRIBE `ships` 0.0041501522064209
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 618))) 0.00063395500183105
(291) DESCRIBE `ships` 0.0042641162872314
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '618') 0.00054812431335449
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036120414733887
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034785270690918
(295) DESCRIBE `itineraries` 0.0020251274108887
(296) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '76520') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010128021240234
(297) DESCRIBE `ports` 0.002129077911377
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00048112869262695
(299) DESCRIBE `ports` 0.0018980503082275
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00040602684020996
(301) DESCRIBE `ports` 0.0019199848175049
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00041890144348145
(303) DESCRIBE `sailingdates` 0.0016129016876221
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '76520') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010230541229248
(305) DESCRIBE `ports` 0.0021228790283203
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00046801567077637
(307) DESCRIBE `ports` 0.0020220279693604
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00043201446533203
(309) DESCRIBE `ports` 0.0020248889923096
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00046110153198242
(311) DESCRIBE `ports` 0.0019490718841553
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00028610229492188
(313) DESCRIBE `ports` 0.0019419193267822
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1747))) 0.0005340576171875
(315) DESCRIBE `ports` 0.001971960067749
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1747') 0.00070595741271973
(317) DESCRIBE `ports` 0.0018889904022217
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00054311752319336
(319) DESCRIBE `ports` 0.0019419193267822
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00051093101501465
(321) DESCRIBE `ports` 0.0018851757049561
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1189))) 0.00053691864013672
(323) DESCRIBE `ports` 0.0018360614776611
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1189') 0.00035881996154785
(325) DESCRIBE `ports` 0.0015490055084229
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3845))) 0.0003819465637207
(327) DESCRIBE `ports` 0.002068042755127
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3845') 0.00052595138549805
(329) DESCRIBE `ports` 0.002284049987793
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3977))) 0.0028908252716064
(331) DESCRIBE `ports` 0.0019400119781494
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3977') 0.00046491622924805
(333) DESCRIBE `ports` 0.0024731159210205
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3820))) 0.00052499771118164
(335) DESCRIBE `ports` 0.0056700706481934
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3820') 0.00061798095703125
(337) DESCRIBE `ports` 0.0018701553344727
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2859))) 0.00049686431884766
(339) DESCRIBE `ports` 0.0019500255584717
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2859') 0.00047802925109863
(341) DESCRIBE `ports` 0.0019569396972656
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1190))) 0.00049781799316406
(343) DESCRIBE `ports` 0.0020351409912109
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1190') 0.00044703483581543
(345) DESCRIBE `ports` 0.0019040107727051
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00045895576477051
(347) DESCRIBE `ports` 0.0019559860229492
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00040507316589355
(349) DESCRIBE `ports` 0.0018649101257324
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00043201446533203
(351) DESCRIBE `ports` 0.001849889755249
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0004279613494873
(353) DESCRIBE `avid_specials` 0.0014650821685791
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76520 and class = 'Cruise') OR (item_id = 618 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 11 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.0012309551239014
(355) DESCRIBE `cruiselines` 0.0021851062774658
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00046992301940918
(357) DESCRIBE `orchid_image` 0.0020899772644043
(358) DESCRIBE `cruiselines` 0.0026559829711914
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00043606758117676
(360) DESCRIBE `cruises` 0.0038580894470215
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78628') 0.00047588348388672
(362) DESCRIBE `ships` 0.004047155380249
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1217))) 0.00057888031005859
(364) DESCRIBE `ships` 0.0040969848632812
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1217') 0.00054001808166504
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035715103149414
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034379959106445
(368) DESCRIBE `itineraries` 0.0019121170043945
(369) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78628') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010449886322021
(370) DESCRIBE `ports` 0.0022830963134766
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00054788589477539
(372) DESCRIBE `ports` 0.0018589496612549
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00044012069702148
(374) DESCRIBE `ports` 0.0019149780273438
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00043082237243652
(376) DESCRIBE `sailingdates` 0.002025842666626
(377) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78628') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00098204612731934
(378) DESCRIBE `ports` 0.0018351078033447
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00051593780517578
(380) DESCRIBE `ports` 0.0015168190002441
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00031280517578125
(382) DESCRIBE `ports` 0.0014591217041016
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00041604042053223
(384) DESCRIBE `ports` 0.0016410350799561
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00041103363037109
(386) DESCRIBE `ports` 0.0017390251159668
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00047087669372559
(388) DESCRIBE `ports` 0.0014150142669678
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00030779838562012
(390) DESCRIBE `ports` 0.001399040222168
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5996))) 0.00031399726867676
(392) DESCRIBE `ports` 0.0014240741729736
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5996') 0.00029397010803223
(394) DESCRIBE `ports` 0.001317024230957
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00032806396484375
(396) DESCRIBE `ports` 0.0014119148254395
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.00033998489379883
(398) DESCRIBE `ports` 0.0014500617980957
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00034403800964355
(400) DESCRIBE `ports` 0.0016860961914062
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00032401084899902
(402) DESCRIBE `ports` 0.0015890598297119
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1596))) 0.00035405158996582
(404) DESCRIBE `ports` 0.0012969970703125
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1596') 0.00030803680419922
(406) DESCRIBE `ports` 0.001323938369751
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00033998489379883
(408) DESCRIBE `ports` 0.0018198490142822
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00015711784362793
(410) DESCRIBE `ports` 0.0015091896057129
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5997))) 0.00041389465332031
(412) DESCRIBE `ports` 0.0012929439544678
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5997') 0.00028491020202637
(414) DESCRIBE `ports` 0.0013818740844727
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00038504600524902
(416) DESCRIBE `ports` 0.00166916847229
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00034403800964355
(418) DESCRIBE `ports` 0.0014381408691406
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00031018257141113
(420) DESCRIBE `ports` 0.0012509822845459
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00028300285339355
(422) DESCRIBE `ports` 0.0014359951019287
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00031185150146484
(424) DESCRIBE `ports` 0.0013339519500732
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00032210350036621
(426) DESCRIBE `avid_specials` 0.0014171600341797
(427) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78628 and class = 'Cruise') OR (item_id = 1217 AND class = 'Ship') OR (item_id = 131 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.0016698837280273
(428) DESCRIBE `cruiselines` 0.0022261142730713
(429) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00036191940307617
(430) DESCRIBE `orchid_image` 0.001413106918335
(431) DESCRIBE `cruiselines` 0.0018839836120605
(432) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.0002899169921875
(433) DESCRIBE `cruises` 0.0042939186096191
(434) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75141') 0.00052499771118164
(435) DESCRIBE `ships` 0.0034739971160889
(436) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1139))) 0.00062704086303711
(437) DESCRIBE `ships` 0.0043489933013916
(438) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1139') 0.00044703483581543
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032687187194824
(441) DESCRIBE `itineraries` 0.001471996307373
(442) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75141') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098991394042969
(443) DESCRIBE `ports` 0.0018229484558105
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00036787986755371
(445) DESCRIBE `ports` 0.0015110969543457
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00039196014404297
(447) DESCRIBE `ports` 0.0016400814056396
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00030398368835449
(449) DESCRIBE `sailingdates` 0.001255989074707
(450) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75141') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00086498260498047
(451) DESCRIBE `ports` 0.0014948844909668
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0004119873046875
(453) DESCRIBE `ports` 0.0015978813171387
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00033688545227051
(455) DESCRIBE `ports` 0.0014472007751465
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0003049373626709
(457) DESCRIBE `ports` 0.0017249584197998
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00040006637573242
(459) DESCRIBE `ports` 0.0017881393432617
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4326))) 0.00042295455932617
(461) DESCRIBE `ports` 0.0013139247894287
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4326') 0.00028705596923828
(463) DESCRIBE `ports` 0.001399040222168
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5294))) 0.00045609474182129
(465) DESCRIBE `ports` 0.0018880367279053
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5294') 0.00043296813964844
(467) DESCRIBE `ports` 0.0019049644470215
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.00048685073852539
(469) DESCRIBE `ports` 0.0021488666534424
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.00045990943908691
(471) DESCRIBE `ports` 0.0018661022186279
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 966))) 0.00045013427734375
(473) DESCRIBE `ports` 0.0017609596252441
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '966') 0.00038695335388184
(475) DESCRIBE `ports` 0.0016369819641113
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00045418739318848
(477) DESCRIBE `ports` 0.0019018650054932
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00041890144348145
(479) DESCRIBE `ports` 0.0017080307006836
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00040292739868164
(481) DESCRIBE `ports` 0.0019278526306152
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00042486190795898
(483) DESCRIBE `ports` 0.0018351078033447
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.0004429817199707
(485) DESCRIBE `ports` 0.001945972442627
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00062799453735352
(487) DESCRIBE `ports` 0.0021531581878662
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00098395347595215
(489) DESCRIBE `ports` 0.0024080276489258
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00046610832214355
(491) DESCRIBE `ports` 0.0023641586303711
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00068187713623047
(493) DESCRIBE `ports` 0.0022950172424316
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00049495697021484
(495) DESCRIBE `ports` 0.0019540786743164
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00047397613525391
(497) DESCRIBE `ports` 0.0019361972808838
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.0004420280456543
(499) DESCRIBE `ports` 0.0020139217376709
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00045084953308105
(501) DESCRIBE `ports` 0.0018959045410156
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00044512748718262
(503) DESCRIBE `ports` 0.0020580291748047
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4733))) 0.00049495697021484
(505) DESCRIBE `ports` 0.0017960071563721
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4733') 0.00043296813964844
(507) DESCRIBE `ports` 0.0018298625946045
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4733))) 0.00046181678771973
(509) DESCRIBE `ports` 0.0019030570983887
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4733') 0.00080513954162598
(511) DESCRIBE `avid_specials` 0.0019350051879883
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75141 and class = 'Cruise') OR (item_id = 1139 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017099380493164
(513) DESCRIBE `cruiselines` 0.0026571750640869
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00056004524230957
(515) DESCRIBE `orchid_image` 0.0019629001617432
(516) DESCRIBE `cruiselines` 0.0025010108947754
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.0006411075592041
(518) DESCRIBE `cruises` 0.0041267871856689
(519) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75015') 0.00051307678222656
(520) DESCRIBE `ships` 0.0036461353302002
(521) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1448))) 0.00055503845214844
(522) DESCRIBE `ships` 0.0039291381835938
(523) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1448') 0.00051498413085938
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033211708068848
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031280517578125
(526) DESCRIBE `itineraries` 0.0017421245574951
(527) DESCRIBE `ports` 0.0018558502197266
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00041794776916504
(529) DESCRIBE `ports` 0.0018329620361328
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00051307678222656
(531) DESCRIBE `ports` 0.0017819404602051
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00039100646972656
(533) DESCRIBE `sailingdates` 0.0013840198516846
(534) DESCRIBE `ports` 0.0021741390228271
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00043988227844238
(536) DESCRIBE `ports` 0.001615047454834
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00034785270690918
(538) DESCRIBE `ports` 0.0018699169158936
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037503242492676
(540) DESCRIBE `ports` 0.0016779899597168
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00040006637573242
(542) DESCRIBE `ports` 0.0017099380493164
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00055193901062012
(544) DESCRIBE `ports` 0.0018320083618164
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037622451782227
(546) DESCRIBE `ports` 0.0018308162689209
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00039911270141602
(548) DESCRIBE `ports` 0.0018219947814941
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00035905838012695
(550) DESCRIBE `ports` 0.0018601417541504
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00040698051452637
(552) DESCRIBE `ports` 0.0015048980712891
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00040698051452637
(554) DESCRIBE `ports` 0.0017969608306885
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.0003349781036377
(556) DESCRIBE `ports` 0.0013818740844727
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.0002748966217041
(558) DESCRIBE `ports` 0.001237154006958
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00033402442932129
(560) DESCRIBE `ports` 0.0015609264373779
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00031399726867676
(562) DESCRIBE `ports` 0.0013248920440674
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00032401084899902
(564) DESCRIBE `ports` 0.0013689994812012
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00030016899108887
(566) DESCRIBE `ports` 0.0012869834899902
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00038599967956543
(568) DESCRIBE `ports` 0.0014030933380127
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00037288665771484
(570) DESCRIBE `ports` 0.0016329288482666
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00039792060852051
(572) DESCRIBE `ports` 0.0017399787902832
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00035405158996582
(574) DESCRIBE `ports` 0.001882791519165
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00032591819763184
(576) DESCRIBE `ports` 0.0013198852539062
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00037384033203125
(578) DESCRIBE `ports` 0.0012879371643066
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0003969669342041
(580) DESCRIBE `ports` 0.0013258457183838
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0003349781036377
(582) DESCRIBE `ports` 0.0015881061553955
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00045490264892578
(584) DESCRIBE `ports` 0.0017399787902832
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037002563476562
(586) DESCRIBE `avid_specials` 0.0019371509552002
(587) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75015 and class = 'Cruise') OR (item_id = 1448 AND class = 'Ship') OR (item_id = 77 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.0017440319061279
(588) DESCRIBE `cruiselines` 0.0026359558105469
(589) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00040197372436523
(590) DESCRIBE `orchid_image` 0.0016188621520996
(591) DESCRIBE `cruiselines` 0.0020790100097656
(592) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00037908554077148
(593) DESCRIBE `cruises` 0.0035669803619385
(594) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45864') 0.00044703483581543
(595) DESCRIBE `ships` 0.0030789375305176
(596) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00047206878662109
(597) DESCRIBE `ships` 0.0027029514312744
(598) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00035691261291504
(599) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028610229492188
(600) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(601) DESCRIBE `itineraries` 0.0013010501861572
(602) DESCRIBE `ports` 0.0013120174407959
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00042486190795898
(604) DESCRIBE `ports` 0.0019659996032715
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00050091743469238
(606) DESCRIBE `ports` 0.002190113067627
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00045514106750488
(608) DESCRIBE `sailingdates` 0.0014779567718506
(609) DESCRIBE `ports` 0.0016961097717285
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00038909912109375
(611) DESCRIBE `ports` 0.0016598701477051
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00029206275939941
(613) DESCRIBE `ports` 0.0016329288482666
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00035905838012695
(615) DESCRIBE `ports` 0.0013189315795898
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00028085708618164
(617) DESCRIBE `ports` 0.0013458728790283
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.0003511905670166
(619) DESCRIBE `ports` 0.0014190673828125
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00033998489379883
(621) DESCRIBE `ports` 0.001619815826416
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00035595893859863
(623) DESCRIBE `ports` 0.0015039443969727
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00037193298339844
(625) DESCRIBE `ports` 0.0015420913696289
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003821849822998
(627) DESCRIBE `ports` 0.0015380382537842
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029802322387695
(629) DESCRIBE `ports` 0.0013298988342285
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00035715103149414
(631) DESCRIBE `ports` 0.0016138553619385
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00045680999755859
(633) DESCRIBE `ports` 0.0012960433959961
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00031304359436035
(635) DESCRIBE `ports` 0.0018298625946045
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00037217140197754
(637) DESCRIBE `ports` 0.0018250942230225
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00040793418884277
(639) DESCRIBE `ports` 0.0018739700317383
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00032496452331543
(641) DESCRIBE `ports` 0.0014009475708008
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00039505958557129
(643) DESCRIBE `ports` 0.0016379356384277
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00040698051452637
(645) DESCRIBE `avid_specials` 0.0016169548034668
(646) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45864 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.001878023147583
(647) DESCRIBE `cruiselines` 0.0027668476104736
(648) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00042915344238281
(649) DESCRIBE `orchid_image` 0.001878023147583
(650) DESCRIBE `cruiselines` 0.0023889541625977
(651) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041794776916504
(652) DESCRIBE `cruises` 0.0033130645751953
(653) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52324') 0.00043702125549316
(654) DESCRIBE `ships` 0.0029881000518799
(655) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00046491622924805
(656) DESCRIBE `ships` 0.0031099319458008
(657) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00041985511779785
(658) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(659) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(660) DESCRIBE `itineraries` 0.0017440319061279
(661) DESCRIBE `ports` 0.0013678073883057
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00039005279541016
(663) DESCRIBE `ports` 0.0015101432800293
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033903121948242
(665) DESCRIBE `ports` 0.0020859241485596
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00050783157348633
(667) DESCRIBE `sailingdates` 0.0018749237060547
(668) DESCRIBE `ports` 0.0023200511932373
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00054383277893066
(670) DESCRIBE `ports` 0.0020899772644043
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00046491622924805
(672) DESCRIBE `ports` 0.0019881725311279
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044488906860352
(674) DESCRIBE `ports` 0.0019121170043945
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00045299530029297
(676) DESCRIBE `ports` 0.0022110939025879
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00061678886413574
(678) DESCRIBE `ports` 0.001986026763916
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00051307678222656
(680) DESCRIBE `ports` 0.0017518997192383
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00027704238891602
(682) DESCRIBE `ports` 0.0018479824066162
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0005800724029541
(684) DESCRIBE `ports` 0.0019130706787109
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00046491622924805
(686) DESCRIBE `ports` 0.0017058849334717
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00041985511779785
(688) DESCRIBE `ports` 0.0019099712371826
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00043988227844238
(690) DESCRIBE `ports` 0.0017709732055664
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.0003349781036377
(692) DESCRIBE `ports` 0.0015709400177002
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00041794776916504
(694) DESCRIBE `ports` 0.0015838146209717
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00031900405883789
(696) DESCRIBE `ports` 0.0015301704406738
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00034308433532715
(698) DESCRIBE `ports` 0.0015919208526611
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00039291381835938
(700) DESCRIBE `ports` 0.0014691352844238
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033211708068848
(702) DESCRIBE `ports` 0.0018129348754883
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037002563476562
(704) DESCRIBE `avid_specials` 0.0016801357269287
(705) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52324 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0017528533935547
(706) DESCRIBE `cruiselines` 0.0025238990783691
(707) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00047516822814941
(708) DESCRIBE `orchid_image` 0.0019638538360596
(709) DESCRIBE `cruiselines` 0.0024948120117188
(710) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00043416023254395
(711) DESCRIBE `cruises` 0.003986120223999
(712) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74667') 0.00042510032653809
(713) DESCRIBE `ships` 0.0033431053161621
(714) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00060486793518066
(715) DESCRIBE `ships` 0.0036618709564209
(716) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00054192543029785
(717) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036096572875977
(718) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(719) DESCRIBE `itineraries` 0.001882791519165
(720) DESCRIBE `ports` 0.0020411014556885
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004880428314209
(722) DESCRIBE `ports` 0.0019481182098389
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00049090385437012
(724) DESCRIBE `ports` 0.0019221305847168
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040888786315918
(726) DESCRIBE `sailingdates` 0.0016450881958008
(727) DESCRIBE `ports` 0.0021460056304932
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047183036804199
(729) DESCRIBE `ports` 0.001924991607666
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0004270076751709
(731) DESCRIBE `ports` 0.0018789768218994
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00046801567077637
(733) DESCRIBE `ports` 0.0018229484558105
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037193298339844
(735) DESCRIBE `ports` 0.0016701221466064
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00037503242492676
(737) DESCRIBE `ports` 0.001884937286377
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0003809928894043
(739) DESCRIBE `ports` 0.0015871524810791
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00045084953308105
(741) DESCRIBE `ports` 0.0019118785858154
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00040698051452637
(743) DESCRIBE `ports` 0.0018661022186279
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00046491622924805
(745) DESCRIBE `ports` 0.0018370151519775
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00054788589477539
(747) DESCRIBE `ports` 0.0018088817596436
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00042414665222168
(749) DESCRIBE `ports` 0.0019140243530273
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0003509521484375
(751) DESCRIBE `ports` 0.0016679763793945
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00034594535827637
(753) DESCRIBE `ports` 0.001680850982666
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00048613548278809
(755) DESCRIBE `ports` 0.0017461776733398
(756) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4161))) 0.00041294097900391
(757) DESCRIBE `ports` 0.0017600059509277
(758) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4161') 0.00033998489379883
(759) DESCRIBE `ports` 0.0014760494232178
(760) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00037693977355957
(761) DESCRIBE `ports` 0.0018079280853271
(762) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00037503242492676
(763) DESCRIBE `avid_specials` 0.0023579597473145
(764) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74667 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0018289089202881
(765) DESCRIBE `cruiselines` 0.0028469562530518
(766) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00053906440734863
(767) DESCRIBE `orchid_image` 0.0021688938140869
(768) DESCRIBE `cruiselines` 0.0026860237121582
(769) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0004580020904541
(770) DESCRIBE `cruiselines` 0.0029571056365967
(771) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '183', '12', '144', '23', '18', '7', '20', '131', '8', '171', '103', '31', '101', '15', '156', '258', '120', '96', '50', '91', '29', '251', '33', '206', '191', '28', '114', '14', '212', '49', '24', '187', '37', '262', '16', '170', '47', '36', '110', '208', '181', '195', '118', '153', '30', '151', '88', '108', '141', '159', '59', '140', '216', '35', '90', '4', '73', '264', '211', '147', '113', '38', '57', '180', '213', '184', '48', '64', '276', '257', '261', '115', '95', '52', '105', '209', '82', '244', '134', '177', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,183,12,144,23,18,7,20,131,8,171,103,31,101,15,156,258,120,96,50,91,29,251,33,206,191,28,114,14,212,49,24,187,37,262,16,170,47,36,110,208,181,195,118,153,30,151,88,108,141,159,59,140,216,35,90,4,73,264,211,147,113,38,57,180,213,184,48,64,276,257,261,115,95,52,105,209,82,244,134,177,245') 0.0064420700073242
(772) DESCRIBE `ships` 0.0042309761047363
(773) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1324', '1554', '1555', '726', '977', '1744', '517', '1272', '1794', '780', '258', '1032', '986', '974', '1292', '461', '22', '21', '1717', '330', '393', '797', '28', '454', '1205', '1359', '207', '1599', '716', '1677', '480', '11', '10', '333', '349', '439', '404', '9', '739', '882', '1135', '737', '1291', '1607', '521', '1588', '1199', '24', '265', '817', '25', '1417', '770', '792', '715', '855', '766', '3', '14', '1068', '711', '1372', '113', '1768', '657', '520', '66', '585', '1302', '31', '34', '37', '38', '837', '1067', '1163', '1413', '1526', '378', '748', '1320', '332', '542', '1579', '1773', '390', '1411', '526', '970', '1323', '1410', '441', '452', '1063', '327', '854', '1237', '407', '582', '573', '1402', '43', '81', '590', '958', '1454', '1013', '39', '791', '1420', '1422', '1586', '1594', '27', '674', '1284', '1308', '1418', '1421', '1424', '30', '36', '1012', '1419', '1423', '1682', '84', '114', '335', '580', '1742', '1326', '1327', '401', '455', '547', '1415', '1587', '451', '1245', '462', '850', '1193', '1461', '1552', '340', '386', '406', '1236', '63', '545', '1303', '1678', '35', '162', '385', '683', '1412', '601', '1575', '78', '160', '325', '722', '1172', '1348', '163', '639', '1168', '1408', '1740', '434', '508', '852', '1008', '1108', '1021', '1289', '1782', '201', '775', '1019', '1743', '119', '1266', '1711', '1716', '610', '776', '857', '858', '1160', '1217', '1229', '1325', '1501', '1604', '111', '338', '394', '673', '1405', '1426', '658', '678', '1226', '1373', '285', '627', '1095', '1137', '1159', '1319', '45', '1330', '1448', '1574', '266', '286', '389', '1136', '1141', '124', '403', '851', '1358', '69', '818', '966', '1259', '151', '351', '1569', '253', '651', '968', '287', '314', '626', '1055', '105', '348', '643', '644', '709', '1049', '1458', '82', '324', '375', '701', '1360', '1361', '1632', '1801', '148', '467', '485', '790', '884', '1260', '1362', '1459', '1672', '1708', '4', '108', '150', '341', '616', '663', '1368', '1455', '1721', '1751', '1767', '291', '769', '885', '1148', '262', '768', '944', '954', '1051', '1572', '70', '98', '405', '421', '1301', '1322', '1724', '116', '290', '1020', '1343', '1409', '1452', '1722', '1750', '123', '198', '703', '784', '1064', '1088', '1580', '1581', '152', '553', '652', '1139', '1321', '1398', '516', '1054', '1208', '1293', '1492', '483', '1445', '1483', '1486', '1601', '1738', '75', '147', '1042', '1195', '1771', '1781', '796', '883', '1150', '1344', '1437', '1714', '223', '559', '1075', '1679', '1681', '149', '886', '1143', '1230', '1231', '1262', '707', '1444', '1539', '1673', '1684', '635', '1045', '1151', '1676', '74', '717', '1367', '1571', '1766', '704', '1035', '1060', '494', '656', '1073', '1318', '205', '982', '1039', '1040', '1254', '1465', '1232', '1389', '574', '761', '1704', '687', '751', '808', '1050', '1144', '1146', '1540', '1791', '503', '795', '1025', '1029', '1043', '1090', '1157', '1645', '1706', '212', '965', '1027', '1223', '1715', '1788', '479', '996', '1037', '1053', '1158', '1297', '1453', '1697', '1709', '93', '493', '767', '1283', '1404', '1471', '1772', '665', '905', '973', '979', '1047', '1052', '1155', '1156', '1188', '1342', '1647', '1713', '1730', '888', '988', '1233', '1351', '695', '733', '1026', '1089', '1145', '1295', '1296', '1316', '1341', '1624', '1674', '62', '240', '685', '1024', '1149', '1196', '1241', '1345', '1366', '1474', '1626', '1710', '299', '300', '666', '692', '921', '972', '1004', '1034', '1113', '1340', '1451', '1609', '417', '743', '914', '915', '916', '920', '923', '924', '926', '927', '930', '931', '997', '1138', '1282', '1298', '1339', '1354', '1596', '1640', '423', '962', '1142', '1650', '1723', '448', '618')) ORDER BY FIND_IN_SET(id, '1761,1324,1554,1555,726,977,1744,517,1272,1794,780,258,1032,986,974,1292,461,22,21,1717,330,393,797,28,454,1205,1359,207,1599,716,1677,480,11,10,333,349,439,404,9,739,882,1135,737,1291,1607,521,1588,1199,24,265,817,25,1417,770,792,715,855,766,3,14,1068,711,1372,113,1768,657,520,66,585,1302,31,34,37,38,837,1067,1163,1413,1526,378,748,1320,332,542,1579,1773,390,1411,526,970,1323,1410,441,452,1063,327,854,1237,407,582,573,1402,43,81,590,958,1454,1013,39,791,1420,1422,1586,1594,27,674,1284,1308,1418,1421,1424,30,36,1012,1419,1423,1682,84,114,335,580,1742,1326,1327,401,455,547,1415,1587,451,1245,462,850,1193,1461,1552,340,386,406,1236,63,545,1303,1678,35,162,385,683,1412,601,1575,78,160,325,722,1172,1348,163,639,1168,1408,1740,434,508,852,1008,1108,1021,1289,1782,201,775,1019,1743,119,1266,1711,1716,610,776,857,858,1160,1217,1229,1325,1501,1604,111,338,394,673,1405,1426,658,678,1226,1373,285,627,1095,1137,1159,1319,45,1330,1448,1574,266,286,389,1136,1141,124,403,851,1358,69,818,966,1259,151,351,1569,253,651,968,287,314,626,1055,105,348,643,644,709,1049,1458,82,324,375,701,1360,1361,1632,1801,148,467,485,790,884,1260,1362,1459,1672,1708,4,108,150,341,616,663,1368,1455,1721,1751,1767,291,769,885,1148,262,768,944,954,1051,1572,70,98,405,421,1301,1322,1724,116,290,1020,1343,1409,1452,1722,1750,123,198,703,784,1064,1088,1580,1581,152,553,652,1139,1321,1398,516,1054,1208,1293,1492,483,1445,1483,1486,1601,1738,75,147,1042,1195,1771,1781,796,883,1150,1344,1437,1714,223,559,1075,1679,1681,149,886,1143,1230,1231,1262,707,1444,1539,1673,1684,635,1045,1151,1676,74,717,1367,1571,1766,704,1035,1060,494,656,1073,1318,205,982,1039,1040,1254,1465,1232,1389,574,761,1704,687,751,808,1050,1144,1146,1540,1791,503,795,1025,1029,1043,1090,1157,1645,1706,212,965,1027,1223,1715,1788,479,996,1037,1053,1158,1297,1453,1697,1709,93,493,767,1283,1404,1471,1772,665,905,973,979,1047,1052,1155,1156,1188,1342,1647,1713,1730,888,988,1233,1351,695,733,1026,1089,1145,1295,1296,1316,1341,1624,1674,62,240,685,1024,1149,1196,1241,1345,1366,1474,1626,1710,299,300,666,692,921,972,1004,1034,1113,1340,1451,1609,417,743,914,915,916,920,923,924,926,927,930,931,997,1138,1282,1298,1339,1354,1596,1640,423,962,1142,1650,1723,448,618') 0.059514999389648
(774) DESCRIBE `cruisetypes` 0.0020370483398438
(775) DESCRIBE `destinations` 0.0026769638061523
(776) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '35', '54', '25', '9', '2', '43', '37', '39', '8', '53', '26', '28', '49', '38', '55', '11', '21', '40', '7', '44', '48', '29', '45', '30', '34', '10', '46', '52', '32', '56')) ORDER BY FIND_IN_SET(id, '50,22,12,35,54,25,9,2,43,37,39,8,53,26,28,49,38,55,11,21,40,7,44,48,29,45,30,34,10,46,52,32,56') 0.00211501121521