or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 0.72878956794739

# Query Time
(1) connect 0.00074601173400879
(2) DESCRIBE `cruises` 0.003244161605835
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80652, 80652, 80655, 80655, 80656, 80656, 80657, 80657, 82416, 82416)) ORDER BY FIND_IN_SET(id, '80652,80652,80655,80655,80656,80656,80657,80657,82416,82416') 0.0012009143829346
(4) DESCRIBE `specials` 0.0041558742523193
(5) DESCRIBE `specials` 0.0041918754577637
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554714') 0.00042104721069336
(7) DESCRIBE `ships` 0.0026857852935791
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00036382675170898
(9) DESCRIBE `ships` 0.0026988983154297
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00027298927307129
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002739429473877
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002901554107666
(13) DESCRIBE `itineraries` 0.0019888877868652
(14) DESCRIBE `ports` 0.0018529891967773
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043106079101562
(16) DESCRIBE `ports` 0.0017378330230713
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00039005279541016
(18) DESCRIBE `ports` 0.0017139911651611
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036311149597168
(20) DESCRIBE `specialsailingdates` 0.0014100074768066
(21) DESCRIBE `sailingdates` 0.0015661716461182
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500069))) 0.0005030632019043
(23) DESCRIBE `sailingdates` 0.0031270980834961
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500088))) 0.00047183036804199
(25) DESCRIBE `sailingdates` 0.0012030601501465
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500071))) 0.00028800964355469
(27) DESCRIBE `sailingdates` 0.001183032989502
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500089))) 0.00028586387634277
(29) DESCRIBE `ports` 0.0015089511871338
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00079798698425293
(31) DESCRIBE `ports` 0.0017149448394775
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032591819763184
(33) DESCRIBE `ports` 0.0012609958648682
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00033402442932129
(35) DESCRIBE `ports` 0.0013830661773682
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028514862060547
(37) DESCRIBE `ports` 0.0014190673828125
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00044012069702148
(39) DESCRIBE `ports` 0.0016520023345947
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0003662109375
(41) DESCRIBE `ports` 0.0018270015716553
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00037503242492676
(43) DESCRIBE `ports` 0.0028591156005859
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00043916702270508
(45) DESCRIBE `ports` 0.0014312267303467
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0
(47) DESCRIBE `ports` 0.0012021064758301
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00031805038452148
(49) DESCRIBE `ports` 0.0019280910491943
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031185150146484
(51) DESCRIBE `ports` 0.0053009986877441
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00045299530029297
(53) DESCRIBE `ports` 0.0018231868743896
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00042414665222168
(55) DESCRIBE `ports` 0.0015640258789062
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00027799606323242
(57) DESCRIBE `ports` 0.0014128684997559
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031208992004395
(59) DESCRIBE `ports` 0.0012810230255127
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002741813659668
(61) DESCRIBE `cruises` 0.0025179386138916
(62) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80652))) 0.00037288665771484
(63) DESCRIBE `avid_specials` 0.0011138916015625
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554714 and class = 'Special') OR (item_id = 80652 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0011179447174072
(65) DESCRIBE `cruiselines` 0.0018329620361328
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00031900405883789
(67) DESCRIBE `orchid_image` 0.0014128684997559
(68) DESCRIBE `cruiselines` 0.0020039081573486
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0013279914855957
(70) DESCRIBE `cruises` 0.0029549598693848
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80652') 0.00011706352233887
(72) DESCRIBE `ships` 0.0034549236297607
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0
(74) DESCRIBE `ships` 0.0032908916473389
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 5.3167343139648E-5
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031304359436035
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027203559875488
(78) DESCRIBE `itineraries` 0.0023641586303711
(79) DESCRIBE `ports` 0.0021109580993652
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046896934509277
(81) DESCRIBE `ports` 0.0024111270904541
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043511390686035
(83) DESCRIBE `ports` 0.0014879703521729
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00033187866210938
(85) DESCRIBE `sailingdates` 0.0031599998474121
(86) DESCRIBE `ports` 0.0015089511871338
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037789344787598
(88) DESCRIBE `ports` 0.0020489692687988
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032591819763184
(90) DESCRIBE `ports` 0.0018501281738281
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00041413307189941
(92) DESCRIBE `ports` 0.0019729137420654
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00036287307739258
(94) DESCRIBE `ports` 0.0015320777893066
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0003209114074707
(96) DESCRIBE `ports` 0.0018799304962158
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00040984153747559
(98) DESCRIBE `ports` 0.0019309520721436
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00036406517028809
(100) DESCRIBE `ports` 0.0022618770599365
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00041294097900391
(102) DESCRIBE `ports` 0.002068042755127
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036907196044922
(104) DESCRIBE `ports` 0.0019829273223877
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037693977355957
(106) DESCRIBE `ports` 0.002392053604126
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00048494338989258
(108) DESCRIBE `ports` 0.0020360946655273
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00048398971557617
(110) DESCRIBE `ports` 0.0018508434295654
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0004889965057373
(112) DESCRIBE `ports` 0.0022330284118652
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00037693977355957
(114) DESCRIBE `ports` 0.001910924911499
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044488906860352
(116) DESCRIBE `ports` 0.0019450187683105
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041389465332031
(118) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80652') AND (sailingdate >= '2019-12-15') 0.012541055679321
(119) DESCRIBE `avid_specials` 0.0018439292907715
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80652 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0014369487762451
(121) DESCRIBE `cruiselines` 0.0020129680633545
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00038003921508789
(123) DESCRIBE `orchid_image` 0.0018389225006104
(124) DESCRIBE `cruiselines` 0.002345085144043
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00027108192443848
(126) DESCRIBE `specials` 0.0042049884796143
(127) DESCRIBE `specials` 0.0050668716430664
(128) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554718') 0.00041890144348145
(129) DESCRIBE `ships` 0.0035221576690674
(130) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00059008598327637
(131) DESCRIBE `ships` 0.0034089088439941
(132) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00034999847412109
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019192695617676
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029206275939941
(135) DESCRIBE `itineraries` 0.0017349720001221
(136) DESCRIBE `ports` 0.0018241405487061
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044798851013184
(138) DESCRIBE `ports` 0.0013549327850342
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047397613525391
(140) DESCRIBE `ports` 0.0024518966674805
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0003669261932373
(142) DESCRIBE `specialsailingdates` 0.0018229484558105
(143) DESCRIBE `sailingdates` 0.0028140544891357
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500075))) 0.00014209747314453
(145) DESCRIBE `ports` 0.0021350383758545
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00048494338989258
(147) DESCRIBE `ports` 0.0021498203277588
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0006101131439209
(149) DESCRIBE `ports` 0.0017158985137939
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 6.9856643676758E-5
(151) DESCRIBE `ports` 0.0023291110992432
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00021719932556152
(153) DESCRIBE `ports` 0.0019609928131104
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00092506408691406
(155) DESCRIBE `ports` 0.0020771026611328
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00040817260742188
(157) DESCRIBE `ports` 0.0025560855865479
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0
(159) DESCRIBE `ports` 0.0021069049835205
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0010418891906738
(161) DESCRIBE `ports` 0.0023770332336426
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00049495697021484
(163) DESCRIBE `ports` 0.0014479160308838
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0011370182037354
(165) DESCRIBE `ports` 0.0016670227050781
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 3.0040740966797E-5
(167) DESCRIBE `ports` 0.0023729801177979
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0007929801940918
(169) DESCRIBE `ports` 0.0018489360809326
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0010089874267578
(171) DESCRIBE `ports` 0.0020990371704102
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 1.3113021850586E-5
(173) DESCRIBE `ports` 0.0016758441925049
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(175) DESCRIBE `ports` 0.0013599395751953
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00013494491577148
(177) DESCRIBE `cruises` 0.0028409957885742
(178) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80655))) 0
(179) DESCRIBE `avid_specials` 0.002155065536499
(180) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554718 and class = 'Special') OR (item_id = 80655 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0018119812011719
(181) DESCRIBE `cruiselines` 0.0023899078369141
(182) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00043296813964844
(183) DESCRIBE `orchid_image` 0.0018489360809326
(184) DESCRIBE `cruiselines` 0.002223014831543
(185) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00015497207641602
(186) DESCRIBE `cruises` 0.0032579898834229
(187) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80655') 0.00023198127746582
(188) DESCRIBE `ships` 0.0028450489044189
(189) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00047206878662109
(190) DESCRIBE `ships` 0.0028970241546631
(191) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00040698051452637
(192) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0006871223449707
(194) DESCRIBE `itineraries` 0.0019338130950928
(195) DESCRIBE `ports` 0.0021190643310547
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004429817199707
(197) DESCRIBE `ports` 0.0016450881958008
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032520294189453
(199) DESCRIBE `ports` 0.0016191005706787
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035715103149414
(201) DESCRIBE `sailingdates` 0.0014760494232178
(202) DESCRIBE `ports` 0.0016491413116455
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00017619132995605
(204) DESCRIBE `ports` 0.0010249614715576
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0010859966278076
(206) DESCRIBE `ports` 0.0018129348754883
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0
(208) DESCRIBE `ports` 0.0022969245910645
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00039792060852051
(210) DESCRIBE `ports` 0.0011541843414307
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00014495849609375
(212) DESCRIBE `ports` 0.0021259784698486
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 7.0095062255859E-5
(214) DESCRIBE `ports` 0.001474142074585
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 4.887580871582E-5
(216) DESCRIBE `ports` 0.00130295753479
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0002899169921875
(218) DESCRIBE `ports` 0.001054048538208
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00040102005004883
(220) DESCRIBE `ports` 0.0014619827270508
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028300285339355
(222) DESCRIBE `ports` 0.0011599063873291
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00019216537475586
(224) DESCRIBE `ports` 0.0026869773864746
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00028300285339355
(226) DESCRIBE `ports` 0.0016810894012451
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00026798248291016
(228) DESCRIBE `ports` 0.0015869140625
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00027203559875488
(230) DESCRIBE `ports` 0.0016012191772461
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044798851013184
(232) DESCRIBE `ports` 0.001924991607666
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029397010803223
(234) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80655') AND (sailingdate >= '2019-12-15') 0.0061519145965576
(235) DESCRIBE `avid_specials` 0.0011630058288574
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80655 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0010490417480469
(237) DESCRIBE `cruiselines` 0.0018928050994873
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00032687187194824
(239) DESCRIBE `orchid_image` 0.0016369819641113
(240) DESCRIBE `cruiselines` 0.0017788410186768
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0002748966217041
(242) DESCRIBE `specials` 0.0051531791687012
(243) DESCRIBE `specials` 0.0039348602294922
(244) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554969') 0.00032615661621094
(245) DESCRIBE `ships` 0.0031299591064453
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.0004270076751709
(247) DESCRIBE `ships` 0.0028679370880127
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00077605247497559
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00012993812561035
(251) DESCRIBE `itineraries` 0.0013539791107178
(252) DESCRIBE `ports` 0.0017910003662109
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00012087821960449
(254) DESCRIBE `ports` 0.0019919872283936
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(256) DESCRIBE `ports` 0.0019969940185547
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(258) DESCRIBE `specialsailingdates` 0.001086950302124
(259) DESCRIBE `sailingdates` 0.00057101249694824
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500076))) 0.00035190582275391
(261) DESCRIBE `ports` 0.0023181438446045
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(263) DESCRIBE `ports` 0.0024609565734863
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00053191184997559
(265) DESCRIBE `ports` 0.001384973526001
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 9.0122222900391E-5
(267) DESCRIBE `ports` 0.00079798698425293
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0005490779876709
(269) DESCRIBE `ports` 0.0011839866638184
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0010809898376465
(271) DESCRIBE `ports` 0.0014231204986572
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00042891502380371
(273) DESCRIBE `ports` 0.0012149810791016
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00051403045654297
(275) DESCRIBE `ports` 0.0018079280853271
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00030899047851562
(277) DESCRIBE `ports` 0.0015060901641846
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00024890899658203
(279) DESCRIBE `ports` 0.0014519691467285
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0
(281) DESCRIBE `ports` 0.0011179447174072
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00020599365234375
(283) DESCRIBE `ports` 0.0018379688262939
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00072383880615234
(285) DESCRIBE `ports` 0.001101016998291
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00063800811767578
(287) DESCRIBE `ports` 0.0015931129455566
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0
(289) DESCRIBE `ports` 0.0012941360473633
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00054788589477539
(291) DESCRIBE `ports` 0.0019209384918213
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00015997886657715
(293) DESCRIBE `cruises` 0.0039350986480713
(294) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80656))) 0.00051403045654297
(295) DESCRIBE `avid_specials` 0.0012922286987305
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554969 and class = 'Special') OR (item_id = 80656 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.00081610679626465
(297) DESCRIBE `cruiselines` 0.0019800662994385
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00031805038452148
(299) DESCRIBE `orchid_image` 0.0017240047454834
(300) DESCRIBE `cruiselines` 0.002187967300415
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0
(302) DESCRIBE `cruises` 0.0030040740966797
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80656') 0.00071096420288086
(304) DESCRIBE `ships` 0.003183126449585
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00043010711669922
(306) DESCRIBE `ships` 0.0027461051940918
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00067591667175293
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(310) DESCRIBE `itineraries` 0.0018861293792725
(311) DESCRIBE `ports` 0.0013229846954346
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030803680419922
(313) DESCRIBE `ports` 0.0015380382537842
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031208992004395
(315) DESCRIBE `ports` 0.0013399124145508
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032305717468262
(317) DESCRIBE `sailingdates` 0.0025351047515869
(318) DESCRIBE `ports` 0.0020079612731934
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046801567077637
(320) DESCRIBE `ports` 0.0021460056304932
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00042605400085449
(322) DESCRIBE `ports` 0.0023188591003418
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00056791305541992
(324) DESCRIBE `ports` 0.0021891593933105
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00040197372436523
(326) DESCRIBE `ports` 0.0018289089202881
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00037193298339844
(328) DESCRIBE `ports` 0.0017390251159668
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00037693977355957
(330) DESCRIBE `ports` 0.0018360614776611
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00050806999206543
(332) DESCRIBE `ports` 0.001906156539917
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0003969669342041
(334) DESCRIBE `ports` 0.0017368793487549
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00043892860412598
(336) DESCRIBE `ports` 0.0018599033355713
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00041103363037109
(338) DESCRIBE `ports` 0.0017600059509277
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00037908554077148
(340) DESCRIBE `ports` 0.0014698505401611
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00035309791564941
(342) DESCRIBE `ports` 0.0015578269958496
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.0004279613494873
(344) DESCRIBE `ports` 0.0012989044189453
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00030803680419922
(346) DESCRIBE `ports` 0.001410961151123
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0011658668518066
(348) DESCRIBE `ports` 0.0012009143829346
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00050687789916992
(350) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80656') AND (sailingdate >= '2019-12-15') 0.0047121047973633
(351) DESCRIBE `avid_specials` 0.0015130043029785
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80656 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.00084185600280762
(353) DESCRIBE `cruiselines` 0.0014898777008057
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00072789192199707
(355) DESCRIBE `orchid_image` 0.0016109943389893
(356) DESCRIBE `cruiselines` 0.0026159286499023
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0
(358) DESCRIBE `specials` 0.0056369304656982
(359) DESCRIBE `specials` 0.0045139789581299
(360) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554970') 0.0003509521484375
(361) DESCRIBE `ships` 0.00301194190979
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00037288665771484
(363) DESCRIBE `ships` 0.0027251243591309
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.0002739429473877
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(367) DESCRIBE `itineraries` 0.0023140907287598
(368) DESCRIBE `ports` 0.0017271041870117
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002741813659668
(370) DESCRIBE `ports` 0.0019099712371826
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020909309387207
(372) DESCRIBE `ports` 0.0015809535980225
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027608871459961
(374) DESCRIBE `specialsailingdates` 0.0014729499816895
(375) DESCRIBE `sailingdates` 0.0014989376068115
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 500077))) 0.0005500316619873
(377) DESCRIBE `ports` 0.0019729137420654
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00072097778320312
(379) DESCRIBE `ports` 0.001619815826416
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027704238891602
(381) DESCRIBE `ports` 0.0021049976348877
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00049805641174316
(383) DESCRIBE `ports` 0.0017349720001221
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00025606155395508
(385) DESCRIBE `ports` 0.0014591217041016
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030303001403809
(387) DESCRIBE `ports` 0.0016510486602783
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00031495094299316
(389) DESCRIBE `ports` 0.0019102096557617
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00037598609924316
(391) DESCRIBE `ports` 0.0017809867858887
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00030803680419922
(393) DESCRIBE `ports` 0.0016250610351562
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030207633972168
(395) DESCRIBE `ports` 0.0016210079193115
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00025391578674316
(397) DESCRIBE `ports` 0.0015809535980225
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00032997131347656
(399) DESCRIBE `ports` 0.0019328594207764
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030088424682617
(401) DESCRIBE `ports` 0.0017189979553223
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00036096572875977
(403) DESCRIBE `ports` 0.0017321109771729
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00036287307739258
(405) DESCRIBE `ports` 0.0014119148254395
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038981437683105
(407) DESCRIBE `ports` 0.0017769336700439
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00042986869812012
(409) DESCRIBE `cruises` 0.0025110244750977
(410) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80657))) 0.00032806396484375
(411) DESCRIBE `avid_specials` 0.0013549327850342
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554970 and class = 'Special') OR (item_id = 80657 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0017170906066895
(413) DESCRIBE `cruiselines` 0.0025620460510254
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00037002563476562
(415) DESCRIBE `orchid_image` 0.0024528503417969
(416) DESCRIBE `cruiselines` 0.0024089813232422
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 6.7949295043945E-5
(418) DESCRIBE `cruises` 0.0027918815612793
(419) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80657') 7.2956085205078E-5
(420) DESCRIBE `ships` 0.0026087760925293
(421) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00056004524230957
(422) DESCRIBE `ships` 0.0028820037841797
(423) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00032281875610352
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(426) DESCRIBE `itineraries` 0.0013060569763184
(427) DESCRIBE `ports` 0.0015058517456055
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(429) DESCRIBE `ports` 0.0011110305786133
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(431) DESCRIBE `ports` 0.0017540454864502
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00067281723022461
(433) DESCRIBE `sailingdates` 0.0016899108886719
(434) DESCRIBE `ports` 0.0015449523925781
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00051617622375488
(436) DESCRIBE `ports` 0.0010049343109131
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00061798095703125
(438) DESCRIBE `ports` 0.0011720657348633
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0
(440) DESCRIBE `ports` 0.0010919570922852
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00042605400085449
(442) DESCRIBE `ports` 0.0017390251159668
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00066399574279785
(444) DESCRIBE `ports` 0.0020101070404053
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00026988983154297
(446) DESCRIBE `ports` 0.0018899440765381
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 5.0067901611328E-5
(448) DESCRIBE `ports` 0.001600980758667
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00037002563476562
(450) DESCRIBE `ports` 0.000885009765625
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0
(452) DESCRIBE `ports` 0.0015699863433838
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0
(454) DESCRIBE `ports` 0.001331090927124
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00060105323791504
(456) DESCRIBE `ports` 0.0012638568878174
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00022101402282715
(458) DESCRIBE `ports` 0.002032995223999
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0
(460) DESCRIBE `ports` 0.0014731884002686
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0
(462) DESCRIBE `ports` 0.0019040107727051
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00098609924316406
(464) DESCRIBE `ports` 0.0016050338745117
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00013399124145508
(466) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80657') AND (sailingdate >= '2019-12-15') 0.0047180652618408
(467) DESCRIBE `avid_specials` 0.0013771057128906
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80657 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.00065708160400391
(469) DESCRIBE `cruiselines` 0.0020318031311035
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00030398368835449
(471) DESCRIBE `orchid_image` 0.0014579296112061
(472) DESCRIBE `cruiselines` 0.0018360614776611
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00028300285339355
(474) DESCRIBE `specials` 0.0045549869537354
(475) DESCRIBE `specials` 0.0037357807159424
(476) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1554972') 0.0006859302520752
(477) DESCRIBE `ships` 0.0025930404663086
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00030088424682617
(479) DESCRIBE `ships` 0.0033621788024902
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00078105926513672
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014901161193848
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060200691223145
(483) DESCRIBE `itineraries` 0.0013289451599121
(484) DESCRIBE `ports` 0.0021829605102539
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0010230541229248
(486) DESCRIBE `ports` 0.0025370121002197
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00037598609924316
(488) DESCRIBE `ports` 0.0015490055084229
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030016899108887
(490) DESCRIBE `specialsailingdates` 0.0012359619140625
(491) DESCRIBE `sailingdates` 0.0015058517456055
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 518397))) 0.00049400329589844
(493) DESCRIBE `ports` 0.0015439987182617
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039196014404297
(495) DESCRIBE `ports` 0.0020711421966553
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003209114074707
(497) DESCRIBE `ports` 0.0019259452819824
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00052881240844727
(499) DESCRIBE `ports` 0.0016038417816162
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00029587745666504
(501) DESCRIBE `ports` 0.0013370513916016
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031113624572754
(503) DESCRIBE `ports` 0.0015549659729004
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028014183044434
(505) DESCRIBE `ports` 0.0019569396972656
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00030803680419922
(507) DESCRIBE `ports` 0.0017490386962891
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00029611587524414
(509) DESCRIBE `ports` 0.001270055770874
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00033092498779297
(511) DESCRIBE `ports` 0.0014088153839111
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027108192443848
(513) DESCRIBE `cruises` 0.0028281211853027
(514) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82416))) 0.00044894218444824
(515) DESCRIBE `avid_specials` 0.0011789798736572
(516) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554972 and class = 'Special') OR (item_id = 82416 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.001262903213501
(517) DESCRIBE `cruiselines` 0.0020439624786377
(518) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00033092498779297
(519) DESCRIBE `orchid_image` 0.0015919208526611
(520) DESCRIBE `cruiselines` 0.0022380352020264
(521) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00033187866210938
(522) DESCRIBE `cruises` 0.0027740001678467
(523) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82416') 0.00029897689819336
(524) DESCRIBE `ships` 0.0034070014953613
(525) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00036096572875977
(526) DESCRIBE `ships` 0.003957986831665
(527) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1767') 0.00030994415283203
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026202201843262
(529) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025677680969238
(530) DESCRIBE `itineraries` 0.0019209384918213
(531) DESCRIBE `ports` 0.0013768672943115
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00032281875610352
(533) DESCRIBE `ports` 0.0014228820800781
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030899047851562
(535) DESCRIBE `ports` 0.001492977142334
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00029611587524414
(537) DESCRIBE `sailingdates` 0.0011920928955078
(538) DESCRIBE `ports` 0.0014028549194336
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00032687187194824
(540) DESCRIBE `ports` 0.0012938976287842
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00026893615722656
(542) DESCRIBE `ports` 0.0015270709991455
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00031805038452148
(544) DESCRIBE `ports` 0.0015099048614502
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00027990341186523
(546) DESCRIBE `ports` 0.0014011859893799
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031590461730957
(548) DESCRIBE `ports` 0.0016109943389893
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041294097900391
(550) DESCRIBE `ports` 0.0021359920501709
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00038480758666992
(552) DESCRIBE `ports` 0.0018289089202881
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00038313865661621
(554) DESCRIBE `ports` 0.0018219947814941
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039291381835938
(556) DESCRIBE `ports` 0.0017330646514893
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00034999847412109
(558) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82416') AND (sailingdate >= '2019-12-15') 0.0053842067718506
(559) DESCRIBE `avid_specials` 0.001643180847168
(560) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82416 and class = 'Cruise') OR (item_id = 1767 AND class = 'Ship') OR (item_id = 264 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.0014200210571289
(561) DESCRIBE `cruiselines` 0.0026140213012695
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00042295455932617
(563) DESCRIBE `orchid_image` 0.0019621849060059
(564) DESCRIBE `cruiselines` 0.0028059482574463
(565) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00034594535827637
(566) DESCRIBE `cruiselines` 0.0026600360870361
(567) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('264')) ORDER BY FIND_IN_SET(id, '264') 0.00046706199645996
(568) DESCRIBE `cruisetypes` 0.0017790794372559
(569) DESCRIBE `destinations` 0.0025279521942139
(570) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00071597099304199
(571) DESCRIBE `ships` 0.0038361549377441
(572) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00046896934509277
(573) DESCRIBE `ships` 0.0036330223083496
(574) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1767))) 0.00044822692871094