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

 
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

    Nights 2 Ship Bhaya Classic Ships
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • VSpirit Classic, Halong Bay 2 Nights ex Halong Bay Return

    Nights 2 Ship VSpirit Classic
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Jasmine, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 Ship Jasmine
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Violet, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 Ship Violet
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

    Nights 1 Ship Bhaya Classic Ships
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • VSpirit Classic, Halong Bay 1 Night ex Halong Bay Return

    Nights 1 Ship VSpirit Classic
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Jasmine, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Jasmine
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Violet, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Violet
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar More 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 10 May, 11 May, 12 May, 13 May, 14 May, 15 May, 16 May, 17 May, 18 May, 19 May, 20 May, 21 May, 22 May, 23 May, 24 May, 25 May, 26 May, 27 May, 28 May, 29 May, 30 May, 31 May, 1 Jun, 2 Jun, 3 Jun, 4 Jun, 5 Jun, 6 Jun, 7 Jun, 8 Jun, 9 Jun, 10 Jun, 11 Jun, 12 Jun, 13 Jun, 14 Jun, 15 Jun, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Raymonde, (PAM) Prestigious Paris & Famous Sites ex Paris Return

    Nights 3 Ship Raymonde
    Star Rating River Departs Paris, France
    Sailing 2018: 21 Feb, 24 Feb, 28 Feb, 3 Mar, 7 Mar, 10 Mar, 14 Mar, 17 Mar, 21 Mar, 24 Mar
    Ports of Call Paris
    Please enquire about this cruise for pricing.
  • Kha Byoo Pandaw, Pagan Mandalay Short Cruise Upstream ex Pagan to Mandalay

    Nights 2 Ship Kha Byoo Pandaw
    Star Rating River Departs Pagan, Myanmar
    Sailing 2018: 21 Feb, 25 Feb, 1 Mar
    Ports of Call Pagan, Yandabo, Mandalay
    Please enquire about this cruise for pricing.
 

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

Total elapsed time: 0.55182981491089

# Query Time
(1) connect 0.00048017501831055
(2) DESCRIBE `cruises` 0.0017831325531006
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (44276, 49176, 65919, 65921, 44275, 49177, 65920, 71154, 51655, 66217)) ORDER BY FIND_IN_SET(id, '44276,49176,65919,65921,44275,49177,65920,71154,51655,66217') 0.00111985206604
(4) DESCRIBE `cruises` 0.0021488666534424
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00028395652770996
(6) DESCRIBE `ships` 0.0013689994812012
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00055289268493652
(8) DESCRIBE `ships` 0.0019669532775879
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00025105476379395
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002140998840332
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020384788513184
(12) DESCRIBE `itineraries` 0.00089287757873535
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '44276') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014889240264893
(14) DESCRIBE `ports` 0.0010530948638916
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029897689819336
(16) DESCRIBE `ports` 0.0010449886322021
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0002281665802002
(18) DESCRIBE `ports` 0.00083589553833008
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0002288818359375
(20) DESCRIBE `sailingdates` 0.00081896781921387
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '44276') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0028359889984131
(22) DESCRIBE `ports` 0.001276969909668
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031900405883789
(24) DESCRIBE `ports` 0.00089716911315918
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00023579597473145
(26) DESCRIBE `ports` 0.00086688995361328
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026297569274902
(28) DESCRIBE `ports` 0.00088214874267578
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00022101402282715
(30) DESCRIBE `ports` 0.00087308883666992
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00025391578674316
(32) DESCRIBE `ports` 0.00088191032409668
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003359317779541
(34) DESCRIBE `avid_specials` 0.00084877014160156
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44276 and class = 'Cruise') OR (item_id = 1127 AND class = 'Ship') OR (item_id = 221 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015108585357666
(36) DESCRIBE `cruiselines` 0.0013570785522461
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.0003669261932373
(38) DESCRIBE `orchid_image` 0.0011489391326904
(39) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '221') 0.035192966461182
(40) DESCRIBE `cruiselines` 0.0013580322265625
(41) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00025010108947754
(42) DESCRIBE `cruises` 0.0018601417541504
(43) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.00028800964355469
(44) DESCRIBE `ships` 0.0013360977172852
(45) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00027012825012207
(46) DESCRIBE `ships` 0.0012168884277344
(47) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00021100044250488
(48) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015592575073242
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014305114746094
(50) DESCRIBE `itineraries` 0.00064206123352051
(51) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '49176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079488754272461
(52) DESCRIBE `ports` 0.00096607208251953
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022006034851074
(54) DESCRIBE `ports` 0.00060892105102539
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00017309188842773
(56) DESCRIBE `ports` 0.00064802169799805
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00021982192993164
(58) DESCRIBE `sailingdates` 0.00058698654174805
(59) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '49176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016059875488281
(60) DESCRIBE `ports` 0.0010120868682861
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00023508071899414
(62) DESCRIBE `ports` 0.00064706802368164
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00018119812011719
(64) DESCRIBE `ports` 0.00069594383239746
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00020098686218262
(66) DESCRIBE `ports` 0.00065708160400391
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017309188842773
(68) DESCRIBE `ports` 0.00062203407287598
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00020194053649902
(70) DESCRIBE `ports` 0.00061488151550293
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00021100044250488
(72) DESCRIBE `avid_specials` 0.00072407722473145
(73) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49176 and class = 'Cruise') OR (item_id = 1247 AND class = 'Ship') OR (item_id = 232 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013399124145508
(74) DESCRIBE `cruiselines` 0.001107931137085
(75) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.0002448558807373
(76) DESCRIBE `orchid_image` 0.00073695182800293
(77) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '232') 0.034051179885864
(78) DESCRIBE `cruiselines` 0.001093864440918
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00022196769714355
(80) DESCRIBE `cruises` 0.0018901824951172
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00033807754516602
(82) DESCRIBE `ships` 0.0020971298217773
(83) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.0004730224609375
(84) DESCRIBE `ships` 0.0020520687103271
(85) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00033879280090332
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020098686218262
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018906593322754
(88) DESCRIBE `itineraries` 0.0010080337524414
(89) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65919') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014970302581787
(90) DESCRIBE `ports` 0.0010001659393311
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026202201843262
(92) DESCRIBE `ports` 0.00078487396240234
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022792816162109
(94) DESCRIBE `ports` 0.000762939453125
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00020503997802734
(96) DESCRIBE `sailingdates` 0.00068211555480957
(97) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65919') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0020301342010498
(98) DESCRIBE `ports` 0.0012760162353516
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00030899047851562
(100) DESCRIBE `ports` 0.0010020732879639
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00024104118347168
(102) DESCRIBE `ports` 0.00088620185852051
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028896331787109
(104) DESCRIBE `ports` 0.0010168552398682
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00025391578674316
(106) DESCRIBE `ports` 0.00088000297546387
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00027298927307129
(108) DESCRIBE `ports` 0.00095486640930176
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00025606155395508
(110) DESCRIBE `avid_specials` 0.00076985359191895
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65919 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017220973968506
(112) DESCRIBE `cruiselines` 0.0015559196472168
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00036501884460449
(114) DESCRIBE `orchid_image` 0.0012369155883789
(115) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '183') 0.048110008239746
(116) DESCRIBE `cruiselines` 0.00111985206604
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00025296211242676
(118) DESCRIBE `cruises` 0.002007007598877
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00033211708068848
(120) DESCRIBE `ships` 0.0019409656524658
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00044798851013184
(122) DESCRIBE `ships` 0.0020542144775391
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00032615661621094
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020098686218262
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018906593322754
(126) DESCRIBE `itineraries` 0.0010080337524414
(127) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65921') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045490264892578
(128) DESCRIBE `ports` 0.0009911060333252
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00027704238891602
(130) DESCRIBE `ports` 0.00091886520385742
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00023698806762695
(132) DESCRIBE `ports` 0.00067591667175293
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00021004676818848
(134) DESCRIBE `sailingdates` 0.00069022178649902
(135) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65921') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016510486602783
(136) DESCRIBE `ports` 0.0011880397796631
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028586387634277
(138) DESCRIBE `ports` 0.00080490112304688
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00022292137145996
(140) DESCRIBE `ports` 0.00080609321594238
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026702880859375
(142) DESCRIBE `ports` 0.0011181831359863
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028705596923828
(144) DESCRIBE `ports` 0.00084018707275391
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00021004676818848
(146) DESCRIBE `ports` 0.00066208839416504
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017809867858887
(148) DESCRIBE `avid_specials` 0.0005638599395752
(149) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65921 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094699859619141
(150) DESCRIBE `cruiselines` 0.0010099411010742
(151) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00025391578674316
(152) DESCRIBE `orchid_image` 0.00075602531433105
(153) DESCRIBE `cruiselines` 0.0011281967163086
(154) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00023794174194336
(155) DESCRIBE `cruises` 0.0017259120941162
(156) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44275') 0.00028491020202637
(157) DESCRIBE `ships` 0.0012960433959961
(158) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00024580955505371
(159) DESCRIBE `ships` 0.0018470287322998
(160) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00023603439331055
(161) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001530647277832
(163) DESCRIBE `itineraries` 0.00099587440490723
(164) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '44275') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00036096572875977
(165) DESCRIBE `ports` 0.00097894668579102
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022697448730469
(167) DESCRIBE `ports` 0.00070381164550781
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00021100044250488
(169) DESCRIBE `ports` 0.00082087516784668
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00018191337585449
(171) DESCRIBE `sailingdates` 0.00076723098754883
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '44275') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.002249002456665
(173) DESCRIBE `ports` 0.0011250972747803
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00024890899658203
(175) DESCRIBE `ports` 0.00061798095703125
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017905235290527
(177) DESCRIBE `ports` 0.00060391426086426
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022006034851074
(179) DESCRIBE `ports` 0.00086498260498047
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017786026000977
(181) DESCRIBE `avid_specials` 0.00059604644775391
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44275 and class = 'Cruise') OR (item_id = 1127 AND class = 'Ship') OR (item_id = 221 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001270055770874
(183) DESCRIBE `cruiselines` 0.0011599063873291
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00025701522827148
(185) DESCRIBE `orchid_image` 0.00094199180603027
(186) DESCRIBE `cruiselines` 0.0010538101196289
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00026106834411621
(188) DESCRIBE `cruises` 0.0014450550079346
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49177') 0.00026583671569824
(190) DESCRIBE `ships` 0.0012431144714355
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00027203559875488
(192) DESCRIBE `ships` 0.0013759136199951
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00023198127746582
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016188621520996
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015401840209961
(196) DESCRIBE `itineraries` 0.00069284439086914
(197) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '49177') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0031430721282959
(198) DESCRIBE `ports` 0.0011730194091797
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042605400085449
(200) DESCRIBE `ports` 0.0010828971862793
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003669261932373
(202) DESCRIBE `ports` 0.0010089874267578
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030112266540527
(204) DESCRIBE `sailingdates` 0.00087904930114746
(205) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '49177') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0021090507507324
(206) DESCRIBE `ports` 0.0010571479797363
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029420852661133
(208) DESCRIBE `ports` 0.00069904327392578
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00022578239440918
(210) DESCRIBE `ports` 0.00063920021057129
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022792816162109
(212) DESCRIBE `ports` 0.000701904296875
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0002288818359375
(214) DESCRIBE `avid_specials` 0.00058197975158691
(215) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49177 and class = 'Cruise') OR (item_id = 1247 AND class = 'Ship') OR (item_id = 232 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00089406967163086
(216) DESCRIBE `cruiselines` 0.0012328624725342
(217) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00030398368835449
(218) DESCRIBE `orchid_image` 0.0010051727294922
(219) DESCRIBE `cruiselines` 0.0011999607086182
(220) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00028014183044434
(221) DESCRIBE `cruises` 0.001676082611084
(222) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00029110908508301
(223) DESCRIBE `ships` 0.0016870498657227
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00042390823364258
(225) DESCRIBE `ships` 0.0020129680633545
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00032401084899902
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020790100097656
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001981258392334
(229) DESCRIBE `itineraries` 0.00096011161804199
(230) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65920') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086402893066406
(231) DESCRIBE `ports` 0.00089597702026367
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0002899169921875
(233) DESCRIBE `ports` 0.00080585479736328
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00023293495178223
(235) DESCRIBE `ports` 0.00080704689025879
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0002138614654541
(237) DESCRIBE `sailingdates` 0.0007929801940918
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65920') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0022871494293213
(239) DESCRIBE `ports` 0.0011560916900635
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028777122497559
(241) DESCRIBE `ports` 0.000823974609375
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00025105476379395
(243) DESCRIBE `ports` 0.00095915794372559
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00022006034851074
(245) DESCRIBE `ports` 0.00075507164001465
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00020313262939453
(247) DESCRIBE `avid_specials` 0.00071406364440918
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65920 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015101432800293
(249) DESCRIBE `cruiselines` 0.0012869834899902
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00030112266540527
(251) DESCRIBE `orchid_image` 0.0010669231414795
(252) DESCRIBE `cruiselines` 0.0015311241149902
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00030207633972168
(254) DESCRIBE `cruises` 0.00199294090271
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.00046515464782715
(256) DESCRIBE `ships` 0.0019540786743164
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00041794776916504
(258) DESCRIBE `ships` 0.002018928527832
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00037693977355957
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021100044250488
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001988410949707
(262) DESCRIBE `itineraries` 0.0010080337524414
(263) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71154') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00099086761474609
(264) DESCRIBE `ports` 0.00097393989562988
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00026512145996094
(266) DESCRIBE `ports` 0.00068807601928711
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029206275939941
(268) DESCRIBE `ports` 0.00096011161804199
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031518936157227
(270) DESCRIBE `sailingdates` 0.00090599060058594
(271) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71154') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.002424955368042
(272) DESCRIBE `ports` 0.0013799667358398
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036907196044922
(274) DESCRIBE `ports` 0.0010449886322021
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00025796890258789
(276) DESCRIBE `ports` 0.0009150505065918
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00025796890258789
(278) DESCRIBE `ports` 0.00089097023010254
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0002439022064209
(280) DESCRIBE `avid_specials` 0.00086307525634766
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001492977142334
(282) DESCRIBE `cruiselines` 0.0014870166778564
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00039410591125488
(284) DESCRIBE `orchid_image` 0.0011799335479736
(285) DESCRIBE `cruiselines` 0.0014591217041016
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00032591819763184
(287) DESCRIBE `cruises` 0.0023519992828369
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51655') 0.00043988227844238
(289) DESCRIBE `ships` 0.0023541450500488
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1288))) 0.00060296058654785
(291) DESCRIBE `ships` 0.002349853515625
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1288') 0.00043892860412598
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022697448730469
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021195411682129
(295) DESCRIBE `itineraries` 0.0011200904846191
(296) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '51655') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001533031463623
(297) DESCRIBE `ports` 0.0013060569763184
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0003361701965332
(299) DESCRIBE `ports` 0.00094199180603027
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00030207633972168
(301) DESCRIBE `ports` 0.00093483924865723
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00024914741516113
(303) DESCRIBE `sailingdates` 0.00081586837768555
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '51655') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077390670776367
(305) DESCRIBE `ports` 0.0011851787567139
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00040316581726074
(307) DESCRIBE `ports` 0.0010240077972412
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00028300285339355
(309) DESCRIBE `ports` 0.00099992752075195
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00036096572875977
(311) DESCRIBE `ports` 0.0010631084442139
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00031495094299316
(313) DESCRIBE `ports` 0.00092291831970215
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00032806396484375
(315) DESCRIBE `ports` 0.00098705291748047
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00024008750915527
(317) DESCRIBE `ports` 0.00089406967163086
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00027203559875488
(319) DESCRIBE `ports` 0.00091218948364258
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00026416778564453
(321) DESCRIBE `avid_specials` 0.00086402893066406
(322) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51655 and class = 'Cruise') OR (item_id = 1288 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013749599456787
(323) DESCRIBE `cruiselines` 0.0014569759368896
(324) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00043892860412598
(325) DESCRIBE `orchid_image` 0.0012431144714355
(326) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '144') 0.049842119216919
(327) DESCRIBE `cruiselines` 0.0015599727630615
(328) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00028705596923828
(329) DESCRIBE `cruises` 0.0020051002502441
(330) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66217') 0.00088906288146973
(331) DESCRIBE `ships` 0.0021989345550537
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1241))) 0.00063300132751465
(333) DESCRIBE `ships` 0.0026640892028809
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1241') 0.00048708915710449
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002288818359375
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(337) DESCRIBE `itineraries` 0.0010440349578857
(338) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66217') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001410961151123
(339) DESCRIBE `ports` 0.0010890960693359
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00028491020202637
(341) DESCRIBE `ports` 0.00081396102905273
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00024294853210449
(343) DESCRIBE `ports` 0.00099802017211914
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00023007392883301
(345) DESCRIBE `sailingdates` 0.00074601173400879
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66217') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095295906066895
(347) DESCRIBE `ports` 0.001298189163208
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00032305717468262
(349) DESCRIBE `ports` 0.00098085403442383
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00027203559875488
(351) DESCRIBE `ports` 0.0010850429534912
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00041818618774414
(353) DESCRIBE `ports` 0.0010368824005127
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00023508071899414
(355) DESCRIBE `ports` 0.00099897384643555
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00049185752868652
(357) DESCRIBE `ports` 0.0010321140289307
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00027704238891602
(359) DESCRIBE `avid_specials` 0.00092983245849609
(360) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66217 and class = 'Cruise') OR (item_id = 1241 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0016939640045166
(361) DESCRIBE `cruiselines` 0.00166916847229
(362) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0003960132598877
(363) DESCRIBE `orchid_image` 0.0016531944274902
(364) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '120') 0.052843809127808
(365) DESCRIBE `cruiselines` 0.0016329288482666
(366) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0002739429473877
(367) DESCRIBE `cruiselines` 0.00174880027771
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '120', '101', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '225', '229', '140', '170', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '177', '224', '245', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,120,101,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,225,229,140,170,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,177,224,245,257,210,223,263,251') 0.005422830581665
(369) DESCRIBE `ships` 0.0023109912872314
(370) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '974', '10', '349', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '520', '817', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '30', '31', '37', '573', '1285', '1586', '36', '38', '39', '378', '434', '590', '792', '34', '35', '1012', '1376', '327', '526', '970', '43', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1176', '1292', '1382', '1405', '338', '716', '1088', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '610', '852', '966', '1095', '1284', '59', '93', '403', '451', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '9', '75', '616', '666', '784', '1150', '1301', '1501', '503', '996', '1587', '81', '455', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1241', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1087', '1172', '1454', '335', '938', '994', '66', '70', '341', '790', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1262', '1439', '715', '973', '1023', '1043', '1144', '1481', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1543', '1594', '448', '717', '1090', '1110', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '858', '915', '916', '926', '1001', '1072', '1082', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,974,10,349,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,520,817,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,30,31,37,573,1285,1586,36,38,39,378,434,590,792,34,35,1012,1376,327,526,970,43,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1176,1292,1382,1405,338,716,1088,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,610,852,966,1095,1284,59,93,403,451,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,9,75,616,666,784,1150,1301,1501,503,996,1587,81,455,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1241,1366,1372,1411,1571,108,313,776,1141,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,823,883,1253,74,98,147,394,937,1579,1087,1172,1454,335,938,994,66,70,341,790,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1262,1439,715,973,1023,1043,1144,1481,1545,494,673,1136,1137,1240,1282,1303,1437,1543,1594,448,717,1090,1110,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,858,915,916,926,1001,1072,1082,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811') 0.030805110931396
(371) DESCRIBE `cruisetypes` 0.0011959075927734
(372) DESCRIBE `destinations` 0.0013899803161621
(373) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0016200542449951