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

Total elapsed time: 0.65377402305603

# Query Time
(1) connect 0.0007939338684082
(2) DESCRIBE `cruises` 0.0038580894470215
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67122, 68292, 69365, 69842, 69844, 70478, 72698, 74245, 74862, 74897)) ORDER BY FIND_IN_SET(id, '67122,68292,69365,69842,69844,70478,72698,74245,74862,74897') 0.0018260478973389
(4) DESCRIBE `cruises` 0.0037021636962891
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67122') 0.00059604644775391
(6) DESCRIBE `ships` 0.0042870044708252
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1569))) 0.00080204010009766
(8) DESCRIBE `ships` 0.0038571357727051
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1569') 0.00045514106750488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034999847412109
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.0018877983093262
(13) DESCRIBE `ports` 0.0019171237945557
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00045204162597656
(15) DESCRIBE `ports` 0.001939058303833
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035381317138672
(17) DESCRIBE `ports` 0.0014090538024902
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037002563476562
(19) DESCRIBE `sailingdates` 0.0013411045074463
(20) DESCRIBE `ports` 0.0014429092407227
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00038290023803711
(22) DESCRIBE `ports` 0.0015640258789062
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034117698669434
(24) DESCRIBE `ports` 0.0014119148254395
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00038599967956543
(26) DESCRIBE `ports` 0.0013809204101562
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00031208992004395
(28) DESCRIBE `ports` 0.0014758110046387
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00037884712219238
(30) DESCRIBE `ports` 0.0014750957489014
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00037598609924316
(32) DESCRIBE `ports` 0.0014400482177734
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00034117698669434
(34) DESCRIBE `ports` 0.001492977142334
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00031089782714844
(36) DESCRIBE `ports` 0.0013570785522461
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00047612190246582
(38) DESCRIBE `ports` 0.0019299983978271
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039005279541016
(40) DESCRIBE `avid_specials` 0.0014419555664062
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67122 and class = 'Cruise') OR (item_id = 1569 AND class = 'Ship') OR (item_id = 20 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.0018620491027832
(42) DESCRIBE `cruiselines` 0.0027260780334473
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00045609474182129
(44) DESCRIBE `orchid_image` 0.0017440319061279
(45) DESCRIBE `cruiselines` 0.0025441646575928
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034594535827637
(47) DESCRIBE `cruises` 0.0034899711608887
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68292') 0.00055098533630371
(49) DESCRIBE `ships` 0.0039811134338379
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1587))) 0.00059795379638672
(51) DESCRIBE `ships` 0.0037031173706055
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1587') 0.00035285949707031
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036120414733887
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034213066101074
(55) DESCRIBE `itineraries` 0.0019819736480713
(56) DESCRIBE `ports` 0.0018949508666992
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045609474182129
(58) DESCRIBE `ports` 0.0018160343170166
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00039982795715332
(60) DESCRIBE `ports` 0.0018291473388672
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0004119873046875
(62) DESCRIBE `sailingdates` 0.0015959739685059
(63) DESCRIBE `ports` 0.0021607875823975
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046396255493164
(65) DESCRIBE `ports` 0.0018889904022217
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041985511779785
(67) DESCRIBE `ports` 0.0018949508666992
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00044584274291992
(69) DESCRIBE `ports` 0.0018799304962158
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00039887428283691
(71) DESCRIBE `ports` 0.0015699863433838
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00040817260742188
(73) DESCRIBE `ports` 0.0017220973968506
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00049185752868652
(75) DESCRIBE `ports` 0.0016269683837891
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0003809928894043
(77) DESCRIBE `ports` 0.0015799999237061
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00034403800964355
(79) DESCRIBE `ports` 0.0016069412231445
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00039196014404297
(81) DESCRIBE `ports` 0.0015239715576172
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003969669342041
(83) DESCRIBE `avid_specials` 0.001492977142334
(84) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68292 and class = 'Cruise') OR (item_id = 1587 AND class = 'Ship') OR (item_id = 8 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.00164794921875
(85) DESCRIBE `cruiselines` 0.0023422241210938
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00040984153747559
(87) DESCRIBE `orchid_image` 0.0017671585083008
(88) DESCRIBE `cruiselines` 0.0023849010467529
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00037908554077148
(90) DESCRIBE `cruises` 0.0032730102539062
(91) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69365') 0.00041913986206055
(92) DESCRIBE `ships` 0.0035088062286377
(93) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1599))) 0.00062894821166992
(94) DESCRIBE `ships` 0.003486156463623
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1599') 0.00041484832763672
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032782554626465
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029397010803223
(98) DESCRIBE `itineraries` 0.0016939640045166
(99) DESCRIBE `ports` 0.0016970634460449
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037407875061035
(101) DESCRIBE `ports` 0.0013630390167236
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037813186645508
(103) DESCRIBE `ports` 0.0013210773468018
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029492378234863
(105) DESCRIBE `sailingdates` 0.0012187957763672
(106) DESCRIBE `ports` 0.002061128616333
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00042390823364258
(108) DESCRIBE `ports` 0.0014431476593018
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00045180320739746
(110) DESCRIBE `ports` 0.00130295753479
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030803680419922
(112) DESCRIBE `ports` 0.0013508796691895
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00034880638122559
(114) DESCRIBE `ports` 0.0016989707946777
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00042986869812012
(116) DESCRIBE `ports` 0.0013010501861572
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00029301643371582
(118) DESCRIBE `ports` 0.0014631748199463
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00045895576477051
(120) DESCRIBE `ports` 0.0014650821685791
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00034213066101074
(122) DESCRIBE `ports` 0.0013720989227295
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031399726867676
(124) DESCRIBE `ports` 0.0012331008911133
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026798248291016
(126) DESCRIBE `ports` 0.0012381076812744
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028705596923828
(128) DESCRIBE `ports` 0.001291036605835
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026893615722656
(130) DESCRIBE `ports` 0.0019099712371826
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00046181678771973
(132) DESCRIBE `ports` 0.0017828941345215
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00036287307739258
(134) DESCRIBE `avid_specials` 0.0017249584197998
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69365 and class = 'Cruise') OR (item_id = 1599 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001237154006958
(136) DESCRIBE `cruiselines` 0.001924991607666
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032186508178711
(138) DESCRIBE `orchid_image` 0.0015130043029785
(139) DESCRIBE `cruiselines` 0.0017249584197998
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031399726867676
(141) DESCRIBE `cruises` 0.0036890506744385
(142) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69842') 0.00039005279541016
(143) DESCRIBE `ships` 0.0032751560211182
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1345))) 0.00043702125549316
(145) DESCRIBE `ships` 0.0025730133056641
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1345') 0.00032496452331543
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(149) DESCRIBE `itineraries` 0.0012249946594238
(150) DESCRIBE `ports` 0.0012991428375244
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00036096572875977
(152) DESCRIBE `ports` 0.0016078948974609
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00033211708068848
(154) DESCRIBE `ports` 0.0013010501861572
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00027894973754883
(156) DESCRIBE `sailingdates` 0.001154899597168
(157) DESCRIBE `ports` 0.0015931129455566
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00033402442932129
(159) DESCRIBE `ports` 0.001276969909668
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00027585029602051
(161) DESCRIBE `ports` 0.0012378692626953
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00034117698669434
(163) DESCRIBE `ports` 0.0012621879577637
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00026583671569824
(165) DESCRIBE `ports` 0.0012938976287842
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00028085708618164
(167) DESCRIBE `ports` 0.0012760162353516
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00026702880859375
(169) DESCRIBE `ports` 0.0012259483337402
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0002899169921875
(171) DESCRIBE `ports` 0.0013871192932129
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00026607513427734
(173) DESCRIBE `ports` 0.0012309551239014
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4236))) 0.00029683113098145
(175) DESCRIBE `ports` 0.0015301704406738
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4236') 0.00028610229492188
(177) DESCRIBE `ports` 0.0012280941009521
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00038599967956543
(179) DESCRIBE `ports` 0.0016319751739502
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00031399726867676
(181) DESCRIBE `ports` 0.0015969276428223
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00027894973754883
(183) DESCRIBE `ports` 0.0012340545654297
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00025296211242676
(185) DESCRIBE `ports` 0.0013208389282227
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00027298927307129
(187) DESCRIBE `ports` 0.0014481544494629
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00037622451782227
(189) DESCRIBE `avid_specials` 0.0011680126190186
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69842 and class = 'Cruise') OR (item_id = 1345 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.0010111331939697
(191) DESCRIBE `cruiselines` 0.0018270015716553
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031900405883789
(193) DESCRIBE `orchid_image` 0.0013949871063232
(194) DESCRIBE `cruiselines` 0.0024359226226807
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00038981437683105
(196) DESCRIBE `cruises` 0.0036289691925049
(197) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69844') 0.00045680999755859
(198) DESCRIBE `ships` 0.003389835357666
(199) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1149))) 0.00045108795166016
(200) DESCRIBE `ships` 0.0028281211853027
(201) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1149') 0.00035190582275391
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(204) DESCRIBE `itineraries` 0.0013439655303955
(205) DESCRIBE `ports` 0.0013389587402344
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00039219856262207
(207) DESCRIBE `ports` 0.0014059543609619
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00032711029052734
(209) DESCRIBE `ports` 0.0021347999572754
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00050997734069824
(211) DESCRIBE `sailingdates` 0.0015230178833008
(212) DESCRIBE `ports` 0.0015149116516113
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00038504600524902
(214) DESCRIBE `ports` 0.0013899803161621
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00028395652770996
(216) DESCRIBE `ports` 0.0012228488922119
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00028014183044434
(218) DESCRIBE `ports` 0.0013000965118408
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00026798248291016
(220) DESCRIBE `ports` 0.0012290477752686
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00029802322387695
(222) DESCRIBE `ports` 0.0014119148254395
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00026702880859375
(224) DESCRIBE `ports` 0.0012509822845459
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00029301643371582
(226) DESCRIBE `ports` 0.001305103302002
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.0002748966217041
(228) DESCRIBE `ports` 0.0012218952178955
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00033903121948242
(230) DESCRIBE `ports` 0.0012760162353516
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00026607513427734
(232) DESCRIBE `ports` 0.0012271404266357
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00029206275939941
(234) DESCRIBE `ports` 0.0012600421905518
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00033688545227051
(236) DESCRIBE `ports` 0.0014009475708008
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00036191940307617
(238) DESCRIBE `ports` 0.0012509822845459
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00027108192443848
(240) DESCRIBE `ports` 0.0019168853759766
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00039005279541016
(242) DESCRIBE `ports` 0.0014681816101074
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00035309791564941
(244) DESCRIBE `ports` 0.0013680458068848
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00030708312988281
(246) DESCRIBE `ports` 0.0013840198516846
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00027084350585938
(248) DESCRIBE `avid_specials` 0.0012061595916748
(249) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69844 and class = 'Cruise') OR (item_id = 1149 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.0014340877532959
(250) DESCRIBE `cruiselines` 0.0025770664215088
(251) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00024604797363281
(252) DESCRIBE `orchid_image` 0.0016601085662842
(253) DESCRIBE `cruiselines` 0.0019259452819824
(254) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00028896331787109
(255) DESCRIBE `cruises` 0.0033469200134277
(256) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70478') 0.00044703483581543
(257) DESCRIBE `ships` 0.0030591487884521
(258) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 986))) 0.00037503242492676
(259) DESCRIBE `ships` 0.0033159255981445
(260) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '986') 0.00047206878662109
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(263) DESCRIBE `itineraries` 0.001384973526001
(264) DESCRIBE `ports` 0.0015299320220947
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00039315223693848
(266) DESCRIBE `ports` 0.0012748241424561
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00021100044250488
(268) DESCRIBE `ports` 0.0016231536865234
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.0003509521484375
(270) DESCRIBE `sailingdates` 0.001147985458374
(271) DESCRIBE `ports` 0.0015361309051514
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00032210350036621
(273) DESCRIBE `ports` 0.0012748241424561
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00034189224243164
(275) DESCRIBE `ports` 0.0014071464538574
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031805038452148
(277) DESCRIBE `ports` 0.0015590190887451
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00029301643371582
(279) DESCRIBE `ports` 0.0013890266418457
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00037598609924316
(281) DESCRIBE `ports` 0.0015029907226562
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.00041413307189941
(283) DESCRIBE `ports` 0.001431941986084
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040483474731445
(285) DESCRIBE `ports` 0.0012669563293457
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0002748966217041
(287) DESCRIBE `ports` 0.0014989376068115
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002901554107666
(289) DESCRIBE `ports` 0.0012710094451904
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030398368835449
(291) DESCRIBE `ports` 0.0014989376068115
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00034308433532715
(293) DESCRIBE `ports` 0.0014219284057617
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028896331787109
(295) DESCRIBE `ports` 0.0012459754943848
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00029397010803223
(297) DESCRIBE `ports` 0.0012650489807129
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.0003211498260498
(299) DESCRIBE `avid_specials` 0.001107931137085
(300) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70478 and class = 'Cruise') OR (item_id = 986 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001183032989502
(301) DESCRIBE `cruiselines` 0.0020589828491211
(302) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00033712387084961
(303) DESCRIBE `orchid_image` 0.0015249252319336
(304) DESCRIBE `cruiselines` 0.002007007598877
(305) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00065398216247559
(306) DESCRIBE `cruises` 0.0039901733398438
(307) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72698') 0.00046801567077637
(308) DESCRIBE `ships` 0.0040171146392822
(309) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1413))) 0.00056910514831543
(310) DESCRIBE `ships` 0.0040979385375977
(311) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1413') 0.00048995018005371
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003669261932373
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035691261291504
(314) DESCRIBE `itineraries` 0.002065896987915
(315) DESCRIBE `ports` 0.0022008419036865
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00048017501831055
(317) DESCRIBE `ports` 0.0018990039825439
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003960132598877
(319) DESCRIBE `ports` 0.00187087059021
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0003969669342041
(321) DESCRIBE `sailingdates` 0.0015969276428223
(322) DESCRIBE `ports` 0.0019829273223877
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00048708915710449
(324) DESCRIBE `ports` 0.0018310546875
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00046992301940918
(326) DESCRIBE `ports` 0.0018329620361328
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00042510032653809
(328) DESCRIBE `ports` 0.0018370151519775
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00037503242492676
(330) DESCRIBE `ports` 0.0017919540405273
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00051283836364746
(332) DESCRIBE `ports` 0.0014309883117676
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028300285339355
(334) DESCRIBE `ports` 0.0013151168823242
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00028800964355469
(336) DESCRIBE `ports` 0.0014359951019287
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0003361701965332
(338) DESCRIBE `ports` 0.0013818740844727
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00029110908508301
(340) DESCRIBE `ports` 0.0013680458068848
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00026988983154297
(342) DESCRIBE `ports` 0.0016911029815674
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00033092498779297
(344) DESCRIBE `ports` 0.001349925994873
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00032281875610352
(346) DESCRIBE `ports` 0.0017940998077393
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00028586387634277
(348) DESCRIBE `ports` 0.0012800693511963
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00026106834411621
(350) DESCRIBE `ports` 0.0013508796691895
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00028514862060547
(352) DESCRIBE `ports` 0.0018959045410156
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.0004420280456543
(354) DESCRIBE `ports` 0.0018589496612549
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00042009353637695
(356) DESCRIBE `ports` 0.0017900466918945
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00039410591125488
(358) DESCRIBE `ports` 0.0017850399017334
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00047612190246582
(360) DESCRIBE `ports` 0.0018420219421387
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00037908554077148
(362) DESCRIBE `ports` 0.0018110275268555
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00039792060852051
(364) DESCRIBE `ports` 0.0015389919281006
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00033807754516602
(366) DESCRIBE `avid_specials` 0.0011229515075684
(367) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72698 and class = 'Cruise') OR (item_id = 1413 AND class = 'Ship') OR (item_id = 258 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.0010628700256348
(368) DESCRIBE `cruiselines` 0.0018270015716553
(369) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00044393539428711
(370) DESCRIBE `orchid_image` 0.0017259120941162
(371) DESCRIBE `cruiselines` 0.001762866973877
(372) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.00048589706420898
(373) DESCRIBE `cruises` 0.0036628246307373
(374) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74245') 0.00040483474731445
(375) DESCRIBE `ships` 0.0033450126647949
(376) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1008))) 0.00046801567077637
(377) DESCRIBE `ships` 0.0032510757446289
(378) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1008') 0.00031304359436035
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029492378234863
(380) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(381) DESCRIBE `itineraries` 0.0014638900756836
(382) DESCRIBE `ports` 0.0016019344329834
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045204162597656
(384) DESCRIBE `ports` 0.0016059875488281
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031399726867676
(386) DESCRIBE `ports` 0.0012829303741455
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028896331787109
(388) DESCRIBE `sailingdates` 0.0010960102081299
(389) DESCRIBE `ports` 0.0014598369598389
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031709671020508
(391) DESCRIBE `ports` 0.0017318725585938
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028896331787109
(393) DESCRIBE `ports` 0.001417875289917
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0003349781036377
(395) DESCRIBE `ports` 0.0016078948974609
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00034308433532715
(397) DESCRIBE `ports` 0.0016469955444336
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00036382675170898
(399) DESCRIBE `ports` 0.0013668537139893
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00028705596923828
(401) DESCRIBE `ports` 0.0012450218200684
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00030994415283203
(403) DESCRIBE `ports` 0.0012731552124023
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00028300285339355
(405) DESCRIBE `ports` 0.001276969909668
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00031208992004395
(407) DESCRIBE `ports` 0.0012509822845459
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00026607513427734
(409) DESCRIBE `ports` 0.0012879371643066
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037193298339844
(411) DESCRIBE `ports` 0.0016608238220215
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037312507629395
(413) DESCRIBE `avid_specials` 0.0012860298156738
(414) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74245 and class = 'Cruise') OR (item_id = 1008 AND class = 'Ship') OR (item_id = 20 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.0010089874267578
(415) DESCRIBE `cruiselines` 0.0018291473388672
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031113624572754
(417) DESCRIBE `orchid_image` 0.0015730857849121
(418) DESCRIBE `cruiselines` 0.0021581649780273
(419) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00031304359436035
(420) DESCRIBE `cruises` 0.0026969909667969
(421) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74862') 0.00033998489379883
(422) DESCRIBE `ships` 0.0026869773864746
(423) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1231))) 0.00042986869812012
(424) DESCRIBE `ships` 0.0026130676269531
(425) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1231') 0.00038695335388184
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027084350585938
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(428) DESCRIBE `itineraries` 0.0013570785522461
(429) DESCRIBE `ports` 0.0016629695892334
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00034999847412109
(431) DESCRIBE `ports` 0.0014550685882568
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00037813186645508
(433) DESCRIBE `ports` 0.0014231204986572
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00034499168395996
(435) DESCRIBE `sailingdates` 0.0011560916900635
(436) DESCRIBE `ports` 0.0013320446014404
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00035190582275391
(438) DESCRIBE `ports` 0.0013298988342285
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00027894973754883
(440) DESCRIBE `ports` 0.0012381076812744
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00030112266540527
(442) DESCRIBE `ports` 0.0013270378112793
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00027799606323242
(444) DESCRIBE `ports` 0.0014541149139404
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0003349781036377
(446) DESCRIBE `ports` 0.0012741088867188
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00027084350585938
(448) DESCRIBE `ports` 0.0013549327850342
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00032591819763184
(450) DESCRIBE `ports` 0.0012350082397461
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00026893615722656
(452) DESCRIBE `ports` 0.0012490749359131
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00032591819763184
(454) DESCRIBE `ports` 0.0012269020080566
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00027298927307129
(456) DESCRIBE `ports` 0.0013570785522461
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00029397010803223
(458) DESCRIBE `ports` 0.0012319087982178
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00030207633972168
(460) DESCRIBE `ports` 0.001270055770874
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.0003058910369873
(462) DESCRIBE `ports` 0.0012319087982178
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00029993057250977
(464) DESCRIBE `ports` 0.0012989044189453
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0002899169921875
(466) DESCRIBE `ports` 0.0012328624725342
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00031304359436035
(468) DESCRIBE `ports` 0.0015809535980225
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00029802322387695
(470) DESCRIBE `ports` 0.0013060569763184
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00028800964355469
(472) DESCRIBE `ports` 0.0012998580932617
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00032615661621094
(474) DESCRIBE `ports` 0.0014090538024902
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.0002748966217041
(476) DESCRIBE `avid_specials` 0.0012140274047852
(477) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74862 and class = 'Cruise') OR (item_id = 1231 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.0017199516296387
(478) DESCRIBE `cruiselines` 0.0020029544830322
(479) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00033807754516602
(480) DESCRIBE `orchid_image` 0.0013909339904785
(481) DESCRIBE `cruiselines` 0.0016489028930664
(482) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00028896331787109
(483) DESCRIBE `cruises` 0.0026438236236572
(484) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74897') 0.00031399726867676
(485) DESCRIBE `ships` 0.0027680397033691
(486) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1361))) 0.0005640983581543
(487) DESCRIBE `ships` 0.0026450157165527
(488) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1361') 0.00036811828613281
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030279159545898
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028419494628906
(491) DESCRIBE `itineraries` 0.0013890266418457
(492) DESCRIBE `ports` 0.00130295753479
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00033402442932129
(494) DESCRIBE `ports` 0.0015418529510498
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00037598609924316
(496) DESCRIBE `ports` 0.001352071762085
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.000518798828125
(498) DESCRIBE `sailingdates` 0.0015499591827393
(499) DESCRIBE `ports` 0.0021169185638428
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0004889965057373
(501) DESCRIBE `ports` 0.0017578601837158
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00034308433532715
(503) DESCRIBE `ports` 0.0013659000396729
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031900405883789
(505) DESCRIBE `ports` 0.001276969909668
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00026392936706543
(507) DESCRIBE `ports` 0.0012481212615967
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00029587745666504
(509) DESCRIBE `ports` 0.0012810230255127
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00027298927307129
(511) DESCRIBE `ports` 0.00164794921875
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00037693977355957
(513) DESCRIBE `ports` 0.0013089179992676
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00027894973754883
(515) DESCRIBE `ports` 0.0013620853424072
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00030183792114258
(517) DESCRIBE `ports` 0.0013711452484131
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00028204917907715
(519) DESCRIBE `ports` 0.001349925994873
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00034499168395996
(521) DESCRIBE `ports` 0.0016660690307617
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00032806396484375
(523) DESCRIBE `ports` 0.0013768672943115
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00033903121948242
(525) DESCRIBE `ports` 0.0013689994812012
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00028395652770996
(527) DESCRIBE `ports` 0.001244068145752
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00029182434082031
(529) DESCRIBE `ports` 0.0013120174407959
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00026988983154297
(531) DESCRIBE `ports` 0.001223087310791
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00028300285339355
(533) DESCRIBE `ports` 0.0012979507446289
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00026607513427734
(535) DESCRIBE `ports` 0.0012240409851074
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00028491020202637
(537) DESCRIBE `ports` 0.0016829967498779
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00036382675170898
(539) DESCRIBE `avid_specials` 0.0011811256408691
(540) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74897 and class = 'Cruise') OR (item_id = 1361 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.0015230178833008
(541) DESCRIBE `cruiselines` 0.001910924911499
(542) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031495094299316
(543) DESCRIBE `orchid_image` 0.0014748573303223
(544) DESCRIBE `cruiselines` 0.0024740695953369
(545) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00037598609924316
(546) DESCRIBE `cruiselines` 0.002129077911377
(547) 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.0049281120300293
(548) DESCRIBE `ships` 0.0033400058746338
(549) 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.049877166748047
(550) DESCRIBE `cruisetypes` 0.0018348693847656
(551) DESCRIBE `destinations` 0.0025119781494141
(552) 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.0028889179229736