or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

 
  • Yangzi Explorer, Downstream ex Chongqing to Yichang

    Nights 3 Ship Sanctuary Yangzi Explorer
    Star Rating River Departs Chongqing, China
    Sailing 2018: 15 Nov, 22 Nov 2019: 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr, 2 May, 9 May, 16 May, 23 May, 30 May, 6 Jun, 13 Jun, 20 Jun, 27 Jun, 4 Jul, 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 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
    Ports of Call Chongqing, Fuling, Qutang Gorge, Wu Gorge, Shennong Stream, Xiling Gorge, Yichang
    Please enquire about this cruise for pricing.
  • Imagination, Baja Mexico ex Los Angeles Return

    Nights 3 Ship Carnival Imagination
    Star Rating 4 Star Departs Los Angeles, California, USA
    Sailing 2018: 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec, 20 Dec, 27 Dec 2019: 3 Jan, 10 Jan, 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr More 11 Apr, 18 Apr, 25 Apr, 30 Apr, 2 May, 9 May, 16 May, 23 May, 6 Jun, 13 Jun, 20 Jun, 27 Jun, 4 Jul, 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 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, 5 Dec, 12 Dec, 19 Dec, 26 Dec 2020: 2 Jan, 9 Jan, 16 Jan, 23 Jan, 30 Jan, 6 Feb, 13 Feb, 20 Feb, 27 Feb, 5 Mar, 12 Mar, 19 Mar, 26 Mar, 2 Apr, 9 Apr, 16 Apr, 23 Apr Less
    Ports of Call Los Angeles, Ensenada
    Please enquire about this cruise for pricing.
  • Liberty, Bahamas Cruise ex Port Canaveral Return

    Nights 3 Ship Carnival Liberty
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2018: 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec, 20 Dec, 27 Dec 2019: 3 Jan, 10 Jan, 17 Jan, 24 Jan, 31 Jan, 7 Feb, 14 Feb, 21 Feb, 28 Feb, 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr
    Ports of Call Port Canaveral, Nassau
    Please enquire about this cruise for pricing.
  • Victoria Selina, 3 Gorges Highlights, ex Chongqing to Yichang

    Nights 3 Ship Victoria Selina
    Star Rating River Departs Chongqing, China
    Sailing 2018: 15 Nov, 22 Nov, 29 Nov, 6 Dec, 13 Dec, 20 Dec, 27 Dec 2019: 7 Mar, 14 Mar, 21 Mar, 28 Mar, 4 Apr, 11 Apr, 18 Apr, 25 Apr, 2 May, 9 May, 16 May, 23 May, 30 May, 6 Jun More 13 Jun, 20 Jun, 27 Jun, 4 Jul, 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 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 Less
    Ports of Call Chongqing, Shibaozhai, Wu Gorge, Qutang Gorge, Sandouping - Three Gorges Dam, Yichang
    Please enquire about this cruise for pricing.
  • A-Rosa Riva, Danube Mini Cruise Wachau ex Engelhartszell Roundtrip

    Nights 3 Ship A-Rosa Riva
    Star Rating River Departs Engelhartszell, Austria
    Sailing 2018: 15 Nov, 20 Dec
    Ports of Call Engelhartszell, Vienna, Krems, Melk
    Please enquire about this cruise for pricing.
  • Mediterranea, Italy, Spain, France ex Savona Return

    Nights 3 Ship Costa Mediterranea
    Star Rating 4 Star Departs Savona, Italy
    Sailing 2018: 15 Nov
    Ports of Call Savona, Barcelona, Marseilles
    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: 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 More 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: 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 More 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.
  • Belmond Road to Mandalay, Taste of Myanmar ex Mandalay to Bagan

    Nights 2 Ship Belmond Road to Mandalay
    Star Rating River Departs Mandalay, Myanmar
    Sailing 2018: 15 Nov, 22 Nov, 13 Dec, 20 Dec, 27 Dec
    Ports of Call Mandalay, Ava, Bagan
    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: 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 More 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, 1 May, 2 May, 3 May, 4 May, 5 May, 6 May, 7 May, 8 May, 9 May, 16 Jun, 17 Jun, 18 Jun, 19 Jun, 20 Jun, 21 Jun, 22 Jun, 23 Jun, 24 Jun, 25 Jun, 26 Jun, 27 Jun, 28 Jun, 29 Jun, 30 Jun, 1 Jul, 2 Jul, 3 Jul, 4 Jul, 5 Jul, 6 Jul, 7 Jul, 8 Jul, 9 Jul, 10 Jul, 11 Jul, 12 Jul, 13 Jul, 14 Jul, 15 Jul, 16 Jul, 17 Jul, 18 Jul, 19 Jul, 20 Jul, 21 Jul, 22 Jul, 23 Jul, 24 Jul, 25 Jul, 26 Jul, 27 Jul, 28 Jul, 29 Jul, 30 Jul, 31 Jul, 1 Aug, 2 Aug, 3 Aug, 4 Aug, 5 Aug, 6 Aug, 7 Aug, 8 Aug, 9 Aug, 10 Aug, 11 Aug, 12 Aug, 13 Aug, 14 Aug, 15 Aug, 16 Aug, 17 Aug, 18 Aug, 19 Aug, 20 Aug, 21 Aug, 22 Aug, 23 Aug, 24 Aug, 25 Aug, 26 Aug, 27 Aug, 28 Aug, 29 Aug, 30 Aug, 31 Aug, 1 Sep, 2 Sep, 3 Sep, 4 Sep, 5 Sep, 6 Sep, 7 Sep, 8 Sep, 9 Sep, 10 Sep, 11 Sep, 12 Sep, 13 Sep, 14 Sep, 15 Sep, 16 Sep, 17 Sep, 18 Sep, 19 Sep, 20 Sep, 21 Sep, 22 Sep, 23 Sep, 24 Sep, 25 Sep, 26 Sep, 27 Sep, 28 Sep, 29 Sep, 30 Sep, 1 Oct, 2 Oct, 3 Oct, 4 Oct, 5 Oct, 6 Oct, 7 Oct, 8 Oct, 9 Oct, 10 Oct, 11 Oct, 12 Oct, 13 Oct, 14 Oct, 15 Oct, 16 Oct, 17 Oct, 18 Oct, 19 Oct, 20 Oct, 21 Oct, 22 Oct, 23 Oct, 24 Oct, 25 Oct, 26 Oct, 27 Oct, 28 Oct, 29 Oct, 30 Oct, 31 Oct, 1 Nov, 2 Nov, 3 Nov, 4 Nov, 5 Nov, 6 Nov, 7 Nov, 8 Nov, 9 Nov, 10 Nov, 11 Nov, 12 Nov, 13 Nov, 14 Nov, 15 Nov, 16 Nov, 17 Nov, 18 Nov, 19 Nov, 20 Nov, 21 Nov, 22 Nov, 23 Nov, 24 Nov, 25 Nov, 26 Nov, 27 Nov, 28 Nov, 29 Nov, 30 Nov, 1 Dec, 2 Dec, 3 Dec, 4 Dec, 5 Dec, 6 Dec, 7 Dec, 8 Dec, 9 Dec, 10 Dec, 11 Dec, 12 Dec, 13 Dec, 14 Dec, 15 Dec, 16 Dec, 17 Dec, 18 Dec, 19 Dec, 20 Dec, 21 Dec, 22 Dec, 23 Dec, 24 Dec, 25 Dec, 26 Dec, 27 Dec, 28 Dec, 29 Dec, 30 Dec, 31 Dec Less
    Ports of Call Halong Bay

    Select a sailing date for approximate pricing.

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

 

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

Database Profiling Report

Total queries executed: 404

Total elapsed time: 0.61059641838074

# Query Time
(1) connect 0.00079607963562012
(2) DESCRIBE `cruises` 0.0030457973480225
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (23656, 52647, 56886, 59436, 66301, 70775, 44276, 49176, 54263, 65919)) ORDER BY FIND_IN_SET(id, '23656,52647,56886,59436,66301,70775,44276,49176,54263,65919') 0.002424955368042
(4) DESCRIBE `cruises` 0.0029809474945068
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '23656') 0.00037193298339844
(6) DESCRIBE `ships` 0.0029630661010742
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 749))) 0.0003809928894043
(8) DESCRIBE `ships` 0.0026071071624756
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '749') 0.00029087066650391
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027990341186523
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032997131347656
(12) DESCRIBE `itineraries` 0.0013329982757568
(13) DESCRIBE `ports` 0.0014572143554688
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00035214424133301
(15) DESCRIBE `ports` 0.0016281604766846
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00032305717468262
(17) DESCRIBE `ports` 0.0012669563293457
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00036287307739258
(19) DESCRIBE `sailingdates` 0.001478910446167
(20) DESCRIBE `ports` 0.001615047454834
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00014305114746094
(22) DESCRIBE `ports` 0.001413106918335
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00030303001403809
(24) DESCRIBE `ports` 0.0015020370483398
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2205))) 0.00026702880859375
(26) DESCRIBE `ports` 0.0013241767883301
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2205') 0.00038599967956543
(28) DESCRIBE `ports` 0.0014498233795166
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0003361701965332
(30) DESCRIBE `ports` 0.0014879703521729
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00017404556274414
(32) DESCRIBE `ports` 0.0015568733215332
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00046181678771973
(34) DESCRIBE `ports` 0.0018768310546875
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00076794624328613
(36) DESCRIBE `ports` 0.0016589164733887
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3100))) 0.0004270076751709
(38) DESCRIBE `ports` 0.0015208721160889
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3100') 0.00037693977355957
(40) DESCRIBE `ports` 0.0016520023345947
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00043988227844238
(42) DESCRIBE `ports` 0.0017290115356445
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00040507316589355
(44) DESCRIBE `ports` 0.0017218589782715
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00056099891662598
(46) DESCRIBE `ports` 0.0017359256744385
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00045204162597656
(48) DESCRIBE `avid_specials` 0.0016989707946777
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 23656 and class = 'Cruise') OR (item_id = 749 AND class = 'Ship') OR (item_id = 174 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.003026008605957
(50) DESCRIBE `cruiselines` 0.0022599697113037
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00087118148803711
(52) DESCRIBE `orchid_image` 0.0020241737365723
(53) DESCRIBE `cruiselines` 0.0028040409088135
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00046586990356445
(55) DESCRIBE `cruises` 0.0045359134674072
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52647') 0.00042915344238281
(57) DESCRIBE `ships` 0.0033199787139893
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 21))) 0.00055694580078125
(59) DESCRIBE `ships` 0.0038001537322998
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '21') 0.00054407119750977
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(63) DESCRIBE `itineraries` 0.001971960067749
(64) DESCRIBE `ports` 0.001917839050293
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041913986206055
(66) DESCRIBE `ports` 0.0015599727630615
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034093856811523
(68) DESCRIBE `ports` 0.0016381740570068
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037717819213867
(70) DESCRIBE `sailingdates` 0.001366138458252
(71) DESCRIBE `ports` 0.002208948135376
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00048398971557617
(73) DESCRIBE `ports` 0.0018420219421387
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039792060852051
(75) DESCRIBE `ports` 0.0017890930175781
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00041413307189941
(77) DESCRIBE `ports` 0.0016341209411621
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.0003819465637207
(79) DESCRIBE `ports` 0.0017158985137939
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00040388107299805
(81) DESCRIBE `ports` 0.0015630722045898
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034594535827637
(83) DESCRIBE `avid_specials` 0.0014770030975342
(84) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52647 and class = 'Cruise') OR (item_id = 21 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0018830299377441
(85) DESCRIBE `cruiselines` 0.0025670528411865
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00050711631774902
(87) DESCRIBE `orchid_image` 0.0019121170043945
(88) DESCRIBE `cruiselines` 0.0024099349975586
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040221214294434
(90) DESCRIBE `cruises` 0.0034008026123047
(91) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56886') 0.00042080879211426
(92) DESCRIBE `ships` 0.0035078525543213
(93) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 461))) 0.00067806243896484
(94) DESCRIBE `ships` 0.0035479068756104
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '461') 0.00048112869262695
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030684471130371
(98) DESCRIBE `itineraries` 0.0018179416656494
(99) DESCRIBE `ports` 0.0018379688262939
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043511390686035
(101) DESCRIBE `ports` 0.0017158985137939
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00040197372436523
(103) DESCRIBE `ports` 0.0018270015716553
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00036811828613281
(105) DESCRIBE `sailingdates` 0.0014410018920898
(106) DESCRIBE `ports` 0.0020170211791992
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042891502380371
(108) DESCRIBE `ports` 0.0016369819641113
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040411949157715
(110) DESCRIBE `ports` 0.0016770362854004
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039911270141602
(112) DESCRIBE `ports` 0.0017120838165283
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00036406517028809
(114) DESCRIBE `ports` 0.0017111301422119
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00046014785766602
(116) DESCRIBE `ports` 0.0018301010131836
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00035905838012695
(118) DESCRIBE `avid_specials` 0.0014338493347168
(119) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56886 and class = 'Cruise') OR (item_id = 461 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019078254699707
(120) DESCRIBE `cruiselines` 0.0027530193328857
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00053000450134277
(122) DESCRIBE `orchid_image` 0.0020208358764648
(123) DESCRIBE `cruiselines` 0.0024900436401367
(124) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040721893310547
(125) DESCRIBE `cruises` 0.0033869743347168
(126) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59436') 0.00039410591125488
(127) DESCRIBE `ships` 0.003338098526001
(128) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1424))) 0.00059390068054199
(129) DESCRIBE `ships` 0.0034291744232178
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1424') 0.00047087669372559
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032401084899902
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030803680419922
(133) DESCRIBE `itineraries` 0.0016739368438721
(134) DESCRIBE `ports` 0.0017011165618896
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00044107437133789
(136) DESCRIBE `ports` 0.0016310214996338
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0003960132598877
(138) DESCRIBE `ports` 0.0016269683837891
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00040888786315918
(140) DESCRIBE `sailingdates` 0.001622200012207
(141) DESCRIBE `ports` 0.0021531581878662
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00050210952758789
(143) DESCRIBE `ports` 0.0017290115356445
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00040912628173828
(145) DESCRIBE `ports` 0.0017480850219727
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00041508674621582
(147) DESCRIBE `ports` 0.00177001953125
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00041294097900391
(149) DESCRIBE `ports` 0.0016889572143555
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00055599212646484
(151) DESCRIBE `ports` 0.0019600391387939
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00061202049255371
(153) DESCRIBE `ports` 0.0014469623565674
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00041103363037109
(155) DESCRIBE `ports` 0.0017998218536377
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00038695335388184
(157) DESCRIBE `ports` 0.0017650127410889
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.0004122257232666
(159) DESCRIBE `ports` 0.0017499923706055
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00043606758117676
(161) DESCRIBE `ports` 0.0017919540405273
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00052618980407715
(163) DESCRIBE `ports` 0.0018978118896484
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00049209594726562
(165) DESCRIBE `avid_specials` 0.0016138553619385
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59436 and class = 'Cruise') OR (item_id = 1424 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.0020570755004883
(167) DESCRIBE `cruiselines` 0.0027098655700684
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00057101249694824
(169) DESCRIBE `orchid_image` 0.0021121501922607
(170) DESCRIBE `cruiselines` 0.0025050640106201
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00046086311340332
(172) DESCRIBE `cruises` 0.0034949779510498
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66301') 0.00043916702270508
(174) DESCRIBE `ships` 0.0036640167236328
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1557))) 0.00057005882263184
(176) DESCRIBE `ships` 0.0034899711608887
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1557') 0.0006411075592041
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029397010803223
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030088424682617
(180) DESCRIBE `itineraries` 0.0019600391387939
(181) DESCRIBE `ports` 0.0018999576568604
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00045204162597656
(183) DESCRIBE `ports` 0.0016851425170898
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00045394897460938
(185) DESCRIBE `ports` 0.0017750263214111
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00039482116699219
(187) DESCRIBE `sailingdates` 0.0014548301696777
(188) DESCRIBE `ports` 0.001478910446167
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00036501884460449
(190) DESCRIBE `ports` 0.0013270378112793
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00033998489379883
(192) DESCRIBE `ports` 0.0016741752624512
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00045180320739746
(194) DESCRIBE `ports` 0.0021789073944092
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00030994415283203
(196) DESCRIBE `ports` 0.0013899803161621
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00039100646972656
(198) DESCRIBE `ports` 0.0013580322265625
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00030684471130371
(200) DESCRIBE `ports` 0.0014610290527344
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00040388107299805
(202) DESCRIBE `ports` 0.0018649101257324
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00032591819763184
(204) DESCRIBE `ports` 0.0015981197357178
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.00036478042602539
(206) DESCRIBE `ports` 0.0016779899597168
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.0003349781036377
(208) DESCRIBE `avid_specials` 0.0014569759368896
(209) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66301 and class = 'Cruise') OR (item_id = 1557 AND class = 'Ship') OR (item_id = 239 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.0017130374908447
(210) DESCRIBE `cruiselines` 0.0025849342346191
(211) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00060701370239258
(212) DESCRIBE `orchid_image` 0.001986026763916
(213) DESCRIBE `cruiselines` 0.0022048950195312
(214) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00046300888061523
(215) DESCRIBE `cruises` 0.0032579898834229
(216) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70775') 0.00050592422485352
(217) DESCRIBE `ships` 0.0036048889160156
(218) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 351))) 0.00056815147399902
(219) DESCRIBE `ships` 0.0037341117858887
(220) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '351') 0.00047707557678223
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(223) DESCRIBE `itineraries` 0.0020120143890381
(224) DESCRIBE `ports` 0.0026590824127197
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00060796737670898
(226) DESCRIBE `ports` 0.0022428035736084
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00046396255493164
(228) DESCRIBE `ports` 0.0018739700317383
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00036787986755371
(230) DESCRIBE `sailingdates` 0.0015199184417725
(231) DESCRIBE `ports` 0.0019259452819824
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00038909912109375
(233) DESCRIBE `ports` 0.0017521381378174
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00042200088500977
(235) DESCRIBE `ports` 0.0017778873443604
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004270076751709
(237) DESCRIBE `ports` 0.0016951560974121
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040411949157715
(239) DESCRIBE `ports` 0.0015759468078613
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00055193901062012
(241) DESCRIBE `ports` 0.001784086227417
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00038695335388184
(243) DESCRIBE `ports` 0.0017290115356445
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00052595138549805
(245) DESCRIBE `ports` 0.0017848014831543
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00040888786315918
(247) DESCRIBE `avid_specials` 0.0014050006866455
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70775 and class = 'Cruise') OR (item_id = 351 AND class = 'Ship') OR (item_id = 12 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.0012798309326172
(249) DESCRIBE `cruiselines` 0.0025999546051025
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00050687789916992
(251) DESCRIBE `orchid_image` 0.002065896987915
(252) DESCRIBE `cruiselines` 0.0021669864654541
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00040888786315918
(254) DESCRIBE `cruises` 0.0028769969940186
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44276') 0.00034213066101074
(256) DESCRIBE `ships` 0.0030190944671631
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1127))) 0.0004580020904541
(258) DESCRIBE `ships` 0.0030910968780518
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1127') 0.00046920776367188
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032210350036621
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(262) DESCRIBE `itineraries` 0.0019030570983887
(263) DESCRIBE `ports` 0.0017430782318115
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00062704086303711
(265) DESCRIBE `ports` 0.0017600059509277
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049495697021484
(267) DESCRIBE `ports` 0.0016820430755615
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033807754516602
(269) DESCRIBE `sailingdates` 0.0014398097991943
(270) DESCRIBE `ports` 0.001906156539917
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040197372436523
(272) DESCRIBE `ports` 0.0013418197631836
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00038886070251465
(274) DESCRIBE `ports` 0.0014150142669678
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00036787986755371
(276) DESCRIBE `ports` 0.0013270378112793
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00031805038452148
(278) DESCRIBE `ports` 0.0012719631195068
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00035285949707031
(280) DESCRIBE `ports` 0.0013339519500732
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00030517578125
(282) DESCRIBE `avid_specials` 0.0011861324310303
(283) 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.0011401176452637
(284) DESCRIBE `cruiselines` 0.0019550323486328
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 221))) 0.00047516822814941
(286) DESCRIBE `orchid_image` 0.0015430450439453
(287) DESCRIBE `cruiselines` 0.0021841526031494
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '221') 0.00038599967956543
(289) DESCRIBE `cruises` 0.0035650730133057
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49176') 0.00040292739868164
(291) DESCRIBE `ships` 0.003446102142334
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1247))) 0.00065493583679199
(293) DESCRIBE `ships` 0.0039811134338379
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1247') 0.00060105323791504
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036287307739258
(297) DESCRIBE `itineraries` 0.002316951751709
(298) DESCRIBE `ports` 0.0016698837280273
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00037407875061035
(300) DESCRIBE `ports` 0.0014011859893799
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00030803680419922
(302) DESCRIBE `ports` 0.0015621185302734
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033807754516602
(304) DESCRIBE `sailingdates` 0.0015120506286621
(305) DESCRIBE `ports` 0.0017209053039551
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047993659973145
(307) DESCRIBE `ports` 0.0014970302581787
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00034785270690918
(309) DESCRIBE `ports` 0.0018880367279053
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038504600524902
(311) DESCRIBE `ports` 0.0014090538024902
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00033998489379883
(313) DESCRIBE `ports` 0.0015327930450439
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003349781036377
(315) DESCRIBE `ports` 0.0013411045074463
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00026988983154297
(317) DESCRIBE `avid_specials` 0.001176118850708
(318) 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.0012660026550293
(319) DESCRIBE `cruiselines` 0.0023019313812256
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 232))) 0.00044488906860352
(321) DESCRIBE `orchid_image` 0.0016388893127441
(322) DESCRIBE `cruiselines` 0.001971960067749
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '232') 0.00034403800964355
(324) DESCRIBE `cruises` 0.0026760101318359
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54263') 0.00031590461730957
(326) DESCRIBE `ships` 0.0029189586639404
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 503))) 0.00054502487182617
(328) DESCRIBE `ships` 0.0027341842651367
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.0004279613494873
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031089782714844
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025081634521484
(332) DESCRIBE `itineraries` 0.001345157623291
(333) DESCRIBE `ports` 0.0014979839324951
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00042295455932617
(335) DESCRIBE `ports` 0.0013730525970459
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00040602684020996
(337) DESCRIBE `ports` 0.0014090538024902
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00047993659973145
(339) DESCRIBE `sailingdates` 0.0014431476593018
(340) DESCRIBE `ports` 0.0019598007202148
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00054287910461426
(342) DESCRIBE `ports` 0.0025179386138916
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00070309638977051
(344) DESCRIBE `ports` 0.001945972442627
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3164))) 0.00094294548034668
(346) DESCRIBE `ports` 0.0025210380554199
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3164') 0.00057506561279297
(348) DESCRIBE `ports` 0.0024690628051758
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00058102607727051
(350) DESCRIBE `ports` 0.0020749568939209
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00057411193847656
(352) DESCRIBE `ports` 0.0019590854644775
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00058817863464355
(354) DESCRIBE `ports` 0.0020298957824707
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00057005882263184
(356) DESCRIBE `avid_specials` 0.0018129348754883
(357) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54263 and class = 'Cruise') OR (item_id = 503 AND class = 'Ship') OR (item_id = 115 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.0017421245574951
(358) DESCRIBE `cruiselines` 0.003140926361084
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00077009201049805
(360) DESCRIBE `orchid_image` 0.0021481513977051
(361) DESCRIBE `cruiselines` 0.002586841583252
(362) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.00046992301940918
(363) DESCRIBE `cruises` 0.0037429332733154
(364) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.0083849430084229
(365) DESCRIBE `ships` 0.004331111907959
(366) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00063490867614746
(367) DESCRIBE `ships` 0.011787891387939
(368) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00058913230895996
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034689903259277
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035381317138672
(371) DESCRIBE `itineraries` 0.0019800662994385
(372) DESCRIBE `ports` 0.0020740032196045
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00045895576477051
(374) DESCRIBE `ports` 0.0019631385803223
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00048398971557617
(376) DESCRIBE `ports` 0.001939058303833
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00049686431884766
(378) DESCRIBE `sailingdates` 0.0021450519561768
(379) DESCRIBE `ports` 0.0022327899932861
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00040102005004883
(381) DESCRIBE `ports` 0.0018877983093262
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00044989585876465
(383) DESCRIBE `ports` 0.0024831295013428
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0011539459228516
(385) DESCRIBE `ports` 0.0021400451660156
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00042891502380371
(387) DESCRIBE `ports` 0.0019059181213379
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046396255493164
(389) DESCRIBE `ports` 0.0021278858184814
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00047707557678223
(391) DESCRIBE `avid_specials` 0.0020360946655273
(392) 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.0021071434020996
(393) DESCRIBE `cruiselines` 0.0029618740081787
(394) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00052213668823242
(395) DESCRIBE `orchid_image` 0.0023789405822754
(396) DESCRIBE `cruiselines` 0.002795934677124
(397) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00050806999206543
(398) DESCRIBE `cruiselines` 0.0024869441986084
(399) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '7', '23', '12', '20', '171', '18', '144', '8', '31', '101', '131', '50', '96', '239', '29', '103', '15', '191', '91', '120', '206', '37', '16', '262', '24', '33', '114', '28', '14', '174', '268', '221', '110', '156', '208', '141', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '4', '212', '36', '225', '238', '264', '232', '184', '140', '249', '159', '90', '113', '230', '182', '47', '213', '136', '276', '237', '57', '188', '261', '64', '180', '35', '73', '248', '95', '52', '209', '195', '231', '146', '256', '219', '59', '116', '82', '115', '168', '196', '119', '134', '244', '105', '170', '229', '204', '240', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,7,23,12,20,171,18,144,8,31,101,131,50,96,239,29,103,15,191,91,120,206,37,16,262,24,33,114,28,14,174,268,221,110,156,208,141,187,153,118,49,151,211,30,258,216,181,88,4,212,36,225,238,264,232,184,140,249,159,90,113,230,182,47,213,136,276,237,57,188,261,64,180,35,73,248,95,52,209,195,231,146,256,219,59,116,82,115,168,196,119,134,244,105,170,229,204,240,48,224') 0.0071899890899658
(400) DESCRIBE `ships` 0.0031790733337402
(401) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '1291', '977', '258', '1199', '1359', '1599', '454', '1272', '404', '780', '855', '1135', '986', '1677', '1067', '1237', '1594', '265', '837', '34', '37', '38', '1607', '21', '22', '27', '378', '461', '1376', '407', '1588', '28', '31', '770', '393', '817', '542', '30', '36', '1012', '39', '1245', '349', '573', '1424', '1552', '35', '1402', '726', '792', '585', '1415', '330', '462', '1422', '66', '113', '882', '1284', '332', '1176', '1744', '1760', '1419', '1423', '1420', '1574', '24', '11', '711', '1405', '1418', '1421', '9', '439', '1215', '455', '10', '434', '766', '1141', '1193', '78', '452', '739', '81', '69', '1572', '1454', '635', '1247', '1372', '3', '1008', '1095', '1682', '674', '124', '1373', '338', '1168', '5', '340', '580', '116', '1319', '43', '335', '553', '850', '1021', '1569', '70', '1302', '1678', '285', '148', '1172', '25', '111', '451', '658', '874', '4', '160', '716', '944', '1260', '253', '348', '390', '1259', '386', '405', '748', '966', '385', '626', '1562', '616', '651', '791', '1108', '1320', '314', '784', '1088', '1323', '1330', '389', '406', '768', '1325', '63', '286', '683', '1645', '508', '582', '590', '749', '970', '1455', '1672', '207', '287', '327', '375', '483', '678', '1587', '119', '526', '1195', '84', '520', '1460', '1575', '108', '559', '722', '854', '1068', '1208', '163', '401', '1398', '394', '657', '1492', '1571', '1586', '1742', '150', '485', '652', '775', '1236', '1266', '1268', '403', '704', '776', '147', '421', '1269', '114', '151', '152', '547', '993', '1064', '1289', '1308', '105', '123', '149', '223', '517', '1321', '325', '262', '715', '883', '954', '958', '1270', '351', '1471', '1711', '45', '1243', '1282', '1389', '1724', '75', '790', '1139', '1143', '1486', '1557', '1601', '1722', '545', '717', '1561', '1717', '441', '1013', '1159', '1526', '1579', '162', '290', '885', '1075', '1151', '1214', '1738', '291', '324', '333', '673', '823', '1326', '1327', '1367', '1437', '1539', '93', '796', '968', '1301', '1303', '98', '205', '516', '1040', '1216', '1318', '1348', '1704', '82', '818', '1540', '1602', '212', '701', '743', '1063', '1218', '1344', '732', '769', '852', '988', '1043', '1137', '1144', '1217', '1343', '1566', '201', '341', '751', '884', '1160', '1409', '1676', '1740', '574', '1163', '1452', '1453', '1604', '14', '266', '795', '1025', '1090', '1136', '1283', '448', '639', '669', '738', '811', '1157', '1241', '1253', '1426', '1449', '1721', '601', '1019', '1223', '1226', '1632', '1766', '467', '905', '1027', '1029', '1152', '1229', '1358', '1411', '1413', '1474', '1716', '997', '1073', '1448', '494', '1150', '1188', '1233', '1345', '1619', '74', '1055', '1322', '1351', '1408', '1647', '1663', '1673', '1713', '1715', '417', '709', '836', '996', '1026', '1047', '1145', '1410', '1458', '1496', '1714', '610', '618', '643', '1580', '1743', '208', '423', '453', '521', '888', '973', '1034', '1149', '1231', '1366', '1404', '1489', '1505', '1609', '666', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1516', '352', '920', '921', '927', '931', '1004', '1017', '1042', '1140', '1154', '1230', '1354', '1444', '1508', '1606', '1627', '1649', '493', '499', '663', '914', '923', '1106', '1517', '1518', '1567', '703', '915', '916', '926', '930', '1003', '1072', '1138', '1262', '1708', '1751', '479', '665', '781', '924', '972', '1001', '1020', '1052', '1175', '1352', '1412', '1463', '1521', '1522', '1593', '1596', '1723', '422', '671', '938', '1005', '1045', '1053', '1054', '1091', '1092', '1254', '1285', '1729', '937', '1051', '1445', '1650', '1681', '1684', '672', '1514', '1679', '1697', '504')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,1291,977,258,1199,1359,1599,454,1272,404,780,855,1135,986,1677,1067,1237,1594,265,837,34,37,38,1607,21,22,27,378,461,1376,407,1588,28,31,770,393,817,542,30,36,1012,39,1245,349,573,1424,1552,35,1402,726,792,585,1415,330,462,1422,66,113,882,1284,332,1176,1744,1760,1419,1423,1420,1574,24,11,711,1405,1418,1421,9,439,1215,455,10,434,766,1141,1193,78,452,739,81,69,1572,1454,635,1247,1372,3,1008,1095,1682,674,124,1373,338,1168,5,340,580,116,1319,43,335,553,850,1021,1569,70,1302,1678,285,148,1172,25,111,451,658,874,4,160,716,944,1260,253,348,390,1259,386,405,748,966,385,626,1562,616,651,791,1108,1320,314,784,1088,1323,1330,389,406,768,1325,63,286,683,1645,508,582,590,749,970,1455,1672,207,287,327,375,483,678,1587,119,526,1195,84,520,1460,1575,108,559,722,854,1068,1208,163,401,1398,394,657,1492,1571,1586,1742,150,485,652,775,1236,1266,1268,403,704,776,147,421,1269,114,151,152,547,993,1064,1289,1308,105,123,149,223,517,1321,325,262,715,883,954,958,1270,351,1471,1711,45,1243,1282,1389,1724,75,790,1139,1143,1486,1557,1601,1722,545,717,1561,1717,441,1013,1159,1526,1579,162,290,885,1075,1151,1214,1738,291,324,333,673,823,1326,1327,1367,1437,1539,93,796,968,1301,1303,98,205,516,1040,1216,1318,1348,1704,82,818,1540,1602,212,701,743,1063,1218,1344,732,769,852,988,1043,1137,1144,1217,1343,1566,201,341,751,884,1160,1409,1676,1740,574,1163,1452,1453,1604,14,266,795,1025,1090,1136,1283,448,639,669,738,811,1157,1241,1253,1426,1449,1721,601,1019,1223,1226,1632,1766,467,905,1027,1029,1152,1229,1358,1411,1413,1474,1716,997,1073,1448,494,1150,1188,1233,1345,1619,74,1055,1322,1351,1408,1647,1663,1673,1713,1715,417,709,836,996,1026,1047,1145,1410,1458,1496,1714,610,618,643,1580,1743,208,423,453,521,888,973,1034,1149,1231,1366,1404,1489,1505,1609,666,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1516,352,920,921,927,931,1004,1017,1042,1140,1154,1230,1354,1444,1508,1606,1627,1649,493,499,663,914,923,1106,1517,1518,1567,703,915,916,926,930,1003,1072,1138,1262,1708,1751,479,665,781,924,972,1001,1020,1052,1175,1352,1412,1463,1521,1522,1593,1596,1723,422,671,938,1005,1045,1053,1054,1091,1092,1254,1285,1729,937,1051,1445,1650,1681,1684,672,1514,1679,1697,504') 0.055807113647461
(402) DESCRIBE `cruisetypes` 0.0016109943389893
(403) DESCRIBE `destinations` 0.0019299983978271
(404) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '26', '38', '40', '7', '30', '48', '21', '11', '49', '29', '45', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,55,28,26,38,40,7,30,48,21,11,49,29,45,44,56,10,34,52,32,46') 0.0020320415496826