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

 
  • Tonle Pandaw, Saigon & Phnom Penh Downstream ex Phnom Penh to My Tho

    Nights 4 Ship Tonle Pandaw
    Star Rating River Departs Phnom Penh Cambodia
    Sailing 2018: 15 Aug, 29 Aug, 26 Sep, 10 Oct, 24 Oct, 7 Nov, 21 Nov, 5 Dec, 19 Dec 2019: 2 Jan, 16 Jan, 30 Jan, 13 Feb, 27 Feb, 13 Mar, 27 Mar, 10 Apr, 24 Apr
    Ports of Call Phnom Penh Cambodia, Kampong Tralach, Tan Chau, Chau Doc, Cai Bei, My Tho
    Please enquire about this cruise for pricing.
  • Century Diamond, Yangtze Upstream ex Yichang to Chongqing

    Nights 4 Ship Century Diamond
    Star Rating River Departs Yichang, China
    Sailing 2018: 15 Aug, 22 Aug, 29 Aug, 5 Sep, 12 Sep, 19 Sep, 26 Sep, 3 Oct, 10 Oct, 17 Oct, 24 Oct, 31 Oct, 7 Nov, 14 Nov, 21 Nov, 28 Nov
    Ports of Call Yichang, Xiling Gorge, Wu Gorge, Shennong Stream, Qutang Gorge, Yangtze River, Chongqing
    Please enquire about this cruise for pricing.
  • Jayavarman, Pearl of the Orient Downstream ex Phnom Penh to Saigon (My Tho)

    Nights 3 Ship Jayavarman
    Star Rating River Departs Phnom Penh Cambodia
    Sailing 2018: 15 Aug, 29 Aug, 12 Sep, 26 Sep, 10 Oct, 24 Oct, 7 Nov, 21 Nov, 5 Dec, 19 Dec 2019: 2 Jan, 16 Jan, 30 Jan, 13 Feb, 27 Feb, 13 Mar, 27 Mar, 10 Apr, 24 Apr
    Ports of Call Phnom Penh Cambodia, Tan Chau, Sa Dec, Cai Bei, My Tho
    Please enquire about this cruise for pricing.
  • Victoria Katarina, 3 Gorges Highlights, ex Chongqing to Yichang

    Nights 3 Ship Victoria Katarina
    Star Rating River Departs Chongqing, China
    Sailing 2018: 15 Aug, 22 Aug, 29 Aug, 5 Sep, 12 Sep, 19 Sep, 26 Sep, 3 Oct, 10 Oct, 17 Oct, 24 Oct, 31 Oct, 7 Nov, 14 Nov, 21 Nov 2019: 20 Mar, 27 Mar, 3 Apr, 10 Apr, 17 Apr, 24 Apr More 1 May, 8 May, 15 May, 22 May, 29 May, 5 Jun, 12 Jun, 19 Jun, 26 Jun, 3 Jul, 10 Jul, 17 Jul, 24 Jul, 31 Jul, 7 Aug, 14 Aug, 21 Aug, 28 Aug, 4 Sep, 11 Sep, 18 Sep, 25 Sep, 2 Oct, 9 Oct, 16 Oct, 23 Oct, 30 Oct, 6 Nov, 13 Nov, 20 Nov Less
    Ports of Call Chongqing, Shibaozhai, Wu Gorge, Qutang Gorge, Sandouping - Three Gorges Dam, Yichang
    Please enquire about this cruise for pricing.
  • France, (TAN) Magic of Moselle & Romantic Rhine Valley, ex Cochem to Strasbourg

    Nights 3 Ship France
    Star Rating River Departs Cochem, Germany
    Sailing 2018: 15 Aug, 18 Sep, 17 Oct
    Ports of Call Cochem, Rudesheim, Worms, Strasbourg
    Please enquire about this cruise for pricing.
  • Bhaya Classic, Halong Bay Cruise ex Halong Bay Return

    Nights 2 Ship Bhaya Classic Ships
    Star Rating River Departs Halong Bay, Vietnam
    Sailing 2018: 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 2 Nights ex Halong Bay Return

    Nights 2 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, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 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, Jewels of Halong Bay ex Halong Bay Return

    Nights 2 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.
  • Genting Dream, Kuala Lumpur Cruise ex Singapore Return

    Nights 2 Ship Genting Dream
    Star Rating Not Rated Departs Singapore, Singapore
    Sailing 2018: 15 Aug, 22 Aug, 12 Sep, 19 Sep, 26 Sep, 3 Oct, 17 Oct, 24 Oct, 31 Oct, 7 Nov, 14 Nov
    Ports of Call Singapore, Port Klang
    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: 424

Total elapsed time: 0.56599402427673

# Query Time
(1) connect 0.00073504447937012
(2) DESCRIBE `cruises` 0.0032341480255127
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66031, 71220, 38581, 59433, 63184, 44276, 49176, 65919, 65921, 77704)) ORDER BY FIND_IN_SET(id, '66031,71220,38581,59433,63184,44276,49176,65919,65921,77704') 0.0014829635620117
(4) DESCRIBE `cruises` 0.0036680698394775
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66031') 0.00041794776916504
(6) DESCRIBE `ships` 0.0029120445251465
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 520))) 0.00043606758117676
(8) DESCRIBE `ships` 0.0029380321502686
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '520') 0.00033712387084961
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002739429473877
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(12) DESCRIBE `itineraries` 0.0015649795532227
(13) DESCRIBE `ports` 0.0017530918121338
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00034499168395996
(15) DESCRIBE `ports` 0.0014522075653076
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032496452331543
(17) DESCRIBE `ports` 0.0012729167938232
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00029921531677246
(19) DESCRIBE `sailingdates` 0.0012798309326172
(20) DESCRIBE `ports` 0.001535177230835
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0003349781036377
(22) DESCRIBE `ports` 0.0014770030975342
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00029897689819336
(24) DESCRIBE `ports` 0.0012829303741455
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0003669261932373
(26) DESCRIBE `ports` 0.0012528896331787
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00027608871459961
(28) DESCRIBE `ports` 0.0012750625610352
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.0003809928894043
(30) DESCRIBE `ports` 0.0012547969818115
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0003659725189209
(32) DESCRIBE `ports` 0.0013670921325684
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00039792060852051
(34) DESCRIBE `ports` 0.0015299320220947
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00029492378234863
(36) DESCRIBE `ports` 0.0014181137084961
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00032401084899902
(38) DESCRIBE `ports` 0.0014491081237793
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00029397010803223
(40) DESCRIBE `ports` 0.0014679431915283
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00030303001403809
(42) DESCRIBE `ports` 0.0013179779052734
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027608871459961
(44) DESCRIBE `avid_specials` 0.0011510848999023
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66031 and class = 'Cruise') OR (item_id = 520 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.001072883605957
(46) DESCRIBE `cruiselines` 0.0023739337921143
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00042605400085449
(48) DESCRIBE `orchid_image` 0.0015699863433838
(49) DESCRIBE `cruiselines` 0.0018429756164551
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00031208992004395
(51) DESCRIBE `cruises` 0.0025389194488525
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71220') 0.00033092498779297
(53) DESCRIBE `ships` 0.0026569366455078
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1628))) 0.00037312507629395
(55) DESCRIBE `ships` 0.0031979084014893
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1628') 0.0004730224609375
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046300888061523
(59) DESCRIBE `itineraries` 0.0017149448394775
(60) DESCRIBE `ports` 0.0014731884002686
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00035309791564941
(62) DESCRIBE `ports` 0.001413106918335
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00037503242492676
(64) DESCRIBE `ports` 0.0012891292572021
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00029087066650391
(66) DESCRIBE `sailingdates` 0.001230001449585
(67) DESCRIBE `ports` 0.0015718936920166
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00040698051452637
(69) DESCRIBE `ports` 0.0014429092407227
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00055098533630371
(71) DESCRIBE `ports` 0.0019218921661377
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00047087669372559
(73) DESCRIBE `ports` 0.0017218589782715
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00037217140197754
(75) DESCRIBE `ports` 0.00154709815979
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.0002892017364502
(77) DESCRIBE `ports` 0.0012698173522949
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00026798248291016
(79) DESCRIBE `ports` 0.001305103302002
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3100))) 0.00029492378234863
(81) DESCRIBE `ports` 0.0012540817260742
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3100') 0.00027608871459961
(83) DESCRIBE `ports` 0.0012660026550293
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00031208992004395
(85) DESCRIBE `ports` 0.0013060569763184
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00027585029602051
(87) DESCRIBE `ports` 0.0012719631195068
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3332))) 0.00040388107299805
(89) DESCRIBE `ports` 0.0016050338745117
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3332') 0.00037884712219238
(91) DESCRIBE `ports` 0.0018022060394287
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00042414665222168
(93) DESCRIBE `ports` 0.0015649795532227
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00030994415283203
(95) DESCRIBE `avid_specials` 0.0025589466094971
(96) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71220 and class = 'Cruise') OR (item_id = 1628 AND class = 'Ship') OR (item_id = 256 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.0013120174407959
(97) DESCRIBE `cruiselines` 0.0020639896392822
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 256))) 0.00047707557678223
(99) DESCRIBE `orchid_image` 0.0016841888427734
(100) DESCRIBE `cruiselines` 0.00276780128479
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '256') 0.00052595138549805
(102) DESCRIBE `cruises` 0.0035269260406494
(103) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38581') 0.00042581558227539
(104) DESCRIBE `ships` 0.0038020610809326
(105) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 797))) 0.00049996376037598
(106) DESCRIBE `ships` 0.0034639835357666
(107) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '797') 0.00037002563476562
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033783912658691
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(110) DESCRIBE `itineraries` 0.0014891624450684
(111) DESCRIBE `ports` 0.0017790794372559
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00034809112548828
(113) DESCRIBE `ports` 0.0014469623565674
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00042200088500977
(115) DESCRIBE `ports` 0.0017750263214111
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00029802322387695
(117) DESCRIBE `sailingdates` 0.0012719631195068
(118) DESCRIBE `ports` 0.0015060901641846
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00035691261291504
(120) DESCRIBE `ports` 0.00136399269104
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00031399726867676
(122) DESCRIBE `ports` 0.0013349056243896
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00030303001403809
(124) DESCRIBE `ports` 0.0012590885162354
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00027298927307129
(126) DESCRIBE `ports` 0.0012500286102295
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00034213066101074
(128) DESCRIBE `ports` 0.0013251304626465
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0002748966217041
(130) DESCRIBE `ports` 0.0014309883117676
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.0002899169921875
(132) DESCRIBE `ports` 0.0012719631195068
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00027203559875488
(134) DESCRIBE `ports` 0.00136399269104
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.0003199577331543
(136) DESCRIBE `ports` 0.0012998580932617
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00035285949707031
(138) DESCRIBE `ports` 0.001741886138916
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003969669342041
(140) DESCRIBE `ports` 0.001823902130127
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00046110153198242
(142) DESCRIBE `ports` 0.0016918182373047
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00053691864013672
(144) DESCRIBE `ports` 0.001417875289917
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00030803680419922
(146) DESCRIBE `avid_specials` 0.0013208389282227
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38581 and class = 'Cruise') OR (item_id = 797 AND class = 'Ship') OR (item_id = 183 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.0012540817260742
(148) DESCRIBE `cruiselines` 0.0024509429931641
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00042390823364258
(150) DESCRIBE `orchid_image` 0.0020458698272705
(151) DESCRIBE `cruiselines` 0.0025320053100586
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00037789344787598
(153) DESCRIBE `cruises` 0.0029420852661133
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59433') 0.00073409080505371
(155) DESCRIBE `ships` 0.002856969833374
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1421))) 0.00033402442932129
(157) DESCRIBE `ships` 0.0034241676330566
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1421') 0.00043702125549316
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035500526428223
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(161) DESCRIBE `itineraries` 0.0018370151519775
(162) DESCRIBE `ports` 0.0016930103302002
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00035309791564941
(164) DESCRIBE `ports` 0.0014629364013672
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00029587745666504
(166) DESCRIBE `ports` 0.0014288425445557
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00042915344238281
(168) DESCRIBE `sailingdates` 0.0012331008911133
(169) DESCRIBE `ports` 0.0018179416656494
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 1.5020370483398E-5
(171) DESCRIBE `ports` 0.0015120506286621
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00031495094299316
(173) DESCRIBE `ports` 0.0012648105621338
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00029397010803223
(175) DESCRIBE `ports` 0.0012550354003906
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00026106834411621
(177) DESCRIBE `ports` 0.0013129711151123
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00029921531677246
(179) DESCRIBE `ports` 0.0015819072723389
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00011014938354492
(181) DESCRIBE `ports` 0.0015180110931396
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00042605400085449
(183) DESCRIBE `ports` 0.0015790462493896
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0003058910369873
(185) DESCRIBE `ports` 0.0014100074768066
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00035309791564941
(187) DESCRIBE `ports` 0.0013511180877686
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00037908554077148
(189) DESCRIBE `ports` 0.0015401840209961
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00023412704467773
(191) DESCRIBE `ports` 0.0016851425170898
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00028610229492188
(193) DESCRIBE `avid_specials` 0.0010228157043457
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59433 and class = 'Cruise') OR (item_id = 1421 AND class = 'Ship') OR (item_id = 31 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.0011041164398193
(195) DESCRIBE `cruiselines` 0.0024058818817139
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00037288665771484
(197) DESCRIBE `orchid_image` 0.0018038749694824
(198) DESCRIBE `cruiselines` 0.0021710395812988
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00036907196044922
(200) DESCRIBE `cruises` 0.0027670860290527
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63184') 0.00043106079101562
(202) DESCRIBE `ships` 0.0033559799194336
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1037))) 0.00051999092102051
(204) DESCRIBE `ships` 0.0028669834136963
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1037') 0.00028610229492188
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031781196594238
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032377243041992
(208) DESCRIBE `itineraries` 0.0017831325531006
(209) DESCRIBE `ports` 0.0018389225006104
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00044488906860352
(211) DESCRIBE `ports` 0.0017378330230713
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00041604042053223
(213) DESCRIBE `ports` 0.0040440559387207
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.00045394897460938
(215) DESCRIBE `sailingdates` 0.0016617774963379
(216) DESCRIBE `ports` 0.0020949840545654
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1597))) 0.00046682357788086
(218) DESCRIBE `ports` 0.0018150806427002
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1597') 0.00040912628173828
(220) DESCRIBE `ports` 0.001655101776123
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00036501884460449
(222) DESCRIBE `ports` 0.0017571449279785
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00037097930908203
(224) DESCRIBE `ports` 0.0017659664154053
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00038504600524902
(226) DESCRIBE `ports` 0.0017688274383545
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00035905838012695
(228) DESCRIBE `ports` 0.0017788410186768
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2406))) 0.00046396255493164
(230) DESCRIBE `ports` 0.0012679100036621
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2406') 0.00027203559875488
(232) DESCRIBE `ports` 0.0015549659729004
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00032687187194824
(234) DESCRIBE `ports` 0.0016028881072998
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00031399726867676
(236) DESCRIBE `avid_specials` 0.0011780261993408
(237) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63184 and class = 'Cruise') OR (item_id = 1037 AND class = 'Ship') OR (item_id = 144 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.0010919570922852
(238) DESCRIBE `cruiselines` 0.0020020008087158
(239) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00039792060852051
(240) DESCRIBE `orchid_image` 0.0018010139465332
(241) DESCRIBE `cruiselines` 0.0023601055145264
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00036096572875977
(243) DESCRIBE `cruises` 0.0033609867095947
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00040698051452637
(245) DESCRIBE `ships` 0.0029201507568359
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.0003509521484375
(247) DESCRIBE `ships` 0.0033149719238281
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00038003921508789
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003049373626709
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(251) DESCRIBE `itineraries` 0.0014259815216064
(252) DESCRIBE `ports` 0.001986026763916
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047993659973145
(254) DESCRIBE `ports` 0.0014021396636963
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029397010803223
(256) DESCRIBE `ports` 0.0013928413391113
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030708312988281
(258) DESCRIBE `sailingdates` 0.0011999607086182
(259) DESCRIBE `ports` 0.0021531581878662
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046896934509277
(261) DESCRIBE `ports` 0.0017411708831787
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033903121948242
(263) DESCRIBE `ports` 0.0015468597412109
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047993659973145
(265) DESCRIBE `ports` 0.0015578269958496
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031685829162598
(267) DESCRIBE `ports` 0.0015919208526611
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037002563476562
(269) DESCRIBE `ports` 0.0020179748535156
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038814544677734
(271) DESCRIBE `avid_specials` 0.0016300678253174
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44276 and class = 'Cruise') OR (item_id = 1127 AND class = 'Ship') OR (item_id = 221 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0057799816131592
(273) DESCRIBE `cruiselines` 0.0022850036621094
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00038290023803711
(275) DESCRIBE `orchid_image` 0.0014779567718506
(276) DESCRIBE `cruiselines` 0.0021231174468994
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00035881996154785
(278) DESCRIBE `cruises` 0.0029919147491455
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.0003058910369873
(280) DESCRIBE `ships` 0.0025749206542969
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00040292739868164
(282) DESCRIBE `ships` 0.0026209354400635
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00032496452331543
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002598762512207
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024700164794922
(286) DESCRIBE `itineraries` 0.0013890266418457
(287) DESCRIBE `ports` 0.0013368129730225
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0006108283996582
(289) DESCRIBE `ports` 0.0019700527191162
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039291381835938
(291) DESCRIBE `ports` 0.0018179416656494
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037908554077148
(293) DESCRIBE `sailingdates` 0.0012221336364746
(294) DESCRIBE `ports` 0.0018379688262939
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00059890747070312
(296) DESCRIBE `ports` 0.0015618801116943
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030899047851562
(298) DESCRIBE `ports` 0.0013270378112793
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00030112266540527
(300) DESCRIBE `ports` 0.0013699531555176
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00032401084899902
(302) DESCRIBE `ports` 0.0012860298156738
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028705596923828
(304) DESCRIBE `ports` 0.0013761520385742
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026583671569824
(306) DESCRIBE `avid_specials` 0.0011639595031738
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49176 and class = 'Cruise') OR (item_id = 1247 AND class = 'Ship') OR (item_id = 232 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011439323425293
(308) DESCRIBE `cruiselines` 0.0018551349639893
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00040388107299805
(310) DESCRIBE `orchid_image` 0.0014920234680176
(311) DESCRIBE `cruiselines` 0.0021779537200928
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00034189224243164
(313) DESCRIBE `cruises` 0.0025050640106201
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00030112266540527
(315) DESCRIBE `ships` 0.0026330947875977
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.0004119873046875
(317) DESCRIBE `ships` 0.0026078224182129
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00031685829162598
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00029182434082031
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032782554626465
(321) DESCRIBE `itineraries` 0.0012969970703125
(322) DESCRIBE `ports` 0.0015599727630615
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033187866210938
(324) DESCRIBE `ports` 0.0012569427490234
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028800964355469
(326) DESCRIBE `ports` 0.0013060569763184
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0002899169921875
(328) DESCRIBE `sailingdates` 0.0011959075927734
(329) DESCRIBE `ports` 0.0017769336700439
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003509521484375
(331) DESCRIBE `ports` 0.0012760162353516
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0003058910369873
(333) DESCRIBE `ports` 0.0014479160308838
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0002899169921875
(335) DESCRIBE `ports` 0.0014848709106445
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033092498779297
(337) DESCRIBE `ports` 0.0015339851379395
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034093856811523
(339) DESCRIBE `ports` 0.00136399269104
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00027799606323242
(341) DESCRIBE `avid_specials` 0.001317024230957
(342) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65919 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001209020614624
(343) DESCRIBE `cruiselines` 0.0019350051879883
(344) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00038290023803711
(345) DESCRIBE `orchid_image` 0.0016579627990723
(346) DESCRIBE `cruiselines` 0.0022978782653809
(347) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00029706954956055
(348) DESCRIBE `cruises` 0.0030200481414795
(349) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.00037598609924316
(350) DESCRIBE `ships` 0.0027542114257812
(351) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00045204162597656
(352) DESCRIBE `ships` 0.0028209686279297
(353) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00036978721618652
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028896331787109
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024986267089844
(356) DESCRIBE `itineraries` 0.0015239715576172
(357) DESCRIBE `ports` 0.0013129711151123
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00032997131347656
(359) DESCRIBE `ports` 0.0014219284057617
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036907196044922
(361) DESCRIBE `ports` 0.0013561248779297
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028491020202637
(363) DESCRIBE `sailingdates` 0.001230001449585
(364) DESCRIBE `ports` 0.0018038749694824
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040411949157715
(366) DESCRIBE `ports` 0.0013580322265625
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028586387634277
(368) DESCRIBE `ports` 0.0013830661773682
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031304359436035
(370) DESCRIBE `ports` 0.0012569427490234
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033903121948242
(372) DESCRIBE `ports` 0.0026531219482422
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035691261291504
(374) DESCRIBE `ports` 0.0014028549194336
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033712387084961
(376) DESCRIBE `avid_specials` 0.0013198852539062
(377) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65921 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012218952178955
(378) DESCRIBE `cruiselines` 0.0021898746490479
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00045490264892578
(380) DESCRIBE `orchid_image` 0.0016708374023438
(381) DESCRIBE `cruiselines` 0.0025758743286133
(382) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00075197219848633
(383) DESCRIBE `cruises` 0.0032529830932617
(384) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77704') 0.00045180320739746
(385) DESCRIBE `ships` 0.003371000289917
(386) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00060415267944336
(387) DESCRIBE `ships` 0.0039010047912598
(388) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00051784515380859
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032591819763184
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032305717468262
(391) DESCRIBE `itineraries` 0.001990795135498
(392) DESCRIBE `ports` 0.0019149780273438
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046586990356445
(394) DESCRIBE `ports` 0.0017890930175781
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00043296813964844
(396) DESCRIBE `ports` 0.0017600059509277
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0004420280456543
(398) DESCRIBE `sailingdates` 0.001554012298584
(399) DESCRIBE `ports` 0.0021839141845703
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046014785766602
(401) DESCRIBE `ports` 0.0018470287322998
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041294097900391
(403) DESCRIBE `ports` 0.0017879009246826
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00047612190246582
(405) DESCRIBE `ports` 0.0018360614776611
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00043702125549316
(407) DESCRIBE `ports` 0.0018110275268555
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00042915344238281
(409) DESCRIBE `ports` 0.0018739700317383
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041913986206055
(411) DESCRIBE `avid_specials` 0.0017759799957275
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77704 and class = 'Cruise') OR (item_id = 1463 AND class = 'Ship') OR (item_id = 264 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.0019760131835938
(413) DESCRIBE `cruiselines` 0.0028839111328125
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00072288513183594
(415) DESCRIBE `orchid_image` 0.0022659301757812
(416) DESCRIBE `cruiselines` 0.002655029296875
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00046896934509277
(418) DESCRIBE `cruiselines` 0.0029489994049072
(419) 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.0086150169372559
(420) DESCRIBE `ships` 0.0041601657867432
(421) 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.060993909835815
(422) DESCRIBE `cruisetypes` 0.0023319721221924
(423) DESCRIBE `destinations` 0.0020828247070312
(424) 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.0023238658905029