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 Roundtrip

    Nights 4 Ship Mariner of the Seas
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2019: 9 Dec, 16 Dec 2020: 6 Jan, 13 Jan, 27 Jan, 3 Feb, 10 Feb, 24 Feb, 2 Mar, 9 Mar, 30 Mar, 13 Apr, 20 Apr, 27 Apr
    Ports of Call Port Canaveral, 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.

  • Navigator, Bahamas Cruise ex Miami Roundtrip

    Nights 4 Ship Navigator of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 9 Dec, 16 Dec 2020: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar, 6 Apr, 13 Apr, 20 Apr, 27 Apr
    Ports of Call Miami, 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.

  • Delfin I, 3 Night Cruise ex Iquitos (Nauta) Return

    Nights 3 Ship Delfin I
    Star Rating River Departs Nauta
    Sailing 2019: 9 Dec, 16 Dec, 23 Dec, 30 Dec 2020: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar, 6 Apr, 13 Apr, 20 Apr, 27 Apr More 4 May, 11 May, 18 May, 25 May, 1 Jun, 8 Jun, 15 Jun, 22 Jun, 29 Jun, 6 Jul, 13 Jul, 20 Jul, 27 Jul, 3 Aug, 10 Aug, 17 Aug, 24 Aug, 31 Aug, 7 Sep, 14 Sep, 21 Sep, 28 Sep, 5 Oct, 12 Oct, 19 Oct, 26 Oct, 2 Nov, 9 Nov, 16 Nov, 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec, 28 Dec Less
    Ports of Call Nauta, Pacaya-Samiria National Reserve
    Please enquire about this cruise for pricing.
  • River Kwai, Upstream ex Bangkok Return

    Nights 3 Ship River Kwai
    Star Rating River Departs Bangkok (Rivers)
    Sailing 2019: 9 Dec, 16 Dec, 23 Dec, 30 Dec 2020: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar, 6 Apr, 13 Apr, 20 Apr, 27 Apr
    Ports of Call Bangkok (Rivers), River Cruising
    Please enquire about this cruise for pricing.
  • Indochina Pandaw, Short Cruise Downstream ex Phnom Penh to Saigon

    Nights 3 Ship Indochina Pandaw
    Star Rating River Departs Phnom Penh, Cambodia
    Sailing 2019: 9 Dec, 16 Dec, 23 Dec, 30 Dec 2020: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar, 3 Jul, 10 Jul, 17 Jul, 24 Jul More 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, 25 Dec 2021: 1 Jan, 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, 7 May, 14 May, 21 May, 28 May, 4 Jun, 11 Jun, 18 Jun, 25 Jun, 2 Jul, 9 Jul, 16 Jul, 23 Jul, 30 Jul, 6 Aug, 13 Aug, 20 Aug, 27 Aug, 3 Sep, 10 Sep, 17 Sep, 24 Sep, 1 Oct, 8 Oct, 15 Oct, 22 Oct, 29 Oct, 5 Nov, 12 Nov, 19 Nov, 26 Nov, 3 Dec, 10 Dec, 17 Dec, 24 Dec, 31 Dec 2022: 7 Jan, 14 Jan, 21 Jan, 28 Jan, 4 Feb, 11 Feb, 18 Feb, 25 Feb, 4 Mar, 11 Mar, 18 Mar, 25 Mar, 5 Aug, 12 Aug, 19 Aug, 26 Aug, 2 Sep, 9 Sep, 16 Sep, 23 Sep, 30 Sep, 7 Oct, 14 Oct, 21 Oct, 28 Oct, 4 Nov, 11 Nov, 18 Nov, 25 Nov, 2 Dec, 9 Dec, 16 Dec, 23 Dec, 30 Dec 2023: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 3 Mar, 10 Mar, 17 Mar, 24 Mar, 31 Mar Less
    Ports of Call Phnom Penh, Con Phuoc Island, Ben Tre, My Tho, Ho Chi Minh City (Saigon)
    Please enquire about this cruise for pricing.
  • Ylang, Senses of Lan Ha ex Lan Ha Bay Return

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

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

    Nights 4 Ship Carnival Liberty
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2019: 9 Dec, 16 Dec, 30 Dec 2020: 13 Jan, 27 Jan, 10 Feb, 24 Feb, 9 Mar, 23 Mar, 6 Apr, 20 Apr, 16 Nov, 24 Dec 2021: 15 Feb
    Ports of Call Port Canaveral, Nassau, Freeport
    Please enquire about this cruise for pricing.
  • Emmylou, Upper Murray Discovery Cruise ex Echuca Return

    Nights 3 Ship Emmylou
    Star Rating River Departs Echuca, Victoria, Australia
    Sailing 2019: 9 Dec 2020: 10 Feb, 2 Mar, 16 Mar, 20 Apr, 4 May, 11 May, 25 May, 1 Jun, 8 Jun, 22 Jun, 13 Jul, 22 Jul, 17 Aug, 24 Aug, 7 Sep, 12 Oct, 26 Oct, 9 Nov, 23 Nov, 30 Nov, 14 Dec
    Ports of Call Echuca, Murray River
    Please enquire about this cruise for pricing.
  • Spitsbergen, Norway Cruise ex Bergen Roundtrip

    Nights 11 Ship Spitsbergen
    Star Rating Specialty Departs Bergen, Norway
    Sailing 2019: 9 Dec, 20 Dec, 31 Dec 2020: 11 Jan, 22 Jan, 2 Feb, 13 Feb, 24 Feb, 6 Mar, 28 Mar, 8 Apr, 19 Apr, 30 Apr
    Ports of Call Bergen, Alesund, Molde, Kristiansund, Trondheim, Bodo, Harstad, Tromso, Hammerfest, Honningsvag, Kirkenes
    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: 478

Total elapsed time: 1.0444293022156

# Query Time
(1) connect 0.0020270347595215
(2) DESCRIBE `cruises` 0.0058870315551758
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73606, 73617, 57660, 59176, 85581, 82150, 86294, 56888, 20573, 59118)) ORDER BY FIND_IN_SET(id, '73606,73617,57660,59176,85581,82150,86294,56888,20573,59118') 0.0038270950317383
(4) DESCRIBE `cruises` 0.0055410861968994
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73606') 0.00080394744873047
(6) DESCRIBE `ships` 0.0058720111846924
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00089097023010254
(8) DESCRIBE `ships` 0.004971981048584
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.0009310245513916
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048613548278809
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0007169246673584
(12) DESCRIBE `itineraries` 0.0028958320617676
(13) DESCRIBE `ports` 0.0029928684234619
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00064682960510254
(15) DESCRIBE `ports` 0.0028111934661865
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00065994262695312
(17) DESCRIBE `ports` 0.002647876739502
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00060606002807617
(19) DESCRIBE `sailingdates` 0.002255916595459
(20) DESCRIBE `ports` 0.0032610893249512
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00086712837219238
(22) DESCRIBE `ports` 0.0029659271240234
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00069499015808105
(24) DESCRIBE `ports` 0.0028870105743408
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00064206123352051
(26) DESCRIBE `ports` 0.0028421878814697
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00045609474182129
(28) DESCRIBE `ports` 0.0023760795593262
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00044417381286621
(30) DESCRIBE `ports` 0.0022828578948975
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0005638599395752
(32) DESCRIBE `ports` 0.0029940605163574
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0006709098815918
(34) DESCRIBE `ports` 0.003040075302124
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00052094459533691
(36) DESCRIBE `avid_specials` 0.0027430057525635
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73606 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.0028190612792969
(38) DESCRIBE `cruiselines` 0.0040881633758545
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00071597099304199
(40) DESCRIBE `orchid_image` 0.0031478404998779
(41) DESCRIBE `cruiselines` 0.0038719177246094
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0005950927734375
(43) DESCRIBE `cruises` 0.0050690174102783
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73617') 0.00090408325195312
(45) DESCRIBE `ships` 0.0063080787658691
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 330))) 0.0007779598236084
(47) DESCRIBE `ships` 0.0048480033874512
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '330') 0.00059199333190918
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004270076751709
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004270076751709
(51) DESCRIBE `itineraries` 0.0027580261230469
(52) DESCRIBE `ports` 0.0031390190124512
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00072002410888672
(54) DESCRIBE `ports` 0.0030298233032227
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00075006484985352
(56) DESCRIBE `ports` 0.0029771327972412
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00067496299743652
(58) DESCRIBE `sailingdates` 0.0026450157165527
(59) DESCRIBE `ports` 0.0031430721282959
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063300132751465
(61) DESCRIBE `ports` 0.0026838779449463
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00063014030456543
(63) DESCRIBE `ports` 0.002122163772583
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00075101852416992
(65) DESCRIBE `ports` 0.0028870105743408
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00066494941711426
(67) DESCRIBE `ports` 0.0028018951416016
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00069618225097656
(69) DESCRIBE `ports` 0.0029110908508301
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00058197975158691
(71) DESCRIBE `ports` 0.0020921230316162
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00066709518432617
(73) DESCRIBE `ports` 0.002842903137207
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00072908401489258
(75) DESCRIBE `avid_specials` 0.0023341178894043
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73617 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.0020670890808105
(77) DESCRIBE `cruiselines` 0.0036089420318604
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0006709098815918
(79) DESCRIBE `orchid_image` 0.0028619766235352
(80) DESCRIBE `cruiselines` 0.0036358833312988
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00056195259094238
(82) DESCRIBE `cruises` 0.0045919418334961
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57660') 0.00063896179199219
(84) DESCRIBE `ships` 0.0056939125061035
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 857))) 0.00090694427490234
(86) DESCRIBE `ships` 0.0060029029846191
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '857') 0.00073909759521484
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00079703330993652
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050210952758789
(90) DESCRIBE `itineraries` 0.0029799938201904
(91) DESCRIBE `ports` 0.0025520324707031
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00075197219848633
(93) DESCRIBE `ports` 0.0028018951416016
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.0006711483001709
(95) DESCRIBE `ports` 0.0035607814788818
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00072407722473145
(97) DESCRIBE `sailingdates` 0.0025579929351807
(98) DESCRIBE `ports` 0.0031301975250244
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.000701904296875
(100) DESCRIBE `ports` 0.003446102142334
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00064396858215332
(102) DESCRIBE `ports` 0.0027999877929688
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00061607360839844
(104) DESCRIBE `ports` 0.0026559829711914
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00063109397888184
(106) DESCRIBE `ports` 0.0029702186584473
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) 0.00074315071105957
(108) DESCRIBE `ports` 0.0029821395874023
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3863') 0.00060415267944336
(110) DESCRIBE `ports` 0.0030210018157959
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3862))) 0.00061488151550293
(112) DESCRIBE `ports` 0.0031599998474121
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3862') 0.00074100494384766
(114) DESCRIBE `avid_specials` 0.0024559497833252
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57660 and class = 'Cruise') OR (item_id = 857 AND class = 'Ship') OR (item_id = 195 AND class = 'CruiseLine') OR (item_id = 55 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.0022838115692139
(116) DESCRIBE `cruiselines` 0.0043990612030029
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) 0.00077009201049805
(118) DESCRIBE `orchid_image` 0.0035290718078613
(119) DESCRIBE `cruiselines` 0.0036699771881104
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') 0.00060081481933594
(121) DESCRIBE `cruises` 0.0059080123901367
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59176') 0.00069904327392578
(123) DESCRIBE `ships` 0.0058140754699707
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 480))) 0.00087690353393555
(125) DESCRIBE `ships` 0.0059018135070801
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '480') 0.00065708160400391
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005040168762207
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049090385437012
(129) DESCRIBE `itineraries` 0.0028629302978516
(130) DESCRIBE `ports` 0.0028531551361084
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00073695182800293
(132) DESCRIBE `ports` 0.0039920806884766
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00069403648376465
(134) DESCRIBE `ports` 0.0025398731231689
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00057697296142578
(136) DESCRIBE `sailingdates` 0.0024509429931641
(137) DESCRIBE `ports` 0.0032000541687012
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00079607963562012
(139) DESCRIBE `ports` 0.0031390190124512
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.00068211555480957
(141) DESCRIBE `ports` 0.0032088756561279
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00099802017211914
(143) DESCRIBE `ports` 0.0040349960327148
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00069212913513184
(145) DESCRIBE `ports` 0.017688035964966
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00081491470336914
(147) DESCRIBE `ports` 0.021939992904663
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0007631778717041
(149) DESCRIBE `ports` 0.011080980300903
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3066))) 0.00078392028808594
(151) DESCRIBE `ports` 0.0030028820037842
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3066') 0.0007941722869873
(153) DESCRIBE `avid_specials` 0.0026328563690186
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59176 and class = 'Cruise') OR (item_id = 480 AND class = 'Ship') OR (item_id = 108 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022940635681152
(155) DESCRIBE `cruiselines` 0.0041899681091309
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 108))) 0.00071907043457031
(157) DESCRIBE `orchid_image` 0.0032460689544678
(158) DESCRIBE `cruiselines` 0.0038919448852539
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '108') 0.00066590309143066
(160) DESCRIBE `cruises` 0.0055370330810547
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85581') 0.00072908401489258
(162) DESCRIBE `ships` 0.005795955657959
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 732))) 0.00081396102905273
(164) DESCRIBE `ships` 0.0048401355743408
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '732') 0.00060892105102539
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038981437683105
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004119873046875
(168) DESCRIBE `itineraries` 0.0019419193267822
(169) DESCRIBE `ports` 0.0031418800354004
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.000885009765625
(171) DESCRIBE `ports` 0.0030629634857178
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00082015991210938
(173) DESCRIBE `ports` 0.003148078918457
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00072407722473145
(175) DESCRIBE `sailingdates` 0.0026588439941406
(176) DESCRIBE `ports` 0.0030901432037354
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0008089542388916
(178) DESCRIBE `ports` 0.0028979778289795
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00074410438537598
(180) DESCRIBE `ports` 0.0027339458465576
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00070595741271973
(182) DESCRIBE `ports` 0.0029900074005127
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00057721138000488
(184) DESCRIBE `ports` 0.0029668807983398
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00073409080505371
(186) DESCRIBE `ports` 0.0029551982879639
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00062179565429688
(188) DESCRIBE `ports` 0.0029671192169189
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00067687034606934
(190) DESCRIBE `ports` 0.0029499530792236
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00062799453735352
(192) DESCRIBE `ports` 0.0030009746551514
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00075101852416992
(194) DESCRIBE `ports` 0.0029430389404297
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00069403648376465
(196) DESCRIBE `avid_specials` 0.0025789737701416
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85581 and class = 'Cruise') OR (item_id = 732 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021340847015381
(198) DESCRIBE `cruiselines` 0.0042600631713867
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00071406364440918
(200) DESCRIBE `orchid_image` 0.0033690929412842
(201) DESCRIBE `cruiselines` 0.0042941570281982
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0005638599395752
(203) DESCRIBE `cruises` 0.0045719146728516
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82150') 0.00064301490783691
(205) DESCRIBE `ships` 0.005702018737793
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1794))) 0.0010309219360352
(207) DESCRIBE `ships` 0.0058810710906982
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1794') 0.0009160041809082
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0005490779876709
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0004880428314209
(211) DESCRIBE `itineraries` 0.002842903137207
(212) DESCRIBE `ports` 0.0028049945831299
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00063300132751465
(214) DESCRIBE `ports` 0.0028560161590576
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00068306922912598
(216) DESCRIBE `ports` 0.0028970241546631
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00059008598327637
(218) DESCRIBE `sailingdates` 0.0024170875549316
(219) DESCRIBE `ports` 0.0031418800354004
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00069689750671387
(221) DESCRIBE `ports` 0.0024409294128418
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00055694580078125
(223) DESCRIBE `ports` 0.002241849899292
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00050091743469238
(225) DESCRIBE `ports` 0.0027899742126465
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00063109397888184
(227) DESCRIBE `ports` 0.0029850006103516
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00065398216247559
(229) DESCRIBE `ports` 0.0029358863830566
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00058102607727051
(231) DESCRIBE `avid_specials` 0.0021860599517822
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82150 and class = 'Cruise') OR (item_id = 1794 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.001802921295166
(233) DESCRIBE `cruiselines` 0.0033760070800781
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0005500316619873
(235) DESCRIBE `orchid_image` 0.0026631355285645
(236) DESCRIBE `cruiselines` 0.0029408931732178
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00053000450134277
(238) DESCRIBE `cruises` 0.0044951438903809
(239) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '86294') 0.00061988830566406
(240) DESCRIBE `ships` 0.0054769515991211
(241) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1572))) 0.00082707405090332
(242) DESCRIBE `ships` 0.0056750774383545
(243) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1572') 0.00062108039855957
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041007995605469
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041508674621582
(246) DESCRIBE `itineraries` 0.0027501583099365
(247) DESCRIBE `ports` 0.0030369758605957
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00073385238647461
(249) DESCRIBE `ports` 0.0023341178894043
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00063395500183105
(251) DESCRIBE `ports` 0.0022261142730713
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00043106079101562
(253) DESCRIBE `sailingdates` 0.0019891262054443
(254) DESCRIBE `ports` 0.0032749176025391
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00072288513183594
(256) DESCRIBE `ports` 0.0023767948150635
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00055599212646484
(258) DESCRIBE `ports` 0.0026450157165527
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3939))) 0.00056600570678711
(260) DESCRIBE `ports` 0.0020699501037598
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3939') 0.00042295455932617
(262) DESCRIBE `ports` 0.0019919872283936
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3937))) 0.00071406364440918
(264) DESCRIBE `ports` 0.0020370483398438
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3937') 0.00059700012207031
(266) DESCRIBE `ports` 0.0018870830535889
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6252))) 0.00042605400085449
(268) DESCRIBE `ports` 0.0018959045410156
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6252') 0.00067400932312012
(270) DESCRIBE `ports` 0.0019569396972656
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5638))) 0.00049781799316406
(272) DESCRIBE `ports` 0.0020909309387207
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5638') 0.00043487548828125
(274) DESCRIBE `ports` 0.0025219917297363
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3939))) 0.00067496299743652
(276) DESCRIBE `ports` 0.0027580261230469
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3939') 0.0006868839263916
(278) DESCRIBE `ports` 0.0028450489044189
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00066590309143066
(280) DESCRIBE `ports` 0.0029561519622803
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.00059819221496582
(282) DESCRIBE `avid_specials` 0.0025219917297363
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 86294 and class = 'Cruise') OR (item_id = 1572 AND class = 'Ship') OR (item_id = 171 AND class = 'CruiseLine') OR (item_id = 30 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.0018899440765381
(284) DESCRIBE `cruiselines` 0.0037951469421387
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00067400932312012
(286) DESCRIBE `orchid_image` 0.0031299591064453
(287) DESCRIBE `cruises` 0.0052170753479004
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56888') 0.00062918663024902
(289) DESCRIBE `ships` 0.0039570331573486
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00058484077453613
(291) DESCRIBE `ships` 0.0045669078826904
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00082516670227051
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051498413085938
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046706199645996
(295) DESCRIBE `itineraries` 0.0022571086883545
(296) DESCRIBE `ports` 0.0024950504302979
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00054407119750977
(298) DESCRIBE `ports` 0.0020649433135986
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00061702728271484
(300) DESCRIBE `ports` 0.002593994140625
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00048518180847168
(302) DESCRIBE `sailingdates` 0.002269983291626
(303) DESCRIBE `ports` 0.0024478435516357
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00055885314941406
(305) DESCRIBE `ports` 0.0024349689483643
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00042605400085449
(307) DESCRIBE `ports` 0.0025529861450195
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00068187713623047
(309) DESCRIBE `ports` 0.0030472278594971
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00071406364440918
(311) DESCRIBE `ports` 0.003154993057251
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00073599815368652
(313) DESCRIBE `ports` 0.0028798580169678
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00065398216247559
(315) DESCRIBE `ports` 0.0028860569000244
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00071287155151367
(317) DESCRIBE `ports` 0.010164976119995
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0022299289703369
(319) DESCRIBE `avid_specials` 0.0026938915252686
(320) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56888 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.0017309188842773
(321) DESCRIBE `cruiselines` 0.0057079792022705
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00075483322143555
(323) DESCRIBE `orchid_image` 0.002439022064209
(324) DESCRIBE `cruiselines` 0.0035660266876221
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00061678886413574
(326) DESCRIBE `cruises` 0.0040099620819092
(327) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '20573') 0.00058293342590332
(328) DESCRIBE `ships` 0.0044999122619629
(329) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 198))) 0.00083088874816895
(330) DESCRIBE `ships` 0.0038399696350098
(331) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '198') 0.00065398216247559
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004119873046875
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003969669342041
(334) DESCRIBE `itineraries` 0.0022151470184326
(335) DESCRIBE `ports` 0.0024831295013428
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) 0.00060892105102539
(337) DESCRIBE `ports` 0.0020699501037598
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) 0.0005640983581543
(339) DESCRIBE `ports` 0.0025970935821533
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') 0.00053095817565918
(341) DESCRIBE `sailingdates` 0.0020420551300049
(342) DESCRIBE `ports` 0.0028979778289795
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) 0.00067019462585449
(344) DESCRIBE `ports` 0.0026950836181641
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') 0.00058484077453613
(346) DESCRIBE `ports` 0.0027639865875244
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00064897537231445
(348) DESCRIBE `ports` 0.0026459693908691
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00060415267944336
(350) DESCRIBE `ports` 0.002640962600708
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0006401538848877
(352) DESCRIBE `ports` 0.0026259422302246
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00063395500183105
(354) DESCRIBE `ports` 0.0025999546051025
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) 0.00058317184448242
(356) DESCRIBE `ports` 0.0025730133056641
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') 0.00070786476135254
(358) DESCRIBE `avid_specials` 0.0018050670623779
(359) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 20573 and class = 'Cruise') OR (item_id = 198 AND class = 'Ship') OR (item_id = 48 AND class = 'CruiseLine') OR (item_id = 46 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.0013689994812012
(360) DESCRIBE `cruiselines` 0.0025959014892578
(361) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 48))) 0.00080299377441406
(362) DESCRIBE `orchid_image` 0.0023438930511475
(363) DESCRIBE `cruiselines` 0.0028159618377686
(364) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '48') 0.00057005882263184
(365) DESCRIBE `cruises` 0.0040569305419922
(366) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59118') 0.00055408477783203
(367) DESCRIBE `ships` 0.0041391849517822
(368) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1405))) 0.0006260871887207
(369) DESCRIBE `ships` 0.003957986831665
(370) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1405') 0.00055193901062012
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038599967956543
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040817260742188
(373) DESCRIBE `itineraries` 0.0021390914916992
(374) DESCRIBE `ports` 0.0018529891967773
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00049495697021484
(376) DESCRIBE `ports` 0.0020530223846436
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00042414665222168
(378) DESCRIBE `ports` 0.0019259452819824
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00040602684020996
(380) DESCRIBE `sailingdates` 0.0017428398132324
(381) DESCRIBE `ports` 0.0031030178070068
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0007169246673584
(383) DESCRIBE `ports` 0.0030269622802734
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0006401538848877
(385) DESCRIBE `ports` 0.0024130344390869
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00060892105102539
(387) DESCRIBE `ports` 0.0029520988464355
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00061798095703125
(389) DESCRIBE `ports` 0.0022339820861816
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00051403045654297
(391) DESCRIBE `ports` 0.0019228458404541
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00048398971557617
(393) DESCRIBE `ports` 0.0020060539245605
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00055217742919922
(395) DESCRIBE `ports` 0.0020020008087158
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00042510032653809
(397) DESCRIBE `ports` 0.0018858909606934
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00057601928710938
(399) DESCRIBE `ports` 0.0019710063934326
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00043892860412598
(401) DESCRIBE `ports` 0.0026788711547852
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00065088272094727
(403) DESCRIBE `ports` 0.0028560161590576
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00051712989807129
(405) DESCRIBE `ports` 0.0020959377288818
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00049185752868652
(407) DESCRIBE `ports` 0.0021088123321533
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00040912628173828
(409) DESCRIBE `ports` 0.0021190643310547
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00045394897460938
(411) DESCRIBE `ports` 0.001924991607666
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00044012069702148
(413) DESCRIBE `ports` 0.0020120143890381
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00064897537231445
(415) DESCRIBE `ports` 0.0019209384918213
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00069212913513184
(417) DESCRIBE `ports` 0.0029218196868896
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00052213668823242
(419) DESCRIBE `ports` 0.002202033996582
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00041913986206055
(421) DESCRIBE `ports` 0.0021078586578369
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00059986114501953
(423) DESCRIBE `ports` 0.0026900768280029
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00061297416687012
(425) DESCRIBE `ports` 0.0031130313873291
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00062322616577148
(427) DESCRIBE `ports` 0.0023279190063477
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00043010711669922
(429) DESCRIBE `ports` 0.0021700859069824
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00046706199645996
(431) DESCRIBE `ports` 0.0018889904022217
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00044679641723633
(433) DESCRIBE `ports` 0.0018839836120605
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00048995018005371
(435) DESCRIBE `ports` 0.0018529891967773
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.0004580020904541
(437) DESCRIBE `ports` 0.0018670558929443
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00044584274291992
(439) DESCRIBE `ports` 0.0018200874328613
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00043511390686035
(441) DESCRIBE `ports` 0.0019080638885498
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.0003960132598877
(443) DESCRIBE `ports` 0.002007007598877
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00042605400085449
(445) DESCRIBE `ports` 0.0019600391387939
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00041007995605469
(447) DESCRIBE `ports` 0.0017910003662109
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00039005279541016
(449) DESCRIBE `ports` 0.0020730495452881
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00042510032653809
(451) DESCRIBE `ports` 0.0025370121002197
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00082182884216309
(453) DESCRIBE `ports` 0.0030148029327393
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0007631778717041
(455) DESCRIBE `ports` 0.0031228065490723
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00071001052856445
(457) DESCRIBE `ports` 0.0026330947875977
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00065898895263672
(459) DESCRIBE `ports` 0.0027198791503906
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00065088272094727
(461) DESCRIBE `ports` 0.0026237964630127
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00054597854614258
(463) DESCRIBE `ports` 0.0019710063934326
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0004889965057373
(465) DESCRIBE `avid_specials` 0.0018110275268555
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59118 and class = 'Cruise') OR (item_id = 1405 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0012609958648682
(467) DESCRIBE `cruiselines` 0.0027439594268799
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00053906440734863
(469) DESCRIBE `orchid_image` 0.0024218559265137
(470) DESCRIBE `cruiselines` 0.002971887588501
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00048518180847168
(472) DESCRIBE `cruiselines` 0.003126859664917
(473) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '170', '262', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '16', '208', '187', '36', '49', '47', '88', '216', '251', '151', '141', '212', '181', '4', '110', '118', '59', '30', '140', '73', '115', '147', '261', '264', '48', '213', '159', '108', '276', '209', '211', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '35', '105', '64', '134', '257', '172', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,170,262,114,24,28,14,156,191,50,258,195,37,153,16,208,187,36,49,47,88,216,251,151,141,212,181,4,110,118,59,30,140,73,115,147,261,264,48,213,159,108,276,209,211,113,90,57,82,184,95,38,180,52,244,35,105,64,134,257,172,245,177') 0.0086438655853271
(474) DESCRIBE `ships` 0.0048770904541016
(475) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '855', '1324', '1588', '1717', '207', '1794', '1291', '874', '871', '1594', '977', '1199', '1572', '454', '1766', '1359', '404', '1272', '770', '22', '330', '461', '1032', '974', '21', '393', '1237', '66', '716', '1424', '28', '797', '1292', '434', '738', '1682', '553', '1134', '332', '521', '1348', '265', '333', '711', '349', '766', '1768', '1415', '1260', '11', '857', '1419', '1423', '9', '585', '858', '1422', '1501', '1677', '10', '715', '792', '1418', '1420', '1421', '739', '163', '407', '439', '25', '34', '455', '31', '36', '378', '1678', '1132', '3', '24', '39', '657', '542', '674', '1205', '1460', '1008', '1141', '1721', '520', '837', '1067', '1607', '385', '1569', '1302', '1402', '1742', '1773', '386', '966', '1852', '113', '882', '1168', '35', '160', '1012', '1372', '850', '1233', '1454', '1574', '1822', '573', '626', '1135', '1455', '1505', '1811', '37', '98', '338', '768', '1319', '1602', '1676', '610', '30', '63', '285', '1021', '451', '1373', '352', '1284', '986', '1413', '38', '817', '1259', '1733', '547', '1282', '1411', '148', '1398', '1410', '108', '111', '314', '503', '1193', '1722', '1782', '43', '375', '406', '1088', '286', '1308', '1437', '748', '1108', '1711', '198', '340', '508', '526', '627', '1320', '1323', '1579', '116', '970', '1063', '1808', '1145', '1738', '124', '327', '485', '854', '883', '1325', '1586', '390', '582', '1571', '348', '590', '1149', '394', '1028', '1208', '1266', '119', '335', '1492', '1552', '1321', '1724', '480', '616', '944', '1068', '1412', '1575', '223', '791', '1587', '1672', '1810', '70', '82', '114', '652', '704', '1157', '75', '658', '1461', '1809', '4', '147', '545', '1027', '1801', '351', '441', '462', '678', '1289', '683', '1853', '69', '162', '325', '884', '988', '78', '201', '403', '405', '601', '722', '1245', '1318', '1330', '1408', '105', '401', '958', '1820', '291', '790', '1188', '1303', '149', '287', '341', '389', '818', '1073', '1139', '1486', '123', '262', '580', '651', '776', '1236', '81', '483', '1037', '1539', '1772', '1159', '1326', '1327', '1367', '1526', '1704', '1771', '423', '673', '1013', '1151', '1172', '1463', '1540', '266', '796', '1019', '1043', '1757', '290', '1040', '1554', '1555', '45', '574', '639', '968', '1474', '1573', '1730', '635', '1035', '1426', '1743', '84', '751', '775', '795', '1160', '1223', '1681', '1715', '852', '1217', '1338', '1344', '1740', '324', '717', '1029', '1283', '1716', '1758', '972', '1095', '1143', '1144', '1163', '1206', '1226', '1229', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '665', '709', '905', '1045', '1048', '1146', '1150', '151', '212', '417', '643', '1405', '1483', '1673', '1807', '1833', '644', '851', '885', '1136', '1137', '1152', '1262', '1293', '1448', '1449', '1746', '1042', '1230', '1231', '1351', '1647', '1787', '467', '769', '1026', '1051', '1109', '1749', '1791', '150', '453', '1025', '1090', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '208', '448', '663', '707', '954', '973', '1224', '1366', '1368', '1459', '1519', '1609', '1632', '1649', '1750', '1751', '1816', '559', '701', '740', '920', '996', '1044', '1049', '1050', '1052', '1148', '1196', '1274', '1329', '1354', '1360', '1361', '1362', '1601', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1055', '1071', '1072', '1294', '1322', '1339', '1580', '1714', '1788', '1823', '14', '886', '915', '916', '926', '930', '931', '1047', '1599', '1854', '205', '703', '784', '924', '1039', '1350', '1352', '1389', '1596', '1650', '93', '253', '299', '300', '422', '1004', '1020', '1036', '1054', '1225', '1451', '1664', '479', '888', '937', '965', '1626', '1674', '27', '487', '672', '999', '1256')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,855,1324,1588,1717,207,1794,1291,874,871,1594,977,1199,1572,454,1766,1359,404,1272,770,22,330,461,1032,974,21,393,1237,66,716,1424,28,797,1292,434,738,1682,553,1134,332,521,1348,265,333,711,349,766,1768,1415,1260,11,857,1419,1423,9,585,858,1422,1501,1677,10,715,792,1418,1420,1421,739,163,407,439,25,34,455,31,36,378,1678,1132,3,24,39,657,542,674,1205,1460,1008,1141,1721,520,837,1067,1607,385,1569,1302,1402,1742,1773,386,966,1852,113,882,1168,35,160,1012,1372,850,1233,1454,1574,1822,573,626,1135,1455,1505,1811,37,98,338,768,1319,1602,1676,610,30,63,285,1021,451,1373,352,1284,986,1413,38,817,1259,1733,547,1282,1411,148,1398,1410,108,111,314,503,1193,1722,1782,43,375,406,1088,286,1308,1437,748,1108,1711,198,340,508,526,627,1320,1323,1579,116,970,1063,1808,1145,1738,124,327,485,854,883,1325,1586,390,582,1571,348,590,1149,394,1028,1208,1266,119,335,1492,1552,1321,1724,480,616,944,1068,1412,1575,223,791,1587,1672,1810,70,82,114,652,704,1157,75,658,1461,1809,4,147,545,1027,1801,351,441,462,678,1289,683,1853,69,162,325,884,988,78,201,403,405,601,722,1245,1318,1330,1408,105,401,958,1820,291,790,1188,1303,149,287,341,389,818,1073,1139,1486,123,262,580,651,776,1236,81,483,1037,1539,1772,1159,1326,1327,1367,1526,1704,1771,423,673,1013,1151,1172,1463,1540,266,796,1019,1043,1757,290,1040,1554,1555,45,574,639,968,1474,1573,1730,635,1035,1426,1743,84,751,775,795,1160,1223,1681,1715,852,1217,1338,1344,1740,324,717,1029,1283,1716,1758,972,1095,1143,1144,1163,1206,1226,1229,1343,1358,1409,1452,1453,1604,1663,665,709,905,1045,1048,1146,1150,151,212,417,643,1405,1483,1673,1807,1833,644,851,885,1136,1137,1152,1262,1293,1448,1449,1746,1042,1230,1231,1351,1647,1787,467,769,1026,1051,1109,1749,1791,150,453,1025,1090,1140,1154,1340,1458,1723,1759,1806,208,448,663,707,954,973,1224,1366,1368,1459,1519,1609,1632,1649,1750,1751,1816,559,701,740,920,996,1044,1049,1050,1052,1148,1196,1274,1329,1354,1360,1361,1362,1601,1708,1713,1805,666,914,921,923,927,1055,1071,1072,1294,1322,1339,1580,1714,1788,1823,14,886,915,916,926,930,931,1047,1599,1854,205,703,784,924,1039,1350,1352,1389,1596,1650,93,253,299,300,422,1004,1020,1036,1054,1225,1451,1664,479,888,937,965,1626,1674,27,487,672,999,1256') 0.081316947937012
(476) DESCRIBE `cruisetypes` 0.0022530555725098
(477) DESCRIBE `destinations` 0.0036129951477051
(478) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '48', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,48,21,29,52,34,10,46,56,32') 0.0027949810028076