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

 
  • Voyager, Penang Getaway Cruise ex Singapore Return

    Nights 3 Ship Voyager of the Seas
    Star Rating 4 Star Departs Singapore, Singapore
    Sailing 2018: 21 Sep, 28 Sep, 5 Oct, 12 Oct, 26 Oct, 2 Nov, 9 Nov, 16 Nov, 30 Nov, 7 Dec, 14 Dec 2019: 18 Jan, 25 Jan, 15 Feb, 22 Feb, 1 Mar
    Ports of Call Singapore, Penang

    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.

  • Star Goddess, Nile Cruise ex Aswan to Luxor

    Nights 3 Ship Star Goddess
    Star Rating River Departs Aswan, Egypt
    Sailing 2018: 21 Sep, 28 Sep, 5 Oct, 12 Oct, 19 Oct, 26 Oct, 2 Nov, 9 Nov, 16 Nov, 23 Nov, 30 Nov, 7 Dec, 14 Dec, 21 Dec, 28 Dec
    Ports of Call Aswan, Kom Ombo, Edfu, Esna, Luxor
    Please enquire about this cruise for pricing.
  • Victoria Grace, 3 Gorges Highlights, ex Chongqing to Yichang

    Nights 3 Ship Victoria Grace
    Star Rating River Departs Chongqing, China
    Sailing 2018: 21 Sep, 28 Sep, 5 Oct, 12 Oct, 19 Oct, 26 Oct, 2 Nov, 9 Nov, 16 Nov, 23 Nov 2019: 15 Mar, 22 Mar, 29 Mar, 5 Apr, 12 Apr, 19 Apr, 26 Apr, 3 May, 10 May, 17 May, 24 May More 31 May, 7 Jun, 14 Jun, 21 Jun, 28 Jun, 5 Jul, 12 Jul, 19 Jul, 26 Jul, 2 Aug, 9 Aug, 16 Aug, 23 Aug, 30 Aug, 6 Sep, 13 Sep, 20 Sep, 27 Sep, 4 Oct, 11 Oct, 18 Oct, 25 Oct, 1 Nov, 8 Nov, 15 Nov, 22 Nov Less
    Ports of Call Chongqing, Shibaozhai, Wu Gorge, Qutang Gorge, Sandouping - Three Gorges Dam, Yichang
    Please enquire about this cruise for pricing.
  • Pacific Explorer, Food and Wine Cruise ex Sydney Return

    Nights 3 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2018: 21 Sep 2019: 14 Sep, 15 Nov 2020: 13 Mar
    Ports of Call Sydney

    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.

     
    P & O 85th BIRTHDAY SALE $85 per person deposit, $85 OBC per cabin and 85th year birthday gift pack
  • Disney Dream, Halloween Bahamaian Cruise ex Port Canaveral Return

    Nights 3 Ship Disney Dream
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2018: 21 Sep, 28 Sep, 5 Oct, 12 Oct, 19 Oct, 26 Oct
    Ports of Call Port Canaveral, Nassau, Castaway Cay

    Select a sailing date for approximate pricing.

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

  • Enchantment, Bahamas ex Port Canaveral Return

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

    Select a sailing date for approximate pricing.

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

  • Mariner, Bahamas Cruise ex Miami Roundtrip

    Nights 3 Ship Mariner of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2018: 21 Sep, 28 Sep
    Ports of Call Miami, Cococay, Nassau

    Select a sailing date for approximate pricing.

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

  • Celestyal Olympia, Iconic Aegean 2018 ex Athens Return

    Nights 3 Ship Celestyal Olympia
    Star Rating 3 Star Departs Athens (Piraeus) Greece
    Sailing 2018: 21 Sep, 28 Sep, 5 Oct, 12 Oct, 19 Oct, 26 Oct, 2 Nov, 9 Nov
    Ports of Call Athens (Piraeus) Greece, Mykonos, Samos, Kusadasi, Patmos, Heraklion, Santorini
    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: 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 More 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: 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 More 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay
    Please enquire about this cruise for pricing.
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 412

Total elapsed time: 0.49001455307007

# Query Time
(1) connect 0.0014760494232178
(2) DESCRIBE `cruises` 0.0034840106964111
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (59239, 59343, 59431, 62162, 65769, 73547, 74768, 77787, 44276, 49176)) ORDER BY FIND_IN_SET(id, '59239,59343,59431,62162,65769,73547,74768,77787,44276,49176') 0.0022118091583252
(4) DESCRIBE `cruises` 0.0029540061950684
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59239') 0.00036501884460449
(6) DESCRIBE `ships` 0.0026149749755859
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00047111511230469
(8) DESCRIBE `ships` 0.0025889873504639
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00029420852661133
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025415420532227
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024104118347168
(12) DESCRIBE `itineraries` 0.0012240409851074
(13) DESCRIBE `ports` 0.0020270347595215
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 2.3126602172852E-5
(15) DESCRIBE `ports` 0.0012791156768799
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00034499168395996
(17) DESCRIBE `ports` 0.0015590190887451
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00039291381835938
(19) DESCRIBE `sailingdates` 0.0012619495391846
(20) DESCRIBE `ports` 0.0013830661773682
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029277801513672
(22) DESCRIBE `ports` 0.0013501644134521
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00026702880859375
(24) DESCRIBE `ports` 0.0013949871063232
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00030803680419922
(26) DESCRIBE `ports` 0.0013740062713623
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0
(28) DESCRIBE `ports` 0.0013470649719238
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029206275939941
(30) DESCRIBE `ports` 0.0017428398132324
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018620491027832
(32) DESCRIBE `avid_specials` 0.0013060569763184
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59239 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 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.0011200904846191
(34) DESCRIBE `cruiselines` 0.0019099712371826
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00058197975158691
(36) DESCRIBE `orchid_image` 0.0017759799957275
(37) DESCRIBE `cruiselines` 0.0023889541625977
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00035810470581055
(39) DESCRIBE `cruises` 0.0025880336761475
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59343') 0.00039196014404297
(41) DESCRIBE `ships` 0.0033321380615234
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1417))) 0.00046014785766602
(43) DESCRIBE `ships` 0.0027689933776855
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1417') 0.00031590461730957
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026082992553711
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024700164794922
(47) DESCRIBE `itineraries` 0.0013248920440674
(48) DESCRIBE `ports` 0.0012521743774414
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00034403800964355
(50) DESCRIBE `ports` 0.0012900829315186
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00029611587524414
(52) DESCRIBE `ports` 0.0012340545654297
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00027799606323242
(54) DESCRIBE `sailingdates` 0.0011279582977295
(55) DESCRIBE `ports` 0.0013411045074463
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00032305717468262
(57) DESCRIBE `ports` 0.0012979507446289
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00028085708618164
(59) DESCRIBE `ports` 0.0013329982757568
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00029706954956055
(61) DESCRIBE `ports` 0.0012450218200684
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00026798248291016
(63) DESCRIBE `ports` 0.0012249946594238
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00030088424682617
(65) DESCRIBE `ports` 0.0013580322265625
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00033402442932129
(67) DESCRIBE `ports` 0.0013210773468018
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.0003199577331543
(69) DESCRIBE `ports` 0.0012679100036621
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.00030279159545898
(71) DESCRIBE `ports` 0.0012578964233398
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00030803680419922
(73) DESCRIBE `ports` 0.0014681816101074
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00030994415283203
(75) DESCRIBE `ports` 0.0014960765838623
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.0003969669342041
(77) DESCRIBE `ports` 0.0014529228210449
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00018095970153809
(79) DESCRIBE `avid_specials` 0.00082206726074219
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59343 and class = 'Cruise') OR (item_id = 1417 AND class = 'Ship') OR (item_id = 170 AND class = 'CruiseLine') OR (item_id = 44 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010879039764404
(81) DESCRIBE `cruiselines` 0.0019080638885498
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 170))) 0.00035810470581055
(83) DESCRIBE `orchid_image` 0.0014939308166504
(84) DESCRIBE `cruiselines` 0.0022950172424316
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '170') 0.00041913986206055
(86) DESCRIBE `cruises` 0.0036699771881104
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59431') 0.00037789344787598
(88) DESCRIBE `ships` 0.0042209625244141
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1419))) 0.00070905685424805
(90) DESCRIBE `ships` 0.0033829212188721
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1419') 0.00038385391235352
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(94) DESCRIBE `itineraries` 0.0014641284942627
(95) DESCRIBE `ports` 0.0017659664154053
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00043702125549316
(97) DESCRIBE `ports` 0.0016870498657227
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0003359317779541
(99) DESCRIBE `ports` 0.0013060569763184
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00033688545227051
(101) DESCRIBE `sailingdates` 0.0012741088867188
(102) DESCRIBE `ports` 0.0015380382537842
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00039505958557129
(104) DESCRIBE `ports` 0.0017509460449219
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00040817260742188
(106) DESCRIBE `ports` 0.0028178691864014
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00047016143798828
(108) DESCRIBE `ports` 0.0014951229095459
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00033378601074219
(110) DESCRIBE `ports` 0.0016491413116455
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00038814544677734
(112) DESCRIBE `ports` 0.0018420219421387
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00035500526428223
(114) DESCRIBE `ports` 0.0017991065979004
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00039100646972656
(116) DESCRIBE `ports` 0.0016460418701172
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00037193298339844
(118) DESCRIBE `ports` 0.0016539096832275
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00036191940307617
(120) DESCRIBE `ports` 0.0016939640045166
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00034284591674805
(122) DESCRIBE `ports` 0.0018019676208496
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00038003921508789
(124) DESCRIBE `ports` 0.0016801357269287
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00021815299987793
(126) DESCRIBE `avid_specials` 0.0017340183258057
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59431 and class = 'Cruise') OR (item_id = 1419 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.0021708011627197
(128) DESCRIBE `cruiselines` 0.0030050277709961
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.0005180835723877
(130) DESCRIBE `orchid_image` 0.0021240711212158
(131) DESCRIBE `cruiselines` 0.0025238990783691
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00049495697021484
(133) DESCRIBE `cruises` 0.0031120777130127
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62162') 0.00033783912658691
(135) DESCRIBE `ships` 0.0028090476989746
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.0010721683502197
(137) DESCRIBE `ships` 0.0037350654602051
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00047707557678223
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 2.8848648071289E-5
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0
(141) DESCRIBE `itineraries` 0.00177001953125
(142) DESCRIBE `ports` 0.0014259815216064
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(144) DESCRIBE `ports` 0.0013408660888672
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032901763916016
(146) DESCRIBE `ports` 0.0014438629150391
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035595893859863
(148) DESCRIBE `sailingdates` 0.0019237995147705
(149) DESCRIBE `ports` 0.0018558502197266
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038695335388184
(151) DESCRIBE `ports` 0.0015769004821777
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039100646972656
(153) DESCRIBE `ports` 0.0014588832855225
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(155) DESCRIBE `ports` 0.001478910446167
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(157) DESCRIBE `avid_specials` 0.0012810230255127
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62162 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013179779052734
(159) DESCRIBE `cruiselines` 0.0020990371704102
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003349781036377
(161) DESCRIBE `orchid_image` 0.0017020702362061
(162) DESCRIBE `cruiselines` 0.001906156539917
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00046515464782715
(164) DESCRIBE `cruises` 0.0025341510772705
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65769') 0.00023698806762695
(166) DESCRIBE `ships` 0.0026991367340088
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 837))) 0.0003819465637207
(168) DESCRIBE `ships` 0.0025601387023926
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028395652770996
(172) DESCRIBE `itineraries` 0.0017437934875488
(173) DESCRIBE `ports` 0.0013570785522461
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0011470317840576
(175) DESCRIBE `ports` 0.0014488697052002
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00038003921508789
(177) DESCRIBE `ports` 0.0016939640045166
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00036907196044922
(179) DESCRIBE `sailingdates` 0.0020630359649658
(180) DESCRIBE `ports` 0.0017309188842773
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039505958557129
(182) DESCRIBE `ports` 0.0016448497772217
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00053787231445312
(184) DESCRIBE `ports` 0.0019698143005371
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00044107437133789
(186) DESCRIBE `ports` 0.001723051071167
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034999847412109
(188) DESCRIBE `ports` 0.0017158985137939
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00033402442932129
(190) DESCRIBE `ports` 0.0016520023345947
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00036382675170898
(192) DESCRIBE `ports` 0.0017797946929932
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042915344238281
(194) DESCRIBE `ports` 0.001600980758667
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00028800964355469
(196) DESCRIBE `avid_specials` 0.0014588832855225
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65769 and class = 'Cruise') OR (item_id = 837 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013618469238281
(198) DESCRIBE `cruiselines` 0.0018761157989502
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00032591819763184
(200) DESCRIBE `orchid_image` 0.0014069080352783
(201) DESCRIBE `cruiselines` 0.0019028186798096
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00030207633972168
(203) DESCRIBE `cruises` 0.0026168823242188
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73547') 0.00033903121948242
(205) DESCRIBE `ships` 0.002816915512085
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00044608116149902
(207) DESCRIBE `ships` 0.0026850700378418
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00034403800964355
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(211) DESCRIBE `itineraries` 0.0012881755828857
(212) DESCRIBE `ports` 0.0012550354003906
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00031900405883789
(214) DESCRIBE `ports` 0.0012679100036621
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029778480529785
(216) DESCRIBE `ports` 0.0012340545654297
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00027704238891602
(218) DESCRIBE `sailingdates` 0.0011858940124512
(219) DESCRIBE `ports` 0.0013830661773682
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00032782554626465
(221) DESCRIBE `ports` 0.0012929439544678
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00027704238891602
(223) DESCRIBE `ports` 0.0012550354003906
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0003359317779541
(225) DESCRIBE `ports` 0.0012531280517578
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027298927307129
(227) DESCRIBE `ports` 0.0012359619140625
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.0003809928894043
(229) DESCRIBE `ports` 0.0012631416320801
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00026893615722656
(231) DESCRIBE `ports` 0.0013031959533691
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029993057250977
(233) DESCRIBE `ports` 0.0013217926025391
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00031208992004395
(235) DESCRIBE `avid_specials` 0.0012819766998291
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73547 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012738704681396
(237) DESCRIBE `cruiselines` 0.001971960067749
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0003659725189209
(239) DESCRIBE `orchid_image` 0.0015048980712891
(240) DESCRIBE `cruiselines` 0.0017850399017334
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036311149597168
(242) DESCRIBE `cruises` 0.0023970603942871
(243) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74768') 0.00030994415283203
(244) DESCRIBE `ships` 0.0024278163909912
(245) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00038695335388184
(246) DESCRIBE `ships` 0.002418041229248
(247) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00038409233093262
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(250) DESCRIBE `itineraries` 0.0012261867523193
(251) DESCRIBE `ports` 0.0012831687927246
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031208992004395
(253) DESCRIBE `ports` 0.0013020038604736
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033903121948242
(255) DESCRIBE `ports` 0.0012779235839844
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030779838562012
(257) DESCRIBE `sailingdates` 0.001115083694458
(258) DESCRIBE `ports` 0.0012779235839844
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031709671020508
(260) DESCRIBE `ports` 0.001345157623291
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028610229492188
(262) DESCRIBE `ports` 0.0012669563293457
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00029492378234863
(264) DESCRIBE `ports` 0.0013101100921631
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0002899169921875
(266) DESCRIBE `ports` 0.0013070106506348
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00035285949707031
(268) DESCRIBE `ports` 0.0012998580932617
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027799606323242
(270) DESCRIBE `ports` 0.0012469291687012
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00038599967956543
(272) DESCRIBE `ports` 0.0015408992767334
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002899169921875
(274) DESCRIBE `avid_specials` 0.001237154006958
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74768 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012381076812744
(276) DESCRIBE `cruiselines` 0.0019419193267822
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034213066101074
(278) DESCRIBE `orchid_image` 0.0014278888702393
(279) DESCRIBE `cruiselines` 0.0018150806427002
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029110908508301
(281) DESCRIBE `cruises` 0.0026960372924805
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77787') 0.00032401084899902
(283) DESCRIBE `ships` 0.0029699802398682
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 817))) 0.00039100646972656
(285) DESCRIBE `ships` 0.0025320053100586
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '817') 0.00027990341186523
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026607513427734
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025296211242676
(289) DESCRIBE `itineraries` 0.0012819766998291
(290) DESCRIBE `ports` 0.001331090927124
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032305717468262
(292) DESCRIBE `ports` 0.001288890838623
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00029897689819336
(294) DESCRIBE `ports` 0.0012490749359131
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027203559875488
(296) DESCRIBE `sailingdates` 0.0011749267578125
(297) DESCRIBE `ports` 0.00142502784729
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031304359436035
(299) DESCRIBE `ports` 0.0012590885162354
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027608871459961
(301) DESCRIBE `ports` 0.0013010501861572
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00031805038452148
(303) DESCRIBE `ports` 0.0013248920440674
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028204917907715
(305) DESCRIBE `ports` 0.001270055770874
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 926))) 0.00031304359436035
(307) DESCRIBE `ports` 0.0013101100921631
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '926') 0.00029206275939941
(309) DESCRIBE `ports` 0.0012438297271729
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00030088424682617
(311) DESCRIBE `ports` 0.0013680458068848
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00026202201843262
(313) DESCRIBE `ports` 0.0012459754943848
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.00028896331787109
(315) DESCRIBE `ports` 0.0012600421905518
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00026178359985352
(317) DESCRIBE `ports` 0.0012421607971191
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.0003058910369873
(319) DESCRIBE `ports` 0.0015790462493896
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00027680397033691
(321) DESCRIBE `ports` 0.0012688636779785
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0003049373626709
(323) DESCRIBE `ports` 0.0012459754943848
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029087066650391
(325) DESCRIBE `ports` 0.0013339519500732
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00032496452331543
(327) DESCRIBE `ports` 0.0012540817260742
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027203559875488
(329) DESCRIBE `avid_specials` 0.00130295753479
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77787 and class = 'Cruise') OR (item_id = 817 AND class = 'Ship') OR (item_id = 118 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.0010349750518799
(331) DESCRIBE `cruiselines` 0.001906156539917
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 118))) 0.00033211708068848
(333) DESCRIBE `orchid_image` 0.0014588832855225
(334) DESCRIBE `cruiselines` 0.0018010139465332
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '118') 0.00037884712219238
(336) DESCRIBE `cruises` 0.0024700164794922
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00030398368835449
(338) DESCRIBE `ships` 0.0025219917297363
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.00037002563476562
(340) DESCRIBE `ships` 0.0029339790344238
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.0003211498260498
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038385391235352
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(344) DESCRIBE `itineraries` 0.0013282299041748
(345) DESCRIBE `ports` 0.0013689994812012
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036191940307617
(347) DESCRIBE `ports` 0.0012850761413574
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031399726867676
(349) DESCRIBE `ports` 0.0012760162353516
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037693977355957
(351) DESCRIBE `sailingdates` 0.0015499591827393
(352) DESCRIBE `ports` 0.0016779899597168
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037193298339844
(354) DESCRIBE `ports` 0.0012800693511963
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028800964355469
(356) DESCRIBE `ports` 0.001255989074707
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00029706954956055
(358) DESCRIBE `ports` 0.0012249946594238
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026202201843262
(360) DESCRIBE `ports` 0.0012228488922119
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00031805038452148
(362) DESCRIBE `ports` 0.0012319087982178
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00027108192443848
(364) DESCRIBE `avid_specials` 0.0010950565338135
(365) 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.001011848449707
(366) DESCRIBE `cruiselines` 0.0017948150634766
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00033807754516602
(368) DESCRIBE `orchid_image` 0.0013871192932129
(369) DESCRIBE `cruiselines` 0.0018689632415771
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00052595138549805
(371) DESCRIBE `cruises` 0.0025031566619873
(372) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.0003209114074707
(373) DESCRIBE `ships` 0.0026118755340576
(374) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00042414665222168
(375) DESCRIBE `ships` 0.0025119781494141
(376) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00059413909912109
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034284591674805
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033092498779297
(379) DESCRIBE `itineraries` 0.0014858245849609
(380) DESCRIBE `ports` 0.001270055770874
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00033998489379883
(382) DESCRIBE `ports` 0.0012779235839844
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00030303001403809
(384) DESCRIBE `ports` 0.0012969970703125
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043606758117676
(386) DESCRIBE `sailingdates` 0.0013370513916016
(387) DESCRIBE `ports` 0.0017151832580566
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00034999847412109
(389) DESCRIBE `ports` 0.0013039112091064
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00028705596923828
(391) DESCRIBE `ports` 0.0012509822845459
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00028705596923828
(393) DESCRIBE `ports` 0.0012650489807129
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026202201843262
(395) DESCRIBE `ports` 0.0013470649719238
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00027918815612793
(397) DESCRIBE `ports` 0.0012741088867188
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00029492378234863
(399) DESCRIBE `avid_specials` 0.0010969638824463
(400) 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.001039981842041
(401) DESCRIBE `cruiselines` 0.001964807510376
(402) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00049996376037598
(403) DESCRIBE `orchid_image` 0.0015931129455566
(404) DESCRIBE `cruiselines` 0.0019409656524658
(405) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00030803680419922
(406) DESCRIBE `cruiselines` 0.0027520656585693
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '12', '23', '171', '144', '18', '20', '101', '31', '8', '96', '131', '183', '239', '120', '191', '206', '29', '50', '103', '15', '221', '33', '28', '262', '24', '91', '268', '114', '110', '156', '37', '208', '141', '14', '187', '153', '118', '49', '211', '151', '30', '232', '258', '216', '181', '212', '36', '4', '140', '225', '238', '249', '256', '204', '47', '113', '16', '174', '90', '88', '261', '35', '182', '188', '230', '136', '237', '264', '159', '195', '146', '115', '213', '220', '180', '57', '64', '73', '248', '196', '209', '95', '168', '52', '184', '219', '59', '231', '170', '229', '116', '82', '119', '244', '105', '134', '108', '276', '48', '275', '240', '269', '132', '266', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,12,23,171,144,18,20,101,31,8,96,131,183,239,120,191,206,29,50,103,15,221,33,28,262,24,91,268,114,110,156,37,208,141,14,187,153,118,49,211,151,30,232,258,216,181,212,36,4,140,225,238,249,256,204,47,113,16,174,90,88,261,35,182,188,230,136,237,264,159,195,146,115,213,220,180,57,64,73,248,196,209,95,168,52,184,219,59,231,170,229,116,82,119,244,105,134,108,276,48,275,240,269,132,266,224,210') 0.0068721771240234
(408) DESCRIBE `ships` 0.0029928684234619
(409) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '1359', '977', '1291', '454', '1272', '1247', '1554', '1555', '1599', '855', '986', '1237', '1594', '1588', '1067', '258', '407', '1677', '34', '22', '27', '37', '38', '378', '461', '21', '28', '31', '393', '817', '1135', '780', '30', '36', '349', '726', '1012', '1424', '39', '1422', '35', '1419', '1423', '1420', '1415', '1418', '1421', '404', '882', '1176', '462', '113', '1215', '1245', '1405', '766', '24', '330', '711', '11', '1574', '439', '452', '9', '265', '10', '455', '1607', '1744', '1141', '585', '542', '739', '1572', '124', '635', '674', '770', '573', '3', '5', '874', '792', '1454', '340', '1372', '116', '580', '351', '716', '1193', '338', '553', '1168', '1302', '520', '797', '1284', '1460', '25', '66', '1402', '1471', '160', '285', '974', '1021', '332', '1095', '1455', '207', '253', '4', '43', '390', '748', '111', '148', '658', '993', '1172', '1325', '791', '1260', '1320', '1678', '81', '517', '1259', '1323', '1562', '406', '1195', '582', '590', '678', '286', '434', '1068', '1575', '119', '327', '526', '559', '970', '616', '63', '108', '421', '854', '78', '375', '401', '657', '883', '1266', '547', '1139', '1571', '1586', '84', '722', '1208', '1569', '775', '1492', '150', '335', '850', '1008', '1236', '1398', '1587', '114', '1308', '1437', '14', '784', '152', '403', '958', '1268', '1672', '151', '1064', '823', '1108', '1289', '1319', '1724', '405', '451', '652', '704', '715', '966', '1088', '325', '348', '683', '1282', '1321', '123', '162', '790', '1243', '262', '389', '1013', '1143', '1159', '1269', '1330', '1348', '1389', '732', '75', '163', '441', '483', '1270', '1326', '1327', '1526', '1579', '508', '1151', '1214', '1557', '1561', '314', '333', '768', '1367', '385', '394', '626', '1318', '1376', '93', '287', '290', '545', '1711', '1075', '1602', '82', '98', '521', '651', '796', '968', '1344', '1539', '1722', '149', '673', '751', '818', '884', '1027', '1040', '1137', '1144', '1163', '1216', '1343', '1717', '201', '291', '743', '852', '1160', '1223', '1373', '1409', '769', '1063', '1157', '1452', '1453', '1604', '1738', '776', '1025', '1090', '1136', '1283', '1301', '1303', '1540', '1552', '45', '223', '341', '1217', '1241', '1413', '105', '485', '516', '669', '811', '1043', '1073', '1233', '1345', '1426', '1449', '1704', '266', '324', '467', '1019', '1152', '1358', '1632', '448', '503', '639', '701', '885', '888', '905', '1029', '1145', '1218', '1226', '1253', '1411', '1448', '1566', '1682', '795', '859', '988', '1150', '1742', '352', '601', '1322', '1647', '1676', '1740', '74', '417', '610', '731', '738', '1149', '1458', '1026', '1188', '493', '494', '973', '1055', '1231', '1351', '1408', '1489', '1496', '1505', '1580', '666', '954', '1034', '1047', '1049', '1366', '1474', '147', '205', '618', '851', '1229', '1230', '1516', '1609', '1716', '208', '836', '1154', '1362', '1368', '1444', '1470', '423', '663', '709', '920', '927', '1262', '1463', '1619', '204', '921', '931', '996', '1004', '1020', '1222', '1285', '1354', '1407', '1410', '1508', '1627', '1713', '1715', '703', '914', '923', '1196', '1518', '1714', '643', '717', '915', '916', '926', '930', '1003', '1037', '1072', '1106', '1224', '1240', '1521', '1581', '1673', '1743', '422', '924', '1017', '1042', '1138', '1352', '1404', '1486', '1567', '1593', '1596', '1606', '499', '972', '1175', '1187', '1360', '1361', '1459', '1522', '479', '671', '672', '781', '1001', '1051', '1148', '1254', '1412', '1445', '1517', '17', '656', '837', '1054', '1382', '1417', '665', '938', '994', '1002', '1514', '1601', '1708', '1751', '504', '985', '1005', '1045', '1053', '1684', '1723', '420', '453', '574', '761', '821', '982', '995', '1028', '1729', '857', '937')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,1359,977,1291,454,1272,1247,1554,1555,1599,855,986,1237,1594,1588,1067,258,407,1677,34,22,27,37,38,378,461,21,28,31,393,817,1135,780,30,36,349,726,1012,1424,39,1422,35,1419,1423,1420,1415,1418,1421,404,882,1176,462,113,1215,1245,1405,766,24,330,711,11,1574,439,452,9,265,10,455,1607,1744,1141,585,542,739,1572,124,635,674,770,573,3,5,874,792,1454,340,1372,116,580,351,716,1193,338,553,1168,1302,520,797,1284,1460,25,66,1402,1471,160,285,974,1021,332,1095,1455,207,253,4,43,390,748,111,148,658,993,1172,1325,791,1260,1320,1678,81,517,1259,1323,1562,406,1195,582,590,678,286,434,1068,1575,119,327,526,559,970,616,63,108,421,854,78,375,401,657,883,1266,547,1139,1571,1586,84,722,1208,1569,775,1492,150,335,850,1008,1236,1398,1587,114,1308,1437,14,784,152,403,958,1268,1672,151,1064,823,1108,1289,1319,1724,405,451,652,704,715,966,1088,325,348,683,1282,1321,123,162,790,1243,262,389,1013,1143,1159,1269,1330,1348,1389,732,75,163,441,483,1270,1326,1327,1526,1579,508,1151,1214,1557,1561,314,333,768,1367,385,394,626,1318,1376,93,287,290,545,1711,1075,1602,82,98,521,651,796,968,1344,1539,1722,149,673,751,818,884,1027,1040,1137,1144,1163,1216,1343,1717,201,291,743,852,1160,1223,1373,1409,769,1063,1157,1452,1453,1604,1738,776,1025,1090,1136,1283,1301,1303,1540,1552,45,223,341,1217,1241,1413,105,485,516,669,811,1043,1073,1233,1345,1426,1449,1704,266,324,467,1019,1152,1358,1632,448,503,639,701,885,888,905,1029,1145,1218,1226,1253,1411,1448,1566,1682,795,859,988,1150,1742,352,601,1322,1647,1676,1740,74,417,610,731,738,1149,1458,1026,1188,493,494,973,1055,1231,1351,1408,1489,1496,1505,1580,666,954,1034,1047,1049,1366,1474,147,205,618,851,1229,1230,1516,1609,1716,208,836,1154,1362,1368,1444,1470,423,663,709,920,927,1262,1463,1619,204,921,931,996,1004,1020,1222,1285,1354,1407,1410,1508,1627,1713,1715,703,914,923,1196,1518,1714,643,717,915,916,926,930,1003,1037,1072,1106,1224,1240,1521,1581,1673,1743,422,924,1017,1042,1138,1352,1404,1486,1567,1593,1596,1606,499,972,1175,1187,1360,1361,1459,1522,479,671,672,781,1001,1051,1148,1254,1412,1445,1517,17,656,837,1054,1382,1417,665,938,994,1002,1514,1601,1708,1751,504,985,1005,1045,1053,1684,1723,420,453,574,761,821,982,995,1028,1729,857,937') 0.042945861816406
(410) DESCRIBE `cruisetypes` 0.0014069080352783
(411) DESCRIBE `destinations` 0.0016860961914062
(412) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '43', '9', '2', '8', '53', '55', '39', '28', '38', '40', '7', '26', '30', '48', '11', '21', '45', '29', '49', '56', '44', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,43,9,2,8,53,55,39,28,38,40,7,26,30,48,11,21,45,29,49,56,44,34,10,52,46,32') 0.0019497871398926