or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Sanctuary Cruises
    Sanctuary Ananda

    Sanctuary Ananda

    Sanctuary Ananda is custom built by local craftsmen using traditional materials while offering sleek contemporary luxury. Sanctuary Ananda set sail on the Myanmar Rivers in...

    Star Rating River
  • APT
    Sanctuary Yangzi Explorer

    Sanctuary Yangzi Explorer

    The Sanctuary Yangzi Explorer is the smallest, most exclusive and most luxurious ship cruising the Yangtze River. It offers the level of intimacy, facilities, comfort...

    Star Rating River
  • Sanctuary Cruises
    Sanctuary Yangzi Explorer

    Sanctuary Yangzi Explorer

    Carrying just 124 passengers, compared to the 300 plus accommodated on other cruise ships, the Sanctuary Yangzi Explorer offers the finest and most personalised service...

    Star Rating River
  • Uniworld Boutique River Cruise Collection
    Sanctuary Yangzi Explorer

    Sanctuary Yangzi Explorer

    The newest ship on the Yangtze is a sanctuary of lavish features, with the largest cabins and suites on the river—all with private balconies, and...

    Star Rating River
  • Tauck
    Sapphire

    Sapphire

    One of the 361-foot (110-meter) riverboats in Tauck's Destination Fleet, this newly redesigned riverboat debuts in 2017 with a new deck plan optimized for the...

    Star Rating River
  • Princess Cruises
    Sapphire Princess

    Sapphire Princess

    As you set your sights on the wonders of the world, let Sapphire Princess indulge your every whim. Over 700 balconies, world-class gourmet dining and...

    Star Rating 4 Star
     
    SAIL & SAVE WITH PRINCESS Save up to 30% off Launch fares on selected cruises
  • Tauck
    Savor

    Savor

    Accommodating up to 130 passengers as she winds her way along the mighty Danube River to offer our guests exclusive Tauck discoveries in timeless cities...

    Star Rating River
  • Scenic Tours
    Scenic Amber

    Scenic Amber

    Innovators in design and technology for luxury river cruising vessels, your Scenic Space-Ship will be your gracious floating hotel as you cruise the waterways of...

    Star Rating River
  • Scenic Tours
    Scenic Aura

    Scenic Aura

    From the moment you step on board our all-new river cruiser Scenic Aura, you will be immersed in our signature world of all-inclusive luxury. Delivering...

    Star Rating River
  • Scenic Tours
    Scenic Azure

    Scenic Azure

    We are delighted to announce the launch of the Scenic Azure, a brand new ship that has been custom-built to navigate the picturesque Douro. The...

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

# Query Time
(1) connect 0.0018401145935059
(2) DESCRIBE `ships` 0.0045230388641357
(3) DESCRIBE `cruiselines` 0.0029110908508301
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00034213066101074
(5) DESCRIBE `orchid_image` 0.002324104309082
(6) DESCRIBE `cruiselines` 0.0025031566619873
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00042605400085449
(8) DESCRIBE `ships` 0.0035750865936279
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1376') 0.00043892860412598
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003509521484375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033402442932129
(12) DESCRIBE `avid_specials` 0.0015900135040283
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1376 AND class = 'Ship') OR (item_id = 174 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.0018808841705322
(14) DESCRIBE `cruiselines` 0.0025069713592529
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00045180320739746
(16) DESCRIBE `orchid_image` 0.0018279552459717
(17) DESCRIBE `cruiselines` 0.0032498836517334
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00038981437683105
(19) DESCRIBE `ships` 0.0026040077209473
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '987') 0.00044798851013184
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027108192443848
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028705596923828
(23) DESCRIBE `avid_specials` 0.0014100074768066
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 987 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.0016438961029053
(25) DESCRIBE `cruiselines` 0.00235915184021
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 174))) 0.00032401084899902
(27) DESCRIBE `orchid_image` 0.0016341209411621
(28) DESCRIBE `cruiselines` 0.0021450519561768
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '174') 0.00038599967956543
(30) DESCRIBE `ships` 0.0028209686279297
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '749') 0.00030899047851562
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003049373626709
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026893615722656
(34) DESCRIBE `avid_specials` 0.0012719631195068
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 749 AND class = 'Ship') OR (item_id = 174 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.00111985206604
(36) DESCRIBE `cruiselines` 0.0019490718841553
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00040602684020996
(38) DESCRIBE `orchid_image` 0.0014481544494629
(39) DESCRIBE `cruiselines` 0.0018000602722168
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00029897689819336
(41) DESCRIBE `ships` 0.0028820037841797
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1732') 0.00031208992004395
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(45) DESCRIBE `avid_specials` 0.0012540817260742
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1732 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.001060962677002
(47) DESCRIBE `cruiselines` 0.0024399757385254
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00055480003356934
(49) DESCRIBE `orchid_image` 0.001596212387085
(50) DESCRIBE `cruiselines` 0.0020740032196045
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00045204162597656
(52) DESCRIBE `ships` 0.0036449432373047
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '672') 0.00039505958557129
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025415420532227
(56) DESCRIBE `avid_specials` 0.0015621185302734
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 672 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.0018219947814941
(58) DESCRIBE `cruiselines` 0.0028400421142578
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00056314468383789
(60) DESCRIBE `orchid_image` 0.0022280216217041
(61) DESCRIBE `cruiselines` 0.0028290748596191
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00053691864013672
(63) DESCRIBE `ships` 0.0026459693908691
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00041484832763672
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(67) DESCRIBE `avid_specials` 0.0013091564178467
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 406 AND class = 'Ship') OR (item_id = 23 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.0013401508331299
(69) DESCRIBE `cruiselines` 0.0020608901977539
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00038695335388184
(71) DESCRIBE `orchid_image` 0.0015928745269775
(72) DESCRIBE `cruiselines` 0.0023820400238037
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.0003669261932373
(74) DESCRIBE `ships` 0.0035731792449951
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1188') 0.0005040168762207
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033879280090332
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(78) DESCRIBE `avid_specials` 0.0017359256744385
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1188 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.0012311935424805
(80) DESCRIBE `cruiselines` 0.0025849342346191
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00056695938110352
(82) DESCRIBE `orchid_image` 0.0021929740905762
(83) DESCRIBE `cruiselines` 0.0026099681854248
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00035500526428223
(85) DESCRIBE `ships` 0.0031771659851074
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.00045299530029297
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026082992553711
(89) DESCRIBE `avid_specials` 0.0012209415435791
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1445 AND class = 'Ship') OR (item_id = 156 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.0017609596252441
(91) DESCRIBE `cruiselines` 0.0026562213897705
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00048995018005371
(93) DESCRIBE `orchid_image` 0.0020458698272705
(94) DESCRIBE `cruiselines` 0.0026469230651855
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00048184394836426
(96) DESCRIBE `ships` 0.0034439563751221
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1350') 0.0003969669342041
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031113624572754
(100) DESCRIBE `avid_specials` 0.0016460418701172
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1350 AND class = 'Ship') OR (item_id = 156 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.0016498565673828
(102) DESCRIBE `cruiselines` 0.0028460025787354
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00059604644775391
(104) DESCRIBE `orchid_image` 0.0021300315856934
(105) DESCRIBE `cruiselines` 0.0023977756500244
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00044608116149902
(107) DESCRIBE `ships` 0.0033318996429443
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1444') 0.00046992301940918
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032711029052734
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027680397033691
(111) DESCRIBE `avid_specials` 0.001410961151123
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1444 AND class = 'Ship') OR (item_id = 156 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.00086116790771484
(113) DESCRIBE `cruises` 0.0029571056365967
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4425, 6056, 34159, 38572, 41312, 41314, 44275, 44276, 48303, 49176)) ORDER BY FIND_IN_SET(id, '4425,6056,34159,38572,41312,41314,44275,44276,48303,49176') 0.00098705291748047
(115) DESCRIBE `cruiselines` 0.0022239685058594
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '12', '23', '171', '18', '144', '20', '101', '31', '8', '131', '96', '239', '183', '29', '191', '120', '103', '206', '50', '15', '221', '33', '28', '262', '24', '91', '268', '114', '110', '156', '37', '208', '141', '14', '187', '153', '118', '49', '211', '151', '30', '258', '216', '232', '181', '212', '36', '4', '140', '225', '238', '249', '256', '113', '204', '47', '16', '90', '174', '88', '261', '182', '188', '230', '35', '136', '237', '159', '146', '195', '264', '180', '213', '115', '57', '64', '73', '248', '95', '168', '196', '209', '220', '184', '52', '219', '59', '231', '170', '229', '116', '82', '119', '244', '105', '134', '108', '276', '48', '240', '275', '269', '132', '224', '266', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,12,23,171,18,144,20,101,31,8,131,96,239,183,29,191,120,103,206,50,15,221,33,28,262,24,91,268,114,110,156,37,208,141,14,187,153,118,49,211,151,30,258,216,232,181,212,36,4,140,225,238,249,256,113,204,47,16,90,174,88,261,182,188,230,35,136,237,159,146,195,264,180,213,115,57,64,73,248,95,168,196,209,220,184,52,219,59,231,170,229,116,82,119,244,105,134,108,276,48,240,275,269,132,224,266,210') 0.0062568187713623
(117) DESCRIBE `ships` 0.003835916519165
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '1359', '1291', '977', '454', '1272', '1599', '855', '1247', '1554', '1555', '986', '1237', '1594', '1067', '1588', '1677', '258', '407', '34', '38', '37', '22', '27', '461', '21', '28', '378', '31', '393', '817', '1135', '780', '349', '1012', '30', '36', '1424', '39', '726', '1422', '35', '1423', '1419', '404', '1418', '1420', '1421', '1415', '882', '1176', '462', '113', '1215', '1245', '1405', '330', '766', '24', '1574', '11', '711', '265', '439', '9', '452', '10', '1607', '1744', '455', '1141', '542', '585', '739', '1572', '635', '124', '674', '770', '1095', '573', '874', '3', '5', '1454', '792', '1372', '116', '340', '338', '580', '716', '1168', '1193', '1302', '351', '553', '1284', '25', '66', '520', '797', '1460', '1471', '1021', '160', '285', '332', '1402', '974', '4', '43', '148', '253', '390', '748', '1455', '111', '658', '993', '1172', '207', '1260', '1678', '791', '1259', '1320', '1325', '1562', '1195', '1323', '81', '406', '517', '286', '434', '582', '590', '768', '1068', '1575', '678', '970', '1266', '119', '327', '526', '559', '1373', '108', '616', '63', '375', '854', '883', '401', '421', '657', '78', '547', '1569', '1571', '1586', '1587', '84', '722', '1208', '775', '850', '1139', '1236', '1398', '150', '335', '1008', '1492', '114', '784', '1437', '403', '1268', '1308', '152', '1064', '1672', '151', '823', '958', '1319', '14', '704', '1108', '1289', '149', '348', '451', '652', '683', '715', '966', '1088', '75', '223', '325', '405', '790', '1321', '123', '162', '1159', '1243', '1269', '1282', '1724', '262', '389', '1013', '1143', '1330', '1348', '1389', '163', '483', '1270', '1326', '1327', '441', '508', '732', '1526', '1557', '1561', '1579', '1151', '1214', '314', '333', '385', '394', '626', '1318', '1367', '287', '290', '545', '1301', '1711', '82', '93', '1376', '521', '651', '1075', '1539', '1602', '1722', '98', '796', '818', '884', '968', '1027', '1040', '1137', '1216', '1344', '1717', '291', '673', '769', '1144', '1163', '1343', '1409', '201', '743', '751', '852', '1160', '1604', '1738', '45', '1063', '1223', '1303', '1452', '1453', '1540', '147', '485', '776', '1025', '1090', '1136', '1157', '1217', '1283', '1413', '1552', '105', '324', '341', '516', '811', '1073', '1233', '1241', '1426', '1449', '1704', '266', '669', '1043', '1345', '1632', '448', '467', '701', '1019', '1145', '1152', '1218', '1226', '1253', '1358', '1566', '1682', '639', '795', '885', '888', '905', '988', '1029', '1150', '1411', '1448', '1742', '74', '503', '601', '1676', '1740', '417', '610', '738', '1322', '1647', '352', '731', '859', '1149', '1188', '1458', '493', '494', '973', '1026', '1351', '1408', '1055', '1231', '1489', '1496', '1505', '1580', '205', '666', '954', '1034', '1047', '1049', '1229', '1366', '1474', '1609', '1716', '618', '836', '851', '1230', '1362', '1368', '1516', '208', '423', '663', '709', '1154', '1262', '1444', '1470', '1619', '204', '920', '927', '1020', '1222', '1285', '1407', '1410', '1627', '1713', '1715', '703', '921', '931', '996', '1004', '1196', '1354', '1463', '1508', '1518', '1714', '643', '914', '923', '1037', '1106', '1240', '1521', '1673', '1743', '422', '717', '915', '916', '926', '930', '1003', '1017', '1072', '1138', '1352', '1404', '1567', '1606', '499', '924', '972', '1042', '1175', '1187', '1224', '1360', '1361', '1459', '1486', '1522', '1581', '1593', '1596', '479', '671', '672', '781', '1051', '1148', '1254', '1412', '1445', '1517', '656', '1001', '17', '665', '994', '1054', '1514', '1708', '1751', '837', '938', '985', '1002', '1005', '1382', '1417', '1601', '1723', '420', '453', '504', '761', '982', '995', '1045', '1053', '1684', '1729', '574', '821', '937', '1028', '1481')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,1359,1291,977,454,1272,1599,855,1247,1554,1555,986,1237,1594,1067,1588,1677,258,407,34,38,37,22,27,461,21,28,378,31,393,817,1135,780,349,1012,30,36,1424,39,726,1422,35,1423,1419,404,1418,1420,1421,1415,882,1176,462,113,1215,1245,1405,330,766,24,1574,11,711,265,439,9,452,10,1607,1744,455,1141,542,585,739,1572,635,124,674,770,1095,573,874,3,5,1454,792,1372,116,340,338,580,716,1168,1193,1302,351,553,1284,25,66,520,797,1460,1471,1021,160,285,332,1402,974,4,43,148,253,390,748,1455,111,658,993,1172,207,1260,1678,791,1259,1320,1325,1562,1195,1323,81,406,517,286,434,582,590,768,1068,1575,678,970,1266,119,327,526,559,1373,108,616,63,375,854,883,401,421,657,78,547,1569,1571,1586,1587,84,722,1208,775,850,1139,1236,1398,150,335,1008,1492,114,784,1437,403,1268,1308,152,1064,1672,151,823,958,1319,14,704,1108,1289,149,348,451,652,683,715,966,1088,75,223,325,405,790,1321,123,162,1159,1243,1269,1282,1724,262,389,1013,1143,1330,1348,1389,163,483,1270,1326,1327,441,508,732,1526,1557,1561,1579,1151,1214,314,333,385,394,626,1318,1367,287,290,545,1301,1711,82,93,1376,521,651,1075,1539,1602,1722,98,796,818,884,968,1027,1040,1137,1216,1344,1717,291,673,769,1144,1163,1343,1409,201,743,751,852,1160,1604,1738,45,1063,1223,1303,1452,1453,1540,147,485,776,1025,1090,1136,1157,1217,1283,1413,1552,105,324,341,516,811,1073,1233,1241,1426,1449,1704,266,669,1043,1345,1632,448,467,701,1019,1145,1152,1218,1226,1253,1358,1566,1682,639,795,885,888,905,988,1029,1150,1411,1448,1742,74,503,601,1676,1740,417,610,738,1322,1647,352,731,859,1149,1188,1458,493,494,973,1026,1351,1408,1055,1231,1489,1496,1505,1580,205,666,954,1034,1047,1049,1229,1366,1474,1609,1716,618,836,851,1230,1362,1368,1516,208,423,663,709,1154,1262,1444,1470,1619,204,920,927,1020,1222,1285,1407,1410,1627,1713,1715,703,921,931,996,1004,1196,1354,1463,1508,1518,1714,643,914,923,1037,1106,1240,1521,1673,1743,422,717,915,916,926,930,1003,1017,1072,1138,1352,1404,1567,1606,499,924,972,1042,1175,1187,1224,1360,1361,1459,1486,1522,1581,1593,1596,479,671,672,781,1051,1148,1254,1412,1445,1517,656,1001,17,665,994,1054,1514,1708,1751,837,938,985,1002,1005,1382,1417,1601,1723,420,453,504,761,982,995,1045,1053,1684,1729,574,821,937,1028,1481') 0.046344041824341
(119) DESCRIBE `cruisetypes` 0.0018517971038818
(120) DESCRIBE `destinations` 0.0034270286560059
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '43', '9', '2', '8', '53', '55', '39', '28', '38', '40', '7', '26', '30', '48', '11', '21', '45', '29', '49', '56', '44', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,43,9,2,8,53,55,39,28,38,40,7,26,30,48,11,21,45,29,49,56,44,34,10,52,46,32') 0.0024299621582031