or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

 
  • River Kwai, Downstream ex Bangkok Return

    Nights 3 Ship River Kwai
    Star Rating River Departs Bangkok (Rivers)
    Sailing 2019: 21 Feb, 28 Feb, 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr, 2 May, 9 May, 16 May, 23 May, 30 May, 6 Jun, 13 Jun, 20 Jun, 27 Jun, 4 Jul More 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 15 Aug, 22 Aug, 29 Aug, 5 Sep, 12 Sep, 19 Sep, 26 Sep, 3 Oct, 10 Oct, 17 Oct, 24 Oct, 31 Oct, 7 Nov, 14 Nov, 21 Nov, 28 Nov, 5 Dec, 12 Dec, 19 Dec, 26 Dec 2020: 2 Jan, 9 Jan, 16 Jan, 23 Jan, 30 Jan, 6 Feb, 13 Feb, 20 Feb, 27 Feb, 5 Mar, 12 Mar, 19 Mar, 26 Mar, 2 Apr, 9 Apr, 16 Apr, 23 Apr, 30 Apr Less
    Ports of Call Bangkok (Rivers), River Cruising
    Please enquire about this cruise for pricing.
  • Gemini, Port Klang, Phuket & Penang ex Port Klang Return

    Nights 3 Ship SuperStar Gemini
    Star Rating 3 Star Departs Port Klang, (Kuala Lumpur), Malaysia
    Sailing 2019: 21 Feb, 24 Feb, 27 Feb, 2 Mar, 5 Mar, 8 Mar, 11 Mar, 14 Mar, 17 Mar, 20 Mar, 23 Mar, 26 Mar, 29 Mar, 1 Apr, 4 Apr, 7 Apr, 10 Apr, 13 Apr, 16 Apr, 19 Apr, 22 Apr, 25 Apr, 28 Apr, 1 May
    Ports of Call Port Klang, Phuket, Penang
    Please enquire about this cruise for pricing.
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

    Nights 2 Ship Bhaya Classic Ships
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2019: 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 More 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, 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 2020: 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, 29 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 2019: 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 More 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, 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.
  • Belmond Road to Mandalay, Taste of Myanmar ex Mandalay to Bagan

    Nights 2 Ship Belmond Road to Mandalay
    Star Rating River Departs Mandalay, Myanmar
    Sailing 2019: 21 Feb, 28 Feb
    Ports of Call Mandalay, Bagan
    Please enquire about this cruise for pricing.
  • Kindat Pandaw, Pagan Mandalay Short Cruise Upstream ex Pagan to Mandalay

    Nights 2 Ship Kindat Pandaw
    Star Rating River Departs Pagan, Myanmar
    Sailing 2019: 21 Feb, 25 Feb, 1 Mar, 5 Mar, 9 Mar, 13 Mar, 17 Mar, 21 Mar, 25 Mar
    Ports of Call Pagan, Yandabo, Mandalay
    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 2019: 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 More 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, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 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 2019: 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 More 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, 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, 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.
  • Katha Pandaw, Pagan Mandalay Short Cruise Upstream ex Pagan to Mandalay

    Nights 2 Ship Katha Pandaw
    Star Rating River Departs Pagan, Myanmar
    Sailing 2019: 21 Feb, 25 Feb, 1 Mar, 5 Mar, 9 Mar, 13 Mar, 17 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: 384

Total elapsed time: 0.56139540672302

# Query Time
(1) connect 0.0010929107666016
(2) DESCRIBE `cruises` 0.0043280124664307
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (59167, 65772, 81660, 44276, 49176, 54263, 56011, 65919, 65921, 66214)) ORDER BY FIND_IN_SET(id, '59167,65772,81660,44276,49176,54263,56011,65919,65921,66214') 0.0028481483459473
(4) DESCRIBE `cruises` 0.0034217834472656
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59167') 0.00071287155151367
(6) DESCRIBE `ships` 0.0038330554962158
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.00063896179199219
(8) DESCRIBE `ships` 0.0039279460906982
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00051617622375488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(12) DESCRIBE `itineraries` 0.0019211769104004
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59167') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012178421020508
(14) DESCRIBE `ports` 0.0021448135375977
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00044703483581543
(16) DESCRIBE `ports` 0.0019419193267822
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00042819976806641
(18) DESCRIBE `ports` 0.0017910003662109
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00038290023803711
(20) DESCRIBE `sailingdates` 0.0016520023345947
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59167') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0017719268798828
(22) DESCRIBE `ports` 0.0019102096557617
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00042986869812012
(24) DESCRIBE `ports` 0.0015890598297119
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00029492378234863
(26) DESCRIBE `ports` 0.0013020038604736
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00042295455932617
(28) DESCRIBE `ports` 0.0015239715576172
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00035190582275391
(30) DESCRIBE `ports` 0.0015320777893066
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00055813789367676
(32) DESCRIBE `ports` 0.0017631053924561
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003821849822998
(34) DESCRIBE `ports` 0.0014560222625732
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.0002901554107666
(36) DESCRIBE `ports` 0.0013189315795898
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00026988983154297
(38) DESCRIBE `avid_specials` 0.0012760162353516
(39) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59167 and class = 'Cruise') OR (item_id = 480 AND class = 'Ship') OR (item_id = 108 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.0010778903961182
(40) DESCRIBE `cruiselines` 0.0019989013671875
(41) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00049591064453125
(42) DESCRIBE `orchid_image` 0.0018727779388428
(43) DESCRIBE `cruiselines` 0.002284049987793
(44) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.00040102005004883
(45) DESCRIBE `cruises` 0.0031042098999023
(46) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65772') 0.0011279582977295
(47) DESCRIBE `ships` 0.0038309097290039
(48) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 70))) 0.0005950927734375
(49) DESCRIBE `ships` 0.0038089752197266
(50) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '70') 0.00045680999755859
(51) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(53) DESCRIBE `itineraries` 0.0021071434020996
(54) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65772') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085282325744629
(55) DESCRIBE `ports` 0.001784086227417
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00049901008605957
(57) DESCRIBE `ports` 0.0017588138580322
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00038599967956543
(59) DESCRIBE `ports` 0.0018990039825439
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00042295455932617
(61) DESCRIBE `sailingdates` 0.0019969940185547
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65772') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084519386291504
(63) DESCRIBE `ports` 0.0015459060668945
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0004279613494873
(65) DESCRIBE `ports` 0.001666784286499
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040197372436523
(67) DESCRIBE `ports` 0.0015161037445068
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039196014404297
(69) DESCRIBE `ports` 0.0016460418701172
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00040388107299805
(71) DESCRIBE `ports` 0.0015370845794678
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00039291381835938
(73) DESCRIBE `ports` 0.0016050338745117
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00046205520629883
(75) DESCRIBE `ports` 0.0016951560974121
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033307075500488
(77) DESCRIBE `ports` 0.0015051364898682
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00043296813964844
(79) DESCRIBE `avid_specials` 0.0014050006866455
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65772 and class = 'Cruise') OR (item_id = 70 AND class = 'Ship') OR (item_id = 16 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.0015170574188232
(81) DESCRIBE `cruiselines` 0.0030460357666016
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00044798851013184
(83) DESCRIBE `orchid_image` 0.0015208721160889
(84) DESCRIBE `cruiselines` 0.0025510787963867
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00046491622924805
(86) DESCRIBE `cruises` 0.0034401416778564
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81660') 0.00047397613525391
(88) DESCRIBE `ships` 0.0029981136322021
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00064587593078613
(90) DESCRIBE `ships` 0.0028109550476074
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.0003960132598877
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027012825012207
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026202201843262
(94) DESCRIBE `itineraries` 0.0013120174407959
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '81660') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083279609680176
(96) DESCRIBE `ports` 0.0016229152679443
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00045394897460938
(98) DESCRIBE `ports` 0.001615047454834
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00037598609924316
(100) DESCRIBE `ports` 0.0013189315795898
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00040102005004883
(102) DESCRIBE `sailingdates` 0.0013680458068848
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '81660') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00092506408691406
(104) DESCRIBE `ports` 0.0022408962249756
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.0004889965057373
(106) DESCRIBE `ports` 0.0019819736480713
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00041699409484863
(108) DESCRIBE `ports` 0.0015380382537842
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00031304359436035
(110) DESCRIBE `ports` 0.0012631416320801
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00029492378234863
(112) DESCRIBE `ports` 0.0012490749359131
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00031399726867676
(114) DESCRIBE `ports` 0.00124192237854
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00029492378234863
(116) DESCRIBE `ports` 0.0012869834899902
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00030517578125
(118) DESCRIBE `ports` 0.0014312267303467
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00027918815612793
(120) DESCRIBE `avid_specials` 0.0012738704681396
(121) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81660 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.0010769367218018
(122) DESCRIBE `cruiselines` 0.0023200511932373
(123) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00033688545227051
(124) DESCRIBE `orchid_image` 0.0020921230316162
(125) DESCRIBE `cruiselines` 0.0020861625671387
(126) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00031495094299316
(127) DESCRIBE `cruises` 0.0031249523162842
(128) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00039196014404297
(129) DESCRIBE `ships` 0.003593921661377
(130) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00042986869812012
(131) DESCRIBE `ships` 0.0034658908843994
(132) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00035786628723145
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(135) DESCRIBE `itineraries` 0.0015380382537842
(136) DESCRIBE `ports` 0.0014901161193848
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039505958557129
(138) DESCRIBE `ports` 0.0015289783477783
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00030684471130371
(140) DESCRIBE `ports` 0.0015358924865723
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040888786315918
(142) DESCRIBE `sailingdates` 0.0013730525970459
(143) DESCRIBE `ports` 0.0020830631256104
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003969669342041
(145) DESCRIBE `ports` 0.0013890266418457
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00036287307739258
(147) DESCRIBE `ports` 0.0013110637664795
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00041103363037109
(149) DESCRIBE `ports` 0.0015478134155273
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038480758666992
(151) DESCRIBE `ports` 0.0019240379333496
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048398971557617
(153) DESCRIBE `ports` 0.0019779205322266
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004279613494873
(155) DESCRIBE `avid_specials` 0.0017261505126953
(156) 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.0013768672943115
(157) DESCRIBE `cruiselines` 0.0026710033416748
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00047898292541504
(159) DESCRIBE `orchid_image` 0.0022540092468262
(160) DESCRIBE `cruiselines` 0.0028738975524902
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00045490264892578
(162) DESCRIBE `cruises` 0.0033168792724609
(163) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.00053000450134277
(164) DESCRIBE `ships` 0.0039310455322266
(165) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00068187713623047
(166) DESCRIBE `ships` 0.0036759376525879
(167) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00054287910461426
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003209114074707
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031089782714844
(170) DESCRIBE `itineraries` 0.0016770362854004
(171) DESCRIBE `ports` 0.0017321109771729
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045299530029297
(173) DESCRIBE `ports` 0.0018179416656494
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037908554077148
(175) DESCRIBE `ports` 0.0017068386077881
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00050187110900879
(177) DESCRIBE `sailingdates` 0.0015659332275391
(178) DESCRIBE `ports` 0.0018019676208496
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036787986755371
(180) DESCRIBE `ports` 0.0013351440429688
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004730224609375
(182) DESCRIBE `ports` 0.0019240379333496
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045204162597656
(184) DESCRIBE `ports` 0.0018148422241211
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041007995605469
(186) DESCRIBE `ports` 0.0016148090362549
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039100646972656
(188) DESCRIBE `ports` 0.0015950202941895
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003511905670166
(190) DESCRIBE `avid_specials` 0.0014228820800781
(191) 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.0016529560089111
(192) DESCRIBE `cruiselines` 0.0024290084838867
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.0005040168762207
(194) DESCRIBE `orchid_image` 0.0020678043365479
(195) DESCRIBE `cruiselines` 0.0025038719177246
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.0004429817199707
(197) DESCRIBE `cruises` 0.0034201145172119
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54263') 0.0004889965057373
(199) DESCRIBE `ships` 0.0035290718078613
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503))) 0.00067615509033203
(201) DESCRIBE `ships` 0.0033330917358398
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.00059795379638672
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031781196594238
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031208992004395
(205) DESCRIBE `itineraries` 0.0015711784362793
(206) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '54263') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078582763671875
(207) DESCRIBE `ports` 0.0018980503082275
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00051689147949219
(209) DESCRIBE `ports` 0.0019209384918213
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00063300132751465
(211) DESCRIBE `ports` 0.0019159317016602
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0005030632019043
(213) DESCRIBE `sailingdates` 0.0015709400177002
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '54263') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00089216232299805
(215) DESCRIBE `ports` 0.0020010471343994
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00046801567077637
(217) DESCRIBE `ports` 0.0014338493347168
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00040984153747559
(219) DESCRIBE `ports` 0.0014119148254395
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00052094459533691
(221) DESCRIBE `ports` 0.0017290115356445
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00049591064453125
(223) DESCRIBE `ports` 0.0013501644134521
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00041794776916504
(225) DESCRIBE `ports` 0.0013420581817627
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00039887428283691
(227) DESCRIBE `avid_specials` 0.0012140274047852
(228) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54263 and class = 'Cruise') OR (item_id = 503 AND class = 'Ship') OR (item_id = 115 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.001762866973877
(229) DESCRIBE `cruiselines` 0.0027740001678467
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00049495697021484
(231) DESCRIBE `orchid_image` 0.0021378993988037
(232) DESCRIBE `cruiselines` 0.0027809143066406
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.00044608116149902
(234) DESCRIBE `cruises` 0.0033152103424072
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56011') 0.00045180320739746
(236) DESCRIBE `ships` 0.0028750896453857
(237) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1243))) 0.00046491622924805
(238) DESCRIBE `ships` 0.0027110576629639
(239) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1243') 0.00039505958557129
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(242) DESCRIBE `itineraries` 0.0013799667358398
(243) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56011') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080585479736328
(244) DESCRIBE `ports` 0.0015668869018555
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00035691261291504
(246) DESCRIBE `ports` 0.0014917850494385
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00031304359436035
(248) DESCRIBE `ports` 0.001399040222168
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00029420852661133
(250) DESCRIBE `sailingdates` 0.0013041496276855
(251) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56011') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0024600028991699
(252) DESCRIBE `ports` 0.0031349658966064
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00039100646972656
(254) DESCRIBE `ports` 0.0015869140625
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00030899047851562
(256) DESCRIBE `ports` 0.0035860538482666
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00046610832214355
(258) DESCRIBE `ports` 0.0018649101257324
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00037121772766113
(260) DESCRIBE `ports` 0.0018370151519775
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00052785873413086
(262) DESCRIBE `ports` 0.0018289089202881
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00046396255493164
(264) DESCRIBE `avid_specials` 0.001615047454834
(265) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56011 and class = 'Cruise') OR (item_id = 1243 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.0016651153564453
(266) DESCRIBE `cruiselines` 0.0026838779449463
(267) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00049614906311035
(268) DESCRIBE `orchid_image` 0.0021159648895264
(269) DESCRIBE `cruiselines` 0.0020260810852051
(270) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00032401084899902
(271) DESCRIBE `cruises` 0.0025291442871094
(272) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00036501884460449
(273) DESCRIBE `ships` 0.0027968883514404
(274) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00048708915710449
(275) DESCRIBE `ships` 0.0028550624847412
(276) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00038886070251465
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026607513427734
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003058910369873
(279) DESCRIBE `itineraries` 0.0018041133880615
(280) DESCRIBE `ports` 0.0017380714416504
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043797492980957
(282) DESCRIBE `ports` 0.0021491050720215
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048494338989258
(284) DESCRIBE `ports` 0.0018188953399658
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00045204162597656
(286) DESCRIBE `sailingdates` 0.0021750926971436
(287) DESCRIBE `ports` 0.001884937286377
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00041294097900391
(289) DESCRIBE `ports` 0.0019080638885498
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040411949157715
(291) DESCRIBE `ports` 0.0014820098876953
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031399726867676
(293) DESCRIBE `ports` 0.0013141632080078
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031900405883789
(295) DESCRIBE `ports` 0.0015869140625
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00044679641723633
(297) DESCRIBE `ports` 0.0017011165618896
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038599967956543
(299) DESCRIBE `avid_specials` 0.0014400482177734
(300) 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.0011279582977295
(301) DESCRIBE `cruiselines` 0.0024018287658691
(302) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00041604042053223
(303) DESCRIBE `orchid_image` 0.0018219947814941
(304) DESCRIBE `cruiselines` 0.002302885055542
(305) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00033807754516602
(306) DESCRIBE `cruises` 0.0030291080474854
(307) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00067496299743652
(308) DESCRIBE `ships` 0.0033631324768066
(309) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00055694580078125
(310) DESCRIBE `ships` 0.0030109882354736
(311) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00032591819763184
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028610229492188
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035309791564941
(314) DESCRIBE `itineraries` 0.0014350414276123
(315) DESCRIBE `ports` 0.0017478466033936
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034189224243164
(317) DESCRIBE `ports` 0.0014669895172119
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034308433532715
(319) DESCRIBE `ports` 0.0014810562133789
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033402442932129
(321) DESCRIBE `sailingdates` 0.0014309883117676
(322) DESCRIBE `ports` 0.0024468898773193
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00054001808166504
(324) DESCRIBE `ports` 0.0020201206207275
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00045299530029297
(326) DESCRIBE `ports` 0.001924991607666
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048589706420898
(328) DESCRIBE `ports` 0.0018270015716553
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038909912109375
(330) DESCRIBE `ports` 0.001845121383667
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003969669342041
(332) DESCRIBE `ports` 0.0017709732055664
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00035595893859863
(334) DESCRIBE `avid_specials` 0.0015850067138672
(335) 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.0018069744110107
(336) DESCRIBE `cruiselines` 0.0025789737701416
(337) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00050210952758789
(338) DESCRIBE `orchid_image` 0.00205397605896
(339) DESCRIBE `cruiselines` 0.0025849342346191
(340) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00039887428283691
(341) DESCRIBE `cruises` 0.003695011138916
(342) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66214') 0.000579833984375
(343) DESCRIBE `ships` 0.0034868717193604
(344) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 993))) 0.00048398971557617
(345) DESCRIBE `ships` 0.0035409927368164
(346) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '993') 0.0004429817199707
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031900405883789
(349) DESCRIBE `itineraries` 0.0018479824066162
(350) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66214') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076603889465332
(351) DESCRIBE `ports` 0.0019948482513428
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00043988227844238
(353) DESCRIBE `ports` 0.0020241737365723
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00045609474182129
(355) DESCRIBE `ports` 0.0019290447235107
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.0004119873046875
(357) DESCRIBE `sailingdates` 0.001643180847168
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66214') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00098490715026855
(359) DESCRIBE `ports` 0.002173900604248
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00041794776916504
(361) DESCRIBE `ports` 0.0018088817596436
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00038504600524902
(363) DESCRIBE `ports` 0.0018680095672607
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00043988227844238
(365) DESCRIBE `ports` 0.0017361640930176
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00034713745117188
(367) DESCRIBE `ports` 0.0016131401062012
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00044393539428711
(369) DESCRIBE `ports` 0.0016989707946777
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00044107437133789
(371) DESCRIBE `avid_specials` 0.001521110534668
(372) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66214 and class = 'Cruise') OR (item_id = 993 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.0018348693847656
(373) DESCRIBE `cruiselines` 0.0026810169219971
(374) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00049304962158203
(375) DESCRIBE `orchid_image` 0.0019881725311279
(376) DESCRIBE `cruiselines` 0.0025439262390137
(377) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00040507316589355
(378) DESCRIBE `cruiselines` 0.002856969833374
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '131', '12', '8', '171', '18', '144', '221', '31', '103', '101', '232', '156', '96', '239', '50', '258', '33', '29', '251', '15', '206', '191', '91', '114', '212', '14', '268', '24', '37', '170', '16', '187', '262', '256', '36', '28', '110', '195', '47', '240', '208', '146', '204', '220', '181', '174', '153', '118', '120', '229', '141', '49', '108', '151', '128', '38', '35', '159', '30', '216', '168', '196', '236', '88', '4', '200', '264', '90', '225', '238', '211', '73', '140', '39', '147', '184', '249', '57', '59', '48', '275', '132', '213', '257', '276', '219', '64', '261', '113', '182', '115', '230', '237', '188', '95', '180', '248', '231', '52', '209', '116', '266', '235', '62', '105', '82', '134', '177', '244', '119', '210', '224', '245', '263')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,131,12,8,171,18,144,221,31,103,101,232,156,96,239,50,258,33,29,251,15,206,191,91,114,212,14,268,24,37,170,16,187,262,256,36,28,110,195,47,240,208,146,204,220,181,174,153,118,120,229,141,49,108,151,128,38,35,159,30,216,168,196,236,88,4,200,264,90,225,238,211,73,140,39,147,184,249,57,59,48,275,132,213,257,276,219,64,261,113,182,115,230,237,188,95,180,248,231,52,209,116,266,235,62,105,82,134,177,244,119,210,224,245,263') 0.0094449520111084
(380) DESCRIBE `ships` 0.0039401054382324
(381) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1555', '1324', '517', '974', '1032', '1794', '1292', '797', '22', '461', '21', '393', '28', '977', '330', '207', '258', '1205', '1599', '480', '349', '1291', '737', '1010', '11', '10', '1199', '439', '404', '333', '1417', '780', '986', '9', '739', '1135', '1588', '14', '726', '265', '1272', '454', '855', '1677', '24', '817', '25', '1359', '770', '731', '1067', '859', '1607', '1237', '3', '113', '1481', '38', '34', '837', '31', '37', '378', '1372', '985', '1594', '1239', '542', '1163', '1744', '1768', '748', '66', '390', '1320', '1526', '1579', '43', '573', '1323', '1422', '1424', '526', '970', '1402', '1413', '39', '1420', '30', '36', '327', '407', '854', '882', '1012', '1411', '1419', '1423', '332', '1418', '1421', '582', '1410', '27', '1454', '160', '590', '1013', '1586', '1773', '791', '792', '674', '958', '1552', '1245', '1284', '580', '35', '114', '441', '1183', '1308', '455', '1184', '1348', '1587', '585', '1193', '1303', '1376', '162', '1415', '1236', '1682', '434', '1159', '1742', '325', '722', '857', '1382', '1461', '1501', '639', '644', '858', '1176', '711', '1215', '1405', '1574', '163', '452', '852', '1412', '462', '658', '683', '1289', '1408', '1678', '78', '81', '119', '285', '338', '1021', '1008', '1172', '673', '1168', '1019', '1373', '69', '1095', '1141', '211', '1160', '111', '610', '678', '776', '850', '1217', '286', '335', '1319', '1383', '1426', '1628', '1782', '1384', '1743', '1711', '45', '253', '1572', '1630', '314', '1569', '348', '403', '451', '851', '869', '1259', '1358', '405', '766', '818', '1302', '1760', '553', '626', '651', '749', '968', '4', '508', '1068', '1266', '1455', '70', '116', '966', '1108', '124', '148', '386', '467', '944', '1082', '1330', '1632', '63', '324', '385', '389', '616', '768', '1260', '1301', '1562', '84', '262', '340', '375', '485', '885', '1195', '1672', '108', '123', '291', '1325', '198', '421', '635', '663', '1639', '1751', '287', '784', '1064', '1088', '483', '1212', '1322', '1575', '98', '1614', '1721', '290', '1208', '1580', '1581', '1781', '652', '703', '883', '954', '1492', '1020', '394', '401', '1321', '1724', '147', '657', '1139', '1398', '1486', '1611', '1722', '1750', '406', '716', '1269', '1601', '1717', '547', '1268', '1539', '1615', '223', '1557', '1738', '149', '150', '152', '341', '516', '1143', '1282', '1326', '1327', '1437', '1445', '1571', '1645', '151', '559', '704', '775', '796', '1771', '717', '1040', '1075', '1704', '105', '545', '886', '1262', '1270', '1444', '1679', '1681', '503', '790', '1151', '1673', '1684', '75', '656', '982', '1254', '1367', '1389', '1063', '1318', '1676', '1740', '205', '351', '574', '761', '1561', '1766', '1043', '1213', '1218', '1471', '1540', '1566', '868', '1144', '1157', '93', '701', '751', '1137', '1223', '1226', '1344', '82', '212', '479', '715', '874', '1027', '1029', '1214', '1229', '1343', '1716', '1767', '665', '808', '823', '884', '1158', '1283', '1452', '1453', '1604', '1772', '687', '1025', '1073', '1090', '1612', '1613', '1706', '201', '266', '795', '988', '1055', '1136', '1216', '1409', '1448', '1713', '1715', '1788', '417', '601', '905', '996', '1026', '1145', '1233', '1458', '1496', '1714', '1791', '695', '767', '1188', '1297', '1602', '1783', '643', '669', '707', '769', '888', '973', '1034', '1149', '1156', '1351', '1366', '1404', '1516', '1609', '448', '743', '979', '1049', '1150', '1155', '1196', '1222', '1231', '1345', '1360', '1361', '1362', '1368', '1414', '1459', '1522', '1647', '1730', '666', '685', '692', '920', '921', '927', '931', '1047', '1230', '1296', '1354', '1474', '1517', '1627', '1729', '74', '423', '914', '923', '997', '1004', '1110', '1253', '1295', '1518', '1567', '618', '915', '916')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1555,1324,517,974,1032,1794,1292,797,22,461,21,393,28,977,330,207,258,1205,1599,480,349,1291,737,1010,11,10,1199,439,404,333,1417,780,986,9,739,1135,1588,14,726,265,1272,454,855,1677,24,817,25,1359,770,731,1067,859,1607,1237,3,113,1481,38,34,837,31,37,378,1372,985,1594,1239,542,1163,1744,1768,748,66,390,1320,1526,1579,43,573,1323,1422,1424,526,970,1402,1413,39,1420,30,36,327,407,854,882,1012,1411,1419,1423,332,1418,1421,582,1410,27,1454,160,590,1013,1586,1773,791,792,674,958,1552,1245,1284,580,35,114,441,1183,1308,455,1184,1348,1587,585,1193,1303,1376,162,1415,1236,1682,434,1159,1742,325,722,857,1382,1461,1501,639,644,858,1176,711,1215,1405,1574,163,452,852,1412,462,658,683,1289,1408,1678,78,81,119,285,338,1021,1008,1172,673,1168,1019,1373,69,1095,1141,211,1160,111,610,678,776,850,1217,286,335,1319,1383,1426,1628,1782,1384,1743,1711,45,253,1572,1630,314,1569,348,403,451,851,869,1259,1358,405,766,818,1302,1760,553,626,651,749,968,4,508,1068,1266,1455,70,116,966,1108,124,148,386,467,944,1082,1330,1632,63,324,385,389,616,768,1260,1301,1562,84,262,340,375,485,885,1195,1672,108,123,291,1325,198,421,635,663,1639,1751,287,784,1064,1088,483,1212,1322,1575,98,1614,1721,290,1208,1580,1581,1781,652,703,883,954,1492,1020,394,401,1321,1724,147,657,1139,1398,1486,1611,1722,1750,406,716,1269,1601,1717,547,1268,1539,1615,223,1557,1738,149,150,152,341,516,1143,1282,1326,1327,1437,1445,1571,1645,151,559,704,775,796,1771,717,1040,1075,1704,105,545,886,1262,1270,1444,1679,1681,503,790,1151,1673,1684,75,656,982,1254,1367,1389,1063,1318,1676,1740,205,351,574,761,1561,1766,1043,1213,1218,1471,1540,1566,868,1144,1157,93,701,751,1137,1223,1226,1344,82,212,479,715,874,1027,1029,1214,1229,1343,1716,1767,665,808,823,884,1158,1283,1452,1453,1604,1772,687,1025,1073,1090,1612,1613,1706,201,266,795,988,1055,1136,1216,1409,1448,1713,1715,1788,417,601,905,996,1026,1145,1233,1458,1496,1714,1791,695,767,1188,1297,1602,1783,643,669,707,769,888,973,1034,1149,1156,1351,1366,1404,1516,1609,448,743,979,1049,1150,1155,1196,1222,1231,1345,1360,1361,1362,1368,1414,1459,1522,1647,1730,666,685,692,920,921,927,931,1047,1230,1296,1354,1474,1517,1627,1729,74,423,914,923,997,1004,1110,1253,1295,1518,1567,618,915,916') 0.051249980926514
(382) DESCRIBE `cruisetypes` 0.0016381740570068
(383) DESCRIBE `destinations` 0.0017619132995605
(384) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '39', '44', '55', '53', '26', '28', '38', '49', '11', '21', '40', '7', '56', '30', '48', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,39,44,55,53,26,28,38,49,11,21,40,7,56,30,48,46,29,45,34,10,52,32') 0.00199294090271