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

Total elapsed time: 0.85965728759766

# Query Time
(1) connect 0.00079703330993652
(2) DESCRIBE `cruises` 0.0029850006103516
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75314, 75299, 75301, 75300, 75316, 75317, 75318, 75328, 75319, 75326)) ORDER BY FIND_IN_SET(id, '75314,75299,75301,75300,75316,75317,75318,75328,75319,75326') 0.0020029544830322
(4) DESCRIBE `cruises` 0.0026590824127197
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75314') 0.00043296813964844
(6) DESCRIBE `ships` 0.002547025680542
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00039196014404297
(8) DESCRIBE `ships` 0.0025308132171631
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00026798248291016
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027108192443848
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025486946105957
(12) DESCRIBE `itineraries` 0.0012609958648682
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75314') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012319087982178
(14) DESCRIBE `ports` 0.0013468265533447
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032305717468262
(16) DESCRIBE `ports` 0.0013458728790283
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030398368835449
(18) DESCRIBE `ports` 0.0013878345489502
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002739429473877
(20) DESCRIBE `sailingdates` 0.0010950565338135
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75314') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070500373840332
(22) DESCRIBE `ports` 0.0016579627990723
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037503242492676
(24) DESCRIBE `ports` 0.0013971328735352
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034904479980469
(26) DESCRIBE `ports` 0.0013859272003174
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00030994415283203
(28) DESCRIBE `ports` 0.0013070106506348
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00028896331787109
(30) DESCRIBE `ports` 0.0014698505401611
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00029706954956055
(32) DESCRIBE `ports` 0.0016911029815674
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00037193298339844
(34) DESCRIBE `ports` 0.0015850067138672
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00033688545227051
(36) DESCRIBE `ports` 0.0012919902801514
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00027012825012207
(38) DESCRIBE `ports` 0.0013809204101562
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00034594535827637
(40) DESCRIBE `ports` 0.0015790462493896
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00034594535827637
(42) DESCRIBE `ports` 0.0017471313476562
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039005279541016
(44) DESCRIBE `ports` 0.0017688274383545
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031089782714844
(46) DESCRIBE `ports` 0.0012669563293457
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00034594535827637
(48) DESCRIBE `ports` 0.0013368129730225
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00033998489379883
(50) DESCRIBE `ports` 0.0013999938964844
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0003509521484375
(52) DESCRIBE `ports` 0.0014688968658447
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00033187866210938
(54) DESCRIBE `ports` 0.0012898445129395
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030708312988281
(56) DESCRIBE `ports` 0.0012538433074951
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026702880859375
(58) DESCRIBE `ports` 0.0013110637664795
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00028300285339355
(60) DESCRIBE `ports` 0.001305103302002
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026893615722656
(62) DESCRIBE `ports` 0.0013461112976074
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00032711029052734
(64) DESCRIBE `ports` 0.0012729167938232
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00033402442932129
(66) DESCRIBE `ports` 0.0012309551239014
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029397010803223
(68) DESCRIBE `ports` 0.0013530254364014
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031018257141113
(70) DESCRIBE `ports` 0.0014891624450684
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033307075500488
(72) DESCRIBE `ports` 0.0013120174407959
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031280517578125
(74) DESCRIBE `ports` 0.0013141632080078
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034785270690918
(76) DESCRIBE `ports` 0.0014700889587402
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028300285339355
(78) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75314') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.008112907409668
(79) DESCRIBE `avid_specials` 0.0017950534820557
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75314 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0011780261993408
(81) DESCRIBE `cruiselines` 0.0019519329071045
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00035810470581055
(83) DESCRIBE `orchid_image` 0.0015959739685059
(84) DESCRIBE `cruiselines` 0.0018959045410156
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00031280517578125
(86) DESCRIBE `cruises` 0.0025420188903809
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75299') 0.00042605400085449
(88) DESCRIBE `ships` 0.0026841163635254
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00036406517028809
(90) DESCRIBE `ships` 0.0026781558990479
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00031685829162598
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025200843811035
(94) DESCRIBE `itineraries` 0.0013518333435059
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75299') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055408477783203
(96) DESCRIBE `ports` 0.0014889240264893
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00035309791564941
(98) DESCRIBE `ports` 0.001384973526001
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00032711029052734
(100) DESCRIBE `ports` 0.0014538764953613
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00035500526428223
(102) DESCRIBE `sailingdates` 0.0011100769042969
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75299') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055193901062012
(104) DESCRIBE `ports` 0.0017309188842773
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00041699409484863
(106) DESCRIBE `ports` 0.0013179779052734
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00034785270690918
(108) DESCRIBE `ports` 0.0014069080352783
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030398368835449
(110) DESCRIBE `ports` 0.0012731552124023
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027179718017578
(112) DESCRIBE `ports` 0.0012331008911133
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00028395652770996
(114) DESCRIBE `ports` 0.0012960433959961
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00034093856811523
(116) DESCRIBE `ports` 0.0013101100921631
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00032997131347656
(118) DESCRIBE `ports` 0.0012469291687012
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00027108192443848
(120) DESCRIBE `ports` 0.0012760162353516
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028610229492188
(122) DESCRIBE `ports` 0.00130295753479
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00027298927307129
(124) DESCRIBE `ports` 0.0013129711151123
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029706954956055
(126) DESCRIBE `ports` 0.0012509822845459
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00035285949707031
(128) DESCRIBE `ports` 0.0014500617980957
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029683113098145
(130) DESCRIBE `ports` 0.0012469291687012
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027203559875488
(132) DESCRIBE `ports` 0.001276969909668
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029706954956055
(134) DESCRIBE `ports` 0.0013070106506348
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00057697296142578
(136) DESCRIBE `ports` 0.0017209053039551
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040578842163086
(138) DESCRIBE `ports` 0.0017988681793213
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037288665771484
(140) DESCRIBE `ports` 0.0016541481018066
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032496452331543
(142) DESCRIBE `ports` 0.0012669563293457
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027608871459961
(144) DESCRIBE `ports` 0.0014028549194336
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031399726867676
(146) DESCRIBE `ports` 0.00130295753479
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00028300285339355
(148) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75299') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0051200389862061
(149) DESCRIBE `avid_specials` 0.0014159679412842
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75299 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0010769367218018
(151) DESCRIBE `cruiselines` 0.0019481182098389
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00033187866210938
(153) DESCRIBE `orchid_image` 0.0013890266418457
(154) DESCRIBE `cruiselines` 0.0022330284118652
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00028896331787109
(156) DESCRIBE `cruises` 0.0031149387359619
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75301') 0.00046014785766602
(158) DESCRIBE `ships` 0.0038540363311768
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00056099891662598
(160) DESCRIBE `ships` 0.0035059452056885
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00050592422485352
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032711029052734
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037693977355957
(164) DESCRIBE `itineraries` 0.0018110275268555
(165) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75301') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070095062255859
(166) DESCRIBE `ports` 0.0018360614776611
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044488906860352
(168) DESCRIBE `ports` 0.0018990039825439
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049304962158203
(170) DESCRIBE `ports` 0.0018770694732666
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043201446533203
(172) DESCRIBE `sailingdates` 0.001366138458252
(173) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75301') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067496299743652
(174) DESCRIBE `ports` 0.0017478466033936
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037097930908203
(176) DESCRIBE `ports` 0.0016238689422607
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038313865661621
(178) DESCRIBE `ports` 0.0016939640045166
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00034999847412109
(180) DESCRIBE `ports` 0.0018970966339111
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00046491622924805
(182) DESCRIBE `ports` 0.0016539096832275
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00045299530029297
(184) DESCRIBE `ports` 0.0018918514251709
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00031280517578125
(186) DESCRIBE `ports` 0.0016829967498779
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036311149597168
(188) DESCRIBE `ports` 0.001370906829834
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030183792114258
(190) DESCRIBE `ports` 0.0014472007751465
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00031399726867676
(192) DESCRIBE `ports` 0.0013129711151123
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037789344787598
(194) DESCRIBE `ports` 0.0014159679412842
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00036907196044922
(196) DESCRIBE `ports` 0.0014541149139404
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037503242492676
(198) DESCRIBE `ports` 0.0017931461334229
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034189224243164
(200) DESCRIBE `ports` 0.0013899803161621
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027799606323242
(202) DESCRIBE `ports` 0.0013618469238281
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029087066650391
(204) DESCRIBE `ports` 0.0013320446014404
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031185150146484
(206) DESCRIBE `ports` 0.0012857913970947
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032806396484375
(208) DESCRIBE `ports` 0.0015950202941895
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003058910369873
(210) DESCRIBE `ports` 0.001478910446167
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031399726867676
(212) DESCRIBE `ports` 0.0012519359588623
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00027585029602051
(214) DESCRIBE `ports` 0.0013420581817627
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.0002901554107666
(216) DESCRIBE `ports` 0.0012919902801514
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.0003361701965332
(218) DESCRIBE `ports` 0.0015208721160889
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00033998489379883
(220) DESCRIBE `ports` 0.0012671947479248
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028705596923828
(222) DESCRIBE `ports` 0.001276969909668
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034213066101074
(224) DESCRIBE `ports` 0.0014939308166504
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030994415283203
(226) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75301') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0082309246063232
(227) DESCRIBE `avid_specials` 0.001823902130127
(228) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75301 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0010929107666016
(229) DESCRIBE `cruiselines` 0.0021710395812988
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00063085556030273
(231) DESCRIBE `orchid_image` 0.0020930767059326
(232) DESCRIBE `cruiselines` 0.0025629997253418
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00043892860412598
(234) DESCRIBE `cruises` 0.0034899711608887
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75300') 0.00046801567077637
(236) DESCRIBE `ships` 0.0035669803619385
(237) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00059795379638672
(238) DESCRIBE `ships` 0.0031058788299561
(239) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00043702125549316
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(242) DESCRIBE `itineraries` 0.0015439987182617
(243) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75300') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057816505432129
(244) DESCRIBE `ports` 0.0015168190002441
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031304359436035
(246) DESCRIBE `ports` 0.0013890266418457
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003659725189209
(248) DESCRIBE `ports` 0.0013549327850342
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028514862060547
(250) DESCRIBE `sailingdates` 0.001230001449585
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75300') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059986114501953
(252) DESCRIBE `ports` 0.0013959407806396
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030994415283203
(254) DESCRIBE `ports` 0.0012519359588623
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003349781036377
(256) DESCRIBE `ports` 0.0013279914855957
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00031280517578125
(258) DESCRIBE `ports` 0.0015220642089844
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00027298927307129
(260) DESCRIBE `ports` 0.0013699531555176
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0003669261932373
(262) DESCRIBE `ports` 0.0013420581817627
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00032877922058105
(264) DESCRIBE `ports` 0.0013279914855957
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029420852661133
(266) DESCRIBE `ports` 0.0012750625610352
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028085708618164
(268) DESCRIBE `ports` 0.0018608570098877
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00037002563476562
(270) DESCRIBE `ports` 0.0015549659729004
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0002899169921875
(272) DESCRIBE `ports` 0.0016088485717773
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030899047851562
(274) DESCRIBE `ports` 0.0013761520385742
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00033283233642578
(276) DESCRIBE `ports` 0.001507043838501
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031399726867676
(278) DESCRIBE `ports` 0.0012650489807129
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(280) DESCRIBE `ports` 0.0015039443969727
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00035405158996582
(282) DESCRIBE `ports` 0.0017240047454834
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038003921508789
(284) DESCRIBE `ports` 0.0013909339904785
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030899047851562
(286) DESCRIBE `ports` 0.0012879371643066
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027990341186523
(288) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75300') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0054678916931152
(289) DESCRIBE `avid_specials` 0.0013408660888672
(290) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75300 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0011658668518066
(291) DESCRIBE `cruiselines` 0.001856803894043
(292) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00034904479980469
(293) DESCRIBE `orchid_image` 0.0014472007751465
(294) DESCRIBE `cruiselines` 0.0019590854644775
(295) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00031685829162598
(296) DESCRIBE `cruises` 0.002615213394165
(297) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75316') 0.00034689903259277
(298) DESCRIBE `ships` 0.002918004989624
(299) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00040817260742188
(300) DESCRIBE `ships` 0.0025899410247803
(301) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.0003211498260498
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(304) DESCRIBE `itineraries` 0.0012540817260742
(305) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75316') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056219100952148
(306) DESCRIBE `ports` 0.0016500949859619
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003511905670166
(308) DESCRIBE `ports` 0.0012671947479248
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029802322387695
(310) DESCRIBE `ports` 0.0013408660888672
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028109550476074
(312) DESCRIBE `sailingdates` 0.0011799335479736
(313) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75316') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053787231445312
(314) DESCRIBE `ports` 0.0013680458068848
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030303001403809
(316) DESCRIBE `ports` 0.0012519359588623
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00026893615722656
(318) DESCRIBE `ports` 0.001262903213501
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031304359436035
(320) DESCRIBE `ports` 0.00124192237854
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00026416778564453
(322) DESCRIBE `ports` 0.0013449192047119
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00030517578125
(324) DESCRIBE `ports` 0.0012960433959961
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00030684471130371
(326) DESCRIBE `ports` 0.0013461112976074
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00030899047851562
(328) DESCRIBE `ports` 0.0014550685882568
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00029206275939941
(330) DESCRIBE `ports` 0.0013148784637451
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030803680419922
(332) DESCRIBE `ports` 0.0012900829315186
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030207633972168
(334) DESCRIBE `ports` 0.0013060569763184
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00031900405883789
(336) DESCRIBE `ports` 0.0012919902801514
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00027894973754883
(338) DESCRIBE `ports` 0.0013000965118408
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030112266540527
(340) DESCRIBE `ports` 0.0012669563293457
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026679039001465
(342) DESCRIBE `ports` 0.0013258457183838
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029587745666504
(344) DESCRIBE `ports` 0.0012481212615967
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026798248291016
(346) DESCRIBE `ports` 0.0012378692626953
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00036001205444336
(348) DESCRIBE `ports` 0.001629114151001
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031399726867676
(350) DESCRIBE `ports` 0.0013449192047119
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00034403800964355
(352) DESCRIBE `ports` 0.0012779235839844
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00033092498779297
(354) DESCRIBE `ports` 0.0013470649719238
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029301643371582
(356) DESCRIBE `ports` 0.0013740062713623
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030994415283203
(358) DESCRIBE `ports` 0.0015339851379395
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00034713745117188
(360) DESCRIBE `ports` 0.0016028881072998
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0003349781036377
(362) DESCRIBE `ports` 0.0013649463653564
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036382675170898
(364) DESCRIBE `ports` 0.0012891292572021
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030303001403809
(366) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75316') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0052509307861328
(367) DESCRIBE `avid_specials` 0.0012879371643066
(368) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75316 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0012710094451904
(369) DESCRIBE `cruiselines` 0.0018579959869385
(370) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00032496452331543
(371) DESCRIBE `orchid_image` 0.0016260147094727
(372) DESCRIBE `cruiselines` 0.001849889755249
(373) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00030398368835449
(374) DESCRIBE `cruises` 0.0024759769439697
(375) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75317') 0.00036096572875977
(376) DESCRIBE `ships` 0.0032830238342285
(377) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00042390823364258
(378) DESCRIBE `ships` 0.0025949478149414
(379) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00029087066650391
(380) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(381) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025010108947754
(382) DESCRIBE `itineraries` 0.0012497901916504
(383) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75317') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051307678222656
(384) DESCRIBE `ports` 0.001554012298584
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00051307678222656
(386) DESCRIBE `ports` 0.0018908977508545
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038886070251465
(388) DESCRIBE `ports` 0.0017569065093994
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0003361701965332
(390) DESCRIBE `sailingdates` 0.0014300346374512
(391) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75317') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057888031005859
(392) DESCRIBE `ports` 0.001446008682251
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031900405883789
(394) DESCRIBE `ports` 0.0012519359588623
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00031208992004395
(396) DESCRIBE `ports` 0.0013120174407959
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00028395652770996
(398) DESCRIBE `ports` 0.0012521743774414
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00029706954956055
(400) DESCRIBE `ports` 0.0012500286102295
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00029802322387695
(402) DESCRIBE `ports` 0.0012800693511963
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00026893615722656
(404) DESCRIBE `ports` 0.0013391971588135
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00028514862060547
(406) DESCRIBE `ports` 0.001317024230957
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00026607513427734
(408) DESCRIBE `ports` 0.0012969970703125
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00031089782714844
(410) DESCRIBE `ports` 0.0017709732055664
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00033998489379883
(412) DESCRIBE `ports` 0.0017809867858887
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029492378234863
(414) DESCRIBE `ports` 0.0012719631195068
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026893615722656
(416) DESCRIBE `ports` 0.0012459754943848
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00035810470581055
(418) DESCRIBE `ports` 0.0012960433959961
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00027012825012207
(420) DESCRIBE `ports` 0.0012860298156738
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031709671020508
(422) DESCRIBE `ports` 0.0014050006866455
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00029087066650391
(424) DESCRIBE `ports` 0.0012638568878174
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00033688545227051
(426) DESCRIBE `ports` 0.0013980865478516
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00027298927307129
(428) DESCRIBE `ports` 0.0013749599456787
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030684471130371
(430) DESCRIBE `ports` 0.0012741088867188
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026702880859375
(432) DESCRIBE `ports` 0.0012929439544678
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00032401084899902
(434) DESCRIBE `ports` 0.0013210773468018
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0003049373626709
(436) DESCRIBE `ports` 0.0012390613555908
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029492378234863
(438) DESCRIBE `ports` 0.0012609958648682
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00026607513427734
(440) DESCRIBE `ports` 0.0012719631195068
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031900405883789
(442) DESCRIBE `ports` 0.0014228820800781
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0002748966217041
(444) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75317') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0050230026245117
(445) DESCRIBE `avid_specials` 0.0012469291687012
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75317 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.001060962677002
(447) DESCRIBE `cruiselines` 0.002007007598877
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00037002563476562
(449) DESCRIBE `orchid_image` 0.0017919540405273
(450) DESCRIBE `cruiselines` 0.0024168491363525
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00037193298339844
(452) DESCRIBE `cruises` 0.0024311542510986
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75318') 0.0003662109375
(454) DESCRIBE `ships` 0.0025031566619873
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00038409233093262
(456) DESCRIBE `ships` 0.0024459362030029
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00028204917907715
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026917457580566
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(460) DESCRIBE `itineraries` 0.0012080669403076
(461) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75318') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049519538879395
(462) DESCRIBE `ports` 0.001284122467041
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00031399726867676
(464) DESCRIBE `ports` 0.0014059543609619
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00039100646972656
(466) DESCRIBE `ports` 0.0013279914855957
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00027990341186523
(468) DESCRIBE `sailingdates` 0.0011119842529297
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75318') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056695938110352
(470) DESCRIBE `ports` 0.001378059387207
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00033903121948242
(472) DESCRIBE `ports` 0.0014529228210449
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00031185150146484
(474) DESCRIBE `ports` 0.0013928413391113
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00031399726867676
(476) DESCRIBE `ports` 0.0013620853424072
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00027894973754883
(478) DESCRIBE `ports` 0.0012950897216797
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00029397010803223
(480) DESCRIBE `ports` 0.0013401508331299
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028300285339355
(482) DESCRIBE `ports` 0.0013320446014404
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036883354187012
(484) DESCRIBE `ports` 0.0013539791107178
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030803680419922
(486) DESCRIBE `ports` 0.0012648105621338
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00033187866210938
(488) DESCRIBE `ports` 0.0014591217041016
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00028204917907715
(490) DESCRIBE `ports` 0.0012872219085693
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00038599967956543
(492) DESCRIBE `ports` 0.0012819766998291
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00027894973754883
(494) DESCRIBE `ports` 0.0013890266418457
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00036716461181641
(496) DESCRIBE `ports` 0.0012600421905518
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029182434082031
(498) DESCRIBE `ports` 0.001662015914917
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039100646972656
(500) DESCRIBE `ports` 0.0021851062774658
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00045990943908691
(502) DESCRIBE `ports` 0.0018391609191895
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00039219856262207
(504) DESCRIBE `ports` 0.0018501281738281
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00036287307739258
(506) DESCRIBE `ports` 0.0017709732055664
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00039315223693848
(508) DESCRIBE `ports` 0.0017459392547607
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037217140197754
(510) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75318') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0088510513305664
(511) DESCRIBE `avid_specials` 0.0018599033355713
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75318 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0017321109771729
(513) DESCRIBE `cruiselines` 0.0026490688323975
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00052404403686523
(515) DESCRIBE `orchid_image` 0.0020210742950439
(516) DESCRIBE `cruiselines` 0.0025219917297363
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00040507316589355
(518) DESCRIBE `cruises` 0.0029060840606689
(519) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75328') 0.00037097930908203
(520) DESCRIBE `ships` 0.0025589466094971
(521) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00066113471984863
(522) DESCRIBE `ships` 0.0036959648132324
(523) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00052404403686523
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035619735717773
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(526) DESCRIBE `itineraries` 0.0019099712371826
(527) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75328') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011041164398193
(528) DESCRIBE `ports` 0.0021078586578369
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00047206878662109
(530) DESCRIBE `ports` 0.001823902130127
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041508674621582
(532) DESCRIBE `ports` 0.0018119812011719
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035810470581055
(534) DESCRIBE `sailingdates` 0.0012021064758301
(535) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75328') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059008598327637
(536) DESCRIBE `ports` 0.0014760494232178
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030398368835449
(538) DESCRIBE `ports` 0.0014700889587402
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00032210350036621
(540) DESCRIBE `ports` 0.0014410018920898
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00042104721069336
(542) DESCRIBE `ports` 0.0013439655303955
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00027298927307129
(544) DESCRIBE `ports` 0.0014309883117676
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028491020202637
(546) DESCRIBE `ports` 0.0012788772583008
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00031089782714844
(548) DESCRIBE `ports` 0.0012998580932617
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00032210350036621
(550) DESCRIBE `ports` 0.0012650489807129
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00036311149597168
(552) DESCRIBE `ports` 0.0013079643249512
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00037622451782227
(554) DESCRIBE `ports` 0.0014538764953613
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028586387634277
(556) DESCRIBE `ports` 0.0013158321380615
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00031495094299316
(558) DESCRIBE `ports` 0.0013101100921631
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00037598609924316
(560) DESCRIBE `ports` 0.0015859603881836
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037312507629395
(562) DESCRIBE `ports` 0.0016319751739502
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032711029052734
(564) DESCRIBE `ports` 0.0014870166778564
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0003659725189209
(566) DESCRIBE `ports` 0.0015089511871338
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00050997734069824
(568) DESCRIBE `ports` 0.002687931060791
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00035905838012695
(570) DESCRIBE `ports` 0.0013730525970459
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030899047851562
(572) DESCRIBE `ports` 0.0013339519500732
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00033807754516602
(574) DESCRIBE `ports` 0.0012810230255127
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00031089782714844
(576) DESCRIBE `ports` 0.0012989044189453
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00031304359436035
(578) DESCRIBE `ports` 0.001305103302002
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00027799606323242
(580) DESCRIBE `ports` 0.0015199184417725
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00047206878662109
(582) DESCRIBE `ports` 0.0016989707946777
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00033307075500488
(584) DESCRIBE `ports` 0.0014200210571289
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031805038452148
(586) DESCRIBE `ports` 0.0013067722320557
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030899047851562
(588) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75328') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0052511692047119
(589) DESCRIBE `avid_specials` 0.0015420913696289
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75328 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0015008449554443
(591) DESCRIBE `cruiselines` 0.0022158622741699
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00036811828613281
(593) DESCRIBE `orchid_image` 0.0015950202941895
(594) DESCRIBE `cruiselines` 0.0024189949035645
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00038814544677734
(596) DESCRIBE `cruises` 0.0042030811309814
(597) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75319') 0.00063896179199219
(598) DESCRIBE `ships` 0.0035610198974609
(599) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00050091743469238
(600) DESCRIBE `ships` 0.0039219856262207
(601) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00044012069702148
(602) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033402442932129
(603) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033712387084961
(604) DESCRIBE `itineraries` 0.0025098323822021
(605) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75319') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069999694824219
(606) DESCRIBE `ports` 0.0022120475769043
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004570484161377
(608) DESCRIBE `ports` 0.0016050338745117
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00058102607727051
(610) DESCRIBE `ports` 0.0020670890808105
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043106079101562
(612) DESCRIBE `sailingdates` 0.0018320083618164
(613) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75319') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072503089904785
(614) DESCRIBE `ports` 0.0020408630371094
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044989585876465
(616) DESCRIBE `ports` 0.0019857883453369
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042605400085449
(618) DESCRIBE `ports` 0.0019190311431885
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0004420280456543
(620) DESCRIBE `ports` 0.0019540786743164
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00037884712219238
(622) DESCRIBE `ports` 0.0017569065093994
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00041508674621582
(624) DESCRIBE `ports` 0.0018141269683838
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00040793418884277
(626) DESCRIBE `ports` 0.0017650127410889
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00045108795166016
(628) DESCRIBE `ports` 0.0018129348754883
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00039505958557129
(630) DESCRIBE `ports` 0.0018432140350342
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00043296813964844
(632) DESCRIBE `ports` 0.0038490295410156
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0005040168762207
(634) DESCRIBE `ports` 0.0023488998413086
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0004429817199707
(636) DESCRIBE `ports` 0.0017020702362061
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00046300888061523
(638) DESCRIBE `ports` 0.0017788410186768
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00039196014404297
(640) DESCRIBE `ports` 0.0013630390167236
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00033402442932129
(642) DESCRIBE `ports` 0.0016999244689941
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0004429817199707
(644) DESCRIBE `ports` 0.0017330646514893
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0004420280456543
(646) DESCRIBE `ports` 0.0016889572143555
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038695335388184
(648) DESCRIBE `ports` 0.0015108585357666
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033092498779297
(650) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75319') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0057229995727539
(651) DESCRIBE `avid_specials` 0.0014760494232178
(652) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75319 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.001352071762085
(653) DESCRIBE `cruiselines` 0.0026650428771973
(654) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00061392784118652
(655) DESCRIBE `orchid_image` 0.0018129348754883
(656) DESCRIBE `cruiselines` 0.0027780532836914
(657) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00050902366638184
(658) DESCRIBE `cruises` 0.0029439926147461
(659) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75326') 0.00040507316589355
(660) DESCRIBE `ships` 0.004054069519043
(661) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00068402290344238
(662) DESCRIBE `ships` 0.0033519268035889
(663) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.0004420280456543
(664) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032901763916016
(665) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033807754516602
(666) DESCRIBE `itineraries` 0.0019299983978271
(667) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75326') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083804130554199
(668) DESCRIBE `ports` 0.0022659301757812
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00055313110351562
(670) DESCRIBE `ports` 0.0021278858184814
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00050592422485352
(672) DESCRIBE `ports` 0.0019989013671875
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039196014404297
(674) DESCRIBE `sailingdates` 0.001690149307251
(675) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75326') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007779598236084
(676) DESCRIBE `ports` 0.0020549297332764
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049495697021484
(678) DESCRIBE `ports` 0.0017108917236328
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038599967956543
(680) DESCRIBE `ports` 0.0016000270843506
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00043487548828125
(682) DESCRIBE `ports` 0.0019729137420654
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00042295455932617
(684) DESCRIBE `ports` 0.0018501281738281
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00041699409484863
(686) DESCRIBE `ports` 0.0015668869018555
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00033783912658691
(688) DESCRIBE `ports` 0.0016651153564453
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00044012069702148
(690) DESCRIBE `ports` 0.0020029544830322
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00041699409484863
(692) DESCRIBE `ports` 0.0018138885498047
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00044488906860352
(694) DESCRIBE `ports` 0.0021281242370605
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00043296813964844
(696) DESCRIBE `ports` 0.0019760131835938
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046610832214355
(698) DESCRIBE `ports` 0.0019130706787109
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00041794776916504
(700) DESCRIBE `ports` 0.0018339157104492
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047397613525391
(702) DESCRIBE `ports` 0.0023529529571533
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047993659973145
(704) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75326') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.013713121414185
(705) DESCRIBE `avid_specials` 0.0019888877868652
(706) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75326 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0018188953399658
(707) DESCRIBE `cruiselines` 0.0027120113372803
(708) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00057816505432129
(709) DESCRIBE `orchid_image` 0.002079963684082
(710) DESCRIBE `cruiselines` 0.002662181854248
(711) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00078701972961426
(712) DESCRIBE `cruisetypes` 0.0024559497833252
(713) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '15') AND (cruises_and_specials.ship_id = '780') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.035367965698242
(714) DESCRIBE `destinations` 0.0023109912872314
(715) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00067496299743652
(716) DESCRIBE `cruiselines` 0.0027611255645752
(717) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00046396255493164
(718) DESCRIBE `ships` 0.003870964050293
(719) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00057291984558105
(720) DESCRIBE `cruiselines` 0.0029361248016357
(721) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00065517425537109
(722) DESCRIBE `ships` 0.0038180351257324
(723) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00061392784118652
(724) DESCRIBE `ports` 0.0019590854644775
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00052118301391602