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

 
 
 
  • American Cruise Lines
    American Jazz

    American Jazz

    American Cruise Lines is pleased to announce the continuation of our modern riverboat series. American Jazz will begin its inaugural season on the Lower Mississippi...

    Star Rating River
  • American Cruise Lines
    American Pride

    American Pride

    American Pride (previously Queen of the Mississippi) offers an unparalleled experience never before available on the Columbia and Snake Rivers. Aboard American Pride, guests will...

    Star Rating River
  • American Queen Steamboat Company
    American Queen

    American Queen

    As one of the largest steamboats ever built, the grand American Queen is a gracious and elegant triumph of American ingenuity. Although filled with...

    Star Rating 4 Star
  • American Cruise Lines
    American Song

    American Song

    With a capacity of 190 guests, the new line of modern riverboats from American Cruise Lines were developed to exceed all guest expectations. Carefully crafted,...

    Star Rating River
  • American Cruise Lines
    American Spirit

    American Spirit

    Small ship cruising with American Cruise Lines is not like cruising on a mega-ship for days on the open sea. Small ships, like the American...

    Star Rating 2 Star
  • American Cruise Lines
    American Star

    American Star

    American Star entered service in June 2007. Similar to the American Spirit, it will offer guests the same unique style of cruising that has become...

    Star Rating 2 Star
  • Holland America Line
    Amsterdam

    Amsterdam

    The third Holland America Line vessel to bear the name Amsterdam, this elegant, mid-sized ship features a three-story atrium graced by a stunning astrolabe. While...

    Star Rating 5 Star
  • Heritage Line
    Anawrahta

    Anawrahta

    Anawrahta-The Great King:

    With the largest cabin space on the Ayeyarwady, and the highest crew to passenger ratio, The Anawrahta offers the finest on-board experience in...

    Star Rating River
  • Tauck
    Andorinha

    Andorinha

    Purpose-built for cruising to historic quintas and picturesque villages along Portugal’s golden Douro River from coastal Porto to the Spanish border with Tauck in 2020,...

    Star Rating River
  • Pandaw Cruises
    Angkor Pandaw

    Angkor Pandaw

    We have 13 beautifully crafted Pandaw ships in operation that we built ourselves. Each ship, hand finished in brass and teak by traditional craftsmen are...

    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.37397027015686

# Query Time
(1) connect 0.0017199516296387
(2) DESCRIBE `ships` 0.0070121288299561
(3) DESCRIBE `cruiselines` 0.0046780109405518
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.0010499954223633
(5) DESCRIBE `orchid_image` 0.0036690235137939
(6) DESCRIBE `cruiselines` 0.0031650066375732
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.0006248950958252
(8) DESCRIBE `ships` 0.0054700374603271
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1853') 0.00079607963562012
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055193901062012
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050091743469238
(12) DESCRIBE `avid_specials` 0.0025680065155029
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1853 AND class = 'Ship') OR (item_id = 103 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.0026259422302246
(14) DESCRIBE `cruiselines` 0.0036759376525879
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00054693222045898
(16) DESCRIBE `orchid_image` 0.0031800270080566
(17) DESCRIBE `cruiselines` 0.0039360523223877
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00064706802368164
(19) DESCRIBE `ships` 0.0079491138458252
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '954') 0.0025899410247803
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052213668823242
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00072002410888672
(23) DESCRIBE `avid_specials` 0.0029950141906738
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 954 AND class = 'Ship') OR (item_id = 103 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.0025761127471924
(25) DESCRIBE `cruiselines` 0.0044729709625244
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0010361671447754
(27) DESCRIBE `orchid_image` 0.0030481815338135
(28) DESCRIBE `cruiselines` 0.0042850971221924
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00068402290344238
(30) DESCRIBE `ships` 0.0054130554199219
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00069093704223633
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051999092102051
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044798851013184
(34) DESCRIBE `avid_specials` 0.0027010440826416
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1013 AND class = 'Ship') OR (item_id = 212 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.0022189617156982
(36) DESCRIBE `cruiselines` 0.0040268898010254
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00082302093505859
(38) DESCRIBE `orchid_image` 0.0027978420257568
(39) DESCRIBE `cruiselines` 0.003648042678833
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00061798095703125
(41) DESCRIBE `ships` 0.0057010650634766
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1632') 0.00064802169799805
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005490779876709
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005340576171875
(45) DESCRIBE `avid_specials` 0.0020561218261719
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1632 AND class = 'Ship') OR (item_id = 103 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.0012478828430176
(47) DESCRIBE `cruiselines` 0.00301194190979
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00046706199645996
(49) DESCRIBE `orchid_image` 0.0030679702758789
(50) DESCRIBE `cruiselines` 0.0041108131408691
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00060200691223145
(52) DESCRIBE `ships` 0.0060639381408691
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '467') 0.00069594383239746
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00054311752319336
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00051712989807129
(56) DESCRIBE `avid_specials` 0.0027999877929688
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 467 AND class = 'Ship') OR (item_id = 103 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.002051830291748
(58) DESCRIBE `cruiselines` 0.0041608810424805
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00084590911865234
(60) DESCRIBE `orchid_image` 0.0032589435577393
(61) DESCRIBE `cruiselines` 0.0044400691986084
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.0006561279296875
(63) DESCRIBE `ships` 0.0062119960784912
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '639') 0.00072503089904785
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00052094459533691
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00050711631774902
(67) DESCRIBE `avid_specials` 0.0026841163635254
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 639 AND class = 'Ship') OR (item_id = 103 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.0021541118621826
(69) DESCRIBE `cruiselines` 0.0043020248413086
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00081205368041992
(71) DESCRIBE `orchid_image` 0.0031380653381348
(72) DESCRIBE `cruiselines` 0.0040020942687988
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00065398216247559
(74) DESCRIBE `ships` 0.0055699348449707
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '74') 0.00076007843017578
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052618980407715
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051498413085938
(78) DESCRIBE `avid_specials` 0.0026590824127197
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74 AND class = 'Ship') OR (item_id = 18 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.0022170543670654
(80) DESCRIBE `cruiselines` 0.0041449069976807
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00071406364440918
(82) DESCRIBE `orchid_image` 0.003352165222168
(83) DESCRIBE `cruiselines` 0.0041370391845703
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00068783760070801
(85) DESCRIBE `ships` 0.0054669380187988
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1552') 0.0007481575012207
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048708915710449
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047802925109863
(89) DESCRIBE `avid_specials` 0.0023810863494873
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1552 AND class = 'Ship') OR (item_id = 183 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.0018320083618164
(91) DESCRIBE `cruiselines` 0.0031890869140625
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00061202049255371
(93) DESCRIBE `orchid_image` 0.0024681091308594
(94) DESCRIBE `cruiselines` 0.0031180381774902
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00049495697021484
(96) DESCRIBE `ships` 0.0048608779907227
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1823') 0.00061988830566406
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00053095817565918
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00070285797119141
(100) DESCRIBE `avid_specials` 0.0025861263275146
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1823 AND class = 'Ship') OR (item_id = 153 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.0020580291748047
(102) DESCRIBE `cruiselines` 0.0043351650238037
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00074982643127441
(104) DESCRIBE `orchid_image` 0.0032730102539062
(105) DESCRIBE `cruiselines` 0.0032329559326172
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.0004880428314209
(107) DESCRIBE `ships` 0.0048849582672119
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1140') 0.00061798095703125
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045013427734375
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050592422485352
(111) DESCRIBE `avid_specials` 0.0022039413452148
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1140 AND class = 'Ship') OR (item_id = 120 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.0021588802337646
(113) DESCRIBE `cruises` 0.005558967590332
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (8256, 29952, 34155, 37682, 38674, 38681, 39342, 40593, 41693, 45259)) ORDER BY FIND_IN_SET(id, '8256,29952,34155,37682,38674,38681,39342,40593,41693,45259') 0.0023398399353027
(115) DESCRIBE `cruiselines` 0.0041370391845703
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '36', '49', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '261', '115', '48', '213', '159', '264', '211', '276', '209', '108', '113', '57', '90', '82', '95', '184', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,36,49,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,261,115,48,213,159,264,211,276,209,108,113,57,90,82,95,184,38,180,52,244,105,35,64,134,257,245,172') 0.0066061019897461
(117) DESCRIBE `ships` 0.0058829784393311
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '1417', '780', '1324', '855', '1588', '1717', '207', '1794', '871', '1291', '874', '1594', '977', '1572', '454', '1199', '1766', '404', '1359', '1272', '770', '22', '330', '461', '21', '393', '1032', '974', '66', '716', '1237', '28', '738', '1292', '1424', '434', '797', '1134', '553', '1682', '265', '332', '521', '333', '1348', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '1422', '585', '1418', '1420', '1421', '9', '11', '715', '857', '10', '858', '1501', '1677', '163', '739', '792', '407', '439', '455', '25', '1132', '1678', '378', '3', '31', '34', '36', '39', '674', '24', '542', '657', '1460', '520', '1008', '1721', '1141', '1205', '837', '1569', '1607', '385', '1742', '1852', '1402', '1773', '386', '966', '1302', '1067', '1168', '1233', '1372', '113', '882', '1822', '850', '1012', '1505', '1811', '160', '1676', '35', '98', '338', '626', '768', '1454', '1455', '1574', '573', '1602', '37', '1135', '1319', '1373', '285', '451', '30', '610', '986', '1021', '63', '817', '1284', '1733', '352', '1282', '1413', '1259', '1411', '547', '1410', '1782', '38', '111', '148', '1398', '108', '314', '375', '1193', '1722', '406', '1088', '1437', '43', '286', '503', '508', '627', '1108', '198', '748', '1063', '1308', '1808', '340', '526', '1145', '1320', '1323', '1579', '1711', '883', '970', '116', '124', '327', '485', '854', '1149', '1325', '1586', '348', '390', '582', '1571', '1738', '394', '590', '1028', '1492', '119', '1068', '1208', '1266', '1575', '1724', '1810', '223', '335', '616', '944', '1157', '1321', '1412', '1552', '1672', '75', '82', '652', '791', '1461', '1587', '1809', '114', '704', '1801', '70', '351', '462', '4', '147', '441', '480', '545', '658', '678', '1027', '1853', '683', '1289', '884', '988', '78', '162', '325', '403', '1318', '1330', '1408', '1820', '69', '105', '201', '401', '601', '722', '790', '291', '405', '958', '1139', '1486', '149', '341', '1188', '1303', '81', '287', '389', '580', '776', '1073', '1236', '1245', '1772', '123', '262', '483', '651', '1326', '1327', '1539', '1771', '818', '1037', '1367', '1704', '423', '1043', '1151', '1159', '1526', '1757', '266', '673', '1013', '1040', '1172', '1540', '290', '796', '1019', '45', '1474', '639', '968', '1223', '1573', '84', '574', '635', '795', '1426', '1463', '1681', '1730', '1740', '1743', '751', '775', '852', '1029', '1035', '1160', '1338', '1715', '1758', '324', '717', '1163', '1206', '1217', '1344', '972', '1146', '1150', '1226', '1229', '1283', '1409', '1452', '1453', '1604', '1716', '417', '643', '709', '1095', '1143', '1144', '1343', '1358', '1483', '1663', '1807', '1833', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '151', '665', '1042', '1045', '1230', '1231', '1787', '212', '467', '885', '1026', '1051', '1137', '1152', '1351', '1449', '1749', '1791', '644', '1140', '1154', '1340', '1458', '1647', '1723', '1759', '1806', '663', '769', '954', '1109', '1224', '1366', '1368', '1405', '1459', '1609', '1632', '1751', '1816', '150', '208', '453', '559', '920', '973', '996', '1025', '1049', '1050', '1090', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1708', '1713', '1805', '448', '666', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1649', '1714', '1750', '1788', '1823', '701', '707', '740', '886', '915', '916', '926', '930', '931', '1071', '1294', '1854', '703', '924', '1047', '1052', '1389', '1580', '1596', '1650', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '93', '479', '784', '937', '1664', '205', '253', '487', '672', '888', '1256', '1301', '1599', '1626', '1674', '671', '821', '965', '999', '1232')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,1417,780,1324,855,1588,1717,207,1794,871,1291,874,1594,977,1572,454,1199,1766,404,1359,1272,770,22,330,461,21,393,1032,974,66,716,1237,28,738,1292,1424,434,797,1134,553,1682,265,332,521,333,1348,766,1768,349,711,1415,1260,1419,1423,1422,585,1418,1420,1421,9,11,715,857,10,858,1501,1677,163,739,792,407,439,455,25,1132,1678,378,3,31,34,36,39,674,24,542,657,1460,520,1008,1721,1141,1205,837,1569,1607,385,1742,1852,1402,1773,386,966,1302,1067,1168,1233,1372,113,882,1822,850,1012,1505,1811,160,1676,35,98,338,626,768,1454,1455,1574,573,1602,37,1135,1319,1373,285,451,30,610,986,1021,63,817,1284,1733,352,1282,1413,1259,1411,547,1410,1782,38,111,148,1398,108,314,375,1193,1722,406,1088,1437,43,286,503,508,627,1108,198,748,1063,1308,1808,340,526,1145,1320,1323,1579,1711,883,970,116,124,327,485,854,1149,1325,1586,348,390,582,1571,1738,394,590,1028,1492,119,1068,1208,1266,1575,1724,1810,223,335,616,944,1157,1321,1412,1552,1672,75,82,652,791,1461,1587,1809,114,704,1801,70,351,462,4,147,441,480,545,658,678,1027,1853,683,1289,884,988,78,162,325,403,1318,1330,1408,1820,69,105,201,401,601,722,790,291,405,958,1139,1486,149,341,1188,1303,81,287,389,580,776,1073,1236,1245,1772,123,262,483,651,1326,1327,1539,1771,818,1037,1367,1704,423,1043,1151,1159,1526,1757,266,673,1013,1040,1172,1540,290,796,1019,45,1474,639,968,1223,1573,84,574,635,795,1426,1463,1681,1730,1740,1743,751,775,852,1029,1035,1160,1338,1715,1758,324,717,1163,1206,1217,1344,972,1146,1150,1226,1229,1283,1409,1452,1453,1604,1716,417,643,709,1095,1143,1144,1343,1358,1483,1663,1807,1833,851,905,1048,1136,1262,1293,1448,1673,1746,151,665,1042,1045,1230,1231,1787,212,467,885,1026,1051,1137,1152,1351,1449,1749,1791,644,1140,1154,1340,1458,1647,1723,1759,1806,663,769,954,1109,1224,1366,1368,1405,1459,1609,1632,1751,1816,150,208,453,559,920,973,996,1025,1049,1050,1090,1148,1274,1329,1354,1360,1361,1362,1519,1601,1708,1713,1805,448,666,914,921,923,927,1044,1055,1072,1196,1322,1339,1649,1714,1750,1788,1823,701,707,740,886,915,916,926,930,931,1071,1294,1854,703,924,1047,1052,1389,1580,1596,1650,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,93,479,784,937,1664,205,253,487,672,888,1256,1301,1599,1626,1674,671,821,965,999,1232') 0.082895994186401
(119) DESCRIBE `cruisetypes` 0.0028970241546631
(120) DESCRIBE `destinations` 0.003662109375
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '49', '7', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,9,2,8,44,55,53,39,40,26,38,28,30,49,7,11,45,21,48,29,52,34,10,46,56,32') 0.004227876663208