or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

 
  • Disney Dream, Very Merrytime Bahamian Cruise ex Port Canaveral Return

    Nights 3 Ship Disney Dream
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2018: 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec 2019: 5 Nov, 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec
    Ports of Call Port Canaveral, Nassau, Castaway Cay

    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.

  • Mariner, Bahamas Cruise ex Miami Return

    Nights 3 Ship Mariner of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2018: 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec, 28 Dec 2019: 4 Jan, 11 Jan, 18 Jan, 25 Jan, 1 Feb, 8 Feb, 15 Feb, 22 Feb, 1 Mar, 8 Mar, 15 Mar, 22 Mar, 29 Mar, 5 Apr, 12 Apr, 19 Apr, 26 Apr
    Ports of Call Miami, Cococay, Nassau

    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.

  • Fascinosa, Spain France Italy ex Barcelona Roundtrip

    Nights 3 Ship Costa Fascinosa
    Star Rating 4 Star Departs Barcelona, Spain
    Sailing 2018: 23 Nov
    Ports of Call Barcelona, Marseilles, Savona
    Please enquire about this cruise for pricing.
  • Enchantment, Bahamas ex Port Canaveral Return

    Nights 3 Ship Enchantment of the Seas
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2018: 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec 2019: 4 Jan, 11 Jan, 18 Jan, 25 Jan, 1 Feb, 8 Feb, 15 Feb, 22 Feb, 1 Mar, 8 Mar, 22 Mar, 29 Mar, 5 Apr, 12 Apr, 19 Apr, 26 Apr
    Ports of Call Port Canaveral, Nassau, Cococay

    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.

  • Sun Boat IV, Nile Cruise ex Aswan to Luxor

    Nights 3 Ship Sanctuary Sun Boat IV
    Star Rating River Departs Aswan, Egypt
    Sailing 2018: 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec, 28 Dec 2019: 4 Jan, 11 Jan, 18 Jan, 25 Jan, 1 Feb, 8 Feb, 15 Feb, 22 Feb, 1 Mar, 8 Mar, 15 Mar, 22 Mar, 29 Mar
    Ports of Call Aswan, Kom Ombo, Edfu, Luxor
    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 2018: 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 More 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • VSpirit Classic, Halong Bay 2 Nights ex Halong Bay Return

    Nights 2 Ship VSpirit Classic
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 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 More 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
  • Jasmine, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 Ship Jasmine
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 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 More 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 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

    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.

  • Violet, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 Ship Violet
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 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 More 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec 2019: 1 Jan, 2 Jan, 3 Jan, 4 Jan, 5 Jan, 6 Jan, 7 Jan, 8 Jan, 9 Jan, 10 Jan, 11 Jan, 12 Jan, 13 Jan, 14 Jan, 15 Jan, 16 Jan, 17 Jan, 18 Jan, 19 Jan, 20 Jan, 21 Jan, 22 Jan, 23 Jan, 24 Jan, 25 Jan, 26 Jan, 27 Jan, 28 Jan, 29 Jan, 30 Jan, 31 Jan, 1 Feb, 2 Feb, 3 Feb, 4 Feb, 5 Feb, 6 Feb, 7 Feb, 8 Feb, 9 Feb, 10 Feb, 11 Feb, 12 Feb, 13 Feb, 14 Feb, 15 Feb, 16 Feb, 17 Feb, 18 Feb, 19 Feb, 20 Feb, 21 Feb, 22 Feb, 23 Feb, 24 Feb, 25 Feb, 26 Feb, 27 Feb, 28 Feb, 1 Mar, 2 Mar, 3 Mar, 4 Mar, 5 Mar, 6 Mar, 7 Mar, 8 Mar, 9 Mar, 10 Mar, 11 Mar, 12 Mar, 13 Mar, 14 Mar, 15 Mar, 16 Mar, 17 Mar, 18 Mar, 19 Mar, 20 Mar, 21 Mar, 22 Mar, 23 Mar, 24 Mar, 25 Mar, 26 Mar, 27 Mar, 28 Mar, 29 Mar, 30 Mar, 31 Mar, 1 Apr, 2 Apr, 3 Apr, 4 Apr, 5 Apr, 6 Apr, 7 Apr, 8 Apr, 9 Apr, 10 Apr, 11 Apr, 12 Apr, 13 Apr, 14 Apr, 15 Apr, 16 Apr, 17 Apr, 18 Apr, 19 Apr, 20 Apr, 21 Apr, 22 Apr, 23 Apr, 24 Apr, 25 Apr, 26 Apr, 27 Apr, 28 Apr, 29 Apr, 30 Apr, 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: 392

Total elapsed time: 0.64647793769836

# Query Time
(1) connect 0.0013370513916016
(2) DESCRIBE `cruises` 0.0041871070861816
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65774, 69405, 69614, 73547, 73661, 80304, 44276, 49176, 65919, 65921)) ORDER BY FIND_IN_SET(id, '65774,69405,69614,73547,73661,80304,44276,49176,65919,65921') 0.0029239654541016
(4) DESCRIBE `cruises` 0.0035219192504883
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65774') 0.00052094459533691
(6) DESCRIBE `ships` 0.0038042068481445
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 837))) 0.0005800724029541
(8) DESCRIBE `ships` 0.0033040046691895
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00081396102905273
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00075101852416992
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029516220092773
(12) DESCRIBE `itineraries` 0.0016870498657227
(13) DESCRIBE `ports` 0.0016989707946777
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00045609474182129
(15) DESCRIBE `ports` 0.0023870468139648
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039911270141602
(17) DESCRIBE `ports` 0.0016591548919678
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00032401084899902
(19) DESCRIBE `sailingdates` 0.0014629364013672
(20) DESCRIBE `ports` 0.001737117767334
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00037622451782227
(22) DESCRIBE `ports` 0.0013351440429688
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00029397010803223
(24) DESCRIBE `ports` 0.0012760162353516
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0003809928894043
(26) DESCRIBE `ports` 0.0017139911651611
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0002899169921875
(28) DESCRIBE `ports` 0.0012860298156738
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00031805038452148
(30) DESCRIBE `ports` 0.0013880729675293
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00034093856811523
(32) DESCRIBE `ports` 0.0013542175292969
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00044894218444824
(34) DESCRIBE `ports` 0.0014100074768066
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00029516220092773
(36) DESCRIBE `avid_specials` 0.0011749267578125
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65774 and class = 'Cruise') OR (item_id = 837 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.001115083694458
(38) DESCRIBE `cruiselines` 0.0022628307342529
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00035500526428223
(40) DESCRIBE `orchid_image` 0.0016729831695557
(41) DESCRIBE `cruiselines` 0.0018951892852783
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00029993057250977
(43) DESCRIBE `cruises` 0.0025219917297363
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69405') 0.00030398368835449
(45) DESCRIBE `ships` 0.0025019645690918
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00046706199645996
(47) DESCRIBE `ships` 0.002708911895752
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00032591819763184
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(51) DESCRIBE `itineraries` 0.0013389587402344
(52) DESCRIBE `ports` 0.001255989074707
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032401084899902
(54) DESCRIBE `ports` 0.0012550354003906
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048303604125977
(56) DESCRIBE `ports` 0.0018157958984375
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040698051452637
(58) DESCRIBE `sailingdates` 0.0015380382537842
(59) DESCRIBE `ports` 0.001615047454834
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035905838012695
(61) DESCRIBE `ports` 0.001305103302002
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00034403800964355
(63) DESCRIBE `ports` 0.0015459060668945
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00039911270141602
(65) DESCRIBE `ports` 0.001507043838501
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00032401084899902
(67) DESCRIBE `ports` 0.0014591217041016
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00030207633972168
(69) DESCRIBE `ports` 0.0014629364013672
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027322769165039
(71) DESCRIBE `ports` 0.0013370513916016
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037598609924316
(73) DESCRIBE `ports` 0.0014951229095459
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00034904479980469
(75) DESCRIBE `avid_specials` 0.0014419555664062
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69405 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 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.0019879341125488
(77) DESCRIBE `cruiselines` 0.0024878978729248
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034594535827637
(79) DESCRIBE `orchid_image` 0.0014150142669678
(80) DESCRIBE `cruiselines` 0.0021121501922607
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029802322387695
(82) DESCRIBE `cruises` 0.0024189949035645
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69614') 0.00035595893859863
(84) DESCRIBE `ships` 0.0031909942626953
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 986))) 0.00048112869262695
(86) DESCRIBE `ships` 0.0031311511993408
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '986') 0.00033020973205566
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054311752319336
(90) DESCRIBE `itineraries` 0.0018410682678223
(91) DESCRIBE `ports` 0.0013790130615234
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004119873046875
(93) DESCRIBE `ports` 0.0010521411895752
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031208992004395
(95) DESCRIBE `ports` 0.0012741088867188
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 2.4080276489258E-5
(97) DESCRIBE `sailingdates` 0.0012171268463135
(98) DESCRIBE `ports` 0.0013058185577393
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032901763916016
(100) DESCRIBE `ports` 0.0012691020965576
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00031089782714844
(102) DESCRIBE `ports` 0.0012938976287842
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00040197372436523
(104) DESCRIBE `ports` 0.0012388229370117
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027179718017578
(106) DESCRIBE `ports` 0.0013501644134521
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00030899047851562
(108) DESCRIBE `ports` 0.0012640953063965
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00046992301940918
(110) DESCRIBE `ports` 0.0014851093292236
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037193298339844
(112) DESCRIBE `ports` 0.0015969276428223
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037002563476562
(114) DESCRIBE `avid_specials` 0.0011069774627686
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69614 and class = 'Cruise') OR (item_id = 986 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 22 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.0011940002441406
(116) DESCRIBE `cruiselines` 0.0019450187683105
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00053501129150391
(118) DESCRIBE `orchid_image` 0.0014519691467285
(119) DESCRIBE `cruiselines` 0.0020267963409424
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00023818016052246
(121) DESCRIBE `cruises` 0.003154993057251
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73547') 0.00043106079101562
(123) DESCRIBE `ships` 0.0031468868255615
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00055503845214844
(125) DESCRIBE `ships` 0.0032699108123779
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.0005028247833252
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030183792114258
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002901554107666
(129) DESCRIBE `itineraries` 0.0017077922821045
(130) DESCRIBE `ports` 0.0013089179992676
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039386749267578
(132) DESCRIBE `ports` 0.0013370513916016
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00030016899108887
(134) DESCRIBE `ports` 0.0013229846954346
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00030398368835449
(136) DESCRIBE `sailingdates` 0.0013449192047119
(137) DESCRIBE `ports` 0.0020120143890381
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 7.1048736572266E-5
(139) DESCRIBE `ports` 0.0017800331115723
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00038695335388184
(141) DESCRIBE `ports` 0.001317024230957
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039315223693848
(143) DESCRIBE `ports` 0.0018620491027832
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034308433532715
(145) DESCRIBE `ports` 0.0015490055084229
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00027799606323242
(147) DESCRIBE `ports` 0.0015039443969727
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00042200088500977
(149) DESCRIBE `ports` 0.0017240047454834
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00045680999755859
(151) DESCRIBE `ports` 0.001812219619751
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0003821849822998
(153) DESCRIBE `avid_specials` 0.0015869140625
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73547 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 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.0018570423126221
(155) DESCRIBE `cruiselines` 0.00229811668396
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 8.8930130004883E-5
(157) DESCRIBE `orchid_image` 0.0020318031311035
(158) DESCRIBE `cruiselines` 0.0027081966400146
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00087594985961914
(160) DESCRIBE `cruises` 0.0039331912994385
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73661') 0.00055599212646484
(162) DESCRIBE `ships` 0.0041830539703369
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 17))) 0.000701904296875
(164) DESCRIBE `ships` 0.0039281845092773
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '17') 0.00051212310791016
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034904479980469
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033402442932129
(168) DESCRIBE `itineraries` 0.0019171237945557
(169) DESCRIBE `ports` 0.0021200180053711
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00051307678222656
(171) DESCRIBE `ports` 0.0018479824066162
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039005279541016
(173) DESCRIBE `ports` 0.0015559196472168
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00038409233093262
(175) DESCRIBE `sailingdates` 0.0012509822845459
(176) DESCRIBE `ports` 0.002004861831665
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00051403045654297
(178) DESCRIBE `ports` 0.0017728805541992
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00041389465332031
(180) DESCRIBE `ports` 0.0017092227935791
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00049805641174316
(182) DESCRIBE `ports` 0.0023229122161865
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00048995018005371
(184) DESCRIBE `ports` 0.0021560192108154
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00049114227294922
(186) DESCRIBE `ports` 0.0018467903137207
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00054597854614258
(188) DESCRIBE `ports` 0.002065896987915
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.0005030632019043
(190) DESCRIBE `ports` 0.0019018650054932
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00055098533630371
(192) DESCRIBE `ports` 0.0024998188018799
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0006248950958252
(194) DESCRIBE `ports` 0.0021460056304932
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00047588348388672
(196) DESCRIBE `avid_specials` 0.0017240047454834
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73661 and class = 'Cruise') OR (item_id = 17 AND class = 'Ship') OR (item_id = 36 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.0017619132995605
(198) DESCRIBE `cruiselines` 0.0027809143066406
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00056982040405273
(200) DESCRIBE `orchid_image` 0.0021870136260986
(201) DESCRIBE `cruiselines` 0.0026290416717529
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00054287910461426
(203) DESCRIBE `cruises` 0.003831148147583
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80304') 0.00052690505981445
(205) DESCRIBE `ships` 0.0049550533294678
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1760))) 0.00085997581481934
(207) DESCRIBE `ships` 0.0041148662567139
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1760') 0.00077509880065918
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038599967956543
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038409233093262
(211) DESCRIBE `itineraries` 0.0023221969604492
(212) DESCRIBE `ports` 0.0022761821746826
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00028491020202637
(214) DESCRIBE `ports` 0.0019710063934326
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00055599212646484
(216) DESCRIBE `ports` 0.0023131370544434
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00052094459533691
(218) DESCRIBE `sailingdates` 0.0025949478149414
(219) DESCRIBE `ports` 0.0022411346435547
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0008399486541748
(221) DESCRIBE `ports` 0.0020530223846436
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00043797492980957
(223) DESCRIBE `ports` 0.0019059181213379
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00044584274291992
(225) DESCRIBE `ports` 0.0021839141845703
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.0004570484161377
(227) DESCRIBE `ports` 0.0020599365234375
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00052309036254883
(229) DESCRIBE `ports` 0.001945972442627
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00044798851013184
(231) DESCRIBE `ports` 0.0018627643585205
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00052499771118164
(233) DESCRIBE `ports` 0.0020630359649658
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00072813034057617
(235) DESCRIBE `ports` 0.0020089149475098
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00056290626525879
(237) DESCRIBE `ports` 0.0019550323486328
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00055289268493652
(239) DESCRIBE `avid_specials` 0.0017790794372559
(240) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80304 and class = 'Cruise') OR (item_id = 1760 AND class = 'Ship') OR (item_id = 174 AND class = 'CruiseLine') OR (item_id = 44 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.0015921592712402
(241) DESCRIBE `cruiselines` 0.0031678676605225
(242) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00058889389038086
(243) DESCRIBE `orchid_image` 0.0022499561309814
(244) DESCRIBE `cruiselines` 0.0030250549316406
(245) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00064396858215332
(246) DESCRIBE `cruises` 0.0035669803619385
(247) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00053191184997559
(248) DESCRIBE `ships` 0.0040240287780762
(249) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00069117546081543
(250) DESCRIBE `ships` 0.0037698745727539
(251) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.0007328987121582
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056195259094238
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00013208389282227
(254) DESCRIBE `itineraries` 0.0020039081573486
(255) DESCRIBE `ports` 0.0020549297332764
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004889965057373
(257) DESCRIBE `ports` 0.0018610954284668
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047612190246582
(259) DESCRIBE `ports` 0.0018610954284668
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00046610832214355
(261) DESCRIBE `sailingdates` 0.0015251636505127
(262) DESCRIBE `ports` 0.0019650459289551
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043416023254395
(264) DESCRIBE `ports` 0.0016767978668213
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003659725189209
(266) DESCRIBE `ports` 0.0017330646514893
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040411949157715
(268) DESCRIBE `ports` 0.0016219615936279
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003509521484375
(270) DESCRIBE `ports` 0.0017960071563721
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00042486190795898
(272) DESCRIBE `ports` 0.0017361640930176
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030803680419922
(274) DESCRIBE `avid_specials` 0.0013139247894287
(275) 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.0015299320220947
(276) DESCRIBE `cruiselines` 0.0025589466094971
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00046205520629883
(278) DESCRIBE `orchid_image` 0.0016560554504395
(279) DESCRIBE `cruiselines` 0.002122163772583
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00040888786315918
(281) DESCRIBE `cruises` 0.0034141540527344
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.0003969669342041
(283) DESCRIBE `ships` 0.0032320022583008
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00065898895263672
(285) DESCRIBE `ships` 0.0032780170440674
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.0004889965057373
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030899047851562
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(289) DESCRIBE `itineraries` 0.0016219615936279
(290) DESCRIBE `ports` 0.0016481876373291
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036191940307617
(292) DESCRIBE `ports` 0.0013871192932129
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004119873046875
(294) DESCRIBE `ports` 0.0015110969543457
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040411949157715
(296) DESCRIBE `sailingdates` 0.0015778541564941
(297) DESCRIBE `ports` 0.0017910003662109
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037503242492676
(299) DESCRIBE `ports` 0.0013887882232666
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028491020202637
(301) DESCRIBE `ports` 0.0014748573303223
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035786628723145
(303) DESCRIBE `ports` 0.0014791488647461
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042104721069336
(305) DESCRIBE `ports` 0.0016028881072998
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00032591819763184
(307) DESCRIBE `ports` 0.0012600421905518
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028109550476074
(309) DESCRIBE `avid_specials` 0.001121997833252
(310) 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.001105785369873
(311) DESCRIBE `cruiselines` 0.0019969940185547
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00032806396484375
(313) DESCRIBE `orchid_image` 0.0015959739685059
(314) DESCRIBE `cruiselines` 0.0023338794708252
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00040483474731445
(316) DESCRIBE `cruises` 0.0029170513153076
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00031304359436035
(318) DESCRIBE `ships` 0.0026271343231201
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00040602684020996
(320) DESCRIBE `ships` 0.0029428005218506
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00045490264892578
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028014183044434
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002601146697998
(324) DESCRIBE `itineraries` 0.0017359256744385
(325) DESCRIBE `ports` 0.0018730163574219
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00051093101501465
(327) DESCRIBE `ports` 0.0019149780273438
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048708915710449
(329) DESCRIBE `ports` 0.0018010139465332
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037384033203125
(331) DESCRIBE `sailingdates` 0.0012788772583008
(332) DESCRIBE `ports` 0.00164794921875
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036716461181641
(334) DESCRIBE `ports` 0.0012609958648682
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030016899108887
(336) DESCRIBE `ports` 0.0014820098876953
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033903121948242
(338) DESCRIBE `ports` 0.0013580322265625
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033998489379883
(340) DESCRIBE `ports` 0.0013360977172852
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028109550476074
(342) DESCRIBE `ports` 0.0012729167938232
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026702880859375
(344) DESCRIBE `avid_specials` 0.001978874206543
(345) 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.0018179416656494
(346) DESCRIBE `cruiselines` 0.0026500225067139
(347) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00045013427734375
(348) DESCRIBE `orchid_image` 0.0020968914031982
(349) DESCRIBE `cruiselines` 0.0025041103363037
(350) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00040698051452637
(351) DESCRIBE `cruises` 0.0034859180450439
(352) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00043892860412598
(353) DESCRIBE `ships` 0.0036959648132324
(354) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00093698501586914
(355) DESCRIBE `ships` 0.012883901596069
(356) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00055599212646484
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033283233642578
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032496452331543
(359) DESCRIBE `itineraries` 0.0018110275268555
(360) DESCRIBE `ports` 0.0017819404602051
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040507316589355
(362) DESCRIBE `ports` 0.0022151470184326
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033783912658691
(364) DESCRIBE `ports` 0.001338005065918
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037384033203125
(366) DESCRIBE `sailingdates` 0.0011951923370361
(367) DESCRIBE `ports` 0.0019638538360596
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003662109375
(369) DESCRIBE `ports` 0.0013320446014404
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026106834411621
(371) DESCRIBE `ports` 0.0013570785522461
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003058910369873
(373) DESCRIBE `ports` 0.0013248920440674
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031709671020508
(375) DESCRIBE `ports` 0.0013391971588135
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0069561004638672
(377) DESCRIBE `ports` 0.0016601085662842
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00032496452331543
(379) DESCRIBE `avid_specials` 0.0013279914855957
(380) 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.0015690326690674
(381) DESCRIBE `cruiselines` 0.0021851062774658
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0091660022735596
(383) DESCRIBE `orchid_image` 0.0017039775848389
(384) DESCRIBE `cruiselines` 0.0018119812011719
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00033903121948242
(386) DESCRIBE `cruiselines` 0.0023138523101807
(387) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '23', '7', '12', '20', '171', '18', '144', '8', '101', '31', '131', '50', '96', '239', '29', '103', '15', '191', '91', '206', '120', '37', '16', '114', '33', '262', '24', '268', '28', '14', '174', '221', '110', '156', '208', '187', '141', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '184', '249', '232', '159', '90', '230', '113', '182', '213', '136', '276', '47', '188', '237', '261', '57', '64', '180', '73', '248', '35', '95', '209', '52', '231', '146', '195', '116', '219', '59', '82', '119', '256', '196', '105', '134', '244', '115', '168', '170', '229', '240', '204', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,23,7,12,20,171,18,144,8,101,31,131,50,96,239,29,103,15,191,91,206,120,37,16,114,33,262,24,268,28,14,174,221,110,156,208,187,141,153,118,49,151,211,30,258,216,181,88,4,212,36,264,225,238,140,184,249,232,159,90,230,113,182,213,136,276,47,188,237,261,57,64,180,73,248,35,95,209,52,231,146,195,116,219,59,82,119,256,196,105,134,244,115,168,170,229,240,204,48,224') 0.013953924179077
(388) DESCRIBE `ships` 0.0030360221862793
(389) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '977', '1291', '258', '1199', '1359', '1599', '349', '454', '1135', '1272', '404', '780', '855', '1677', '986', '1067', '1237', '265', '1594', '837', '1607', '37', '38', '34', '22', '27', '21', '31', '378', '407', '461', '28', '770', '1376', '1588', '393', '817', '542', '39', '30', '36', '1012', '1245', '573', '1552', '1402', '1424', '35', '726', '792', '66', '585', '330', '1415', '462', '332', '1284', '1744', '113', '1422', '882', '1176', '1419', '1423', '1760', '24', '711', '1574', '9', '11', '1405', '1420', '1418', '1421', '439', '455', '434', '1215', '10', '580', '766', '1021', '1193', '1141', '78', '739', '452', '69', '81', '1454', '1572', '1372', '1682', '3', '674', '1008', '1095', '635', '678', '124', '338', '1373', '1168', '1319', '5', '335', '340', '116', '43', '253', '553', '850', '1569', '1678', '70', '1302', '148', '285', '1172', '111', '160', '451', '25', '348', '658', '944', '1260', '4', '390', '874', '966', '1159', '1247', '1259', '386', '716', '748', '385', '405', '626', '651', '1108', '616', '791', '1320', '1330', '1562', '314', '1088', '1323', '1325', '63', '389', '406', '768', '784', '286', '683', '1455', '1645', '207', '508', '582', '590', '970', '1672', '287', '327', '375', '1195', '1587', '119', '483', '526', '749', '1575', '84', '108', '291', '559', '1068', '1236', '401', '722', '854', '98', '394', '520', '1208', '1398', '1460', '163', '290', '657', '1742', '485', '1571', '1586', '150', '652', '775', '776', '1492', '403', '421', '704', '1268', '147', '151', '152', '341', '1064', '1266', '1269', '114', '1308', '123', '223', '547', '1289', '1321', '149', '1539', '325', '883', '954', '993', '105', '262', '517', '715', '958', '1711', '45', '351', '1270', '1389', '1471', '1724', '75', '1139', '1243', '1282', '1486', '1601', '1722', '1143', '1557', '1717', '545', '717', '790', '441', '1526', '1561', '1579', '1738', '324', '823', '885', '1013', '1075', '1151', '1214', '1326', '1327', '1437', '162', '333', '673', '1303', '1367', '93', '205', '516', '796', '968', '1040', '1318', '1704', '818', '1301', '1540', '82', '212', '701', '1063', '1216', '1348', '1602', '743', '988', '1043', '1218', '1344', '201', '751', '769', '852', '1137', '1144', '1217', '1262', '1343', '1676', '1740', '574', '732', '1160', '1409', '1566', '1766', '795', '884', '1283', '1452', '1453', '1604', '266', '639', '738', '1025', '1090', '1136', '1157', '1163', '1721', '448', '601', '669', '811', '1073', '1223', '1226', '1241', '1253', '1426', '1449', '14', '905', '1019', '1027', '1029', '1229', '1411', '1496', '1632', '1716', '467', '1152', '1358', '1413', '1474', '997', '1188', '1448', '1619', '74', '610', '1055', '1150', '1345', '1351', '1673', '1713', '1715', '417', '494', '836', '996', '1026', '1047', '1145', '1233', '1322', '1408', '1410', '1458', '1647', '1663', '1714', '643', '1743', '423', '453', '618', '709', '888', '973', '1034', '1149', '1231', '1366', '1404', '1522', '1580', '1609', '208', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1489', '1505', '1516', '1593', '1730', '666', '920', '921', '927', '931', '1004', '1017', '1042', '1230', '1354', '1508', '1606', '1627', '1649', '1729', '352', '493', '521', '914', '923', '1106', '1140', '1154', '1444', '1517', '1518', '1567', '499', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1514', '1674', '1708', '1751', '479', '703', '924', '972', '1001', '1020', '1052', '1175', '1352', '1515', '1521', '1596', '1723', '422', '665', '671', '781', '938', '1005', '1045', '1054', '1254', '1285', '1412', '1463', '937', '1051', '1053', '1091', '1092', '1445', '1650', '1681', '1684', '672')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,977,1291,258,1199,1359,1599,349,454,1135,1272,404,780,855,1677,986,1067,1237,265,1594,837,1607,37,38,34,22,27,21,31,378,407,461,28,770,1376,1588,393,817,542,39,30,36,1012,1245,573,1552,1402,1424,35,726,792,66,585,330,1415,462,332,1284,1744,113,1422,882,1176,1419,1423,1760,24,711,1574,9,11,1405,1420,1418,1421,439,455,434,1215,10,580,766,1021,1193,1141,78,739,452,69,81,1454,1572,1372,1682,3,674,1008,1095,635,678,124,338,1373,1168,1319,5,335,340,116,43,253,553,850,1569,1678,70,1302,148,285,1172,111,160,451,25,348,658,944,1260,4,390,874,966,1159,1247,1259,386,716,748,385,405,626,651,1108,616,791,1320,1330,1562,314,1088,1323,1325,63,389,406,768,784,286,683,1455,1645,207,508,582,590,970,1672,287,327,375,1195,1587,119,483,526,749,1575,84,108,291,559,1068,1236,401,722,854,98,394,520,1208,1398,1460,163,290,657,1742,485,1571,1586,150,652,775,776,1492,403,421,704,1268,147,151,152,341,1064,1266,1269,114,1308,123,223,547,1289,1321,149,1539,325,883,954,993,105,262,517,715,958,1711,45,351,1270,1389,1471,1724,75,1139,1243,1282,1486,1601,1722,1143,1557,1717,545,717,790,441,1526,1561,1579,1738,324,823,885,1013,1075,1151,1214,1326,1327,1437,162,333,673,1303,1367,93,205,516,796,968,1040,1318,1704,818,1301,1540,82,212,701,1063,1216,1348,1602,743,988,1043,1218,1344,201,751,769,852,1137,1144,1217,1262,1343,1676,1740,574,732,1160,1409,1566,1766,795,884,1283,1452,1453,1604,266,639,738,1025,1090,1136,1157,1163,1721,448,601,669,811,1073,1223,1226,1241,1253,1426,1449,14,905,1019,1027,1029,1229,1411,1496,1632,1716,467,1152,1358,1413,1474,997,1188,1448,1619,74,610,1055,1150,1345,1351,1673,1713,1715,417,494,836,996,1026,1047,1145,1233,1322,1408,1410,1458,1647,1663,1714,643,1743,423,453,618,709,888,973,1034,1149,1231,1366,1404,1522,1580,1609,208,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1489,1505,1516,1593,1730,666,920,921,927,931,1004,1017,1042,1230,1354,1508,1606,1627,1649,1729,352,493,521,914,923,1106,1140,1154,1444,1517,1518,1567,499,663,915,916,926,930,1003,1072,1138,1514,1674,1708,1751,479,703,924,972,1001,1020,1052,1175,1352,1515,1521,1596,1723,422,665,671,781,938,1005,1045,1054,1254,1285,1412,1463,937,1051,1053,1091,1092,1445,1650,1681,1684,672') 0.10739183425903
(390) DESCRIBE `cruisetypes` 0.0014808177947998
(391) DESCRIBE `destinations` 0.0019431114196777
(392) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '28', '26', '55', '38', '40', '7', '30', '21', '48', '11', '49', '45', '29', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,28,26,55,38,40,7,30,21,48,11,49,45,29,44,56,10,34,52,32,46') 0.0027589797973633