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

Total elapsed time: 0.74163508415222

# Query Time
(1) connect 0.00081205368041992
(2) DESCRIBE `cruises` 0.0031881332397461
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82172, 82063, 82063, 82124, 82125, 82171, 68831, 68831, 82064, 82064)) ORDER BY FIND_IN_SET(id, '82172,82063,82063,82124,82125,82171,68831,68831,82064,82064') 0.0017039775848389
(4) DESCRIBE `cruises` 0.0026359558105469
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00033187866210938
(6) DESCRIBE `ships` 0.0025320053100586
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00037312507629395
(8) DESCRIBE `ships` 0.0028700828552246
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00033712387084961
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025177001953125
(12) DESCRIBE `itineraries` 0.0013258457183838
(13) DESCRIBE `ports` 0.0013129711151123
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039911270141602
(15) DESCRIBE `ports` 0.0017480850219727
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003960132598877
(17) DESCRIBE `ports` 0.0017759799957275
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040102005004883
(19) DESCRIBE `sailingdates` 0.001270055770874
(20) DESCRIBE `ports` 0.0013670921325684
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033688545227051
(22) DESCRIBE `ports` 0.0012519359588623
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030994415283203
(24) DESCRIBE `ports` 0.0013217926025391
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00037288665771484
(26) DESCRIBE `ports` 0.0018119812011719
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035405158996582
(28) DESCRIBE `ports` 0.001755952835083
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00042891502380371
(30) DESCRIBE `ports` 0.0019471645355225
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00042295455932617
(32) DESCRIBE `ports` 0.0017640590667725
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00041508674621582
(34) DESCRIBE `ports` 0.0017008781433105
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027990341186523
(36) DESCRIBE `ports` 0.0012378692626953
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00033688545227051
(38) DESCRIBE `ports` 0.0012500286102295
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028395652770996
(40) DESCRIBE `ports` 0.0013232231140137
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00028896331787109
(42) DESCRIBE `ports` 0.0012578964233398
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027298927307129
(44) DESCRIBE `ports` 0.0014739036560059
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029110908508301
(46) DESCRIBE `ports` 0.0012679100036621
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00027298927307129
(48) DESCRIBE `ports` 0.0012872219085693
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00029301643371582
(50) DESCRIBE `ports` 0.0012481212615967
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00026321411132812
(52) DESCRIBE `ports` 0.0013360977172852
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029492378234863
(54) DESCRIBE `ports` 0.0012381076812744
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00030803680419922
(56) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82172') AND (sailingdate >= '2020-02-01') 0.0075960159301758
(57) DESCRIBE `avid_specials` 0.0014159679412842
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82172 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010478496551514
(59) DESCRIBE `cruiselines` 0.0018317699432373
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00035691261291504
(61) DESCRIBE `orchid_image` 0.0016038417816162
(62) DESCRIBE `cruiselines` 0.001990795135498
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032806396484375
(64) DESCRIBE `specials` 0.0048470497131348
(65) DESCRIBE `specials` 0.0038120746612549
(66) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534175') 0.00049209594726562
(67) DESCRIBE `ships` 0.0030961036682129
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00050210952758789
(69) DESCRIBE `ships` 0.0028748512268066
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00045990943908691
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029802322387695
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025820732116699
(73) DESCRIBE `itineraries` 0.0018949508666992
(74) DESCRIBE `ports` 0.0017259120941162
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041699409484863
(76) DESCRIBE `ports` 0.0012941360473633
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033688545227051
(78) DESCRIBE `ports` 0.0012760162353516
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00029397010803223
(80) DESCRIBE `specialsailingdates` 0.0011630058288574
(81) DESCRIBE `sailingdates` 0.0011978149414062
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515290))) 0.00050997734069824
(83) DESCRIBE `sailingdates` 0.0011579990386963
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515291))) 0.00033092498779297
(85) DESCRIBE `sailingdates` 0.0014979839324951
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515292))) 0.00043106079101562
(87) DESCRIBE `sailingdates` 0.0014100074768066
(88) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515296))) 0.00034284591674805
(89) DESCRIBE `sailingdates` 0.001140832901001
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515304))) 0.00027704238891602
(91) DESCRIBE `sailingdates` 0.0011351108551025
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515305))) 0.00027012825012207
(93) DESCRIBE `sailingdates` 0.0011439323425293
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515308))) 0.0003509521484375
(95) DESCRIBE `sailingdates` 0.0013868808746338
(96) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515325))) 0.00028300285339355
(97) DESCRIBE `sailingdates` 0.0011918544769287
(98) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515330))) 0.00031208992004395
(99) DESCRIBE `sailingdates` 0.0011968612670898
(100) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515331))) 0.00026798248291016
(101) DESCRIBE `sailingdates` 0.0011489391326904
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515332))) 0.00031185150146484
(103) DESCRIBE `sailingdates` 0.0014541149139404
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515333))) 0.00031805038452148
(105) DESCRIBE `ports` 0.0017659664154053
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00032496452331543
(107) DESCRIBE `ports` 0.0013179779052734
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00034189224243164
(109) DESCRIBE `ports` 0.0012588500976562
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029301643371582
(111) DESCRIBE `ports` 0.001244068145752
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00028610229492188
(113) DESCRIBE `ports` 0.0013859272003174
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00028896331787109
(115) DESCRIBE `ports` 0.0012929439544678
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00030279159545898
(117) DESCRIBE `ports` 0.0013189315795898
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00031399726867676
(119) DESCRIBE `ports` 0.0013189315795898
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027894973754883
(121) DESCRIBE `ports` 0.0012800693511963
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00029611587524414
(123) DESCRIBE `ports` 0.0012309551239014
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00027608871459961
(125) DESCRIBE `ports` 0.0012321472167969
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00035309791564941
(127) DESCRIBE `ports` 0.0012378692626953
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.0002739429473877
(129) DESCRIBE `ports` 0.0012359619140625
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00033211708068848
(131) DESCRIBE `ports` 0.0012869834899902
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0002748966217041
(133) DESCRIBE `ports` 0.0013070106506348
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00032711029052734
(135) DESCRIBE `ports` 0.0013260841369629
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00030612945556641
(137) DESCRIBE `ports` 0.0013630390167236
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003199577331543
(139) DESCRIBE `ports` 0.0013618469238281
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029397010803223
(141) DESCRIBE `cruises` 0.0023989677429199
(142) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82063))) 0.00049018859863281
(143) DESCRIBE `avid_specials` 0.0012111663818359
(144) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534175 and class = 'Special') OR (item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010128021240234
(145) DESCRIBE `cruiselines` 0.0020289421081543
(146) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032901763916016
(147) DESCRIBE `orchid_image` 0.0014078617095947
(148) DESCRIBE `cruiselines` 0.0017259120941162
(149) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00029587745666504
(150) DESCRIBE `cruises` 0.002453088760376
(151) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.00035214424133301
(152) DESCRIBE `ships` 0.0025110244750977
(153) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00038790702819824
(154) DESCRIBE `ships` 0.0027239322662354
(155) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00035691261291504
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(157) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029802322387695
(158) DESCRIBE `itineraries` 0.0012378692626953
(159) DESCRIBE `ports` 0.0014188289642334
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00035691261291504
(161) DESCRIBE `ports` 0.0016801357269287
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00036406517028809
(163) DESCRIBE `ports` 0.001338005065918
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00028896331787109
(165) DESCRIBE `sailingdates` 0.0011298656463623
(166) DESCRIBE `ports` 0.0013251304626465
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00031590461730957
(168) DESCRIBE `ports` 0.0013031959533691
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00037598609924316
(170) DESCRIBE `ports` 0.0012779235839844
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029206275939941
(172) DESCRIBE `ports` 0.0013530254364014
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0002899169921875
(174) DESCRIBE `ports` 0.0013318061828613
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00029206275939941
(176) DESCRIBE `ports` 0.0013949871063232
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00033712387084961
(178) DESCRIBE `ports` 0.0014188289642334
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00029802322387695
(180) DESCRIBE `ports` 0.0014228820800781
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027704238891602
(182) DESCRIBE `ports` 0.0012950897216797
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00029802322387695
(184) DESCRIBE `ports` 0.0013000965118408
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00030803680419922
(186) DESCRIBE `ports` 0.001662015914917
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00033712387084961
(188) DESCRIBE `ports` 0.001762866973877
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00030612945556641
(190) DESCRIBE `ports` 0.00136399269104
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00034284591674805
(192) DESCRIBE `ports` 0.0015528202056885
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00033712387084961
(194) DESCRIBE `ports` 0.0013799667358398
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00037288665771484
(196) DESCRIBE `ports` 0.0014309883117676
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00031089782714844
(198) DESCRIBE `ports` 0.0014870166778564
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040507316589355
(200) DESCRIBE `ports` 0.0013461112976074
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028300285339355
(202) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82063') AND (sailingdate >= '2020-02-01') 0.0061380863189697
(203) DESCRIBE `avid_specials` 0.0015480518341064
(204) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011100769042969
(205) DESCRIBE `cruiselines` 0.0026490688323975
(206) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00045680999755859
(207) DESCRIBE `orchid_image` 0.0020151138305664
(208) DESCRIBE `cruiselines` 0.0026450157165527
(209) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041389465332031
(210) DESCRIBE `cruises` 0.0033938884735107
(211) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00039887428283691
(212) DESCRIBE `ships` 0.003511905670166
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00041294097900391
(214) DESCRIBE `ships` 0.0027561187744141
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00036811828613281
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(218) DESCRIBE `itineraries` 0.001716136932373
(219) DESCRIBE `ports` 0.0018661022186279
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00045394897460938
(221) DESCRIBE `ports` 0.0019159317016602
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044393539428711
(223) DESCRIBE `ports` 0.0017759799957275
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003509521484375
(225) DESCRIBE `sailingdates` 0.0012190341949463
(226) DESCRIBE `ports` 0.0013151168823242
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041794776916504
(228) DESCRIBE `ports` 0.0018658638000488
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037908554077148
(230) DESCRIBE `ports` 0.001802921295166
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044012069702148
(232) DESCRIBE `ports` 0.0017910003662109
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035905838012695
(234) DESCRIBE `ports` 0.0015320777893066
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029611587524414
(236) DESCRIBE `ports` 0.0012798309326172
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029110908508301
(238) DESCRIBE `ports` 0.0012438297271729
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00036096572875977
(240) DESCRIBE `ports` 0.0012969970703125
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027704238891602
(242) DESCRIBE `ports` 0.0016109943389893
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00031399726867676
(244) DESCRIBE `ports` 0.0014040470123291
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028681755065918
(246) DESCRIBE `ports` 0.0013360977172852
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0003209114074707
(248) DESCRIBE `ports` 0.0013070106506348
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00028610229492188
(250) DESCRIBE `ports` 0.0013542175292969
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00033092498779297
(252) DESCRIBE `ports` 0.0013518333435059
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00026488304138184
(254) DESCRIBE `ports` 0.0012669563293457
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00029110908508301
(256) DESCRIBE `ports` 0.0013198852539062
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00028014183044434
(258) DESCRIBE `ports` 0.0014519691467285
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030708312988281
(260) DESCRIBE `ports` 0.0013918876647949
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029110908508301
(262) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82124') AND (sailingdate >= '2020-02-01') 0.005357027053833
(263) DESCRIBE `avid_specials` 0.0015509128570557
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82124 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010271072387695
(265) DESCRIBE `cruiselines` 0.0018739700317383
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032305717468262
(267) DESCRIBE `orchid_image` 0.001492977142334
(268) DESCRIBE `cruiselines` 0.0020170211791992
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00029802322387695
(270) DESCRIBE `cruises` 0.0033941268920898
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00042414665222168
(272) DESCRIBE `ships` 0.0033941268920898
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00054812431335449
(274) DESCRIBE `ships` 0.003126859664917
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00034093856811523
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(278) DESCRIBE `itineraries` 0.0012860298156738
(279) DESCRIBE `ports` 0.0013048648834229
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036382675170898
(281) DESCRIBE `ports` 0.0017690658569336
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003960132598877
(283) DESCRIBE `ports` 0.0014820098876953
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00036096572875977
(285) DESCRIBE `sailingdates` 0.0011250972747803
(286) DESCRIBE `ports` 0.0012760162353516
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030612945556641
(288) DESCRIBE `ports` 0.0013120174407959
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037097930908203
(290) DESCRIBE `ports` 0.0012891292572021
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031208992004395
(292) DESCRIBE `ports` 0.0012810230255127
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031590461730957
(294) DESCRIBE `ports` 0.0016489028930664
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00038909912109375
(296) DESCRIBE `ports` 0.0014300346374512
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00030899047851562
(298) DESCRIBE `ports` 0.0015900135040283
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030016899108887
(300) DESCRIBE `ports` 0.0014328956604004
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037980079650879
(302) DESCRIBE `ports` 0.0015871524810791
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00030899047851562
(304) DESCRIBE `ports` 0.0017848014831543
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00036501884460449
(306) DESCRIBE `ports` 0.0017530918121338
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00041508674621582
(308) DESCRIBE `ports` 0.0017831325531006
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00036096572875977
(310) DESCRIBE `ports` 0.0018079280853271
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00046491622924805
(312) DESCRIBE `ports` 0.0013041496276855
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00029706954956055
(314) DESCRIBE `ports` 0.0013549327850342
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00036096572875977
(316) DESCRIBE `ports` 0.0014889240264893
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037503242492676
(318) DESCRIBE `ports` 0.0014958381652832
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0003209114074707
(320) DESCRIBE `ports` 0.0013020038604736
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00035285949707031
(322) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82125') AND (sailingdate >= '2020-02-01') 0.0080139636993408
(323) DESCRIBE `avid_specials` 0.0015401840209961
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82125 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017111301422119
(325) DESCRIBE `cruiselines` 0.0025038719177246
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00038313865661621
(327) DESCRIBE `orchid_image` 0.0015370845794678
(328) DESCRIBE `cruiselines` 0.0020749568939209
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040292739868164
(330) DESCRIBE `cruises` 0.0032849311828613
(331) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.00038409233093262
(332) DESCRIBE `ships` 0.0027580261230469
(333) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00037407875061035
(334) DESCRIBE `ships` 0.0032520294189453
(335) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00040006637573242
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056982040405273
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(338) DESCRIBE `itineraries` 0.0014281272888184
(339) DESCRIBE `ports` 0.001723051071167
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00039291381835938
(341) DESCRIBE `ports` 0.0014069080352783
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00036215782165527
(343) DESCRIBE `ports` 0.001662015914917
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003058910369873
(345) DESCRIBE `sailingdates` 0.0012288093566895
(346) DESCRIBE `ports` 0.0016260147094727
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0004270076751709
(348) DESCRIBE `ports` 0.0014228820800781
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00038599967956543
(350) DESCRIBE `ports` 0.0016489028930664
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00040102005004883
(352) DESCRIBE `ports` 0.0016980171203613
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00030899047851562
(354) DESCRIBE `ports` 0.0013301372528076
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00030612945556641
(356) DESCRIBE `ports` 0.0013220310211182
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00030398368835449
(358) DESCRIBE `ports` 0.0017189979553223
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00035905838012695
(360) DESCRIBE `ports` 0.0013589859008789
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00034999847412109
(362) DESCRIBE `ports` 0.0014238357543945
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00032615661621094
(364) DESCRIBE `ports` 0.0014290809631348
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029706954956055
(366) DESCRIBE `ports` 0.0014219284057617
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00032496452331543
(368) DESCRIBE `ports` 0.0013589859008789
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00029706954956055
(370) DESCRIBE `ports` 0.0013320446014404
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00043487548828125
(372) DESCRIBE `ports` 0.0012891292572021
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00030612945556641
(374) DESCRIBE `ports` 0.0014030933380127
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00038909912109375
(376) DESCRIBE `ports` 0.0016129016876221
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00040888786315918
(378) DESCRIBE `ports` 0.0016851425170898
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004279613494873
(380) DESCRIBE `ports` 0.0014309883117676
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029206275939941
(382) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82171') AND (sailingdate >= '2020-02-01') 0.0053479671478271
(383) DESCRIBE `avid_specials` 0.0015799999237061
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82171 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011677742004395
(385) DESCRIBE `cruiselines` 0.0020811557769775
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00038790702819824
(387) DESCRIBE `orchid_image` 0.0014801025390625
(388) DESCRIBE `cruiselines` 0.0019128322601318
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00034713745117188
(390) DESCRIBE `cruises` 0.0036749839782715
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00049805641174316
(392) DESCRIBE `ships` 0.0038020610809326
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00064206123352051
(394) DESCRIBE `ships` 0.0038800239562988
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00051403045654297
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032711029052734
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(398) DESCRIBE `itineraries` 0.0014669895172119
(399) DESCRIBE `ports` 0.0016968250274658
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039005279541016
(401) DESCRIBE `ports` 0.0014069080352783
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030708312988281
(403) DESCRIBE `ports` 0.0013129711151123
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028514862060547
(405) DESCRIBE `sailingdates` 0.0011770725250244
(406) DESCRIBE `ports` 0.0017380714416504
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047397613525391
(408) DESCRIBE `ports` 0.0017340183258057
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00038290023803711
(410) DESCRIBE `ports` 0.0013349056243896
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00034880638122559
(412) DESCRIBE `ports` 0.0015950202941895
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039887428283691
(414) DESCRIBE `ports` 0.0018870830535889
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00043106079101562
(416) DESCRIBE `ports` 0.0019340515136719
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0003809928894043
(418) DESCRIBE `ports` 0.0018320083618164
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00041818618774414
(420) DESCRIBE `ports` 0.0018179416656494
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00034284591674805
(422) DESCRIBE `ports` 0.0013220310211182
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00032615661621094
(424) DESCRIBE `ports` 0.0012989044189453
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028705596923828
(426) DESCRIBE `ports` 0.0013670921325684
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00031495094299316
(428) DESCRIBE `ports` 0.001737117767334
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00029492378234863
(430) DESCRIBE `ports` 0.0012919902801514
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00031805038452148
(432) DESCRIBE `ports` 0.0013830661773682
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00031399726867676
(434) DESCRIBE `ports` 0.0014078617095947
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030994415283203
(436) DESCRIBE `ports` 0.0012619495391846
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026988983154297
(438) DESCRIBE `ports` 0.00130295753479
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030684471130371
(440) DESCRIBE `ports` 0.0013830661773682
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00034999847412109
(442) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2020-02-01') 0.0068519115447998
(443) DESCRIBE `avid_specials` 0.0016510486602783
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001708984375
(445) DESCRIBE `cruiselines` 0.0021581649780273
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00048208236694336
(447) DESCRIBE `orchid_image` 0.0015020370483398
(448) DESCRIBE `cruiselines` 0.0023019313812256
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041890144348145
(450) DESCRIBE `specials` 0.0051860809326172
(451) DESCRIBE `specials` 0.0043740272521973
(452) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534180') 0.00042414665222168
(453) DESCRIBE `ships` 0.0032110214233398
(454) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00042009353637695
(455) DESCRIBE `ships` 0.0036370754241943
(456) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0003659725189209
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(459) DESCRIBE `itineraries` 0.0018210411071777
(460) DESCRIBE `ports` 0.0014379024505615
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040698051452637
(462) DESCRIBE `ports` 0.0014100074768066
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029993057250977
(464) DESCRIBE `ports` 0.0013670921325684
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031590461730957
(466) DESCRIBE `specialsailingdates` 0.0013527870178223
(467) DESCRIBE `sailingdates` 0.0012869834899902
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515685))) 0.00045084953308105
(469) DESCRIBE `sailingdates` 0.0012311935424805
(470) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515686))) 0.00028014183044434
(471) DESCRIBE `sailingdates` 0.0010988712310791
(472) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515690))) 0.00037503242492676
(473) DESCRIBE `sailingdates` 0.0012450218200684
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515691))) 0.00027799606323242
(475) DESCRIBE `sailingdates` 0.0014739036560059
(476) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515696))) 0.00029802322387695
(477) DESCRIBE `sailingdates` 0.0012319087982178
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515697))) 0.00027585029602051
(479) DESCRIBE `sailingdates` 0.0011699199676514
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515698))) 0.0002751350402832
(481) DESCRIBE `sailingdates` 0.001101016998291
(482) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515699))) 0.00027894973754883
(483) DESCRIBE `sailingdates` 0.0011320114135742
(484) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515288))) 0.00028514862060547
(485) DESCRIBE `sailingdates` 0.0012328624725342
(486) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515704))) 0.00030708312988281
(487) DESCRIBE `sailingdates` 0.0011119842529297
(488) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515711))) 0.0002751350402832
(489) DESCRIBE `sailingdates` 0.0010981559753418
(490) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515712))) 0.00027585029602051
(491) DESCRIBE `sailingdates` 0.001107931137085
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515713))) 0.00027298927307129
(493) DESCRIBE `sailingdates` 0.0011169910430908
(494) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515718))) 0.00029683113098145
(495) DESCRIBE `sailingdates` 0.0011308193206787
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515719))) 0.0002751350402832
(497) DESCRIBE `sailingdates` 0.0011579990386963
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515720))) 0.00029492378234863
(499) DESCRIBE `sailingdates` 0.0010910034179688
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515721))) 0.00027608871459961
(501) DESCRIBE `sailingdates` 0.0011241436004639
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515725))) 0.00027298927307129
(503) DESCRIBE `ports` 0.0012729167938232
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00037002563476562
(505) DESCRIBE `ports` 0.0012691020965576
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00034308433532715
(507) DESCRIBE `ports` 0.0013339519500732
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032901763916016
(509) DESCRIBE `ports` 0.0012719631195068
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027680397033691
(511) DESCRIBE `ports` 0.0012969970703125
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00030612945556641
(513) DESCRIBE `ports` 0.0016231536865234
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00029802322387695
(515) DESCRIBE `ports` 0.0013010501861572
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030207633972168
(517) DESCRIBE `ports` 0.0014340877532959
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00030088424682617
(519) DESCRIBE `ports` 0.0012550354003906
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00030279159545898
(521) DESCRIBE `ports` 0.0013930797576904
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028896331787109
(523) DESCRIBE `ports` 0.0013151168823242
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00029706954956055
(525) DESCRIBE `ports` 0.0014159679412842
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00030899047851562
(527) DESCRIBE `ports` 0.0013079643249512
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0003049373626709
(529) DESCRIBE `ports` 0.0012528896331787
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00028491020202637
(531) DESCRIBE `ports` 0.0012378692626953
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029993057250977
(533) DESCRIBE `ports` 0.0012907981872559
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0002748966217041
(535) DESCRIBE `ports` 0.0012741088867188
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030994415283203
(537) DESCRIBE `ports` 0.0012490749359131
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00026798248291016
(539) DESCRIBE `cruises` 0.0024650096893311
(540) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68831))) 0.00051784515380859
(541) DESCRIBE `avid_specials` 0.001507043838501
(542) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534180 and class = 'Special') OR (item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016381740570068
(543) DESCRIBE `cruiselines` 0.0022900104522705
(544) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00048089027404785
(545) DESCRIBE `orchid_image` 0.0018899440765381
(546) DESCRIBE `cruiselines` 0.0019738674163818
(547) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032186508178711
(548) DESCRIBE `specials` 0.0040879249572754
(549) DESCRIBE `specials` 0.0043089389801025
(550) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534121') 0.00047206878662109
(551) DESCRIBE `ships` 0.0037460327148438
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00054788589477539
(553) DESCRIBE `ships` 0.0025730133056641
(554) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00040602684020996
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(557) DESCRIBE `itineraries` 0.0012531280517578
(558) DESCRIBE `ports` 0.0014419555664062
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033092498779297
(560) DESCRIBE `ports` 0.0013220310211182
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00035309791564941
(562) DESCRIBE `ports` 0.0012550354003906
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027990341186523
(564) DESCRIBE `specialsailingdates` 0.0010879039764404
(565) DESCRIBE `sailingdates` 0.0012381076812744
(566) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515297))) 0.00040698051452637
(567) DESCRIBE `ports` 0.0017468929290771
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041007995605469
(569) DESCRIBE `ports` 0.0017790794372559
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00038003921508789
(571) DESCRIBE `ports` 0.0018289089202881
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036311149597168
(573) DESCRIBE `ports` 0.0015230178833008
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00034999847412109
(575) DESCRIBE `ports` 0.0018138885498047
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00042319297790527
(577) DESCRIBE `ports` 0.0018470287322998
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00034499168395996
(579) DESCRIBE `ports` 0.0017259120941162
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0003821849822998
(581) DESCRIBE `ports` 0.0014469623565674
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00029277801513672
(583) DESCRIBE `ports` 0.0013601779937744
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00058102607727051
(585) DESCRIBE `ports` 0.0015208721160889
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029516220092773
(587) DESCRIBE `ports` 0.0013649463653564
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00032401084899902
(589) DESCRIBE `ports` 0.0012950897216797
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00033211708068848
(591) DESCRIBE `ports` 0.0013418197631836
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00032496452331543
(593) DESCRIBE `ports` 0.0013120174407959
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00027608871459961
(595) DESCRIBE `ports` 0.0012829303741455
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00030016899108887
(597) DESCRIBE `ports` 0.0013270378112793
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0002739429473877
(599) DESCRIBE `ports` 0.0013058185577393
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030398368835449
(601) DESCRIBE `ports` 0.0014259815216064
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030803680419922
(603) DESCRIBE `cruises` 0.0025160312652588
(604) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82064))) 0.0005180835723877
(605) DESCRIBE `avid_specials` 0.001140832901001
(606) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534121 and class = 'Special') OR (item_id = 82064 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010101795196533
(607) DESCRIBE `cruiselines` 0.0018229484558105
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00043010711669922
(609) DESCRIBE `orchid_image` 0.0018589496612549
(610) DESCRIBE `cruiselines` 0.0020360946655273
(611) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00037312507629395
(612) DESCRIBE `cruises` 0.0025098323822021
(613) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.00047802925109863
(614) DESCRIBE `ships` 0.0026259422302246
(615) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00041604042053223
(616) DESCRIBE `ships` 0.0025320053100586
(617) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00035476684570312
(618) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(620) DESCRIBE `itineraries` 0.001554012298584
(621) DESCRIBE `ports` 0.0013718605041504
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003349781036377
(623) DESCRIBE `ports` 0.0013630390167236
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030303001403809
(625) DESCRIBE `ports` 0.0014040470123291
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029897689819336
(627) DESCRIBE `sailingdates` 0.001209020614624
(628) DESCRIBE `ports` 0.0013141632080078
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032806396484375
(630) DESCRIBE `ports` 0.0016498565673828
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029110908508301
(632) DESCRIBE `ports` 0.0013329982757568
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003352165222168
(634) DESCRIBE `ports` 0.0015170574188232
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00055098533630371
(636) DESCRIBE `ports` 0.0014200210571289
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030398368835449
(638) DESCRIBE `ports` 0.0013329982757568
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029397010803223
(640) DESCRIBE `ports` 0.0013191699981689
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00046920776367188
(642) DESCRIBE `ports` 0.0017859935760498
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0003669261932373
(644) DESCRIBE `ports` 0.0019240379333496
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00045990943908691
(646) DESCRIBE `ports` 0.0014760494232178
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00041890144348145
(648) DESCRIBE `ports` 0.0015919208526611
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00042295455932617
(650) DESCRIBE `ports` 0.0017430782318115
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00033307075500488
(652) DESCRIBE `ports` 0.0014650821685791
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00040006637573242
(654) DESCRIBE `ports` 0.001751184463501
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00028181076049805
(656) DESCRIBE `ports` 0.0012929439544678
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00033807754516602
(658) DESCRIBE `ports` 0.0013391971588135
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0002741813659668
(660) DESCRIBE `ports` 0.0013020038604736
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032520294189453
(662) DESCRIBE `ports` 0.0012660026550293
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028085708618164
(664) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82064') AND (sailingdate >= '2020-02-01') 0.0048110485076904
(665) DESCRIBE `avid_specials` 0.0012068748474121
(666) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82064 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099897384643555
(667) DESCRIBE `cruiselines` 0.0020651817321777
(668) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034594535827637
(669) DESCRIBE `orchid_image` 0.0016000270843506
(670) DESCRIBE `cruiselines` 0.0018970966339111
(671) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00035214424133301
(672) DESCRIBE `ships` 0.0027270317077637
(673) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1791')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1791') 0.00096297264099121
(674) DESCRIBE `cruisetypes` 0.0010690689086914
(675) DESCRIBE `destinations` 0.0020110607147217
(676) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.00058197975158691
(677) DESCRIBE `cruiselines` 0.0018548965454102
(678) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034093856811523
(679) DESCRIBE `cruiselines` 0.0022220611572266
(680) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00036001205444336