or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • AMA Waterways
    AmaVida

    AmaVida

    The AmaVida brings AmaWaterways’ distinctive standard of excellence to the Douro River in Portugal. This grand 106-passenger vessel features balconies in the majority of its...

    Star Rating River
  • APT
    AmaVida

    AmaVida

    The luxurious MS AmaVida has been custom-designed and built with Portugal's beautiful Douro River in mind. Thread your way through this picturesque slice of Europe...

    Star Rating River
  • APT
    AmaViola

    AmaViola

    Leading the way in luxury and comfort, our Concerto River Ships represent a revolution in ship design. They are the grandest ships on Europe’s rivers...

    Star Rating River
  • AMA Waterways
    AmaViola

    AmaViola

    The AmaViola – set to debut in 2016 – is a sister ship to the AmaSerena and features the most advanced design of any river...

    Star Rating River
  • CroisiEurope
    Amazon Discovery

    Amazon Discovery

    Amazon Discovery.

    Star Rating River
  • Pandaw Cruises
    Amazon Dream

    Amazon Dream

    Our partner ship, the Amazon Dream, offers a comfortable base from where we explore; all cabins are air-conditioned and well appointed and you will be...

    Star Rating River
  • Amazon Explorer

    Amazon Explorer

    Our Amazon Explorer tours are designed around our first class 19th century style riverboat. Ecologically designed with the fragile Amazon river and surrounding environment in...

    Star Rating River
     
    G Adventures LAST MINUTE OFFERS Book by July 31st Up to 10% off Galapagos, 20 off Cuba sailing and 35% off Riverboats. For travel between August and November 2018
  • American Cruise Lines
    America

    America

    The America is American Cruise Lines’ eighth ship and its second brand-new vessel to launch in 2016. America is the finest Mississippi paddlewheeler ever built,...

    Star Rating River
  • American Cruise Lines
    American Constellation

    American Constellation

    The American Constellation is the latest small coastal cruise ship from American Cruise Lines. Uniquely designed to navigate the inland waterways of the East Coast...

    Star Rating Specialty
  • American Cruise Lines
    American Constitution

    American Constitution

    The newly-announced American Constitution is scheduled to begin cruising the East Coast in spring of 2018. With a capacity of 175 passengers, the American Constitution...

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

Total elapsed time: 0.18719267845154

# Query Time
(1) connect 0.0008549690246582
(2) DESCRIBE `ships` 0.0044069290161133
(3) DESCRIBE `cruiselines` 0.002251148223877
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00038290023803711
(5) DESCRIBE `orchid_image` 0.0014429092407227
(6) DESCRIBE `cruiselines` 0.0017969608306885
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.00033211708068848
(8) DESCRIBE `ships` 0.0028340816497803
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1020') 0.00034999847412109
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036191940307617
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030207633972168
(12) DESCRIBE `avid_specials` 0.0012819766998291
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1020 AND class = 'Ship') OR (item_id = 131 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.0014770030975342
(14) DESCRIBE `cruiselines` 0.0019068717956543
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00035214424133301
(16) DESCRIBE `orchid_image` 0.0014638900756836
(17) DESCRIBE `cruiselines` 0.0017178058624268
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00031805038452148
(19) DESCRIBE `ships` 0.0026600360870361
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1166') 0.00041508674621582
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029993057250977
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024890899658203
(23) DESCRIBE `avid_specials` 0.0012450218200684
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1166 AND class = 'Ship') OR (item_id = 181 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.0011389255523682
(25) DESCRIBE `cruiselines` 0.0018019676208496
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00049781799316406
(27) DESCRIBE `orchid_image` 0.0015840530395508
(28) DESCRIBE `cruiselines` 0.0018348693847656
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00028109550476074
(30) DESCRIBE `ships` 0.002514123916626
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1478') 0.00031113624572754
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026106834411621
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024700164794922
(34) DESCRIBE `avid_specials` 0.0012969970703125
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1478 AND class = 'Ship') OR (item_id = 181 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.0010149478912354
(36) DESCRIBE `cruiselines` 0.0017709732055664
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.00030303001403809
(38) DESCRIBE `orchid_image` 0.0013618469238281
(39) DESCRIBE `cruiselines` 0.0018019676208496
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.0002601146697998
(41) DESCRIBE `ships` 0.0033719539642334
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1322') 0.00039291381835938
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032305717468262
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(45) DESCRIBE `avid_specials` 0.0014932155609131
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1322 AND class = 'Ship') OR (item_id = 131 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.0015349388122559
(47) DESCRIBE `cruiselines` 0.0023839473724365
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00055193901062012
(49) DESCRIBE `orchid_image` 0.0019140243530273
(50) DESCRIBE `cruiselines` 0.0017879009246826
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00029492378234863
(52) DESCRIBE `ships` 0.0025019645690918
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1466') 0.00029206275939941
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025677680969238
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024604797363281
(56) DESCRIBE `avid_specials` 0.0012478828430176
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1466 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.001054048538208
(58) DESCRIBE `cruiselines` 0.001802921295166
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00029110908508301
(60) DESCRIBE `orchid_image` 0.0013840198516846
(61) DESCRIBE `cruiselines` 0.001708984375
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00027108192443848
(63) DESCRIBE `ships` 0.0024721622467041
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1427') 0.00028395652770996
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030398368835449
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028300285339355
(67) DESCRIBE `avid_specials` 0.0011172294616699
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1427 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.00091791152954102
(69) DESCRIBE `cruiselines` 0.0017299652099609
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00030779838562012
(71) DESCRIBE `orchid_image` 0.001384973526001
(72) DESCRIBE `ships` 0.0024831295013428
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '872') 0.00030803680419922
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030708312988281
(76) DESCRIBE `avid_specials` 0.001101016998291
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 872 AND class = 'Ship') OR (item_id = 171 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.00092697143554688
(78) DESCRIBE `cruiselines` 0.0017518997192383
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00030207633972168
(80) DESCRIBE `orchid_image` 0.0013899803161621
(81) DESCRIBE `cruiselines` 0.0020298957824707
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00033688545227051
(83) DESCRIBE `ships` 0.0031251907348633
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1373') 0.00029492378234863
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030517578125
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024795532226562
(87) DESCRIBE `avid_specials` 0.0010969638824463
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1373 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.00098991394042969
(89) DESCRIBE `cruiselines` 0.001863956451416
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.0003049373626709
(91) DESCRIBE `orchid_image` 0.0014441013336182
(92) DESCRIBE `cruiselines` 0.0023260116577148
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.0003359317779541
(94) DESCRIBE `ships` 0.0032539367675781
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1486') 0.00034809112548828
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031805038452148
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030994415283203
(98) DESCRIBE `avid_specials` 0.0015640258789062
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1486 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.0016391277313232
(100) DESCRIBE `cruiselines` 0.002324104309082
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00037312507629395
(102) DESCRIBE `orchid_image` 0.001863956451416
(103) DESCRIBE `cruiselines` 0.0022690296173096
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00032806396484375
(105) DESCRIBE `ships` 0.0033400058746338
(106) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00038814544677734
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032591819763184
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031089782714844
(109) DESCRIBE `avid_specials` 0.00148606300354
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1601 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.0016639232635498
(111) DESCRIBE `cruises` 0.0039360523223877
(112) SELECT `cruises`.* FROM `cruises` WHERE (id IN (17397, 23655, 23870, 32348, 32923, 33074, 33075, 33084, 33087, 33088)) ORDER BY FIND_IN_SET(id, '17397,23655,23870,32348,32923,33074,33075,33084,33087,33088') 0.0013260841369629
(113) DESCRIBE `cruiselines` 0.0028879642486572
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '144', '171', '31', '101', '18', '20', '8', '183', '7', '96', '120', '191', '12', '103', '221', '50', '29', '15', '268', '37', '91', '262', '28', '110', '33', '114', '141', '208', '232', '153', '187', '14', '24', '118', '49', '131', '181', '258', '206', '156', '151', '36', '204', '212', '30', '220', '256', '140', '4', '249', '238', '16', '47', '239', '174', '195', '35', '264', '113', '211', '216', '90', '146', '182', '188', '159', '213', '136', '168', '196', '237', '115', '209', '180', '73', '95', '57', '219', '248', '59', '170', '184', '225', '229', '52', '108', '231', '261', '88', '132', '276', '269', '275', '244', '82', '230', '105', '48', '119', '64', '116', '240', '38', '266', '39', '134', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,144,171,31,101,18,20,8,183,7,96,120,191,12,103,221,50,29,15,268,37,91,262,28,110,33,114,141,208,232,153,187,14,24,118,49,131,181,258,206,156,151,36,204,212,30,220,256,140,4,249,238,16,47,239,174,195,35,264,113,211,216,90,146,182,188,159,213,136,168,196,237,115,209,180,73,95,57,219,248,59,170,184,225,229,52,108,231,261,88,132,276,269,275,244,82,230,105,48,119,64,116,240,38,266,39,134,210,224,245') 0.0059561729431152
(115) DESCRIBE `ships` 0.0028769969940186
(116) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1247', '1554', '1555', '977', '1205', '1199', '1291', '1359', '1588', '1067', '1237', '407', '258', '1599', '1594', '22', '27', '461', '726', '21', '28', '393', '1424', '817', '1135', '1422', '349', '780', '1419', '1420', '1423', '1418', '1421', '1415', '113', '462', '452', '404', '766', '24', '265', '11', '439', '711', '1245', '10', '1574', '9', '330', '542', '1215', '585', '455', '1141', '674', '207', '770', '124', '1460', '739', '797', '5', '520', '635', '974', '792', '1572', '553', '1607', '1454', '1455', '1272', '3', '116', '573', '517', '25', '1372', '1193', '340', '78', '580', '1021', '1325', '874', '1068', '1402', '390', '1284', '253', '748', '1095', '4', '43', '285', '1172', '1320', '332', '1302', '14', '66', '421', '434', '658', '765', '791', '559', '1586', '582', '1323', '1575', '327', '590', '970', '1259', '286', '855', '1139', '1260', '1571', '119', '160', '526', '678', '993', '406', '854', '883', '1064', '1678', '454', '1492', '405', '616', '1321', '722', '850', '1236', '1308', '823', '1569', '114', '441', '732', '1008', '1348', '403', '547', '1208', '84', '81', '163', '784', '338', '1088', '1319', '348', '652', '657', '871', '1108', '1326', '1327', '1330', '111', '325', '333', '451', '521', '966', '1282', '1672', '1027', '1143', '1389', '262', '731', '859', '1376', '1581', '1587', '30', '31', '34', '35', '36', '37', '38', '351', '378', '1012', '1579', '39', '82', '123', '508', '389', '610', '1151', '1471', '148', '314', '683', '1318', '1367', '1724', '93', '290', '1214', '1243', '1405', '287', '394', '483', '626', '751', '1157', '1398', '651', '1013', '1075', '162', '545', '1040', '1137', '1144', '1344', '1345', '291', '673', '1063', '1159', '1223', '1233', '1343', '98', '352', '743', '768', '852', '1145', '1168', '1303', '1413', '1604', '152', '335', '401', '669', '716', '818', '1043', '1452', '1453', '1602', '149', '968', '1025', '1090', '1136', '1283', '1301', '1552', '45', '769', '988', '1149', '1241', '1373', '1526', '150', '151', '1163', '1463', '1711', '59', '201', '223', '467', '776', '905', '1152', '1226', '1448', '324', '639', '1150', '1449', '108', '888', '1539', '1647', '1717', '74', '266', '341', '503', '601', '973', '1029', '1411', '417', '790', '1458', '1738', '796', '885', '1026', '1188', '1231', '1351', '1614', '1055', '1253', '1292', '1489', '1496', '105', '811', '882', '954', '986', '1034', '1047', '1049', '1366', '1609', '1704', '666', '704', '851', '996', '1073', '1154', '1230', '1285', '1362', '1368', '1382', '1408', '1417', '1505', '1632', '75', '494', '574', '701', '837', '985', '1176', '1409', '1470', '1516', '1540', '1682', '208', '480', '493', '738', '1037', '1474', '147', '205', '857', '1518', '1740', '618', '836', '884', '1521', '1627', '423', '1054', '1134', '1196', '1407', '204', '422', '643', '1051', '1410', '448', '672', '1042', '1224', '1437', '1486', '1593', '1615', '671', '709', '795', '1138', '1148', '1229', '1517', '1522', '1716', '485', '717', '781', '972', '994', '1262', '1352', '1384', '1628', '938', '1017', '1383', '1501', '1514', '1619', '1684', '479', '665', '749', '995', '1645', '1713', '1715', '499', '821', '1045', '1175', '1254', '1412', '1461', '1481', '1601', '1673', '1714', '17', '937', '1011', '1106', '1240', '420', '1028', '1439', '1515', '1606', '313', '453', '1053', '1206', '1266', '1360', '1361', '1459', '212', '744', '1052', '1256', '1293', '1676', '487', '1611', '1639', '1708', '70', '419', '775', '808', '969', '1035', '1048', '1071', '1089', '1110', '1189', '1232', '1274', '1631', '1722', '1723', '375', '798', '1338', '1697', '1729', '715', '1060', '1192', '1339', '1342', '1355', '1385', '1612', '958', '1036', '1158', '1491', '1679', '69', '225', '288', '886')) ORDER BY FIND_IN_SET(id, '1127,1032,1247,1554,1555,977,1205,1199,1291,1359,1588,1067,1237,407,258,1599,1594,22,27,461,726,21,28,393,1424,817,1135,1422,349,780,1419,1420,1423,1418,1421,1415,113,462,452,404,766,24,265,11,439,711,1245,10,1574,9,330,542,1215,585,455,1141,674,207,770,124,1460,739,797,5,520,635,974,792,1572,553,1607,1454,1455,1272,3,116,573,517,25,1372,1193,340,78,580,1021,1325,874,1068,1402,390,1284,253,748,1095,4,43,285,1172,1320,332,1302,14,66,421,434,658,765,791,559,1586,582,1323,1575,327,590,970,1259,286,855,1139,1260,1571,119,160,526,678,993,406,854,883,1064,1678,454,1492,405,616,1321,722,850,1236,1308,823,1569,114,441,732,1008,1348,403,547,1208,84,81,163,784,338,1088,1319,348,652,657,871,1108,1326,1327,1330,111,325,333,451,521,966,1282,1672,1027,1143,1389,262,731,859,1376,1581,1587,30,31,34,35,36,37,38,351,378,1012,1579,39,82,123,508,389,610,1151,1471,148,314,683,1318,1367,1724,93,290,1214,1243,1405,287,394,483,626,751,1157,1398,651,1013,1075,162,545,1040,1137,1144,1344,1345,291,673,1063,1159,1223,1233,1343,98,352,743,768,852,1145,1168,1303,1413,1604,152,335,401,669,716,818,1043,1452,1453,1602,149,968,1025,1090,1136,1283,1301,1552,45,769,988,1149,1241,1373,1526,150,151,1163,1463,1711,59,201,223,467,776,905,1152,1226,1448,324,639,1150,1449,108,888,1539,1647,1717,74,266,341,503,601,973,1029,1411,417,790,1458,1738,796,885,1026,1188,1231,1351,1614,1055,1253,1292,1489,1496,105,811,882,954,986,1034,1047,1049,1366,1609,1704,666,704,851,996,1073,1154,1230,1285,1362,1368,1382,1408,1417,1505,1632,75,494,574,701,837,985,1176,1409,1470,1516,1540,1682,208,480,493,738,1037,1474,147,205,857,1518,1740,618,836,884,1521,1627,423,1054,1134,1196,1407,204,422,643,1051,1410,448,672,1042,1224,1437,1486,1593,1615,671,709,795,1138,1148,1229,1517,1522,1716,485,717,781,972,994,1262,1352,1384,1628,938,1017,1383,1501,1514,1619,1684,479,665,749,995,1645,1713,1715,499,821,1045,1175,1254,1412,1461,1481,1601,1673,1714,17,937,1011,1106,1240,420,1028,1439,1515,1606,313,453,1053,1206,1266,1360,1361,1459,212,744,1052,1256,1293,1676,487,1611,1639,1708,70,419,775,808,969,1035,1048,1071,1089,1110,1189,1232,1274,1631,1722,1723,375,798,1338,1697,1729,715,1060,1192,1339,1342,1355,1385,1612,958,1036,1158,1491,1679,69,225,288,886') 0.037591934204102
(117) DESCRIBE `cruisetypes` 0.0014348030090332
(118) DESCRIBE `destinations` 0.0017759799957275
(119) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '9', '2', '43', '25', '8', '53', '55', '39', '28', '26', '40', '38', '11', '30', '21', '48', '7', '44', '49', '29', '45', '56', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,9,2,43,25,8,53,55,39,28,26,40,38,11,30,21,48,7,44,49,29,45,56,34,10,52,46,32') 0.0025339126586914