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

 
 
 
  • A-Rosa Cruises

    A-Rosa Riva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Silva

    A-Rosa Silva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Stella

    A-Rosa Stella

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhône/Saône. Seeking for privacy or cozy...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Viva

    A-Rosa Viva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • Assam Bengal Navigation
    ABN Charaidew

    ABN Charaidew

    The "ABN Charaidew" is a 38m long twin-engine steel hulled passenger boat. She was completely stripped down and rebuilt by ABN in 2003 to provide...

    Star Rating River
  • 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
     
    Alaskan Dream Cruises Children 15 years and under receive 30% off Cruise Fares. Call for details. Conditions apply
  • P&O International

    Adonia

    The smallest of our eight ships, Adonia offers a delightfully intimate cruising experience. As she carries just 710 guests, Adonia is a very sociable ship,...

    Star Rating Not Rated
 

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

Total elapsed time: 0.12172389030457

# Query Time
(1) connect 0.00052309036254883
(2) DESCRIBE `ships` 0.002701997756958
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') 0.005889892578125
(4) connect 0.00049400329589844
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0050480365753174
(6) DESCRIBE `cruiselines` 0.0019478797912598
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00053310394287109
(8) DESCRIBE `orchid_image` 0.0013680458068848
(9) DESCRIBE `cruiselines` 0.00099587440490723
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00033092498779297
(11) DESCRIBE `ships` 0.0021579265594482
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1557') 0.00018095970153809
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(15) DESCRIBE `avid_specials` 0.000640869140625
(16) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1557 AND class = 'Ship') OR (item_id = 239 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
(17) DESCRIBE `cruiselines` 0.00092387199401855
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00021600723266602
(19) DESCRIBE `orchid_image` 0.00075697898864746
(20) DESCRIBE `cruiselines` 0.00091814994812012
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00017690658569336
(22) DESCRIBE `ships` 0.0013489723205566
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1216') 0.00018596649169922
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(26) DESCRIBE `avid_specials` 0.00059318542480469
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1216 AND class = 'Ship') OR (item_id = 239 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.00049495697021484
(28) DESCRIBE `cruiselines` 0.00093388557434082
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00020718574523926
(30) DESCRIBE `orchid_image` 0.00072908401489258
(31) DESCRIBE `cruiselines` 0.00089693069458008
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00017499923706055
(33) DESCRIBE `ships` 0.001295804977417
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1222') 0.00019598007202148
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016188621520996
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(37) DESCRIBE `avid_specials` 0.00060701370239258
(38) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222 AND class = 'Ship') OR (item_id = 239 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.00048089027404785
(39) DESCRIBE `cruiselines` 0.00091004371643066
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00022411346435547
(41) DESCRIBE `orchid_image` 0.00075507164001465
(42) DESCRIBE `cruiselines` 0.00092196464538574
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00017499923706055
(44) DESCRIBE `ships` 0.00124192237854
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1270') 0.0001981258392334
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015807151794434
(48) DESCRIBE `avid_specials` 0.00059080123901367
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1270 AND class = 'Ship') OR (item_id = 239 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.0004889965057373
(50) DESCRIBE `cruiselines` 0.00091004371643066
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00022792816162109
(52) DESCRIBE `orchid_image` 0.00075101852416992
(53) DESCRIBE `cruiselines` 0.0009009838104248
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00017905235290527
(55) DESCRIBE `ships` 0.0012478828430176
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1211') 0.00020289421081543
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001680850982666
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(59) DESCRIBE `avid_specials` 0.00059294700622559
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1211 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.00052118301391602
(61) DESCRIBE `cruiselines` 0.00092101097106934
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00022077560424805
(63) DESCRIBE `orchid_image` 0.00073099136352539
(64) DESCRIBE `cruiselines` 0.00090503692626953
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00018596649169922
(66) DESCRIBE `ships` 0.0012509822845459
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00018906593322754
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(70) DESCRIBE `avid_specials` 0.00059294700622559
(71) 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.00051593780517578
(72) DESCRIBE `cruiselines` 0.00091409683227539
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00023603439331055
(74) DESCRIBE `orchid_image` 0.00073099136352539
(75) DESCRIBE `cruiselines` 0.00091886520385742
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00019598007202148
(77) DESCRIBE `ships` 0.0013301372528076
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.00018715858459473
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022196769714355
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(81) DESCRIBE `avid_specials` 0.00067520141601562
(82) 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.00055694580078125
(83) DESCRIBE `cruiselines` 0.00093889236450195
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) 0.00023484230041504
(85) DESCRIBE `orchid_image` 0.00095605850219727
(86) DESCRIBE `cruiselines` 0.0010678768157959
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '206') 0.00020194053649902
(88) DESCRIBE `ships` 0.0014579296112061
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1197') 0.00019502639770508
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016593933105469
(92) DESCRIBE `avid_specials` 0.00062108039855957
(93) 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.0006558895111084
(94) DESCRIBE `cruiselines` 0.00095009803771973
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00023007392883301
(96) DESCRIBE `orchid_image` 0.00074291229248047
(97) DESCRIBE `cruiselines` 0.00094914436340332
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00019383430480957
(99) DESCRIBE `ships` 0.0013608932495117
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022') 0.00018191337585449
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018095970153809
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001671314239502
(103) DESCRIBE `avid_specials` 0.00063800811767578
(104) 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.00059914588928223
(105) DESCRIBE `cruiselines` 0.000946044921875
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.0002129077911377
(107) DESCRIBE `orchid_image` 0.00078296661376953
(108) DESCRIBE `cruiselines` 0.0011618137359619
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00025391578674316
(110) DESCRIBE `ships` 0.001399040222168
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1568') 0.00020909309387207
(112) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id != '1568') 0.004302978515625
(113) UPDATE `ships` SET `orchid_slug` = ? WHERE (id = '1568') 0.00029897689819336
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00020980834960938
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016689300537109
(116) DESCRIBE `avid_specials` 0.00074291229248047
(117) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1568 AND class = 'Ship') OR (item_id = 50 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.00063395500183105
(118) DESCRIBE `cruises` 0.0019650459289551
(119) SELECT `cruises`.* FROM `cruises` WHERE (id IN (14972, 29952, 31627, 34157, 34171, 34192, 38147, 38149, 40904, 44079)) ORDER BY FIND_IN_SET(id, '14972,29952,31627,34157,34171,34192,38147,38149,40904,44079') 0.00081801414489746
(120) DESCRIBE `cruiselines` 0.0013198852539062
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '144', '23', '20', '18', '171', '8', '31', '232', '12', '120', '137', '101', '96', '15', '50', '29', '103', '183', '181', '91', '131', '206', '208', '16', '204', '37', '156', '33', '38', '28', '191', '221', '110', '14', '36', '220', '268', '153', '174', '114', '196', '47', '115', '141', '24', '187', '30', '35', '195', '216', '262', '211', '168', '170', '49', '151', '4', '200', '140', '159', '269', '108', '118', '39', '223', '88', '212', '59', '73', '180', '209', '113', '213', '264', '182', '64', '132', '147', '157', '128', '48', '92', '136', '188', '82', '95', '263', '52', '62', '266', '57', '116', '119', '105', '172', '94', '134', '166', '146', '219')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,144,23,20,18,171,8,31,232,12,120,137,101,96,15,50,29,103,183,181,91,131,206,208,16,204,37,156,33,38,28,191,221,110,14,36,220,268,153,174,114,196,47,115,141,24,187,30,35,195,216,262,211,168,170,49,151,4,200,140,159,269,108,118,39,223,88,212,59,73,180,209,113,213,264,182,64,132,147,157,128,48,92,136,188,82,95,263,52,62,266,57,116,119,105,172,94,134,166,146,219') 0.002532958984375
(122) DESCRIBE `ships` 0.0017399787902832
(123) SELECT `ships`.* FROM `ships` WHERE (id IN ('1247', '738', '1127', '258', '594', '595', '859', '517', '593', '1199', '1291', '1359', '585', '503', '207', '1082', '766', '14', '855', '24', '731', '5', '780', '1376', '837', '1205', '974', '1032', '22', '21', '461', '726', '452', '27', '116', '113', '265', '405', '521', '610', '797', '28', '38', '34', '1424', '37', '404', '30', '39', '35', '1012', '36', '378', '1245', '31', '390', '462', '739', '657', '1372', '674', '1135', '441', '1421', '480', '211', '1420', '684', '1419', '1422', '1087', '1418', '439', '1068', '1115', '25', '555', '792', '1095', '857', '1021', '1423', '1292', '455', '1109', '10', '70', '711', '977', '1405', '770', '1064', '542', '1063', '11', '393', '483', '553', '850', '966', '1489', '69', '1272', '253', '451', '1302', '1552', '4', '434', '716', '883', '1067', '1169', '407', '1325', '639', '869', '1319', '1373', '580', '784', '1417', '769', '1455', '573', '737', '1088', '1301', '349', '454', '1071', '1565', '678', '1308', '291', '954', '1195', '59', '652', '658', '993', '75', '105', '286', '582', '590', '748', '765', '791', '1320', '332', '749', '944', '1323', '1330', '119', '854', '970', '3', '394', '467', '526', '1285', '150', '327', '508', '968', '1027', '149', '683', '768', '616', '651', '1193', '790', '1259', '314', '547', '1208', '1284', '9', '45', '205', '285', '1236', '324', '333', '340', '348', '1139', '1157', '148', '98', '162', '882', '1108', '1463', '82', '338', '403', '775', '1035', '1266', '160', '330', '401', '1008', '1505', '66', '111', '262', '485', '669', '704', '776', '874', '1240', '43', '81', '325', '341', '817', '852', '988', '1168', '1232', '223', '626', '937', '1241', '1282', '1397', '1398', '351', '596', '722', '885', '1159', '93', '151', '152', '743', '884', '1206', '1262', '1558', '62', '1189', '1224', '124', '389', '821', '868', '1145', '1233', '84', '114', '147', '559', '986', '1501', '288', '665', '1327', '406', '516', '650', '688', '1011', '1013', '204', '290', '673', '958', '996', '1010', '1040', '1058', '1326', '1471', '74', '198', '385', '717', '1006', '1243', '201', '448', '715', '1073', '1223', '1460', '1553', '1554', '1555', '1559', '287', '727', '728', '1449', '1486', '163', '313', '574', '701', '796', '1170', '1217', '1343', '1546', '212', '375', '386', '1136', '1237', '1344', '1415', '123', '545', '973', '1137', '1160', '1318', '1345', '1358', '1454', '818', '823', '961', '963', '1283', '1289', '1348', '1452', '1545', '108', '709', '751', '1049', '1151', '1303', '1445', '1453', '1468', '78', '612', '666', '795', '811', '1026', '1144', '1338', '266', '804', '905', '978', '1025', '1045', '1090', '1143', '1163', '1367', '1458', '1459', '417', '732', '800', '997', '1226', '1321', '1357', '1152', '1448', '487', '733', '1229', '1366', '1402', '1519', '335', '672', '786', '1019', '1075', '1148', '1149', '1231', '1322', '1533', '1538', '208', '601', '707', '740', '744', '1034', '1043', '1055', '1060', '1106', '1146', '1175', '1230', '1406', '1532', '1568', '421', '488', '494', '920', '927', '1047', '1051', '1140', '1147', '1426', '1496', '1541', '420', '422', '931', '1004', '1053', '1260', '1346', '466', '560', '692', '695', '785', '836', '914', '915', '921', '923', '1001', '1054', '1072', '1188', '1354', '1516', '1521', '493', '693', '916', '926', '930', '972', '994', '1002', '1257', '1351', '663', '671', '687', '761', '888', '924', '1003', '1154', '1389', '1443', '1518', '17', '225', '504', '627', '767', '1028', '1044', '1294', '1355', '752', '781', '932', '1020', '1038', '1341', '1350', '1407', '1450', '990', '1048', '1089', '1132', '1340', '1514', '1542', '1560', '643', '1017', '1030', '1052', '1299', '1352', '423', '938', '969', '1138', '1297')) ORDER BY FIND_IN_SET(id, '1247,738,1127,258,594,595,859,517,593,1199,1291,1359,585,503,207,1082,766,14,855,24,731,5,780,1376,837,1205,974,1032,22,21,461,726,452,27,116,113,265,405,521,610,797,28,38,34,1424,37,404,30,39,35,1012,36,378,1245,31,390,462,739,657,1372,674,1135,441,1421,480,211,1420,684,1419,1422,1087,1418,439,1068,1115,25,555,792,1095,857,1021,1423,1292,455,1109,10,70,711,977,1405,770,1064,542,1063,11,393,483,553,850,966,1489,69,1272,253,451,1302,1552,4,434,716,883,1067,1169,407,1325,639,869,1319,1373,580,784,1417,769,1455,573,737,1088,1301,349,454,1071,1565,678,1308,291,954,1195,59,652,658,993,75,105,286,582,590,748,765,791,1320,332,749,944,1323,1330,119,854,970,3,394,467,526,1285,150,327,508,968,1027,149,683,768,616,651,1193,790,1259,314,547,1208,1284,9,45,205,285,1236,324,333,340,348,1139,1157,148,98,162,882,1108,1463,82,338,403,775,1035,1266,160,330,401,1008,1505,66,111,262,485,669,704,776,874,1240,43,81,325,341,817,852,988,1168,1232,223,626,937,1241,1282,1397,1398,351,596,722,885,1159,93,151,152,743,884,1206,1262,1558,62,1189,1224,124,389,821,868,1145,1233,84,114,147,559,986,1501,288,665,1327,406,516,650,688,1011,1013,204,290,673,958,996,1010,1040,1058,1326,1471,74,198,385,717,1006,1243,201,448,715,1073,1223,1460,1553,1554,1555,1559,287,727,728,1449,1486,163,313,574,701,796,1170,1217,1343,1546,212,375,386,1136,1237,1344,1415,123,545,973,1137,1160,1318,1345,1358,1454,818,823,961,963,1283,1289,1348,1452,1545,108,709,751,1049,1151,1303,1445,1453,1468,78,612,666,795,811,1026,1144,1338,266,804,905,978,1025,1045,1090,1143,1163,1367,1458,1459,417,732,800,997,1226,1321,1357,1152,1448,487,733,1229,1366,1402,1519,335,672,786,1019,1075,1148,1149,1231,1322,1533,1538,208,601,707,740,744,1034,1043,1055,1060,1106,1146,1175,1230,1406,1532,1568,421,488,494,920,927,1047,1051,1140,1147,1426,1496,1541,420,422,931,1004,1053,1260,1346,466,560,692,695,785,836,914,915,921,923,1001,1054,1072,1188,1354,1516,1521,493,693,916,926,930,972,994,1002,1257,1351,663,671,687,761,888,924,1003,1154,1389,1443,1518,17,225,504,627,767,1028,1044,1294,1355,752,781,932,1020,1038,1341,1350,1407,1450,990,1048,1089,1132,1340,1514,1542,1560,643,1017,1030,1052,1299,1352,423,938,969,1138,1297') 0.026197910308838
(124) DESCRIBE `cruisetypes` 0.0011570453643799
(125) DESCRIBE `destinations` 0.0012199878692627
(126) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '25', '43', '9', '44', '2', '8', '40', '39', '48', '53', '26', '28', '21', '55', '38', '46', '7', '11', '29', '49', '34', '30', '45', '52', '10', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,25,43,9,44,2,8,40,39,48,53,26,28,21,55,38,46,7,11,29,49,34,30,45,52,10,56,32') 0.0013861656188965