or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

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

Total elapsed time: 0.57080626487732

# Query Time
(1) connect 0.00062203407287598
(2) DESCRIBE `cruises` 0.0023531913757324
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74112, 64080, 64105, 67226, 54856, 67856, 66556, 67828, 64106, 59347)) ORDER BY FIND_IN_SET(id, '74112,64080,64105,67226,54856,67856,66556,67828,64106,59347') 0.001943826675415
(4) DESCRIBE `cruises` 0.0021400451660156
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74112') 0.00035881996154785
(6) DESCRIBE `ships` 0.0022311210632324
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00045490264892578
(8) DESCRIBE `ships` 0.0020418167114258
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00034213066101074
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(12) DESCRIBE `itineraries` 0.0010838508605957
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74112') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016958713531494
(14) DESCRIBE `ports` 0.0012550354003906
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0003211498260498
(16) DESCRIBE `ports` 0.0010311603546143
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030517578125
(18) DESCRIBE `ports` 0.0010411739349365
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00025296211242676
(20) DESCRIBE `sailingdates` 0.00083088874816895
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74112') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0015101432800293
(22) DESCRIBE `ports` 0.0014009475708008
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032401084899902
(24) DESCRIBE `ports` 0.00094389915466309
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024199485778809
(26) DESCRIBE `ports` 0.0009009838104248
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00028085708618164
(28) DESCRIBE `ports` 0.00097799301147461
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00027704238891602
(30) DESCRIBE `ports` 0.00096487998962402
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0002748966217041
(32) DESCRIBE `ports` 0.00097894668579102
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00024509429931641
(34) DESCRIBE `ports` 0.00088191032409668
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00028395652770996
(36) DESCRIBE `ports` 0.00099515914916992
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00025296211242676
(38) DESCRIBE `ports` 0.00092196464538574
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00026082992553711
(40) DESCRIBE `ports` 0.00084900856018066
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00022697448730469
(42) DESCRIBE `ports` 0.00084614753723145
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.0002591609954834
(44) DESCRIBE `ports` 0.00094103813171387
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00022792816162109
(46) DESCRIBE `ports` 0.0008540153503418
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00028800964355469
(48) DESCRIBE `ports` 0.00087118148803711
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00022506713867188
(50) DESCRIBE `ports` 0.00088906288146973
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027704238891602
(52) DESCRIBE `ports` 0.0009610652923584
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00025486946105957
(54) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74112') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.011919021606445
(55) DESCRIBE `avid_specials` 0.0012290477752686
(56) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74112 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 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.0013980865478516
(57) DESCRIBE `cruiselines` 0.0013158321380615
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00028395652770996
(59) DESCRIBE `orchid_image` 0.00093817710876465
(60) DESCRIBE `cruiselines` 0.0011589527130127
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00026106834411621
(62) DESCRIBE `cruises` 0.0017509460449219
(63) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64080') 0.00034594535827637
(64) DESCRIBE `ships` 0.0019309520721436
(65) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.0004429817199707
(66) DESCRIBE `ships` 0.0020811557769775
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00029301643371582
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001990795135498
(70) DESCRIBE `itineraries` 0.0010459423065186
(71) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64080') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012671947479248
(72) DESCRIBE `ports` 0.0013320446014404
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(74) DESCRIBE `ports` 0.0010459423065186
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030016899108887
(76) DESCRIBE `ports` 0.00094294548034668
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024318695068359
(78) DESCRIBE `sailingdates` 0.00083208084106445
(79) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64080') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00099515914916992
(80) DESCRIBE `ports` 0.0011529922485352
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(82) DESCRIBE `ports` 0.00091314315795898
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023508071899414
(84) DESCRIBE `ports` 0.0009150505065918
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024294853210449
(86) DESCRIBE `ports` 0.00098896026611328
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024604797363281
(88) DESCRIBE `ports` 0.00087904930114746
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00024986267089844
(90) DESCRIBE `ports` 0.00094890594482422
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00023007392883301
(92) DESCRIBE `ports` 0.00093507766723633
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00025105476379395
(94) DESCRIBE `ports` 0.0010268688201904
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00024509429931641
(96) DESCRIBE `ports` 0.00082707405090332
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00022697448730469
(98) DESCRIBE `ports` 0.00085306167602539
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00021600723266602
(100) DESCRIBE `ports` 0.00087690353393555
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00023698806762695
(102) DESCRIBE `ports` 0.00092601776123047
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00021600723266602
(104) DESCRIBE `ports` 0.00087404251098633
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00024604797363281
(106) DESCRIBE `ports` 0.00092697143554688
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00032687187194824
(108) DESCRIBE `ports` 0.00095319747924805
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00023508071899414
(110) DESCRIBE `ports` 0.00088810920715332
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00020098686218262
(112) DESCRIBE `ports` 0.00082087516784668
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00024986267089844
(114) DESCRIBE `ports` 0.00087213516235352
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.0002281665802002
(116) DESCRIBE `ports` 0.00086808204650879
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00024104118347168
(118) DESCRIBE `ports` 0.00091695785522461
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00022387504577637
(120) DESCRIBE `ports` 0.00083684921264648
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00024604797363281
(122) DESCRIBE `ports` 0.00088286399841309
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0002288818359375
(124) DESCRIBE `ports` 0.00090789794921875
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0002589225769043
(126) DESCRIBE `ports` 0.00090217590332031
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00024104118347168
(128) DESCRIBE `ports` 0.00092005729675293
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00026392936706543
(130) DESCRIBE `ports` 0.00093698501586914
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00022697448730469
(132) DESCRIBE `ports` 0.00085806846618652
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00027012825012207
(134) DESCRIBE `ports` 0.0009770393371582
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00024604797363281
(136) DESCRIBE `ports` 0.00095295906066895
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00027012825012207
(138) DESCRIBE `ports` 0.0010049343109131
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00023102760314941
(140) DESCRIBE `ports` 0.00087499618530273
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029897689819336
(142) DESCRIBE `ports` 0.00099420547485352
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024580955505371
(144) DESCRIBE `ports` 0.00091695785522461
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00027203559875488
(146) DESCRIBE `ports` 0.00095987319946289
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00024819374084473
(148) DESCRIBE `ports` 0.00089693069458008
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026988983154297
(150) DESCRIBE `ports` 0.00087499618530273
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023198127746582
(152) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64080') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0084719657897949
(153) DESCRIBE `avid_specials` 0.0010731220245361
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64080 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0015709400177002
(155) DESCRIBE `cruiselines` 0.0016298294067383
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034999847412109
(157) DESCRIBE `orchid_image` 0.0012831687927246
(158) DESCRIBE `cruiselines` 0.0016529560089111
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00030183792114258
(160) DESCRIBE `cruises` 0.0021030902862549
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64105') 0.00032615661621094
(162) DESCRIBE `ships` 0.0020971298217773
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00039196014404297
(164) DESCRIBE `ships` 0.0019588470458984
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00031304359436035
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(168) DESCRIBE `itineraries` 0.0010440349578857
(169) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64105') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008089542388916
(170) DESCRIBE `ports` 0.0013220310211182
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004730224609375
(172) DESCRIBE `ports` 0.0010161399841309
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(174) DESCRIBE `ports` 0.00096392631530762
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(176) DESCRIBE `sailingdates` 0.0011959075927734
(177) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64105') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055694580078125
(178) DESCRIBE `ports` 0.00099897384643555
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027108192443848
(180) DESCRIBE `ports` 0.0013701915740967
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039410591125488
(182) DESCRIBE `ports` 0.0010929107666016
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029802322387695
(184) DESCRIBE `ports` 0.0010719299316406
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.000244140625
(186) DESCRIBE `ports` 0.00088191032409668
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00026798248291016
(188) DESCRIBE `ports` 0.0009610652923584
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00025296211242676
(190) DESCRIBE `ports` 0.00092506408691406
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00026488304138184
(192) DESCRIBE `ports` 0.0012941360473633
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00024986267089844
(194) DESCRIBE `ports` 0.00084209442138672
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00023794174194336
(196) DESCRIBE `ports` 0.0009148120880127
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00021910667419434
(198) DESCRIBE `ports` 0.00080204010009766
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00028610229492188
(200) DESCRIBE `ports` 0.00089406967163086
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00022792816162109
(202) DESCRIBE `ports` 0.00084805488586426
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00023794174194336
(204) DESCRIBE `ports` 0.00083684921264648
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00022196769714355
(206) DESCRIBE `ports` 0.00088810920715332
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00024795532226562
(208) DESCRIBE `ports` 0.00088596343994141
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00020194053649902
(210) DESCRIBE `ports` 0.00090599060058594
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.0003819465637207
(212) DESCRIBE `ports` 0.0011250972747803
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00028705596923828
(214) DESCRIBE `ports` 0.00088095664978027
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.0002448558807373
(216) DESCRIBE `ports` 0.00090599060058594
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00025200843811035
(218) DESCRIBE `ports` 0.00087690353393555
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00024294853210449
(220) DESCRIBE `ports` 0.00088381767272949
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00023293495178223
(222) DESCRIBE `ports` 0.00088596343994141
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00028586387634277
(224) DESCRIBE `ports` 0.00094294548034668
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00024700164794922
(226) DESCRIBE `ports` 0.00090980529785156
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00029802322387695
(228) DESCRIBE `ports` 0.00098013877868652
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00034189224243164
(230) DESCRIBE `ports` 0.0010490417480469
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0003058910369873
(232) DESCRIBE `ports` 0.00096797943115234
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.0002739429473877
(234) DESCRIBE `ports` 0.0009610652923584
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00025701522827148
(236) DESCRIBE `ports` 0.00085186958312988
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00022697448730469
(238) DESCRIBE `ports` 0.00098299980163574
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028109550476074
(240) DESCRIBE `ports` 0.00098800659179688
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027608871459961
(242) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64105') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0069780349731445
(243) DESCRIBE `avid_specials` 0.0010700225830078
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64105 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0015549659729004
(245) DESCRIBE `cruiselines` 0.0015552043914795
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037002563476562
(247) DESCRIBE `orchid_image` 0.0011229515075684
(248) DESCRIBE `cruiselines` 0.0015840530395508
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0002589225769043
(250) DESCRIBE `cruises` 0.0017769336700439
(251) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67226') 0.00031805038452148
(252) DESCRIBE `ships` 0.0020010471343994
(253) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.00033903121948242
(254) DESCRIBE `ships` 0.0018830299377441
(255) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.0003349781036377
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(257) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019001960754395
(258) DESCRIBE `itineraries` 0.00093913078308105
(259) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67226') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013999938964844
(260) DESCRIBE `ports` 0.0012080669403076
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031399726867676
(262) DESCRIBE `ports` 0.00091385841369629
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00026202201843262
(264) DESCRIBE `ports` 0.00078988075256348
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00021886825561523
(266) DESCRIBE `sailingdates` 0.0007469654083252
(267) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67226') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067591667175293
(268) DESCRIBE `ports` 0.0012059211730957
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00036096572875977
(270) DESCRIBE `ports` 0.001060962677002
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0003049373626709
(272) DESCRIBE `ports` 0.00099492073059082
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00036501884460449
(274) DESCRIBE `ports` 0.0010039806365967
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00026297569274902
(276) DESCRIBE `ports` 0.0009000301361084
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00025105476379395
(278) DESCRIBE `ports` 0.00088787078857422
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00024294853210449
(280) DESCRIBE `ports` 0.00087118148803711
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00025701522827148
(282) DESCRIBE `ports` 0.00088810920715332
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00023722648620605
(284) DESCRIBE `ports` 0.00087904930114746
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00028300285339355
(286) DESCRIBE `ports` 0.0010159015655518
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00024294853210449
(288) DESCRIBE `ports` 0.00087404251098633
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.0002591609954834
(290) DESCRIBE `ports` 0.00091695785522461
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00027298927307129
(292) DESCRIBE `ports` 0.00092291831970215
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00027918815612793
(294) DESCRIBE `ports` 0.00096511840820312
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00023198127746582
(296) DESCRIBE `ports` 0.0009160041809082
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00029301643371582
(298) DESCRIBE `ports` 0.00089383125305176
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00026512145996094
(300) DESCRIBE `ports` 0.00095987319946289
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1089))) 0.00034809112548828
(302) DESCRIBE `ports` 0.0010151863098145
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1089') 0.00027203559875488
(304) DESCRIBE `ports` 0.00094795227050781
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00030899047851562
(306) DESCRIBE `ports` 0.0010368824005127
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00027990341186523
(308) DESCRIBE `ports` 0.0012030601501465
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034689903259277
(310) DESCRIBE `ports` 0.00099706649780273
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0002439022064209
(312) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67226') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0078098773956299
(313) DESCRIBE `avid_specials` 0.0011661052703857
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67226 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 21 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.0015261173248291
(315) DESCRIBE `cruiselines` 0.0015048980712891
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048184394836426
(317) DESCRIBE `orchid_image` 0.0012640953063965
(318) DESCRIBE `cruiselines` 0.0013360977172852
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029611587524414
(320) DESCRIBE `cruises` 0.0021719932556152
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54856') 0.00036716461181641
(322) DESCRIBE `ships` 0.0021798610687256
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00041580200195312
(324) DESCRIBE `ships` 0.0024359226226807
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00036787986755371
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020599365234375
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(328) DESCRIBE `itineraries` 0.0010199546813965
(329) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '54856') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053715705871582
(330) DESCRIBE `ports` 0.0011239051818848
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0003199577331543
(332) DESCRIBE `ports` 0.0012099742889404
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00035810470581055
(334) DESCRIBE `ports` 0.0010719299316406
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00026297569274902
(336) DESCRIBE `sailingdates` 0.00088691711425781
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '54856') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079917907714844
(338) DESCRIBE `ports` 0.00130295753479
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00032997131347656
(340) DESCRIBE `ports` 0.0010209083557129
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00027012825012207
(342) DESCRIBE `ports` 0.00096607208251953
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00027298927307129
(344) DESCRIBE `ports` 0.00087809562683105
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.0002288818359375
(346) DESCRIBE `ports` 0.00088715553283691
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00025582313537598
(348) DESCRIBE `ports` 0.000885009765625
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00021696090698242
(350) DESCRIBE `ports` 0.0008997917175293
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030183792114258
(352) DESCRIBE `ports` 0.0010178089141846
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00025105476379395
(354) DESCRIBE `ports` 0.00091099739074707
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00043416023254395
(356) DESCRIBE `ports` 0.00099706649780273
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00028014183044434
(358) DESCRIBE `ports` 0.00095200538635254
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 560))) 0.00031208992004395
(360) DESCRIBE `ports` 0.0010809898376465
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '560') 0.00024104118347168
(362) DESCRIBE `ports` 0.00085806846618652
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00028705596923828
(364) DESCRIBE `ports` 0.00095319747924805
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00025200843811035
(366) DESCRIBE `ports` 0.00094509124755859
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0002589225769043
(368) DESCRIBE `ports` 0.00084710121154785
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00022792816162109
(370) DESCRIBE `ports` 0.00082993507385254
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00024104118347168
(372) DESCRIBE `ports` 0.00084114074707031
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00022697448730469
(374) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54856') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.007936954498291
(375) DESCRIBE `avid_specials` 0.0011239051818848
(376) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54856 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.0016028881072998
(377) DESCRIBE `cruiselines` 0.0016109943389893
(378) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034999847412109
(379) DESCRIBE `orchid_image` 0.0011692047119141
(380) DESCRIBE `cruiselines` 0.001345157623291
(381) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00026607513427734
(382) DESCRIBE `cruises` 0.0019128322601318
(383) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67856') 0.00034809112548828
(384) DESCRIBE `ships` 0.0021200180053711
(385) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00053000450134277
(386) DESCRIBE `ships` 0.0022392272949219
(387) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00036907196044922
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(390) DESCRIBE `itineraries` 0.0010871887207031
(391) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67856') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007331371307373
(392) DESCRIBE `ports` 0.0010631084442139
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00027012825012207
(394) DESCRIBE `ports` 0.00093603134155273
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00054192543029785
(396) DESCRIBE `ports` 0.00098490715026855
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00030088424682617
(398) DESCRIBE `sailingdates` 0.0009310245513916
(399) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67856') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077009201049805
(400) DESCRIBE `ports` 0.0012569427490234
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00031805038452148
(402) DESCRIBE `ports` 0.0009160041809082
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00025701522827148
(404) DESCRIBE `ports` 0.00088000297546387
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00027203559875488
(406) DESCRIBE `ports` 0.0011100769042969
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.0003049373626709
(408) DESCRIBE `ports` 0.0010600090026855
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00034284591674805
(410) DESCRIBE `ports` 0.0011329650878906
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00029397010803223
(412) DESCRIBE `ports` 0.0010168552398682
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00035190582275391
(414) DESCRIBE `ports` 0.0010230541229248
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.0002748966217041
(416) DESCRIBE `ports` 0.00096487998962402
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1434))) 0.00030207633972168
(418) DESCRIBE `ports` 0.0010421276092529
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1434') 0.00025391578674316
(420) DESCRIBE `ports` 0.00089001655578613
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4475))) 0.00027918815612793
(422) DESCRIBE `ports` 0.00092411041259766
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4475') 0.00023317337036133
(424) DESCRIBE `ports` 0.00099897384643555
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00032401084899902
(426) DESCRIBE `ports` 0.0010671615600586
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00030207633972168
(428) DESCRIBE `ports` 0.0010318756103516
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00029802322387695
(430) DESCRIBE `ports` 0.0010490417480469
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00033998489379883
(432) DESCRIBE `ports` 0.001086950302124
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.0003199577331543
(434) DESCRIBE `ports` 0.0011000633239746
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00027704238891602
(436) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67856') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0080680847167969
(437) DESCRIBE `avid_specials` 0.0011320114135742
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67856 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0017139911651611
(439) DESCRIBE `cruiselines` 0.0014982223510742
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00041007995605469
(441) DESCRIBE `orchid_image` 0.0011060237884521
(442) DESCRIBE `cruiselines` 0.0014579296112061
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00032711029052734
(444) DESCRIBE `cruises` 0.0024311542510986
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66556') 0.00040292739868164
(446) DESCRIBE `ships` 0.0023181438446045
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00066685676574707
(448) DESCRIBE `ships` 0.0018851757049561
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00025486946105957
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020217895507812
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(452) DESCRIBE `itineraries` 0.0011920928955078
(453) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66556') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058388710021973
(454) DESCRIBE `ports` 0.0010221004486084
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00025486946105957
(456) DESCRIBE `ports` 0.00089097023010254
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00024199485778809
(458) DESCRIBE `ports` 0.0011281967163086
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00020289421081543
(460) DESCRIBE `sailingdates` 0.0005950927734375
(461) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66556') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055909156799316
(462) DESCRIBE `ports` 0.00091099739074707
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029492378234863
(464) DESCRIBE `ports` 0.00080609321594238
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00026917457580566
(466) DESCRIBE `ports` 0.00073504447937012
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0002439022064209
(468) DESCRIBE `ports` 0.0007171630859375
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00022411346435547
(470) DESCRIBE `ports` 0.00084495544433594
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00039100646972656
(472) DESCRIBE `ports` 0.0010089874267578
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00032711029052734
(474) DESCRIBE `ports` 0.00074005126953125
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021481513977051
(476) DESCRIBE `ports` 0.00065088272094727
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00017404556274414
(478) DESCRIBE `ports` 0.00064396858215332
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019502639770508
(480) DESCRIBE `ports` 0.00065803527832031
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017499923706055
(482) DESCRIBE `ports` 0.00061988830566406
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021600723266602
(484) DESCRIBE `ports` 0.00062203407287598
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017404556274414
(486) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66556') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0050580501556396
(487) DESCRIBE `avid_specials` 0.00085711479187012
(488) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66556 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.00091791152954102
(489) DESCRIBE `cruiselines` 0.0011999607086182
(490) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00026106834411621
(491) DESCRIBE `orchid_image` 0.00078511238098145
(492) DESCRIBE `cruiselines` 0.00092506408691406
(493) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020813941955566
(494) DESCRIBE `cruises` 0.0014069080352783
(495) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67828') 0.00028419494628906
(496) DESCRIBE `ships` 0.0013511180877686
(497) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00025796890258789
(498) DESCRIBE `ships` 0.0014369487762451
(499) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00020408630371094
(500) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016117095947266
(501) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(502) DESCRIBE `itineraries` 0.00087404251098633
(503) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67828') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057101249694824
(504) DESCRIBE `ports` 0.001060962677002
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00039005279541016
(506) DESCRIBE `ports` 0.00091314315795898
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00022602081298828
(508) DESCRIBE `ports` 0.00075006484985352
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.00018000602722168
(510) DESCRIBE `sailingdates` 0.00075316429138184
(511) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67828') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054383277893066
(512) DESCRIBE `ports` 0.0010261535644531
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.00028085708618164
(514) DESCRIBE `ports` 0.00073790550231934
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.0001828670501709
(516) DESCRIBE `ports` 0.00092506408691406
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00025200843811035
(518) DESCRIBE `ports` 0.00074195861816406
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00025105476379395
(520) DESCRIBE `ports` 0.00078892707824707
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 191))) 0.0002589225769043
(522) DESCRIBE `ports` 0.00090694427490234
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '191') 0.0002129077911377
(524) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67828') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0067141056060791
(525) DESCRIBE `avid_specials` 0.0010910034179688
(526) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67828 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0016040802001953
(527) DESCRIBE `cruiselines` 0.0014400482177734
(528) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00036382675170898
(529) DESCRIBE `orchid_image` 0.0011920928955078
(530) DESCRIBE `cruiselines` 0.0012991428375244
(531) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028204917907715
(532) DESCRIBE `cruises` 0.001878023147583
(533) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64106') 0.00040602684020996
(534) DESCRIBE `ships` 0.002208948135376
(535) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00049090385437012
(536) DESCRIBE `ships` 0.002018928527832
(537) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00040102005004883
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021219253540039
(539) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001981258392334
(540) DESCRIBE `itineraries` 0.0011579990386963
(541) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64106') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065398216247559
(542) DESCRIBE `ports` 0.0012369155883789
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032901763916016
(544) DESCRIBE `ports` 0.001007080078125
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031781196594238
(546) DESCRIBE `ports` 0.0010170936584473
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028681755065918
(548) DESCRIBE `sailingdates` 0.00091695785522461
(549) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64106') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056791305541992
(550) DESCRIBE `ports` 0.0010359287261963
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00028896331787109
(552) DESCRIBE `ports` 0.00083303451538086
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026512145996094
(554) DESCRIBE `ports` 0.00099706649780273
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00031399726867676
(556) DESCRIBE `ports` 0.0011088848114014
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0002899169921875
(558) DESCRIBE `ports` 0.00097894668579102
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00037002563476562
(560) DESCRIBE `ports` 0.0011510848999023
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00032496452331543
(562) DESCRIBE `ports` 0.0010640621185303
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00028419494628906
(564) DESCRIBE `ports` 0.00095415115356445
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.0002439022064209
(566) DESCRIBE `ports` 0.001007080078125
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00035285949707031
(568) DESCRIBE `ports` 0.0011160373687744
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00030398368835449
(570) DESCRIBE `ports` 0.0010228157043457
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00032496452331543
(572) DESCRIBE `ports` 0.0011439323425293
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00028395652770996
(574) DESCRIBE `ports` 0.0010008811950684
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00031304359436035
(576) DESCRIBE `ports` 0.00099802017211914
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00024700164794922
(578) DESCRIBE `ports` 0.00098514556884766
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00027608871459961
(580) DESCRIBE `ports` 0.00095200538635254
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00026202201843262
(582) DESCRIBE `ports` 0.0010149478912354
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00038313865661621
(584) DESCRIBE `ports` 0.001121997833252
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00032687187194824
(586) DESCRIBE `ports` 0.0010499954223633
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00026297569274902
(588) DESCRIBE `ports` 0.00090503692626953
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00025391578674316
(590) DESCRIBE `ports` 0.0010058879852295
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00033187866210938
(592) DESCRIBE `ports` 0.0010421276092529
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00029182434082031
(594) DESCRIBE `ports` 0.0010020732879639
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00031399726867676
(596) DESCRIBE `ports` 0.00093913078308105
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00024986267089844
(598) DESCRIBE `ports` 0.00092601776123047
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00028395652770996
(600) DESCRIBE `ports` 0.00092101097106934
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00027179718017578
(602) DESCRIBE `ports` 0.001032829284668
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00033903121948242
(604) DESCRIBE `ports` 0.0010488033294678
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00026702880859375
(606) DESCRIBE `ports` 0.00096416473388672
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027608871459961
(608) DESCRIBE `ports` 0.00095105171203613
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026988983154297
(610) DESCRIBE `ports` 0.00093603134155273
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0002899169921875
(612) DESCRIBE `ports` 0.001082181930542
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0003199577331543
(614) DESCRIBE `ports` 0.0010359287261963
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041294097900391
(616) DESCRIBE `ports` 0.0011119842529297
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(618) DESCRIBE `ports` 0.0011029243469238
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034308433532715
(620) DESCRIBE `ports` 0.00097298622131348
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026917457580566
(622) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64106') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0087530612945557
(623) DESCRIBE `avid_specials` 0.001133918762207
(624) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64106 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0017838478088379
(625) DESCRIBE `cruiselines` 0.0015938282012939
(626) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037002563476562
(627) DESCRIBE `orchid_image` 0.0011959075927734
(628) DESCRIBE `cruiselines` 0.001511812210083
(629) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0003049373626709
(630) DESCRIBE `cruises` 0.0020308494567871
(631) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59347') 0.00034594535827637
(632) DESCRIBE `ships` 0.00205397605896
(633) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.0003659725189209
(634) DESCRIBE `ships` 0.0020909309387207
(635) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00030112266540527
(636) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020885467529297
(637) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(638) DESCRIBE `itineraries` 0.0010290145874023
(639) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59347') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007169246673584
(640) DESCRIBE `ports` 0.0011739730834961
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00031518936157227
(642) DESCRIBE `ports` 0.00098109245300293
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00026893615722656
(644) DESCRIBE `ports` 0.00094199180603027
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00024819374084473
(646) DESCRIBE `sailingdates` 0.00081300735473633
(647) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59347') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095105171203613
(648) DESCRIBE `ports` 0.0013740062713623
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032186508178711
(650) DESCRIBE `ports` 0.0009458065032959
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00023889541625977
(652) DESCRIBE `ports` 0.00095915794372559
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00028705596923828
(654) DESCRIBE `ports` 0.00095701217651367
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00024104118347168
(656) DESCRIBE `ports` 0.00095915794372559
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00026202201843262
(658) DESCRIBE `ports` 0.00094890594482422
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00025701522827148
(660) DESCRIBE `ports` 0.00094699859619141
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00026988983154297
(662) DESCRIBE `ports` 0.0012071132659912
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0002739429473877
(664) DESCRIBE `ports` 0.00092291831970215
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0002741813659668
(666) DESCRIBE `ports` 0.00096893310546875
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00025200843811035
(668) DESCRIBE `ports` 0.00093507766723633
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00031089782714844
(670) DESCRIBE `ports` 0.00093793869018555
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00024104118347168
(672) DESCRIBE `ports` 0.00093507766723633
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0002598762512207
(674) DESCRIBE `ports` 0.00090885162353516
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00023698806762695
(676) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59347') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0082530975341797
(677) DESCRIBE `avid_specials` 0.00099301338195801
(678) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59347 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.00092005729675293
(679) DESCRIBE `cruiselines` 0.0011191368103027
(680) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00028204917907715
(681) DESCRIBE `orchid_image` 0.00077700614929199
(682) DESCRIBE `cruiselines` 0.00086379051208496
(683) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019001960754395
(684) DESCRIBE `ships` 0.0014550685882568
(685) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '542', '1135', '434', '1021', '290', '348', '678', '451', '580', '253', '291', '98', '406', '341', '105', '1409')) ORDER BY FIND_IN_SET(id, '349,542,1135,434,1021,290,348,678,451,580,253,291,98,406,341,105,1409') 0.00075697898864746
(686) DESCRIBE `cruisetypes` 0.00066995620727539
(687) DESCRIBE `destinations` 0.0011839866638184
(688) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '35', '22', '26', '12', '21', '40', '34', '43', '48', '8', '11', '38', '25', '53', '29', '49', '28')) ORDER BY FIND_IN_SET(id, '2,35,22,26,12,21,40,34,43,48,8,11,38,25,53,29,49,28') 0.0008549690246582
(689) DESCRIBE `cruiselines` 0.00092101097106934
(690) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021696090698242
(691) DESCRIBE `cruiselines` 0.00088810920715332
(692) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00019693374633789