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

Total elapsed time: 0.40365648269653

# Query Time
(1) connect 0.00060319900512695
(2) DESCRIBE `cruises` 0.0017299652099609
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62661, 62666, 70236, 62662, 70352, 68527, 62667, 64926, 67961, 62663)) ORDER BY FIND_IN_SET(id, '62661,62666,70236,62662,70352,68527,62667,64926,67961,62663') 0.0016288757324219
(4) DESCRIBE `cruises` 0.001629114151001
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00024509429931641
(6) DESCRIBE `ships` 0.0013020038604736
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00027585029602051
(8) DESCRIBE `ships` 0.001338005065918
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00020813941955566
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(12) DESCRIBE `itineraries` 0.00069904327392578
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059700012207031
(14) DESCRIBE `ports` 0.00081992149353027
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00027203559875488
(16) DESCRIBE `ports` 0.00068998336791992
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0002288818359375
(18) DESCRIBE `ports` 0.00068283081054688
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00019502639770508
(20) DESCRIBE `sailingdates` 0.00061893463134766
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62661') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0008690357208252
(22) DESCRIBE `ports` 0.0014328956604004
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034403800964355
(24) DESCRIBE `ports` 0.00097799301147461
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00024199485778809
(26) DESCRIBE `ports` 0.00088214874267578
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024104118347168
(28) DESCRIBE `ports` 0.00072598457336426
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019407272338867
(30) DESCRIBE `ports` 0.00072598457336426
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021100044250488
(32) DESCRIBE `ports` 0.0006861686706543
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00019216537475586
(34) DESCRIBE `ports` 0.00071310997009277
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00025296211242676
(36) DESCRIBE `ports` 0.00068402290344238
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018882751464844
(38) DESCRIBE `ports` 0.00068092346191406
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021195411682129
(40) DESCRIBE `ports` 0.00067710876464844
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001828670501709
(42) DESCRIBE `ports` 0.00067019462585449
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020694732666016
(44) DESCRIBE `ports` 0.00068187713623047
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021791458129883
(46) DESCRIBE `ports` 0.00070595741271973
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021696090698242
(48) DESCRIBE `ports` 0.00068497657775879
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018906593322754
(50) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62661') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0053210258483887
(51) DESCRIBE `avid_specials` 0.0009150505065918
(52) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.00097393989562988
(53) DESCRIBE `cruiselines` 0.0010671615600586
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025105476379395
(55) DESCRIBE `orchid_image` 0.00079607963562012
(56) DESCRIBE `cruiselines` 0.00098395347595215
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00024509429931641
(58) DESCRIBE `cruises` 0.0015420913696289
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62666') 0.00030899047851562
(60) DESCRIBE `ships` 0.0015311241149902
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00026607513427734
(62) DESCRIBE `ships` 0.0013680458068848
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00020885467529297
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022482872009277
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(66) DESCRIBE `itineraries` 0.0011050701141357
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62666') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056314468383789
(68) DESCRIBE `ports` 0.00078582763671875
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024700164794922
(70) DESCRIBE `ports` 0.00067591667175293
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019407272338867
(72) DESCRIBE `ports` 0.00067400932312012
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020790100097656
(74) DESCRIBE `sailingdates` 0.00063991546630859
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62666') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069093704223633
(76) DESCRIBE `ports` 0.00094199180603027
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025296211242676
(78) DESCRIBE `ports` 0.00067996978759766
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019311904907227
(80) DESCRIBE `ports` 0.00077080726623535
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020313262939453
(82) DESCRIBE `ports` 0.00068092346191406
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018596649169922
(84) DESCRIBE `ports` 0.0006718635559082
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00020408630371094
(86) DESCRIBE `ports` 0.00083589553833008
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0001838207244873
(88) DESCRIBE `ports` 0.00069403648376465
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020694732666016
(90) DESCRIBE `ports` 0.00071620941162109
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018692016601562
(92) DESCRIBE `ports` 0.00072216987609863
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002140998840332
(94) DESCRIBE `ports` 0.00070881843566895
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018882751464844
(96) DESCRIBE `ports` 0.00068998336791992
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00021219253540039
(98) DESCRIBE `ports` 0.00067687034606934
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018501281738281
(100) DESCRIBE `ports` 0.00071382522583008
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0002140998840332
(102) DESCRIBE `ports` 0.00067281723022461
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018310546875
(104) DESCRIBE `ports` 0.0006721019744873
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020909309387207
(106) DESCRIBE `ports` 0.00070309638977051
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022506713867188
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62666') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0053379535675049
(109) DESCRIBE `avid_specials` 0.00086379051208496
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62666 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0010080337524414
(111) DESCRIBE `cruiselines` 0.0010781288146973
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024199485778809
(113) DESCRIBE `orchid_image` 0.00077319145202637
(114) DESCRIBE `cruiselines` 0.00098705291748047
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020194053649902
(116) DESCRIBE `cruises` 0.0020639896392822
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70236') 0.00037884712219238
(118) DESCRIBE `ships` 0.0021700859069824
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00043106079101562
(120) DESCRIBE `ships` 0.0022919178009033
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00037097930908203
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023198127746582
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021791458129883
(124) DESCRIBE `itineraries` 0.0012221336364746
(125) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087499618530273
(126) DESCRIBE `ports` 0.0013577938079834
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00039005279541016
(128) DESCRIBE `ports` 0.0010688304901123
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00026988983154297
(130) DESCRIBE `ports` 0.00090718269348145
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00024700164794922
(132) DESCRIBE `sailingdates` 0.00082302093505859
(133) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075507164001465
(134) DESCRIBE `ports` 0.001107931137085
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00032305717468262
(136) DESCRIBE `ports` 0.00098490715026855
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00026106834411621
(138) DESCRIBE `ports` 0.00093197822570801
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00035309791564941
(140) DESCRIBE `ports` 0.000946044921875
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00024795532226562
(142) DESCRIBE `ports` 0.00091195106506348
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00029420852661133
(144) DESCRIBE `ports` 0.00092697143554688
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00023794174194336
(146) DESCRIBE `ports` 0.00095105171203613
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00026488304138184
(148) DESCRIBE `ports` 0.00092697143554688
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00024104118347168
(150) DESCRIBE `ports` 0.0009000301361084
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.0002751350402832
(152) DESCRIBE `ports` 0.001162052154541
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00036191940307617
(154) DESCRIBE `ports` 0.0010898113250732
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00027799606323242
(156) DESCRIBE `ports` 0.00094294548034668
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00024604797363281
(158) DESCRIBE `ports` 0.00097513198852539
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00027799606323242
(160) DESCRIBE `ports` 0.00092697143554688
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00024604797363281
(162) DESCRIBE `ports` 0.00094699859619141
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00028800964355469
(164) DESCRIBE `ports` 0.00092411041259766
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00028896331787109
(166) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70236') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0095820426940918
(167) DESCRIBE `avid_specials` 0.0010581016540527
(168) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70236 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 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.001568078994751
(169) DESCRIBE `cruiselines` 0.0016021728515625
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00029206275939941
(171) DESCRIBE `orchid_image` 0.0011799335479736
(172) DESCRIBE `cruiselines` 0.0014128684997559
(173) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002748966217041
(174) DESCRIBE `cruises` 0.0020670890808105
(175) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62662') 0.0003359317779541
(176) DESCRIBE `ships` 0.002187967300415
(177) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00045895576477051
(178) DESCRIBE `ships` 0.0023789405822754
(179) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00038409233093262
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023412704467773
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(182) DESCRIBE `itineraries` 0.00088906288146973
(183) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62662') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045299530029297
(184) DESCRIBE `ports` 0.00088000297546387
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033020973205566
(186) DESCRIBE `ports` 0.0010950565338135
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029301643371582
(188) DESCRIBE `ports` 0.0010778903961182
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00025105476379395
(190) DESCRIBE `sailingdates` 0.00089597702026367
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62662') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00098204612731934
(192) DESCRIBE `ports` 0.0014059543609619
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035500526428223
(194) DESCRIBE `ports` 0.00088000297546387
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00021004676818848
(196) DESCRIBE `ports` 0.00074601173400879
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021815299987793
(198) DESCRIBE `ports` 0.00068902969360352
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0002140998840332
(200) DESCRIBE `ports` 0.00069212913513184
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00024104118347168
(202) DESCRIBE `ports` 0.00071096420288086
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00019693374633789
(204) DESCRIBE `ports` 0.00074291229248047
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020694732666016
(206) DESCRIBE `ports` 0.00067901611328125
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018620491027832
(208) DESCRIBE `ports` 0.00072097778320312
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002138614654541
(210) DESCRIBE `ports` 0.00073480606079102
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019311904907227
(212) DESCRIBE `ports` 0.00068187713623047
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021886825561523
(214) DESCRIBE `ports` 0.00077486038208008
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00019383430480957
(216) DESCRIBE `ports` 0.00069117546081543
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021791458129883
(218) DESCRIBE `ports` 0.00068306922912598
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019001960754395
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62662') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0056140422821045
(221) DESCRIBE `avid_specials` 0.0009458065032959
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0011119842529297
(223) DESCRIBE `cruiselines` 0.0010030269622803
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023603439331055
(225) DESCRIBE `orchid_image` 0.00080585479736328
(226) DESCRIBE `cruiselines` 0.00094985961914062
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00022292137145996
(228) DESCRIBE `cruises` 0.0014359951019287
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70352') 0.00024199485778809
(230) DESCRIBE `ships` 0.001446008682251
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00027704238891602
(232) DESCRIBE `ships` 0.0012891292572021
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00020289421081543
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(236) DESCRIBE `itineraries` 0.00075197219848633
(237) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70352') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058889389038086
(238) DESCRIBE `ports` 0.00088405609130859
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00024199485778809
(240) DESCRIBE `ports` 0.00079989433288574
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020003318786621
(242) DESCRIBE `ports` 0.00072908401489258
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00019121170043945
(244) DESCRIBE `sailingdates` 0.0006871223449707
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70352') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006251335144043
(246) DESCRIBE `ports` 0.0011141300201416
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00025200843811035
(248) DESCRIBE `ports` 0.00078392028808594
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00019097328186035
(250) DESCRIBE `ports` 0.00068187713623047
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00020289421081543
(252) DESCRIBE `ports` 0.00070691108703613
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00020408630371094
(254) DESCRIBE `ports` 0.00073385238647461
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1761))) 0.00020599365234375
(256) DESCRIBE `ports` 0.00068020820617676
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1761') 0.00019598007202148
(258) DESCRIBE `ports` 0.0006859302520752
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00022315979003906
(260) DESCRIBE `ports` 0.00087308883666992
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0002138614654541
(262) DESCRIBE `ports` 0.0007331371307373
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2870))) 0.00020885467529297
(264) DESCRIBE `ports` 0.00073003768920898
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2870') 0.00018000602722168
(266) DESCRIBE `ports` 0.00068116188049316
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00023603439331055
(268) DESCRIBE `ports` 0.0009911060333252
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00020599365234375
(270) DESCRIBE `ports` 0.00069499015808105
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00023698806762695
(272) DESCRIBE `ports` 0.00091099739074707
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018715858459473
(274) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70352') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0066258907318115
(275) DESCRIBE `avid_specials` 0.00094795227050781
(276) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70352 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0010030269622803
(277) DESCRIBE `cruiselines` 0.0010230541229248
(278) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002288818359375
(279) DESCRIBE `orchid_image` 0.00077199935913086
(280) DESCRIBE `cruiselines` 0.0010228157043457
(281) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002138614654541
(282) DESCRIBE `cruises` 0.0020620822906494
(283) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68527') 0.00039887428283691
(284) DESCRIBE `ships` 0.0023119449615479
(285) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00041890144348145
(286) DESCRIBE `ships` 0.0023229122161865
(287) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.0003359317779541
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023508071899414
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024294853210449
(290) DESCRIBE `itineraries` 0.00094795227050781
(291) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68527') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080513954162598
(292) DESCRIBE `ports` 0.001305103302002
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032401084899902
(294) DESCRIBE `ports` 0.0010280609130859
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027799606323242
(296) DESCRIBE `ports` 0.001025915145874
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020694732666016
(298) DESCRIBE `sailingdates` 0.00078201293945312
(299) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68527') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057387351989746
(300) DESCRIBE `ports` 0.00086212158203125
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023198127746582
(302) DESCRIBE `ports` 0.00068497657775879
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020289421081543
(304) DESCRIBE `ports` 0.00068783760070801
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022697448730469
(306) DESCRIBE `ports` 0.00070810317993164
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017809867858887
(308) DESCRIBE `ports` 0.00066590309143066
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00019693374633789
(310) DESCRIBE `ports` 0.00068998336791992
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017595291137695
(312) DESCRIBE `ports` 0.00070500373840332
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023317337036133
(314) DESCRIBE `ports` 0.00076603889465332
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022721290588379
(316) DESCRIBE `ports` 0.00073909759521484
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00026583671569824
(318) DESCRIBE `ports` 0.00074315071105957
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00018405914306641
(320) DESCRIBE `ports` 0.00069618225097656
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.0001981258392334
(322) DESCRIBE `ports` 0.00074315071105957
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00018811225891113
(324) DESCRIBE `ports` 0.00082993507385254
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00025701522827148
(326) DESCRIBE `ports` 0.0010499954223633
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00026202201843262
(328) DESCRIBE `ports` 0.00073909759521484
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00021481513977051
(330) DESCRIBE `ports` 0.0006861686706543
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00019383430480957
(332) DESCRIBE `ports` 0.00067615509033203
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(334) DESCRIBE `ports` 0.0007481575012207
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(336) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68527') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0053319931030273
(337) DESCRIBE `avid_specials` 0.0010750293731689
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68527 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.00097393989562988
(339) DESCRIBE `cruiselines` 0.0010409355163574
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032210350036621
(341) DESCRIBE `orchid_image` 0.0012960433959961
(342) DESCRIBE `cruiselines` 0.0011651515960693
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023794174194336
(344) DESCRIBE `cruises` 0.001331090927124
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62667') 0.0002748966217041
(346) DESCRIBE `ships` 0.0013818740844727
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00029206275939941
(348) DESCRIBE `ships` 0.001878023147583
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00025677680969238
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002291202545166
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023007392883301
(352) DESCRIBE `itineraries` 0.00084710121154785
(353) DESCRIBE `ports` 0.00081515312194824
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00025606155395508
(355) DESCRIBE `ports` 0.00082015991210938
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020313262939453
(357) DESCRIBE `ports` 0.000701904296875
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019288063049316
(359) DESCRIBE `sailingdates` 0.0006108283996582
(360) DESCRIBE `ports` 0.00091791152954102
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00024986267089844
(362) DESCRIBE `ports` 0.00069999694824219
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019502639770508
(364) DESCRIBE `ports` 0.00076079368591309
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00020503997802734
(366) DESCRIBE `ports` 0.00069117546081543
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0001838207244873
(368) DESCRIBE `ports` 0.00068116188049316
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001990795135498
(370) DESCRIBE `ports` 0.00067591667175293
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00023198127746582
(372) DESCRIBE `ports` 0.00072598457336426
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021982192993164
(374) DESCRIBE `ports` 0.00074577331542969
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020289421081543
(376) DESCRIBE `ports` 0.00068902969360352
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00021004676818848
(378) DESCRIBE `ports` 0.0007328987121582
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00020003318786621
(380) DESCRIBE `ports` 0.00071096420288086
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021982192993164
(382) DESCRIBE `ports` 0.00069499015808105
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00019311904907227
(384) DESCRIBE `ports` 0.00092411041259766
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(386) DESCRIBE `ports` 0.00067520141601562
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001978874206543
(388) DESCRIBE `ports` 0.00069117546081543
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00023794174194336
(390) DESCRIBE `ports` 0.00070095062255859
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018191337585449
(392) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62667') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0052850246429443
(393) DESCRIBE `avid_specials` 0.00091195106506348
(394) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62667 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.00097489356994629
(395) DESCRIBE `cruiselines` 0.0010139942169189
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026202201843262
(397) DESCRIBE `orchid_image` 0.00076699256896973
(398) DESCRIBE `cruiselines` 0.00092506408691406
(399) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019693374633789
(400) DESCRIBE `cruises` 0.0013210773468018
(401) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64926') 0.00023722648620605
(402) DESCRIBE `ships` 0.0014238357543945
(403) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00037407875061035
(404) DESCRIBE `ships` 0.0016148090362549
(405) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00025296211242676
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(408) DESCRIBE `itineraries` 0.0009000301361084
(409) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64926') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060009956359863
(410) DESCRIBE `ports` 0.00071406364440918
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00022196769714355
(412) DESCRIBE `ports` 0.00081992149353027
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00025296211242676
(414) DESCRIBE `ports` 0.00068187713623047
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00018715858459473
(416) DESCRIBE `sailingdates` 0.00074005126953125
(417) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64926') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071287155151367
(418) DESCRIBE `ports` 0.00092697143554688
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00027012825012207
(420) DESCRIBE `ports` 0.00093579292297363
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00023198127746582
(422) DESCRIBE `ports` 0.00074410438537598
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00020408630371094
(424) DESCRIBE `ports` 0.00068211555480957
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00018501281738281
(426) DESCRIBE `ports` 0.00078511238098145
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00020408630371094
(428) DESCRIBE `ports` 0.00067806243896484
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0002140998840332
(430) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64926') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0063049793243408
(431) DESCRIBE `avid_specials` 0.00092291831970215
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64926 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.001039981842041
(433) DESCRIBE `cruiselines` 0.0010080337524414
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023508071899414
(435) DESCRIBE `orchid_image` 0.00081491470336914
(436) DESCRIBE `cruiselines` 0.0010900497436523
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00023603439331055
(438) DESCRIBE `cruises` 0.0020217895507812
(439) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67961') 0.0004279613494873
(440) DESCRIBE `ships` 0.002039909362793
(441) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00042295455932617
(442) DESCRIBE `ships` 0.0023221969604492
(443) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.0003819465637207
(444) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(445) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022602081298828
(446) DESCRIBE `itineraries` 0.001183032989502
(447) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67961') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.000762939453125
(448) DESCRIBE `ports` 0.0011658668518066
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00031518936157227
(450) DESCRIBE `ports` 0.0010058879852295
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00026202201843262
(452) DESCRIBE `ports` 0.00099778175354004
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00023603439331055
(454) DESCRIBE `sailingdates` 0.00091695785522461
(455) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67961') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072479248046875
(456) DESCRIBE `ports` 0.0011038780212402
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00028204917907715
(458) DESCRIBE `ports` 0.00098299980163574
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00023794174194336
(460) DESCRIBE `ports` 0.00097417831420898
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026202201843262
(462) DESCRIBE `ports` 0.00099802017211914
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027108192443848
(464) DESCRIBE `ports` 0.00099492073059082
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00026702880859375
(466) DESCRIBE `ports` 0.00098299980163574
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00024199485778809
(468) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67961') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0089738368988037
(469) DESCRIBE `avid_specials` 0.001162052154541
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67961 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0016169548034668
(471) DESCRIBE `cruiselines` 0.0014028549194336
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030994415283203
(473) DESCRIBE `orchid_image` 0.0011670589447021
(474) DESCRIBE `cruiselines` 0.0015270709991455
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032806396484375
(476) DESCRIBE `cruises` 0.0020878314971924
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00030899047851562
(478) DESCRIBE `ships` 0.0017828941345215
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00036096572875977
(480) DESCRIBE `ships` 0.0017669200897217
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00025200843811035
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021481513977051
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(484) DESCRIBE `itineraries` 0.00092911720275879
(485) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62663') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048208236694336
(486) DESCRIBE `ports` 0.001082181930542
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00024294853210449
(488) DESCRIBE `ports` 0.00076603889465332
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00025701522827148
(490) DESCRIBE `ports` 0.00077104568481445
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00020599365234375
(492) DESCRIBE `sailingdates` 0.00062704086303711
(493) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62663') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063395500183105
(494) DESCRIBE `ports` 0.00092720985412598
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00028610229492188
(496) DESCRIBE `ports` 0.00076889991760254
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0001978874206543
(498) DESCRIBE `ports` 0.00069808959960938
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020599365234375
(500) DESCRIBE `ports` 0.00086808204650879
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00024008750915527
(502) DESCRIBE `ports` 0.00099515914916992
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028109550476074
(504) DESCRIBE `ports` 0.00096487998962402
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023198127746582
(506) DESCRIBE `ports` 0.00089287757873535
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002598762512207
(508) DESCRIBE `ports` 0.0009009838104248
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021004676818848
(510) DESCRIBE `ports` 0.00077104568481445
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020813941955566
(512) DESCRIBE `ports` 0.00068092346191406
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018715858459473
(514) DESCRIBE `ports` 0.00067281723022461
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020289421081543
(516) DESCRIBE `ports` 0.00073003768920898
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019693374633789
(518) DESCRIBE `ports` 0.00073695182800293
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0002138614654541
(520) DESCRIBE `ports` 0.00068998336791992
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00019407272338867
(522) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62663') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0065460205078125
(523) DESCRIBE `avid_specials` 0.001147985458374
(524) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62663 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0011451244354248
(525) DESCRIBE `cruiselines` 0.0010478496551514
(526) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.000244140625
(527) DESCRIBE `orchid_image` 0.00085091590881348
(528) DESCRIBE `cruiselines` 0.0010619163513184
(529) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002129077911377
(530) DESCRIBE `ships` 0.0015668869018555
(531) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '407', '1067', '726', '452', '766', '1588', '462', '553', '1415', '352', '610', '674', '738', '1599')) ORDER BY FIND_IN_SET(id, '977,1359,407,1067,726,452,766,1588,462,553,1415,352,610,674,738,1599') 0.00092792510986328
(532) DESCRIBE `cruisetypes` 0.00092601776123047
(533) DESCRIBE `destinations` 0.00096988677978516
(534) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '28', '25', '26', '52', '45', '38', '40', '35', '21', '49', '37')) ORDER BY FIND_IN_SET(id, '22,12,28,25,26,52,45,38,40,35,21,49,37') 0.00085210800170898
(535) DESCRIBE `cruiselines` 0.0012860298156738
(536) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026917457580566
(537) DESCRIBE `cruiselines` 0.0018541812896729
(538) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00029706954956055