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

Le Lyrial

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

Total elapsed time: 0.23887610435486

# Query Time
(1) connect 0.0011720657348633
(2) DESCRIBE `specials` 0.0087540149688721
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '21-night-antarctica-to-africa-luxury-cruise-from-ushuaia-to-capetown') AND (orchid_available = 1) LIMIT 1 0.0020911693572998
(4) DESCRIBE `cruises` 0.005479097366333
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75713))) 0.0012350082397461
(6) DESCRIBE `avid_specials` 0.0027689933776855
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1613320 and class = 'Special') OR (item_id = 75713 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 38 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.0023760795593262
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1613320') 0.0012509822845459
(9) DESCRIBE `ships` 0.0068609714508057
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00086593627929688
(11) DESCRIBE `ships` 0.0070362091064453
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00059795379638672
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005190372467041
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046300888061523
(15) DESCRIBE `itineraries` 0.020726919174194
(16) DESCRIBE `ports` 0.0090160369873047
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00066399574279785
(18) DESCRIBE `ports` 0.0030348300933838
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00065803527832031
(20) DESCRIBE `ports` 0.0032918453216553
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0014309883117676
(22) DESCRIBE `specialsailingdates` 0.0023608207702637
(23) DESCRIBE `sailingdates` 0.0024230480194092
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 476915))) 0.00076198577880859
(25) DESCRIBE `ports` 0.0027680397033691
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00058388710021973
(27) DESCRIBE `ports` 0.0028321743011475
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00057601928710938
(29) DESCRIBE `ports` 0.0023348331451416
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00059795379638672
(31) DESCRIBE `ports` 0.0023229122161865
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00047993659973145
(33) DESCRIBE `ports` 0.0022411346435547
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5458))) 0.00089907646179199
(35) DESCRIBE `ports` 0.0025088787078857
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5458') 0.00069689750671387
(37) DESCRIBE `ports` 0.0027451515197754
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3134))) 0.00057697296142578
(39) DESCRIBE `ports` 0.0026280879974365
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3134') 0.0004270076751709
(41) DESCRIBE `ports` 0.0018339157104492
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00048303604125977
(43) DESCRIBE `ports` 0.0020778179168701
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0004889965057373
(45) DESCRIBE `ports` 0.0018899440765381
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00055193901062012
(47) DESCRIBE `ports` 0.0024089813232422
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00057101249694824
(49) DESCRIBE `ports` 0.0024979114532471
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00054597854614258
(51) DESCRIBE `ports` 0.002396821975708
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00050711631774902
(53) DESCRIBE `ports` 0.0027248859405518
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2039))) 0.00044012069702148
(55) DESCRIBE `ports` 0.0019569396972656
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2039') 0.00041294097900391
(57) DESCRIBE `ports` 0.002647876739502
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3818))) 0.00067305564880371
(59) DESCRIBE `ports` 0.0027480125427246
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3818') 0.00045680999755859
(61) DESCRIBE `ports` 0.0020809173583984
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2896))) 0.00055193901062012
(63) DESCRIBE `ports` 0.0021731853485107
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2896') 0.00050806999206543
(65) DESCRIBE `ports` 0.0026271343231201
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00050210952758789
(67) DESCRIBE `ports` 0.0021920204162598
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00040912628173828
(69) DESCRIBE `ports` 0.002065896987915
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00063109397888184
(71) DESCRIBE `ports` 0.0028131008148193
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00058293342590332
(73) DESCRIBE `specialsmultipricing` 0.0028419494628906
(74) DESCRIBE `leadpricing` 0.0020649433135986
(75) DESCRIBE `specialspricing` 0.0025269985198975
(76) DESCRIBE `cabins` 0.002471923828125
(77) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 13984))) 0.0007631778717041
(78) DESCRIBE `currencies` 0.0022220611572266
(79) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00055789947509766
(80) DESCRIBE `cruiselines` 0.0044448375701904
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00085806846618652
(82) DESCRIBE `orchid_image` 0.0033190250396729
(83) DESCRIBE `cruiselines` 0.0034260749816895
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00058317184448242
(85) DESCRIBE `cruises` 0.0054309368133545
(86) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75713') 0.00068998336791992
(87) DESCRIBE `deckplans` 0.0026218891143799
(88) DESCRIBE `cabins` 0.0033209323883057
(89) DESCRIBE `shipphotos` 0.0021011829376221
(90) DESCRIBE `cruises` 0.005277156829834
(91) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4425, 6056, 4424, 75760, 51215, 45258, 45259, 85799, 69292, 79285)) ORDER BY FIND_IN_SET(id, '4425,6056,4424,75760,51215,45258,45259,85799,69292,79285') 0.0021481513977051
(92) DESCRIBE `cruiselines` 0.0042400360107422
(93) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('216', '23', '47', '33', '14', '20', '26', '151', '19', '15', '91', '8', '29', '101', '96', '114', '218', '18', '24', '180')) ORDER BY FIND_IN_SET(id, '216,23,47,33,14,20,26,151,19,15,91,8,29,101,96,114,218,18,24,180') 0.0032379627227783
(94) DESCRIBE `ships` 0.0056469440460205
(95) SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '66', '1282', '780', '148', '652', '1409', '1766', '124', '290', '332', '349', '448', '542', '585', '616', '966', '1021', '1159', '1672', '160', '163', '286', '291', '404', '434', '580', '766', '776', '1088', '1193', '1303', '1319', '1321', '1330', '1359', '1569', '1746', '1772', '45', '98', '105', '108', '149', '253', '262', '285', '287', '338', '340', '341', '389', '394', '406', '422', '508', '547', '553', '674', '678', '683', '726', '738', '748', '768', '769', '770', '907', '968', '1028', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1318', '1415', '1587', '1721', '1723')) ORDER BY FIND_IN_SET(id, '855,517,66,1282,780,148,652,1409,1766,124,290,332,349,448,542,585,616,966,1021,1159,1672,160,163,286,291,404,434,580,766,776,1088,1193,1303,1319,1321,1330,1359,1569,1746,1772,45,98,105,108,149,253,262,285,287,338,340,341,389,394,406,422,508,547,553,674,678,683,726,738,748,768,769,770,907,968,1028,1029,1073,1108,1135,1157,1262,1283,1318,1415,1587,1721,1723') 0.012676000595093
(96) DESCRIBE `cruisetypes` 0.0024120807647705
(97) DESCRIBE `destinations` 0.0036859512329102
(98) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '2', '35', '50', '12', '26', '25', '8', '48', '49', '29', '40', '53', '11', '28', '34', '37', '38')) ORDER BY FIND_IN_SET(id, '43,22,2,35,50,12,26,25,8,48,49,29,40,53,11,28,34,37,38') 0.0027971267700195