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

Total elapsed time: 0.83942341804504

# Query Time
(1) connect 0.00095891952514648
(2) DESCRIBE `cruises` 0.0031988620758057
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69854, 69855, 69891, 69873, 69856, 69874, 69857, 69892, 69875, 69893)) ORDER BY FIND_IN_SET(id, '69854,69855,69891,69873,69856,69874,69857,69892,69875,69893') 0.0015690326690674
(4) DESCRIBE `cruises` 0.0034220218658447
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69854') 0.00054717063903809
(6) DESCRIBE `ships` 0.0035920143127441
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00097203254699707
(8) DESCRIBE `ships` 0.0028009414672852
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 6.9141387939453E-6
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002739429473877
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032711029052734
(12) DESCRIBE `itineraries` 0.0013549327850342
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69854') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0001978874206543
(14) DESCRIBE `ports` 0.0014519691467285
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00034379959106445
(16) DESCRIBE `ports` 0.0012850761413574
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0
(18) DESCRIBE `ports` 0.0013110637664795
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030016899108887
(20) DESCRIBE `sailingdates` 0.001410961151123
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69854') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083208084106445
(22) DESCRIBE `ports` 0.0016050338745117
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00091814994812012
(24) DESCRIBE `ports` 0.0018448829650879
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00031781196594238
(26) DESCRIBE `ports` 0.0014488697052002
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00042104721069336
(28) DESCRIBE `ports` 0.001176118850708
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00031208992004395
(30) DESCRIBE `ports` 0.0018689632415771
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00030994415283203
(32) DESCRIBE `ports` 0.0018289089202881
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00024104118347168
(34) DESCRIBE `ports` 0.0016210079193115
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00034594535827637
(36) DESCRIBE `ports` 0.0013210773468018
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00027298927307129
(38) DESCRIBE `ports` 0.0014450550079346
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00040197372436523
(40) DESCRIBE `ports` 0.0014591217041016
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00028181076049805
(42) DESCRIBE `ports` 0.0014519691467285
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00032210350036621
(44) DESCRIBE `ports` 0.0013241767883301
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00028204917907715
(46) DESCRIBE `ports` 0.0013470649719238
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00031495094299316
(48) DESCRIBE `ports` 0.0012660026550293
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00029492378234863
(50) DESCRIBE `ports` 0.0012800693511963
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00035810470581055
(52) DESCRIBE `ports` 0.0012490749359131
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027585029602051
(54) DESCRIBE `ports` 0.0014050006866455
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037693977355957
(56) DESCRIBE `ports` 0.0015020370483398
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031590461730957
(58) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69854') AND (sailingdate >= '2018-01-10') 0.0093801021575928
(59) DESCRIBE `avid_specials` 0.0016529560089111
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69854 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012068748474121
(61) DESCRIBE `cruiselines` 0.0035789012908936
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00060200691223145
(63) DESCRIBE `orchid_image` 0.0020809173583984
(64) DESCRIBE `cruiselines` 0.0028729438781738
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043201446533203
(66) DESCRIBE `cruises` 0.0039219856262207
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69855') 0.0003509521484375
(68) DESCRIBE `ships` 0.0030701160430908
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00053620338439941
(70) DESCRIBE `ships` 0.0029711723327637
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00039887428283691
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028014183044434
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004429817199707
(74) DESCRIBE `itineraries` 0.0014610290527344
(75) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69855') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050687789916992
(76) DESCRIBE `ports` 0.0015659332275391
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037598609924316
(78) DESCRIBE `ports` 0.0014429092407227
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(80) DESCRIBE `ports` 0.0015749931335449
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036001205444336
(82) DESCRIBE `sailingdates` 0.0012731552124023
(83) DESCRIBE `ports` 0.0015499591827393
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042891502380371
(85) DESCRIBE `ports` 0.0014059543609619
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(87) DESCRIBE `ports` 0.0013430118560791
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031304359436035
(89) DESCRIBE `ports` 0.0013830661773682
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00033402442932129
(91) DESCRIBE `ports` 0.0014419555664062
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0002899169921875
(93) DESCRIBE `ports` 0.0018060207366943
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00039505958557129
(95) DESCRIBE `ports` 0.0018050670623779
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00031709671020508
(97) DESCRIBE `ports` 0.001356840133667
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00028109550476074
(99) DESCRIBE `ports` 0.0012600421905518
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031089782714844
(101) DESCRIBE `ports` 0.0016880035400391
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029611587524414
(103) DESCRIBE `ports` 0.0018348693847656
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00040197372436523
(105) DESCRIBE `ports` 0.0016820430755615
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00055193901062012
(107) DESCRIBE `ports` 0.0021839141845703
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037193298339844
(109) DESCRIBE `ports` 0.0013549327850342
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031089782714844
(111) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69855') AND (sailingdate >= '2018-01-10') 0.0074999332427979
(112) DESCRIBE `avid_specials` 0.0019819736480713
(113) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69855 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018830299377441
(114) DESCRIBE `cruiselines` 0.0027270317077637
(115) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00051188468933105
(116) DESCRIBE `orchid_image` 0.0018510818481445
(117) DESCRIBE `cruiselines` 0.0022010803222656
(118) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00045585632324219
(119) DESCRIBE `cruises` 0.0030429363250732
(120) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69891') 0.00041103363037109
(121) DESCRIBE `ships` 0.0026700496673584
(122) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00035905838012695
(123) DESCRIBE `ships` 0.0028059482574463
(124) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00038599967956543
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(127) DESCRIBE `itineraries` 0.0017669200897217
(128) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69891') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057220458984375
(129) DESCRIBE `ports` 0.0015168190002441
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031089782714844
(131) DESCRIBE `ports` 0.0012638568878174
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030088424682617
(133) DESCRIBE `ports` 0.0012631416320801
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(135) DESCRIBE `sailingdates` 0.0010910034179688
(136) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69891') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049304962158203
(137) DESCRIBE `ports` 0.0012481212615967
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(139) DESCRIBE `ports` 0.0012600421905518
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(141) DESCRIBE `ports` 0.0013360977172852
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029587745666504
(143) DESCRIBE `ports` 0.0013649463653564
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0002739429473877
(145) DESCRIBE `ports` 0.0013070106506348
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00033283233642578
(147) DESCRIBE `ports` 0.0014190673828125
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00031280517578125
(149) DESCRIBE `ports` 0.0013160705566406
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00032591819763184
(151) DESCRIBE `ports` 0.0012738704681396
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00028204917907715
(153) DESCRIBE `ports` 0.0012989044189453
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030994415283203
(155) DESCRIBE `ports` 0.0012571811676025
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00036287307739258
(157) DESCRIBE `ports` 0.00142502784729
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029802322387695
(159) DESCRIBE `ports` 0.0013999938964844
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030422210693359
(161) DESCRIBE `ports` 0.00136399269104
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00029993057250977
(163) DESCRIBE `ports` 0.0014450550079346
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00029301643371582
(165) DESCRIBE `ports` 0.0012290477752686
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(167) DESCRIBE `ports` 0.0012648105621338
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(169) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69891') AND (sailingdate >= '2018-01-10') 0.0054099559783936
(170) DESCRIBE `avid_specials` 0.0012989044189453
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69891 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010039806365967
(172) DESCRIBE `cruiselines` 0.0018908977508545
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033712387084961
(174) DESCRIBE `orchid_image` 0.0014009475708008
(175) DESCRIBE `cruiselines` 0.0019321441650391
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030708312988281
(177) DESCRIBE `cruises` 0.002659797668457
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69873') 0.00041890144348145
(179) DESCRIBE `ships` 0.0025370121002197
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00047802925109863
(181) DESCRIBE `ships` 0.0026309490203857
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00053215026855469
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034618377685547
(185) DESCRIBE `itineraries` 0.0019350051879883
(186) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69873') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065112113952637
(187) DESCRIBE `ports` 0.0029911994934082
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043487548828125
(189) DESCRIBE `ports` 0.0017518997192383
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(191) DESCRIBE `ports` 0.0016870498657227
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(193) DESCRIBE `sailingdates` 0.00073719024658203
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69873') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059604644775391
(195) DESCRIBE `ports` 0.0019998550415039
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(197) DESCRIBE `ports` 0.0018088817596436
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0012328624725342
(199) DESCRIBE `ports` 0.001291036605835
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041890144348145
(201) DESCRIBE `ports` 0.0018720626831055
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038290023803711
(203) DESCRIBE `ports` 0.0019590854644775
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00040483474731445
(205) DESCRIBE `ports` 0.0018050670623779
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 3.3855438232422E-5
(207) DESCRIBE `ports` 0.0016849040985107
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0012362003326416
(209) DESCRIBE `ports` 0.00136399269104
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0013980865478516
(211) DESCRIBE `ports` 0.0016770362854004
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00033688545227051
(213) DESCRIBE `ports` 0.0013101100921631
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00029706954956055
(215) DESCRIBE `ports` 0.0017619132995605
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00038695335388184
(217) DESCRIBE `ports` 0.00211501121521
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00041794776916504
(219) DESCRIBE `ports` 0.0018088817596436
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00043201446533203
(221) DESCRIBE `ports` 0.0017859935760498
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00042200088500977
(223) DESCRIBE `ports` 0.0018589496612549
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043296813964844
(225) DESCRIBE `ports` 0.0018060207366943
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040984153747559
(227) DESCRIBE `ports` 0.0014188289642334
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0003199577331543
(229) DESCRIBE `ports` 0.0014312267303467
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028610229492188
(231) DESCRIBE `ports` 0.0012459754943848
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036883354187012
(233) DESCRIBE `ports` 0.0012750625610352
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032997131347656
(235) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69873') AND (sailingdate >= '2018-01-10') 0.005573034286499
(236) DESCRIBE `avid_specials` 0.0013489723205566
(237) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69873 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010390281677246
(238) DESCRIBE `cruiselines` 0.0020949840545654
(239) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037097930908203
(240) DESCRIBE `orchid_image` 0.0015130043029785
(241) DESCRIBE `cruiselines` 0.0026991367340088
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00045895576477051
(243) DESCRIBE `cruises` 0.0037250518798828
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69856') 0.00049591064453125
(245) DESCRIBE `ships` 0.003939151763916
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.0006110668182373
(247) DESCRIBE `ships` 0.0033679008483887
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.0004580020904541
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(251) DESCRIBE `itineraries` 0.0015759468078613
(252) DESCRIBE `ports` 0.0017399787902832
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053811073303223
(254) DESCRIBE `ports` 0.0015499591827393
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(256) DESCRIBE `ports` 0.0014779567718506
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055599212646484
(258) DESCRIBE `sailingdates` 0.0015761852264404
(259) DESCRIBE `ports` 0.002039909362793
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050210952758789
(261) DESCRIBE `ports` 0.0018489360809326
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003211498260498
(263) DESCRIBE `ports` 0.001633882522583
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00048995018005371
(265) DESCRIBE `ports` 0.0018281936645508
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038385391235352
(267) DESCRIBE `ports` 0.0019099712371826
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00045490264892578
(269) DESCRIBE `ports` 0.0018301010131836
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00038695335388184
(271) DESCRIBE `ports` 0.0023999214172363
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034904479980469
(273) DESCRIBE `ports` 0.0013229846954346
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030398368835449
(275) DESCRIBE `ports` 0.0013618469238281
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00037884712219238
(277) DESCRIBE `ports` 0.0022218227386475
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037789344787598
(279) DESCRIBE `ports` 0.0018651485443115
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063395500183105
(281) DESCRIBE `ports` 0.0017199516296387
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(283) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69856') AND (sailingdate >= '2018-01-10') 0.0052170753479004
(284) DESCRIBE `avid_specials` 0.0025959014892578
(285) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69856 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011780261993408
(286) DESCRIBE `cruiselines` 0.0021998882293701
(287) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00027990341186523
(288) DESCRIBE `orchid_image` 0.0026290416717529
(289) DESCRIBE `cruiselines` 0.0025181770324707
(290) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00045490264892578
(291) DESCRIBE `cruises` 0.0034651756286621
(292) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69874') 0.00047898292541504
(293) DESCRIBE `ships` 0.0035660266876221
(294) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00057005882263184
(295) DESCRIBE `ships` 0.0035490989685059
(296) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.0005190372467041
(297) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004119873046875
(299) DESCRIBE `itineraries` 0.0018730163574219
(300) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69874') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00075101852416992
(301) DESCRIBE `ports` 0.0036680698394775
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054192543029785
(303) DESCRIBE `ports` 0.0019898414611816
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053596496582031
(305) DESCRIBE `ports` 0.0020091533660889
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046992301940918
(307) DESCRIBE `sailingdates` 0.001798152923584
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69874') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064897537231445
(309) DESCRIBE `ports` 0.001439094543457
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004880428314209
(311) DESCRIBE `ports` 0.0018310546875
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003969669342041
(313) DESCRIBE `ports` 0.0018301010131836
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00047087669372559
(315) DESCRIBE `ports` 0.0018348693847656
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0004279613494873
(317) DESCRIBE `ports` 0.0018010139465332
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00054407119750977
(319) DESCRIBE `ports` 0.0017280578613281
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00039386749267578
(321) DESCRIBE `ports` 0.0017330646514893
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041484832763672
(323) DESCRIBE `ports` 0.0017039775848389
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00035309791564941
(325) DESCRIBE `ports` 0.0023870468139648
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040102005004883
(327) DESCRIBE `ports` 0.0023720264434814
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(329) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69874') AND (sailingdate >= '2018-01-10') 0.0092389583587646
(330) DESCRIBE `avid_specials` 0.001910924911499
(331) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69874 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019369125366211
(332) DESCRIBE `cruiselines` 0.0031330585479736
(333) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00052499771118164
(334) DESCRIBE `orchid_image` 0.0022580623626709
(335) DESCRIBE `cruiselines` 0.0030608177185059
(336) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0004429817199707
(337) DESCRIBE `cruises` 0.0040819644927979
(338) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69857') 0.0016090869903564
(339) DESCRIBE `ships` 0.004565954208374
(340) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00087904930114746
(341) DESCRIBE `ships` 0.0079128742218018
(342) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.0017950534820557
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052189826965332
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(345) DESCRIBE `itineraries` 0.0043139457702637
(346) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69857') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071001052856445
(347) DESCRIBE `ports` 0.0021481513977051
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043201446533203
(349) DESCRIBE `ports` 0.0016508102416992
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039887428283691
(351) DESCRIBE `ports` 0.0016751289367676
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042200088500977
(353) DESCRIBE `sailingdates` 0.0014059543609619
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69857') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061321258544922
(355) DESCRIBE `ports` 0.0018949508666992
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045204162597656
(357) DESCRIBE `ports` 0.0017290115356445
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052905082702637
(359) DESCRIBE `ports` 0.0016350746154785
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00045514106750488
(361) DESCRIBE `ports` 0.00130295753479
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030899047851562
(363) DESCRIBE `ports` 0.0013580322265625
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00040888786315918
(365) DESCRIBE `ports` 0.0016028881072998
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00046682357788086
(367) DESCRIBE `ports` 0.0014338493347168
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00034904479980469
(369) DESCRIBE `ports` 0.0018081665039062
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00040793418884277
(371) DESCRIBE `ports` 0.0015809535980225
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00032520294189453
(373) DESCRIBE `ports` 0.0016229152679443
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00032901763916016
(375) DESCRIBE `ports` 0.0015590190887451
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029706954956055
(377) DESCRIBE `ports` 0.0017750263214111
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00041007995605469
(379) DESCRIBE `ports` 0.0016350746154785
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033402442932129
(381) DESCRIBE `ports` 0.0013930797576904
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036787986755371
(383) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69857') AND (sailingdate >= '2018-01-10') 0.0068919658660889
(384) DESCRIBE `avid_specials` 0.0018019676208496
(385) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69857 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011849403381348
(386) DESCRIBE `cruiselines` 0.0021510124206543
(387) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042295455932617
(388) DESCRIBE `orchid_image` 0.0016570091247559
(389) DESCRIBE `cruiselines` 0.0026051998138428
(390) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0003960132598877
(391) DESCRIBE `cruises` 0.0026359558105469
(392) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69892') 0.00043988227844238
(393) DESCRIBE `ships` 0.0031139850616455
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00044798851013184
(395) DESCRIBE `ships` 0.0032579898834229
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00038409233093262
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002748966217041
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030207633972168
(399) DESCRIBE `itineraries` 0.0016040802001953
(400) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69892') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065922737121582
(401) DESCRIBE `ports` 0.0019550323486328
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044608116149902
(403) DESCRIBE `ports` 0.0020978450775146
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053596496582031
(405) DESCRIBE `ports` 0.0020480155944824
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044989585876465
(407) DESCRIBE `sailingdates` 0.0021231174468994
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69892') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012609958648682
(409) DESCRIBE `ports` 0.0020949840545654
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045084953308105
(411) DESCRIBE `ports` 0.0019559860229492
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044512748718262
(413) DESCRIBE `ports` 0.0018329620361328
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00044894218444824
(415) DESCRIBE `ports` 0.0018401145935059
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00043892860412598
(417) DESCRIBE `ports` 0.0017979145050049
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00054597854614258
(419) DESCRIBE `ports` 0.0017690658569336
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00049281120300293
(421) DESCRIBE `ports` 0.0020370483398438
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0004880428314209
(423) DESCRIBE `ports` 0.0016939640045166
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00053191184997559
(425) DESCRIBE `ports` 0.0017869472503662
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042104721069336
(427) DESCRIBE `ports` 0.0016720294952393
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037503242492676
(429) DESCRIBE `ports` 0.0016281604766846
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00044703483581543
(431) DESCRIBE `ports` 0.0016939640045166
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00038790702819824
(433) DESCRIBE `ports` 0.0016779899597168
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00036001205444336
(435) DESCRIBE `ports` 0.0016729831695557
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00050115585327148
(437) DESCRIBE `ports` 0.0019838809967041
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00044012069702148
(439) DESCRIBE `ports` 0.0019090175628662
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00034403800964355
(441) DESCRIBE `ports` 0.0027132034301758
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00056982040405273
(443) DESCRIBE `ports` 0.00082087516784668
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00041317939758301
(445) DESCRIBE `ports` 0.0017569065093994
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049495697021484
(447) DESCRIBE `ports` 0.001741886138916
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037312507629395
(449) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69892') AND (sailingdate >= '2018-01-10') 0.008735179901123
(450) DESCRIBE `avid_specials` 0.0023231506347656
(451) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69892 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017709732055664
(452) DESCRIBE `cruiselines` 0.0028989315032959
(453) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045609474182129
(454) DESCRIBE `orchid_image` 0.0027148723602295
(455) DESCRIBE `cruiselines` 0.002993106842041
(456) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00045514106750488
(457) DESCRIBE `cruises` 0.0049600601196289
(458) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69875') 0.00052309036254883
(459) DESCRIBE `ships` 0.0035080909729004
(460) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00056910514831543
(461) DESCRIBE `ships` 0.0034358501434326
(462) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00048995018005371
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039315223693848
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(465) DESCRIBE `itineraries` 0.0021688938140869
(466) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69875') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077199935913086
(467) DESCRIBE `ports` 0.0019412040710449
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(469) DESCRIBE `ports` 0.0019409656524658
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(471) DESCRIBE `ports` 0.0028839111328125
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052404403686523
(473) DESCRIBE `sailingdates` 0.0027430057525635
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69875') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063705444335938
(475) DESCRIBE `ports` 0.0025668144226074
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048112869262695
(477) DESCRIBE `ports` 0.0019280910491943
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041508674621582
(479) DESCRIBE `ports` 0.0019018650054932
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00046086311340332
(481) DESCRIBE `ports` 0.001986026763916
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00043201446533203
(483) DESCRIBE `ports` 0.0016059875488281
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032806396484375
(485) DESCRIBE `ports` 0.001323938369751
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027990341186523
(487) DESCRIBE `ports` 0.0013549327850342
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00037693977355957
(489) DESCRIBE `ports` 0.0018742084503174
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00038504600524902
(491) DESCRIBE `ports` 0.0018138885498047
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00035285949707031
(493) DESCRIBE `ports` 0.0014770030975342
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00037193298339844
(495) DESCRIBE `ports` 0.0017349720001221
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00035905838012695
(497) DESCRIBE `ports` 0.0017399787902832
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031185150146484
(499) DESCRIBE `ports` 0.0016779899597168
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042104721069336
(501) DESCRIBE `ports` 0.0016789436340332
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037097930908203
(503) DESCRIBE `ports` 0.0016450881958008
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0003819465637207
(505) DESCRIBE `ports` 0.0013940334320068
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00032711029052734
(507) DESCRIBE `ports` 0.0012757778167725
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00031590461730957
(509) DESCRIBE `ports` 0.0015358924865723
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00035500526428223
(511) DESCRIBE `ports` 0.0015459060668945
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00031709671020508
(513) DESCRIBE `ports` 0.0013570785522461
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00028491020202637
(515) DESCRIBE `ports` 0.0012919902801514
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(517) DESCRIBE `ports` 0.0015430450439453
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(519) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69875') AND (sailingdate >= '2018-01-10') 0.0063848495483398
(520) DESCRIBE `avid_specials` 0.0020670890808105
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69875 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018479824066162
(522) DESCRIBE `cruiselines` 0.0026290416717529
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043606758117676
(524) DESCRIBE `orchid_image` 0.0019750595092773
(525) DESCRIBE `cruiselines` 0.0021870136260986
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00032615661621094
(527) DESCRIBE `cruises` 0.0027360916137695
(528) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69893') 0.00042915344238281
(529) DESCRIBE `ships` 0.0031650066375732
(530) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00061798095703125
(531) DESCRIBE `ships` 0.0030498504638672
(532) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00032997131347656
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(534) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028085708618164
(535) DESCRIBE `itineraries` 0.0015408992767334
(536) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69893') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069808959960938
(537) DESCRIBE `ports` 0.0015048980712891
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032401084899902
(539) DESCRIBE `ports` 0.0015120506286621
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003809928894043
(541) DESCRIBE `ports` 0.0015349388122559
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038599967956543
(543) DESCRIBE `sailingdates` 0.0013749599456787
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69893') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060200691223145
(545) DESCRIBE `ports` 0.0015928745269775
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042819976806641
(547) DESCRIBE `ports` 0.0016441345214844
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034213066101074
(549) DESCRIBE `ports` 0.0015177726745605
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00032281875610352
(551) DESCRIBE `ports` 0.001284122467041
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00031304359436035
(553) DESCRIBE `ports` 0.0013489723205566
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0011007785797119
(555) DESCRIBE `ports` 0.00074315071105957
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00027799606323242
(557) DESCRIBE `ports` 0.0012378692626953
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0
(559) DESCRIBE `ports` 0.0014970302581787
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00030303001403809
(561) DESCRIBE `ports` 0.0014231204986572
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00031113624572754
(563) DESCRIBE `ports` 0.0013329982757568
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0011708736419678
(565) DESCRIBE `ports` 0.00058603286743164
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029301643371582
(567) DESCRIBE `ports` 0.0013718605041504
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0
(569) DESCRIBE `ports` 0.0015008449554443
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036716461181641
(571) DESCRIBE `ports` 0.0017480850219727
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0004880428314209
(573) DESCRIBE `ports` 0.0017430782318115
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00043416023254395
(575) DESCRIBE `ports` 0.0022659301757812
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0003509521484375
(577) DESCRIBE `ports` 0.001741886138916
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0
(579) DESCRIBE `ports` 0.0025341510772705
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00092387199401855
(581) DESCRIBE `ports` 0.0019989013671875
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00046086311340332
(583) DESCRIBE `ports` 0.0018141269683838
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038886070251465
(585) DESCRIBE `ports` 0.0019278526306152
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004570484161377
(587) DESCRIBE `ports` 0.0012729167938232
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040102005004883
(589) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69893') AND (sailingdate >= '2018-01-10') 0.0063719749450684
(590) DESCRIBE `avid_specials` 0.0033891201019287
(591) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69893 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011928081512451
(592) DESCRIBE `cruiselines` 0.0018899440765381
(593) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00058078765869141
(594) DESCRIBE `orchid_image` 0.0030808448791504
(595) DESCRIBE `cruiselines` 0.0024418830871582
(596) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036191940307617
(597) DESCRIBE `ships` 0.0044429302215576
(598) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '287', '262', '124')) ORDER BY FIND_IN_SET(id, '1330,287,262,124') 0.00091910362243652
(599) DESCRIBE `cruisetypes` 0.0014171600341797
(600) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '43') AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.036932945251465
(601) DESCRIBE `cruiselines` 0.0027589797973633
(602) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00059390068054199
(603) DESCRIBE `destinations` 0.0025191307067871
(604) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00053191184997559
(605) DESCRIBE `destinations` 0.0080070495605469
(606) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00057792663574219
(607) DESCRIBE `cruiselines` 0.0022828578948975
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0081818103790283