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

 
 
 
  • 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
  • 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

    Enjoy the ultimate European river cruise experience on board a luxury Scenic Space-Ship. In 2015 and 2016, we launched three Scenic Space-Ships, Scenic Jasper, Scenic...

    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

    The 5-star Scenic Azure has just 48 cabins and an almost 1:2 staff-to-guest ratio, so you're guaranteed a more intimate experience during your time on-board....

    Star Rating River
  • Scenic Tours
    Scenic Crystal

    Scenic Crystal

    Scenic Crystal, Scenic Jewel and Scenic Jade joined the Scenic luxury fleet in 2012, 2013 and 2014 respectively.

    These ships feature outdoor balconies that convert...

    Star Rating River
  • Scenic Tours
    Scenic Diamond

    Scenic Diamond

    Enjoy the ultimate France river cruise experience on board a luxury Scenic Space-Ship. Scenic recently upgraded Scenic Sapphire and Scenic Diamond to meet the same...

    Star Rating River
  • Scenic Ocean Cruising
    Scenic Eclipse

    Scenic Eclipse

    Introducing Scenic Eclipse, the point on the map where luxury meets discovery.

    Scenic Eclipse sets the standard in ocean cruising in terms of technology, size and...

    Star Rating 6 Star
  • Scenic Tours
    Scenic Gem

    Scenic Gem

    Scenic Gem sails the historic Seine River in Northern France and has the unique ability to sail to the port commune of Honfleur thanks to...

    Star Rating River
  • Scenic Tours
    Scenic Jade

    Scenic Jade

    Scenic Crystal, Scenic Jewel and Scenic Jade joined the Scenic luxury fleet in 2012, 2013 and 2014 respectively.

    These ships feature outdoor balconies that convert into...

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

# Query Time
(1) connect 0.0013470649719238
(2) DESCRIBE `ships` 0.0060679912567139
(3) DESCRIBE `cruiselines` 0.0037360191345215
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0012719631195068
(5) DESCRIBE `orchid_image` 0.0034430027008057
(6) DESCRIBE `cruiselines` 0.0044119358062744
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00070691108703613
(8) DESCRIBE `ships` 0.0050809383392334
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.0005500316619873
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055813789367676
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041604042053223
(12) DESCRIBE `avid_specials` 0.0019748210906982
(13) 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.0013070106506348
(14) DESCRIBE `cruiselines` 0.0026059150695801
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00049400329589844
(16) DESCRIBE `orchid_image` 0.0021500587463379
(17) DESCRIBE `cruiselines` 0.0030159950256348
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00056314468383789
(19) DESCRIBE `ships` 0.0037999153137207
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1188') 0.00057196617126465
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040292739868164
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034689903259277
(23) DESCRIBE `avid_specials` 0.0017781257629395
(24) 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.0015981197357178
(25) DESCRIBE `cruiselines` 0.0034182071685791
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0006721019744873
(27) DESCRIBE `orchid_image` 0.002964973449707
(28) DESCRIBE `cruiselines` 0.0032238960266113
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.0004889965057373
(30) DESCRIBE `ships` 0.0038621425628662
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.0005950927734375
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044083595275879
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034713745117188
(34) DESCRIBE `avid_specials` 0.0018150806427002
(35) 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.0013108253479004
(36) DESCRIBE `cruiselines` 0.0028350353240967
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0004878044128418
(38) DESCRIBE `orchid_image` 0.0019998550415039
(39) DESCRIBE `cruiselines` 0.0029220581054688
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00040006637573242
(41) DESCRIBE `ships` 0.0035262107849121
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1350') 0.00045514106750488
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034880638122559
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040507316589355
(45) DESCRIBE `avid_specials` 0.0023620128631592
(46) 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.0014300346374512
(47) DESCRIBE `cruiselines` 0.0025119781494141
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00047707557678223
(49) DESCRIBE `orchid_image` 0.0025780200958252
(50) DESCRIBE `cruiselines` 0.0029149055480957
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00050520896911621
(52) DESCRIBE `ships` 0.0040569305419922
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1444') 0.00059390068054199
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00048089027404785
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(56) DESCRIBE `avid_specials` 0.0022320747375488
(57) 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.0015430450439453
(58) DESCRIBE `cruiselines` 0.0030419826507568
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00058984756469727
(60) DESCRIBE `orchid_image` 0.0023748874664307
(61) DESCRIBE `cruiselines` 0.003572940826416
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00056600570678711
(63) DESCRIBE `ships` 0.0038430690765381
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '982') 0.00049710273742676
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042295455932617
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004119873046875
(67) DESCRIBE `avid_specials` 0.0021891593933105
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 982 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.001460075378418
(69) DESCRIBE `cruiselines` 0.0026068687438965
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00081682205200195
(71) DESCRIBE `orchid_image` 0.0027339458465576
(72) DESCRIBE `cruiselines` 0.0034399032592773
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00078415870666504
(74) DESCRIBE `ships` 0.0050959587097168
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '687') 0.00064492225646973
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00065898895263672
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042080879211426
(78) DESCRIBE `avid_specials` 0.0021920204162598
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 687 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.0018439292907715
(80) DESCRIBE `cruiselines` 0.0035600662231445
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 261))) 0.00072097778320312
(82) DESCRIBE `orchid_image` 0.0024299621582031
(83) DESCRIBE `cruiselines` 0.0029888153076172
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '261') 0.00050020217895508
(85) DESCRIBE `ships` 0.0041508674621582
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1437') 0.00055408477783203
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036001205444336
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00046300888061523
(89) DESCRIBE `avid_specials` 0.0021331310272217
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1437 AND class = 'Ship') OR (item_id = 261 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.00180983543396
(91) DESCRIBE `cruiselines` 0.0037660598754883
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00060200691223145
(93) DESCRIBE `orchid_image` 0.0023291110992432
(94) DESCRIBE `cruiselines` 0.00319504737854
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00047588348388672
(96) DESCRIBE `ships` 0.0041401386260986
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1156') 0.00048398971557617
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044918060302734
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046110153198242
(100) DESCRIBE `avid_specials` 0.0022919178009033
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1156 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.0020649433135986
(102) DESCRIBE `cruiselines` 0.0039119720458984
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00073790550231934
(104) DESCRIBE `orchid_image` 0.0031239986419678
(105) DESCRIBE `cruiselines` 0.0039761066436768
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00059700012207031
(107) DESCRIBE `ships` 0.0049788951873779
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1295') 0.00054287910461426
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035595893859863
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005030632019043
(111) DESCRIBE `avid_specials` 0.0024700164794922
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1295 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.0021359920501709
(113) DESCRIBE `cruises` 0.0050997734069824
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4425, 4425, 6056, 6056, 34157, 38579, 40785, 40852, 40900, 41006)) ORDER BY FIND_IN_SET(id, '4425,4425,6056,6056,34157,38579,40785,40852,40900,41006') 0.0015339851379395
(115) DESCRIBE `cruiselines` 0.0036330223083496
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '12', '144', '183', '20', '18', '101', '120', '31', '8', '131', '96', '7', '15', '103', '91', '29', '206', '170', '262', '33', '114', '24', '28', '156', '50', '14', '191', '258', '195', '37', '16', '153', '208', '36', '187', '49', '47', '216', '88', '251', '141', '151', '212', '181', '110', '4', '118', '59', '264', '30', '115', '140', '73', '48', '159', '108', '261', '147', '213', '209', '113', '276', '211', '38', '35', '90', '57', '82', '184', '95', '180', '52', '244', '105', '172', '64', '257', '134', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,12,144,183,20,18,101,120,31,8,131,96,7,15,103,91,29,206,170,262,33,114,24,28,156,50,14,191,258,195,37,16,153,208,36,187,49,47,216,88,251,141,151,212,181,110,4,118,59,264,30,115,140,73,48,159,108,261,147,213,209,113,276,211,38,35,90,57,82,184,95,180,52,244,105,172,64,257,134,245,177') 0.0072259902954102
(117) DESCRIBE `ships` 0.0049920082092285
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1744', '732', '517', '737', '1417', '726', '258', '855', '1588', '780', '207', '1717', '1291', '1794', '1324', '454', '1594', '1199', '874', '977', '1237', '871', '1272', '1359', '1572', '974', '404', '1032', '22', '461', '21', '770', '1766', '330', '797', '393', '1424', '1292', '1554', '1555', '716', '28', '66', '521', '1682', '1348', '434', '553', '349', '333', '738', '332', '1423', '1677', '1419', '1422', '1134', '1420', '711', '766', '1418', '1421', '857', '858', '1501', '715', '1415', '265', '11', '9', '792', '10', '439', '1260', '739', '1205', '25', '407', '585', '24', '1768', '163', '455', '542', '674', '1067', '1678', '657', '3', '837', '1607', '1132', '1460', '503', '1008', '882', '1574', '1141', '1302', '1721', '1773', '113', '520', '1402', '385', '1135', '1569', '386', '986', '1742', '850', '966', '1168', '63', '160', '573', '1233', '1372', '1454', '1319', '1602', '610', '626', '1852', '98', '1021', '1455', '285', '1373', '817', '1284', '198', '352', '1822', '338', '1413', '1505', '1811', '111', '480', '1398', '1411', '1676', '1259', '1410', '1193', '116', '286', '547', '1733', '108', '314', '768', '1738', '124', '148', '526', '1088', '1320', '1323', '1579', '43', '340', '883', '1437', '508', '748', '970', '1108', '1308', '854', '1266', '1325', '1552', '1722', '327', '390', '627', '1571', '1782', '582', '590', '1145', '1575', '462', '485', '1063', '1586', '1711', '348', '406', '1245', '1492', '394', '944', '1028', '1724', '791', '1149', '1208', '1321', '1412', '70', '119', '335', '616', '405', '658', '1587', '1672', '114', '162', '1027', '4', '69', '704', '1463', '82', '441', '545', '652', '1068', '1289', '451', '678', '958', '1157', '31', '34', '38', '75', '351', '37', '105', '722', '1461', '325', '401', '1303', '1318', '1330', '78', '378', '403', '601', '884', '1159', '1408', '1809', '683', '1236', '1801', '201', '262', '291', '341', '651', '389', '644', '1139', '1188', '1367', '1526', '1853', '14', '36', '580', '988', '1013', '1151', '1540', '287', '1073', '1172', '1808', '123', '639', '790', '818', '1019', '1037', '1326', '1327', '1820', '423', '483', '635', '776', '1405', '1573', '1599', '1704', '81', '266', '673', '1282', '1743', '1772', '290', '796', '852', '1160', '1426', '1539', '1715', '212', '1043', '1217', '1344', '45', '574', '775', '968', '1040', '1223', '1474', '1716', '1730', '84', '751', '1095', '1143', '1144', '1163', '1226', '1229', '1343', '1358', '1452', '1453', '1604', '324', '795', '1029', '1035', '1681', '1757', '1771', '39', '1045', '1409', '30', '35', '709', '1012', '1137', '1283', '1338', '1449', '905', '1048', '1152', '1647', '1663', '1740', '417', '972', '1136', '1150', '1206', '1448', '1673', '151', '223', '769', '885', '1025', '1090', '1483', '27', '150', '643', '701', '851', '1055', '253', '665', '1026', '1293', '1351', '1750', '1758', '1146', '1262', '1713', '1042', '1071', '1140', '1154', '1230', '1231', '1329', '1458', '1714', '1807', '1833', '448', '453', '663', '707', '784', '954', '973', '1049', '1109', '1322', '1366', '1519', '1580', '1632', '1751', '208', '666', '740', '1052', '1148', '1196', '1340', '1368', '1459', '1708', '1723', '1787', '147', '205', '467', '1050', '1051', '1360', '1361', '1362', '1389', '1749', '1791', '93', '559', '703', '920', '1224', '1274', '1294', '1350', '1609', '1649', '1759', '1806', '717', '886', '921', '923', '1020', '1044', '1301', '1339', '1352', '1354', '1674', '1816', '888', '914', '915', '927', '996', '1039', '1072', '1601', '1679', '1805', '479', '916', '926', '930', '931', '1036', '1047', '1664', '1788', '1823', '149', '730', '924', '1468', '1596', '1767', '1854', '152', '965', '1004', '1054', '1075', '1241', '1445', '1486', '1626', '1650', '299', '300', '422', '821')) ORDER BY FIND_IN_SET(id, '1761,1744,732,517,737,1417,726,258,855,1588,780,207,1717,1291,1794,1324,454,1594,1199,874,977,1237,871,1272,1359,1572,974,404,1032,22,461,21,770,1766,330,797,393,1424,1292,1554,1555,716,28,66,521,1682,1348,434,553,349,333,738,332,1423,1677,1419,1422,1134,1420,711,766,1418,1421,857,858,1501,715,1415,265,11,9,792,10,439,1260,739,1205,25,407,585,24,1768,163,455,542,674,1067,1678,657,3,837,1607,1132,1460,503,1008,882,1574,1141,1302,1721,1773,113,520,1402,385,1135,1569,386,986,1742,850,966,1168,63,160,573,1233,1372,1454,1319,1602,610,626,1852,98,1021,1455,285,1373,817,1284,198,352,1822,338,1413,1505,1811,111,480,1398,1411,1676,1259,1410,1193,116,286,547,1733,108,314,768,1738,124,148,526,1088,1320,1323,1579,43,340,883,1437,508,748,970,1108,1308,854,1266,1325,1552,1722,327,390,627,1571,1782,582,590,1145,1575,462,485,1063,1586,1711,348,406,1245,1492,394,944,1028,1724,791,1149,1208,1321,1412,70,119,335,616,405,658,1587,1672,114,162,1027,4,69,704,1463,82,441,545,652,1068,1289,451,678,958,1157,31,34,38,75,351,37,105,722,1461,325,401,1303,1318,1330,78,378,403,601,884,1159,1408,1809,683,1236,1801,201,262,291,341,651,389,644,1139,1188,1367,1526,1853,14,36,580,988,1013,1151,1540,287,1073,1172,1808,123,639,790,818,1019,1037,1326,1327,1820,423,483,635,776,1405,1573,1599,1704,81,266,673,1282,1743,1772,290,796,852,1160,1426,1539,1715,212,1043,1217,1344,45,574,775,968,1040,1223,1474,1716,1730,84,751,1095,1143,1144,1163,1226,1229,1343,1358,1452,1453,1604,324,795,1029,1035,1681,1757,1771,39,1045,1409,30,35,709,1012,1137,1283,1338,1449,905,1048,1152,1647,1663,1740,417,972,1136,1150,1206,1448,1673,151,223,769,885,1025,1090,1483,27,150,643,701,851,1055,253,665,1026,1293,1351,1750,1758,1146,1262,1713,1042,1071,1140,1154,1230,1231,1329,1458,1714,1807,1833,448,453,663,707,784,954,973,1049,1109,1322,1366,1519,1580,1632,1751,208,666,740,1052,1148,1196,1340,1368,1459,1708,1723,1787,147,205,467,1050,1051,1360,1361,1362,1389,1749,1791,93,559,703,920,1224,1274,1294,1350,1609,1649,1759,1806,717,886,921,923,1020,1044,1301,1339,1352,1354,1674,1816,888,914,915,927,996,1039,1072,1601,1679,1805,479,916,926,930,931,1036,1047,1664,1788,1823,149,730,924,1468,1596,1767,1854,152,965,1004,1054,1075,1241,1445,1486,1626,1650,299,300,422,821') 0.073003053665161
(119) DESCRIBE `cruisetypes` 0.0019350051879883
(120) DESCRIBE `destinations` 0.0028629302978516
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '43', '37', '9', '2', '25', '8', '44', '55', '53', '39', '38', '28', '30', '26', '40', '7', '48', '45', '11', '49', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,43,37,9,2,25,8,44,55,53,39,38,28,30,26,40,7,48,45,11,49,21,29,52,34,10,46,56,32') 0.003209114074707