or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Assam Bengal Navigation
    ABN Rajmahal

    ABN Rajmahal

    Our new ship "ABN Rajmahal", nearing completion in Kolkata, enters service on the Hugli and the Ganges in February 2014. She is 50m long, is...

    Star Rating River
  • Assam Bengal Navigation
    ABN Sukapha

    ABN Sukapha

    Our second ship "ABN Sukapha" joined "ABN Charaidew" in Assam in October 2006. We have respected the fragile environment of the River Brahmaputra and resisted...

    Star Rating River
  • European Waterways
    Absoluut2

    Absoluut2

    Absoluut2 was purpose-built for luxury cruising on the inland waterways of Europe and was launched as the private luxury hotel barge of the DeKuyper liqueur...

    Star Rating River
  • Alaskan Dream Cruises
    Admiralty Dream

    Admiralty Dream

    The Admiralty Dream is perfect for adventure in the wilderness waterways. With its shallow draft and stately pace of cruising, nothing will be missed in...

    Star Rating Specialty
  • Royal Caribbean International
    Adventure of the Seas

    Adventure of the Seas

    Royal Caribbean International have taken cruising to a whole new level. Enjoy one-of-a-kind features like an ice-skating rink, the Royal Promenade and a rock-climbing wall...

    Star Rating 4 Star
     
    Royal Caribbean Cruises - The Big View Sale Free Balcony Upgrade when booking a selected Oceanview plus up to 30% off* Every Guest. LAST MINUTE, 24 HOUR SALES & EXCLUSIVE FARES EXCLUDED. On Sale until 28 May.
  • Voyages to Antiquity
    Aegean Odyssey

    Aegean Odyssey

    AEGEAN ODYSSEY is apremium class ship that is being especially rebuilt to cater for cruising in the coastal waters of the central and southern Mediterranean....

    Star Rating 3 Star
  • Affinity Cruises
    Affinity

    Affinity

    Discover the wonders of these areas aboard our comfy vessel where we offer you a personalised nautical experience in a relaxed atmosphere that you only...

    Star Rating Specialty
  • One Ocean Expeditions
    Akademik Ioffe

    Akademik Ioffe

    Designed for polar research, Akademik Ioffe is modern, comfortable, safe and ice-strengthened. From small group sessions to briefings for all passengers, we have public spaces...

    Star Rating Specialty
  • One Ocean Expeditions
    Akademik Sergey Vavilov

    Akademik Sergey Vavilov

    Designed for polar research, Akademik Sergey Vavilov is modern, comfortable, safe and ice-strengthened. From small group sessions to briefings for all passengers, we have public...

    Star Rating Specialty
  • Heritage Expeditions
    Akademik Shokalskiy

    Akademik Shokalskiy

    The Shokalskiy is the sister ship to the Spirit of Enderby, they were both built in 1984 for polar and oceanographic research and being fully...

    Star Rating Specialty
 

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

Total elapsed time: 0.083094835281372

# Query Time
(1) connect 0.00063705444335938
(2) DESCRIBE `ships` 0.0012960433959961
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') 0.0028798580169678
(4) connect 0.00044798851013184
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0034759044647217
(6) DESCRIBE `cruiselines` 0.00094914436340332
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00027298927307129
(8) DESCRIBE `orchid_image` 0.00054097175598145
(9) DESCRIBE `cruiselines` 0.00062012672424316
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00019502639770508
(11) DESCRIBE `ships` 0.00084400177001953
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00018692016601562
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017905235290527
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022101402282715
(15) DESCRIBE `avid_specials` 0.00045394897460938
(16) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1213 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00073981285095215
(17) DESCRIBE `cruiselines` 0.0006110668182373
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00024008750915527
(19) DESCRIBE `orchid_image` 0.0005190372467041
(20) DESCRIBE `cruiselines` 0.00059199333190918
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00017905235290527
(22) DESCRIBE `ships` 0.00079894065856934
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.00019216537475586
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016188621520996
(26) DESCRIBE `avid_specials` 0.00044417381286621
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1212 AND class = 'Ship') OR (item_id = 236 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00072717666625977
(28) DESCRIBE `cruiselines` 0.00064301490783691
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) 0.0002131462097168
(30) DESCRIBE `orchid_image` 0.00052213668823242
(31) DESCRIBE `cruiselines` 0.00077700614929199
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '206') 0.00023913383483887
(33) DESCRIBE `ships` 0.00083208084106445
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1197') 0.00018405914306641
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020003318786621
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(37) DESCRIBE `avid_specials` 0.00044703483581543
(38) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1197 AND class = 'Ship') OR (item_id = 206 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00068521499633789
(39) DESCRIBE `cruiselines` 0.00068306922912598
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00023102760314941
(41) DESCRIBE `orchid_image` 0.00051712989807129
(42) DESCRIBE `cruiselines` 0.00065708160400391
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00017905235290527
(44) DESCRIBE `ships` 0.00080180168151855
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022') 0.00018620491027832
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017690658569336
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001680850982666
(48) DESCRIBE `avid_specials` 0.00047588348388672
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1022 AND class = 'Ship') OR (item_id = 213 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00065708160400391
(50) DESCRIBE `cruiselines` 0.00061702728271484
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00022506713867188
(52) DESCRIBE `orchid_image` 0.00053095817565918
(53) DESCRIBE `cruiselines` 0.00060915946960449
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00019311904907227
(55) DESCRIBE `ships` 0.00084805488586426
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.00018095970153809
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(59) DESCRIBE `avid_specials` 0.0004429817199707
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00062990188598633
(61) DESCRIBE `cruiselines` 0.0006110668182373
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00020885467529297
(63) DESCRIBE `orchid_image` 0.0005190372467041
(64) DESCRIBE `cruiselines` 0.00059890747070312
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00018906593322754
(66) DESCRIBE `ships` 0.00077009201049805
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00018000602722168
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017213821411133
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016903877258301
(70) DESCRIBE `avid_specials` 0.00043988227844238
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 823 AND class = 'Ship') OR (item_id = 188 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00059294700622559
(72) DESCRIBE `cruiselines` 0.00061583518981934
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134))) 0.00023698806762695
(74) DESCRIBE `orchid_image` 0.00050902366638184
(75) DESCRIBE `cruiselines` 0.00065708160400391
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134') 0.00018000602722168
(77) DESCRIBE `ships` 0.00081801414489746
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568') 0.00017809867858887
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017309188842773
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001678466796875
(81) DESCRIBE `avid_specials` 0.00044488906860352
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 568 AND class = 'Ship') OR (item_id = 134 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0006098747253418
(83) DESCRIBE `cruiselines` 0.00068306922912598
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 184))) 0.0002140998840332
(85) DESCRIBE `orchid_image` 0.0005180835723877
(86) DESCRIBE `cruiselines` 0.00059795379638672
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '184') 0.00018095970153809
(88) DESCRIBE `ships` 0.00080490112304688
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1092') 0.00019001960754395
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017285346984863
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001671314239502
(92) DESCRIBE `avid_specials` 0.00053501129150391
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1092 AND class = 'Ship') OR (item_id = 184 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00068998336791992
(94) DESCRIBE `cruiselines` 0.00062990188598633
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 184))) 0.00021004676818848
(96) DESCRIBE `orchid_image` 0.00055503845214844
(97) DESCRIBE `cruiselines` 0.00060200691223145
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '184') 0.00018000602722168
(99) DESCRIBE `ships` 0.0007929801940918
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1091') 0.00018787384033203
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017404556274414
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016689300537109
(103) DESCRIBE `avid_specials` 0.00045204162597656
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1091 AND class = 'Ship') OR (item_id = 184 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00062108039855957
(105) DESCRIBE `cruiselines` 0.00060296058654785
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105))) 0.00020813941955566
(107) DESCRIBE `orchid_image` 0.00052309036254883
(108) DESCRIBE `cruiselines` 0.00064802169799805
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '105') 0.00018000602722168
(110) DESCRIBE `ships` 0.00077295303344727
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1392') 0.00019097328186035
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017213821411133
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001671314239502
(114) DESCRIBE `avid_specials` 0.00050497055053711
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1392 AND class = 'Ship') OR (item_id = 105 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00059199333190918
(116) DESCRIBE `cruises` 0.00124192237854
(117) SELECT `cruises`.* FROM `cruises` WHERE (id IN (9304, 32350, 34157, 34171, 34192, 34654, 40794, 41417, 44275, 44276)) ORDER BY FIND_IN_SET(id, '9304,32350,34157,34171,34192,34654,40794,41417,44275,44276') 0.00073909759521484
(118) DESCRIBE `cruiselines` 0.00072002410888672
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '19', '26', '218', '101', '23', '20', '96', '18', '7', '171', '120', '206', '8', '131', '208', '144', '50', '191', '15', '156', '31', '91', '37', '103', '221', '12', '29', '110', '183', '33', '181', '153', '137', '14', '16', '28', '24', '38', '170', '36', '49', '114', '141', '118', '159', '108', '151', '187', '220', '223', '212', '47', '59', '35', '88', '196', '216', '263', '30', '94', '4', '172', '174', '168', '115', '180', '200', '73', '211', '113', '195', '140', '188', '147', '39', '157', '92', '52', '146', '213', '62', '132', '136', '105', '82', '57', '95', '182', '116', '119', '134', '209', '48', '219', '204')) ORDER BY FIND_IN_SET(id, '77,19,26,218,101,23,20,96,18,7,171,120,206,8,131,208,144,50,191,15,156,31,91,37,103,221,12,29,110,183,33,181,153,137,14,16,28,24,38,170,36,49,114,141,118,159,108,151,187,220,223,212,47,59,35,88,196,216,263,30,94,4,172,174,168,115,180,200,73,211,113,195,140,188,147,39,157,92,52,146,213,62,132,136,105,82,57,95,182,116,119,134,209,48,219,204') 0.0020458698272705
(120) DESCRIBE `ships` 0.0011889934539795
(121) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '809', '1199', '738', '726', '287', '258', '116', '452', '797', '1359', '1082', '1205', '834', '585', '113', '1243', '974', '1372', '521', '480', '1032', '610', '674', '837', '207', '404', '684', '766', '517', '883', '14', '405', '780', '1245', '770', '407', '553', '10', '455', '594', '977', '595', '855', '859', '1417', '265', '737', '1021', '462', '1135', '1027', '711', '349', '573', '1323', '1067', '727', '286', '966', '993', '1109', '748', '27', '937', '970', '1075', '1224', '1285', '560', '22', '105', '616', '665', '81', '338', '731', '1302', '483', '593', '1139', '1223', '1345', '189', '28', '590', '657', '791', '850', '1233', '21', '769', '1145', '1284', '82', '817', '1272', '683', '1424', '75', '332', '988', '39', '996', '262', '792', '1405', '30', '34', '37', '111', '503', '652', '1013', '784', '35', '704', '986', '1422', '25', '325', '1012', '1237', '1419', '1421', '4', '163', '547', '678', '871', '1455', '31', '790', '1418', '1420', '36', '66', '378', '439', '451', '728', '1321', '38', '1095', '1217', '1291', '1327', '212', '612', '958', '1308', '1456', '5', '11', '24', '314', '394', '1326', '162', '626', '823', '1115', '1168', '1241', '1343', '1449', '70', '385', '526', '639', '852', '1136', '1157', '1172', '1319', '1344', '43', '253', '765', '1137', '1149', '1460', '508', '961', '963', '1108', '1318', '1373', '9', '461', '635', '650', '884', '885', '1058', '1325', '968', '1025', '1026', '1144', '1160', '1282', '45', '108', '673', '1090', '1143', '78', '211', '285', '386', '403', '434', '485', '658', '751', '905', '944', '84', '542', '1071', '1094', '1159', '1163', '119', '124', '580', '742', '1008', '1448', '666', '1322', '205', '559', '1266', '123', '160', '324', '401', '651', '688', '1088', '1148', '1292', '1301', '1348', '1366', '201', '722', '1034', '1134', '1231', '330', '340', '997', '1152', '1169', '1230', '1289', '954', '973', '1146', '74', '93', '290', '420', '421', '1006', '1147', '313', '348', '920', '927', '1240', '1283', '422', '768', '783', '786', '1423', '208', '266', '335', '467', '663', '785', '857', '931', '994', '1028', '1087', '1188', '333', '487', '672', '869', '914', '915', '921', '923', '985', '1019', '1354', '3', '798', '916', '926', '930', '1072', '1226', '148', '341', '389', '582', '749', '796', '924', '1064', '1376', '69', '149', '327', '448', '545', '574', '733', '739', '811', '854', '1073', '1154', '1193', '115', '375', '390', '419', '456', '818', '1068', '1320', '1351', '1355', '1471', '601', '776', '204', '995', '1063', '1229', '98', '261', '393', '671', '836', '932', '692', '1138', '1262', '152', '938', '1175', '150', '223', '494', '693', '701', '752', '147', '453', '669', '695', '882', '1453', '1457', '17', '627', '717', '775', '888', '969', '1341', '1352', '1452', '97', '703', '730', '972', '1029', '1089', '1196', '1340', '1358', '1415', '1459', '795', '990', '1189', '1458', '291', '423', '441', '851', '1389', '1054', '1055', '1236', '1461', '488', '868', '1140', '1254', '1330', '1350', '1450', '687', '1011', '1156', '454', '493', '707', '1158', '351', '596', '761', '1024', '1256', '1299', '1426', '151', '240', '288', '479', '491', '1056', '1402', '925', '1113', '1142', '1298', '1338', '1468', '466', '962', '964', '804', '1049', '1053', '1339', '1342', '299', '506', '808', '886', '1059', '1316', '1346', '1469', '59', '300', '520', '1020', '1045', '1141', '1225', '1294', '417', '562', '1037', '1151', '1170', '1232', '1329', '1367', '62', '114', '297', '1242', '1360', '1361', '1404', '589', '682', '800', '801', '1250', '1362', '1368', '618', '716', '740', '821', '858', '965', '987', '1004', '1106', '1198', '1353', '225', '656')) ORDER BY FIND_IN_SET(id, '1127,809,1199,738,726,287,258,116,452,797,1359,1082,1205,834,585,113,1243,974,1372,521,480,1032,610,674,837,207,404,684,766,517,883,14,405,780,1245,770,407,553,10,455,594,977,595,855,859,1417,265,737,1021,462,1135,1027,711,349,573,1323,1067,727,286,966,993,1109,748,27,937,970,1075,1224,1285,560,22,105,616,665,81,338,731,1302,483,593,1139,1223,1345,189,28,590,657,791,850,1233,21,769,1145,1284,82,817,1272,683,1424,75,332,988,39,996,262,792,1405,30,34,37,111,503,652,1013,784,35,704,986,1422,25,325,1012,1237,1419,1421,4,163,547,678,871,1455,31,790,1418,1420,36,66,378,439,451,728,1321,38,1095,1217,1291,1327,212,612,958,1308,1456,5,11,24,314,394,1326,162,626,823,1115,1168,1241,1343,1449,70,385,526,639,852,1136,1157,1172,1319,1344,43,253,765,1137,1149,1460,508,961,963,1108,1318,1373,9,461,635,650,884,885,1058,1325,968,1025,1026,1144,1160,1282,45,108,673,1090,1143,78,211,285,386,403,434,485,658,751,905,944,84,542,1071,1094,1159,1163,119,124,580,742,1008,1448,666,1322,205,559,1266,123,160,324,401,651,688,1088,1148,1292,1301,1348,1366,201,722,1034,1134,1231,330,340,997,1152,1169,1230,1289,954,973,1146,74,93,290,420,421,1006,1147,313,348,920,927,1240,1283,422,768,783,786,1423,208,266,335,467,663,785,857,931,994,1028,1087,1188,333,487,672,869,914,915,921,923,985,1019,1354,3,798,916,926,930,1072,1226,148,341,389,582,749,796,924,1064,1376,69,149,327,448,545,574,733,739,811,854,1073,1154,1193,115,375,390,419,456,818,1068,1320,1351,1355,1471,601,776,204,995,1063,1229,98,261,393,671,836,932,692,1138,1262,152,938,1175,150,223,494,693,701,752,147,453,669,695,882,1453,1457,17,627,717,775,888,969,1341,1352,1452,97,703,730,972,1029,1089,1196,1340,1358,1415,1459,795,990,1189,1458,291,423,441,851,1389,1054,1055,1236,1461,488,868,1140,1254,1330,1350,1450,687,1011,1156,454,493,707,1158,351,596,761,1024,1256,1299,1426,151,240,288,479,491,1056,1402,925,1113,1142,1298,1338,1468,466,962,964,804,1049,1053,1339,1342,299,506,808,886,1059,1316,1346,1469,59,300,520,1020,1045,1141,1225,1294,417,562,1037,1151,1170,1232,1329,1367,62,114,297,1242,1360,1361,1404,589,682,800,801,1250,1362,1368,618,716,740,821,858,965,987,1004,1106,1198,1353,225,656') 0.018179893493652
(122) DESCRIBE `cruisetypes` 0.00099897384643555
(123) DESCRIBE `destinations` 0.00094294548034668
(124) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '54', '12', '2', '37', '35', '25', '43', '9', '44', '8', '39', '26', '40', '55', '48', '28', '53', '38', '49', '11', '29', '7', '21', '34', '46', '30', '10', '45', '52', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,54,12,2,37,35,25,43,9,44,8,39,26,40,55,48,28,53,38,49,11,29,7,21,34,46,30,10,45,52,56,32') 0.0012671947479248