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

 
 
 
  • Seabourn Venture

    Seabourn Venture

    Seabourn Venture is scheduled to launch in June 2021, with a second yet-to-be-named sister ship slated to launch in May 2022. Both ships will be...

    Star Rating Specialty
  • SeaDream Yacht Club
    SeaDream I

    SeaDream I

    Let’s face it! Some vacations at sea can be boring. But a holiday with SeaDream Yacht Club is something new. Unstructured! Unexpected! A casual, free-form...

    Star Rating 5 Star
  • SeaDream Yacht Club
    SeaDream II

    SeaDream II

    Let’s face it! Some vacations at sea can be boring. But a holiday with SeaDream Yacht Club is something new. Unstructured! Unexpected! A casual, free-form...

    Star Rating 5 Star
  • CroisiEurope
    Seine Princess

    Seine Princess

    Enjoy the MS Seine Princess and its spacious and comfortable cabins to discover the Seine, its secret gardens, bucolic landscapes and history.

    Star Rating River
  • Royal Caribbean International
    Serenade of the Seas

    Serenade of the Seas

    Good morning, sunshine. Wake up on board Serenade of the Seas®, a dreamlike ship that's sleek and sunlit, with panoramic vistas and wide-open spaces at...

    Star Rating 4 Star
  • Noble Caledonia
    Serenissima

    Serenissima

    The handsome 100-passenger MS Serenissima began her career as the Harald Jarl, cruising the Norwegian coastline and fjords. Extensively renovated in 2003 she was rechristened...

    Star Rating 4 Star
  • Regent Seven Seas Cruises
    Seven Seas Explorer

    Seven Seas Explorer

    Seven Seas Explorer® is spaciously intimate, breathlessly elegant and perfectly staffed to offer Regent Seven Seas Cruises’ special brand of all-inclusive luxury. The summer of...

    Star Rating 6 Star
  • Regent Seven Seas Cruises
    Seven Seas Mariner

    Seven Seas Mariner

    Seven Seas Mariner is the world's first all-suite, all-balcony ship, as well as the first to offer dining by the famed Le Cordon Bleu®...

    Star Rating 6 Star
  • Regent Seven Seas Cruises
    Seven Seas Navigator

    Seven Seas Navigator

    The intimate atmosphere of Seven Seas Navigator® is accompanied by her beautiful style and luxury, from the gorgeous teak pool deck to the superb offerings...

    Star Rating 6 Star
  • Regent Seven Seas Cruises
    Seven Seas Splendor

    Seven Seas Splendor

    Seven Seas Splendor - luxury perfected.

    Building on our long tradition of being the most inclusive luxury experience in the world, we are creating something...

    Star Rating 6 Star
 

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

Total elapsed time: 0.29494047164917

# Query Time
(1) connect 0.0011858940124512
(2) DESCRIBE `ships` 0.0062129497528076
(3) DESCRIBE `cruiselines` 0.0038290023803711
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00071120262145996
(5) DESCRIBE `orchid_image` 0.0030891895294189
(6) DESCRIBE `ships` 0.0035710334777832
(7) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1807') 0.00046491622924805
(8) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036907196044922
(9) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034809112548828
(10) DESCRIBE `avid_specials` 0.0017440319061279
(11) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1807 AND class = 'Ship') OR (item_id = 28 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.0011460781097412
(12) DESCRIBE `cruiselines` 0.002971887588501
(13) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.0004270076751709
(14) DESCRIBE `orchid_image` 0.0027329921722412
(15) DESCRIBE `cruiselines` 0.0037062168121338
(16) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00050687789916992
(17) DESCRIBE `ships` 0.0058071613311768
(18) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.0003969669342041
(19) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036120414733887
(20) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034785270690918
(21) DESCRIBE `avid_specials` 0.0019030570983887
(22) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 385 AND class = 'Ship') OR (item_id = 88 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.0012087821960449
(23) DESCRIBE `cruiselines` 0.0026059150695801
(24) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00044393539428711
(25) DESCRIBE `orchid_image` 0.0020930767059326
(26) DESCRIBE `cruiselines` 0.0026628971099854
(27) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00037503242492676
(28) DESCRIBE `ships` 0.0045130252838135
(29) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '386') 0.00038814544677734
(30) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035810470581055
(31) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(32) DESCRIBE `avid_specials` 0.0017368793487549
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 386 AND class = 'Ship') OR (item_id = 88 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.0012149810791016
(34) DESCRIBE `cruiselines` 0.003187894821167
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00064611434936523
(36) DESCRIBE `orchid_image` 0.0028340816497803
(37) DESCRIBE `cruiselines` 0.0032501220703125
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00039815902709961
(39) DESCRIBE `ships` 0.0035369396209717
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1055') 0.00058293342590332
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035500526428223
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039196014404297
(43) DESCRIBE `avid_specials` 0.0021889209747314
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1055 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.0010859966278076
(45) DESCRIBE `cruiselines` 0.0034849643707275
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00054502487182617
(47) DESCRIBE `orchid_image` 0.0024158954620361
(48) DESCRIBE `cruiselines` 0.0025639533996582
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044894218444824
(50) DESCRIBE `ships` 0.0036602020263672
(51) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '389') 0.00058603286743164
(52) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055098533630371
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050711631774902
(54) DESCRIBE `avid_specials` 0.0030808448791504
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 389 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.0023539066314697
(56) DESCRIBE `cruiselines` 0.003709077835083
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 209))) 0.00064611434936523
(58) DESCRIBE `orchid_image` 0.0034310817718506
(59) DESCRIBE `cruiselines` 0.0027790069580078
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '209') 0.00050687789916992
(61) DESCRIBE `ships` 0.0041220188140869
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1257') 0.00040507316589355
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(65) DESCRIBE `avid_specials` 0.0025448799133301
(66) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1257 AND class = 'Ship') OR (item_id = 209 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.001723051071167
(67) DESCRIBE `cruiselines` 0.0031619071960449
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00059008598327637
(69) DESCRIBE `orchid_image` 0.0024268627166748
(70) DESCRIBE `cruiselines` 0.0045990943908691
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00065898895263672
(72) DESCRIBE `ships` 0.006234884262085
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1168') 0.00055599212646484
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00051498413085938
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0005180835723877
(76) DESCRIBE `avid_specials` 0.0026280879974365
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1168 AND class = 'Ship') OR (item_id = 24 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.0013790130615234
(78) DESCRIBE `cruiselines` 0.0030748844146729
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00048112869262695
(80) DESCRIBE `orchid_image` 0.0027358531951904
(81) DESCRIBE `cruiselines` 0.0030651092529297
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00047993659973145
(83) DESCRIBE `ships` 0.0049450397491455
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '111') 0.00047802925109863
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00046491622924805
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00047898292541504
(87) DESCRIBE `avid_specials` 0.0029270648956299
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 111 AND class = 'Ship') OR (item_id = 24 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.0020251274108887
(89) DESCRIBE `cruiselines` 0.0033509731292725
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00055408477783203
(91) DESCRIBE `orchid_image` 0.002734899520874
(92) DESCRIBE `cruiselines` 0.0026731491088867
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00044798851013184
(94) DESCRIBE `ships` 0.0041558742523193
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '108') 0.00046992301940918
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00046014785766602
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035905838012695
(98) DESCRIBE `avid_specials` 0.0017781257629395
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 108 AND class = 'Ship') OR (item_id = 24 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.0011990070343018
(100) DESCRIBE `cruiselines` 0.0034539699554443
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00045299530029297
(102) DESCRIBE `orchid_image` 0.0022039413452148
(103) DESCRIBE `cruiselines` 0.0029261112213135
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00041413307189941
(105) DESCRIBE `ships` 0.0041189193725586
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1676') 0.00048398971557617
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00039100646972656
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036406517028809
(109) DESCRIBE `avid_specials` 0.0017540454864502
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1676 AND class = 'Ship') OR (item_id = 24 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.0012731552124023
(111) DESCRIBE `cruises` 0.0054481029510498
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34156, 34163, 34184, 52232, 52645, 52732, 54751, 57662, 61417, 62216)) ORDER BY FIND_IN_SET(id, '34156,34163,34184,52232,52645,52732,54751,57662,61417,62216') 0.0018918514251709
(113) DESCRIBE `cruiselines` 0.0032141208648682
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '183', '101', '8', '31', '120', '131', '29', '96', '103', '15', '206', '91', '262', '33', '114', '24', '170', '14', '28', '156', '258', '191', '50', '195', '37', '153', '208', '16', '49', '187', '36', '88', '251', '47', '151', '216', '212', '141', '181', '118', '4', '110', '59', '140', '147', '30', '261', '48', '73', '213', '211', '276', '209', '159', '115', '264', '108', '82', '113', '57', '95', '90', '184', '244', '52', '180', '38', '64', '35', '105', '134', '257', '245')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,183,101,8,31,120,131,29,96,103,15,206,91,262,33,114,24,170,14,28,156,258,191,50,195,37,153,208,16,49,187,36,88,251,47,151,216,212,141,181,118,4,110,59,140,147,30,261,48,73,213,211,276,209,159,115,264,108,82,113,57,95,90,184,244,52,180,38,64,35,105,134,257,245') 0.0054831504821777
(115) DESCRIBE `ships` 0.0042300224304199
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '258', '1324', '517', '780', '737', '1417', '1588', '1717', '855', '871', '207', '1766', '1794', '1291', '977', '1572', '874', '1594', '454', '404', '1359', '770', '1272', '1199', '66', '22', '21', '330', '461', '738', '393', '1032', '1134', '1424', '434', '716', '265', '553', '974', '28', '332', '1237', '1292', '333', '1682', '1768', '797', '521', '1348', '349', '1260', '1419', '1423', '1422', '1418', '1420', '1421', '766', '1415', '711', '715', '163', '792', '9', '455', '1678', '11', '25', '407', '10', '439', '585', '674', '739', '857', '858', '1677', '1132', '1501', '657', '542', '3', '24', '1460', '31', '34', '36', '39', '378', '520', '1008', '1721', '1852', '966', '1569', '1141', '1233', '1607', '1742', '1822', '385', '1505', '1811', '386', '1168', '1676', '1302', '1372', '1402', '35', '1012', '1455', '626', '768', '837', '850', '1373', '1773', '98', '986', '113', '817', '1205', '1319', '338', '451', '1282', '1413', '1602', '882', '1135', '573', '1410', '1782', '160', '352', '1021', '1067', '1259', '1411', '1574', '1733', '547', '610', '1284', '1454', '37', '285', '1398', '30', '148', '314', '375', '1063', '1437', '63', '111', '198', '508', '1145', '1722', '108', '883', '1088', '1193', '1308', '286', '627', '748', '1149', '1808', '38', '340', '406', '526', '1323', '43', '970', '1028', '1320', '1579', '1711', '124', '327', '485', '1108', '1325', '394', '854', '1068', '1586', '348', '390', '582', '1810', '116', '590', '1157', '1321', '1412', '1492', '1571', '1724', '1461', '1738', '1809', '223', '616', '1208', '1575', '1672', '1801', '82', '119', '462', '652', '1853', '351', '791', '944', '1027', '1587', '114', '147', '678', '704', '884', '1318', '1408', '1820', '70', '75', '1266', '1552', '4', '78', '503', '545', '658', '683', '1139', '1486', '201', '325', '335', '401', '441', '958', '1188', '1289', '81', '149', '291', '601', '722', '988', '1330', '1772', '162', '403', '790', '1326', '1327', '1771', '287', '580', '776', '1073', '1367', '105', '389', '423', '651', '1037', '1043', '1151', '1236', '1757', '69', '818', '1040', '1303', '1704', '341', '1013', '1019', '1539', '123', '262', '266', '1172', '290', '405', '483', '796', '1223', '1526', '45', '480', '639', '673', '1474', '1740', '84', '751', '1029', '1159', '1338', '1540', '1715', '1743', '1758', '795', '852', '1035', '1160', '1163', '1206', '1344', '1426', '968', '972', '1146', '1150', '1217', '1226', '1229', '1452', '1453', '1573', '1604', '1681', '1716', '324', '417', '635', '643', '717', '1143', '1144', '1245', '1283', '1343', '1358', '1483', '1807', '1833', '574', '709', '775', '851', '905', '1048', '1136', '1262', '1293', '1448', '1746', '1042', '1045', '1230', '1231', '1663', '1787', '467', '885', '1026', '1051', '1095', '1137', '1749', '1791', '1140', '1154', '1340', '1351', '1409', '1458', '1723', '1730', '1759', '1806', '663', '954', '1224', '1366', '1368', '1459', '1463', '1609', '1632', '1673', '1751', '559', '665', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '151', '448', '666', '914', '921', '923', '927', '1025', '1044', '1055', '1072', '1090', '1196', '1339', '1601', '1714', '1788', '1823', '212', '453', '886', '915', '916', '926', '930', '931', '1109', '1152', '1322', '1449', '1649', '1750', '1854', '208', '703', '769', '924', '1047', '1052', '1596', '1650', '1816', '299', '300', '422', '740', '1004', '1020', '1036', '1039', '1054', '1225', '1352', '1451', '1519', '1580', '150', '937', '1294', '479', '487', '672', '707', '888', '1071', '1256', '1301', '1329', '1389', '93', '205', '671', '821', '1232', '1445', '1664', '516', '644', '1005', '1060', '1350', '1405', '1626', '1792', '1821', '420')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,258,1324,517,780,737,1417,1588,1717,855,871,207,1766,1794,1291,977,1572,874,1594,454,404,1359,770,1272,1199,66,22,21,330,461,738,393,1032,1134,1424,434,716,265,553,974,28,332,1237,1292,333,1682,1768,797,521,1348,349,1260,1419,1423,1422,1418,1420,1421,766,1415,711,715,163,792,9,455,1678,11,25,407,10,439,585,674,739,857,858,1677,1132,1501,657,542,3,24,1460,31,34,36,39,378,520,1008,1721,1852,966,1569,1141,1233,1607,1742,1822,385,1505,1811,386,1168,1676,1302,1372,1402,35,1012,1455,626,768,837,850,1373,1773,98,986,113,817,1205,1319,338,451,1282,1413,1602,882,1135,573,1410,1782,160,352,1021,1067,1259,1411,1574,1733,547,610,1284,1454,37,285,1398,30,148,314,375,1063,1437,63,111,198,508,1145,1722,108,883,1088,1193,1308,286,627,748,1149,1808,38,340,406,526,1323,43,970,1028,1320,1579,1711,124,327,485,1108,1325,394,854,1068,1586,348,390,582,1810,116,590,1157,1321,1412,1492,1571,1724,1461,1738,1809,223,616,1208,1575,1672,1801,82,119,462,652,1853,351,791,944,1027,1587,114,147,678,704,884,1318,1408,1820,70,75,1266,1552,4,78,503,545,658,683,1139,1486,201,325,335,401,441,958,1188,1289,81,149,291,601,722,988,1330,1772,162,403,790,1326,1327,1771,287,580,776,1073,1367,105,389,423,651,1037,1043,1151,1236,1757,69,818,1040,1303,1704,341,1013,1019,1539,123,262,266,1172,290,405,483,796,1223,1526,45,480,639,673,1474,1740,84,751,1029,1159,1338,1540,1715,1743,1758,795,852,1035,1160,1163,1206,1344,1426,968,972,1146,1150,1217,1226,1229,1452,1453,1573,1604,1681,1716,324,417,635,643,717,1143,1144,1245,1283,1343,1358,1483,1807,1833,574,709,775,851,905,1048,1136,1262,1293,1448,1746,1042,1045,1230,1231,1663,1787,467,885,1026,1051,1095,1137,1749,1791,1140,1154,1340,1351,1409,1458,1723,1730,1759,1806,663,954,1224,1366,1368,1459,1463,1609,1632,1673,1751,559,665,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,151,448,666,914,921,923,927,1025,1044,1055,1072,1090,1196,1339,1601,1714,1788,1823,212,453,886,915,916,926,930,931,1109,1152,1322,1449,1649,1750,1854,208,703,769,924,1047,1052,1596,1650,1816,299,300,422,740,1004,1020,1036,1039,1054,1225,1352,1451,1519,1580,150,937,1294,479,487,672,707,888,1071,1256,1301,1329,1389,93,205,671,821,1232,1445,1664,516,644,1005,1060,1350,1405,1626,1792,1821,420') 0.064986944198608
(117) DESCRIBE `cruisetypes` 0.0025169849395752
(118) DESCRIBE `destinations` 0.003587007522583
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '2', '9', '8', '44', '55', '39', '53', '26', '38', '28', '40', '30', '49', '11', '21', '7', '45', '29', '48', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,2,9,8,44,55,39,53,26,38,28,40,30,49,11,21,7,45,29,48,52,34,10,46,56,32') 0.004101037979126