or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.88986825942993

# Query Time
(1) connect 0.0009918212890625
(2) DESCRIBE `cruises` 0.0043659210205078
(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.0028228759765625
(4) DESCRIBE `cruises` 0.0038061141967773
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80643') 0.00058197975158691
(6) DESCRIBE `ships` 0.0038559436798096
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00061702728271484
(8) DESCRIBE `ships` 0.0040278434753418
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00049400329589844
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003359317779541
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00031208992004395
(12) DESCRIBE `itineraries` 0.0018799304962158
(13) DESCRIBE `ports` 0.0022199153900146
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00070095062255859
(15) DESCRIBE `ports` 0.0019488334655762
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00055193901062012
(17) DESCRIBE `ports` 0.0018970966339111
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046801567077637
(19) DESCRIBE `sailingdates` 0.0016109943389893
(20) DESCRIBE `ports` 0.0022070407867432
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00052404403686523
(22) DESCRIBE `ports` 0.0020139217376709
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00044894218444824
(24) DESCRIBE `ports` 0.001816987991333
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056314468383789
(26) DESCRIBE `ports` 0.0017499923706055
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045585632324219
(28) DESCRIBE `ports` 0.0016989707946777
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00044798851013184
(30) DESCRIBE `ports` 0.0017900466918945
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00041079521179199
(32) DESCRIBE `ports` 0.0021491050720215
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005180835723877
(34) DESCRIBE `ports` 0.0020639896392822
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00050210952758789
(36) DESCRIBE `ports` 0.0019330978393555
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049686431884766
(38) DESCRIBE `ports` 0.00211501121521
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00045609474182129
(40) 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.012250900268555
(41) DESCRIBE `avid_specials` 0.0019450187683105
(42) 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.002000093460083
(43) DESCRIBE `cruiselines` 0.0030090808868408
(44) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00064992904663086
(45) DESCRIBE `orchid_image` 0.0025529861450195
(46) DESCRIBE `cruiselines` 0.004951000213623
(47) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00075984001159668
(48) DESCRIBE `cruises` 0.004706859588623
(49) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80644') 0.0014691352844238
(50) DESCRIBE `ships` 0.0064718723297119
(51) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.0033090114593506
(52) DESCRIBE `ships` 0.0047750473022461
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00070381164550781
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00052499771118164
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032806396484375
(56) DESCRIBE `itineraries` 0.0059988498687744
(57) DESCRIBE `ports` 0.0021781921386719
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00058197975158691
(59) DESCRIBE `ports` 0.0021398067474365
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0006568431854248
(61) DESCRIBE `ports` 0.0027158260345459
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0051999092102051
(63) DESCRIBE `sailingdates` 0.0018677711486816
(64) DESCRIBE `ports` 0.0021541118621826
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00052905082702637
(66) DESCRIBE `ports` 0.0096690654754639
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0012857913970947
(68) DESCRIBE `ports` 0.012946844100952
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0023729801177979
(70) DESCRIBE `ports` 0.0021288394927979
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052094459533691
(72) 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.0087969303131104
(73) DESCRIBE `avid_specials` 0.0051388740539551
(74) 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.0022919178009033
(75) DESCRIBE `cruiselines` 0.0046920776367188
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00062179565429688
(77) DESCRIBE `orchid_image` 0.0031459331512451
(78) DESCRIBE `cruiselines` 0.0043449401855469
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00056099891662598
(80) DESCRIBE `cruises` 0.0037808418273926
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80576') 0.0014259815216064
(82) DESCRIBE `ships` 0.0040991306304932
(83) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00068211555480957
(84) DESCRIBE `ships` 0.0042221546173096
(85) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00054502487182617
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00056195259094238
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00033783912658691
(88) DESCRIBE `itineraries` 0.0023438930511475
(89) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80576') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0041611194610596
(90) DESCRIBE `ports` 0.0022518634796143
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055885314941406
(92) DESCRIBE `ports` 0.0021240711212158
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061488151550293
(94) DESCRIBE `ports` 0.002377986907959
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054097175598145
(96) DESCRIBE `sailingdates` 0.0055899620056152
(97) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80576') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0015270709991455
(98) DESCRIBE `ports` 0.0037400722503662
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00081086158752441
(100) DESCRIBE `ports` 0.0021591186523438
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0014150142669678
(102) DESCRIBE `ports` 0.002302885055542
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00066900253295898
(104) DESCRIBE `ports` 0.0021140575408936
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00047707557678223
(106) DESCRIBE `ports` 0.002251148223877
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051403045654297
(108) DESCRIBE `ports` 0.0020570755004883
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043106079101562
(110) DESCRIBE `ports` 0.0019419193267822
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049591064453125
(112) DESCRIBE `ports` 0.0019791126251221
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0004417896270752
(114) 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.008793830871582
(115) DESCRIBE `avid_specials` 0.00193190574646
(116) 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.0020210742950439
(117) DESCRIBE `cruiselines` 0.0029110908508301
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0006568431854248
(119) DESCRIBE `orchid_image` 0.0028021335601807
(120) DESCRIBE `cruiselines` 0.0034530162811279
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.0010747909545898
(122) DESCRIBE `cruises` 0.0043752193450928
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61570') 0.00065708160400391
(124) DESCRIBE `ships` 0.0067858695983887
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00090789794921875
(126) DESCRIBE `ships` 0.0044529438018799
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.0013930797576904
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048112869262695
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00056314468383789
(130) DESCRIBE `itineraries` 0.0022950172424316
(131) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61570') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011589527130127
(132) DESCRIBE `ports` 0.0022518634796143
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00051999092102051
(134) DESCRIBE `ports` 0.0018830299377441
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00047397613525391
(136) DESCRIBE `ports` 0.0020248889923096
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00046706199645996
(138) DESCRIBE `sailingdates` 0.0018880367279053
(139) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61570') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013999938964844
(140) DESCRIBE `ports` 0.0023548603057861
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0005340576171875
(142) DESCRIBE `ports` 0.0019600391387939
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00052785873413086
(144) DESCRIBE `ports` 0.0019888877868652
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00052499771118164
(146) DESCRIBE `ports` 0.0020430088043213
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00045394897460938
(148) DESCRIBE `ports` 0.0023059844970703
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00046682357788086
(150) DESCRIBE `ports` 0.0021131038665771
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00045490264892578
(152) DESCRIBE `ports` 0.002108097076416
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00051999092102051
(154) DESCRIBE `ports` 0.0032470226287842
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0018219947814941
(156) 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.019065856933594
(157) DESCRIBE `avid_specials` 0.0025100708007812
(158) 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.0024588108062744
(159) DESCRIBE `cruiselines` 0.0031149387359619
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00073099136352539
(161) DESCRIBE `orchid_image` 0.0027809143066406
(162) DESCRIBE `cruiselines` 0.0031650066375732
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00073814392089844
(164) DESCRIBE `cruises` 0.0057609081268311
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80577') 0.00068497657775879
(166) DESCRIBE `ships` 0.0053279399871826
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.0011088848114014
(168) DESCRIBE `ships` 0.0050241947174072
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00081706047058105
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003511905670166
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032305717468262
(172) DESCRIBE `itineraries` 0.0020542144775391
(173) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80577') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00091099739074707
(174) DESCRIBE `ports` 0.0022449493408203
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00056195259094238
(176) DESCRIBE `ports` 0.0022749900817871
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0031390190124512
(178) DESCRIBE `ports` 0.0023460388183594
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00081205368041992
(180) DESCRIBE `sailingdates` 0.0020411014556885
(181) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80577') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00088310241699219
(182) DESCRIBE `ports` 0.0030419826507568
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00076699256896973
(184) DESCRIBE `ports` 0.0032119750976562
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0010130405426025
(186) DESCRIBE `ports` 0.0020959377288818
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6035))) 0.00084185600280762
(188) DESCRIBE `ports` 0.0021810531616211
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6035') 0.00045609474182129
(190) DESCRIBE `ports` 0.0035250186920166
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00053095817565918
(192) DESCRIBE `ports` 0.0018601417541504
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.0004580020904541
(194) DESCRIBE `ports` 0.0020151138305664
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00065803527832031
(196) DESCRIBE `ports` 0.0022280216217041
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00054121017456055
(198) 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.013514041900635
(199) DESCRIBE `avid_specials` 0.0028319358825684
(200) 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.0033018589019775
(201) DESCRIBE `cruiselines` 0.003058910369873
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00061798095703125
(203) DESCRIBE `orchid_image` 0.0022270679473877
(204) DESCRIBE `cruiselines` 0.0030338764190674
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00054407119750977
(206) DESCRIBE `cruises` 0.0039150714874268
(207) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57752') 0.00058388710021973
(208) DESCRIBE `ships` 0.0043468475341797
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.00075602531433105
(210) DESCRIBE `ships` 0.0042920112609863
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00061988830566406
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038480758666992
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035381317138672
(214) DESCRIBE `itineraries` 0.0020561218261719
(215) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57752') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011160373687744
(216) DESCRIBE `ports` 0.0026907920837402
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00052404403686523
(218) DESCRIBE `ports` 0.0020430088043213
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.001107931137085
(220) DESCRIBE `ports` 0.0041501522064209
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00056695938110352
(222) DESCRIBE `sailingdates` 0.0018911361694336
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57752') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001121997833252
(224) DESCRIBE `ports` 0.0022540092468262
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00063014030456543
(226) DESCRIBE `ports` 0.0027410984039307
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00046491622924805
(228) DESCRIBE `ports` 0.002439022064209
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00052189826965332
(230) DESCRIBE `ports` 0.0017690658569336
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00047492980957031
(232) DESCRIBE `ports` 0.0018110275268555
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00048708915710449
(234) DESCRIBE `ports` 0.0022377967834473
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00051093101501465
(236) DESCRIBE `ports` 0.0020828247070312
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00051283836364746
(238) DESCRIBE `ports` 0.0019760131835938
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00042891502380371
(240) DESCRIBE `ports` 0.0019609928131104
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00062704086303711
(242) DESCRIBE `ports` 0.0022759437561035
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00046396255493164
(244) 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.0095701217651367
(245) DESCRIBE `avid_specials` 0.0018970966339111
(246) 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.0020499229431152
(247) DESCRIBE `cruiselines` 0.0030641555786133
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00054383277893066
(249) DESCRIBE `orchid_image` 0.0019340515136719
(250) DESCRIBE `cruiselines` 0.0025260448455811
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00048398971557617
(252) DESCRIBE `cruises` 0.0047461986541748
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56235') 0.00053596496582031
(254) DESCRIBE `ships` 0.0038230419158936
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00077486038208008
(256) DESCRIBE `ships` 0.0037939548492432
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.0005500316619873
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00041699409484863
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034809112548828
(260) DESCRIBE `itineraries` 0.0018870830535889
(261) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56235') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00093603134155273
(262) DESCRIBE `ports` 0.0020871162414551
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00050091743469238
(264) DESCRIBE `ports` 0.0026261806488037
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00080394744873047
(266) DESCRIBE `ports` 0.0021710395812988
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00086283683776855
(268) DESCRIBE `sailingdates` 0.0021491050720215
(269) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56235') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013220310211182
(270) DESCRIBE `ports` 0.0039799213409424
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00061893463134766
(272) DESCRIBE `ports` 0.021255016326904
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00054407119750977
(274) DESCRIBE `ports` 0.0022151470184326
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00058102607727051
(276) DESCRIBE `ports` 0.0021190643310547
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00050783157348633
(278) DESCRIBE `ports` 0.0018210411071777
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00050115585327148
(280) DESCRIBE `ports` 0.0018270015716553
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00046992301940918
(282) DESCRIBE `ports` 0.0022730827331543
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00049185752868652
(284) DESCRIBE `ports` 0.0020339488983154
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00051307678222656
(286) DESCRIBE `ports` 0.0019931793212891
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00051498413085938
(288) DESCRIBE `ports` 0.0021228790283203
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00051498413085938
(290) 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.0094540119171143
(291) DESCRIBE `avid_specials` 0.0020079612731934
(292) 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.0017900466918945
(293) DESCRIBE `cruiselines` 0.0028319358825684
(294) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0006101131439209
(295) DESCRIBE `orchid_image` 0.0021829605102539
(296) DESCRIBE `cruiselines` 0.0028290748596191
(297) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00063490867614746
(298) DESCRIBE `cruises` 0.0070850849151611
(299) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80578') 0.00059413909912109
(300) DESCRIBE `ships` 0.0049269199371338
(301) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00096297264099121
(302) DESCRIBE `ships` 0.0045199394226074
(303) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.0006558895111084
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038909912109375
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00057101249694824
(306) DESCRIBE `itineraries` 0.0020477771759033
(307) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80578') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.000946044921875
(308) DESCRIBE `ports` 0.0022339820861816
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049495697021484
(310) DESCRIBE `ports` 0.0019979476928711
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00048279762268066
(312) DESCRIBE `ports` 0.001884937286377
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00041699409484863
(314) DESCRIBE `sailingdates` 0.001755952835083
(315) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80578') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007631778717041
(316) DESCRIBE `ports` 0.0020558834075928
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049591064453125
(318) DESCRIBE `ports` 0.0019040107727051
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00043106079101562
(320) DESCRIBE `ports` 0.0018949508666992
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00056815147399902
(322) DESCRIBE `ports` 0.001863956451416
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039482116699219
(324) DESCRIBE `ports` 0.0019478797912598
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0004429817199707
(326) DESCRIBE `ports` 0.0019080638885498
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00042486190795898
(328) DESCRIBE `ports` 0.0019040107727051
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00047087669372559
(330) DESCRIBE `ports` 0.0019421577453613
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00043487548828125
(332) DESCRIBE `ports` 0.0019059181213379
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00048589706420898
(334) DESCRIBE `ports` 0.0018899440765381
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00046682357788086
(336) DESCRIBE `ports` 0.0018730163574219
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00046992301940918
(338) DESCRIBE `ports` 0.0019369125366211
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00043177604675293
(340) 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.0087058544158936
(341) DESCRIBE `avid_specials` 0.0020208358764648
(342) 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.0018129348754883
(343) DESCRIBE `cruiselines` 0.0028278827667236
(344) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00059390068054199
(345) DESCRIBE `orchid_image` 0.0024449825286865
(346) DESCRIBE `cruiselines` 0.0030441284179688
(347) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00051784515380859
(348) DESCRIBE `cruises` 0.004054069519043
(349) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77978') 0.00059199333190918
(350) DESCRIBE `ships` 0.0037999153137207
(351) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00079488754272461
(352) DESCRIBE `ships` 0.0041120052337646
(353) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00053095817565918
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00040388107299805
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003509521484375
(356) DESCRIBE `itineraries` 0.001878023147583
(357) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083303451538086
(358) DESCRIBE `ports` 0.0019960403442383
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00049495697021484
(360) DESCRIBE `ports` 0.0019829273223877
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00044512748718262
(362) DESCRIBE `ports` 0.0020790100097656
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00043892860412598
(364) DESCRIBE `sailingdates` 0.0016820430755615
(365) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77978') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093603134155273
(366) DESCRIBE `ports` 0.0021090507507324
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00056815147399902
(368) DESCRIBE `ports` 0.0019400119781494
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00051593780517578
(370) DESCRIBE `ports` 0.0022110939025879
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00077414512634277
(372) DESCRIBE `ports` 0.0036118030548096
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00055694580078125
(374) DESCRIBE `ports` 0.0022428035736084
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00054597854614258
(376) DESCRIBE `ports` 0.0027251243591309
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.0010240077972412
(378) 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.019877910614014
(379) DESCRIBE `avid_specials` 0.0019819736480713
(380) 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.0019679069519043
(381) DESCRIBE `cruiselines` 0.0030760765075684
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00056695938110352
(383) DESCRIBE `orchid_image` 0.002249002456665
(384) DESCRIBE `cruiselines` 0.0029778480529785
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00051307678222656
(386) DESCRIBE `cruises` 0.0035398006439209
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77979') 0.00047683715820312
(388) DESCRIBE `ships` 0.0035037994384766
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0011899471282959
(390) DESCRIBE `ships` 0.005424976348877
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.000701904296875
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00044608116149902
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034809112548828
(394) DESCRIBE `itineraries` 0.0026249885559082
(395) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77979') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081491470336914
(396) DESCRIBE `ports` 0.0048129558563232
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0012409687042236
(398) DESCRIBE `ports` 0.0027508735656738
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00069808959960938
(400) DESCRIBE `ports` 0.0024440288543701
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00051689147949219
(402) DESCRIBE `sailingdates` 0.0020520687103271
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77979') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00086498260498047
(404) DESCRIBE `ports` 0.0020089149475098
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0004730224609375
(406) DESCRIBE `ports` 0.0017600059509277
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00039410591125488
(408) DESCRIBE `ports` 0.0017600059509277
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00049996376037598
(410) DESCRIBE `ports` 0.0022640228271484
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00054097175598145
(412) DESCRIBE `ports` 0.0017669200897217
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00039386749267578
(414) DESCRIBE `ports` 0.0014870166778564
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00029397010803223
(416) DESCRIBE `ports` 0.0016031265258789
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00042295455932617
(418) DESCRIBE `ports` 0.0013289451599121
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00029397010803223
(420) DESCRIBE `ports` 0.001474142074585
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031805038452148
(422) DESCRIBE `ports` 0.0013730525970459
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00033712387084961
(424) 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.0056910514831543
(425) DESCRIBE `avid_specials` 0.0014019012451172
(426) 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.0010881423950195
(427) DESCRIBE `cruiselines` 0.0022449493408203
(428) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00042080879211426
(429) DESCRIBE `orchid_image` 0.0016360282897949
(430) DESCRIBE `cruiselines` 0.0021059513092041
(431) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00039815902709961
(432) DESCRIBE `ships` 0.0037379264831543
(433) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1308', '818', '1730', '1479')) ORDER BY FIND_IN_SET(id, '1454,1308,818,1730,1479') 0.0010550022125244
(434) DESCRIBE `cruisetypes` 0.001399040222168
(435) DESCRIBE `destinations` 0.0022900104522705
(436) 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.0020809173583984
(437) DESCRIBE `cruiselines` 0.0027289390563965
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00051593780517578
(439) DESCRIBE `cruiselines` 0.0025639533996582
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0005640983581543