or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

 
  • Scenic Spirit, Treasures of the Mekong 2019/20 ex Ho Chi Minh to Siem Reap

    Nights 12 Ship Scenic Spirit
    Star Rating River
    Sailing 2019: 15 Dec, 29 Dec 2020: 12 Jan, 26 Jan, 9 Feb, 23 Feb, 8 Mar, 22 Mar, 5 Apr, 19 Apr, 3 May
    Ports of Call

    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.

  • Scenic Amber, Danube Christmas Markets ex Nuremberg to Budapest

    Nights 7 Ship Scenic Amber
    Star Rating River
    Sailing 2019: 16 Dec 2020: 26 Nov, 10 Dec
    Ports of Call

    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.

  • Scenic Spirit, Mekong & Temple Discovery 2019/20 ex Ho Chi Minh to Siem Reap

    Nights 10 Ship Scenic Spirit
    Star Rating River
    Sailing 2019: 17 Dec, 31 Dec 2020: 14 Jan, 28 Jan, 11 Feb, 25 Feb, 10 Mar, 24 Mar, 7 Apr, 21 Apr, 5 May
    Ports of Call

    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.

  • Scenic Crystal, Christmas Wonderland ex Amsterdam to Budapest

    Nights 15 Ship Scenic Crystal
    Star Rating River
    Sailing 2019: 18 Dec
    Ports of Call
    Please enquire about this cruise for pricing.
  • Scenic Spirit, Treasures of the Mekong ex Siem Reap to Ho Chi Minh

    Nights 12 Ship Scenic Spirit
    Star Rating River
    Sailing 2019: 21 Dec 2020: 4 Jan, 18 Jan, 1 Feb, 15 Feb, 28 Mar, 11 Apr, 25 Apr, 18 Jul, 1 Aug, 15 Aug, 29 Aug, 12 Sep, 26 Sep, 10 Oct, 24 Oct, 7 Nov, 21 Nov, 5 Dec, 19 Dec 2021: 2 Jan, 16 Jan, 30 Jan, 13 Feb, 27 Feb, 13 Mar, 27 Mar, 10 Apr, 24 Apr, 8 May
    Ports of Call

    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.

  • Scenic Spirit, Mekong & Temple Discovery 2019/20 ex Siem Reap to Ho Chi Minh

    Nights 10 Ship Scenic Spirit
    Star Rating River
    Sailing 2019: 21 Dec 2020: 4 Jan, 18 Jan, 1 Feb, 15 Feb, 28 Mar, 11 Apr, 25 Apr
    Ports of Call
    Please enquire about this cruise for pricing.
  • Scenic Aura, Luxury Irrawaddy Cruise 2019/20 ex Yangon to Mandalay

    Nights 10 Ship Scenic Aura
    Star Rating River
    Sailing 2019: 23 Dec 2020: 12 Jan, 1 Feb, 21 Feb, 12 Mar
    Ports of Call

    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.

  • Scenic Aura, Luxury Irrawaddy Cruise 2019/20 ex Mandalay to Yangon

    Nights 10 Ship Scenic Aura
    Star Rating River
    Sailing 2020: 2 Jan, 22 Jan, 11 Feb, 2 Mar, 22 Mar
    Ports of Call

    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.

  • Scenic Jewel, Jewels of Europe 2020 ex Amsterdam to Budapest

    Nights 14 Ship Scenic Jewel
    Star Rating River
    Sailing 2020: 30 Mar, 11 May, 8 Jun, 3 Aug, 31 Aug, 19 Oct
    Ports of Call

    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.

  • Scenic Amber, Danube Delta Discovery ex Vienna to Bucharest

    Nights 14 Ship Scenic Amber
    Star Rating River
    Sailing 2020: 1 Apr
    Ports of Call

    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: 202

Total elapsed time: 0.36215114593506

# Query Time
(1) connect 0.0012922286987305
(2) DESCRIBE `cruises` 0.0044410228729248
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (81916, 78495, 81915, 78494, 81917, 81914, 81919, 81918, 81876, 81897)) ORDER BY FIND_IN_SET(id, '81916,78495,81915,78494,81917,81914,81919,81918,81876,81897') 0.0032150745391846
(4) DESCRIBE `cruises` 0.0036239624023438
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81916') 0.00040912628173828
(6) DESCRIBE `ships` 0.003831148147583
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00052309036254883
(8) DESCRIBE `ships` 0.0044019222259521
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00044512748718262
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035881996154785
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(12) DESCRIBE `itineraries` 0.0018160343170166
(13) DESCRIBE `sailingdates` 0.0017929077148438
(14) DESCRIBE `itineraries` 0.0021209716796875
(15) DESCRIBE `itineraries` 0.0017809867858887
(16) DESCRIBE `avid_specials` 0.0018241405487061
(17) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81916 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 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.001147985458374
(18) DESCRIBE `cruiselines` 0.0025019645690918
(19) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0004570484161377
(20) DESCRIBE `orchid_image` 0.0019979476928711
(21) DESCRIBE `cruiselines` 0.0026240348815918
(22) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00037884712219238
(23) DESCRIBE `cruises` 0.0034360885620117
(24) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78495') 0.00046610832214355
(25) DESCRIBE `ships` 0.0035409927368164
(26) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1445))) 0.00049805641174316
(27) DESCRIBE `ships` 0.0045168399810791
(28) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.00046014785766602
(29) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042104721069336
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(31) DESCRIBE `itineraries` 0.0018570423126221
(32) DESCRIBE `sailingdates` 0.0024678707122803
(33) DESCRIBE `itineraries` 0.0024218559265137
(34) DESCRIBE `itineraries` 0.0024199485778809
(35) DESCRIBE `avid_specials` 0.0022330284118652
(36) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78495 and class = 'Cruise') OR (item_id = 1445 AND class = 'Ship') OR (item_id = 156 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.0015060901641846
(37) DESCRIBE `cruiselines` 0.0036358833312988
(38) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00062394142150879
(39) DESCRIBE `orchid_image` 0.0025439262390137
(40) DESCRIBE `cruiselines` 0.0036039352416992
(41) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00051403045654297
(42) DESCRIBE `cruises` 0.0033669471740723
(43) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81915') 0.00038886070251465
(44) DESCRIBE `ships` 0.0035200119018555
(45) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00049304962158203
(46) DESCRIBE `ships` 0.0034310817718506
(47) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00060796737670898
(48) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039815902709961
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(50) DESCRIBE `itineraries` 0.0019052028656006
(51) DESCRIBE `sailingdates` 0.0016059875488281
(52) DESCRIBE `itineraries` 0.0018880367279053
(53) DESCRIBE `itineraries` 0.0017631053924561
(54) DESCRIBE `avid_specials` 0.0016520023345947
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81915 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 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.0011930465698242
(56) DESCRIBE `cruiselines` 0.0027937889099121
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00046300888061523
(58) DESCRIBE `orchid_image` 0.0024120807647705
(59) DESCRIBE `cruiselines` 0.0025320053100586
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00038313865661621
(61) DESCRIBE `cruises` 0.0034029483795166
(62) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78494') 0.00038599967956543
(63) DESCRIBE `ships` 0.0035250186920166
(64) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 982))) 0.00045084953308105
(65) DESCRIBE `ships` 0.0036311149597168
(66) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '982') 0.00037598609924316
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046610832214355
(69) DESCRIBE `itineraries` 0.0017011165618896
(70) DESCRIBE `sailingdates` 0.001600980758667
(71) DESCRIBE `itineraries` 0.0016758441925049
(72) DESCRIBE `itineraries` 0.0016829967498779
(73) DESCRIBE `avid_specials` 0.0016798973083496
(74) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78494 and class = 'Cruise') OR (item_id = 982 AND class = 'Ship') OR (item_id = 156 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.0011560916900635
(75) DESCRIBE `cruiselines` 0.0025169849395752
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0005497932434082
(77) DESCRIBE `orchid_image` 0.002439022064209
(78) DESCRIBE `cruiselines` 0.0026009082794189
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00040602684020996
(80) DESCRIBE `cruises` 0.0035879611968994
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81917') 0.00038504600524902
(82) DESCRIBE `ships` 0.0034809112548828
(83) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00053811073303223
(84) DESCRIBE `ships` 0.0036530494689941
(85) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00044393539428711
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035190582275391
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(88) DESCRIBE `itineraries` 0.0019271373748779
(89) DESCRIBE `sailingdates` 0.0019638538360596
(90) DESCRIBE `itineraries` 0.0019030570983887
(91) DESCRIBE `itineraries` 0.0016920566558838
(92) DESCRIBE `avid_specials` 0.0019180774688721
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81917 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 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.001345157623291
(94) DESCRIBE `cruiselines` 0.0025639533996582
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00040006637573242
(96) DESCRIBE `orchid_image` 0.0021719932556152
(97) DESCRIBE `cruiselines` 0.0034940242767334
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00043106079101562
(99) DESCRIBE `cruises` 0.0034399032592773
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81914') 0.00037908554077148
(101) DESCRIBE `ships` 0.0033750534057617
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.00054097175598145
(103) DESCRIBE `ships` 0.0038058757781982
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00043916702270508
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034785270690918
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043010711669922
(107) DESCRIBE `itineraries` 0.0020558834075928
(108) DESCRIBE `sailingdates` 0.0015869140625
(109) DESCRIBE `itineraries` 0.0020248889923096
(110) DESCRIBE `itineraries` 0.0021750926971436
(111) DESCRIBE `avid_specials` 0.0016300678253174
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81914 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 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.001244068145752
(113) DESCRIBE `cruiselines` 0.0024361610412598
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00045680999755859
(115) DESCRIBE `orchid_image` 0.0020840167999268
(116) DESCRIBE `cruiselines` 0.0025639533996582
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00039100646972656
(118) DESCRIBE `cruises` 0.0035960674285889
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81919') 0.0003960132598877
(120) DESCRIBE `ships` 0.0036871433258057
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1350))) 0.0004889965057373
(122) DESCRIBE `ships` 0.0035519599914551
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1350') 0.00041508674621582
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039410591125488
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(126) DESCRIBE `itineraries` 0.0017330646514893
(127) DESCRIBE `sailingdates` 0.0021710395812988
(128) DESCRIBE `itineraries` 0.0027000904083252
(129) DESCRIBE `itineraries` 0.0026640892028809
(130) DESCRIBE `avid_specials` 0.0016090869903564
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81919 and class = 'Cruise') OR (item_id = 1350 AND class = 'Ship') OR (item_id = 156 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.0011880397796631
(132) DESCRIBE `cruiselines` 0.0026497840881348
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00047588348388672
(134) DESCRIBE `orchid_image` 0.0021138191223145
(135) DESCRIBE `cruiselines` 0.0027041435241699
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00040006637573242
(137) DESCRIBE `cruises` 0.0034551620483398
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81918') 0.00038909912109375
(139) DESCRIBE `ships` 0.0034101009368896
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1350))) 0.00051593780517578
(141) DESCRIBE `ships` 0.0036079883575439
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1350') 0.00045895576477051
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040006637573242
(145) DESCRIBE `itineraries` 0.0021679401397705
(146) DESCRIBE `sailingdates` 0.0016210079193115
(147) DESCRIBE `itineraries` 0.0018742084503174
(148) DESCRIBE `itineraries` 0.002065896987915
(149) DESCRIBE `avid_specials` 0.0017910003662109
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81918 and class = 'Cruise') OR (item_id = 1350 AND class = 'Ship') OR (item_id = 156 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.0013220310211182
(151) DESCRIBE `cruiselines` 0.0025551319122314
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00051498413085938
(153) DESCRIBE `orchid_image` 0.0021491050720215
(154) DESCRIBE `cruiselines` 0.0030679702758789
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00050616264343262
(156) DESCRIBE `cruises` 0.0036032199859619
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81876') 0.00054192543029785
(158) DESCRIBE `ships` 0.0039160251617432
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1155))) 0.00048303604125977
(160) DESCRIBE `ships` 0.0041279792785645
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1155') 0.00059103965759277
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051307678222656
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055289268493652
(164) DESCRIBE `itineraries` 0.0025420188903809
(165) DESCRIBE `sailingdates` 0.0023269653320312
(166) DESCRIBE `itineraries` 0.0026199817657471
(167) DESCRIBE `itineraries` 0.0025980472564697
(168) DESCRIBE `avid_specials` 0.0024211406707764
(169) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81876 and class = 'Cruise') OR (item_id = 1155 AND class = 'Ship') OR (item_id = 156 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.0021829605102539
(170) DESCRIBE `cruiselines` 0.0037810802459717
(171) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00059700012207031
(172) DESCRIBE `orchid_image` 0.0026450157165527
(173) DESCRIBE `cruiselines` 0.0026650428771973
(174) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00043296813964844
(175) DESCRIBE `cruises` 0.0038290023803711
(176) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81897') 0.00052499771118164
(177) DESCRIBE `ships` 0.0037801265716553
(178) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1445))) 0.00054097175598145
(179) DESCRIBE `ships` 0.0036940574645996
(180) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.00047707557678223
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035190582275391
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040888786315918
(183) DESCRIBE `itineraries` 0.002086877822876
(184) DESCRIBE `sailingdates` 0.0017650127410889
(185) DESCRIBE `itineraries` 0.0022621154785156
(186) DESCRIBE `itineraries` 0.002065896987915
(187) DESCRIBE `avid_specials` 0.0017309188842773
(188) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81897 and class = 'Cruise') OR (item_id = 1445 AND class = 'Ship') OR (item_id = 156 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.0011861324310303
(189) DESCRIBE `cruiselines` 0.0028760433197021
(190) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00051188468933105
(191) DESCRIBE `orchid_image` 0.0021960735321045
(192) DESCRIBE `cruiselines` 0.0028049945831299
(193) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00042390823364258
(194) DESCRIBE `ships` 0.0040969848632812
(195) SELECT `ships`.* FROM `ships` WHERE (id IN ('1348', '1350', '1445', '982', '1444', '687', '1297', '1156', '1155', '767', '1295', '1296', '685', '979', '983')) ORDER BY FIND_IN_SET(id, '1348,1350,1445,982,1444,687,1297,1156,1155,767,1295,1296,685,979,983') 0.0026648044586182
(196) DESCRIBE `cruisetypes` 0.0018091201782227
(197) DESCRIBE `destinations` 0.0025169849395752
(198) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '54')) ORDER BY FIND_IN_SET(id, '50,54') 0.00076198577880859
(199) DESCRIBE `cruiselines` 0.0034239292144775
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00051403045654297
(201) DESCRIBE `cruiselines` 0.0030112266540527
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00060486793518066