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

Total elapsed time: 0.97006869316101

# Query Time
(1) connect 0.0012130737304688
(2) DESCRIBE `cruises` 0.0044600963592529
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82172, 82063, 82124, 82125, 82171, 68831, 82064, 82123, 82126, 45864)) ORDER BY FIND_IN_SET(id, '82172,82063,82124,82125,82171,68831,82064,82123,82126,45864') 0.0029480457305908
(4) DESCRIBE `cruises` 0.003925085067749
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00042104721069336
(6) DESCRIBE `ships` 0.00370192527771
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0004889965057373
(8) DESCRIBE `ships` 0.0036840438842773
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00062918663024902
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036382675170898
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043797492980957
(12) DESCRIBE `itineraries` 0.0019049644470215
(13) DESCRIBE `ports` 0.0030019283294678
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00062990188598633
(15) DESCRIBE `ports` 0.0028729438781738
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00058889389038086
(17) DESCRIBE `ports` 0.0030970573425293
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00056695938110352
(19) DESCRIBE `sailingdates` 0.0028300285339355
(20) DESCRIBE `ports` 0.003140926361084
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00074505805969238
(22) DESCRIBE `ports` 0.0027949810028076
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00063014030456543
(24) DESCRIBE `ports` 0.0036680698394775
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00065517425537109
(26) DESCRIBE `ports` 0.0037789344787598
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00069785118103027
(28) DESCRIBE `ports` 0.0036389827728271
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00063085556030273
(30) DESCRIBE `ports` 0.0032038688659668
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00057816505432129
(32) DESCRIBE `ports` 0.0029621124267578
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00062084197998047
(34) DESCRIBE `ports` 0.0031728744506836
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00065708160400391
(36) DESCRIBE `ports` 0.0034050941467285
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00063586235046387
(38) DESCRIBE `ports` 0.0031838417053223
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00059294700622559
(40) DESCRIBE `ports` 0.0033679008483887
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00059795379638672
(42) DESCRIBE `ports` 0.0035190582275391
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00059700012207031
(44) DESCRIBE `ports` 0.0028960704803467
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0006110668182373
(46) DESCRIBE `ports` 0.0028889179229736
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00041294097900391
(48) DESCRIBE `ports` 0.0018510818481445
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00040197372436523
(50) DESCRIBE `ports` 0.0019509792327881
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00051498413085938
(52) DESCRIBE `ports` 0.0019710063934326
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043010711669922
(54) DESCRIBE `ports` 0.0043840408325195
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040292739868164
(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-01-01') 0.011255025863647
(57) DESCRIBE `avid_specials` 0.0017650127410889
(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.0093209743499756
(59) DESCRIBE `cruiselines` 0.0029909610748291
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00046300888061523
(61) DESCRIBE `orchid_image` 0.0045430660247803
(62) DESCRIBE `cruiselines` 0.0026538372039795
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041484832763672
(64) DESCRIBE `cruises` 0.0040647983551025
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.00042390823364258
(66) DESCRIBE `ships` 0.004694938659668
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00055718421936035
(68) DESCRIBE `ships` 0.0039849281311035
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00042104721069336
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040411949157715
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036382675170898
(72) DESCRIBE `itineraries` 0.0027890205383301
(73) DESCRIBE `ports` 0.0020198822021484
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00042915344238281
(75) DESCRIBE `ports` 0.0018479824066162
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0004119873046875
(77) DESCRIBE `ports` 0.0026719570159912
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040197372436523
(79) DESCRIBE `sailingdates` 0.0020878314971924
(80) DESCRIBE `ports` 0.0021820068359375
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00051999092102051
(82) DESCRIBE `ports` 0.002039909362793
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00039792060852051
(84) DESCRIBE `ports` 0.0019600391387939
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041007995605469
(86) DESCRIBE `ports` 0.0018610954284668
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003969669342041
(88) DESCRIBE `ports` 0.0022320747375488
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00040388107299805
(90) DESCRIBE `ports` 0.0023770332336426
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00044798851013184
(92) DESCRIBE `ports` 0.0022070407867432
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00051212310791016
(94) DESCRIBE `ports` 0.0023150444030762
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0004880428314209
(96) DESCRIBE `ports` 0.002608060836792
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00052905082702637
(98) DESCRIBE `ports` 0.0025389194488525
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00047802925109863
(100) DESCRIBE `ports` 0.0020821094512939
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00040411949157715
(102) DESCRIBE `ports` 0.0019640922546387
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00037693977355957
(104) DESCRIBE `ports` 0.0021300315856934
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00048208236694336
(106) DESCRIBE `ports` 0.002302885055542
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00039196014404297
(108) DESCRIBE `ports` 0.0023040771484375
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00050592422485352
(110) DESCRIBE `ports` 0.002316951751709
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00043010711669922
(112) DESCRIBE `ports` 0.0031769275665283
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047206878662109
(114) DESCRIBE `ports` 0.0019421577453613
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039100646972656
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82063') AND (sailingdate >= '2020-01-01') 0.0054340362548828
(117) DESCRIBE `avid_specials` 0.0022649765014648
(118) 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.001945972442627
(119) DESCRIBE `cruiselines` 0.0033628940582275
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00044989585876465
(121) DESCRIBE `orchid_image` 0.00211501121521
(122) DESCRIBE `cruiselines` 0.002601146697998
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00038790702819824
(124) DESCRIBE `cruises` 0.0035409927368164
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00045394897460938
(126) DESCRIBE `ships` 0.0038580894470215
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00056910514831543
(128) DESCRIBE `ships` 0.0042488574981689
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00049400329589844
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048303604125977
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045609474182129
(132) DESCRIBE `itineraries` 0.002363920211792
(133) DESCRIBE `ports` 0.002432107925415
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00045490264892578
(135) DESCRIBE `ports` 0.0025489330291748
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00059795379638672
(137) DESCRIBE `ports` 0.0019810199737549
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039291381835938
(139) DESCRIBE `sailingdates` 0.001568078994751
(140) DESCRIBE `ports` 0.0017790794372559
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042605400085449
(142) DESCRIBE `ports` 0.0019710063934326
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00048398971557617
(144) DESCRIBE `ports` 0.0019731521606445
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039911270141602
(146) DESCRIBE `ports` 0.0019280910491943
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003821849822998
(148) DESCRIBE `ports` 0.0018730163574219
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00047397613525391
(150) DESCRIBE `ports` 0.0018310546875
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003809928894043
(152) DESCRIBE `ports` 0.0024950504302979
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00043010711669922
(154) DESCRIBE `ports` 0.0022978782653809
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00041818618774414
(156) DESCRIBE `ports` 0.001990795135498
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00043106079101562
(158) DESCRIBE `ports` 0.0020289421081543
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00040793418884277
(160) DESCRIBE `ports` 0.0020639896392822
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00053596496582031
(162) DESCRIBE `ports` 0.0032229423522949
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00063419342041016
(164) DESCRIBE `ports` 0.0032660961151123
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00052499771118164
(166) DESCRIBE `ports` 0.0024409294128418
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00040507316589355
(168) DESCRIBE `ports` 0.002392053604126
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00047397613525391
(170) DESCRIBE `ports` 0.0020031929016113
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00040602684020996
(172) DESCRIBE `ports` 0.0018990039825439
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004270076751709
(174) DESCRIBE `ports` 0.0019462108612061
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040602684020996
(176) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82124') AND (sailingdate >= '2020-01-01') 0.0087230205535889
(177) DESCRIBE `avid_specials` 0.0019071102142334
(178) 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.0011768341064453
(179) DESCRIBE `cruiselines` 0.002701997756958
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0004580020904541
(181) DESCRIBE `orchid_image` 0.0020520687103271
(182) DESCRIBE `cruiselines` 0.0025520324707031
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00039505958557129
(184) DESCRIBE `cruises` 0.0049540996551514
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00042200088500977
(186) DESCRIBE `ships` 0.0035560131072998
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00046706199645996
(188) DESCRIBE `ships` 0.0034160614013672
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00055813789367676
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(192) DESCRIBE `itineraries` 0.0017709732055664
(193) DESCRIBE `ports` 0.0018789768218994
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00051307678222656
(195) DESCRIBE `ports` 0.0021779537200928
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047612190246582
(197) DESCRIBE `ports` 0.0020229816436768
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040197372436523
(199) DESCRIBE `sailingdates` 0.0020420551300049
(200) DESCRIBE `ports` 0.0023219585418701
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047492980957031
(202) DESCRIBE `ports` 0.0019121170043945
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00049996376037598
(204) DESCRIBE `ports` 0.0019729137420654
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040292739868164
(206) DESCRIBE `ports` 0.0018429756164551
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00042390823364258
(208) DESCRIBE `ports` 0.0018680095672607
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.0004429817199707
(210) DESCRIBE `ports` 0.0020170211791992
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00038290023803711
(212) DESCRIBE `ports` 0.0018758773803711
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00045990943908691
(214) DESCRIBE `ports` 0.0017850399017334
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0003809928894043
(216) DESCRIBE `ports` 0.0018270015716553
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00040912628173828
(218) DESCRIBE `ports` 0.0018739700317383
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00039505958557129
(220) DESCRIBE `ports` 0.0018110275268555
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00041389465332031
(222) DESCRIBE `ports` 0.0018048286437988
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00040102005004883
(224) DESCRIBE `ports` 0.0020711421966553
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00047802925109863
(226) DESCRIBE `ports` 0.0017690658569336
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00039410591125488
(228) DESCRIBE `ports` 0.0017259120941162
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00040102005004883
(230) DESCRIBE `ports` 0.0019009113311768
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00049209594726562
(232) DESCRIBE `ports` 0.0018148422241211
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041413307189941
(234) DESCRIBE `ports` 0.0017619132995605
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00046491622924805
(236) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82125') AND (sailingdate >= '2020-01-01') 0.0052800178527832
(237) DESCRIBE `avid_specials` 0.0017449855804443
(238) 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.0011570453643799
(239) DESCRIBE `cruiselines` 0.0025460720062256
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00045084953308105
(241) DESCRIBE `orchid_image` 0.0023720264434814
(242) DESCRIBE `cruiselines` 0.0026369094848633
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00053596496582031
(244) DESCRIBE `cruises` 0.0036768913269043
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.00056695938110352
(246) DESCRIBE `ships` 0.0051419734954834
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0005948543548584
(248) DESCRIBE `ships` 0.0070431232452393
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00080299377441406
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046491622924805
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036811828613281
(252) DESCRIBE `itineraries` 0.0019798278808594
(253) DESCRIBE `ports` 0.0019891262054443
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00057101249694824
(255) DESCRIBE `ports` 0.0031700134277344
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041604042053223
(257) DESCRIBE `ports` 0.0020170211791992
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040102005004883
(259) DESCRIBE `sailingdates` 0.0017211437225342
(260) DESCRIBE `ports` 0.0027170181274414
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00051999092102051
(262) DESCRIBE `ports` 0.0017490386962891
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00046396255493164
(264) DESCRIBE `ports` 0.0026299953460693
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0005640983581543
(266) DESCRIBE `ports` 0.0026681423187256
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00072193145751953
(268) DESCRIBE `ports` 0.0020821094512939
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00044584274291992
(270) DESCRIBE `ports` 0.0022618770599365
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00043010711669922
(272) DESCRIBE `ports` 0.0017790794372559
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00043487548828125
(274) DESCRIBE `ports` 0.0026450157165527
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00050616264343262
(276) DESCRIBE `ports` 0.0035331249237061
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00072884559631348
(278) DESCRIBE `ports` 0.0049569606781006
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0006561279296875
(280) DESCRIBE `ports` 0.002208948135376
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00046205520629883
(282) DESCRIBE `ports` 0.0019590854644775
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00041985511779785
(284) DESCRIBE `ports` 0.0020339488983154
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00060796737670898
(286) DESCRIBE `ports` 0.0019609928131104
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00046801567077637
(288) DESCRIBE `ports` 0.0024580955505371
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00054121017456055
(290) DESCRIBE `ports` 0.0025179386138916
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0005040168762207
(292) DESCRIBE `ports` 0.0021378993988037
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043797492980957
(294) DESCRIBE `ports` 0.0022730827331543
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00057697296142578
(296) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82171') AND (sailingdate >= '2020-01-01') 0.0067250728607178
(297) DESCRIBE `avid_specials` 0.002284049987793
(298) 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.0011680126190186
(299) DESCRIBE `cruiselines` 0.0026638507843018
(300) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0005340576171875
(301) DESCRIBE `orchid_image` 0.0022170543670654
(302) DESCRIBE `cruiselines` 0.0027010440826416
(303) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00043296813964844
(304) DESCRIBE `cruises` 0.0043530464172363
(305) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.0004730224609375
(306) DESCRIBE `ships` 0.0037050247192383
(307) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00052499771118164
(308) DESCRIBE `ships` 0.0036110877990723
(309) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00040507316589355
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036907196044922
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044894218444824
(312) DESCRIBE `itineraries` 0.0018341541290283
(313) DESCRIBE `ports` 0.0019710063934326
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00045013427734375
(315) DESCRIBE `ports` 0.0019540786743164
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042009353637695
(317) DESCRIBE `ports` 0.0018608570098877
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040102005004883
(319) DESCRIBE `sailingdates` 0.0016348361968994
(320) DESCRIBE `ports` 0.002051830291748
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043582916259766
(322) DESCRIBE `ports` 0.0018100738525391
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037097930908203
(324) DESCRIBE `ports` 0.0018150806427002
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043797492980957
(326) DESCRIBE `ports` 0.0018298625946045
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037598609924316
(328) DESCRIBE `ports` 0.0017931461334229
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00039219856262207
(330) DESCRIBE `ports` 0.0018298625946045
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00037097930908203
(332) DESCRIBE `ports` 0.0017390251159668
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00038909912109375
(334) DESCRIBE `ports` 0.002147912979126
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037503242492676
(336) DESCRIBE `ports` 0.001920223236084
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00041508674621582
(338) DESCRIBE `ports` 0.0018751621246338
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00047206878662109
(340) DESCRIBE `ports` 0.0018050670623779
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00041413307189941
(342) DESCRIBE `ports` 0.0018370151519775
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00037193298339844
(344) DESCRIBE `ports` 0.0020060539245605
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00041103363037109
(346) DESCRIBE `ports` 0.0017380714416504
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00046205520629883
(348) DESCRIBE `ports` 0.0018150806427002
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00038695335388184
(350) DESCRIBE `ports` 0.0022130012512207
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038290023803711
(352) DESCRIBE `ports` 0.0019400119781494
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0003969669342041
(354) DESCRIBE `ports` 0.001816987991333
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00036811828613281
(356) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2020-01-01') 0.0050551891326904
(357) DESCRIBE `avid_specials` 0.0016798973083496
(358) 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.0010910034179688
(359) DESCRIBE `cruiselines` 0.0026688575744629
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00041103363037109
(361) DESCRIBE `orchid_image` 0.0019180774688721
(362) DESCRIBE `cruiselines` 0.0028059482574463
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00038981437683105
(364) DESCRIBE `cruises` 0.0034148693084717
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.00038695335388184
(366) DESCRIBE `ships` 0.0039119720458984
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0004889965057373
(368) DESCRIBE `ships` 0.0036110877990723
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00040912628173828
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034880638122559
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(372) DESCRIBE `itineraries` 0.0019629001617432
(373) DESCRIBE `ports` 0.0019140243530273
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00048995018005371
(375) DESCRIBE `ports` 0.0017569065093994
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00038790702819824
(377) DESCRIBE `ports` 0.0019280910491943
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003809928894043
(379) DESCRIBE `sailingdates` 0.0017778873443604
(380) DESCRIBE `ports` 0.0024220943450928
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00055694580078125
(382) DESCRIBE `ports` 0.0019130706787109
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00038290023803711
(384) DESCRIBE `ports` 0.0017671585083008
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040006637573242
(386) DESCRIBE `ports` 0.0017890930175781
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040292739868164
(388) DESCRIBE `ports` 0.0020971298217773
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0005190372467041
(390) DESCRIBE `ports` 0.0019328594207764
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037598609924316
(392) DESCRIBE `ports` 0.0021071434020996
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00040292739868164
(394) DESCRIBE `ports` 0.0017368793487549
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037288665771484
(396) DESCRIBE `ports` 0.0020878314971924
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00040793418884277
(398) DESCRIBE `ports` 0.0018281936645508
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00040102005004883
(400) DESCRIBE `ports` 0.0019240379333496
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00044918060302734
(402) DESCRIBE `ports` 0.0020170211791992
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00055503845214844
(404) DESCRIBE `ports` 0.0022850036621094
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00044703483581543
(406) DESCRIBE `ports` 0.0020101070404053
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00038790702819824
(408) DESCRIBE `ports` 0.0019600391387939
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00040602684020996
(410) DESCRIBE `ports` 0.0018360614776611
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00043106079101562
(412) DESCRIBE `ports` 0.0019569396972656
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047111511230469
(414) DESCRIBE `ports` 0.0017828941345215
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00041103363037109
(416) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82064') AND (sailingdate >= '2020-01-01') 0.0052409172058105
(417) DESCRIBE `avid_specials` 0.0017139911651611
(418) 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.0016570091247559
(419) DESCRIBE `cruiselines` 0.0039060115814209
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00061702728271484
(421) DESCRIBE `orchid_image` 0.0029301643371582
(422) DESCRIBE `cruiselines` 0.0027139186859131
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0004730224609375
(424) DESCRIBE `cruises` 0.0036568641662598
(425) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82123') 0.00054502487182617
(426) DESCRIBE `ships` 0.0044999122619629
(427) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00069212913513184
(428) DESCRIBE `ships` 0.0053410530090332
(429) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00057888031005859
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054311752319336
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048995018005371
(432) DESCRIBE `itineraries` 0.0027060508728027
(433) DESCRIBE `ports` 0.002918004989624
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00067996978759766
(435) DESCRIBE `ports` 0.0029308795928955
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00070500373840332
(437) DESCRIBE `ports` 0.0055601596832275
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00065708160400391
(439) DESCRIBE `sailingdates` 0.0024840831756592
(440) DESCRIBE `ports` 0.0030419826507568
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00067400932312012
(442) DESCRIBE `ports` 0.0028290748596191
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00058412551879883
(444) DESCRIBE `ports` 0.0027050971984863
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00061392784118652
(446) DESCRIBE `ports` 0.0025961399078369
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00057506561279297
(448) DESCRIBE `ports` 0.002655029296875
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00057101249694824
(450) DESCRIBE `ports` 0.0024638175964355
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00057411193847656
(452) DESCRIBE `ports` 0.0025310516357422
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00062990188598633
(454) DESCRIBE `ports` 0.0021700859069824
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00047397613525391
(456) DESCRIBE `ports` 0.0018360614776611
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00038313865661621
(458) DESCRIBE `ports` 0.0018939971923828
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00036311149597168
(460) DESCRIBE `ports` 0.0021011829376221
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00050497055053711
(462) DESCRIBE `ports` 0.0023059844970703
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00057196617126465
(464) DESCRIBE `ports` 0.0021588802337646
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00049281120300293
(466) DESCRIBE `ports` 0.0019948482513428
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00048398971557617
(468) DESCRIBE `ports` 0.0019381046295166
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00045108795166016
(470) DESCRIBE `ports` 0.0018329620361328
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00047898292541504
(472) DESCRIBE `ports` 0.0018429756164551
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00044512748718262
(474) DESCRIBE `ports` 0.0018069744110107
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00048208236694336
(476) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82123') AND (sailingdate >= '2020-01-01') 0.0051259994506836
(477) DESCRIBE `avid_specials` 0.0017991065979004
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82123 and class = 'Cruise') OR (item_id = 1163 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.0012731552124023
(479) DESCRIBE `cruiselines` 0.0026810169219971
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00053596496582031
(481) DESCRIBE `orchid_image` 0.0020599365234375
(482) DESCRIBE `cruiselines` 0.0026280879974365
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00058197975158691
(484) DESCRIBE `cruises` 0.0039560794830322
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82126') 0.00042104721069336
(486) DESCRIBE `ships` 0.004019021987915
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0005800724029541
(488) DESCRIBE `ships` 0.0037438869476318
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00044417381286621
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044703483581543
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042390823364258
(492) DESCRIBE `itineraries` 0.0022799968719482
(493) DESCRIBE `ports` 0.0019679069519043
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044584274291992
(495) DESCRIBE `ports` 0.0018670558929443
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00042414665222168
(497) DESCRIBE `ports` 0.0020749568939209
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00047612190246582
(499) DESCRIBE `sailingdates` 0.0015730857849121
(500) DESCRIBE `ports` 0.0020270347595215
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00061392784118652
(502) DESCRIBE `ports` 0.0020139217376709
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00052285194396973
(504) DESCRIBE `ports` 0.0018961429595947
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00048398971557617
(506) DESCRIBE `ports` 0.0018241405487061
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00056815147399902
(508) DESCRIBE `ports` 0.0017580986022949
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00048708915710449
(510) DESCRIBE `ports` 0.001823902130127
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00040102005004883
(512) DESCRIBE `ports` 0.0018401145935059
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00040388107299805
(514) DESCRIBE `ports` 0.0018699169158936
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00041103363037109
(516) DESCRIBE `ports` 0.0017499923706055
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00055789947509766
(518) DESCRIBE `ports` 0.0019168853759766
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00045013427734375
(520) DESCRIBE `ports` 0.0018219947814941
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00039887428283691
(522) DESCRIBE `ports` 0.0018351078033447
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00038003921508789
(524) DESCRIBE `ports` 0.0017340183258057
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00039792060852051
(526) DESCRIBE `ports` 0.0020279884338379
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00041699409484863
(528) DESCRIBE `ports` 0.0018351078033447
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00040316581726074
(530) DESCRIBE `ports` 0.0024149417877197
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.000762939453125
(532) DESCRIBE `ports` 0.0022041797637939
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004580020904541
(534) DESCRIBE `ports` 0.0018811225891113
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00046706199645996
(536) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82126') AND (sailingdate >= '2020-01-01') 0.0055861473083496
(537) DESCRIBE `avid_specials` 0.0019271373748779
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82126 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.0011730194091797
(539) DESCRIBE `cruiselines` 0.0029840469360352
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00049495697021484
(541) DESCRIBE `orchid_image` 0.0022599697113037
(542) DESCRIBE `cruiselines` 0.0027589797973633
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00050902366638184
(544) DESCRIBE `cruises` 0.0038559436798096
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45864') 0.00043892860412598
(546) DESCRIBE `ships` 0.0037150382995605
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.0008080005645752
(548) DESCRIBE `ships` 0.0043880939483643
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00046205520629883
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003511905670166
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050187110900879
(552) DESCRIBE `itineraries` 0.0017950534820557
(553) DESCRIBE `ports` 0.0020039081573486
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00054407119750977
(555) DESCRIBE `ports` 0.0017809867858887
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00041818618774414
(557) DESCRIBE `ports` 0.0021610260009766
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00040006637573242
(559) DESCRIBE `sailingdates` 0.001708984375
(560) DESCRIBE `ports` 0.002230167388916
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00048494338989258
(562) DESCRIBE `ports` 0.0019340515136719
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00050806999206543
(564) DESCRIBE `ports` 0.0024189949035645
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00045990943908691
(566) DESCRIBE `ports` 0.0025589466094971
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00046396255493164
(568) DESCRIBE `ports` 0.0018839836120605
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00040006637573242
(570) DESCRIBE `ports` 0.0018761157989502
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00039291381835938
(572) DESCRIBE `ports` 0.0018279552459717
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00043010711669922
(574) DESCRIBE `ports` 0.0017998218536377
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.0004119873046875
(576) DESCRIBE `ports` 0.0017509460449219
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00041103363037109
(578) DESCRIBE `ports` 0.0017449855804443
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037097930908203
(580) DESCRIBE `ports` 0.001917839050293
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00041413307189941
(582) DESCRIBE `ports` 0.0018830299377441
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.0003819465637207
(584) DESCRIBE `ports` 0.0018119812011719
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00041413307189941
(586) DESCRIBE `ports` 0.0017960071563721
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00037097930908203
(588) DESCRIBE `ports` 0.0021250247955322
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00068998336791992
(590) DESCRIBE `ports` 0.0019590854644775
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00039386749267578
(592) DESCRIBE `ports` 0.0017988681793213
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00044989585876465
(594) DESCRIBE `ports` 0.0019030570983887
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00053787231445312
(596) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '45864') AND (sailingdate >= '2020-01-01') 0.0052151679992676
(597) DESCRIBE `avid_specials` 0.0017697811126709
(598) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45864 and class = 'Cruise') OR (item_id = 1163 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.0013358592987061
(599) DESCRIBE `cruiselines` 0.0027039051055908
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0004420280456543
(601) DESCRIBE `orchid_image` 0.0022430419921875
(602) DESCRIBE `cruiselines` 0.0028009414672852
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040817260742188
(604) DESCRIBE `ships` 0.0036718845367432
(605) SELECT `ships`.* FROM `ships` WHERE (id IN ('1013', '1526', '1163', '1791')) ORDER BY FIND_IN_SET(id, '1013,1526,1163,1791') 0.0013940334320068
(606) DESCRIBE `cruisetypes` 0.0015361309051514
(607) DESCRIBE `destinations` 0.0023889541625977
(608) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.00069117546081543
(609) DESCRIBE `cruiselines` 0.0025250911712646
(610) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00045990943908691
(611) DESCRIBE `cruiselines` 0.0026919841766357
(612) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00053501129150391