or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.76953220367432

# Query Time
(1) connect 0.0015771389007568
(2) DESCRIBE `cruises` 0.0029928684234619
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66772, 74667, 66749, 68831, 78519, 52324, 74697, 74713, 74713, 52324)) ORDER BY FIND_IN_SET(id, '66772,74667,66749,68831,78519,52324,74697,74713,74713,52324') 0.0015408992767334
(4) DESCRIBE `cruises` 0.0024559497833252
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66772') 0.00029802322387695
(6) DESCRIBE `ships` 0.0024580955505371
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00043797492980957
(8) DESCRIBE `ships` 0.0023839473724365
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00028800964355469
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024318695068359
(12) DESCRIBE `itineraries` 0.0012011528015137
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66772') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082516670227051
(14) DESCRIBE `ports` 0.001323938369751
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029897689819336
(16) DESCRIBE `ports` 0.0012319087982178
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031805038452148
(18) DESCRIBE `ports` 0.001270055770874
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028800964355469
(20) DESCRIBE `sailingdates` 0.0010828971862793
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66772') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005950927734375
(22) DESCRIBE `ports` 0.0012359619140625
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003049373626709
(24) DESCRIBE `ports` 0.001431941986084
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003349781036377
(26) DESCRIBE `ports` 0.0015850067138672
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031018257141113
(28) DESCRIBE `ports` 0.00124192237854
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026392936706543
(30) DESCRIBE `ports` 0.0012269020080566
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00027990341186523
(32) DESCRIBE `ports` 0.0012290477752686
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026321411132812
(34) DESCRIBE `ports` 0.0012590885162354
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00028705596923828
(36) DESCRIBE `ports` 0.0012221336364746
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00026202201843262
(38) DESCRIBE `ports` 0.0012719631195068
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00034809112548828
(40) DESCRIBE `ports` 0.001594066619873
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00027108192443848
(42) DESCRIBE `ports` 0.0013470649719238
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029802322387695
(44) DESCRIBE `ports` 0.0013120174407959
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00032186508178711
(46) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66772') AND (sailingdate >= '2019-01-01') 0.0073790550231934
(47) DESCRIBE `avid_specials` 0.0015699863433838
(48) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66772 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.0012061595916748
(49) DESCRIBE `cruiselines` 0.0018291473388672
(50) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00031781196594238
(51) DESCRIBE `orchid_image` 0.0013949871063232
(52) DESCRIBE `cruiselines` 0.0017919540405273
(53) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00028085708618164
(54) DESCRIBE `cruises` 0.0026829242706299
(55) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74667') 0.00029802322387695
(56) DESCRIBE `ships` 0.0025179386138916
(57) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00049901008605957
(58) DESCRIBE `ships` 0.0024881362915039
(59) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00030398368835449
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0010340213775635
(62) DESCRIBE `itineraries` 0.00073695182800293
(63) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74667') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005650520324707
(64) DESCRIBE `ports` 0.0013630390167236
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030183792114258
(66) DESCRIBE `ports` 0.0016379356384277
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00037407875061035
(68) DESCRIBE `ports` 0.0015690326690674
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040102005004883
(70) DESCRIBE `sailingdates` 0.0011119842529297
(71) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74667') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067496299743652
(72) DESCRIBE `ports` 0.0014820098876953
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032305717468262
(74) DESCRIBE `ports` 0.0014171600341797
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027298927307129
(76) DESCRIBE `ports` 0.0012881755828857
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00029897689819336
(78) DESCRIBE `ports` 0.0013229846954346
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029182434082031
(80) DESCRIBE `ports` 0.0014150142669678
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00034403800964355
(82) DESCRIBE `ports` 0.0016970634460449
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0010089874267578
(84) DESCRIBE `ports` 0.00087809562683105
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00032496452331543
(86) DESCRIBE `ports` 0.0015170574188232
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0002748966217041
(88) DESCRIBE `ports` 0.0014369487762451
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.0012679100036621
(90) DESCRIBE `ports` 0.0015850067138672
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00034189224243164
(92) DESCRIBE `ports` 0.0015549659729004
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00035691261291504
(94) DESCRIBE `ports` 0.0015490055084229
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00032210350036621
(96) DESCRIBE `ports` 0.0012779235839844
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029182434082031
(98) DESCRIBE `ports` 0.0012760162353516
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026702880859375
(100) DESCRIBE `ports` 0.0012331008911133
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4161))) 0.00028300285339355
(102) DESCRIBE `ports` 0.001262903213501
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4161') 0.00026488304138184
(104) DESCRIBE `ports` 0.0012338161468506
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00029301643371582
(106) DESCRIBE `ports` 0.0013411045074463
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003349781036377
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74667') AND (sailingdate >= '2019-01-01') 0.0050139427185059
(109) DESCRIBE `avid_specials` 0.0013461112976074
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74667 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.0011200904846191
(111) DESCRIBE `cruiselines` 0.0019159317016602
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034785270690918
(113) DESCRIBE `orchid_image` 0.0016460418701172
(114) DESCRIBE `cruiselines` 0.0018010139465332
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00030994415283203
(116) DESCRIBE `cruises` 0.0026609897613525
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66749') 0.00038003921508789
(118) DESCRIBE `ships` 0.0035130977630615
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0003969669342041
(120) DESCRIBE `ships` 0.0026800632476807
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00031304359436035
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027585029602051
(124) DESCRIBE `itineraries` 0.0012691020965576
(125) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66749') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058794021606445
(126) DESCRIBE `ports` 0.0013298988342285
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00031614303588867
(128) DESCRIBE `ports` 0.0012621879577637
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00028800964355469
(130) DESCRIBE `ports` 0.0012779235839844
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027608871459961
(132) DESCRIBE `sailingdates` 0.0010979175567627
(133) DESCRIBE `ports` 0.0015180110931396
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030684471130371
(135) DESCRIBE `ports` 0.0012509822845459
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027108192443848
(137) DESCRIBE `ports` 0.0012931823730469
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00036096572875977
(139) DESCRIBE `ports` 0.0016927719116211
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003659725189209
(141) DESCRIBE `ports` 0.0016820430755615
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2910))) 0.00037789344787598
(143) DESCRIBE `ports` 0.0017449855804443
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2910') 0.00033402442932129
(145) DESCRIBE `ports` 0.0013229846954346
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00037717819213867
(147) DESCRIBE `ports` 0.0014011859893799
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00029802322387695
(149) DESCRIBE `ports` 0.0015010833740234
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00040316581726074
(151) DESCRIBE `ports` 0.0014691352844238
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00036096572875977
(153) DESCRIBE `ports` 0.0016019344329834
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00034594535827637
(155) DESCRIBE `ports` 0.001539945602417
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00031709671020508
(157) DESCRIBE `ports` 0.0015459060668945
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00044894218444824
(159) DESCRIBE `ports` 0.0017769336700439
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00037407875061035
(161) DESCRIBE `ports` 0.0018270015716553
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00039982795715332
(163) DESCRIBE `ports` 0.0017871856689453
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00034499168395996
(165) DESCRIBE `ports` 0.0017619132995605
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043797492980957
(167) DESCRIBE `ports` 0.0017549991607666
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029397010803223
(169) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66749') AND (sailingdate >= '2019-01-01') 0.0050129890441895
(170) DESCRIBE `avid_specials` 0.001643180847168
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66749 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.00058889389038086
(172) DESCRIBE `cruiselines` 0.0024039745330811
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0001988410949707
(174) DESCRIBE `orchid_image` 0.0017070770263672
(175) DESCRIBE `cruiselines` 0.0030720233917236
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00038909912109375
(177) DESCRIBE `cruises` 0.0028450489044189
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00041913986206055
(179) DESCRIBE `ships` 0.0041229724884033
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00037288665771484
(181) DESCRIBE `ships` 0.0026829242706299
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00032496452331543
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(185) DESCRIBE `itineraries` 0.00187087059021
(186) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68831') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008549690246582
(187) DESCRIBE `ports` 0.0019509792327881
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00046777725219727
(189) DESCRIBE `ports` 0.0018019676208496
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043010711669922
(191) DESCRIBE `ports` 0.0018589496612549
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040197372436523
(193) DESCRIBE `sailingdates` 0.0016829967498779
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68831') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010280609130859
(195) DESCRIBE `ports` 0.0016989707946777
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044488906860352
(197) DESCRIBE `ports` 0.00154709815979
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031208992004395
(199) DESCRIBE `ports` 0.0014901161193848
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00035405158996582
(201) DESCRIBE `ports` 0.0010030269622803
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035715103149414
(203) DESCRIBE `ports` 0.00080990791320801
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00038695335388184
(205) DESCRIBE `ports` 0.0017340183258057
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00037789344787598
(207) DESCRIBE `ports` 0.0026450157165527
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00034403800964355
(209) DESCRIBE `ports` 0.0016860961914062
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00035405158996582
(211) DESCRIBE `ports` 0.001680850982666
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00038814544677734
(213) DESCRIBE `ports` 0.001655101776123
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00037384033203125
(215) DESCRIBE `ports` 0.0017011165618896
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00040793418884277
(217) DESCRIBE `ports` 0.0017499923706055
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00034999847412109
(219) DESCRIBE `ports` 0.0016651153564453
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00048685073852539
(221) DESCRIBE `ports` 0.0016779899597168
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00036501884460449
(223) DESCRIBE `ports` 0.0017328262329102
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00038909912109375
(225) DESCRIBE `ports` 0.0017709732055664
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00035405158996582
(227) DESCRIBE `ports` 0.0017528533935547
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041699409484863
(229) DESCRIBE `ports` 0.0017299652099609
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00037097930908203
(231) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2019-01-01') 0.0077829360961914
(232) DESCRIBE `avid_specials` 0.0018610954284668
(233) 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.0016779899597168
(234) DESCRIBE `cruiselines` 0.0025718212127686
(235) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0004570484161377
(236) DESCRIBE `orchid_image` 0.0020341873168945
(237) DESCRIBE `cruiselines` 0.0024960041046143
(238) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0003969669342041
(239) DESCRIBE `cruises` 0.0032460689544678
(240) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78519') 0.0003809928894043
(241) DESCRIBE `ships` 0.0034129619598389
(242) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00048494338989258
(243) DESCRIBE `ships` 0.0036191940307617
(244) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00044512748718262
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029802322387695
(247) DESCRIBE `itineraries` 0.0019268989562988
(248) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78519') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084996223449707
(249) DESCRIBE `ports` 0.0019412040710449
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044798851013184
(251) DESCRIBE `ports` 0.0017330646514893
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00038599967956543
(253) DESCRIBE `ports` 0.0017631053924561
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00040602684020996
(255) DESCRIBE `sailingdates` 0.0015449523925781
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78519') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082802772521973
(257) DESCRIBE `ports` 0.0019221305847168
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042605400085449
(259) DESCRIBE `ports` 0.0016970634460449
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00041484832763672
(261) DESCRIBE `ports` 0.0017459392547607
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00038790702819824
(263) DESCRIBE `ports` 0.001737117767334
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0003659725189209
(265) DESCRIBE `ports` 0.0025119781494141
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00040817260742188
(267) DESCRIBE `ports` 0.0016920566558838
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0
(269) DESCRIBE `ports` 0.0017061233520508
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00044488906860352
(271) DESCRIBE `ports` 0.0012071132659912
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00046896934509277
(273) DESCRIBE `ports` 0.0018720626831055
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00042581558227539
(275) DESCRIBE `ports` 0.0019769668579102
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0003960132598877
(277) DESCRIBE `ports` 0.0018219947814941
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0004420280456543
(279) DESCRIBE `ports` 0.0019400119781494
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00028705596923828
(281) DESCRIBE `ports` 0.0016629695892334
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00036978721618652
(283) DESCRIBE `ports` 0.0016388893127441
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003960132598877
(285) DESCRIBE `ports` 0.0019369125366211
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044083595275879
(287) DESCRIBE `ports` 0.0019321441650391
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00041103363037109
(289) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '78519') AND (sailingdate >= '2019-01-01') 0.0092458724975586
(290) DESCRIBE `avid_specials` 0.0018949508666992
(291) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78519 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.0010318756103516
(292) DESCRIBE `cruiselines` 0.0028181076049805
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00051283836364746
(294) DESCRIBE `orchid_image` 0.0021288394927979
(295) DESCRIBE `cruiselines` 0.0022048950195312
(296) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0
(297) DESCRIBE `cruises` 0.0033841133117676
(298) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52324') 0.00048398971557617
(299) DESCRIBE `ships` 0.0034921169281006
(300) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00060892105102539
(301) DESCRIBE `ships` 0.0034260749816895
(302) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00041699409484863
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(305) DESCRIBE `itineraries` 0.0016739368438721
(306) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52324') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081896781921387
(307) DESCRIBE `ports` 0.0018599033355713
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00042295455932617
(309) DESCRIBE `ports` 0.0016319751739502
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0
(311) DESCRIBE `ports` 0.0016868114471436
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00035309791564941
(313) DESCRIBE `sailingdates` 0.0014238357543945
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52324') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093197822570801
(315) DESCRIBE `ports` 0.0022721290588379
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00053691864013672
(317) DESCRIBE `ports` 0.0010180473327637
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0012621879577637
(319) DESCRIBE `ports` 0.0011568069458008
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00044584274291992
(321) DESCRIBE `ports` 0.0023419857025146
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00046801567077637
(323) DESCRIBE `ports` 0.0018851757049561
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00048303604125977
(325) DESCRIBE `ports` 0.0017900466918945
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00042486190795898
(327) DESCRIBE `ports` 0.0016751289367676
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 8.9168548583984E-5
(329) DESCRIBE `ports` 0.0015511512756348
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00038504600524902
(331) DESCRIBE `ports` 0.0018758773803711
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00051593780517578
(333) DESCRIBE `ports` 0.0018689632415771
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00046014785766602
(335) DESCRIBE `ports` 0.0017838478088379
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00066685676574707
(337) DESCRIBE `ports` 0.0019769668579102
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00044798851013184
(339) DESCRIBE `ports` 0.0019369125366211
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0004889965057373
(341) DESCRIBE `ports` 0.0021328926086426
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00040912628173828
(343) DESCRIBE `ports` 0.0017809867858887
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.0003819465637207
(345) DESCRIBE `ports` 0.0018138885498047
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00039911270141602
(347) DESCRIBE `ports` 0.0018861293792725
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00044894218444824
(349) DESCRIBE `ports` 0.0017900466918945
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00036191940307617
(351) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '52324') AND (sailingdate >= '2019-01-01') 0.0085968971252441
(352) DESCRIBE `avid_specials` 0.0018830299377441
(353) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52324 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.0017411708831787
(354) DESCRIBE `cruiselines` 0.0023272037506104
(355) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00058603286743164
(356) DESCRIBE `orchid_image` 0.001917839050293
(357) DESCRIBE `cruiselines` 0.0024640560150146
(358) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00047898292541504
(359) DESCRIBE `cruises` 0.0035610198974609
(360) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74697') 0.00043797492980957
(361) DESCRIBE `ships` 0.0034890174865723
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00053906440734863
(363) DESCRIBE `ships` 0.0035769939422607
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00048995018005371
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041604042053223
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(367) DESCRIBE `itineraries` 0.001884937286377
(368) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74697') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077199935913086
(369) DESCRIBE `ports` 0.0020098686218262
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00047397613525391
(371) DESCRIBE `ports` 0.001762866973877
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00041794776916504
(373) DESCRIBE `ports` 0.0017678737640381
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00042486190795898
(375) DESCRIBE `sailingdates` 0.0014858245849609
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74697') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077986717224121
(377) DESCRIBE `ports` 0.0020589828491211
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 2.8133392333984E-5
(379) DESCRIBE `ports` 0.0017600059509277
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00037908554077148
(381) DESCRIBE `ports` 0.0013968944549561
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00034689903259277
(383) DESCRIBE `ports` 0.0013930797576904
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00054812431335449
(385) DESCRIBE `ports` 0.0016250610351562
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00047087669372559
(387) DESCRIBE `ports` 0.0015640258789062
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00033783912658691
(389) DESCRIBE `ports` 0.0015199184417725
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003669261932373
(391) DESCRIBE `ports` 0.0014870166778564
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00042295455932617
(393) DESCRIBE `ports` 0.0016639232635498
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00047397613525391
(395) DESCRIBE `ports` 0.0026211738586426
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.0004727840423584
(397) DESCRIBE `ports` 0.0020568370819092
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00049281120300293
(399) DESCRIBE `ports` 0.0019128322601318
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00040984153747559
(401) DESCRIBE `ports` 0.0018870830535889
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00042510032653809
(403) DESCRIBE `ports` 0.0019369125366211
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.0003659725189209
(405) DESCRIBE `ports` 0.0022759437561035
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) 0.00050187110900879
(407) DESCRIBE `ports` 0.0021469593048096
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') 0.00047111511230469
(409) DESCRIBE `ports` 0.0020420551300049
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00055384635925293
(411) DESCRIBE `ports` 0.0017251968383789
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00046181678771973
(413) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74697') AND (sailingdate >= '2019-01-01') 0.0054061412811279
(414) DESCRIBE `avid_specials` 0.0015780925750732
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74697 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.0011730194091797
(416) DESCRIBE `cruiselines` 0.0024230480194092
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00055480003356934
(418) DESCRIBE `orchid_image` 0.0021388530731201
(419) DESCRIBE `cruiselines` 0.0028378963470459
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00052404403686523
(421) DESCRIBE `specials` 0.0056970119476318
(422) SELECT `specials`.* FROM `specials` WHERE (id = '1472318') AND (specials.orchid_available = 1) LIMIT 1 0.0011570453643799
(423) DESCRIBE `specials` 0.0056838989257812
(424) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1472318') 0.0006098747253418
(425) DESCRIBE `ships` 0.0040750503540039
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00065803527832031
(427) DESCRIBE `ships` 0.0033600330352783
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00053596496582031
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(431) DESCRIBE `itineraries` 0.0018570423126221
(432) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74713') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072002410888672
(433) DESCRIBE `ports` 0.0016770362854004
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042009353637695
(435) DESCRIBE `ports` 0.0014431476593018
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030398368835449
(437) DESCRIBE `ports` 0.0014989376068115
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028181076049805
(439) DESCRIBE `specialsailingdates` 0.0011498928070068
(440) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1472318') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00064206123352051
(441) DESCRIBE `sailingdates` 0.0016860961914062
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471699))) 0.00027799606323242
(443) DESCRIBE `ports` 0.0014190673828125
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00037002563476562
(445) DESCRIBE `ports` 0.0013489723205566
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037503242492676
(447) DESCRIBE `ports` 0.00148606300354
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00096487998962402
(449) DESCRIBE `ports` 0.0015151500701904
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035405158996582
(451) DESCRIBE `ports` 0.0016441345214844
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00036096572875977
(453) DESCRIBE `ports` 0.001694917678833
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00035309791564941
(455) DESCRIBE `ports` 0.00166916847229
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00036811828613281
(457) DESCRIBE `ports` 0.00173020362854
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0003969669342041
(459) DESCRIBE `ports` 0.0017139911651611
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00039792060852051
(461) DESCRIBE `ports` 0.0017788410186768
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00037288665771484
(463) DESCRIBE `ports` 0.0018119812011719
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00040793418884277
(465) DESCRIBE `ports` 0.0018210411071777
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.001478910446167
(467) DESCRIBE `ports` 0.0017020702362061
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00038409233093262
(469) DESCRIBE `ports` 0.0013270378112793
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00029611587524414
(471) DESCRIBE `ports` 0.0013349056243896
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030303001403809
(473) DESCRIBE `ports` 0.0013289451599121
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003211498260498
(475) DESCRIBE `ports` 0.0014808177947998
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00031113624572754
(477) DESCRIBE `ports` 0.0013320446014404
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00030517578125
(479) DESCRIBE `cruises` 0.0024669170379639
(480) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74713))) 0.0005190372467041
(481) DESCRIBE `avid_specials` 0.0012428760528564
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1472318 and class = 'Special') OR (item_id = 74713 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.001068115234375
(483) DESCRIBE `cruiselines` 0.0018801689147949
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00040507316589355
(485) DESCRIBE `orchid_image` 0.0015380382537842
(486) DESCRIBE `cruiselines` 0.0018980503082275
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00035595893859863
(488) DESCRIBE `cruises` 0.0026810169219971
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74713') 0.0004270076751709
(490) DESCRIBE `ships` 0.0030779838562012
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00044989585876465
(492) DESCRIBE `ships` 0.0028131008148193
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00031614303588867
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031590461730957
(496) DESCRIBE `itineraries` 0.0016078948974609
(497) DESCRIBE `ports` 0.001384973526001
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00035810470581055
(499) DESCRIBE `ports` 0.0017809867858887
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031805038452148
(501) DESCRIBE `ports` 0.0013308525085449
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035309791564941
(503) DESCRIBE `sailingdates` 0.0014908313751221
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74713') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056600570678711
(505) DESCRIBE `ports` 0.0019330978393555
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00047111511230469
(507) DESCRIBE `ports` 0.0014050006866455
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029802322387695
(509) DESCRIBE `ports` 0.0012919902801514
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036406517028809
(511) DESCRIBE `ports` 0.0017740726470947
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00042200088500977
(513) DESCRIBE `ports` 0.0014710426330566
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00032401084899902
(515) DESCRIBE `ports` 0.0014340877532959
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00029397010803223
(517) DESCRIBE `ports` 0.0015161037445068
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0004730224609375
(519) DESCRIBE `ports` 0.0021531581878662
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00042486190795898
(521) DESCRIBE `ports` 0.0020890235900879
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00047016143798828
(523) DESCRIBE `ports` 0.0021491050720215
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00041985511779785
(525) DESCRIBE `ports` 0.00201416015625
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00047802925109863
(527) DESCRIBE `ports` 0.0020790100097656
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0004570484161377
(529) DESCRIBE `ports` 0.0020530223846436
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00047492980957031
(531) DESCRIBE `ports` 0.0020120143890381
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00040888786315918
(533) DESCRIBE `ports` 0.001845121383667
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00041103363037109
(535) DESCRIBE `ports` 0.0018739700317383
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038504600524902
(537) DESCRIBE `ports` 0.0018970966339111
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041699409484863
(539) DESCRIBE `ports` 0.001859188079834
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00039982795715332
(541) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74713') AND (sailingdate >= '2019-01-01') 0.0095260143280029
(542) DESCRIBE `avid_specials` 0.0018918514251709
(543) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74713 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.0021941661834717
(544) DESCRIBE `cruiselines` 0.0028300285339355
(545) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00060391426086426
(546) DESCRIBE `orchid_image` 0.0020351409912109
(547) DESCRIBE `cruiselines` 0.0027291774749756
(548) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041484832763672
(549) DESCRIBE `specials` 0.0054299831390381
(550) SELECT `specials`.* FROM `specials` WHERE (id = '1472325') AND (specials.orchid_available = 1) LIMIT 1 0.00081706047058105
(551) DESCRIBE `specials` 0.0038471221923828
(552) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1472325') 0.00055122375488281
(553) DESCRIBE `ships` 0.0029120445251465
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00048613548278809
(555) DESCRIBE `ships` 0.0029029846191406
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00041890144348145
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028514862060547
(559) DESCRIBE `itineraries` 0.0014269351959229
(560) DESCRIBE `ports` 0.0014181137084961
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033092498779297
(562) DESCRIBE `ports` 0.0012938976287842
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00036382675170898
(564) DESCRIBE `ports` 0.0015139579772949
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00041389465332031
(566) DESCRIBE `specialsailingdates` 0.0015609264373779
(567) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1472325') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00085902214050293
(568) DESCRIBE `sailingdates` 0.001276969909668
(569) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471701))) 0.00031709671020508
(570) DESCRIBE `ports` 0.0013771057128906
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00034189224243164
(572) DESCRIBE `ports` 0.0013060569763184
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00032186508178711
(574) DESCRIBE `ports` 0.0013868808746338
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00032210350036621
(576) DESCRIBE `ports` 0.0022151470184326
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00045013427734375
(578) DESCRIBE `ports` 0.0015048980712891
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00031900405883789
(580) DESCRIBE `ports` 0.0012528896331787
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00029706954956055
(582) DESCRIBE `ports` 0.0013668537139893
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00030303001403809
(584) DESCRIBE `ports` 0.0012509822845459
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027585029602051
(586) DESCRIBE `ports` 0.0012941360473633
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00030708312988281
(588) DESCRIBE `ports` 0.0012998580932617
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00030612945556641
(590) DESCRIBE `ports` 0.0012540817260742
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00029993057250977
(592) DESCRIBE `ports` 0.001323938369751
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00029921531677246
(594) DESCRIBE `ports` 0.0014011859893799
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030899047851562
(596) DESCRIBE `ports` 0.0012609958648682
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027608871459961
(598) DESCRIBE `ports` 0.0013680458068848
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00042390823364258
(600) DESCRIBE `ports` 0.0013229846954346
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00034189224243164
(602) DESCRIBE `ports` 0.0013689994812012
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040292739868164
(604) DESCRIBE `ports` 0.0015559196472168
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031495094299316
(606) DESCRIBE `cruises` 0.002485990524292
(607) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52324))) 0.00053191184997559
(608) DESCRIBE `avid_specials` 0.0014481544494629
(609) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1472325 and class = 'Special') OR (item_id = 52324 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.0013179779052734
(610) DESCRIBE `cruiselines` 0.002190113067627
(611) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00036001205444336
(612) DESCRIBE `orchid_image` 0.0016720294952393
(613) DESCRIBE `cruiselines` 0.001835823059082
(614) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0011260509490967
(615) DESCRIBE `ships` 0.0042908191680908
(616) SELECT `ships`.* FROM `ships` WHERE (id IN ('1013', '1526', '1163')) ORDER BY FIND_IN_SET(id, '1013,1526,1163') 0.00098013877868652
(617) DESCRIBE `cruisetypes` 0.001723051071167
(618) DESCRIBE `destinations` 0.0026750564575195
(619) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0
(620) DESCRIBE `cruiselines` 0.0029361248016357
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00061607360839844
(622) DESCRIBE `cruiselines` 0.0030570030212402
(623) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00061893463134766