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

Total elapsed time: 1.3743538856506

# Query Time
(1) connect 0.00559401512146
(2) DESCRIBE `cruises` 0.0064480304718018
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82172, 82063, 82124, 82125, 82171, 82171, 68831, 82064, 82123, 82126)) ORDER BY FIND_IN_SET(id, '82172,82063,82124,82125,82171,82171,68831,82064,82123,82126') 0.0047478675842285
(4) DESCRIBE `cruises` 0.006256103515625
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00067305564880371
(6) DESCRIBE `ships` 0.0060818195343018
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0012679100036621
(8) DESCRIBE `ships` 0.0054891109466553
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.0011210441589355
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00088000297546387
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00089788436889648
(12) DESCRIBE `itineraries` 0.0032308101654053
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82172') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014247894287109
(14) DESCRIBE `ports` 0.0030300617218018
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00065493583679199
(16) DESCRIBE `ports` 0.0030350685119629
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00078296661376953
(18) DESCRIBE `ports` 0.0027248859405518
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00058412551879883
(20) DESCRIBE `sailingdates` 0.0025920867919922
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82172') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013659000396729
(22) DESCRIBE `ports` 0.0047340393066406
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00069785118103027
(24) DESCRIBE `ports` 0.003471851348877
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0007929801940918
(26) DESCRIBE `ports` 0.0032129287719727
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0011091232299805
(28) DESCRIBE `ports` 0.0034270286560059
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00088810920715332
(30) DESCRIBE `ports` 0.0038120746612549
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00066590309143066
(32) DESCRIBE `ports` 0.0040469169616699
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0027000904083252
(34) DESCRIBE `ports` 0.004310131072998
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00071287155151367
(36) DESCRIBE `ports` 0.0034739971160889
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00082683563232422
(38) DESCRIBE `ports` 0.02402400970459
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.000885009765625
(40) DESCRIBE `ports` 0.0030350685119629
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00059199333190918
(42) DESCRIBE `ports` 0.0031130313873291
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00066280364990234
(44) DESCRIBE `ports` 0.0025250911712646
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00060796737670898
(46) DESCRIBE `ports` 0.0030040740966797
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00064611434936523
(48) DESCRIBE `ports` 0.0028760433197021
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00056600570678711
(50) DESCRIBE `ports` 0.0027000904083252
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00057411193847656
(52) DESCRIBE `ports` 0.0031239986419678
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00057005882263184
(54) DESCRIBE `ports` 0.0042300224304199
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00070405006408691
(56) DESCRIBE `ports` 0.0038409233093262
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.002068042755127
(58) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82172') AND (sailingdate >= '2020-02-01') 0.025589942932129
(59) DESCRIBE `avid_specials` 0.0029439926147461
(60) 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.0024819374084473
(61) DESCRIBE `cruiselines` 0.0078859329223633
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00067615509033203
(63) DESCRIBE `orchid_image` 0.0048980712890625
(64) DESCRIBE `cruiselines` 0.0057408809661865
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00063490867614746
(66) DESCRIBE `cruises` 0.0064108371734619
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.00067996978759766
(68) DESCRIBE `ships` 0.018799066543579
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00084900856018066
(70) DESCRIBE `ships` 0.0055339336395264
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00071191787719727
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050997734069824
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049901008605957
(74) DESCRIBE `itineraries` 0.0027351379394531
(75) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82063') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011270046234131
(76) DESCRIBE `ports` 0.002781867980957
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00059819221496582
(78) DESCRIBE `ports` 0.0025789737701416
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00060105323791504
(80) DESCRIBE `ports` 0.0025351047515869
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00060486793518066
(82) DESCRIBE `sailingdates` 0.0022931098937988
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82063') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001410961151123
(84) DESCRIBE `ports` 0.0046889781951904
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0011260509490967
(86) DESCRIBE `ports` 0.0033950805664062
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0040290355682373
(88) DESCRIBE `ports` 0.0042710304260254
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00061988830566406
(90) DESCRIBE `ports` 0.002795934677124
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00061893463134766
(92) DESCRIBE `ports` 0.0025970935821533
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00093793869018555
(94) DESCRIBE `ports` 0.0054550170898438
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00073409080505371
(96) DESCRIBE `ports` 0.0029668807983398
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0025861263275146
(98) DESCRIBE `ports` 0.0035030841827393
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00062990188598633
(100) DESCRIBE `ports` 0.0042779445648193
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00079083442687988
(102) DESCRIBE `ports` 0.0032799243927002
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.001244068145752
(104) DESCRIBE `ports` 0.0043787956237793
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00090408325195312
(106) DESCRIBE `ports` 0.0030200481414795
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00060415267944336
(108) DESCRIBE `ports` 0.0034730434417725
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00079798698425293
(110) DESCRIBE `ports` 0.0032260417938232
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00068879127502441
(112) DESCRIBE `ports` 0.0030450820922852
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00067710876464844
(114) DESCRIBE `ports` 0.0027799606323242
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0007469654083252
(116) DESCRIBE `ports` 0.0025730133056641
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00071096420288086
(118) DESCRIBE `ports` 0.0035429000854492
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00066208839416504
(120) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82063') AND (sailingdate >= '2020-02-01') 0.01121711730957
(121) DESCRIBE `avid_specials` 0.0030839443206787
(122) 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.0034170150756836
(123) DESCRIBE `cruiselines` 0.0056910514831543
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0012321472167969
(125) DESCRIBE `orchid_image` 0.0044457912445068
(126) DESCRIBE `cruiselines` 0.0052931308746338
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00074887275695801
(128) DESCRIBE `cruises` 0.0099539756774902
(129) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00081300735473633
(130) DESCRIBE `ships` 0.0092101097106934
(131) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0008699893951416
(132) DESCRIBE `ships` 0.0076808929443359
(133) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0045418739318848
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0020148754119873
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0059638023376465
(136) DESCRIBE `itineraries` 0.003399133682251
(137) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82124') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0050358772277832
(138) DESCRIBE `ports` 0.0034961700439453
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0010199546813965
(140) DESCRIBE `ports` 0.0047829151153564
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00095701217651367
(142) DESCRIBE `ports` 0.0030698776245117
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00066304206848145
(144) DESCRIBE `sailingdates` 0.0026121139526367
(145) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82124') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010759830474854
(146) DESCRIBE `ports` 0.0033419132232666
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00058293342590332
(148) DESCRIBE `ports` 0.0022649765014648
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00074505805969238
(150) DESCRIBE `ports` 0.0027101039886475
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0007789134979248
(152) DESCRIBE `ports` 0.0027408599853516
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00063490867614746
(154) DESCRIBE `ports` 0.0023679733276367
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00064802169799805
(156) DESCRIBE `ports` 0.0026450157165527
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00059795379638672
(158) DESCRIBE `ports` 0.0025970935821533
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00063419342041016
(160) DESCRIBE `ports` 0.0027511119842529
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00066900253295898
(162) DESCRIBE `ports` 0.0024409294128418
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.0006248950958252
(164) DESCRIBE `ports` 0.0022709369659424
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00062012672424316
(166) DESCRIBE `ports` 0.0023050308227539
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00061583518981934
(168) DESCRIBE `ports` 0.0022571086883545
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00057291984558105
(170) DESCRIBE `ports` 0.0023159980773926
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00063896179199219
(172) DESCRIBE `ports` 0.0022637844085693
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00055408477783203
(174) DESCRIBE `ports` 0.0022339820861816
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00063109397888184
(176) DESCRIBE `ports` 0.0022878646850586
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00056290626525879
(178) DESCRIBE `ports` 0.0022778511047363
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00068497657775879
(180) DESCRIBE `ports` 0.0024969577789307
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00058603286743164
(182) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82124') AND (sailingdate >= '2020-02-01') 0.0071609020233154
(183) DESCRIBE `avid_specials` 0.0023198127746582
(184) 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.0014340877532959
(185) DESCRIBE `cruiselines` 0.0049178600311279
(186) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.000701904296875
(187) DESCRIBE `orchid_image` 0.0031189918518066
(188) DESCRIBE `cruiselines` 0.0038449764251709
(189) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00065493583679199
(190) DESCRIBE `cruises` 0.005295991897583
(191) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00071096420288086
(192) DESCRIBE `ships` 0.0055711269378662
(193) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00081515312194824
(194) DESCRIBE `ships` 0.0047769546508789
(195) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00062298774719238
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043010711669922
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042080879211426
(198) DESCRIBE `itineraries` 0.0026600360870361
(199) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82125') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001201868057251
(200) DESCRIBE `ports` 0.0026829242706299
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00076198577880859
(202) DESCRIBE `ports` 0.0043778419494629
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00070285797119141
(204) DESCRIBE `ports` 0.0024960041046143
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00053882598876953
(206) DESCRIBE `sailingdates` 0.0021820068359375
(207) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82125') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093793869018555
(208) DESCRIBE `ports` 0.002683162689209
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00058102607727051
(210) DESCRIBE `ports` 0.0021910667419434
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00053501129150391
(212) DESCRIBE `ports` 0.0024459362030029
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00061702728271484
(214) DESCRIBE `ports` 0.0025351047515869
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00063991546630859
(216) DESCRIBE `ports` 0.0025789737701416
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00047612190246582
(218) DESCRIBE `ports` 0.0018279552459717
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00049710273742676
(220) DESCRIBE `ports` 0.0025031566619873
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00075912475585938
(222) DESCRIBE `ports` 0.0024640560150146
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00057792663574219
(224) DESCRIBE `ports` 0.0024838447570801
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00057792663574219
(226) DESCRIBE `ports` 0.0024590492248535
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00052690505981445
(228) DESCRIBE `ports` 0.0023279190063477
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0005488395690918
(230) DESCRIBE `ports` 0.0023019313812256
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00043606758117676
(232) DESCRIBE `ports` 0.0019259452819824
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00054287910461426
(234) DESCRIBE `ports` 0.0018439292907715
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00042581558227539
(236) DESCRIBE `ports` 0.0019490718841553
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00043201446533203
(238) DESCRIBE `ports` 0.0021390914916992
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00043797492980957
(240) DESCRIBE `ports` 0.0019021034240723
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00046801567077637
(242) DESCRIBE `ports` 0.001903772354126
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00050497055053711
(244) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82125') AND (sailingdate >= '2020-02-01') 0.0056579113006592
(245) DESCRIBE `avid_specials` 0.0020079612731934
(246) 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.0013518333435059
(247) DESCRIBE `cruiselines` 0.003154993057251
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00047492980957031
(249) DESCRIBE `orchid_image` 0.0024948120117188
(250) DESCRIBE `cruiselines` 0.0027148723602295
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00055408477783203
(252) DESCRIBE `specials` 0.0070450305938721
(253) SELECT `specials`.* FROM `specials` WHERE (id = '1612734') AND (specials.orchid_available = 1) LIMIT 1 0.00088405609130859
(254) DESCRIBE `specials` 0.0057849884033203
(255) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1612734') 0.00063204765319824
(256) DESCRIBE `ships` 0.0043480396270752
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00065803527832031
(258) DESCRIBE `ships` 0.0042989253997803
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00059199333190918
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046491622924805
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050115585327148
(262) DESCRIBE `itineraries` 0.0024909973144531
(263) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82171') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014111995697021
(264) DESCRIBE `ports` 0.0029439926147461
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00061988830566406
(266) DESCRIBE `ports` 0.0019750595092773
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00054693222045898
(268) DESCRIBE `ports` 0.0018949508666992
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00056815147399902
(270) DESCRIBE `specialsailingdates` 0.0020530223846436
(271) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1612734') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00090408325195312
(272) DESCRIBE `sailingdates` 0.0018630027770996
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 516367))) 0.00043702125549316
(274) DESCRIBE `ports` 0.0019171237945557
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043296813964844
(276) DESCRIBE `ports` 0.002418041229248
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00051188468933105
(278) DESCRIBE `ports` 0.0024349689483643
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0005190372467041
(280) DESCRIBE `ports` 0.0023410320281982
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00064802169799805
(282) DESCRIBE `ports` 0.0026299953460693
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00059199333190918
(284) DESCRIBE `ports` 0.002485990524292
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00041508674621582
(286) DESCRIBE `ports` 0.0018730163574219
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00047612190246582
(288) DESCRIBE `ports` 0.0023419857025146
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00062799453735352
(290) DESCRIBE `ports` 0.0024900436401367
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00048708915710449
(292) DESCRIBE `ports` 0.0027198791503906
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00054097175598145
(294) DESCRIBE `ports` 0.0024628639221191
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00064396858215332
(296) DESCRIBE `ports` 0.0027060508728027
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00053691864013672
(298) DESCRIBE `ports` 0.0024399757385254
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00049495697021484
(300) DESCRIBE `ports` 0.0022261142730713
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00055599212646484
(302) DESCRIBE `ports` 0.0024170875549316
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00072598457336426
(304) DESCRIBE `ports` 0.0024778842926025
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00050806999206543
(306) DESCRIBE `ports` 0.0024549961090088
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0005650520324707
(308) DESCRIBE `ports` 0.0026140213012695
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00056099891662598
(310) DESCRIBE `cruises` 0.0048160552978516
(311) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82171))) 0.00078797340393066
(312) DESCRIBE `avid_specials` 0.0024919509887695
(313) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1612734 and class = 'Special') OR (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.0024127960205078
(314) DESCRIBE `cruiselines` 0.0039470195770264
(315) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00063395500183105
(316) DESCRIBE `orchid_image` 0.0030159950256348
(317) DESCRIBE `cruiselines` 0.0032761096954346
(318) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00051307678222656
(319) DESCRIBE `cruises` 0.0039889812469482
(320) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.00048995018005371
(321) DESCRIBE `ships` 0.0044469833374023
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00066399574279785
(323) DESCRIBE `ships` 0.0041129589080811
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0005648136138916
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043392181396484
(327) DESCRIBE `itineraries` 0.0028848648071289
(328) DESCRIBE `ports` 0.0026679039001465
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00061202049255371
(330) DESCRIBE `ports` 0.002392053604126
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00057101249694824
(332) DESCRIBE `ports` 0.00242018699646
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00052022933959961
(334) DESCRIBE `sailingdates` 0.0018410682678223
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82171') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010159015655518
(336) DESCRIBE `ports` 0.0024278163909912
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00043487548828125
(338) DESCRIBE `ports` 0.0020852088928223
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00038599967956543
(340) DESCRIBE `ports` 0.0023319721221924
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00048208236694336
(342) DESCRIBE `ports` 0.0018081665039062
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00047087669372559
(344) DESCRIBE `ports` 0.0018429756164551
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00041294097900391
(346) DESCRIBE `ports` 0.0020880699157715
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00037217140197754
(348) DESCRIBE `ports` 0.0023529529571533
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0006260871887207
(350) DESCRIBE `ports` 0.0028269290924072
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0005648136138916
(352) DESCRIBE `ports` 0.0026929378509521
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00066590309143066
(354) DESCRIBE `ports` 0.0023500919342041
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00041913986206055
(356) DESCRIBE `ports` 0.0024600028991699
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00044798851013184
(358) DESCRIBE `ports` 0.0027308464050293
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00040698051452637
(360) DESCRIBE `ports` 0.001884937286377
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0004570484161377
(362) DESCRIBE `ports` 0.0021557807922363
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00059008598327637
(364) DESCRIBE `ports` 0.0025498867034912
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00068116188049316
(366) DESCRIBE `ports` 0.0022730827331543
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00057005882263184
(368) DESCRIBE `ports` 0.0024170875549316
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00053310394287109
(370) DESCRIBE `ports` 0.0024619102478027
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00064897537231445
(372) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82171') AND (sailingdate >= '2020-02-01') 0.011131048202515
(373) DESCRIBE `avid_specials` 0.0026509761810303
(374) 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.002418041229248
(375) DESCRIBE `cruiselines` 0.0041570663452148
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0007789134979248
(377) DESCRIBE `orchid_image` 0.003093957901001
(378) DESCRIBE `cruiselines` 0.0033559799194336
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00054383277893066
(380) DESCRIBE `cruises` 0.0045979022979736
(381) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00057888031005859
(382) DESCRIBE `ships` 0.0046939849853516
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00070500373840332
(384) DESCRIBE `ships` 0.0049901008605957
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00069093704223633
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005040168762207
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054216384887695
(388) DESCRIBE `itineraries` 0.0023250579833984
(389) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68831') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010700225830078
(390) DESCRIBE `ports` 0.0025379657745361
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00060200691223145
(392) DESCRIBE `ports` 0.002377986907959
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0006260871887207
(394) DESCRIBE `ports` 0.0024800300598145
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00059795379638672
(396) DESCRIBE `sailingdates` 0.0022749900817871
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68831') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014450550079346
(398) DESCRIBE `ports` 0.0031578540802002
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00066995620727539
(400) DESCRIBE `ports` 0.0024650096893311
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00052285194396973
(402) DESCRIBE `ports` 0.002453088760376
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0005640983581543
(404) DESCRIBE `ports` 0.0025629997253418
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00054097175598145
(406) DESCRIBE `ports` 0.0025060176849365
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00058889389038086
(408) DESCRIBE `ports` 0.0026111602783203
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00054812431335449
(410) DESCRIBE `ports` 0.0025608539581299
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00088906288146973
(412) DESCRIBE `ports` 0.0029661655426025
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.000823974609375
(414) DESCRIBE `ports` 0.0032520294189453
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00086307525634766
(416) DESCRIBE `ports` 0.0029160976409912
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00059413909912109
(418) DESCRIBE `ports` 0.0026171207427979
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0005650520324707
(420) DESCRIBE `ports` 0.0023460388183594
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00062084197998047
(422) DESCRIBE `ports` 0.0023670196533203
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00066494941711426
(424) DESCRIBE `ports` 0.0026531219482422
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00063896179199219
(426) DESCRIBE `ports` 0.0021350383758545
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00059318542480469
(428) DESCRIBE `ports` 0.0026519298553467
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00059103965759277
(430) DESCRIBE `ports` 0.0023949146270752
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0006411075592041
(432) DESCRIBE `ports` 0.0026490688323975
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00062394142150879
(434) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2020-02-01') 0.0090789794921875
(435) DESCRIBE `avid_specials` 0.00242018699646
(436) 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.002169132232666
(437) DESCRIBE `cruiselines` 0.0036690235137939
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00070905685424805
(439) DESCRIBE `orchid_image` 0.0028572082519531
(440) DESCRIBE `cruiselines` 0.0035550594329834
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00058603286743164
(442) DESCRIBE `cruises` 0.0045418739318848
(443) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.000701904296875
(444) DESCRIBE `ships` 0.0044779777526855
(445) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00067901611328125
(446) DESCRIBE `ships` 0.0049159526824951
(447) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00063896179199219
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042986869812012
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049400329589844
(450) DESCRIBE `itineraries` 0.0024449825286865
(451) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82064') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014359951019287
(452) DESCRIBE `ports` 0.0025510787963867
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00052094459533691
(454) DESCRIBE `ports` 0.0019290447235107
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040888786315918
(456) DESCRIBE `ports` 0.0019419193267822
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003960132598877
(458) DESCRIBE `sailingdates` 0.0021588802337646
(459) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82064') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0008089542388916
(460) DESCRIBE `ports` 0.0023539066314697
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00049686431884766
(462) DESCRIBE `ports` 0.0023338794708252
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00041413307189941
(464) DESCRIBE `ports` 0.0020761489868164
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00054407119750977
(466) DESCRIBE `ports` 0.002446174621582
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00063204765319824
(468) DESCRIBE `ports` 0.0022170543670654
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0004730224609375
(470) DESCRIBE `ports` 0.0027248859405518
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00064802169799805
(472) DESCRIBE `ports` 0.0027530193328857
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00065994262695312
(474) DESCRIBE `ports` 0.002918004989624
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00055384635925293
(476) DESCRIBE `ports` 0.0027999877929688
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00082302093505859
(478) DESCRIBE `ports` 0.0028519630432129
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00066518783569336
(480) DESCRIBE `ports` 0.0025367736816406
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00050091743469238
(482) DESCRIBE `ports` 0.0026140213012695
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00052905082702637
(484) DESCRIBE `ports` 0.0020878314971924
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00061416625976562
(486) DESCRIBE `ports` 0.002716064453125
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00057792663574219
(488) DESCRIBE `ports` 0.0030560493469238
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00088286399841309
(490) DESCRIBE `ports` 0.0028550624847412
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0006108283996582
(492) DESCRIBE `ports` 0.0026071071624756
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00065803527832031
(494) DESCRIBE `ports` 0.0026509761810303
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00058197975158691
(496) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82064') AND (sailingdate >= '2020-02-01') 0.010731220245361
(497) DESCRIBE `avid_specials` 0.0025539398193359
(498) 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.0023279190063477
(499) DESCRIBE `cruiselines` 0.0037200450897217
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0006859302520752
(501) DESCRIBE `orchid_image` 0.0028409957885742
(502) DESCRIBE `cruiselines` 0.0035881996154785
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00057220458984375
(504) DESCRIBE `cruises` 0.0057830810546875
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82123') 0.00063395500183105
(506) DESCRIBE `ships` 0.0054881572723389
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00091981887817383
(508) DESCRIBE `ships` 0.0054469108581543
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00060391426086426
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046586990356445
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044703483581543
(512) DESCRIBE `itineraries` 0.0026590824127197
(513) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82123') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012238025665283
(514) DESCRIBE `ports` 0.0030529499053955
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00071501731872559
(516) DESCRIBE `ports` 0.0029110908508301
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00076603889465332
(518) DESCRIBE `ports` 0.0023279190063477
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00058102607727051
(520) DESCRIBE `sailingdates` 0.002424955368042
(521) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82123') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013210773468018
(522) DESCRIBE `ports` 0.0028159618377686
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00063705444335938
(524) DESCRIBE `ports` 0.002363920211792
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00057005882263184
(526) DESCRIBE `ports` 0.0024280548095703
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00054383277893066
(528) DESCRIBE `ports` 0.002251148223877
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00053191184997559
(530) DESCRIBE `ports` 0.0024118423461914
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00046992301940918
(532) DESCRIBE `ports` 0.0024199485778809
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.0005500316619873
(534) DESCRIBE `ports` 0.0024039745330811
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00050878524780273
(536) DESCRIBE `ports` 0.0022909641265869
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00042390823364258
(538) DESCRIBE `ports` 0.0020899772644043
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00067901611328125
(540) DESCRIBE `ports` 0.0023961067199707
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00041484832763672
(542) DESCRIBE `ports` 0.0019969940185547
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00056099891662598
(544) DESCRIBE `ports` 0.0021240711212158
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00061988830566406
(546) DESCRIBE `ports` 0.0024847984313965
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00074410438537598
(548) DESCRIBE `ports` 0.0020449161529541
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.0005030632019043
(550) DESCRIBE `ports` 0.0021669864654541
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00065302848815918
(552) DESCRIBE `ports` 0.0025730133056641
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00058197975158691
(554) DESCRIBE `ports` 0.002626895904541
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00066399574279785
(556) DESCRIBE `ports` 0.0026178359985352
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.0005640983581543
(558) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82123') AND (sailingdate >= '2020-02-01') 0.010535001754761
(559) DESCRIBE `avid_specials` 0.0025179386138916
(560) 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.0019350051879883
(561) DESCRIBE `cruiselines` 0.0037660598754883
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00076603889465332
(563) DESCRIBE `orchid_image` 0.0028510093688965
(564) DESCRIBE `cruiselines` 0.0039570331573486
(565) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00050997734069824
(566) DESCRIBE `cruises` 0.0043728351593018
(567) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82126') 0.00048398971557617
(568) DESCRIBE `ships` 0.0041079521179199
(569) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00077414512634277
(570) DESCRIBE `ships` 0.0059540271759033
(571) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00069808959960938
(572) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051188468933105
(573) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047397613525391
(574) DESCRIBE `itineraries` 0.0028150081634521
(575) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '82126') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008699893951416
(576) DESCRIBE `ports` 0.0025279521942139
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00058507919311523
(578) DESCRIBE `ports` 0.0024278163909912
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00049901008605957
(580) DESCRIBE `ports` 0.0022709369659424
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00069093704223633
(582) DESCRIBE `sailingdates` 0.002187967300415
(583) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '82126') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.000946044921875
(584) DESCRIBE `ports` 0.0029089450836182
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00054407119750977
(586) DESCRIBE `ports` 0.0020899772644043
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00049901008605957
(588) DESCRIBE `ports` 0.0022389888763428
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00050187110900879
(590) DESCRIBE `ports` 0.002579927444458
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00050210952758789
(592) DESCRIBE `ports` 0.0021789073944092
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00047397613525391
(594) DESCRIBE `ports` 0.0021579265594482
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00054502487182617
(596) DESCRIBE `ports` 0.0020310878753662
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00046682357788086
(598) DESCRIBE `ports` 0.0020558834075928
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00046610832214355
(600) DESCRIBE `ports` 0.0019800662994385
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00052714347839355
(602) DESCRIBE `ports` 0.0018129348754883
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00052094459533691
(604) DESCRIBE `ports` 0.0019879341125488
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00043296813964844
(606) DESCRIBE `ports` 0.0018761157989502
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00039100646972656
(608) DESCRIBE `ports` 0.0018219947814941
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00043797492980957
(610) DESCRIBE `ports` 0.0020930767059326
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00047993659973145
(612) DESCRIBE `ports` 0.0025250911712646
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00060296058654785
(614) DESCRIBE `ports` 0.0026450157165527
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00066018104553223
(616) DESCRIBE `ports` 0.0028338432312012
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00080180168151855
(618) DESCRIBE `ports` 0.0026450157165527
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00050711631774902
(620) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82126') AND (sailingdate >= '2020-02-01') 0.0061769485473633
(621) DESCRIBE `avid_specials` 0.0024387836456299
(622) 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.0018889904022217
(623) DESCRIBE `cruiselines` 0.0034708976745605
(624) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00078296661376953
(625) DESCRIBE `orchid_image` 0.0029590129852295
(626) DESCRIBE `cruiselines` 0.0037882328033447
(627) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00065088272094727
(628) DESCRIBE `ships` 0.0044341087341309
(629) SELECT `ships`.* FROM `ships` WHERE (id IN ('1013', '1526', '1163', '1791')) ORDER BY FIND_IN_SET(id, '1013,1526,1163,1791') 0.0015718936920166
(630) DESCRIBE `cruisetypes` 0.0017659664154053
(631) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '212') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.038589954376221
(632) DESCRIBE `destinations` 0.0042521953582764
(633) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.0010700225830078
(634) DESCRIBE `cruiselines` 0.0038120746612549
(635) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00070309638977051
(636) DESCRIBE `cruiselines` 0.0037670135498047
(637) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00063109397888184