or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
  • Sky, Bahamas Cruise ex Miami Roundtrip

    Nights 3 Ship Norwegian Sky
    Star Rating 4 Star Departs Miami
    Sailing 2017: 15 Dec, 26 Dec
    Ports of Call Miami, Nassau, Great Stirrup Cay
    Please enquire about this cruise for pricing.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Star, Mexican Riviera ex Los Angeles Return

    Nights 7 Ship Norwegian Star
    Star Rating 4 Star Departs Los Angeles, California, USA
    Sailing 2017: 15 Dec, 22 Dec, 29 Dec
    Ports of Call Los Angeles, Puerto Vallarta, Mazatlan, Cabo San Lucas
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Breakaway, Bahamas & Florida ex New York Roundtrip

    Nights 7 Ship Norwegian Breakaway
    Star Rating 4 Star Departs New York, USA
    Sailing 2017: 15 Dec, 29 Dec
    Ports of Call New York, Port Canaveral, Nassau, Great Stirrup Cay
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • America, Hawaii Cruise ex Honolulu Return

    Nights 7 Ship Pride of America
    Star Rating 4 Star Departs Honolulu, Hawaii
    Sailing 2017: 16 Dec, 23 Dec, 30 Dec
    Ports of Call Honolulu, Kahului-Maui, Hilo Hawaii, Kailua Kona, Nawiliwili Kauai
    Please enquire about this cruise for pricing.
     
    Pride of America Free At Sea Sale for sailings through to 2018 Hawaii Free At Sea: Pick 1 for Studio, Inside, Oceanview & Balcony (excludes categories IX,OX,BX): 1nt Pre Hotel stay, Pre-Paid Service Charges, Specialty Dining Package up to 3 meals, $50 USD per port Shore Excursion Credit (max 4), 3rd & 4th Guest Sail Free (select sailings) If choosing 1nt pre hotel option, reservation must be confirmed more than 30 days prior to sailing.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Escape, Eastern Caribbean ex Miami Return

    Nights 7 Ship Norwegian Escape
    Star Rating 5 Star Departs Miami
    Sailing 2017: 16 Dec, 23 Dec, 30 Dec
    Ports of Call Miami, St Thomas, Tortola, Nassau
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Epic, Eastern Caribbean Cruise ex Port Canveral

    Nights 7 Ship Norwegian Epic
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2017: 16 Dec, 30 Dec
    Ports of Call Port Canaveral, Tortola, St Thomas, Great Stirrup Cay
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Getaway, Western Caribbean ex Miami Return

    Nights 7 Ship Norwegian Getaway
    Star Rating 4 Star Departs Miami
    Sailing 2017: 17 Dec, 24 Dec, 31 Dec
    Ports of Call Miami, Roatan, Harvest Caye, Costa Maya, Cozumel
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Dawn, Southern Caribbean Holiday ex San Juan Return

    Nights 11 Ship Norwegian Dawn
    Star Rating 4 Star Departs San Juan, Puerto Rico
    Sailing 2017: 17 Dec
    Ports of Call San Juan, Oranjestad, Willemstad, Kralendijk, St Georges, Bridgetown, Castries, Philipsburg, Tortola
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Jade, Southern Caribbean ex Miami Return

    Nights 10 Ship Norwegian Jade
    Star Rating 4 Star Departs Miami
    Sailing 2017: 18 Dec
    Ports of Call Miami, San Juan, St Thomas, Roseau, Bridgetown, Castries, Philipsburg
    Please enquire about this cruise for pricing.
     
    Norwegian Cruise Line - Free at Sea Offer extended. BOOK BY 31 OCT 2017 Applicable to sailings 3 nights or longer. Free At Sea: Pick 1 Offer for Studio & Inside or Pick 2 for Ocean view, Balcony & Mini-Suite: Ultimate Beverage Package, 250 Minute Internet Package, Specialty Dining Package up to 4 meals, $50USD per port Shore Excursion Credit, Kids Free (select sailings). Excludes Pride of America, Norwegian Sky and Norwegian Joy sailings. Excludes categories IX, OX, BX, MX. Terms and Conditions apply.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
  • Sky, Bahamas Cruise ex Miami Roundtrip

    Nights 4 Ship Norwegian Sky
    Star Rating 4 Star Departs Miami
    Sailing 2017: 18 Dec, 29 Dec
    Ports of Call Miami, Grand Bahamas Island, Nassau, Great Stirrup Cay
    Please enquire about this cruise for pricing.
     
    Plan a Cruise Month Special: Norwegian Cruise Line Norwegian have great offers to help you make the most of Plan A Cruise Month …. Free at Sea and Pride of America Free at Sea offers until 31 Oct. Up to $1000 USD on board spend available on select Caribbean sailings booked between 29 Sep and 16 Oct 2017 and for other destinations up to $500 USD on board spend is up for grabs on select departures also booked between 29 Sep and 16 Oct 2017. Terms and conditions apply. Contact us for details.
 

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

Total elapsed time: 0.29647517204285

# Query Time
(1) connect 0.00043010711669922
(2) DESCRIBE `cruises` 0.0014750957489014
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (43646, 25176, 58299, 43678, 63480, 63474, 63485, 63881, 64571, 43647)) ORDER BY FIND_IN_SET(id, '43646,25176,58299,43678,63480,63474,63485,63881,64571,43647') 0.0013628005981445
(4) DESCRIBE `cruises` 0.002112865447998
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43646') 0.00028085708618164
(6) DESCRIBE `ships` 0.0018048286437988
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00031805038452148
(8) DESCRIBE `ships` 0.0012660026550293
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.00021195411682129
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(12) DESCRIBE `itineraries` 0.00069808959960938
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43646') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067305564880371
(14) DESCRIBE `ports` 0.001007080078125
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024199485778809
(16) DESCRIBE `ports` 0.00060081481933594
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018310546875
(18) DESCRIBE `ports` 0.00059008598327637
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017809867858887
(20) DESCRIBE `sailingdates` 0.00053596496582031
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43646') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00090718269348145
(22) DESCRIBE `ports` 0.00095891952514648
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024294853210449
(24) DESCRIBE `ports` 0.00059199333190918
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017380714416504
(26) DESCRIBE `ports` 0.00058603286743164
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020313262939453
(28) DESCRIBE `ports` 0.00059890747070312
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0001671314239502
(30) DESCRIBE `ports` 0.00058603286743164
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00018191337585449
(32) DESCRIBE `ports` 0.00058603286743164
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.0001680850982666
(34) DESCRIBE `ports` 0.00058388710021973
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00017905235290527
(36) DESCRIBE `ports` 0.00064206123352051
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00027203559875488
(38) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '43646') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0053451061248779
(39) DESCRIBE `avid_specials` 0.00073385238647461
(40) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43646 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00095796585083008
(41) DESCRIBE `cruiselines` 0.00088191032409668
(42) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00019383430480957
(43) DESCRIBE `orchid_image` 0.00079488754272461
(44) DESCRIBE `cruiselines` 0.0011019706726074
(45) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020289421081543
(46) DESCRIBE `cruises` 0.0012209415435791
(47) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.00020790100097656
(48) DESCRIBE `ships` 0.001129150390625
(49) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00021886825561523
(50) DESCRIBE `ships` 0.0011451244354248
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0001680850982666
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(54) DESCRIBE `itineraries` 0.00057506561279297
(55) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '25176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048303604125977
(56) DESCRIBE `ports` 0.00061988830566406
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00018405914306641
(58) DESCRIBE `ports` 0.00062298774719238
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00018501281738281
(60) DESCRIBE `ports` 0.00060296058654785
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00015616416931152
(62) DESCRIBE `sailingdates` 0.00052690505981445
(63) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '25176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056600570678711
(64) DESCRIBE `ports` 0.00068306922912598
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00018787384033203
(66) DESCRIBE `ports` 0.00060701370239258
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00019121170043945
(68) DESCRIBE `ports` 0.00058794021606445
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00018310546875
(70) DESCRIBE `ports` 0.00058889389038086
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00016188621520996
(72) DESCRIBE `ports` 0.00058412551879883
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00018906593322754
(74) DESCRIBE `ports` 0.00058603286743164
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00015997886657715
(76) DESCRIBE `ports` 0.00064206123352051
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00017189979553223
(78) DESCRIBE `ports` 0.00059294700622559
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00018620491027832
(80) DESCRIBE `ports` 0.00058197975158691
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00017714500427246
(82) DESCRIBE `ports` 0.00058603286743164
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00015997886657715
(84) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '25176') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0043580532073975
(85) DESCRIBE `avid_specials` 0.00075697898864746
(86) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.00096011161804199
(87) DESCRIBE `cruiselines` 0.00086808204650879
(88) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0001990795135498
(89) DESCRIBE `orchid_image` 0.00064897537231445
(90) DESCRIBE `cruiselines` 0.00080299377441406
(91) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017809867858887
(92) DESCRIBE `cruises` 0.0011529922485352
(93) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58299') 0.00030612945556641
(94) DESCRIBE `ships` 0.0011231899261475
(95) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1008))) 0.00022196769714355
(96) DESCRIBE `ships` 0.0011730194091797
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1008') 0.00016498565673828
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001530647277832
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(100) DESCRIBE `itineraries` 0.00063395500183105
(101) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58299') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004889965057373
(102) DESCRIBE `ports` 0.00062704086303711
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00019502639770508
(104) DESCRIBE `ports` 0.00058603286743164
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0001680850982666
(106) DESCRIBE `ports` 0.00061511993408203
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00016212463378906
(108) DESCRIBE `sailingdates` 0.00053501129150391
(109) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58299') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053501129150391
(110) DESCRIBE `ports` 0.00065708160400391
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00018095970153809
(112) DESCRIBE `ports` 0.00058293342590332
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00015497207641602
(114) DESCRIBE `ports` 0.00058197975158691
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020194053649902
(116) DESCRIBE `ports` 0.00059199333190918
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00016617774963379
(118) DESCRIBE `ports` 0.00058603286743164
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00023698806762695
(120) DESCRIBE `ports` 0.00069904327392578
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00015997886657715
(122) DESCRIBE `ports` 0.00057697296142578
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00017118453979492
(124) DESCRIBE `ports` 0.00059103965759277
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00016498565673828
(126) DESCRIBE `ports` 0.00059604644775391
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00017309188842773
(128) DESCRIBE `ports` 0.00058603286743164
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00015592575073242
(130) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58299') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0038638114929199
(131) DESCRIBE `avid_specials` 0.00065398216247559
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58299 and class = 'Cruise') OR (item_id = 1008 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00094914436340332
(133) DESCRIBE `cruiselines` 0.0009160041809082
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022506713867188
(135) DESCRIBE `orchid_image` 0.0006871223449707
(136) DESCRIBE `cruiselines` 0.00091314315795898
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019001960754395
(138) DESCRIBE `cruises` 0.0012471675872803
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43678') 0.0002129077911377
(140) DESCRIBE `ships` 0.0012588500976562
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00032520294189453
(142) DESCRIBE `ships` 0.0013039112091064
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.00021195411682129
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015592575073242
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014400482177734
(146) DESCRIBE `itineraries` 0.00065994262695312
(147) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43678') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044417381286621
(148) DESCRIBE `ports` 0.00062704086303711
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00018906593322754
(150) DESCRIBE `ports` 0.00059199333190918
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0001828670501709
(152) DESCRIBE `ports` 0.00063896179199219
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018501281738281
(154) DESCRIBE `sailingdates` 0.00071096420288086
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43678') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012338161468506
(156) DESCRIBE `ports` 0.001039981842041
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00024008750915527
(158) DESCRIBE `ports` 0.00060105323791504
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00017094612121582
(160) DESCRIBE `ports` 0.00058889389038086
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00022387504577637
(162) DESCRIBE `ports` 0.00063204765319824
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00016403198242188
(164) DESCRIBE `ports` 0.00064611434936523
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00018191337585449
(166) DESCRIBE `ports` 0.00062394142150879
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00016689300537109
(168) DESCRIBE `ports` 0.0005950927734375
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00017690658569336
(170) DESCRIBE `ports` 0.00058603286743164
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00015902519226074
(172) DESCRIBE `ports` 0.00062704086303711
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00017905235290527
(174) DESCRIBE `ports` 0.00059390068054199
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00016093254089355
(176) DESCRIBE `ports` 0.00058412551879883
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00017499923706055
(178) DESCRIBE `ports` 0.00063490867614746
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00015687942504883
(180) DESCRIBE `ports` 0.00059080123901367
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00016999244689941
(182) DESCRIBE `ports` 0.00060391426086426
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00015616416931152
(184) DESCRIBE `ports` 0.00060701370239258
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00018000602722168
(186) DESCRIBE `ports` 0.00060415267944336
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00016212463378906
(188) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '43678') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0038650035858154
(189) DESCRIBE `avid_specials` 0.00070905685424805
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 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.0010089874267578
(191) DESCRIBE `cruiselines` 0.00089287757873535
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020599365234375
(193) DESCRIBE `orchid_image` 0.00066494941711426
(194) DESCRIBE `cruiselines` 0.00094914436340332
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018692016601562
(196) DESCRIBE `cruises` 0.0013360977172852
(197) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63480') 0.00020599365234375
(198) DESCRIBE `ships` 0.0011639595031738
(199) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1193))) 0.00024580955505371
(200) DESCRIBE `ships` 0.001183032989502
(201) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1193') 0.00018692016601562
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001528263092041
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014901161193848
(204) DESCRIBE `itineraries` 0.00084614753723145
(205) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63480') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059199333190918
(206) DESCRIBE `ports` 0.0007479190826416
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022315979003906
(208) DESCRIBE `ports` 0.00061297416687012
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019001960754395
(210) DESCRIBE `ports` 0.00059890747070312
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017094612121582
(212) DESCRIBE `sailingdates` 0.00056910514831543
(213) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63480') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063109397888184
(214) DESCRIBE `ports` 0.00092887878417969
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023198127746582
(216) DESCRIBE `ports` 0.00074195861816406
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020694732666016
(218) DESCRIBE `ports` 0.0006411075592041
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00020194053649902
(220) DESCRIBE `ports` 0.00061297416687012
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00016999244689941
(222) DESCRIBE `ports` 0.00071191787719727
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00041913986206055
(224) DESCRIBE `ports` 0.00098800659179688
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00017595291137695
(226) DESCRIBE `ports` 0.00062298774719238
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00018501281738281
(228) DESCRIBE `ports` 0.00080490112304688
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0001978874206543
(230) DESCRIBE `ports` 0.00080204010009766
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023412704467773
(232) DESCRIBE `ports` 0.00078582763671875
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001988410949707
(234) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63480') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0053811073303223
(235) DESCRIBE `avid_specials` 0.00070095062255859
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63480 and class = 'Cruise') OR (item_id = 1193 AND class = 'Ship') OR (item_id = 20 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.00097203254699707
(237) DESCRIBE `cruiselines` 0.00090312957763672
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00019502639770508
(239) DESCRIBE `orchid_image` 0.00065994262695312
(240) DESCRIBE `cruiselines` 0.00086379051208496
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017404556274414
(242) DESCRIBE `cruises` 0.0011460781097412
(243) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63474') 0.00019502639770508
(244) DESCRIBE `ships` 0.0011858940124512
(245) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00023698806762695
(246) DESCRIBE `ships` 0.0011420249938965
(247) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00016593933105469
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014495849609375
(250) DESCRIBE `itineraries` 0.00060486793518066
(251) DESCRIBE `ports` 0.00061202049255371
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020289421081543
(253) DESCRIBE `ports` 0.00058794021606445
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00017404556274414
(255) DESCRIBE `ports` 0.00059294700622559
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00016999244689941
(257) DESCRIBE `sailingdates` 0.00056099891662598
(258) DESCRIBE `ports` 0.00063204765319824
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0001990795135498
(260) DESCRIBE `ports` 0.0005950927734375
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00016307830810547
(262) DESCRIBE `ports` 0.00079917907714844
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00022697448730469
(264) DESCRIBE `ports` 0.00083708763122559
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00019621849060059
(266) DESCRIBE `ports` 0.00076913833618164
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00022006034851074
(268) DESCRIBE `ports` 0.00080394744873047
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00019598007202148
(270) DESCRIBE `ports` 0.00079512596130371
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00019407272338867
(272) DESCRIBE `ports` 0.00073599815368652
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00019502639770508
(274) DESCRIBE `ports` 0.00062704086303711
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00018000602722168
(276) DESCRIBE `ports` 0.00064611434936523
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00016117095947266
(278) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63474') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0038387775421143
(279) DESCRIBE `avid_specials` 0.00063514709472656
(280) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63474 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.00093603134155273
(281) DESCRIBE `cruiselines` 0.00091195106506348
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020217895507812
(283) DESCRIBE `orchid_image` 0.00069403648376465
(284) DESCRIBE `cruiselines` 0.00084304809570312
(285) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017714500427246
(286) DESCRIBE `cruises` 0.0011579990386963
(287) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63485') 0.00029802322387695
(288) DESCRIBE `ships` 0.0011601448059082
(289) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1088))) 0.00022983551025391
(290) DESCRIBE `ships` 0.0011370182037354
(291) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1088') 0.00018882751464844
(292) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(294) DESCRIBE `itineraries` 0.00073504447937012
(295) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63485') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043296813964844
(296) DESCRIBE `ports` 0.00070095062255859
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020790100097656
(298) DESCRIBE `ports` 0.00059604644775391
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001828670501709
(300) DESCRIBE `ports` 0.00060200691223145
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016903877258301
(302) DESCRIBE `sailingdates` 0.00056099891662598
(303) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63485') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007178783416748
(304) DESCRIBE `ports` 0.00091910362243652
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00024604797363281
(306) DESCRIBE `ports` 0.00058794021606445
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017404556274414
(308) DESCRIBE `ports` 0.00064396858215332
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00018501281738281
(310) DESCRIBE `ports` 0.00059413909912109
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00018215179443359
(312) DESCRIBE `ports` 0.00058293342590332
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00018000602722168
(314) DESCRIBE `ports` 0.00058698654174805
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00016307830810547
(316) DESCRIBE `ports` 0.00060200691223145
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00018191337585449
(318) DESCRIBE `ports` 0.00061488151550293
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00019097328186035
(320) DESCRIBE `ports` 0.00059914588928223
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00017905235290527
(322) DESCRIBE `ports` 0.00059604644775391
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00016212463378906
(324) DESCRIBE `ports` 0.00059890747070312
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018405914306641
(326) DESCRIBE `ports` 0.00059199333190918
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016307830810547
(328) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63485') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0058121681213379
(329) DESCRIBE `avid_specials` 0.00088191032409668
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63485 and class = 'Cruise') OR (item_id = 1088 AND class = 'Ship') OR (item_id = 20 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.0011651515960693
(331) DESCRIBE `cruiselines` 0.00091290473937988
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0001978874206543
(333) DESCRIBE `orchid_image` 0.00071001052856445
(334) DESCRIBE `cruiselines` 0.00082898139953613
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00016689300537109
(336) DESCRIBE `cruises` 0.0012619495391846
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63881') 0.00021100044250488
(338) DESCRIBE `ships` 0.001154899597168
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 314))) 0.00021982192993164
(340) DESCRIBE `ships` 0.0011341571807861
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '314') 0.00015497207641602
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014615058898926
(344) DESCRIBE `itineraries` 0.00058889389038086
(345) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051403045654297
(346) DESCRIBE `ports` 0.00063800811767578
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00020694732666016
(348) DESCRIBE `ports` 0.00060701370239258
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00017309188842773
(350) DESCRIBE `ports` 0.00059199333190918
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00015592575073242
(352) DESCRIBE `sailingdates` 0.00053095817565918
(353) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036096572875977
(354) DESCRIBE `ports` 0.00066590309143066
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00019192695617676
(356) DESCRIBE `ports` 0.00060105323791504
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00024199485778809
(358) DESCRIBE `ports` 0.00062894821166992
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00018095970153809
(360) DESCRIBE `ports` 0.00062799453735352
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00016212463378906
(362) DESCRIBE `ports` 0.00062704086303711
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00017905235290527
(364) DESCRIBE `ports` 0.00063109397888184
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00020408630371094
(366) DESCRIBE `ports` 0.00081396102905273
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00023102760314941
(368) DESCRIBE `ports` 0.00085711479187012
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00016403198242188
(370) DESCRIBE `ports` 0.00062894821166992
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00018000602722168
(372) DESCRIBE `ports` 0.00059986114501953
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00016498565673828
(374) DESCRIBE `ports` 0.00060200691223145
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00021696090698242
(376) DESCRIBE `ports` 0.00081992149353027
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00021696090698242
(378) DESCRIBE `ports` 0.00087785720825195
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00032305717468262
(380) DESCRIBE `ports` 0.00076413154602051
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00017309188842773
(382) DESCRIBE `ports` 0.00059700012207031
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0001828670501709
(384) DESCRIBE `ports` 0.0005948543548584
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00015997886657715
(386) DESCRIBE `ports` 0.00059700012207031
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00017881393432617
(388) DESCRIBE `ports` 0.00059795379638672
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00018000602722168
(390) DESCRIBE `ports` 0.00060701370239258
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018692016601562
(392) DESCRIBE `ports` 0.00061297416687012
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00016403198242188
(394) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63881') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0038580894470215
(395) DESCRIBE `avid_specials` 0.00072479248046875
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63881 and class = 'Cruise') OR (item_id = 314 AND class = 'Ship') OR (item_id = 20 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.00098180770874023
(397) DESCRIBE `cruiselines` 0.00099706649780273
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00025391578674316
(399) DESCRIBE `orchid_image` 0.00068378448486328
(400) DESCRIBE `cruiselines` 0.00091195106506348
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00022292137145996
(402) DESCRIBE `cruises` 0.0011749267578125
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64571') 0.00022792816162109
(404) DESCRIBE `ships` 0.0011410713195801
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 665))) 0.00023603439331055
(406) DESCRIBE `ships` 0.0021998882293701
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '665') 0.00028395652770996
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015997886657715
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014710426330566
(410) DESCRIBE `itineraries` 0.00075697898864746
(411) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64571') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053000450134277
(412) DESCRIBE `ports` 0.00063896179199219
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020813941955566
(414) DESCRIBE `ports` 0.00060510635375977
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018000602722168
(416) DESCRIBE `ports` 0.00060391426086426
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016999244689941
(418) DESCRIBE `sailingdates` 0.00053286552429199
(419) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64571') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060105323791504
(420) DESCRIBE `ports` 0.00065994262695312
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020503997802734
(422) DESCRIBE `ports` 0.00059890747070312
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017189979553223
(424) DESCRIBE `ports` 0.0006098747253418
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00018095970153809
(426) DESCRIBE `ports` 0.00059795379638672
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00015997886657715
(428) DESCRIBE `ports` 0.00059986114501953
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00018095970153809
(430) DESCRIBE `ports` 0.00061392784118652
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00015997886657715
(432) DESCRIBE `ports` 0.00058603286743164
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00018191337585449
(434) DESCRIBE `ports` 0.00061607360839844
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00015902519226074
(436) DESCRIBE `ports` 0.00060701370239258
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00017690658569336
(438) DESCRIBE `ports` 0.0006098747253418
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00016212463378906
(440) DESCRIBE `ports` 0.00058889389038086
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00017690658569336
(442) DESCRIBE `ports` 0.00061798095703125
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00016188621520996
(444) DESCRIBE `ports` 0.00060105323791504
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00018095970153809
(446) DESCRIBE `ports` 0.00061488151550293
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00016188621520996
(448) DESCRIBE `ports` 0.0006108283996582
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019216537475586
(450) DESCRIBE `ports` 0.00058889389038086
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016403198242188
(452) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64571') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0038399696350098
(453) DESCRIBE `avid_specials` 0.00063204765319824
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64571 and class = 'Cruise') OR (item_id = 665 AND class = 'Ship') OR (item_id = 20 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.00096607208251953
(455) DESCRIBE `cruiselines` 0.00087809562683105
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0001990795135498
(457) DESCRIBE `orchid_image` 0.00068092346191406
(458) DESCRIBE `cruiselines` 0.00083684921264648
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00016593933105469
(460) DESCRIBE `cruises` 0.0011579990386963
(461) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43647') 0.00018405914306641
(462) DESCRIBE `ships` 0.0011351108551025
(463) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00023102760314941
(464) DESCRIBE `ships` 0.0011491775512695
(465) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.00018000602722168
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015592575073242
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(468) DESCRIBE `itineraries` 0.00060009956359863
(469) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43647') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034594535827637
(470) DESCRIBE `ports` 0.000640869140625
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001981258392334
(472) DESCRIBE `ports` 0.00062108039855957
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019001960754395
(474) DESCRIBE `ports` 0.00060892105102539
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016999244689941
(476) DESCRIBE `sailingdates` 0.00053596496582031
(477) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43647') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046610832214355
(478) DESCRIBE `ports` 0.00081300735473633
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022196769714355
(480) DESCRIBE `ports` 0.00059700012207031
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019097328186035
(482) DESCRIBE `ports` 0.00059103965759277
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2559))) 0.00025105476379395
(484) DESCRIBE `ports` 0.00061893463134766
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2559') 0.00016689300537109
(486) DESCRIBE `ports` 0.00059986114501953
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00018405914306641
(488) DESCRIBE `ports` 0.00059390068054199
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00020408630371094
(490) DESCRIBE `ports` 0.00063896179199219
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00017595291137695
(492) DESCRIBE `ports` 0.00061988830566406
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00015997886657715
(494) DESCRIBE `ports` 0.0005948543548584
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019121170043945
(496) DESCRIBE `ports` 0.00059080123901367
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00016403198242188
(498) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '43647') AND (sailingdate >= '2017-12-15') AND (sailingdate <= '2017-12-31') 0.0037131309509277
(499) DESCRIBE `avid_specials` 0.00065493583679199
(500) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43647 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.000946044921875
(501) DESCRIBE `cruiselines` 0.00088691711425781
(502) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020217895507812
(503) DESCRIBE `orchid_image` 0.00066399574279785
(504) DESCRIBE `cruiselines` 0.0008389949798584
(505) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00016307830810547
(506) DESCRIBE `ships` 0.0012660026550293
(507) SELECT `ships`.* FROM `ships` WHERE (id IN ('405', '93', '404', '770', '1008', '1088', '1193', '314', '574', '665', '212', '448', '485', '626')) ORDER BY FIND_IN_SET(id, '405,93,404,770,1008,1088,1193,314,574,665,212,448,485,626') 0.00066995620727539
(508) DESCRIBE `cruisetypes` 0.00059890747070312
(509) DESCRIBE `destinations` 0.00093293190002441
(510) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '29', '53', '28', '37', '43')) ORDER BY FIND_IN_SET(id, '12,9,29,53,28,37,43') 0.00050497055053711
(511) DESCRIBE `cruiselines` 0.00096797943115234
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022602081298828
(513) DESCRIBE `cruiselines` 0.0011141300201416
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021982192993164