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.96831583976746

# Query Time
(1) connect 0.00094509124755859
(2) DESCRIBE `cruises` 0.0048139095306396
(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.0026149749755859
(4) DESCRIBE `cruises` 0.0039541721343994
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00062990188598633
(6) DESCRIBE `ships` 0.0036959648132324
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00056791305541992
(8) DESCRIBE `ships` 0.0037400722503662
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00042009353637695
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033903121948242
(12) DESCRIBE `itineraries` 0.0018219947814941
(13) DESCRIBE `ports` 0.0019769668579102
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044012069702148
(15) DESCRIBE `ports` 0.0019600391387939
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00038909912109375
(17) DESCRIBE `ports` 0.0018601417541504
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00049495697021484
(19) DESCRIBE `sailingdates` 0.0015308856964111
(20) DESCRIBE `ports` 0.0021650791168213
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00045514106750488
(22) DESCRIBE `ports` 0.0020668506622314
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037908554077148
(24) DESCRIBE `ports` 0.0017211437225342
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040292739868164
(26) DESCRIBE `ports` 0.0018188953399658
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00036287307739258
(28) DESCRIBE `ports` 0.0017800331115723
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00037908554077148
(30) DESCRIBE `ports` 0.0018150806427002
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00039196014404297
(32) DESCRIBE `ports` 0.0018651485443115
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00041604042053223
(34) DESCRIBE `ports` 0.0017910003662109
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00040197372436523
(36) DESCRIBE `ports` 0.0018179416656494
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00046396255493164
(38) DESCRIBE `ports` 0.0017819404602051
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00046706199645996
(40) DESCRIBE `ports` 0.0017869472503662
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00038599967956543
(42) DESCRIBE `ports` 0.0018889904022217
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00053215026855469
(44) DESCRIBE `ports` 0.001990795135498
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00055193901062012
(46) DESCRIBE `ports` 0.0018651485443115
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00040006637573242
(48) DESCRIBE `ports` 0.0018010139465332
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00040793418884277
(50) DESCRIBE `ports` 0.0018260478973389
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00051593780517578
(52) DESCRIBE `ports` 0.0027730464935303
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00055599212646484
(54) DESCRIBE `ports` 0.0027430057525635
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00069093704223633
(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.0074079036712646
(57) DESCRIBE `avid_specials` 0.0020451545715332
(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.0011708736419678
(59) DESCRIBE `cruiselines` 0.0028188228607178
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00066089630126953
(61) DESCRIBE `orchid_image` 0.0021970272064209
(62) DESCRIBE `cruiselines` 0.0026118755340576
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00050091743469238
(64) DESCRIBE `cruises` 0.0047140121459961
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.0005958080291748
(66) DESCRIBE `ships` 0.004749059677124
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0007929801940918
(68) DESCRIBE `ships` 0.0034840106964111
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00042200088500977
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036096572875977
(72) DESCRIBE `itineraries` 0.0019910335540771
(73) DESCRIBE `ports` 0.0018279552459717
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041985511779785
(75) DESCRIBE `ports` 0.0018889904022217
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00039291381835938
(77) DESCRIBE `ports` 0.0018749237060547
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00044894218444824
(79) DESCRIBE `sailingdates` 0.0018391609191895
(80) DESCRIBE `ports` 0.00199294090271
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00050997734069824
(82) DESCRIBE `ports` 0.0018241405487061
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040793418884277
(84) DESCRIBE `ports` 0.0020182132720947
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044512748718262
(86) DESCRIBE `ports` 0.0019550323486328
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00038695335388184
(88) DESCRIBE `ports` 0.0017650127410889
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00049090385437012
(90) DESCRIBE `ports` 0.0025091171264648
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00038003921508789
(92) DESCRIBE `ports` 0.0020830631256104
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00040411949157715
(94) DESCRIBE `ports` 0.0018730163574219
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00037813186645508
(96) DESCRIBE `ports` 0.002047061920166
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00060296058654785
(98) DESCRIBE `ports` 0.0022358894348145
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00039005279541016
(100) DESCRIBE `ports` 0.0020949840545654
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.0044879913330078
(102) DESCRIBE `ports` 0.0024130344390869
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00063180923461914
(104) DESCRIBE `ports` 0.0017480850219727
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00039505958557129
(106) DESCRIBE `ports` 0.0019848346710205
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037908554077148
(108) DESCRIBE `ports` 0.0019528865814209
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00041699409484863
(110) DESCRIBE `ports` 0.0023369789123535
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00047087669372559
(112) DESCRIBE `ports` 0.0028550624847412
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00053691864013672
(114) DESCRIBE `ports` 0.0020418167114258
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039005279541016
(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.0051829814910889
(117) DESCRIBE `avid_specials` 0.0017030239105225
(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.00111985206604
(119) DESCRIBE `cruiselines` 0.0025880336761475
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00053095817565918
(121) DESCRIBE `orchid_image` 0.0020508766174316
(122) DESCRIBE `cruiselines` 0.0026049613952637
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00043201446533203
(124) DESCRIBE `cruises` 0.0035669803619385
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00043392181396484
(126) DESCRIBE `ships` 0.0039591789245605
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00051999092102051
(128) DESCRIBE `ships` 0.0041079521179199
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0004429817199707
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038003921508789
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040102005004883
(132) DESCRIBE `itineraries` 0.0018401145935059
(133) DESCRIBE `ports` 0.0019800662994385
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043487548828125
(135) DESCRIBE `ports` 0.0019400119781494
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003969669342041
(137) DESCRIBE `ports` 0.0018589496612549
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00046086311340332
(139) DESCRIBE `sailingdates` 0.0016469955444336
(140) DESCRIBE `ports` 0.0020430088043213
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00048017501831055
(142) DESCRIBE `ports` 0.0019998550415039
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037813186645508
(144) DESCRIBE `ports` 0.0021431446075439
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039887428283691
(146) DESCRIBE `ports` 0.0017898082733154
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00055193901062012
(148) DESCRIBE `ports` 0.0019381046295166
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00043487548828125
(150) DESCRIBE `ports` 0.0017318725585938
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037288665771484
(152) DESCRIBE `ports` 0.0018658638000488
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00042414665222168
(154) DESCRIBE `ports` 0.0017919540405273
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00044894218444824
(156) DESCRIBE `ports` 0.0021090507507324
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00056910514831543
(158) DESCRIBE `ports` 0.0022521018981934
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00044083595275879
(160) DESCRIBE `ports` 0.0020909309387207
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00045990943908691
(162) DESCRIBE `ports` 0.0023930072784424
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00061297416687012
(164) DESCRIBE `ports` 0.003309965133667
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00068116188049316
(166) DESCRIBE `ports` 0.0021889209747314
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00041389465332031
(168) DESCRIBE `ports` 0.0017898082733154
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00046396255493164
(170) DESCRIBE `ports` 0.0019378662109375
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00039911270141602
(172) DESCRIBE `ports` 0.0018320083618164
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039911270141602
(174) DESCRIBE `ports` 0.0017819404602051
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00042581558227539
(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.0053689479827881
(177) DESCRIBE `avid_specials` 0.002108097076416
(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.001133918762207
(179) DESCRIBE `cruiselines` 0.0027539730072021
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00046896934509277
(181) DESCRIBE `orchid_image` 0.0020909309387207
(182) DESCRIBE `cruiselines` 0.0025379657745361
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00039005279541016
(184) DESCRIBE `cruises` 0.0034549236297607
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00041103363037109
(186) DESCRIBE `ships` 0.0035150051116943
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00059890747070312
(188) DESCRIBE `ships` 0.0034270286560059
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00045895576477051
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(192) DESCRIBE `itineraries` 0.0017790794372559
(193) DESCRIBE `ports` 0.001849889755249
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043582916259766
(195) DESCRIBE `ports` 0.0017609596252441
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047111511230469
(197) DESCRIBE `ports` 0.0017998218536377
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003960132598877
(199) DESCRIBE `sailingdates` 0.0019750595092773
(200) DESCRIBE `ports` 0.0019450187683105
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00054693222045898
(202) DESCRIBE `ports` 0.0017740726470947
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0004279613494873
(204) DESCRIBE `ports` 0.0018661022186279
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041007995605469
(206) DESCRIBE `ports` 0.00180983543396
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00038290023803711
(208) DESCRIBE `ports` 0.0018229484558105
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00043606758117676
(210) DESCRIBE `ports` 0.0018510818481445
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00038290023803711
(212) DESCRIBE `ports` 0.0018889904022217
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00042986869812012
(214) DESCRIBE `ports` 0.0019590854644775
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0004119873046875
(216) DESCRIBE `ports` 0.0018689632415771
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00043511390686035
(218) DESCRIBE `ports` 0.0021579265594482
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00043678283691406
(220) DESCRIBE `ports` 0.0020089149475098
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00045394897460938
(222) DESCRIBE `ports` 0.0018157958984375
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00042605400085449
(224) DESCRIBE `ports` 0.0025107860565186
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00044894218444824
(226) DESCRIBE `ports` 0.0018339157104492
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00040698051452637
(228) DESCRIBE `ports` 0.0019550323486328
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00042200088500977
(230) DESCRIBE `ports` 0.0017759799957275
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00042295455932617
(232) DESCRIBE `ports` 0.0020439624786377
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044393539428711
(234) DESCRIBE `ports` 0.0018999576568604
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00044608116149902
(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.0049929618835449
(237) DESCRIBE `avid_specials` 0.0016810894012451
(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.0011889934539795
(239) DESCRIBE `cruiselines` 0.0025758743286133
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00046896934509277
(241) DESCRIBE `orchid_image` 0.0019681453704834
(242) DESCRIBE `cruiselines` 0.0027370452880859
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0004119873046875
(244) DESCRIBE `cruises` 0.0033650398254395
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.00039386749267578
(246) DESCRIBE `ships` 0.0040230751037598
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0005800724029541
(248) DESCRIBE `ships` 0.0055630207061768
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0006561279296875
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052905082702637
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048589706420898
(252) DESCRIBE `itineraries` 0.0020570755004883
(253) DESCRIBE `ports` 0.0018510818481445
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043201446533203
(255) DESCRIBE `ports` 0.0018041133880615
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00042200088500977
(257) DESCRIBE `ports` 0.0018370151519775
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00044798851013184
(259) DESCRIBE `sailingdates` 0.0018529891967773
(260) DESCRIBE `ports` 0.00199294090271
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00045013427734375
(262) DESCRIBE `ports` 0.0018258094787598
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003809928894043
(264) DESCRIBE `ports` 0.0018539428710938
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041699409484863
(266) DESCRIBE `ports` 0.0019888877868652
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040197372436523
(268) DESCRIBE `ports` 0.0018041133880615
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.0003960132598877
(270) DESCRIBE `ports` 0.0017828941345215
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00036001205444336
(272) DESCRIBE `ports` 0.0017528533935547
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00043296813964844
(274) DESCRIBE `ports` 0.0018908977508545
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0003809928894043
(276) DESCRIBE `ports` 0.0019819736480713
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00042200088500977
(278) DESCRIBE `ports` 0.001741886138916
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00038504600524902
(280) DESCRIBE `ports` 0.0018389225006104
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00041079521179199
(282) DESCRIBE `ports` 0.001816987991333
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00037813186645508
(284) DESCRIBE `ports` 0.001943826675415
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0004119873046875
(286) DESCRIBE `ports` 0.0017671585083008
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037908554077148
(288) DESCRIBE `ports` 0.0018088817596436
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00041389465332031
(290) DESCRIBE `ports` 0.0017879009246826
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00043606758117676
(292) DESCRIBE `ports` 0.0018620491027832
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042295455932617
(294) DESCRIBE `ports` 0.00177001953125
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039482116699219
(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.0050621032714844
(297) DESCRIBE `avid_specials` 0.001823902130127
(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.001176118850708
(299) DESCRIBE `cruiselines` 0.002687931060791
(300) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00044012069702148
(301) DESCRIBE `orchid_image` 0.0021920204162598
(302) DESCRIBE `cruiselines` 0.0025820732116699
(303) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040292739868164
(304) DESCRIBE `cruises` 0.0041089057922363
(305) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00047492980957031
(306) DESCRIBE `ships` 0.0045678615570068
(307) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00071501731872559
(308) DESCRIBE `ships` 0.0038762092590332
(309) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00046586990356445
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036382675170898
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040197372436523
(312) DESCRIBE `itineraries` 0.002007007598877
(313) DESCRIBE `ports` 0.001863956451416
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00045895576477051
(315) DESCRIBE `ports` 0.0018801689147949
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041508674621582
(317) DESCRIBE `ports` 0.0022640228271484
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00038886070251465
(319) DESCRIBE `sailingdates` 0.0016810894012451
(320) DESCRIBE `ports` 0.0019779205322266
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00050210952758789
(322) DESCRIBE `ports` 0.0017738342285156
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040411949157715
(324) DESCRIBE `ports` 0.0017819404602051
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004119873046875
(326) DESCRIBE `ports` 0.0019118785858154
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037407875061035
(328) DESCRIBE `ports` 0.0018470287322998
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00042510032653809
(330) DESCRIBE `ports` 0.0019509792327881
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00042819976806641
(332) DESCRIBE `ports` 0.0018050670623779
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00038599967956543
(334) DESCRIBE `ports` 0.0018260478973389
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037908554077148
(336) DESCRIBE `ports` 0.0017950534820557
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00041699409484863
(338) DESCRIBE `ports` 0.0018789768218994
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00040221214294434
(340) DESCRIBE `ports` 0.0018079280853271
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00047707557678223
(342) DESCRIBE `ports` 0.0018529891967773
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00043201446533203
(344) DESCRIBE `ports` 0.0019590854644775
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0004580020904541
(346) DESCRIBE `ports` 0.0020990371704102
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.0003819465637207
(348) DESCRIBE `ports` 0.0019078254699707
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0005030632019043
(350) DESCRIBE `ports` 0.0018589496612549
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00039100646972656
(352) DESCRIBE `ports` 0.0022258758544922
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043606758117676
(354) DESCRIBE `ports` 0.001802921295166
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00045204162597656
(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.0065219402313232
(357) DESCRIBE `avid_specials` 0.0017261505126953
(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.0011720657348633
(359) DESCRIBE `cruiselines` 0.0024950504302979
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0004580020904541
(361) DESCRIBE `orchid_image` 0.0020911693572998
(362) DESCRIBE `cruiselines` 0.0034201145172119
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00042295455932617
(364) DESCRIBE `cruises` 0.0039229393005371
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.00060701370239258
(366) DESCRIBE `ships` 0.004256010055542
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00057601928710938
(368) DESCRIBE `ships` 0.0040781497955322
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00048518180847168
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040602684020996
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037884712219238
(372) DESCRIBE `itineraries` 0.0018410682678223
(373) DESCRIBE `ports` 0.0018918514251709
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041699409484863
(375) DESCRIBE `ports` 0.0022799968719482
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00053501129150391
(377) DESCRIBE `ports` 0.0019819736480713
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00043392181396484
(379) DESCRIBE `sailingdates` 0.0019118785858154
(380) DESCRIBE `ports` 0.0018711090087891
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042510032653809
(382) DESCRIBE `ports` 0.0030021667480469
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003819465637207
(384) DESCRIBE `ports` 0.0023908615112305
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044393539428711
(386) DESCRIBE `ports` 0.0020060539245605
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00049090385437012
(388) DESCRIBE `ports` 0.0024280548095703
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00043702125549316
(390) DESCRIBE `ports` 0.0020449161529541
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037693977355957
(392) DESCRIBE `ports` 0.0020520687103271
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00040698051452637
(394) DESCRIBE `ports` 0.0030450820922852
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00039982795715332
(396) DESCRIBE `ports` 0.0022521018981934
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.0004270076751709
(398) DESCRIBE `ports` 0.0024240016937256
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00040292739868164
(400) DESCRIBE `ports` 0.0022761821746826
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00060009956359863
(402) DESCRIBE `ports` 0.0023539066314697
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00037980079650879
(404) DESCRIBE `ports` 0.0027010440826416
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00058984756469727
(406) DESCRIBE `ports` 0.0022039413452148
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00046300888061523
(408) DESCRIBE `ports` 0.00217604637146
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00043988227844238
(410) DESCRIBE `ports` 0.0018589496612549
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00039792060852051
(412) DESCRIBE `ports` 0.0026419162750244
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00048589706420898
(414) DESCRIBE `ports` 0.0030398368835449
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00049614906311035
(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.0091350078582764
(417) DESCRIBE `avid_specials` 0.0022869110107422
(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.0021669864654541
(419) DESCRIBE `cruiselines` 0.0040988922119141
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00066804885864258
(421) DESCRIBE `orchid_image` 0.0032179355621338
(422) DESCRIBE `cruiselines` 0.0042960643768311
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00056982040405273
(424) DESCRIBE `cruises` 0.0049939155578613
(425) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82123') 0.00057506561279297
(426) DESCRIBE `ships` 0.0047299861907959
(427) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00050687789916992
(428) DESCRIBE `ships` 0.0037741661071777
(429) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00039291381835938
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042200088500977
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(432) DESCRIBE `itineraries` 0.0017960071563721
(433) DESCRIBE `ports` 0.0018010139465332
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00046515464782715
(435) DESCRIBE `ports` 0.0023000240325928
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00045609474182129
(437) DESCRIBE `ports` 0.0018918514251709
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.0004122257232666
(439) DESCRIBE `sailingdates` 0.0016391277313232
(440) DESCRIBE `ports` 0.0021030902862549
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00048589706420898
(442) DESCRIBE `ports` 0.001924991607666
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00039815902709961
(444) DESCRIBE `ports` 0.0019230842590332
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00045299530029297
(446) DESCRIBE `ports` 0.0021469593048096
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00042009353637695
(448) DESCRIBE `ports` 0.0018219947814941
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0004279613494873
(450) DESCRIBE `ports` 0.0020921230316162
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00044798851013184
(452) DESCRIBE `ports` 0.0023219585418701
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00043201446533203
(454) DESCRIBE `ports` 0.0019979476928711
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00039410591125488
(456) DESCRIBE `ports` 0.0021700859069824
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00043606758117676
(458) DESCRIBE `ports` 0.0019841194152832
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00037503242492676
(460) DESCRIBE `ports` 0.0023930072784424
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00043296813964844
(462) DESCRIBE `ports` 0.0023009777069092
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038814544677734
(464) DESCRIBE `ports` 0.0026497840881348
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00049805641174316
(466) DESCRIBE `ports` 0.0024230480194092
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00041294097900391
(468) DESCRIBE `ports` 0.0025761127471924
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00044989585876465
(470) DESCRIBE `ports` 0.0024619102478027
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00044798851013184
(472) DESCRIBE `ports` 0.002551794052124
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00055694580078125
(474) DESCRIBE `ports` 0.0026729106903076
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00044894218444824
(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.005702018737793
(477) DESCRIBE `avid_specials` 0.0025849342346191
(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.0013208389282227
(479) DESCRIBE `cruiselines` 0.0026919841766357
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0004580020904541
(481) DESCRIBE `orchid_image` 0.002094030380249
(482) DESCRIBE `cruiselines` 0.0029280185699463
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041007995605469
(484) DESCRIBE `cruises` 0.0042300224304199
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82126') 0.00046682357788086
(486) DESCRIBE `ships` 0.0040850639343262
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00070405006408691
(488) DESCRIBE `ships` 0.0056140422821045
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00054502487182617
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052022933959961
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050592422485352
(492) DESCRIBE `itineraries` 0.0027711391448975
(493) DESCRIBE `ports` 0.003511905670166
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00062417984008789
(495) DESCRIBE `ports` 0.003180980682373
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00064301490783691
(497) DESCRIBE `ports` 0.0026240348815918
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00056195259094238
(499) DESCRIBE `sailingdates` 0.002310037612915
(500) DESCRIBE `ports` 0.0028581619262695
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00060582160949707
(502) DESCRIBE `ports` 0.0029799938201904
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00055694580078125
(504) DESCRIBE `ports` 0.0021688938140869
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00045490264892578
(506) DESCRIBE `ports` 0.0018770694732666
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00039100646972656
(508) DESCRIBE `ports` 0.0021660327911377
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00042891502380371
(510) DESCRIBE `ports` 0.0026450157165527
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00041389465332031
(512) DESCRIBE `ports` 0.0029599666595459
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00047016143798828
(514) DESCRIBE `ports` 0.0022079944610596
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00040388107299805
(516) DESCRIBE `ports` 0.0026130676269531
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00044703483581543
(518) DESCRIBE `ports` 0.0025310516357422
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00038313865661621
(520) DESCRIBE `ports` 0.0020408630371094
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00053596496582031
(522) DESCRIBE `ports` 0.0033309459686279
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00055503845214844
(524) DESCRIBE `ports` 0.0029890537261963
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00042104721069336
(526) DESCRIBE `ports` 0.0019590854644775
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00041294097900391
(528) DESCRIBE `ports` 0.0018608570098877
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00044894218444824
(530) DESCRIBE `ports` 0.0018529891967773
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00037097930908203
(532) DESCRIBE `ports` 0.0019569396972656
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040793418884277
(534) DESCRIBE `ports` 0.002155065536499
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00043797492980957
(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.0058879852294922
(537) DESCRIBE `avid_specials` 0.0026149749755859
(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.0012221336364746
(539) DESCRIBE `cruiselines` 0.0028469562530518
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00051593780517578
(541) DESCRIBE `orchid_image` 0.029295921325684
(542) DESCRIBE `cruiselines` 0.0041878223419189
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00052499771118164
(544) DESCRIBE `cruises` 0.0043420791625977
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45864') 0.00046682357788086
(546) DESCRIBE `ships` 0.0040509700775146
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00057721138000488
(548) DESCRIBE `ships` 0.0038080215454102
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00045299530029297
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036978721618652
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036287307739258
(552) DESCRIBE `itineraries` 0.0024709701538086
(553) DESCRIBE `ports` 0.0026330947875977
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00052905082702637
(555) DESCRIBE `ports` 0.0019979476928711
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00041294097900391
(557) DESCRIBE `ports` 0.0020849704742432
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.0005040168762207
(559) DESCRIBE `sailingdates` 0.002655029296875
(560) DESCRIBE `ports` 0.0018539428710938
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00045299530029297
(562) DESCRIBE `ports` 0.0019419193267822
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00039291381835938
(564) DESCRIBE `ports` 0.0018868446350098
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00057220458984375
(566) DESCRIBE `ports` 0.0020449161529541
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00042295455932617
(568) DESCRIBE `ports` 0.0030109882354736
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00056600570678711
(570) DESCRIBE `ports` 0.0022001266479492
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00044608116149902
(572) DESCRIBE `ports` 0.0020651817321777
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00055813789367676
(574) DESCRIBE `ports` 0.0019521713256836
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00046610832214355
(576) DESCRIBE `ports` 0.0025548934936523
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00050187110900879
(578) DESCRIBE `ports` 0.0032799243927002
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00044918060302734
(580) DESCRIBE `ports` 0.002399206161499
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.0004420280456543
(582) DESCRIBE `ports` 0.0024161338806152
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00038409233093262
(584) DESCRIBE `ports` 0.002608060836792
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00043106079101562
(586) DESCRIBE `ports` 0.0024139881134033
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00047993659973145
(588) DESCRIBE `ports` 0.0024399757385254
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00051283836364746
(590) DESCRIBE `ports` 0.0024909973144531
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00043487548828125
(592) DESCRIBE `ports` 0.0025999546051025
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0004580020904541
(594) DESCRIBE `ports` 0.0026071071624756
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00040793418884277
(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.0051159858703613
(597) DESCRIBE `avid_specials` 0.0024049282073975
(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.0013449192047119
(599) DESCRIBE `cruiselines` 0.0029211044311523
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00060701370239258
(601) DESCRIBE `orchid_image` 0.0031158924102783
(602) DESCRIBE `cruiselines` 0.0027749538421631
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00040292739868164
(604) DESCRIBE `ships` 0.0038981437683105
(605) SELECT `ships`.* FROM `ships` WHERE (id IN ('1526', '1013', '1163', '1791')) ORDER BY FIND_IN_SET(id, '1526,1013,1163,1791') 0.0015759468078613
(606) DESCRIBE `cruisetypes` 0.0018889904022217
(607) DESCRIBE `destinations` 0.0028579235076904
(608) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.00082612037658691
(609) DESCRIBE `cruiselines` 0.0032188892364502
(610) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00050091743469238
(611) DESCRIBE `cruiselines` 0.0029079914093018
(612) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00046992301940918