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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Belmond Afloat in France
    Belmond Lilas Barge

    Belmond Lilas Barge

    Soak up the scenery of Alsace aboard Belmond Lilas launching in 2017.

    Step in and discover the casual, welcoming atmosphere of Belmond Lilas. Vibrant colours reflect...

    Star Rating River
  • Belmond Afloat in France
    Belmond Napolean Barge

    Belmond Napolean Barge

    Belmond Napoléon is perfect for convivial parties of up to 12 passengers. Six decadent cabins each boast en-suite bathrooms.

    Feast on dinners in the stately lounge....

    Star Rating River
  • Belmond Afloat in France
    Belmond Pivoine Barge

    Belmond Pivoine Barge

    Uncover the delights of the Champagne region aboard Belmond Pivoine.

    From the trompe l’oeil wall mural and embroidered Parisian bed covers to the marble bathrooms, Belmond...

    Star Rating River
  • Belmond River Cruises
    Belmond Road to Mandalay

    Belmond Road to Mandalay

    Experience the enchanting sights, scents and sounds of the Ayeyarwady River aboard the Belmond Road to Mandalay.

    LIFE ON BOARD
    With cool, relaxing spaces in...

    Star Rating River
  • Fred. Olsen Cruise Lines
    Black Watch

    Black Watch

    Black Watch is sleek, intimate and harks back to the days when cruise ships were revered for their style and charm. Focusing on providing a...

    Star Rating 3 Star
  • CroisiEurope
    Boheme

    Boheme

    Carefully maintained and partially renovated each year, the CroisiEurope fleet is largely made up of recently built vessels, less than five years old, all with...

    Star Rating River
  • Uniworld Boutique River Cruise Collection
    Bon Voyage

    Bon Voyage

    We are excited to announce that after an extensive full-ship renovation, the River Royale will reemerge as the S.S. Bon Voyage in Spring 2019. Inspired...

    Star Rating River
  • CroisiEurope
    Botticelli

    Botticelli

    A spacious ship and bright, the MS Botticelli will allow you to discover Paris, the most beautiful city in the world. The surprising valley of...

    Star Rating River
  • Fred. Olsen Cruise Lines
    Boudicca

    Boudicca

    Loved by Fred. Olsens's staff and guests alike, beautiful Boudicca oozes a sense of class, style and elegance not seen or experienced on modern megaships...

    Star Rating 3 Star
  • Fred. Olsen Cruise Lines
    Brabant

    Brabant

    We’re delighted to introduce you to Brabant, Fred. Olsen’s first-ever dedicated river cruising boat. Built in 2006, this elegant and comfortable vessel is in keeping...

    Star Rating River
 

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

Total elapsed time: 0.28382706642151

# Query Time
(1) connect 0.0010340213775635
(2) DESCRIBE `ships` 0.0044319629669189
(3) DESCRIBE `cruiselines` 0.0032401084899902
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 211))) 0.00075817108154297
(5) DESCRIBE `orchid_image` 0.0022449493408203
(6) DESCRIBE `cruiselines` 0.0034000873565674
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '211') 0.00052285194396973
(8) DESCRIBE `ships` 0.0036880970001221
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1508') 0.00043582916259766
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034189224243164
(12) DESCRIBE `avid_specials` 0.0016911029815674
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1508 AND class = 'Ship') OR (item_id = 211 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.0013089179992676
(14) DESCRIBE `cruiselines` 0.0032479763031006
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 211))) 0.00052905082702637
(16) DESCRIBE `orchid_image` 0.00211501121521
(17) DESCRIBE `cruiselines` 0.0024759769439697
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '211') 0.00057411193847656
(19) DESCRIBE `ships` 0.0055539608001709
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1005') 0.00061607360839844
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055718421936035
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00058293342590332
(23) DESCRIBE `avid_specials` 0.0023860931396484
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1005 AND class = 'Ship') OR (item_id = 211 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.0023670196533203
(25) DESCRIBE `cruiselines` 0.0034949779510498
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 211))) 0.00060796737670898
(27) DESCRIBE `orchid_image` 0.0028588771820068
(28) DESCRIBE `cruiselines` 0.003715991973877
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '211') 0.00065302848815918
(30) DESCRIBE `ships` 0.0047919750213623
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1509') 0.00063109397888184
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036311149597168
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035190582275391
(34) DESCRIBE `avid_specials` 0.0017030239105225
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1509 AND class = 'Ship') OR (item_id = 211 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.0015809535980225
(36) DESCRIBE `cruiselines` 0.0025930404663086
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 115))) 0.00041484832763672
(38) DESCRIBE `orchid_image` 0.0019760131835938
(39) DESCRIBE `cruiselines` 0.0034520626068115
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '115') 0.0007469654083252
(41) DESCRIBE `ships` 0.0051701068878174
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '503') 0.00083398818969727
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046110153198242
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048208236694336
(45) DESCRIBE `avid_specials` 0.0024118423461914
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 503 AND class = 'Ship') OR (item_id = 115 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.0020778179168701
(47) DESCRIBE `cruiselines` 0.0037841796875
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.0008389949798584
(49) DESCRIBE `orchid_image` 0.0029878616333008
(50) DESCRIBE `cruiselines` 0.003593921661377
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.0005648136138916
(52) DESCRIBE `ships` 0.003978967666626
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '201') 0.00057816505432129
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035905838012695
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00045204162597656
(56) DESCRIBE `avid_specials` 0.0018060207366943
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 201 AND class = 'Ship') OR (item_id = 49 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.0012650489807129
(58) DESCRIBE `cruiselines` 0.0025789737701416
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00066900253295898
(60) DESCRIBE `orchid_image` 0.0019938945770264
(61) DESCRIBE `cruiselines` 0.0028400421142578
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0004889965057373
(63) DESCRIBE `ships` 0.0036349296569824
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1043') 0.00043201446533203
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035715103149414
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034594535827637
(67) DESCRIBE `avid_specials` 0.0020160675048828
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1043 AND class = 'Ship') OR (item_id = 144 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.002079963684082
(69) DESCRIBE `cruiselines` 0.0038070678710938
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00055193901062012
(71) DESCRIBE `orchid_image` 0.0021939277648926
(72) DESCRIBE `cruiselines` 0.0027379989624023
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00042605400085449
(74) DESCRIBE `ships` 0.0059440135955811
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '559') 0.00050711631774902
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039410591125488
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004119873046875
(78) DESCRIBE `avid_specials` 0.0017180442810059
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 559 AND class = 'Ship') OR (item_id = 96 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.0012290477752686
(80) DESCRIBE `cruiselines` 0.0029799938201904
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00049304962158203
(82) DESCRIBE `orchid_image` 0.0021388530731201
(83) DESCRIBE `cruiselines` 0.0026791095733643
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00041103363037109
(85) DESCRIBE `ships` 0.0035409927368164
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1053') 0.00038790702819824
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036311149597168
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(89) DESCRIBE `avid_specials` 0.001708984375
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1053 AND class = 'Ship') OR (item_id = 144 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.0018548965454102
(91) DESCRIBE `cruiselines` 0.0027401447296143
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.00061297416687012
(93) DESCRIBE `orchid_image` 0.0021381378173828
(94) DESCRIBE `cruiselines` 0.0025122165679932
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.00051188468933105
(96) DESCRIBE `ships` 0.004216194152832
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '545') 0.00054407119750977
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00043201446533203
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035595893859863
(100) DESCRIBE `avid_specials` 0.001755952835083
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 545 AND class = 'Ship') OR (item_id = 49 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.0012421607971191
(102) DESCRIBE `cruiselines` 0.0025308132171631
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 49))) 0.00051188468933105
(104) DESCRIBE `orchid_image` 0.0020639896392822
(105) DESCRIBE `cruiselines` 0.0026021003723145
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '49') 0.00046682357788086
(107) DESCRIBE `ships` 0.003774881362915
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1609') 0.00044894218444824
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003960132598877
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004119873046875
(111) DESCRIBE `avid_specials` 0.0017778873443604
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1609 AND class = 'Ship') OR (item_id = 49 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.001262903213501
(113) DESCRIBE `cruises` 0.0039310455322266
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (10649, 13509, 13510, 34157, 34181, 34203, 38122, 38147, 38149, 41318)) ORDER BY FIND_IN_SET(id, '10649,13509,13510,34157,34181,34203,38122,38147,38149,41318') 0.0018250942230225
(115) DESCRIBE `cruiselines` 0.0030059814453125
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '144', '183', '12', '23', '20', '101', '31', '18', '8', '131', '7', '120', '96', '171', '103', '156', '33', '15', '262', '29', '191', '258', '91', '50', '153', '16', '208', '28', '37', '14', '187', '114', '49', '251', '212', '24', '47', '141', '151', '206', '36', '110', '170', '118', '181', '4', '88', '264', '30', '195', '59', '108', '159', '73', '140', '35', '216', '90', '147', '113', '276', '180', '211', '95', '57', '52', '64', '257', '261', '115', '48', '184', '38', '213', '105', '82', '177', '244', '209', '134', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,144,183,12,23,20,101,31,18,8,131,7,120,96,171,103,156,33,15,262,29,191,258,91,50,153,16,208,28,37,14,187,114,49,251,212,24,47,141,151,206,36,110,170,118,181,4,88,264,30,195,59,108,159,73,140,35,216,90,147,113,276,180,211,95,57,52,64,257,261,115,48,184,38,213,105,82,177,244,209,134,245') 0.0058538913726807
(117) DESCRIBE `ships` 0.0048859119415283
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1324', '1744', '732', '726', '517', '1588', '977', '1594', '1555', '1794', '454', '1237', '1717', '780', '1272', '974', '1359', '258', '1032', '797', '1424', '22', '461', '1292', '21', '330', '770', '393', '404', '28', '1677', '1419', '1423', '1420', '1422', '1348', '1418', '1421', '716', '986', '1205', '349', '1415', '333', '521', '674', '11', '1067', '10', '439', '715', '739', '9', '25', '837', '24', '738', '207', '455', '1607', '3', '882', '1260', '1678', '163', '480', '1135', '407', '113', '553', '1141', '1682', '1008', '1402', '1599', '1773', '434', '1768', '610', '766', '1455', '160', '792', '520', '352', '1742', '1569', '265', '332', '711', '817', '1454', '63', '66', '573', '1372', '626', '657', '1021', '1284', '1721', '1602', '462', '542', '285', '585', '1308', '883', '1163', '1302', '1413', '1526', '1738', '737', '1291', '1410', '1411', '314', '526', '1068', '1320', '1323', '1579', '14', '286', '390', '970', '1199', '1266', '43', '327', '582', '748', '854', '1259', '1063', '124', '405', '590', '31', '34', '38', '855', '1088', '1552', '1822', '37', '1013', '1586', '1811', '1463', '378', '635', '944', '1321', '1766', '791', '958', '1733', '119', '441', '1417', '1587', '70', '1193', '1208', '1492', '114', '162', '1245', '678', '1027', '1139', '1157', '4', '386', '401', '850', '1028', '1159', '69', '351', '406', '545', '580', '616', '1318', '1722', '658', '1412', '1672', '1782', '335', '704', '1289', '1461', '547', '1711', '340', '451', '722', '325', '385', '403', '1236', '1326', '1327', '1330', '212', '601', '683', '1108', '1233', '1408', '39', '84', '148', '627', '652', '1040', '1188', '1303', '1367', '1398', '30', '35', '36', '966', '1012', '1151', '1575', '508', '988', '1172', '27', '201', '287', '291', '389', '639', '818', '1043', '1168', '105', '394', '776', '78', '111', '341', '852', '1019', '1223', '1743', '262', '338', '1037', '1344', '1801', '123', '290', '485', '751', '775', '1217', '1282', '1426', '1715', '1716', '673', '701', '1143', '1144', '1160', '1325', '1343', '1452', '1453', '45', '266', '1029', '1226', '1229', '1405', '1604', '1740', '1809', '483', '1319', '1704', '348', '1095', '1358', '905', '1137', '1283', '1373', '968', '972', '1035', '1136', '1152', '1448', '223', '253', '559', '574', '768', '769', '1025', '1090', '1150', '1724', '1808', '151', '417', '651', '851', '1730', '98', '116', '709', '1026', '1045', '1351', '1474', '108', '324', '973', '1055', '1145', '1409', '150', '643', '663', '1206', '1230', '1231', '1458', '1713', '82', '885', '954', '1714', '1772', '1042', '1149', '1154', '1366', '1632', '1750', '1751', '1771', '467', '996', '1196', '1360', '1361', '1368', '1459', '1501', '1609', '1708', '1723', '666', '857', '858', '884', '1049', '1052', '1322', '1362', '1483', '1681', '208', '665', '1071', '1148', '1580', '423', '784', '790', '888', '1048', '1649', '703', '1051', '1293', '1301', '1574', '1020', '1140', '1352', '147', '1054', '1224', '1389', '1571', '1676', '75', '205', '375', '707', '1047', '1601', '152', '516', '886', '1036', '1039', '1075', '1445', '1486', '1758', '81', '422', '796', '1146', '1262', '1329', '1679', '671', '717', '1073', '1256', '1287', '1465', '1539', '1572', '1807', '93', '149', '672', '937', '1109', '1138', '1286', '1437', '1468', '1519', '1781', '503', '1050', '1350', '1371', '1673', '74', '420', '656', '743', '1232', '1444', '1749', '1791', '198', '821', '1044', '1060', '1254', '1294', '1540', '1806', '419', '795', '1663', '1816', '421', '644', '982', '1805', '744', '808', '965', '1645', '1684', '1788', '1823', '493', '494', '761', '969', '999', '1084', '1674', '1767', '1800', '1053', '1240', '1624', '1626', '1650', '452', '479', '687', '1156', '1158', '1241', '1297', '1581')) ORDER BY FIND_IN_SET(id, '1761,1554,1324,1744,732,726,517,1588,977,1594,1555,1794,454,1237,1717,780,1272,974,1359,258,1032,797,1424,22,461,1292,21,330,770,393,404,28,1677,1419,1423,1420,1422,1348,1418,1421,716,986,1205,349,1415,333,521,674,11,1067,10,439,715,739,9,25,837,24,738,207,455,1607,3,882,1260,1678,163,480,1135,407,113,553,1141,1682,1008,1402,1599,1773,434,1768,610,766,1455,160,792,520,352,1742,1569,265,332,711,817,1454,63,66,573,1372,626,657,1021,1284,1721,1602,462,542,285,585,1308,883,1163,1302,1413,1526,1738,737,1291,1410,1411,314,526,1068,1320,1323,1579,14,286,390,970,1199,1266,43,327,582,748,854,1259,1063,124,405,590,31,34,38,855,1088,1552,1822,37,1013,1586,1811,1463,378,635,944,1321,1766,791,958,1733,119,441,1417,1587,70,1193,1208,1492,114,162,1245,678,1027,1139,1157,4,386,401,850,1028,1159,69,351,406,545,580,616,1318,1722,658,1412,1672,1782,335,704,1289,1461,547,1711,340,451,722,325,385,403,1236,1326,1327,1330,212,601,683,1108,1233,1408,39,84,148,627,652,1040,1188,1303,1367,1398,30,35,36,966,1012,1151,1575,508,988,1172,27,201,287,291,389,639,818,1043,1168,105,394,776,78,111,341,852,1019,1223,1743,262,338,1037,1344,1801,123,290,485,751,775,1217,1282,1426,1715,1716,673,701,1143,1144,1160,1325,1343,1452,1453,45,266,1029,1226,1229,1405,1604,1740,1809,483,1319,1704,348,1095,1358,905,1137,1283,1373,968,972,1035,1136,1152,1448,223,253,559,574,768,769,1025,1090,1150,1724,1808,151,417,651,851,1730,98,116,709,1026,1045,1351,1474,108,324,973,1055,1145,1409,150,643,663,1206,1230,1231,1458,1713,82,885,954,1714,1772,1042,1149,1154,1366,1632,1750,1751,1771,467,996,1196,1360,1361,1368,1459,1501,1609,1708,1723,666,857,858,884,1049,1052,1322,1362,1483,1681,208,665,1071,1148,1580,423,784,790,888,1048,1649,703,1051,1293,1301,1574,1020,1140,1352,147,1054,1224,1389,1571,1676,75,205,375,707,1047,1601,152,516,886,1036,1039,1075,1445,1486,1758,81,422,796,1146,1262,1329,1679,671,717,1073,1256,1287,1465,1539,1572,1807,93,149,672,937,1109,1138,1286,1437,1468,1519,1781,503,1050,1350,1371,1673,74,420,656,743,1232,1444,1749,1791,198,821,1044,1060,1254,1294,1540,1806,419,795,1663,1816,421,644,982,1805,744,808,965,1645,1684,1788,1823,493,494,761,969,999,1084,1674,1767,1800,1053,1240,1624,1626,1650,452,479,687,1156,1158,1241,1297,1581') 0.063354015350342
(119) DESCRIBE `cruisetypes` 0.0020260810852051
(120) DESCRIBE `destinations` 0.0027318000793457
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '9', '43', '25', '37', '2', '8', '39', '53', '28', '38', '26', '44', '49', '11', '55', '40', '48', '7', '21', '29', '30', '45', '34', '10', '52', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,9,43,25,37,2,8,39,53,28,38,26,44,49,11,55,40,48,7,21,29,30,45,34,10,52,46,56,32') 0.0025968551635742