or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

 
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

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

    Nights 1 Ship VSpirit Classic
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 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 More 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.
  • Jasmine, The Dragon Passage ex Halong Bay Return

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

    Select a sailing date for approximate pricing.

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

  • Violet, The Dragon Passage ex Halong Bay Return

    Nights 1 Ship Violet
    Star Rating Specialty Departs Halong Bay, Vietnam
    Sailing 2018: 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 More 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.
  • Oosterdam, Greek & Mediterranean Romance ex Rome to Barcelona

    Nights 24 Ship Oosterdam
    Star Rating 5 Star Departs Rome (Civitavecchia), Italy
    Sailing 2018: 16 Aug, 3 Oct
    Ports of Call Rome (Civitavecchia), Naples, Santorini, Rhodes, Iraklion, Athens (Piraeus) Greece, Navplion, Argostoli More Corfu, Kotor, Venice, Dubrovnik, Sarande, Katakolon, Livorno, Monte Carlo, Toulon, Barcelona Less

    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.

  • Mahler, Grand Europe ex Budapest to Amsterdam

    Nights 16 Ship Crystal Mahler
    Star Rating River Departs Budapest, Hungary
    Sailing 2018: 16 Aug, 17 Sep, 19 Oct, 20 Nov, 22 Dec 2019: 20 May, 21 Jun, 23 Jul, 24 Aug, 25 Sep
    Ports of Call Budapest, Bratislava, Vienna, Durnstein, Melk , Passau, Deggendorf, Regensburg, Nuremberg, Bamberg, Wurzburg, Miltenberg, Koblenz, Cologne, Amsterdam
    Please enquire about this cruise for pricing.
  • Ravel, Majestic Europe ex Vienna to Basel

    Nights 14 Ship Crystal Ravel
    Star Rating River Departs Vienna, Austria
    Sailing 2018: 16 Aug, 27 Sep, 25 Oct
    Ports of Call Vienna, Durnstein, Melk , Linz, Passau, Regensburg, Nuremberg, Bamberg, Wurzburg, Miltenberg, Koblenz, Speyer, Kehl, Basel
    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: 736

Total elapsed time: 0.83245801925659

# Query Time
(1) connect 0.00079512596130371
(2) DESCRIBE `cruises` 0.0042319297790527
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (44275, 49177, 65920, 71154, 67110, 67373, 59221, 65237, 65604, 67370)) ORDER BY FIND_IN_SET(id, '44275,49177,65920,71154,67110,67373,59221,65237,65604,67370') 0.0018310546875
(4) DESCRIBE `cruises` 0.0035381317138672
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44275') 0.00042295455932617
(6) DESCRIBE `ships` 0.0036721229553223
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00065112113952637
(8) DESCRIBE `ships` 0.0033988952636719
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00041985511779785
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034713745117188
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(12) DESCRIBE `itineraries` 0.0018482208251953
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '44275') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077390670776367
(14) DESCRIBE `ports` 0.0019350051879883
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00044918060302734
(16) DESCRIBE `ports` 0.0017490386962891
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034594535827637
(18) DESCRIBE `ports` 0.0016500949859619
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037598609924316
(20) DESCRIBE `sailingdates` 0.0016100406646729
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '44275') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0023419857025146
(22) DESCRIBE `ports` 0.0020561218261719
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046896934509277
(24) DESCRIBE `ports` 0.0016679763793945
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037598609924316
(26) DESCRIBE `ports` 0.0015869140625
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037598609924316
(28) DESCRIBE `ports` 0.0015459060668945
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031018257141113
(30) DESCRIBE `avid_specials` 0.0016810894012451
(31) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44275 and class = 'Cruise') OR (item_id = 1127 AND class = 'Ship') OR (item_id = 221 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016388893127441
(32) DESCRIBE `cruiselines` 0.0027470588684082
(33) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00052404403686523
(34) DESCRIBE `orchid_image` 0.0021569728851318
(35) DESCRIBE `cruiselines` 0.0025260448455811
(36) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00041699409484863
(37) DESCRIBE `cruises` 0.0033049583435059
(38) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49177') 0.00057792663574219
(39) DESCRIBE `ships` 0.0038280487060547
(40) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00062298774719238
(41) DESCRIBE `ships` 0.0037941932678223
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.0005500316619873
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031709671020508
(45) DESCRIBE `itineraries` 0.0019040107727051
(46) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '49177') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007481575012207
(47) DESCRIBE `ports` 0.0018458366394043
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045299530029297
(49) DESCRIBE `ports` 0.0019278526306152
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043296813964844
(51) DESCRIBE `ports` 0.0018210411071777
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031089782714844
(53) DESCRIBE `sailingdates` 0.0012710094451904
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '49177') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012681484222412
(55) DESCRIBE `ports` 0.0017349720001221
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035190582275391
(57) DESCRIBE `ports` 0.001349925994873
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00027990341186523
(59) DESCRIBE `ports` 0.0012719631195068
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031399726867676
(61) DESCRIBE `ports` 0.0016059875488281
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00034499168395996
(63) DESCRIBE `avid_specials` 0.001554012298584
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49177 and class = 'Cruise') OR (item_id = 1247 AND class = 'Ship') OR (item_id = 232 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011119842529297
(65) DESCRIBE `cruiselines` 0.0019910335540771
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00033879280090332
(67) DESCRIBE `orchid_image` 0.0015749931335449
(68) DESCRIBE `cruiselines` 0.0017719268798828
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00034594535827637
(70) DESCRIBE `cruises` 0.0034120082855225
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00032901763916016
(72) DESCRIBE `ships` 0.0028800964355469
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00039196014404297
(74) DESCRIBE `ships` 0.0024170875549316
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.0003049373626709
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026798248291016
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032401084899902
(78) DESCRIBE `itineraries` 0.0015401840209961
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65920') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052809715270996
(80) DESCRIBE `ports` 0.0013809204101562
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029993057250977
(82) DESCRIBE `ports` 0.0012669563293457
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029802322387695
(84) DESCRIBE `ports` 0.0014500617980957
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030899047851562
(86) DESCRIBE `sailingdates` 0.0012791156768799
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65920') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00124192237854
(88) DESCRIBE `ports` 0.0017869472503662
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0011360645294189
(90) DESCRIBE `ports` 0.0017468929290771
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039911270141602
(92) DESCRIBE `ports` 0.0015969276428223
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033402442932129
(94) DESCRIBE `ports` 0.0013449192047119
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031900405883789
(96) DESCRIBE `avid_specials` 0.0017111301422119
(97) 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.0015988349914551
(98) DESCRIBE `cruiselines` 0.0025389194488525
(99) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00039100646972656
(100) DESCRIBE `orchid_image` 0.0015420913696289
(101) DESCRIBE `cruiselines` 0.0017740726470947
(102) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00027799606323242
(103) DESCRIBE `cruises` 0.0025138854980469
(104) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.00054693222045898
(105) DESCRIBE `ships` 0.0030629634857178
(106) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00042915344238281
(107) DESCRIBE `ships` 0.0025880336761475
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00031208992004395
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028395652770996
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032520294189453
(111) DESCRIBE `itineraries` 0.0015618801116943
(112) DESCRIBE `ports` 0.0015590190887451
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043487548828125
(114) DESCRIBE `ports` 0.001554012298584
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00032210350036621
(116) DESCRIBE `ports` 0.0014379024505615
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00029802322387695
(118) DESCRIBE `sailingdates` 0.0011529922485352
(119) DESCRIBE `ports` 0.0020270347595215
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045585632324219
(121) DESCRIBE `ports` 0.0016651153564453
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00062894821166992
(123) DESCRIBE `ports` 0.001417875289917
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033211708068848
(125) DESCRIBE `ports` 0.0016510486602783
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038909912109375
(127) DESCRIBE `avid_specials` 0.0013289451599121
(128) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012619495391846
(129) DESCRIBE `cruiselines` 0.0022351741790771
(130) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00042080879211426
(131) DESCRIBE `orchid_image` 0.0021238327026367
(132) DESCRIBE `cruiselines` 0.0028278827667236
(133) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00033688545227051
(134) DESCRIBE `cruises` 0.0030570030212402
(135) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67110') 0.00039196014404297
(136) DESCRIBE `ships` 0.0029261112213135
(137) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00046682357788086
(138) DESCRIBE `ships` 0.0028359889984131
(139) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00036811828613281
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(142) DESCRIBE `itineraries` 0.0014810562133789
(143) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67110') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080204010009766
(144) DESCRIBE `ports` 0.0016429424285889
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00036406517028809
(146) DESCRIBE `ports` 0.0012400150299072
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030684471130371
(148) DESCRIBE `ports` 0.0015530586242676
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036191940307617
(150) DESCRIBE `sailingdates` 0.0014019012451172
(151) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67110') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068306922912598
(152) DESCRIBE `ports` 0.0018208026885986
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00016999244689941
(154) DESCRIBE `ports` 0.0015268325805664
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00031590461730957
(156) DESCRIBE `ports` 0.0017340183258057
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00033116340637207
(158) DESCRIBE `ports` 0.0015170574188232
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00031590461730957
(160) DESCRIBE `ports` 0.0013511180877686
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00029993057250977
(162) DESCRIBE `ports` 0.0013608932495117
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00026893615722656
(164) DESCRIBE `ports` 0.0012710094451904
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00032997131347656
(166) DESCRIBE `ports` 0.0013930797576904
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00027918815612793
(168) DESCRIBE `ports` 0.0013391971588135
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.00036191940307617
(170) DESCRIBE `ports` 0.0014619827270508
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.00028705596923828
(172) DESCRIBE `ports` 0.0013489723205566
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00039410591125488
(174) DESCRIBE `ports` 0.00130295753479
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032186508178711
(176) DESCRIBE `ports` 0.0013008117675781
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00029993057250977
(178) DESCRIBE `ports` 0.0013511180877686
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00033807754516602
(180) DESCRIBE `ports` 0.0014140605926514
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00035285949707031
(182) DESCRIBE `ports` 0.0013201236724854
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00028395652770996
(184) DESCRIBE `ports` 0.0013320446014404
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00034379959106445
(186) DESCRIBE `ports` 0.0013868808746338
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00028109550476074
(188) DESCRIBE `ports` 0.001471996307373
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00036001205444336
(190) DESCRIBE `ports` 0.0014998912811279
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00041103363037109
(192) DESCRIBE `ports` 0.0013201236724854
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031089782714844
(194) DESCRIBE `ports` 0.0013210773468018
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031399726867676
(196) DESCRIBE `ports` 0.0015430450439453
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040102005004883
(198) DESCRIBE `ports` 0.0014259815216064
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032901763916016
(200) DESCRIBE `ports` 0.0013589859008789
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00034213066101074
(202) DESCRIBE `ports` 0.0012869834899902
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00011801719665527
(204) DESCRIBE `ports` 0.0014820098876953
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00032901763916016
(206) DESCRIBE `ports` 0.0019118785858154
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00046086311340332
(208) DESCRIBE `ports` 0.0015251636505127
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00039792060852051
(210) DESCRIBE `ports` 0.0013329982757568
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00029492378234863
(212) DESCRIBE `ports` 0.0015201568603516
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030899047851562
(214) DESCRIBE `ports` 0.0013110637664795
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002751350402832
(216) DESCRIBE `ports` 0.0013818740844727
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033402442932129
(218) DESCRIBE `ports` 0.0013120174407959
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032281875610352
(220) DESCRIBE `ports` 0.0013108253479004
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031208992004395
(222) DESCRIBE `ports` 0.0013949871063232
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026988983154297
(224) DESCRIBE `ports` 0.0014519691467285
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00037097930908203
(226) DESCRIBE `ports` 0.0013329982757568
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00028085708618164
(228) DESCRIBE `ports` 0.0012679100036621
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00035214424133301
(230) DESCRIBE `ports` 0.0012631416320801
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00028681755065918
(232) DESCRIBE `ports` 0.0012660026550293
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032401084899902
(234) DESCRIBE `ports` 0.0012860298156738
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029301643371582
(236) DESCRIBE `ports` 0.0014150142669678
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031399726867676
(238) DESCRIBE `ports` 0.0013449192047119
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003199577331543
(240) DESCRIBE `avid_specials` 0.0011699199676514
(241) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67110 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 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.0010988712310791
(242) DESCRIBE `cruiselines` 0.0021908283233643
(243) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00042414665222168
(244) DESCRIBE `orchid_image` 0.0017209053039551
(245) DESCRIBE `cruiselines` 0.0021560192108154
(246) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00034809112548828
(247) DESCRIBE `cruises` 0.0027379989624023
(248) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67373') 0.00038290023803711
(249) DESCRIBE `ships` 0.0027480125427246
(250) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 798))) 0.00037789344787598
(251) DESCRIBE `ships` 0.0027530193328857
(252) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00037813186645508
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037789344787598
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030183792114258
(255) DESCRIBE `itineraries` 0.0015008449554443
(256) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67373') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079488754272461
(257) DESCRIBE `ports` 0.0014410018920898
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00031781196594238
(259) DESCRIBE `ports` 0.0016729831695557
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00029802322387695
(261) DESCRIBE `ports` 0.0012829303741455
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00029301643371582
(263) DESCRIBE `sailingdates` 0.00130295753479
(264) DESCRIBE `ports` 0.0015811920166016
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00046300888061523
(266) DESCRIBE `ports` 0.0014078617095947
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00028395652770996
(268) DESCRIBE `ports` 0.0013160705566406
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00029897689819336
(270) DESCRIBE `ports` 0.0013480186462402
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00031304359436035
(272) DESCRIBE `ports` 0.0013899803161621
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00039792060852051
(274) DESCRIBE `ports` 0.0019810199737549
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00037908554077148
(276) DESCRIBE `ports` 0.0018210411071777
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00040698051452637
(278) DESCRIBE `ports` 0.0017569065093994
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00043201446533203
(280) DESCRIBE `ports` 0.0017910003662109
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00038695335388184
(282) DESCRIBE `ports` 0.0018010139465332
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00036191940307617
(284) DESCRIBE `ports` 0.001835823059082
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00037908554077148
(286) DESCRIBE `ports` 0.0017549991607666
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00038504600524902
(288) DESCRIBE `ports` 0.0017249584197998
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4505))) 0.00060009956359863
(290) DESCRIBE `ports` 0.0020389556884766
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4505') 0.00040698051452637
(292) DESCRIBE `ports` 0.0018830299377441
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0004730224609375
(294) DESCRIBE `ports` 0.0018548965454102
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0003809928894043
(296) DESCRIBE `ports` 0.0018160343170166
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00042104721069336
(298) DESCRIBE `ports` 0.0018160343170166
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00029706954956055
(300) DESCRIBE `ports` 0.0015270709991455
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00043010711669922
(302) DESCRIBE `ports` 0.0016329288482666
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0003359317779541
(304) DESCRIBE `ports` 0.0014328956604004
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00043988227844238
(306) DESCRIBE `ports` 0.0019760131835938
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00042295455932617
(308) DESCRIBE `ports` 0.0018548965454102
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00042581558227539
(310) DESCRIBE `ports` 0.0013339519500732
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00036811828613281
(312) DESCRIBE `ports` 0.001291036605835
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00032997131347656
(314) DESCRIBE `ports` 0.0013279914855957
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00032401084899902
(316) DESCRIBE `ports` 0.0015091896057129
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00032901763916016
(318) DESCRIBE `ports` 0.0013899803161621
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00034093856811523
(320) DESCRIBE `ports` 0.0013399124145508
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00037217140197754
(322) DESCRIBE `ports` 0.0013091564178467
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.0002901554107666
(324) DESCRIBE `ports` 0.0015270709991455
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00032281875610352
(326) DESCRIBE `ports` 0.0014421939849854
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00032687187194824
(328) DESCRIBE `ports` 0.0014948844909668
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00042390823364258
(330) DESCRIBE `ports` 0.0015530586242676
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0003199577331543
(332) DESCRIBE `ports` 0.0012040138244629
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00054001808166504
(334) DESCRIBE `ports` 0.0018389225006104
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00030994415283203
(336) DESCRIBE `ports` 0.001856803894043
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00045895576477051
(338) DESCRIBE `ports` 0.0018410682678223
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00040698051452637
(340) DESCRIBE `ports` 0.0020179748535156
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00039100646972656
(342) DESCRIBE `ports` 0.0014958381652832
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00029397010803223
(344) DESCRIBE `ports` 0.0014228820800781
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00031709671020508
(346) DESCRIBE `ports` 0.0014309883117676
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00031614303588867
(348) DESCRIBE `ports` 0.0016891956329346
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00037789344787598
(350) DESCRIBE `ports` 0.0013399124145508
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00031614303588867
(352) DESCRIBE `ports` 0.0016961097717285
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00034689903259277
(354) DESCRIBE `ports` 0.0015408992767334
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.0003049373626709
(356) DESCRIBE `ports` 0.0013229846954346
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0003199577331543
(358) DESCRIBE `ports` 0.0014498233795166
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0002899169921875
(360) DESCRIBE `ports` 0.0013270378112793
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00032711029052734
(362) DESCRIBE `ports` 0.0012919902801514
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00038886070251465
(364) DESCRIBE `ports` 0.0017480850219727
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00039482116699219
(366) DESCRIBE `ports` 0.0017311573028564
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031805038452148
(368) DESCRIBE `avid_specials` 0.0011429786682129
(369) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67373 and class = 'Cruise') OR (item_id = 798 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine') OR (item_id = 50 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.0011599063873291
(370) DESCRIBE `cruiselines` 0.002302885055542
(371) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00038003921508789
(372) DESCRIBE `orchid_image` 0.0014560222625732
(373) DESCRIBE `cruiselines` 0.0021789073944092
(374) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00036406517028809
(375) DESCRIBE `cruises` 0.0032041072845459
(376) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59221') 0.00042104721069336
(377) DESCRIBE `ships` 0.002673864364624
(378) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1412))) 0.00041794776916504
(379) DESCRIBE `ships` 0.002633810043335
(380) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1412') 0.00032496452331543
(381) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(383) DESCRIBE `itineraries` 0.0014159679412842
(384) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59221') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070905685424805
(385) DESCRIBE `ports` 0.0016250610351562
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00040507316589355
(387) DESCRIBE `ports` 0.0015840530395508
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00041484832763672
(389) DESCRIBE `ports` 0.0014400482177734
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00038695335388184
(391) DESCRIBE `sailingdates` 0.0012621879577637
(392) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59221') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082588195800781
(393) DESCRIBE `ports` 0.0020020008087158
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00046086311340332
(395) DESCRIBE `ports` 0.001884937286377
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00040984153747559
(397) DESCRIBE `ports` 0.0019829273223877
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00051116943359375
(399) DESCRIBE `ports` 0.001882791519165
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00010299682617188
(401) DESCRIBE `ports` 0.0014579296112061
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00032711029052734
(403) DESCRIBE `ports` 0.0020990371704102
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00031399726867676
(405) DESCRIBE `ports` 0.0013189315795898
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031614303588867
(407) DESCRIBE `ports` 0.0013508796691895
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00031495094299316
(409) DESCRIBE `ports` 0.001366138458252
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00033807754516602
(411) DESCRIBE `ports` 0.0014209747314453
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00031590461730957
(413) DESCRIBE `ports` 0.0014889240264893
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00034618377685547
(415) DESCRIBE `ports` 0.0020570755004883
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00038909912109375
(417) DESCRIBE `ports` 0.001849889755249
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00042510032653809
(419) DESCRIBE `ports` 0.0016942024230957
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00029897689819336
(421) DESCRIBE `ports` 0.0018000602722168
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00048303604125977
(423) DESCRIBE `ports` 0.0013999938964844
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00029397010803223
(425) DESCRIBE `ports` 0.0014560222625732
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00041604042053223
(427) DESCRIBE `ports` 0.0019521713256836
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00040602684020996
(429) DESCRIBE `ports` 0.0018241405487061
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3337))) 0.00041794776916504
(431) DESCRIBE `ports` 0.0017919540405273
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3337') 0.00037193298339844
(433) DESCRIBE `ports` 0.0017879009246826
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00035405158996582
(435) DESCRIBE `ports` 0.0014050006866455
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0003049373626709
(437) DESCRIBE `ports` 0.001338005065918
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00032997131347656
(439) DESCRIBE `ports` 0.0013020038604736
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00029087066650391
(441) DESCRIBE `ports` 0.0013420581817627
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00033712387084961
(443) DESCRIBE `ports` 0.0018250942230225
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.000579833984375
(445) DESCRIBE `ports` 0.0018630027770996
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00044012069702148
(447) DESCRIBE `ports` 0.0013949871063232
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00035214424133301
(449) DESCRIBE `ports` 0.0013651847839355
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00034689903259277
(451) DESCRIBE `ports` 0.0013768672943115
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00032687187194824
(453) DESCRIBE `ports` 0.0017549991607666
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00036191940307617
(455) DESCRIBE `ports` 0.0015840530395508
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00029706954956055
(457) DESCRIBE `ports` 0.0014259815216064
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00032687187194824
(459) DESCRIBE `ports` 0.0015709400177002
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00029993057250977
(461) DESCRIBE `ports` 0.0013859272003174
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00032305717468262
(463) DESCRIBE `ports` 0.0013999938964844
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00028800964355469
(465) DESCRIBE `ports` 0.0013480186462402
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00063514709472656
(467) DESCRIBE `ports` 0.0020999908447266
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00045609474182129
(469) DESCRIBE `avid_specials` 0.0018000602722168
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59221 and class = 'Cruise') OR (item_id = 1412 AND class = 'Ship') OR (item_id = 258 AND class = 'CruiseLine') OR (item_id = 50 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.001291036605835
(471) DESCRIBE `cruiselines` 0.0020079612731934
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00044798851013184
(473) DESCRIBE `orchid_image` 0.0015308856964111
(474) DESCRIBE `cruiselines` 0.0020709037780762
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.00047087669372559
(476) DESCRIBE `cruises` 0.0031948089599609
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65237') 0.00049781799316406
(478) DESCRIBE `ships` 0.0028469562530518
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00041913986206055
(480) DESCRIBE `ships` 0.0029840469360352
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00029611587524414
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(484) DESCRIBE `itineraries` 0.0012919902801514
(485) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071406364440918
(486) DESCRIBE `ports` 0.001298189163208
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00033402442932129
(488) DESCRIBE `ports` 0.0012710094451904
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030612945556641
(490) DESCRIBE `ports` 0.0017499923706055
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028491020202637
(492) DESCRIBE `sailingdates` 0.001162052154541
(493) DESCRIBE `ports` 0.0012850761413574
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031805038452148
(495) DESCRIBE `ports` 0.0014331340789795
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027799606323242
(497) DESCRIBE `ports` 0.0012660026550293
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032305717468262
(499) DESCRIBE `ports` 0.0013120174407959
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028491020202637
(501) DESCRIBE `ports` 0.0013620853424072
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00030899047851562
(503) DESCRIBE `ports` 0.0013740062713623
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028204917907715
(505) DESCRIBE `ports` 0.0013659000396729
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00029611587524414
(507) DESCRIBE `ports` 0.0014200210571289
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00033688545227051
(509) DESCRIBE `ports` 0.0014510154724121
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00033402442932129
(511) DESCRIBE `ports` 0.0013010501861572
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.0002899169921875
(513) DESCRIBE `ports` 0.0013010501861572
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031018257141113
(515) DESCRIBE `ports` 0.0013668537139893
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00032401084899902
(517) DESCRIBE `ports` 0.0015308856964111
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00042581558227539
(519) DESCRIBE `ports` 0.0017449855804443
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00037097930908203
(521) DESCRIBE `ports` 0.0019850730895996
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00038790702819824
(523) DESCRIBE `ports` 0.0017709732055664
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00039219856262207
(525) DESCRIBE `ports` 0.0022368431091309
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051498413085938
(527) DESCRIBE `ports` 0.0016708374023438
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003211498260498
(529) DESCRIBE `ports` 0.0016028881072998
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00032496452331543
(531) DESCRIBE `ports` 0.00093579292297363
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00034618377685547
(533) DESCRIBE `ports` 0.0014660358428955
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0002748966217041
(535) DESCRIBE `ports` 0.0016520023345947
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00032305717468262
(537) DESCRIBE `avid_specials` 0.0010619163513184
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65237 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 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.0011060237884521
(539) DESCRIBE `cruiselines` 0.0021660327911377
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00036311149597168
(541) DESCRIBE `orchid_image` 0.0016548633575439
(542) DESCRIBE `cruiselines` 0.0020289421081543
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00047111511230469
(544) DESCRIBE `cruises` 0.0040831565856934
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65604') 0.00043702125549316
(546) DESCRIBE `ships` 0.0029480457305908
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1413))) 0.0005500316619873
(548) DESCRIBE `ships` 0.003108024597168
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1413') 0.0003509521484375
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029993057250977
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(552) DESCRIBE `itineraries` 0.0016980171203613
(553) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65604') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007939338684082
(554) DESCRIBE `ports` 0.0017499923706055
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00034618377685547
(556) DESCRIBE `ports` 0.0013449192047119
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031185150146484
(558) DESCRIBE `ports` 0.0015079975128174
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00044012069702148
(560) DESCRIBE `sailingdates` 0.0013599395751953
(561) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65604') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075292587280273
(562) DESCRIBE `ports` 0.0015461444854736
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00040006637573242
(564) DESCRIBE `ports` 0.0013358592987061
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00028491020202637
(566) DESCRIBE `ports` 0.0013060569763184
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00029301643371582
(568) DESCRIBE `ports` 0.0012540817260742
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00056600570678711
(570) DESCRIBE `ports` 0.0012130737304688
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00029897689819336
(572) DESCRIBE `ports` 0.001643180847168
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00033807754516602
(574) DESCRIBE `ports` 0.001478910446167
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00030684471130371
(576) DESCRIBE `ports` 0.0012879371643066
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00030088424682617
(578) DESCRIBE `ports` 0.0014219284057617
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0003662109375
(580) DESCRIBE `ports` 0.0014469623565674
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00024509429931641
(582) DESCRIBE `ports` 0.0013949871063232
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00029397010803223
(584) DESCRIBE `ports` 0.001291036605835
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00032591819763184
(586) DESCRIBE `ports` 0.0013089179992676
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00028896331787109
(588) DESCRIBE `ports` 0.0012550354003906
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00062012672424316
(590) DESCRIBE `ports` 0.0011248588562012
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00028800964355469
(592) DESCRIBE `ports` 0.0012919902801514
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00025081634521484
(594) DESCRIBE `ports` 0.0013341903686523
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00029397010803223
(596) DESCRIBE `ports` 0.001338005065918
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.0002751350402832
(598) DESCRIBE `ports` 0.0013158321380615
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00039792060852051
(600) DESCRIBE `ports` 0.0018460750579834
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00042009353637695
(602) DESCRIBE `ports` 0.001845121383667
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.0003049373626709
(604) DESCRIBE `ports` 0.0015561580657959
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00028800964355469
(606) DESCRIBE `ports` 0.0013031959533691
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00036787986755371
(608) DESCRIBE `ports` 0.0014238357543945
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00028014183044434
(610) DESCRIBE `ports` 0.0013740062713623
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00022578239440918
(612) DESCRIBE `ports` 0.0014679431915283
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00032997131347656
(614) DESCRIBE `ports` 0.0013878345489502
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3806))) 0.00024604797363281
(616) DESCRIBE `ports` 0.00160813331604
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3806') 0.00028610229492188
(618) DESCRIBE `ports` 0.0012688636779785
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00034689903259277
(620) DESCRIBE `ports` 0.0017759799957275
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.0003361701965332
(622) DESCRIBE `ports` 0.0016801357269287
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00041007995605469
(624) DESCRIBE `ports` 0.0016999244689941
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00046515464782715
(626) DESCRIBE `avid_specials` 0.0015299320220947
(627) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65604 and class = 'Cruise') OR (item_id = 1413 AND class = 'Ship') OR (item_id = 258 AND class = 'CruiseLine') OR (item_id = 50 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.0013217926025391
(628) DESCRIBE `cruiselines` 0.0020191669464111
(629) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00038790702819824
(630) DESCRIBE `orchid_image` 0.0014369487762451
(631) DESCRIBE `cruiselines` 0.001802921295166
(632) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.00035691261291504
(633) DESCRIBE `cruises` 0.0025568008422852
(634) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67370') 0.00030994415283203
(635) DESCRIBE `ships` 0.00313401222229
(636) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 798))) 0.00045394897460938
(637) DESCRIBE `ships` 0.0027902126312256
(638) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00028896331787109
(639) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032210350036621
(640) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(641) DESCRIBE `itineraries` 0.0012378692626953
(642) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67370') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049877166748047
(643) DESCRIBE `ports` 0.0014190673828125
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.0003199577331543
(645) DESCRIBE `ports` 0.0013940334320068
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00028300285339355
(647) DESCRIBE `ports` 0.0013480186462402
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00028705596923828
(649) DESCRIBE `sailingdates` 0.001209020614624
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67370') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050616264343262
(651) DESCRIBE `ports` 0.0013980865478516
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00042295455932617
(653) DESCRIBE `ports` 0.0020110607147217
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00028109550476074
(655) DESCRIBE `ports` 0.00160813331604
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00035285949707031
(657) DESCRIBE `ports` 0.0013141632080078
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00028300285339355
(659) DESCRIBE `ports` 0.0016870498657227
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00043702125549316
(661) DESCRIBE `ports` 0.0019111633300781
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00039815902709961
(663) DESCRIBE `ports` 0.001812219619751
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.0003960132598877
(665) DESCRIBE `ports` 0.001878023147583
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00040793418884277
(667) DESCRIBE `ports` 0.001816987991333
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00039577484130859
(669) DESCRIBE `ports` 0.00177001953125
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00036287307739258
(671) DESCRIBE `ports` 0.0018320083618164
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00044894218444824
(673) DESCRIBE `ports` 0.0016341209411621
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00031399726867676
(675) DESCRIBE `ports` 0.0016810894012451
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4505))) 0.00035595893859863
(677) DESCRIBE `ports` 0.0014851093292236
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4505') 0.00031590461730957
(679) DESCRIBE `ports` 0.0013549327850342
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00031399726867676
(681) DESCRIBE `ports` 0.0015509128570557
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00027799606323242
(683) DESCRIBE `ports` 0.001338005065918
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00037407875061035
(685) DESCRIBE `ports` 0.0016310214996338
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00031590461730957
(687) DESCRIBE `ports` 0.0015549659729004
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00037002563476562
(689) DESCRIBE `ports` 0.0017898082733154
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00035881996154785
(691) DESCRIBE `ports` 0.0017061233520508
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00044083595275879
(693) DESCRIBE `ports` 0.0014660358428955
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00038695335388184
(695) DESCRIBE `ports` 0.00180983543396
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00037503242492676
(697) DESCRIBE `ports` 0.0016000270843506
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0003819465637207
(699) DESCRIBE `ports` 0.0018370151519775
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00030398368835449
(701) DESCRIBE `ports` 0.0015320777893066
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00034093856811523
(703) DESCRIBE `ports` 0.0014879703521729
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00030612945556641
(705) DESCRIBE `ports` 0.0013048648834229
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00029206275939941
(707) DESCRIBE `ports` 0.0013680458068848
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00031900405883789
(709) DESCRIBE `ports` 0.0014140605926514
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00030708312988281
(711) DESCRIBE `ports` 0.0013730525970459
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00034594535827637
(713) DESCRIBE `ports` 0.001533031463623
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00028300285339355
(715) DESCRIBE `ports` 0.0014190673828125
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00038504600524902
(717) DESCRIBE `ports` 0.0017879009246826
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00037598609924316
(719) DESCRIBE `ports` 0.0018200874328613
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00047111511230469
(721) DESCRIBE `ports` 0.0017900466918945
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0003669261932373
(723) DESCRIBE `avid_specials` 0.0015830993652344
(724) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67370 and class = 'Cruise') OR (item_id = 798 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine') OR (item_id = 50 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.0016942024230957
(725) DESCRIBE `cruiselines` 0.0025308132171631
(726) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0003960132598877
(727) DESCRIBE `orchid_image` 0.0022881031036377
(728) DESCRIBE `cruiselines` 0.002608060836792
(729) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00039196014404297
(730) DESCRIBE `cruiselines` 0.0023190975189209
(731) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '268', '37', '156', '28', '91', '262', '114', '110', '141', '131', '208', '153', '187', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '204', '4', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '264', '90', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '225', '229', '108', '88', '230', '276', '82', '244', '132', '269', '105', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,268,37,156,28,91,262,114,110,141,131,208,153,187,14,232,24,118,49,181,258,151,36,212,30,206,140,204,4,256,238,249,220,16,239,47,174,113,35,264,90,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,225,229,108,88,230,276,82,244,132,269,105,275,48,119,240,116,64,266,38,134,224,210') 0.0066359043121338
(732) DESCRIBE `ships` 0.0045020580291748
(733) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '28', '37', '38', '34', '378', '31', '393', '726', '817', '1424', '349', '1135', '30', '1012', '36', '39', '1422', '780', '1419', '1423', '1420', '1421', '1418', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '797', '207', '1460', '3', '573', '974', '116', '340', '520', '553', '1454', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1284', '1302', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '1068', '582', '1323', '434', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '348', '657', '966', '1088', '1108', '1282', '1587', '1672', '111', '163', '652', '1321', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1027', '1159', '1243', '1376', '148', '351', '683', '1151', '1471', '1526', '314', '483', '1013', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '291', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '149', '335', '716', '743', '852', '968', '1063', '1168', '1233', '1413', '1604', '152', '610', '818', '884', '1223', '1303', '1345', '1452', '1453', '1581', '1711', '82', '401', '669', '769', '1025', '1043', '1090', '1136', '1145', '1283', '1301', '1373', '1552', '45', '150', '151', '352', '790', '796', '1241', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1226', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1150', '1448', '1463', '266', '1409', '1449', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1055', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1049', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '493', '1037', '1470', '1474', '1580', '1627', '618', '836', '1224', '1444', '1518', '423', '837', '1176', '1382', '1417', '1521', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1138', '1196', '1262', '1593', '672', '709', '857', '1054', '1148', '1445', '1486', '1517', '1522', '1619', '671', '717', '972', '1017', '1042', '1051', '1352', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1053', '1134', '1384', '1481', '1628', '313', '420', '982', '1028', '1322', '1358', '1383', '1501', '1515', '1676', '453', '749', '937', '958', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1071', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1189', '1232', '1274', '1293', '1297', '1338', '1355', '1035', '1048', '1679', '1681', '1697', '70', '212', '288', '1060', '1089')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,28,37,38,34,378,31,393,726,817,1424,349,1135,30,1012,36,39,1422,780,1419,1423,1420,1421,1418,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,797,207,1460,3,573,974,116,340,520,553,1454,25,1372,1455,160,1193,874,517,580,1021,1284,1302,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,1068,582,1323,434,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,348,657,966,1088,1108,1282,1587,1672,111,163,652,1321,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1027,1159,1243,1376,148,351,683,1151,1471,1526,314,483,1013,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,291,673,768,1040,1137,1144,1157,1343,98,149,335,716,743,852,968,1063,1168,1233,1413,1604,152,610,818,884,1223,1303,1345,1452,1453,1581,1711,82,401,669,769,1025,1043,1090,1136,1145,1283,1301,1373,1552,45,150,151,352,790,796,1241,201,223,485,776,882,1160,1717,59,108,467,503,1152,1226,1539,1738,324,341,639,905,988,1149,1150,1448,1463,266,1409,1449,1540,417,871,885,1253,1411,1647,105,601,811,1055,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1049,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,493,1037,1470,1474,1580,1627,618,836,1224,1444,1518,423,837,1176,1382,1417,1521,1229,1404,1407,1410,1716,204,422,643,985,1138,1196,1262,1593,672,709,857,1054,1148,1445,1486,1517,1522,1619,671,717,972,1017,1042,1051,1352,1713,1715,781,994,1175,1714,479,480,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1053,1134,1384,1481,1628,313,420,982,1028,1322,1358,1383,1501,1515,1676,453,749,937,958,1439,1461,1645,1708,1743,775,999,1052,1071,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1189,1232,1274,1293,1297,1338,1355,1035,1048,1679,1681,1697,70,212,288,1060,1089') 0.04405403137207
(734) DESCRIBE `cruisetypes` 0.0016789436340332
(735) DESCRIBE `destinations` 0.0022270679473877
(736) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0024077892303467