or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

 
  • Spirit, Weekend Sampler Cruise ex Sydney Return

    Nights 3 Ship Carnival Spirit
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2019: 17 Jan, 8 Feb, 19 Apr, 7 Jun, 2 Aug, 23 Aug, 31 Oct, 6 Dec
    Ports of Call Sydney

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Imagination, Baja Mexico ex Los Angeles Return

    Nights 3 Ship Carnival Imagination
    Star Rating 4 Star Departs Los Angeles, California, USA
    Sailing 2019: 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr, 30 Apr, 2 May, 9 May, 16 May, 23 May More 6 Jun, 13 Jun, 20 Jun, 27 Jun, 4 Jul, 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 Less
    Ports of Call Los Angeles, Ensenada
    Please enquire about this cruise for pricing.
  • Liberty, Bahamas Cruise ex Port Canaveral Return

    Nights 3 Ship Carnival Liberty
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2019: 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr
    Ports of Call Port Canaveral, Nassau
    Please enquire about this cruise for pricing.
  • River Kwai, Downstream ex Bangkok Return

    Nights 3 Ship River Kwai
    Star Rating River Departs Bangkok (Rivers)
    Sailing 2019: 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 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 More 6 Jun, 13 Jun, 20 Jun, 27 Jun, 4 Jul, 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, Phuket, Penang & Port Klang ex Phuket Return

    Nights 3 Ship SuperStar Gemini
    Star Rating 3 Star Departs Phuket, Thailand
    Sailing 2019: 17 Jan, 23 Jan, 26 Jan, 29 Jan
    Ports of Call Phuket, Penang, Port Klang
    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: 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 More 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, 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.
  • 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: 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb
    Ports of Call Mandalay, Bagan
    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: 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 More 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, 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: 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 More 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, 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.
 

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

Total elapsed time: 0.47915697097778

# Query Time
(1) connect 0.00078606605529785
(2) DESCRIBE `cruises` 0.0031459331512451
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41778, 52647, 56886, 59167, 69356, 44276, 49176, 54263, 65919, 65921)) ORDER BY FIND_IN_SET(id, '41778,52647,56886,59167,69356,44276,49176,54263,65919,65921') 0.0018770694732666
(4) DESCRIBE `cruises` 0.0028550624847412
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00043606758117676
(6) DESCRIBE `ships` 0.0033049583435059
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00047111511230469
(8) DESCRIBE `ships` 0.0027050971984863
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00031089782714844
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031805038452148
(12) DESCRIBE `itineraries` 0.0020358562469482
(13) DESCRIBE `ports` 0.002094030380249
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047111511230469
(15) DESCRIBE `ports` 0.0017960071563721
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052905082702637
(17) DESCRIBE `ports` 0.0018370151519775
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040602684020996
(19) DESCRIBE `sailingdates` 0.0015339851379395
(20) DESCRIBE `ports` 0.0014219284057617
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042390823364258
(22) DESCRIBE `ports` 0.0013349056243896
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030803680419922
(24) DESCRIBE `ports` 0.001284122467041
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031280517578125
(26) DESCRIBE `ports` 0.0013070106506348
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(28) DESCRIBE `avid_specials` 0.0013031959533691
(29) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010750293731689
(30) DESCRIBE `cruiselines` 0.0020430088043213
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032687187194824
(32) DESCRIBE `orchid_image` 0.0016171932220459
(33) DESCRIBE `cruiselines` 0.0027709007263184
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00053286552429199
(35) DESCRIBE `cruises` 0.0023949146270752
(36) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52647') 0.00041604042053223
(37) DESCRIBE `ships` 0.0027730464935303
(38) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 21))) 0.00040817260742188
(39) DESCRIBE `ships` 0.0022249221801758
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '21') 0.00084495544433594
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001530647277832
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(43) DESCRIBE `itineraries` 0.0014808177947998
(44) DESCRIBE `ports` 0.0013132095336914
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00047206878662109
(46) DESCRIBE `ports` 0.0017077922821045
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00040888786315918
(48) DESCRIBE `ports` 0.0020120143890381
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00025701522827148
(50) DESCRIBE `sailingdates` 0.0012490749359131
(51) DESCRIBE `ports` 0.0017809867858887
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020980834960938
(53) DESCRIBE `ports` 0.0015609264373779
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0012199878692627
(55) DESCRIBE `ports` 0.0020718574523926
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00041294097900391
(57) DESCRIBE `ports` 0.0017099380493164
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.0003058910369873
(59) DESCRIBE `ports` 0.0013411045074463
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033712387084961
(61) DESCRIBE `ports` 0.0013179779052734
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 6.3896179199219E-5
(63) DESCRIBE `avid_specials` 0.00073719024658203
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52647 and class = 'Cruise') OR (item_id = 21 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010941028594971
(65) DESCRIBE `cruiselines` 0.00189208984375
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0003349781036377
(67) DESCRIBE `orchid_image` 0.0016229152679443
(68) DESCRIBE `cruiselines` 0.0018870830535889
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0003960132598877
(70) DESCRIBE `cruises` 0.00301194190979
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56886') 0.00038695335388184
(72) DESCRIBE `ships` 0.0026950836181641
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00053215026855469
(74) DESCRIBE `ships` 0.0028071403503418
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00034594535827637
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(78) DESCRIBE `itineraries` 0.0013878345489502
(79) DESCRIBE `ports` 0.0012798309326172
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0
(81) DESCRIBE `ports` 0.0012750625610352
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0005650520324707
(83) DESCRIBE `ports` 0.00146484375
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00027990341186523
(85) DESCRIBE `sailingdates` 0.0011429786682129
(86) DESCRIBE `ports` 0.0014710426330566
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0009310245513916
(88) DESCRIBE `ports` 0.00092911720275879
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0002899169921875
(90) DESCRIBE `ports` 0.0013349056243896
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0
(92) DESCRIBE `ports` 0.0013649463653564
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034618377685547
(94) DESCRIBE `ports` 0.0016331672668457
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029611587524414
(96) DESCRIBE `ports` 0.0013298988342285
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00028395652770996
(98) DESCRIBE `avid_specials` 0.0012350082397461
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56886 and class = 'Cruise') OR (item_id = 461 AND class = 'Ship') OR (item_id = 218 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.0011460781097412
(100) DESCRIBE `cruiselines` 0.0020442008972168
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00041604042053223
(102) DESCRIBE `orchid_image` 0.0015959739685059
(103) DESCRIBE `cruiselines` 0.0019731521606445
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00032997131347656
(105) DESCRIBE `cruises` 0.0022099018096924
(106) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59167') 0.00099396705627441
(107) DESCRIBE `ships` 0.0021369457244873
(108) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.0003359317779541
(109) DESCRIBE `ships` 0.0023720264434814
(110) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00090694427490234
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(113) DESCRIBE `itineraries` 0.0012860298156738
(114) DESCRIBE `ports` 0.0013988018035889
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.0003058910369873
(116) DESCRIBE `ports` 0.001384973526001
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0
(118) DESCRIBE `ports` 0.0012989044189453
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.0002741813659668
(120) DESCRIBE `sailingdates` 0.0017049312591553
(121) DESCRIBE `ports` 0.0017950534820557
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00033879280090332
(123) DESCRIBE `ports` 0.0013298988342285
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00033998489379883
(125) DESCRIBE `ports` 0.0015521049499512
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030899047851562
(127) DESCRIBE `ports` 0.0014910697937012
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00027704238891602
(129) DESCRIBE `ports` 0.0013599395751953
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00036311149597168
(131) DESCRIBE `ports` 0.0012729167938232
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029301643371582
(133) DESCRIBE `ports` 0.001276969909668
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00033998489379883
(135) DESCRIBE `ports` 0.0012490749359131
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.0002901554107666
(137) DESCRIBE `avid_specials` 0.0012929439544678
(138) 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.00099587440490723
(139) DESCRIBE `cruiselines` 0.001971960067749
(140) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00032496452331543
(141) DESCRIBE `orchid_image` 0.0017580986022949
(142) DESCRIBE `cruiselines` 0.0019609928131104
(143) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.00030994415283203
(144) DESCRIBE `cruises` 0.002777099609375
(145) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69356') 0.00030398368835449
(146) DESCRIBE `ships` 0.0028378963470459
(147) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00040197372436523
(148) DESCRIBE `ships` 0.002957820892334
(149) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00040197372436523
(150) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029397010803223
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00033807754516602
(152) DESCRIBE `itineraries` 0.0020091533660889
(153) DESCRIBE `ports` 0.0015761852264404
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00040507316589355
(155) DESCRIBE `ports` 0.0016319751739502
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00043797492980957
(157) DESCRIBE `ports` 0.0015490055084229
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 4.9829483032227E-5
(159) DESCRIBE `sailingdates` 0.00130295753479
(160) DESCRIBE `ports` 0.0016860961914062
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00089216232299805
(162) DESCRIBE `ports` 0.0014908313751221
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00034403800964355
(164) DESCRIBE `ports` 0.0015931129455566
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00039291381835938
(166) DESCRIBE `ports` 0.0018329620361328
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00034499168395996
(168) DESCRIBE `ports` 0.001533031463623
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00041604042053223
(170) DESCRIBE `ports` 0.0019469261169434
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00036311149597168
(172) DESCRIBE `ports` 0.0016989707946777
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00031805038452148
(174) DESCRIBE `ports` 0.0012719631195068
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00028204917907715
(176) DESCRIBE `avid_specials` 0.0012450218200684
(177) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69356 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.00099515914916992
(178) DESCRIBE `cruiselines` 0.0019609928131104
(179) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.0003349781036377
(180) DESCRIBE `orchid_image` 0.0014629364013672
(181) DESCRIBE `cruiselines` 0.0018730163574219
(182) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00033283233642578
(183) DESCRIBE `cruises` 0.0026299953460693
(184) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00034189224243164
(185) DESCRIBE `ships` 0.0034840106964111
(186) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.0005948543548584
(187) DESCRIBE `ships` 0.0039770603179932
(188) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00042009353637695
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028395652770996
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(191) DESCRIBE `itineraries` 0.0017509460449219
(192) DESCRIBE `ports` 0.0017750263214111
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0
(194) DESCRIBE `ports` 0.0028669834136963
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040292739868164
(196) DESCRIBE `ports` 0.0018181800842285
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0
(198) DESCRIBE `sailingdates` 0.0017108917236328
(199) DESCRIBE `ports` 0.0017428398132324
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038814544677734
(201) DESCRIBE `ports` 0.0013589859008789
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031399726867676
(203) DESCRIBE `ports` 0.0014348030090332
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0
(205) DESCRIBE `ports` 0.0013577938079834
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030016899108887
(207) DESCRIBE `ports` 0.0016629695892334
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003669261932373
(209) DESCRIBE `ports` 0.0022308826446533
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 2.3126602172852E-5
(211) DESCRIBE `avid_specials` 0.0011420249938965
(212) 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.0019478797912598
(213) DESCRIBE `cruiselines` 0.0022170543670654
(214) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0
(215) DESCRIBE `orchid_image` 0.0015289783477783
(216) DESCRIBE `cruiselines` 0.0023510456085205
(217) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00044012069702148
(218) DESCRIBE `cruises` 0.0027039051055908
(219) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.00040888786315918
(220) DESCRIBE `ships` 0.0031731128692627
(221) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00064611434936523
(222) DESCRIBE `ships` 0.0039608478546143
(223) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00061392784118652
(224) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032591819763184
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025510787963867
(226) DESCRIBE `itineraries` 0.0016810894012451
(227) DESCRIBE `ports` 0.0019338130950928
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045013427734375
(229) DESCRIBE `ports` 0.0013368129730225
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031113624572754
(231) DESCRIBE `ports` 0.0014400482177734
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031399726867676
(233) DESCRIBE `sailingdates` 0.0012719631195068
(234) DESCRIBE `ports` 0.00097489356994629
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003659725189209
(236) DESCRIBE `ports` 0.0013771057128906
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00034689903259277
(238) DESCRIBE `ports` 0.0013489723205566
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0
(240) DESCRIBE `ports` 0.0011870861053467
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031185150146484
(242) DESCRIBE `ports` 0.0013558864593506
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00032401084899902
(244) DESCRIBE `ports` 0.0013229846954346
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030088424682617
(246) DESCRIBE `avid_specials` 0.0011570453643799
(247) 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.0016269683837891
(248) DESCRIBE `cruiselines` 0.0020499229431152
(249) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00048613548278809
(250) DESCRIBE `orchid_image` 0.0020301342010498
(251) DESCRIBE `cruiselines` 0.0024459362030029
(252) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00045204162597656
(253) DESCRIBE `cruises` 0.0026848316192627
(254) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54263') 0.00032591819763184
(255) DESCRIBE `ships` 0.0026199817657471
(256) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503))) 0.00052213668823242
(257) DESCRIBE `ships` 0.0030028820037842
(258) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.00043797492980957
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026202201843262
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026607513427734
(261) DESCRIBE `itineraries` 0.0017619132995605
(262) DESCRIBE `ports` 0.001568078994751
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00084304809570312
(264) DESCRIBE `ports` 0.0012259483337402
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00037884712219238
(266) DESCRIBE `ports` 0.0015590190887451
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00035500526428223
(268) DESCRIBE `sailingdates` 0.0012509822845459
(269) DESCRIBE `ports` 0.001633882522583
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00098609924316406
(271) DESCRIBE `ports` 0.0011410713195801
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00040483474731445
(273) DESCRIBE `ports` 0.0018410682678223
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00058197975158691
(275) DESCRIBE `ports` 0.0017619132995605
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00050806999206543
(277) DESCRIBE `ports` 0.0016701221466064
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.0005500316619873
(279) DESCRIBE `ports` 0.0019769668579102
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.0005030632019043
(281) DESCRIBE `avid_specials` 0.0014879703521729
(282) 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.0011100769042969
(283) DESCRIBE `cruiselines` 0.0021488666534424
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00040698051452637
(285) DESCRIBE `orchid_image` 0.0018479824066162
(286) DESCRIBE `cruiselines` 0.0023338794708252
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.00035715103149414
(288) DESCRIBE `cruises` 0.0042629241943359
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00045609474182129
(290) DESCRIBE `ships` 0.0031440258026123
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.0013260841369629
(292) DESCRIBE `ships` 0.003593921661377
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00052809715270996
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0012590885162354
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0
(296) DESCRIBE `itineraries` 0.0018579959869385
(297) DESCRIBE `ports` 0.0013060569763184
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003819465637207
(299) DESCRIBE `ports` 0.0014209747314453
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003509521484375
(301) DESCRIBE `ports` 0.0014090538024902
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0
(303) DESCRIBE `sailingdates` 0.0010440349578857
(304) DESCRIBE `ports` 0.0017821788787842
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049591064453125
(306) DESCRIBE `ports` 0.0014619827270508
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00032520294189453
(308) DESCRIBE `ports` 0.001594066619873
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040912628173828
(310) DESCRIBE `ports` 0.0016098022460938
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003659725189209
(312) DESCRIBE `ports` 0.0013701915740967
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035405158996582
(314) DESCRIBE `ports` 0.0013110637664795
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028800964355469
(316) DESCRIBE `avid_specials` 0.0014247894287109
(317) 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.0016679763793945
(318) DESCRIBE `cruiselines` 0.0026149749755859
(319) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00045514106750488
(320) DESCRIBE `orchid_image` 0.0021169185638428
(321) DESCRIBE `cruiselines` 0.0022120475769043
(322) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.0003049373626709
(323) DESCRIBE `cruises` 0.0026669502258301
(324) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00033307075500488
(325) DESCRIBE `ships` 0.0030238628387451
(326) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00043296813964844
(327) DESCRIBE `ships` 0.0026979446411133
(328) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00030088424682617
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003199577331543
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030303001403809
(331) DESCRIBE `itineraries` 0.0016629695892334
(332) DESCRIBE `ports` 0.0023918151855469
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047993659973145
(334) DESCRIBE `ports` 0.0018041133880615
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00010204315185547
(336) DESCRIBE `ports` 0.0027129650115967
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003960132598877
(338) DESCRIBE `sailingdates` 0.0014631748199463
(339) DESCRIBE `ports` 0.0022499561309814
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004580020904541
(341) DESCRIBE `ports` 0.001500129699707
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031304359436035
(343) DESCRIBE `ports` 0.0014610290527344
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035309791564941
(345) DESCRIBE `ports` 0.00152587890625
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00029420852661133
(347) DESCRIBE `ports` 0.001378059387207
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029492378234863
(349) DESCRIBE `ports` 0.0014321804046631
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00032496452331543
(351) DESCRIBE `avid_specials` 0.0011739730834961
(352) 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.0011229515075684
(353) DESCRIBE `cruiselines` 0.0019838809967041
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00037693977355957
(355) DESCRIBE `orchid_image` 0.00201416015625
(356) DESCRIBE `cruiselines` 0.0028369426727295
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00042819976806641
(358) DESCRIBE `cruiselines` 0.0030708312988281
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '12', '8', '18', '171', '221', '144', '31', '101', '103', '232', '131', '96', '50', '29', '239', '258', '15', '191', '251', '206', '33', '91', '114', '170', '37', '14', '16', '24', '268', '262', '36', '256', '28', '120', '195', '47', '240', '208', '146', '110', '156', '174', '187', '220', '141', '153', '118', '229', '108', '49', '151', '128', '35', '30', '216', '168', '196', '181', '236', '88', '4', '200', '212', '38', '264', '73', '225', '238', '159', '90', '211', '39', '147', '115', '140', '184', '249', '59', '48', '257', '275', '219', '132', '213', '276', '230', '113', '182', '261', '64', '188', '237', '57', '180', '95', '248', '235', '209', '62', '231', '52', '116', '266', '105', '82', '177', '119', '134', '244', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,12,8,18,171,221,144,31,101,103,232,131,96,50,29,239,258,15,191,251,206,33,91,114,170,37,14,16,24,268,262,36,256,28,120,195,47,240,208,146,110,156,174,187,220,141,153,118,229,108,49,151,128,35,30,216,168,196,181,236,88,4,200,212,38,264,73,225,238,159,90,211,39,147,115,140,184,249,59,48,257,275,219,132,213,276,230,113,182,261,64,188,237,57,180,95,248,235,209,62,231,52,116,266,105,82,177,119,134,244,210,224,245') 0.0062351226806641
(360) DESCRIBE `ships` 0.0031049251556396
(361) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1127', '1554', '1555', '1247', '1324', '517', '1032', '974', '797', '21', '22', '461', '1292', '393', '207', '28', '977', '1205', '330', '258', '480', '1291', '1599', '737', '1199', '1010', '1417', '11', '10', '780', '349', '439', '9', '333', '404', '739', '1135', '986', '1359', '14', '454', '1272', '265', '1677', '855', '1237', '24', '25', '731', '1067', '859', '817', '1594', '770', '1607', '113', '1481', '1588', '3', '31', '37', '38', '837', '34', '378', '985', '1239', '1372', '542', '407', '390', '39', '1320', '30', '43', '748', '1579', '36', '970', '1012', '573', '726', '1323', '1402', '1744', '66', '854', '1376', '1768', '526', '582', '1245', '27', '1422', '1424', '327', '332', '882', '1413', '590', '1420', '1552', '1411', '1419', '1423', '1284', '1418', '1421', '1586', '35', '791', '792', '1410', '441', '674', '1773', '585', '1587', '1183', '1415', '455', '1184', '114', '580', '857', '1501', '858', '1176', '711', '1193', '1382', '434', '462', '1236', '1405', '1574', '162', '722', '1215', '1682', '325', '160', '1742', '452', '639', '285', '1021', '1141', '1454', '78', '119', '658', '683', '852', '81', '1008', '1412', '69', '1168', '338', '1095', '1408', '1678', '1760', '1373', '1572', '163', '678', '1172', '869', '1082', '776', '850', '1319', '211', '335', '1630', '111', '253', '610', '1782', '45', '314', '403', '503', '1302', '1383', '1569', '1628', '124', '348', '451', '1259', '1384', '70', '340', '405', '4', '116', '766', '968', '1711', '635', '966', '626', '651', '851', '944', '1159', '148', '286', '386', '553', '63', '324', '385', '508', '749', '768', '1303', '1330', '123', '262', '389', '559', '1068', '1260', '1455', '198', '485', '616', '1266', '1301', '375', '406', '467', '1088', '1108', '1325', '1632', '1672', '84', '291', '784', '1212', '1562', '1575', '287', '1195', '108', '483', '716', '1208', '1781', '98', '421', '1639', '290', '401', '1064', '1571', '394', '1398', '1492', '1614', '1645', '1721', '652', '657', '1308', '883', '954', '147', '150', '152', '341', '1321', '1389', '1724', '149', '151', '223', '704', '874', '1139', '1486', '1611', '1722', '775', '885', '1269', '1539', '1601', '1717', '1268', '1615', '547', '958', '1289', '1557', '1738', '105', '1143', '1326', '1327', '1437', '545', '717', '1771', '351', '516', '1040', '1075', '1704', '75', '790', '818', '1270', '1471', '1679', '868', '1063', '1151', '1213', '1282', '1673', '1684', '796', '823', '1367', '479', '574', '665', '1013', '1214', '1262', '1318', '1676', '1740', '82', '93', '205', '701', '1561', '1766', '520', '1043', '1218', '1460', '1526', '1540', '1566', '644', '673', '715', '988', '1144', '1157', '743', '751', '1137', '1223', '1226', '1344', '212', '266', '669', '884', '1027', '1029', '1163', '1229', '1343', '1409', '1602', '1716', '201', '795', '1160', '1217', '1283', '1452', '1453', '1604', '707', '769', '1025', '1090', '1414', '1612', '1613', '1055', '1073', '1136', '1216', '1426', '1448', '1713', '1715', '417', '448', '601', '695', '905', '996', '1019', '1026', '1110', '1145', '1233', '1243', '1253', '1458', '1496', '1714', '643', '1188', '1211', '1743', '1772', '1783', '74', '888', '973', '997', '1034', '1149', '1351', '1358', '1366', '1404', '1516', '1609', '811', '1049', '1150', '1196', '1222', '1231', '1241', '1345', '1360', '1361', '1362', '1368', '1395', '1449', '1459', '1522', '1619', '1647', '1730', '618', '666', '920', '921', '927', '931', '1047', '1152', '1230', '1354', '1474', '1627', '1663', '1729', '261', '423', '733', '914', '923', '993', '1004', '1322', '1348', '1517', '1518', '1567', '1580', '663', '740', '836', '915', '916', '926', '930', '1037', '1042', '1072', '1138', '1521', '1674', '1708', '1751', '453', '494', '499', '703', '709')) ORDER BY FIND_IN_SET(id, '1761,1127,1554,1555,1247,1324,517,1032,974,797,21,22,461,1292,393,207,28,977,1205,330,258,480,1291,1599,737,1199,1010,1417,11,10,780,349,439,9,333,404,739,1135,986,1359,14,454,1272,265,1677,855,1237,24,25,731,1067,859,817,1594,770,1607,113,1481,1588,3,31,37,38,837,34,378,985,1239,1372,542,407,390,39,1320,30,43,748,1579,36,970,1012,573,726,1323,1402,1744,66,854,1376,1768,526,582,1245,27,1422,1424,327,332,882,1413,590,1420,1552,1411,1419,1423,1284,1418,1421,1586,35,791,792,1410,441,674,1773,585,1587,1183,1415,455,1184,114,580,857,1501,858,1176,711,1193,1382,434,462,1236,1405,1574,162,722,1215,1682,325,160,1742,452,639,285,1021,1141,1454,78,119,658,683,852,81,1008,1412,69,1168,338,1095,1408,1678,1760,1373,1572,163,678,1172,869,1082,776,850,1319,211,335,1630,111,253,610,1782,45,314,403,503,1302,1383,1569,1628,124,348,451,1259,1384,70,340,405,4,116,766,968,1711,635,966,626,651,851,944,1159,148,286,386,553,63,324,385,508,749,768,1303,1330,123,262,389,559,1068,1260,1455,198,485,616,1266,1301,375,406,467,1088,1108,1325,1632,1672,84,291,784,1212,1562,1575,287,1195,108,483,716,1208,1781,98,421,1639,290,401,1064,1571,394,1398,1492,1614,1645,1721,652,657,1308,883,954,147,150,152,341,1321,1389,1724,149,151,223,704,874,1139,1486,1611,1722,775,885,1269,1539,1601,1717,1268,1615,547,958,1289,1557,1738,105,1143,1326,1327,1437,545,717,1771,351,516,1040,1075,1704,75,790,818,1270,1471,1679,868,1063,1151,1213,1282,1673,1684,796,823,1367,479,574,665,1013,1214,1262,1318,1676,1740,82,93,205,701,1561,1766,520,1043,1218,1460,1526,1540,1566,644,673,715,988,1144,1157,743,751,1137,1223,1226,1344,212,266,669,884,1027,1029,1163,1229,1343,1409,1602,1716,201,795,1160,1217,1283,1452,1453,1604,707,769,1025,1090,1414,1612,1613,1055,1073,1136,1216,1426,1448,1713,1715,417,448,601,695,905,996,1019,1026,1110,1145,1233,1243,1253,1458,1496,1714,643,1188,1211,1743,1772,1783,74,888,973,997,1034,1149,1351,1358,1366,1404,1516,1609,811,1049,1150,1196,1222,1231,1241,1345,1360,1361,1362,1368,1395,1449,1459,1522,1619,1647,1730,618,666,920,921,927,931,1047,1152,1230,1354,1474,1627,1663,1729,261,423,733,914,923,993,1004,1322,1348,1517,1518,1567,1580,663,740,836,915,916,926,930,1037,1042,1072,1138,1521,1674,1708,1751,453,494,499,703,709') 0.046314001083374
(362) DESCRIBE `cruisetypes` 0.0017468929290771
(363) DESCRIBE `destinations` 0.0019071102142334
(364) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '44', '55', '53', '39', '26', '38', '28', '49', '7', '40', '11', '21', '48', '56', '30', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,44,55,53,39,26,38,28,49,7,40,11,21,48,56,30,46,29,45,34,10,52,32') 0.0017588138580322