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

Total elapsed time: 0.62637281417847

# Query Time
(1) connect 0.00095987319946289
(2) DESCRIBE `cruises` 0.0042850971221924
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80643, 80644, 80576, 61570, 80577, 57752, 56235, 80578, 77978, 77979)) ORDER BY FIND_IN_SET(id, '80643,80644,80576,61570,80577,57752,56235,80578,77978,77979') 0.0023679733276367
(4) DESCRIBE `cruises` 0.0029149055480957
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80643') 0.00035905838012695
(6) DESCRIBE `ships` 0.002885103225708
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00049901008605957
(8) DESCRIBE `ships` 0.0034160614013672
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00029277801513672
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027203559875488
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026512145996094
(12) DESCRIBE `itineraries` 0.0015969276428223
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80643') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0020091533660889
(14) DESCRIBE `ports` 0.002147912979126
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046515464782715
(16) DESCRIBE `ports` 0.0019340515136719
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004429817199707
(18) DESCRIBE `ports` 0.0019009113311768
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00017380714416504
(20) DESCRIBE `sailingdates` 0.0017948150634766
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80643') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010430812835693
(22) DESCRIBE `ports` 0.0018470287322998
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042891502380371
(24) DESCRIBE `ports` 0.0017499923706055
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038790702819824
(26) DESCRIBE `ports` 0.001978874206543
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041079521179199
(28) DESCRIBE `ports` 0.0017690658569336
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016689300537109
(30) DESCRIBE `ports` 0.001838207244873
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00041484832763672
(32) DESCRIBE `ports` 0.0018320083618164
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00037908554077148
(34) DESCRIBE `ports` 0.0017330646514893
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039911270141602
(36) DESCRIBE `ports` 0.0017452239990234
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038695335388184
(38) DESCRIBE `ports` 0.0017259120941162
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038814544677734
(40) DESCRIBE `ports` 0.001838207244873
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00038790702819824
(42) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80643') AND (sailingdate >= '2019-11-27') 0.0082800388336182
(43) DESCRIBE `avid_specials` 0.0018560886383057
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80643 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013790130615234
(45) DESCRIBE `cruiselines` 0.0019879341125488
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00039911270141602
(47) DESCRIBE `orchid_image` 0.001600980758667
(48) DESCRIBE `cruiselines` 0.0020239353179932
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00038003921508789
(50) DESCRIBE `cruises` 0.0038888454437256
(51) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80644') 0.00066518783569336
(52) DESCRIBE `ships` 0.0040609836578369
(53) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00052809715270996
(54) DESCRIBE `ships` 0.0035750865936279
(55) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.0004889965057373
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046396255493164
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035190582275391
(58) DESCRIBE `itineraries` 0.0020380020141602
(59) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80644') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055599212646484
(60) DESCRIBE `ports` 0.0019900798797607
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047707557678223
(62) DESCRIBE `ports` 0.0017149448394775
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004119873046875
(64) DESCRIBE `ports` 0.0015780925750732
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029397010803223
(66) DESCRIBE `sailingdates` 0.0011680126190186
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80644') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077605247497559
(68) DESCRIBE `ports` 0.0020670890808105
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047612190246582
(70) DESCRIBE `ports` 0.0019681453704834
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043201446533203
(72) DESCRIBE `ports` 0.0019729137420654
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004730224609375
(74) DESCRIBE `ports` 0.0018680095672607
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040006637573242
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80644') AND (sailingdate >= '2019-11-27') 0.0090999603271484
(77) DESCRIBE `avid_specials` 0.0019779205322266
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80644 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015861988067627
(79) DESCRIBE `cruiselines` 0.0025370121002197
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0005040168762207
(81) DESCRIBE `orchid_image` 0.0020780563354492
(82) DESCRIBE `cruiselines` 0.0027198791503906
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00051712989807129
(84) DESCRIBE `cruises` 0.0036909580230713
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80576') 0.00041699409484863
(86) DESCRIBE `ships` 0.0032370090484619
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00048995018005371
(88) DESCRIBE `ships` 0.0038230419158936
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00041103363037109
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034213066101074
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032711029052734
(92) DESCRIBE `itineraries` 0.0017991065979004
(93) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80576') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011529922485352
(94) DESCRIBE `ports` 0.0016610622406006
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(96) DESCRIBE `ports` 0.0017549991607666
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038409233093262
(98) DESCRIBE `ports` 0.001533031463623
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(100) DESCRIBE `sailingdates` 0.0014698505401611
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80576') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00097298622131348
(102) DESCRIBE `ports` 0.0020639896392822
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040316581726074
(104) DESCRIBE `ports` 0.001370906829834
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(106) DESCRIBE `ports` 0.0012650489807129
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00037884712219238
(108) DESCRIBE `ports` 0.00148606300354
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00028204917907715
(110) DESCRIBE `ports` 0.0015711784362793
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033712387084961
(112) DESCRIBE `ports` 0.0012381076812744
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029706954956055
(114) DESCRIBE `ports` 0.0017001628875732
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0003819465637207
(116) DESCRIBE `ports` 0.001690149307251
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00041484832763672
(118) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80576') AND (sailingdate >= '2019-11-27') 0.0065040588378906
(119) DESCRIBE `avid_specials` 0.0013530254364014
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80576 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010838508605957
(121) DESCRIBE `cruiselines` 0.0021469593048096
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00043201446533203
(123) DESCRIBE `orchid_image` 0.0015561580657959
(124) DESCRIBE `cruiselines` 0.0019891262054443
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00032615661621094
(126) DESCRIBE `cruises` 0.0027108192443848
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61570') 0.00031304359436035
(128) DESCRIBE `ships` 0.0027379989624023
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00044393539428711
(130) DESCRIBE `ships` 0.0028109550476074
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00031399726867676
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026798248291016
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025296211242676
(134) DESCRIBE `itineraries` 0.0012810230255127
(135) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61570') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009760856628418
(136) DESCRIBE `ports` 0.0013039112091064
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031495094299316
(138) DESCRIBE `ports` 0.0013129711151123
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00036120414733887
(140) DESCRIBE `ports` 0.0013389587402344
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00030303001403809
(142) DESCRIBE `sailingdates` 0.0012929439544678
(143) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61570') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076413154602051
(144) DESCRIBE `ports` 0.0013899803161621
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031399726867676
(146) DESCRIBE `ports` 0.00148606300354
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00035810470581055
(148) DESCRIBE `ports` 0.0018267631530762
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00031900405883789
(150) DESCRIBE `ports` 0.0013430118560791
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00028586387634277
(152) DESCRIBE `ports` 0.0012819766998291
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00028705596923828
(154) DESCRIBE `ports` 0.00130295753479
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00026607513427734
(156) DESCRIBE `ports` 0.0013899803161621
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0003209114074707
(158) DESCRIBE `ports` 0.0015549659729004
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00044417381286621
(160) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '61570') AND (sailingdate >= '2019-11-27') 0.0090479850769043
(161) DESCRIBE `avid_specials` 0.0018429756164551
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61570 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013260841369629
(163) DESCRIBE `cruiselines` 0.0021719932556152
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00050997734069824
(165) DESCRIBE `orchid_image` 0.0018138885498047
(166) DESCRIBE `cruiselines` 0.0020430088043213
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00042581558227539
(168) DESCRIBE `cruises` 0.0039908885955811
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80577') 0.00050687789916992
(170) DESCRIBE `ships` 0.0041389465332031
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00043511390686035
(172) DESCRIBE `ships` 0.0032899379730225
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00028300285339355
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026702880859375
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00031089782714844
(176) DESCRIBE `itineraries` 0.0012660026550293
(177) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80577') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059819221496582
(178) DESCRIBE `ports` 0.0013689994812012
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00032615661621094
(180) DESCRIBE `ports` 0.0013000965118408
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00035214424133301
(182) DESCRIBE `ports` 0.0015261173248291
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00035786628723145
(184) DESCRIBE `sailingdates` 0.0014488697052002
(185) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80577') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070309638977051
(186) DESCRIBE `ports` 0.0015919208526611
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00040793418884277
(188) DESCRIBE `ports` 0.0013689994812012
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00029420852661133
(190) DESCRIBE `ports` 0.0013141632080078
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6035))) 0.00031113624572754
(192) DESCRIBE `ports` 0.001284122467041
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6035') 0.00027918815612793
(194) DESCRIBE `ports` 0.0012390613555908
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00029182434082031
(196) DESCRIBE `ports` 0.001237154006958
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00030994415283203
(198) DESCRIBE `ports` 0.0012869834899902
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0004580020904541
(200) DESCRIBE `ports` 0.0014889240264893
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00029706954956055
(202) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80577') AND (sailingdate >= '2019-11-27') 0.0051860809326172
(203) DESCRIBE `avid_specials` 0.0013470649719238
(204) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80577 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010001659393311
(205) DESCRIBE `cruiselines` 0.0019140243530273
(206) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00033307075500488
(207) DESCRIBE `orchid_image` 0.0014500617980957
(208) DESCRIBE `cruiselines` 0.0018298625946045
(209) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0002899169921875
(210) DESCRIBE `cruises` 0.0036029815673828
(211) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57752') 0.0004727840423584
(212) DESCRIBE `ships` 0.0036230087280273
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.00057101249694824
(214) DESCRIBE `ships` 0.0034768581390381
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00036907196044922
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030207633972168
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00033092498779297
(218) DESCRIBE `itineraries` 0.0014948844909668
(219) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57752') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085997581481934
(220) DESCRIBE `ports` 0.00166916847229
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00032997131347656
(222) DESCRIBE `ports` 0.0012719631195068
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.0003349781036377
(224) DESCRIBE `ports` 0.0012638568878174
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00027894973754883
(226) DESCRIBE `sailingdates` 0.0013902187347412
(227) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57752') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084805488586426
(228) DESCRIBE `ports` 0.0014569759368896
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00030303001403809
(230) DESCRIBE `ports` 0.0012600421905518
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00026893615722656
(232) DESCRIBE `ports` 0.0012869834899902
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00030183792114258
(234) DESCRIBE `ports` 0.0012948513031006
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00028586387634277
(236) DESCRIBE `ports` 0.0013110637664795
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00029206275939941
(238) DESCRIBE `ports` 0.0012521743774414
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00031590461730957
(240) DESCRIBE `ports` 0.0012810230255127
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00029492378234863
(242) DESCRIBE `ports` 0.0013129711151123
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00027608871459961
(244) DESCRIBE `ports` 0.0012571811676025
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00027894973754883
(246) DESCRIBE `ports` 0.0012750625610352
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00029611587524414
(248) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57752') AND (sailingdate >= '2019-11-27') 0.006080150604248
(249) DESCRIBE `avid_specials` 0.0013599395751953
(250) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57752 and class = 'Cruise') OR (item_id = 818 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0013000965118408
(251) DESCRIBE `cruiselines` 0.0021967887878418
(252) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00040698051452637
(253) DESCRIBE `orchid_image` 0.0015900135040283
(254) DESCRIBE `cruiselines` 0.0017991065979004
(255) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00035405158996582
(256) DESCRIBE `cruises` 0.003324031829834
(257) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56235') 0.00044703483581543
(258) DESCRIBE `ships` 0.003201961517334
(259) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.0003201961517334
(260) DESCRIBE `ships` 0.0032961368560791
(261) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.0003349781036377
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00028514862060547
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029182434082031
(264) DESCRIBE `itineraries` 0.0015850067138672
(265) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56235') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081086158752441
(266) DESCRIBE `ports` 0.0018370151519775
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00044703483581543
(268) DESCRIBE `ports` 0.0016601085662842
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0003669261932373
(270) DESCRIBE `ports` 0.0017869472503662
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00040793418884277
(272) DESCRIBE `sailingdates` 0.0016109943389893
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56235') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00090694427490234
(274) DESCRIBE `ports` 0.0020320415496826
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00047492980957031
(276) DESCRIBE `ports` 0.0016748905181885
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00036787986755371
(278) DESCRIBE `ports` 0.0019359588623047
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0004730224609375
(280) DESCRIBE `ports` 0.0018548965454102
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00042605400085449
(282) DESCRIBE `ports` 0.0019090175628662
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00051307678222656
(284) DESCRIBE `ports` 0.0018949508666992
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00042986869812012
(286) DESCRIBE `ports` 0.0018880367279053
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00027298927307129
(288) DESCRIBE `ports` 0.0019369125366211
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00044417381286621
(290) DESCRIBE `ports` 0.0018970966339111
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00048303604125977
(292) DESCRIBE `ports` 0.0021491050720215
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00045990943908691
(294) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56235') AND (sailingdate >= '2019-11-27') 0.009260892868042
(295) DESCRIBE `avid_specials` 0.0019161701202393
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56235 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0016319751739502
(297) DESCRIBE `cruiselines` 0.0026240348815918
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00046920776367188
(299) DESCRIBE `orchid_image` 0.0020668506622314
(300) DESCRIBE `cruiselines` 0.0025620460510254
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00042891502380371
(302) DESCRIBE `cruises` 0.0036909580230713
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80578') 0.0005488395690918
(304) DESCRIBE `ships` 0.0041401386260986
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00061607360839844
(306) DESCRIBE `ships` 0.0041539669036865
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00056004524230957
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00039005279541016
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00044393539428711
(310) DESCRIBE `itineraries` 0.0017209053039551
(311) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80578') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061607360839844
(312) DESCRIBE `ports` 0.0021870136260986
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00050711631774902
(314) DESCRIBE `ports` 0.0018808841705322
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00043201446533203
(316) DESCRIBE `ports` 0.0017721652984619
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00038814544677734
(318) DESCRIBE `sailingdates` 0.0014359951019287
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80578') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069904327392578
(320) DESCRIBE `ports` 0.0017139911651611
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038003921508789
(322) DESCRIBE `ports` 0.0016112327575684
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00031399726867676
(324) DESCRIBE `ports` 0.0016779899597168
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039410591125488
(326) DESCRIBE `ports` 0.0017518997192383
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036907196044922
(328) DESCRIBE `ports` 0.0017240047454834
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00039196014404297
(330) DESCRIBE `ports` 0.0017468929290771
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00040197372436523
(332) DESCRIBE `ports` 0.0017008781433105
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00043106079101562
(334) DESCRIBE `ports` 0.0018439292907715
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00039911270141602
(336) DESCRIBE `ports` 0.0018248558044434
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00049304962158203
(338) DESCRIBE `ports` 0.001863956451416
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00034403800964355
(340) DESCRIBE `ports` 0.0013289451599121
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00033402442932129
(342) DESCRIBE `ports` 0.0017030239105225
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00030303001403809
(344) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80578') AND (sailingdate >= '2019-11-27') 0.0059549808502197
(345) DESCRIBE `avid_specials` 0.00148606300354
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80578 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016369819641113
(347) DESCRIBE `cruiselines` 0.0026099681854248
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00053191184997559
(349) DESCRIBE `orchid_image` 0.0019538402557373
(350) DESCRIBE `cruiselines` 0.002208948135376
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00040602684020996
(352) DESCRIBE `cruises` 0.0039610862731934
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77978') 0.00048995018005371
(354) DESCRIBE `ships` 0.0037910938262939
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00060200691223145
(356) DESCRIBE `ships` 0.0045719146728516
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.0006110668182373
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038814544677734
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034713745117188
(360) DESCRIBE `itineraries` 0.0022401809692383
(361) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0018250942230225
(362) DESCRIBE `ports` 0.0021319389343262
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0004420280456543
(364) DESCRIBE `ports` 0.0023398399353027
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00055098533630371
(366) DESCRIBE `ports` 0.0023069381713867
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00037789344787598
(368) DESCRIBE `sailingdates` 0.0021378993988037
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77978') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011801719665527
(370) DESCRIBE `ports` 0.0022809505462646
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00048995018005371
(372) DESCRIBE `ports` 0.0019969940185547
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00043296813964844
(374) DESCRIBE `ports` 0.0020749568939209
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00048589706420898
(376) DESCRIBE `ports` 0.0020871162414551
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00043916702270508
(378) DESCRIBE `ports` 0.0019969940185547
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00043106079101562
(380) DESCRIBE `ports` 0.0018739700317383
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00041604042053223
(382) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77978') AND (sailingdate >= '2019-11-27') 0.0090961456298828
(383) DESCRIBE `avid_specials` 0.0019350051879883
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77978 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0018410682678223
(385) DESCRIBE `cruiselines` 0.0027320384979248
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00058913230895996
(387) DESCRIBE `orchid_image` 0.002183198928833
(388) DESCRIBE `cruiselines` 0.0026319026947021
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00034689903259277
(390) DESCRIBE `cruises` 0.0035660266876221
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77979') 0.00045514106750488
(392) DESCRIBE `ships` 0.0035710334777832
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00049114227294922
(394) DESCRIBE `ships` 0.0033669471740723
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00038981437683105
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026893615722656
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025486946105957
(398) DESCRIBE `itineraries` 0.0015239715576172
(399) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77979') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054407119750977
(400) DESCRIBE `ports` 0.0017311573028564
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00041580200195312
(402) DESCRIBE `ports` 0.0018100738525391
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00050497055053711
(404) DESCRIBE `ports` 0.0020039081573486
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00046586990356445
(406) DESCRIBE `sailingdates` 0.0017609596252441
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77979') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081801414489746
(408) DESCRIBE `ports` 0.0020811557769775
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00047492980957031
(410) DESCRIBE `ports` 0.0015380382537842
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00033903121948242
(412) DESCRIBE `ports` 0.0012710094451904
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00034904479980469
(414) DESCRIBE `ports` 0.0018391609191895
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00041413307189941
(416) DESCRIBE `ports` 0.0018231868743896
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00045609474182129
(418) DESCRIBE `ports` 0.001910924911499
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.0003960132598877
(420) DESCRIBE `ports` 0.0021219253540039
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00056982040405273
(422) DESCRIBE `ports` 0.0018830299377441
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00036501884460449
(424) DESCRIBE `ports` 0.0017120838165283
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00047802925109863
(426) DESCRIBE `ports` 0.0019140243530273
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00040793418884277
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77979') AND (sailingdate >= '2019-11-27') 0.0092718601226807
(429) DESCRIBE `avid_specials` 0.0019409656524658
(430) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77979 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0016579627990723
(431) DESCRIBE `cruiselines` 0.0027070045471191
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00048398971557617
(433) DESCRIBE `orchid_image` 0.0019659996032715
(434) DESCRIBE `cruiselines` 0.0025780200958252
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0004429817199707
(436) DESCRIBE `ships` 0.0039730072021484
(437) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1308', '818', '1730', '1479')) ORDER BY FIND_IN_SET(id, '1454,1308,818,1730,1479') 0.0014040470123291
(438) DESCRIBE `cruisetypes` 0.0019149780273438
(439) DESCRIBE `destinations` 0.0025229454040527
(440) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('21', '40', '25', '26', '28', '8', '49', '35', '30', '55')) ORDER BY FIND_IN_SET(id, '21,40,25,26,28,8,49,35,30,55') 0.0017910003662109
(441) DESCRIBE `cruiselines` 0.0035500526428223
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00055193901062012
(443) DESCRIBE `cruiselines` 0.0032649040222168
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0005488395690918