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

Total elapsed time: 0.37200927734375

# Query Time
(1) connect 0.00056695938110352
(2) DESCRIBE `cruises` 0.0022439956665039
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41777, 63400, 57652, 63459, 41776, 63399, 63458, 63372, 63405, 63370)) ORDER BY FIND_IN_SET(id, '41777,63400,57652,63459,41776,63399,63458,63372,63405,63370') 0.0011579990386963
(4) DESCRIBE `cruises` 0.0015280246734619
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41777') 0.00025391578674316
(6) DESCRIBE `ships` 0.0012469291687012
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00027990341186523
(8) DESCRIBE `ships` 0.0012578964233398
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00021696090698242
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016093254089355
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015115737915039
(12) DESCRIBE `itineraries` 0.00065898895263672
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41777') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070977210998535
(14) DESCRIBE `ports` 0.0011041164398193
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024294853210449
(16) DESCRIBE `ports` 0.00068807601928711
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018596649169922
(18) DESCRIBE `ports` 0.00060009956359863
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001828670501709
(20) DESCRIBE `sailingdates` 0.00061297416687012
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41777') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00065779685974121
(22) DESCRIBE `ports` 0.00083804130554199
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002291202545166
(24) DESCRIBE `ports` 0.00060200691223145
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022792816162109
(26) DESCRIBE `ports` 0.0006101131439209
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00020599365234375
(28) DESCRIBE `ports` 0.0006260871887207
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0001828670501709
(30) DESCRIBE `ports` 0.00062298774719238
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0001990795135498
(32) DESCRIBE `ports` 0.00064802169799805
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00016999244689941
(34) DESCRIBE `ports` 0.00059294700622559
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(36) DESCRIBE `ports` 0.00063204765319824
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016999244689941
(38) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41777') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0065951347351074
(39) DESCRIBE `avid_specials` 0.00083494186401367
(40) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41777 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.00094294548034668
(41) DESCRIBE `cruiselines` 0.001021146774292
(42) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025701522827148
(43) DESCRIBE `orchid_image` 0.00081110000610352
(44) DESCRIBE `cruiselines` 0.00088095664978027
(45) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021004676818848
(46) DESCRIBE `cruises` 0.0021240711212158
(47) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63400') 0.00033092498779297
(48) DESCRIBE `ships` 0.0018510818481445
(49) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00033688545227051
(50) DESCRIBE `ships` 0.0018711090087891
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00043296813964844
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020694732666016
(54) DESCRIBE `itineraries` 0.0010530948638916
(55) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63400') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055193901062012
(56) DESCRIBE `ports` 0.0010280609130859
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00028800964355469
(58) DESCRIBE `ports` 0.00090694427490234
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00024008750915527
(60) DESCRIBE `ports` 0.00092411041259766
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00021815299987793
(62) DESCRIBE `sailingdates` 0.00075912475585938
(63) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63400') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069284439086914
(64) DESCRIBE `ports` 0.0010371208190918
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029897689819336
(66) DESCRIBE `ports` 0.00087094306945801
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00022602081298828
(68) DESCRIBE `ports` 0.00086402893066406
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00024294853210449
(70) DESCRIBE `ports` 0.00072002410888672
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017714500427246
(72) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63400') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0073139667510986
(73) DESCRIBE `avid_specials` 0.00099682807922363
(74) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63400 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0014982223510742
(75) DESCRIBE `cruiselines` 0.0013160705566406
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00029587745666504
(77) DESCRIBE `orchid_image` 0.00095987319946289
(78) DESCRIBE `cruiselines` 0.0012009143829346
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026106834411621
(80) DESCRIBE `cruises` 0.0016238689422607
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57652') 0.00026202201843262
(82) DESCRIBE `ships` 0.0015840530395508
(83) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00029802322387695
(84) DESCRIBE `ships` 0.0015749931335449
(85) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002291202545166
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017881393432617
(88) DESCRIBE `itineraries` 0.00084400177001953
(89) DESCRIBE `ports` 0.00068187713623047
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020503997802734
(91) DESCRIBE `ports` 0.0006098747253418
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017714500427246
(93) DESCRIBE `ports` 0.00058388710021973
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016498565673828
(95) DESCRIBE `sailingdates` 0.00052499771118164
(96) DESCRIBE `ports` 0.00058794021606445
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001828670501709
(98) DESCRIBE `ports` 0.00058102607727051
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00015902519226074
(100) DESCRIBE `ports` 0.00057888031005859
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00017189979553223
(102) DESCRIBE `ports` 0.00057506561279297
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00016593933105469
(104) DESCRIBE `ports` 0.00058412551879883
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00017786026000977
(106) DESCRIBE `ports` 0.00058507919311523
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00015497207641602
(108) DESCRIBE `ports` 0.00064301490783691
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020289421081543
(110) DESCRIBE `ports` 0.00067806243896484
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00015783309936523
(112) DESCRIBE `ports` 0.00058102607727051
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00017881393432617
(114) DESCRIBE `ports` 0.00059413909912109
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00015497207641602
(116) DESCRIBE `ports` 0.00058221817016602
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0001680850982666
(118) DESCRIBE `ports` 0.00058603286743164
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018000602722168
(120) DESCRIBE `ports` 0.00060415267944336
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017714500427246
(122) DESCRIBE `ports` 0.00060009956359863
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016307830810547
(124) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57652') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0061800479888916
(125) DESCRIBE `avid_specials` 0.00078701972961426
(126) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57652 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.00093889236450195
(127) DESCRIBE `cruiselines` 0.00088596343994141
(128) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00020384788513184
(129) DESCRIBE `orchid_image` 0.00064921379089355
(130) DESCRIBE `cruiselines` 0.0008552074432373
(131) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00016903877258301
(132) DESCRIBE `cruises` 0.0011379718780518
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63459') 0.00017905235290527
(134) DESCRIBE `ships` 0.0011329650878906
(135) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0002129077911377
(136) DESCRIBE `ships` 0.0011000633239746
(137) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00015807151794434
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014591217041016
(140) DESCRIBE `itineraries` 0.00085186958312988
(141) DESCRIBE `ports` 0.00089693069458008
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00026297569274902
(143) DESCRIBE `ports` 0.00084710121154785
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002291202545166
(145) DESCRIBE `ports` 0.00081300735473633
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00021004676818848
(147) DESCRIBE `sailingdates` 0.00072097778320312
(148) DESCRIBE `ports` 0.0010008811950684
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00027108192443848
(150) DESCRIBE `ports` 0.00084590911865234
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002591609954834
(152) DESCRIBE `ports` 0.00074291229248047
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022292137145996
(154) DESCRIBE `ports` 0.00083208084106445
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023603439331055
(156) DESCRIBE `ports` 0.00092577934265137
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00025701522827148
(158) DESCRIBE `ports` 0.00087189674377441
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00017309188842773
(160) DESCRIBE `ports` 0.00060200691223145
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00019979476928711
(162) DESCRIBE `ports` 0.00059103965759277
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018596649169922
(164) DESCRIBE `ports` 0.00059795379638672
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018191337585449
(166) DESCRIBE `ports` 0.00059294700622559
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00015997886657715
(168) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63459') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0044310092926025
(169) DESCRIBE `avid_specials` 0.00070595741271973
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63459 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.00086092948913574
(171) DESCRIBE `cruiselines` 0.00086712837219238
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00020313262939453
(173) DESCRIBE `orchid_image` 0.00066685676574707
(174) DESCRIBE `cruiselines` 0.00082206726074219
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00017690658569336
(176) DESCRIBE `cruises` 0.0015130043029785
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00030422210693359
(178) DESCRIBE `ships` 0.0017659664154053
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00026297569274902
(180) DESCRIBE `ships` 0.0011579990386963
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00017690658569336
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015783309936523
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(184) DESCRIBE `itineraries` 0.00071406364440918
(185) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046014785766602
(186) DESCRIBE `ports` 0.00063705444335938
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020503997802734
(188) DESCRIBE `ports` 0.00060582160949707
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017404556274414
(190) DESCRIBE `ports` 0.00058817863464355
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016498565673828
(192) DESCRIBE `sailingdates` 0.00058388710021973
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41776') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006101131439209
(194) DESCRIBE `ports` 0.00066804885864258
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019001960754395
(196) DESCRIBE `ports` 0.00059986114501953
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00015783309936523
(198) DESCRIBE `ports` 0.00058293342590332
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00017619132995605
(200) DESCRIBE `ports` 0.00062298774719238
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00015687942504883
(202) DESCRIBE `ports` 0.00058794021606445
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00016999244689941
(204) DESCRIBE `ports` 0.00058102607727051
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00015401840209961
(206) DESCRIBE `ports` 0.00058603286743164
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00017905235290527
(208) DESCRIBE `ports` 0.00058197975158691
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00015687942504883
(210) DESCRIBE `ports` 0.00080013275146484
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021886825561523
(212) DESCRIBE `ports` 0.00077581405639648
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(214) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41776') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0075929164886475
(215) DESCRIBE `avid_specials` 0.00084304809570312
(216) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.00090217590332031
(217) DESCRIBE `cruiselines` 0.00092005729675293
(218) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023293495178223
(219) DESCRIBE `orchid_image` 0.00068402290344238
(220) DESCRIBE `cruiselines` 0.00088000297546387
(221) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0001981258392334
(222) DESCRIBE `cruises` 0.0019021034240723
(223) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63399') 0.00032711029052734
(224) DESCRIBE `ships` 0.0019268989562988
(225) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00039410591125488
(226) DESCRIBE `ships` 0.0020570755004883
(227) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00033903121948242
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020313262939453
(230) DESCRIBE `itineraries` 0.0010838508605957
(231) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63399') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047993659973145
(232) DESCRIBE `ports` 0.0011610984802246
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030088424682617
(234) DESCRIBE `ports` 0.00082898139953613
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029492378234863
(236) DESCRIBE `ports` 0.0011298656463623
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002129077911377
(238) DESCRIBE `sailingdates` 0.0005800724029541
(239) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63399') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041794776916504
(240) DESCRIBE `ports` 0.0007481575012207
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00022602081298828
(242) DESCRIBE `ports` 0.00067496299743652
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0001680850982666
(244) DESCRIBE `ports` 0.0005950927734375
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00018215179443359
(246) DESCRIBE `ports` 0.00060486793518066
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00015807151794434
(248) DESCRIBE `ports` 0.00058579444885254
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00019097328186035
(250) DESCRIBE `ports` 0.00059890747070312
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00016903877258301
(252) DESCRIBE `ports` 0.00068402290344238
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001981258392334
(254) DESCRIBE `ports` 0.00082707405090332
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023603439331055
(256) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63399') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0059399604797363
(257) DESCRIBE `avid_specials` 0.00086593627929688
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63399 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0015079975128174
(259) DESCRIBE `cruiselines` 0.0014548301696777
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033402442932129
(261) DESCRIBE `orchid_image` 0.00097393989562988
(262) DESCRIBE `cruiselines` 0.0012900829315186
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026893615722656
(264) DESCRIBE `cruises` 0.0020999908447266
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63458') 0.00038599967956543
(266) DESCRIBE `ships` 0.0021131038665771
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00045895576477051
(268) DESCRIBE `ships` 0.0021460056304932
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00029110908508301
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016093254089355
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(272) DESCRIBE `itineraries` 0.00077509880065918
(273) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63458') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049209594726562
(274) DESCRIBE `ports` 0.00095891952514648
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028300285339355
(276) DESCRIBE `ports` 0.0011050701141357
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027894973754883
(278) DESCRIBE `ports` 0.00062799453735352
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016999244689941
(280) DESCRIBE `sailingdates` 0.00057101249694824
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63458') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038385391235352
(282) DESCRIBE `ports` 0.00081300735473633
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021910667419434
(284) DESCRIBE `ports` 0.00074219703674316
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(286) DESCRIBE `ports` 0.00074315071105957
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00017905235290527
(288) DESCRIBE `ports` 0.00065708160400391
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00015497207641602
(290) DESCRIBE `ports` 0.00064301490783691
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00022602081298828
(292) DESCRIBE `ports` 0.00085711479187012
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00020599365234375
(294) DESCRIBE `ports` 0.00081396102905273
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00017499923706055
(296) DESCRIBE `ports` 0.00058388710021973
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00015497207641602
(298) DESCRIBE `ports` 0.00059008598327637
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00017404556274414
(300) DESCRIBE `ports` 0.00083804130554199
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00021481513977051
(302) DESCRIBE `ports` 0.00086688995361328
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026202201843262
(304) DESCRIBE `ports` 0.00079798698425293
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(306) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63458') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0089550018310547
(307) DESCRIBE `avid_specials` 0.00090503692626953
(308) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63458 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0014679431915283
(309) DESCRIBE `cruiselines` 0.0011870861053467
(310) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025510787963867
(311) DESCRIBE `orchid_image` 0.00088191032409668
(312) DESCRIBE `cruiselines` 0.0012400150299072
(313) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00023293495178223
(314) DESCRIBE `cruises` 0.0015649795532227
(315) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63372') 0.00024795532226562
(316) DESCRIBE `ships` 0.0015928745269775
(317) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00028204917907715
(318) DESCRIBE `ships` 0.0014598369598389
(319) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00019598007202148
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018882751464844
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(322) DESCRIBE `itineraries` 0.00076985359191895
(323) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63372') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046706199645996
(324) DESCRIBE `ports` 0.00080990791320801
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(326) DESCRIBE `ports` 0.00083398818969727
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002140998840332
(328) DESCRIBE `ports` 0.00077199935913086
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019097328186035
(330) DESCRIBE `sailingdates` 0.00070500373840332
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63372') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00041294097900391
(332) DESCRIBE `ports` 0.0012960433959961
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(334) DESCRIBE `ports` 0.00093889236450195
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024795532226562
(336) DESCRIBE `ports` 0.00090885162353516
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032615661621094
(338) DESCRIBE `ports` 0.00092601776123047
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023889541625977
(340) DESCRIBE `ports` 0.00086688995361328
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0002739429473877
(342) DESCRIBE `ports` 0.00090599060058594
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00025200843811035
(344) DESCRIBE `ports` 0.00087499618530273
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00026607513427734
(346) DESCRIBE `ports` 0.00088095664978027
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00023388862609863
(348) DESCRIBE `ports` 0.00086498260498047
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00027799606323242
(350) DESCRIBE `ports` 0.00088286399841309
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00022602081298828
(352) DESCRIBE `ports` 0.00089192390441895
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00028610229492188
(354) DESCRIBE `ports` 0.00092196464538574
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00024294853210449
(356) DESCRIBE `ports` 0.00087094306945801
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025701522827148
(358) DESCRIBE `ports` 0.00088214874267578
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024890899658203
(360) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63372') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0094749927520752
(361) DESCRIBE `avid_specials` 0.0010771751403809
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63372 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0016880035400391
(363) DESCRIBE `cruiselines` 0.0015420913696289
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035500526428223
(365) DESCRIBE `orchid_image` 0.0011451244354248
(366) DESCRIBE `cruiselines` 0.0015938282012939
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034618377685547
(368) DESCRIBE `cruises` 0.0020570755004883
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63405') 0.00033903121948242
(370) DESCRIBE `ships` 0.0019011497497559
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0027248859405518
(372) DESCRIBE `ships` 0.0019080638885498
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00025582313537598
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020790100097656
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019407272338867
(376) DESCRIBE `itineraries` 0.00089311599731445
(377) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63405') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062417984008789
(378) DESCRIBE `ports` 0.0010349750518799
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028395652770996
(380) DESCRIBE `ports` 0.00089907646179199
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025296211242676
(382) DESCRIBE `ports` 0.00093197822570801
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022697448730469
(384) DESCRIBE `sailingdates` 0.00076508522033691
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63405') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044393539428711
(386) DESCRIBE `ports` 0.00076198577880859
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019693374633789
(388) DESCRIBE `ports` 0.00060915946960449
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017619132995605
(390) DESCRIBE `ports` 0.0006711483001709
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00017786026000977
(392) DESCRIBE `ports` 0.00062894821166992
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017309188842773
(394) DESCRIBE `ports` 0.00067496299743652
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00018215179443359
(396) DESCRIBE `ports` 0.00078892707824707
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0002129077911377
(398) DESCRIBE `ports` 0.00083804130554199
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00022315979003906
(400) DESCRIBE `ports` 0.00064992904663086
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00017595291137695
(402) DESCRIBE `ports` 0.00058484077453613
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021910667419434
(404) DESCRIBE `ports` 0.00059604644775391
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00015902519226074
(406) DESCRIBE `ports` 0.0006101131439209
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00025606155395508
(408) DESCRIBE `ports` 0.00079202651977539
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018882751464844
(410) DESCRIBE `ports` 0.0006859302520752
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00018191337585449
(412) DESCRIBE `ports` 0.00074601173400879
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018787384033203
(414) DESCRIBE `ports` 0.00081515312194824
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00024914741516113
(416) DESCRIBE `ports` 0.00088596343994141
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00020313262939453
(418) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63405') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0084290504455566
(419) DESCRIBE `avid_specials` 0.00098395347595215
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63405 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0015161037445068
(421) DESCRIBE `cruiselines` 0.001410961151123
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00026106834411621
(423) DESCRIBE `orchid_image` 0.0011358261108398
(424) DESCRIBE `cruiselines` 0.0010991096496582
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026702880859375
(426) DESCRIBE `cruises` 0.0021038055419922
(427) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63370') 0.00039792060852051
(428) DESCRIBE `ships` 0.0019540786743164
(429) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00040602684020996
(430) DESCRIBE `ships` 0.0018448829650879
(431) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00024700164794922
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018811225891113
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018787384033203
(434) DESCRIBE `itineraries` 0.0009160041809082
(435) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63370') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052499771118164
(436) DESCRIBE `ports` 0.0010659694671631
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030708312988281
(438) DESCRIBE `ports` 0.00087809562683105
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026106834411621
(440) DESCRIBE `ports` 0.0009758472442627
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025320053100586
(442) DESCRIBE `sailingdates` 0.00074100494384766
(443) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63370') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051999092102051
(444) DESCRIBE `ports` 0.00095486640930176
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027203559875488
(446) DESCRIBE `ports` 0.00090885162353516
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(448) DESCRIBE `ports` 0.00094294548034668
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00026106834411621
(450) DESCRIBE `ports` 0.00086307525634766
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00024890899658203
(452) DESCRIBE `ports` 0.00095891952514648
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00026607513427734
(454) DESCRIBE `ports` 0.0010180473327637
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00025677680969238
(456) DESCRIBE `ports` 0.00096893310546875
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0004889965057373
(458) DESCRIBE `ports` 0.001072883605957
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028204917907715
(460) DESCRIBE `ports` 0.00095605850219727
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028800964355469
(462) DESCRIBE `ports` 0.0010039806365967
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00025606155395508
(464) DESCRIBE `ports` 0.00097489356994629
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(466) DESCRIBE `ports` 0.0010809898376465
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026988983154297
(468) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63370') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.008228063583374
(469) DESCRIBE `avid_specials` 0.0011329650878906
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63370 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0016069412231445
(471) DESCRIBE `cruiselines` 0.00148606300354
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032496452331543
(473) DESCRIBE `orchid_image` 0.0010750293731689
(474) DESCRIBE `cruiselines` 0.0015640258789062
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032997131347656
(476) DESCRIBE `ships` 0.0022718906402588
(477) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00051093101501465
(478) DESCRIBE `cruisetypes` 0.00086498260498047
(479) DESCRIBE `destinations` 0.0013628005981445
(480) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00052285194396973
(481) DESCRIBE `cruiselines` 0.0014660358428955
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032711029052734
(483) DESCRIBE `cruiselines` 0.0013329982757568
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00026607513427734