or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

 
  • Mariner, Bahamas Cruise ex Port Canaveral Return

    Nights 3 Ship Mariner of the Seas
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2019: 28 Jun, 5 Jul, 12 Jul, 19 Jul, 26 Jul, 2 Aug, 9 Aug, 16 Aug, 23 Aug, 30 Aug, 6 Sep, 13 Sep, 20 Sep, 27 Sep, 4 Oct, 11 Oct, 18 Oct, 25 Oct, 1 Nov, 8 Nov More 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec, 20 Dec, 27 Dec 2020: 3 Jan, 10 Jan, 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 6 Mar, 13 Mar, 20 Mar, 27 Mar, 3 Apr, 10 Apr, 17 Apr, 24 Apr Less
    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.

  • Navigator, Bahamas Cruise ex Miami Return

    Nights 3 Ship Navigator of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 28 Jun, 5 Jul, 12 Jul, 19 Jul, 26 Jul, 2 Aug, 9 Aug, 16 Aug, 23 Aug, 30 Aug, 6 Sep, 13 Sep, 20 Sep, 27 Sep, 4 Oct, 11 Oct, 18 Oct, 25 Oct
    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.

  • Liberty, Bahamas Overnight Cruise ex Port Canaveral Return

    Nights 3 Ship Carnival Liberty
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2019: 28 Jun, 5 Jul, 12 Jul, 19 Jul, 26 Jul, 2 Aug, 9 Aug, 16 Aug, 23 Aug, 30 Aug, 6 Sep, 13 Sep, 20 Sep, 27 Sep, 4 Oct, 11 Oct, 18 Oct, 25 Oct, 1 Nov, 8 Nov More 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec, 20 Dec, 27 Dec 2020: 3 Jan, 10 Jan, 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 6 Mar, 13 Mar, 20 Mar, 27 Mar, 3 Apr, 10 Apr, 17 Apr, 24 Apr, 1 May, 8 May, 15 May, 22 May, 29 May, 5 Jun, 12 Jun, 19 Jun, 26 Jun, 3 Jul, 10 Jul, 17 Jul, 24 Jul, 31 Jul, 7 Aug, 14 Aug, 21 Aug, 28 Aug, 4 Sep, 11 Sep, 18 Sep, 25 Sep, 2 Oct, 9 Oct, 16 Oct, 23 Oct, 30 Oct, 6 Nov, 13 Nov, 20 Nov, 27 Nov, 4 Dec, 11 Dec, 18 Dec, 21 Dec, 28 Dec 2021: 8 Jan, 15 Jan, 22 Jan, 29 Jan, 5 Feb, 12 Feb, 19 Feb, 26 Feb, 5 Mar, 12 Mar, 19 Mar, 26 Mar, 2 Apr, 9 Apr, 16 Apr, 23 Apr, 30 Apr Less
    Ports of Call Port Canaveral, Nassau
    Please enquire about this cruise for pricing.
  • Sky, Bahamas ex Miami Return

    Nights 3 Ship Norwegian Sky
    Star Rating 4 Star Departs Miami
    Sailing 2019: 28 Jun, 19 Jul, 9 Aug
    Ports of Call Miami, Key West, Great Stirrup Cay
    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: 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 More 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.
  • Aquarius, Keelung & Yonaguni ex Keelung Return

    Nights 2 Ship SuperStar Aquarius
    Star Rating 4 Star Departs Keelung, Taiwan
    Sailing 2019: 28 Jun, 5 Jul, 12 Jul, 19 Jul, 26 Jul, 2 Aug, 9 Aug, 16 Aug, 23 Aug, 30 Aug, 6 Sep, 13 Sep, 20 Sep, 27 Sep, 4 Oct, 11 Oct, 18 Oct, 25 Oct
    Ports of Call Keelung, Yonaguni
    Please enquire about this cruise for pricing.
  • Jasmine, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Jasmine
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2019: 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 More 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.
  • Ginger, Hidden Worlds ex Lan Ha Bay Return

    Nights 1 Ship Ginger
    Star Rating Specialty Departs Lan Ha Bay, Vietnam
    Sailing 2019: 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 More 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, 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, 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, 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 Lan Ha Bay
    Please enquire about this cruise for pricing.
  • Emerald, Mediterranean Collection ex Barcelona Return

    Nights 21 Ship Emerald Princess
    Star Rating 4 Star Departs Barcelona, Spain
    Sailing 2019: 29 Jun, 20 Jul, 10 Aug, 31 Aug
    Ports of Call Barcelona, Gibraltar, Provence, Genoa, Livorno, Rome (Civitavecchia), Salerno, Kotor, Corfu, Chania, Mykonos, Athens (Piraeus) Greece, Santorini, Messina, Naples

    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.

 

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

Total elapsed time: 0.63495373725891

# Query Time
(1) connect 0.0010099411010742
(2) DESCRIBE `cruises` 0.0026159286499023
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73604, 73616, 73760, 79828, 65919, 81623, 65920, 80327, 64680, 74413)) ORDER BY FIND_IN_SET(id, '73604,73616,73760,79828,65919,81623,65920,80327,64680,74413') 0.0013251304626465
(4) DESCRIBE `cruises` 0.0033481121063232
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73604') 0.00034093856811523
(6) DESCRIBE `ships` 0.0030219554901123
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00049018859863281
(8) DESCRIBE `ships` 0.0024580955505371
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00036501884460449
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024604797363281
(12) DESCRIBE `itineraries` 0.0014328956604004
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73604') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00094294548034668
(14) DESCRIBE `ports` 0.0013332366943359
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00031614303588867
(16) DESCRIBE `ports` 0.0017001628875732
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00023889541625977
(18) DESCRIBE `ports` 0.0017030239105225
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00027990341186523
(20) DESCRIBE `sailingdates` 0.0018770694732666
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73604') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0018050670623779
(22) DESCRIBE `ports` 0.0017759799957275
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00040817260742188
(24) DESCRIBE `ports` 0.0015590190887451
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0
(26) DESCRIBE `ports` 0.0011301040649414
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00036907196044922
(28) DESCRIBE `ports` 0.0012338161468506
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00026798248291016
(30) DESCRIBE `ports` 0.0012249946594238
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00032305717468262
(32) DESCRIBE `ports` 0.00050902366638184
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00028586387634277
(34) DESCRIBE `ports` 0.001223087310791
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0010108947753906
(36) DESCRIBE `ports` 0.00087714195251465
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00026917457580566
(38) DESCRIBE `avid_specials` 0.00066685676574707
(39) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73604 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.0021431446075439
(40) DESCRIBE `cruiselines` 0.0018229484558105
(41) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032901763916016
(42) DESCRIBE `orchid_image` 0.0020158290863037
(43) DESCRIBE `cruiselines` 0.0021319389343262
(44) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028204917907715
(45) DESCRIBE `cruises` 0.0025920867919922
(46) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73616') 0.00030708312988281
(47) DESCRIBE `ships` 0.0025179386138916
(48) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 330))) 0.00034213066101074
(49) DESCRIBE `ships` 0.0025758743286133
(50) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '330') 0.0003209114074707
(51) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(53) DESCRIBE `itineraries` 0.001384973526001
(54) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73616') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006110668182373
(55) DESCRIBE `ports` 0.0020809173583984
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045084953308105
(57) DESCRIBE `ports` 0.0015780925750732
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030779838562012
(59) DESCRIBE `ports` 0.0012469291687012
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 4.9829483032227E-5
(61) DESCRIBE `sailingdates` 0.00090408325195312
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73616') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.000640869140625
(63) DESCRIBE `ports` 0.0015120506286621
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00036501884460449
(65) DESCRIBE `ports` 0.0012400150299072
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028800964355469
(67) DESCRIBE `ports` 0.0013880729675293
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00037693977355957
(69) DESCRIBE `ports` 0.0015299320220947
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00036120414733887
(71) DESCRIBE `ports` 0.0016539096832275
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039386749267578
(73) DESCRIBE `ports` 0.0016388893127441
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034499168395996
(75) DESCRIBE `ports` 0.0017220973968506
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041818618774414
(77) DESCRIBE `ports` 0.0013148784637451
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00031685829162598
(79) DESCRIBE `avid_specials` 0.0011091232299805
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73616 and class = 'Cruise') OR (item_id = 330 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.0012428760528564
(81) DESCRIBE `cruiselines` 0.0019290447235107
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037908554077148
(83) DESCRIBE `orchid_image` 0.0021610260009766
(84) DESCRIBE `cruiselines` 0.0022068023681641
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0003659725189209
(86) DESCRIBE `cruises` 0.0029118061065674
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73760') 0.00034785270690918
(88) DESCRIBE `ships` 0.0029621124267578
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00053787231445312
(90) DESCRIBE `ships` 0.002910852432251
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00033807754516602
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002751350402832
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025010108947754
(94) DESCRIBE `itineraries` 0.0015690326690674
(95) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73760') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006248950958252
(96) DESCRIBE `ports` 0.0016751289367676
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0004429817199707
(98) DESCRIBE `ports` 0.0015509128570557
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033402442932129
(100) DESCRIBE `ports` 0.0013961791992188
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00031805038452148
(102) DESCRIBE `sailingdates` 0.0011529922485352
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73760') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012409687042236
(104) DESCRIBE `ports` 0.0019140243530273
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039100646972656
(106) DESCRIBE `ports` 0.0015439987182617
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00037002563476562
(108) DESCRIBE `ports` 0.0012788772583008
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00050520896911621
(110) DESCRIBE `ports` 0.0012979507446289
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00032591819763184
(112) DESCRIBE `ports` 0.0015859603881836
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041007995605469
(114) DESCRIBE `ports` 0.0014710426330566
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00035810470581055
(116) DESCRIBE `ports` 0.0018019676208496
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00065302848815918
(118) DESCRIBE `ports` 0.0020968914031982
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00033116340637207
(120) DESCRIBE `avid_specials` 0.0012729167938232
(121) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73760 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.0011188983917236
(122) DESCRIBE `cruiselines` 0.0019161701202393
(123) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00040006637573242
(124) DESCRIBE `orchid_image` 0.0015101432800293
(125) DESCRIBE `cruiselines` 0.0024001598358154
(126) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00036406517028809
(127) DESCRIBE `cruises` 0.0032491683959961
(128) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79828') 0.00045394897460938
(129) DESCRIBE `ships` 0.0031180381774902
(130) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00050783157348633
(131) DESCRIBE `ships` 0.0034310817718506
(132) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.0004429817199707
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055885314941406
(135) DESCRIBE `itineraries` 0.0015799999237061
(136) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '79828') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0046508312225342
(137) DESCRIBE `ports` 0.0023889541625977
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044608116149902
(139) DESCRIBE `ports` 0.0015938282012939
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035905838012695
(141) DESCRIBE `ports` 0.0013928413391113
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00035619735717773
(143) DESCRIBE `sailingdates` 0.0012710094451904
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '79828') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0024650096893311
(145) DESCRIBE `ports` 0.0017900466918945
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043487548828125
(147) DESCRIBE `ports` 0.001471996307373
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039386749267578
(149) DESCRIBE `ports` 0.0013861656188965
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00034117698669434
(151) DESCRIBE `ports` 0.0015151500701904
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00032496452331543
(153) DESCRIBE `ports` 0.0013191699981689
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00034999847412109
(155) DESCRIBE `ports` 0.0013589859008789
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00033402442932129
(157) DESCRIBE `ports` 0.001370906829834
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037002563476562
(159) DESCRIBE `ports` 0.0014801025390625
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029897689819336
(161) DESCRIBE `avid_specials` 0.0011589527130127
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79828 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011858940124512
(163) DESCRIBE `cruiselines` 0.0021309852600098
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00037288665771484
(165) DESCRIBE `orchid_image` 0.0022068023681641
(166) DESCRIBE `cruiselines` 0.0027000904083252
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00010204315185547
(168) DESCRIBE `cruises` 0.0027618408203125
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 1.0013580322266E-5
(170) DESCRIBE `ships` 0.0026669502258301
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00017213821411133
(172) DESCRIBE `ships` 0.0029561519622803
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00034809112548828
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027084350585938
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027179718017578
(176) DESCRIBE `itineraries` 0.0013899803161621
(177) DESCRIBE `ports` 0.001309871673584
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00057387351989746
(179) DESCRIBE `ports` 0.0014510154724121
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029420852661133
(181) DESCRIBE `ports` 0.0013751983642578
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028896331787109
(183) DESCRIBE `sailingdates` 0.0011329650878906
(184) DESCRIBE `ports` 0.0021469593048096
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040197372436523
(186) DESCRIBE `ports` 0.0013461112976074
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031495094299316
(188) DESCRIBE `ports` 0.0012919902801514
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036001205444336
(190) DESCRIBE `ports` 0.0014219284057617
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00027108192443848
(192) DESCRIBE `ports` 0.0012519359588623
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028800964355469
(194) DESCRIBE `ports` 0.0012881755828857
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026702880859375
(196) DESCRIBE `avid_specials` 0.0012049674987793
(197) 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.0011861324310303
(198) DESCRIBE `cruiselines` 0.0020527839660645
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00031208992004395
(200) DESCRIBE `orchid_image` 0.0013270378112793
(201) DESCRIBE `cruiselines` 0.0021548271179199
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.0004889965057373
(203) DESCRIBE `cruises` 0.0031371116638184
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81623') 0.00038504600524902
(205) DESCRIBE `ships` 0.0039088726043701
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 644))) 0.00062918663024902
(207) DESCRIBE `ships` 0.0041749477386475
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '644') 0.00050806999206543
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(211) DESCRIBE `itineraries` 0.0014939308166504
(212) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '81623') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078487396240234
(213) DESCRIBE `ports` 0.0022580623626709
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.0009009838104248
(215) DESCRIBE `ports` 0.0021960735321045
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00086092948913574
(217) DESCRIBE `ports` 0.0016739368438721
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00087499618530273
(219) DESCRIBE `sailingdates` 0.0011141300201416
(220) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '81623') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.010251998901367
(221) DESCRIBE `ports` 0.0011410713195801
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00043916702270508
(223) DESCRIBE `ports` 0.0014069080352783
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00029492378234863
(225) DESCRIBE `ports` 0.0013399124145508
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3506))) 0.00045084953308105
(227) DESCRIBE `ports` 0.0013439655303955
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3506') 0.00028800964355469
(229) DESCRIBE `ports` 0.0013349056243896
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00028705596923828
(231) DESCRIBE `ports` 0.0012569427490234
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00026082992553711
(233) DESCRIBE `avid_specials` 0.0012540817260742
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81623 and class = 'Cruise') OR (item_id = 644 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.0031318664550781
(235) DESCRIBE `cruiselines` 0.0031299591064453
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00053501129150391
(237) DESCRIBE `orchid_image` 0.002108097076416
(238) DESCRIBE `cruiselines` 0.002357006072998
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.0003349781036377
(240) DESCRIBE `cruises` 0.0038390159606934
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00045609474182129
(242) DESCRIBE `ships` 0.0027201175689697
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00041294097900391
(244) DESCRIBE `ships` 0.0027120113372803
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00036191940307617
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032997131347656
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030303001403809
(248) DESCRIBE `itineraries` 0.0015499591827393
(249) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65920') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098896026611328
(250) DESCRIBE `ports` 0.0019149780273438
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00051403045654297
(252) DESCRIBE `ports` 0.0028200149536133
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038385391235352
(254) DESCRIBE `ports` 0.0012099742889404
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004119873046875
(256) DESCRIBE `sailingdates` 0.0018069744110107
(257) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65920') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.002810001373291
(258) DESCRIBE `ports` 0.0019450187683105
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034880638122559
(260) DESCRIBE `ports` 0.0014700889587402
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031113624572754
(262) DESCRIBE `ports` 0.0013961791992188
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038719177246094
(264) DESCRIBE `ports` 0.0013468265533447
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00029397010803223
(266) DESCRIBE `avid_specials` 0.0015478134155273
(267) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65920 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010831356048584
(268) DESCRIBE `cruiselines` 0.0019659996032715
(269) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00033402442932129
(270) DESCRIBE `orchid_image` 0.0019028186798096
(271) DESCRIBE `cruiselines` 0.0026040077209473
(272) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00031018257141113
(273) DESCRIBE `cruises` 0.0029370784759521
(274) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80327') 0.00042915344238281
(275) DESCRIBE `ships` 0.0030219554901123
(276) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00037717819213867
(277) DESCRIBE `ships` 0.0034480094909668
(278) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00028109550476074
(279) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031495094299316
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002899169921875
(281) DESCRIBE `itineraries` 0.0015630722045898
(282) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80327') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069904327392578
(283) DESCRIBE `ports` 0.0015490055084229
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00030517578125
(285) DESCRIBE `ports` 0.0016770362854004
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00028800964355469
(287) DESCRIBE `ports` 0.0014019012451172
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00034189224243164
(289) DESCRIBE `sailingdates` 0.0013279914855957
(290) DESCRIBE `ports` 0.001957893371582
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.0004119873046875
(292) DESCRIBE `ports` 0.001816987991333
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.0003809928894043
(294) DESCRIBE `ports` 0.001986026763916
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00048017501831055
(296) DESCRIBE `ports` 0.0018749237060547
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00036096572875977
(298) DESCRIBE `avid_specials` 0.0020151138305664
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80327 and class = 'Cruise') OR (item_id = 1761 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.0017950534820557
(300) DESCRIBE `cruiselines` 0.0029659271240234
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0003972053527832
(302) DESCRIBE `orchid_image` 0.0024359226226807
(303) DESCRIBE `cruiselines` 0.0028278827667236
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00033402442932129
(305) DESCRIBE `cruises` 0.0028181076049805
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64680') 0.00045990943908691
(307) DESCRIBE `ships` 0.0027470588684082
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 711))) 0.00037503242492676
(309) DESCRIBE `ships` 0.0028750896453857
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '711') 0.0002901554107666
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028300285339355
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025701522827148
(313) DESCRIBE `itineraries` 0.0014641284942627
(314) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64680') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071501731872559
(315) DESCRIBE `ports` 0.0010180473327637
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036406517028809
(317) DESCRIBE `ports` 0.0012791156768799
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003049373626709
(319) DESCRIBE `ports` 0.0012571811676025
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029683113098145
(321) DESCRIBE `sailingdates` 0.0015459060668945
(322) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64680') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012590885162354
(323) DESCRIBE `ports` 0.0013229846954346
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031900405883789
(325) DESCRIBE `ports` 0.0014309883117676
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0
(327) DESCRIBE `ports` 0.0016791820526123
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4525))) 0.00041699409484863
(329) DESCRIBE `ports` 0.0011870861053467
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4525') 0.0003349781036377
(331) DESCRIBE `ports` 0.0025520324707031
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00040793418884277
(333) DESCRIBE `ports` 0.0017409324645996
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00030612945556641
(335) DESCRIBE `ports` 0.001230001449585
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002899169921875
(337) DESCRIBE `ports` 0.0012960433959961
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00027012825012207
(339) DESCRIBE `ports` 0.0014650821685791
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2487))) 0.00029206275939941
(341) DESCRIBE `ports` 0.0012199878692627
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2487') 0.00026512145996094
(343) DESCRIBE `ports` 0.0012509822845459
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.00030398368835449
(345) DESCRIBE `ports` 0.0012989044189453
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00029206275939941
(347) DESCRIBE `ports` 0.0012991428375244
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00031590461730957
(349) DESCRIBE `ports` 0.0012688636779785
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00026512145996094
(351) DESCRIBE `ports` 0.0012688636779785
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00029802322387695
(353) DESCRIBE `ports` 0.0015971660614014
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00026488304138184
(355) DESCRIBE `ports` 0.001230001449585
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00029611587524414
(357) DESCRIBE `ports` 0.0012860298156738
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0003211498260498
(359) DESCRIBE `ports` 0.0012259483337402
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1620))) 0.00031208992004395
(361) DESCRIBE `ports` 0.001255989074707
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1620') 0.00026607513427734
(363) DESCRIBE `ports` 0.0012271404266357
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3299))) 0.00028705596923828
(365) DESCRIBE `ports` 0.0012190341949463
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3299') 0.00026607513427734
(367) DESCRIBE `ports` 0.0012500286102295
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.0003199577331543
(369) DESCRIBE `ports` 0.0012779235839844
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.00026798248291016
(371) DESCRIBE `ports` 0.0012331008911133
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00032901763916016
(373) DESCRIBE `ports` 0.0012788772583008
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.00025486946105957
(375) DESCRIBE `ports` 0.0014050006866455
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00036191940307617
(377) DESCRIBE `ports` 0.0012481212615967
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00044894218444824
(379) DESCRIBE `ports` 0.0012779235839844
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3964))) 0.00028896331787109
(381) DESCRIBE `ports` 0.0012710094451904
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3964') 0.00027322769165039
(383) DESCRIBE `ports` 0.0013580322265625
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00037193298339844
(385) DESCRIBE `ports` 0.0010290145874023
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00034999847412109
(387) DESCRIBE `ports` 0.0018410682678223
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00039792060852051
(389) DESCRIBE `ports` 0.0012648105621338
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00034499168395996
(391) DESCRIBE `ports` 0.0013720989227295
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2431))) 0.00031805038452148
(393) DESCRIBE `ports` 0.00041103363037109
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2431') 0.00034594535827637
(395) DESCRIBE `ports` 0.0013439655303955
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1641))) 0.00032496452331543
(397) DESCRIBE `ports` 0.0015828609466553
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1641') 0.00032305717468262
(399) DESCRIBE `ports` 0.0012819766998291
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003349781036377
(401) DESCRIBE `ports` 0.001276969909668
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028705596923828
(403) DESCRIBE `avid_specials` 0.0011498928070068
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64680 and class = 'Cruise') OR (item_id = 711 AND class = 'Ship') OR (item_id = 28 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.001025915145874
(405) DESCRIBE `cruiselines` 0.0019757747650146
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00037097930908203
(407) DESCRIBE `orchid_image` 0.0014851093292236
(408) DESCRIBE `cruises` 0.0027480125427246
(409) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74413') 0.00040602684020996
(410) DESCRIBE `ships` 0.0028080940246582
(411) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.00039982795715332
(412) DESCRIBE `ships` 0.0027399063110352
(413) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.00036001205444336
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(416) DESCRIBE `itineraries` 0.0013868808746338
(417) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74413') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087404251098633
(418) DESCRIBE `ports` 0.0015668869018555
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036191940307617
(420) DESCRIBE `ports` 0.0014739036560059
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031900405883789
(422) DESCRIBE `ports` 0.0012960433959961
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029397010803223
(424) DESCRIBE `sailingdates` 0.0011742115020752
(425) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74413') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084304809570312
(426) DESCRIBE `ports` 0.0017788410186768
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037598609924316
(428) DESCRIBE `ports` 0.0018150806427002
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002129077911377
(430) DESCRIBE `ports` 0.0012528896331787
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00030899047851562
(432) DESCRIBE `ports` 0.0013191699981689
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00029492378234863
(434) DESCRIBE `ports` 0.0012879371643066
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1509))) 0.0010149478912354
(436) DESCRIBE `ports` 0.00089788436889648
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1509') 0.00031590461730957
(438) DESCRIBE `ports` 0.0020089149475098
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044703483581543
(440) DESCRIBE `ports` 0.0014350414276123
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00030279159545898
(442) DESCRIBE `ports` 0.0013139247894287
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00030398368835449
(444) DESCRIBE `ports` 0.0014369487762451
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00032305717468262
(446) DESCRIBE `ports` 0.0013699531555176
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003211498260498
(448) DESCRIBE `ports` 0.0014970302581787
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041508674621582
(450) DESCRIBE `ports` 0.0014970302581787
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00036811828613281
(452) DESCRIBE `ports` 0.0014889240264893
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00033998489379883
(454) DESCRIBE `ports` 0.0013010501861572
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00038599967956543
(456) DESCRIBE `ports` 0.0015308856964111
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035309791564941
(458) DESCRIBE `ports` 0.0018460750579834
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00036001205444336
(460) DESCRIBE `ports` 0.0013189315795898
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00029397010803223
(462) DESCRIBE `ports` 0.0014650821685791
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00032186508178711
(464) DESCRIBE `ports` 0.0086522102355957
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00045895576477051
(466) DESCRIBE `ports` 0.012619972229004
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040102005004883
(468) DESCRIBE `ports` 0.0013420581817627
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028800964355469
(470) DESCRIBE `ports` 0.0012948513031006
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00029993057250977
(472) DESCRIBE `ports` 0.0013208389282227
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028800964355469
(474) DESCRIBE `ports` 0.0016329288482666
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00033688545227051
(476) DESCRIBE `ports` 0.0014040470123291
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029206275939941
(478) DESCRIBE `ports` 0.0016448497772217
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041317939758301
(480) DESCRIBE `ports` 0.001291036605835
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029301643371582
(482) DESCRIBE `ports` 0.0013720989227295
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00039315223693848
(484) DESCRIBE `ports` 0.0013411045074463
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00033211708068848
(486) DESCRIBE `ports` 0.0014410018920898
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0004119873046875
(488) DESCRIBE `ports` 0.0016489028930664
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003049373626709
(490) DESCRIBE `ports` 0.0013489723205566
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038504600524902
(492) DESCRIBE `ports` 0.0015490055084229
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029492378234863
(494) DESCRIBE `avid_specials` 0.0011758804321289
(495) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74413 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 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.0011188983917236
(496) DESCRIBE `cruiselines` 0.0023798942565918
(497) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00041604042053223
(498) DESCRIBE `orchid_image` 0.0016498565673828
(499) DESCRIBE `cruiselines` 0.0019779205322266
(500) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033402442932129
(501) DESCRIBE `cruiselines` 0.0021951198577881
(502) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '144', '183', '12', '23', '20', '101', '18', '8', '7', '131', '96', '171', '103', '33', '156', '120', '15', '262', '191', '29', '31', '258', '91', '208', '50', '28', '14', '187', '251', '114', '49', '212', '24', '47', '37', '206', '16', '153', '151', '36', '170', '110', '118', '181', '264', '195', '4', '30', '88', '59', '108', '159', '141', '140', '73', '35', '216', '90', '113', '147', '211', '57', '180', '64', '257', '261', '38', '48', '115', '276', '213', '184', '95', '105', '52', '82', '244', '209', '177', '134', '245')) ORDER BY FIND_IN_SET(id, '218,19,77,26,144,183,12,23,20,101,18,8,7,131,96,171,103,33,156,120,15,262,191,29,31,258,91,208,50,28,14,187,251,114,49,212,24,47,37,206,16,153,151,36,170,110,118,181,264,195,4,30,88,59,108,159,141,140,73,35,216,90,113,147,211,57,180,64,257,261,38,48,115,276,213,184,95,105,52,82,244,209,177,134,245') 0.0054659843444824
(503) DESCRIBE `ships` 0.0030171871185303
(504) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '726', '1744', '1588', '977', '517', '1594', '1555', '454', '1794', '1237', '780', '1272', '974', '1717', '1032', '1359', '258', '797', '1292', '22', '461', '21', '330', '770', '393', '404', '28', '1677', '986', '1348', '1205', '716', '1415', '349', '674', '333', '11', '10', '207', '739', '1067', '439', '521', '9', '715', '25', '24', '163', '738', '882', '3', '480', '1135', '1599', '1607', '455', '1260', '1678', '407', '553', '113', '1141', '1008', '434', '1455', '160', '766', '1773', '1682', '792', '1768', '265', '610', '817', '1569', '1742', '711', '332', '520', '1454', '352', '63', '66', '1372', '737', '1291', '626', '462', '542', '657', '1021', '1199', '585', '1308', '1721', '1738', '285', '1163', '1410', '14', '1068', '1302', '1411', '1413', '1526', '314', '526', '748', '1320', '1323', '1579', '855', '286', '390', '405', '573', '970', '1417', '34', '38', '43', '327', '582', '854', '1063', '1259', '31', '37', '590', '837', '1402', '378', '1463', '1088', '124', '1321', '1586', '580', '791', '958', '1013', '1552', '1284', '1811', '119', '162', '441', '1159', '1193', '1208', '1266', '678', '1139', '1157', '1492', '114', '1587', '1766', '401', '406', '850', '1245', '1318', '4', '335', '351', '451', '545', '616', '1028', '1412', '1672', '386', '704', '1461', '212', '547', '658', '1722', '39', '84', '722', '1236', '1326', '1327', '1782', '30', '35', '36', '148', '340', '403', '1012', '1040', '1289', '385', '988', '1330', '1398', '1408', '325', '601', '1108', '1303', '1575', '1711', '27', '287', '683', '966', '291', '652', '1043', '1172', '105', '201', '389', '508', '627', '639', '78', '818', '1168', '394', '1223', '111', '852', '1743', '338', '776', '1019', '1319', '1344', '1419', '1420', '1422', '1423', '262', '485', '751', '775', '1325', '1715', '1716', '1740', '123', '290', '673', '1029', '1160', '1217', '1282', '1343', '1418', '1421', '1424', '1452', '1453', '1801', '1037', '1229', '1426', '1604', '266', '1373', '1405', '45', '348', '701', '1095', '1226', '1704', '559', '768', '905', '1137', '1283', '1358', '1809', '253', '972', '1136', '1448', '223', '1150', '69', '341', '574', '851', '968', '98', '151', '651', '709', '973', '1409', '324', '1055', '1724', '1808', '108', '150', '643', '1230', '1231', '1458', '1474', '1501', '1713', '1730', '1767', '82', '857', '858', '954', '996', '1714', '75', '663', '769', '885', '1035', '1042', '1206', '1632', '1751', '467', '884', '1154', '1360', '1361', '1368', '1459', '1574', '1609', '1708', '1723', '1750', '666', '1049', '1362', '1772', '1148', '1322', '1483', '1771', '665', '888', '944', '423', '790', '1051', '1681', '147', '703', '717', '784', '1020', '1071', '1188', '1293', '1301', '1580', '70', '375', '1054', '152', '422', '483', '516', '707', '1075', '1224', '1486', '1601', '81', '1047', '1052', '1445', '1676', '796', '886', '937', '1036', '1572', '1679', '93', '116', '1048', '1138', '1262', '1351', '1437', '1465', '1781', '1045', '1329', '1539', '1673', '74', '149', '420', '1519', '1807', '644', '1060', '1109', '1146', '1444', '1468', '198', '503', '1039', '1050', '1143', '1196', '1232', '1350', '205', '419', '656', '1073', '1151', '1254', '1389', '1581', '1749', '1791', '795', '982', '1294', '1367', '1540', '1645', '1684', '1806', '452', '1064', '1140', '1800', '1816', '421', '761', '808', '1044', '1805', '493', '965', '1788', '479', '494', '687', '1297', '1624', '1674', '1706', '1053', '1158', '1241', '1626', '671', '883', '1156', '1195', '1316', '1571', '1709', '240', '767', '1025', '1090', '1144', '1340', '1342', '1647', '635', '695', '733', '979', '1027', '1113', '1341', '1663', '1089', '1155', '1256', '1295', '1024', '1038', '1296', '1471', '1792', '299', '300', '685', '692', '1451')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,726,1744,1588,977,517,1594,1555,454,1794,1237,780,1272,974,1717,1032,1359,258,797,1292,22,461,21,330,770,393,404,28,1677,986,1348,1205,716,1415,349,674,333,11,10,207,739,1067,439,521,9,715,25,24,163,738,882,3,480,1135,1599,1607,455,1260,1678,407,553,113,1141,1008,434,1455,160,766,1773,1682,792,1768,265,610,817,1569,1742,711,332,520,1454,352,63,66,1372,737,1291,626,462,542,657,1021,1199,585,1308,1721,1738,285,1163,1410,14,1068,1302,1411,1413,1526,314,526,748,1320,1323,1579,855,286,390,405,573,970,1417,34,38,43,327,582,854,1063,1259,31,37,590,837,1402,378,1463,1088,124,1321,1586,580,791,958,1013,1552,1284,1811,119,162,441,1159,1193,1208,1266,678,1139,1157,1492,114,1587,1766,401,406,850,1245,1318,4,335,351,451,545,616,1028,1412,1672,386,704,1461,212,547,658,1722,39,84,722,1236,1326,1327,1782,30,35,36,148,340,403,1012,1040,1289,385,988,1330,1398,1408,325,601,1108,1303,1575,1711,27,287,683,966,291,652,1043,1172,105,201,389,508,627,639,78,818,1168,394,1223,111,852,1743,338,776,1019,1319,1344,1419,1420,1422,1423,262,485,751,775,1325,1715,1716,1740,123,290,673,1029,1160,1217,1282,1343,1418,1421,1424,1452,1453,1801,1037,1229,1426,1604,266,1373,1405,45,348,701,1095,1226,1704,559,768,905,1137,1283,1358,1809,253,972,1136,1448,223,1150,69,341,574,851,968,98,151,651,709,973,1409,324,1055,1724,1808,108,150,643,1230,1231,1458,1474,1501,1713,1730,1767,82,857,858,954,996,1714,75,663,769,885,1035,1042,1206,1632,1751,467,884,1154,1360,1361,1368,1459,1574,1609,1708,1723,1750,666,1049,1362,1772,1148,1322,1483,1771,665,888,944,423,790,1051,1681,147,703,717,784,1020,1071,1188,1293,1301,1580,70,375,1054,152,422,483,516,707,1075,1224,1486,1601,81,1047,1052,1445,1676,796,886,937,1036,1572,1679,93,116,1048,1138,1262,1351,1437,1465,1781,1045,1329,1539,1673,74,149,420,1519,1807,644,1060,1109,1146,1444,1468,198,503,1039,1050,1143,1196,1232,1350,205,419,656,1073,1151,1254,1389,1581,1749,1791,795,982,1294,1367,1540,1645,1684,1806,452,1064,1140,1800,1816,421,761,808,1044,1805,493,965,1788,479,494,687,1297,1624,1674,1706,1053,1158,1241,1626,671,883,1156,1195,1316,1571,1709,240,767,1025,1090,1144,1340,1342,1647,635,695,733,979,1027,1113,1341,1663,1089,1155,1256,1295,1024,1038,1296,1471,1792,299,300,685,692,1451') 0.047960042953491
(505) DESCRIBE `cruisetypes` 0.0015220642089844
(506) DESCRIBE `destinations` 0.0015058517456055
(507) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '9', '25', '2', '37', '8', '39', '53', '26', '28', '38', '49', '55', '11', '40', '48', '7', '29', '21', '45', '44', '30', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,9,25,2,37,8,39,53,26,28,38,49,55,11,40,48,7,29,21,45,44,30,34,10,52,46,56,32') 0.0019888877868652