or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Movenpick Nile Cruises
    Hamees

    Hamees

    The Mövenpick MS Hamees has a comfortable and contemporary design and is among the largest and best-appointed crafts on the river Nile. Enjoy a truly...

    Star Rating River
  • Hapag-Lloyd Cruises
    Hanseatic

    Hanseatic

    Genuine adventures and exceptional comfort – on the HANSEATIC, what discoverers of former times could only dream of becomes a reality. The only expedition ship...

    Star Rating 5 Star
  • Hapag-Lloyd Cruises
    Hanseatic Inspiration

    Hanseatic Inspiration

    The HANSEATIC inspiration will be an international ship, with all cruises conducted in both English and German.

    The new expedition class, a mixture of adventures and...

    Star Rating 5 Star
  • Hapag-Lloyd Cruises
    Hanseatic Nature

    Hanseatic Nature

    Please note: The HANSEATIC nature will be a German-speaking ship, with all cruises conducted in German only.

    The new expedition class, a mixture of adventures...

    Star Rating 5 Star
  • Variety Cruises
    Harmony G

    Harmony G

    The Harmony "G" is a modern vessel with a sleek high-tech look very similar to the private yachts to be found in the famous ports...

    Star Rating Specialty
  • Peregrine Adventure Cruising
    Harmony G At Peregrine

    Harmony G At Peregrine

    With its sleek high-tech look and state-of-the-art engine technology, the Harmony G is similar to the private yachts found in the famous ports of the...

    Star Rating Specialty
  • Royal Caribbean International
    Harmony of the Seas

    Harmony of the Seas

    Introducing the Harmony of the Seas®. The world's biggest ship with the world's best features just got even better. There's no turning back once you...

    Star Rating Not Rated
  • Variety Cruises
    Harmony V

    Harmony V

    The Harmony V is a modern elegant yacht with a sleek high-tech look very similar to the private yachts to be found in the famous...

    Star Rating Specialty
  • Lindblad Expeditions
    Harmony V

    Harmony V

    Harmony V provides an ideal way to explore Cuba’s coast. The ship is fully air-conditioned. Part of the Sun Deck is enclosed, and serves as...

    Star Rating Specialty
  • Peregrine Adventure Cruising
    Harmony V at Peregrine

    Harmony V at Peregrine

    With this ship, you’ll be forgiven for thinking you’ve stepped aboard a private yacht of the rich and famous. The Harmony V is a 55-metre...

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

Total elapsed time: 0.31835269927979

# Query Time
(1) connect 0.0013740062713623
(2) DESCRIBE `ships` 0.0046610832214355
(3) DESCRIBE `cruiselines` 0.0032021999359131
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 172))) 0.0009000301361084
(5) DESCRIBE `orchid_image` 0.0024850368499756
(6) DESCRIBE `cruiselines` 0.0029468536376953
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '172') 0.0006711483001709
(8) DESCRIBE `ships` 0.012553930282593
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '730') 0.00056099891662598
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035500526428223
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035381317138672
(12) DESCRIBE `avid_specials` 0.0018610954284668
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 730 AND class = 'Ship') OR (item_id = 172 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.002249002456665
(14) DESCRIBE `cruiselines` 0.00313401222229
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 159))) 0.00056886672973633
(16) DESCRIBE `orchid_image` 0.0021660327911377
(17) DESCRIBE `cruiselines` 0.0050039291381836
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '159') 0.00092196464538574
(19) DESCRIBE `ships` 0.0047190189361572
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '693') 0.00045895576477051
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034189224243164
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032377243041992
(23) DESCRIBE `avid_specials` 0.0017890930175781
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 693 AND class = 'Ship') OR (item_id = 159 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.0018329620361328
(25) DESCRIBE `cruiselines` 0.0028631687164307
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 159))) 0.00053691864013672
(27) DESCRIBE `orchid_image` 0.0020301342010498
(28) DESCRIBE `cruiselines` 0.0025780200958252
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '159') 0.00045394897460938
(30) DESCRIBE `ships` 0.0036079883575439
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1707') 0.00051403045654297
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034785270690918
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035190582275391
(34) DESCRIBE `avid_specials` 0.0018360614776611
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1707 AND class = 'Ship') OR (item_id = 159 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.0020239353179932
(36) DESCRIBE `cruiselines` 0.0027530193328857
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 159))) 0.00066304206848145
(38) DESCRIBE `orchid_image` 0.0021109580993652
(39) DESCRIBE `cruiselines` 0.0029950141906738
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '159') 0.0005180835723877
(41) DESCRIBE `ships` 0.0039701461791992
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1706') 0.00057411193847656
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035405158996582
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034213066101074
(45) DESCRIBE `avid_specials` 0.0017471313476562
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1706 AND class = 'Ship') OR (item_id = 159 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.0017020702362061
(47) DESCRIBE `cruiselines` 0.0028181076049805
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.0005490779876709
(49) DESCRIBE `orchid_image` 0.0022189617156982
(50) DESCRIBE `cruiselines` 0.0032908916473389
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00050806999206543
(52) DESCRIBE `ships` 0.0039279460906982
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '743') 0.00055599212646484
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003509521484375
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033307075500488
(56) DESCRIBE `avid_specials` 0.0016849040985107
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 743 AND class = 'Ship') OR (item_id = 141 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.001575231552124
(58) DESCRIBE `cruiselines` 0.0031900405883789
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 90))) 0.00061821937561035
(60) DESCRIBE `orchid_image` 0.0020790100097656
(61) DESCRIBE `cruiselines` 0.0028350353240967
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '90') 0.00063180923461914
(63) DESCRIBE `ships` 0.0045678615570068
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1700') 0.00060582160949707
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035285949707031
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036001205444336
(67) DESCRIBE `avid_specials` 0.0017979145050049
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1700 AND class = 'Ship') OR (item_id = 90 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.0019121170043945
(69) DESCRIBE `cruiselines` 0.0029218196868896
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00060892105102539
(71) DESCRIBE `orchid_image` 0.0021548271179199
(72) DESCRIBE `cruiselines` 0.0029609203338623
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00053215026855469
(74) DESCRIBE `ships` 0.0044848918914795
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1323') 0.00065803527832031
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00038599967956543
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034499168395996
(78) DESCRIBE `avid_specials` 0.0018930435180664
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1323 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.0017879009246826
(80) DESCRIBE `cruiselines` 0.0029177665710449
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00061488151550293
(82) DESCRIBE `orchid_image` 0.0028889179229736
(83) DESCRIBE `cruiselines` 0.0028910636901855
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00046896934509277
(85) DESCRIBE `ships` 0.0041871070861816
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '744') 0.00057005882263184
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038790702819824
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040507316589355
(89) DESCRIBE `avid_specials` 0.0017199516296387
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 744 AND class = 'Ship') OR (item_id = 141 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.00211501121521
(91) DESCRIBE `cruiselines` 0.0027930736541748
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00050687789916992
(93) DESCRIBE `orchid_image` 0.0023899078369141
(94) DESCRIBE `cruiselines` 0.0030739307403564
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00053215026855469
(96) DESCRIBE `ships` 0.0038321018218994
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1618') 0.00055694580078125
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036406517028809
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038599967956543
(100) DESCRIBE `avid_specials` 0.00177001953125
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1618 AND class = 'Ship') OR (item_id = 110 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
(102) DESCRIBE `cruiselines` 0.003242015838623
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 90))) 0.00063705444335938
(104) DESCRIBE `orchid_image` 0.0021378993988037
(105) DESCRIBE `cruiselines` 0.0026600360870361
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '90') 0.00046300888061523
(107) DESCRIBE `ships` 0.0058271884918213
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1734') 0.00056219100952148
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036191940307617
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034403800964355
(111) DESCRIBE `avid_specials` 0.0018119812011719
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1734 AND class = 'Ship') OR (item_id = 90 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.0018160343170166
(113) DESCRIBE `cruises` 0.0040240287780762
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4424, 11516, 21383, 22963, 24925, 27115, 29065, 29591, 29609, 34155)) ORDER BY FIND_IN_SET(id, '4424,11516,21383,22963,24925,27115,29065,29591,29609,34155') 0.0018281936645508
(115) DESCRIBE `cruiselines` 0.0029950141906738
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '7', '12', '23', '171', '20', '18', '144', '31', '101', '8', '131', '96', '239', '29', '15', '191', '120', '183', '103', '50', '206', '91', '16', '262', '221', '33', '24', '28', '114', '110', '268', '156', '37', '208', '141', '14', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '212', '4', '36', '232', '225', '238', '140', '184', '249', '159', '113', '90', '47', '230', '182', '136', '213', '256', '261', '35', '237', '188', '174', '57', '180', '64', '264', '73', '248', '146', '195', '95', '52', '115', '204', '209', '59', '168', '196', '219', '231', '116', '82', '229', '119', '170', '244', '134', '105', '240', '276', '48', '108', '275', '132', '224', '210', '269')) ORDER BY FIND_IN_SET(id, '218,19,77,26,7,12,23,171,20,18,144,31,101,8,131,96,239,29,15,191,120,183,103,50,206,91,16,262,221,33,24,28,114,110,268,156,37,208,141,14,187,153,118,49,151,211,30,258,216,181,88,212,4,36,232,225,238,140,184,249,159,113,90,47,230,182,136,213,256,261,35,237,188,174,57,180,64,264,73,248,146,195,95,52,115,204,209,59,168,196,219,231,116,82,229,119,170,244,134,105,240,276,48,108,275,132,224,210,269') 0.0070271492004395
(117) DESCRIBE `ships` 0.0047769546508789
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '258', '1291', '977', '1359', '454', '1599', '1272', '855', '986', '1237', '404', '1594', '780', '1677', '1067', '1588', '837', '37', '38', '34', '22', '27', '378', '461', '21', '28', '407', '31', '393', '1607', '817', '1135', '1247', '1554', '1555', '1012', '30', '36', '349', '39', '1424', '726', '35', '1422', '462', '1415', '792', '1423', '585', '882', '1245', '1419', '1420', '1421', '1176', '1418', '1215', '1574', '113', '330', '1405', '24', '711', '11', '439', '1744', '9', '10', '265', '766', '455', '452', '542', '1141', '1193', '78', '739', '81', '635', '1572', '69', '124', '674', '3', '1095', '1454', '770', '1008', '1372', '5', '850', '874', '338', '116', '340', '573', '1168', '580', '1471', '1021', '1569', '553', '1284', '43', '70', '1302', '25', '66', '160', '253', '285', '332', '405', '716', '1402', '148', '451', '658', '944', '1678', '111', '390', '1562', '4', '748', '1172', '386', '520', '797', '966', '1259', '1260', '1460', '385', '626', '791', '1320', '1323', '406', '1455', '974', '1088', '1108', '1325', '286', '314', '678', '351', '590', '768', '582', '970', '1195', '1373', '1575', '63', '119', '327', '434', '508', '526', '108', '335', '375', '616', '993', '1587', '559', '854', '207', '84', '394', '401', '722', '1208', '1266', '517', '1398', '1492', '1571', '657', '775', '1068', '1268', '150', '421', '1236', '1586', '485', '1308', '1672', '114', '403', '704', '1742', '147', '152', '547', '784', '883', '105', '151', '1064', '1289', '1319', '223', '325', '652', '683', '958', '1269', '1724', '123', '149', '262', '348', '715', '1321', '1270', '75', '163', '389', '483', '1243', '1389', '1143', '1159', '1282', '1561', '1330', '1437', '1557', '14', '441', '1013', '1526', '1579', '1711', '287', '717', '1139', '1151', '1214', '1326', '1327', '1348', '162', '333', '545', '790', '796', '1367', '1722', '290', '732', '823', '1216', '1301', '1539', '1717', '93', '651', '1738', '291', '884', '968', '1075', '1318', '201', '673', '1540', '1602', '82', '98', '212', '769', '818', '1063', '1137', '1144', '1303', '1344', '45', '516', '743', '852', '1040', '1160', '1343', '1704', '751', '776', '1163', '1217', '1452', '1453', '1604', '701', '1043', '1218', '1283', '1409', '1426', '1566', '1682', '266', '324', '341', '521', '811', '885', '988', '1025', '1027', '1090', '1136', '1157', '1241', '1449', '448', '669', '1253', '1413', '1552', '1632', '1676', '1740', '467', '574', '738', '795', '1019', '1073', '1223', '1358', '1411', '639', '905', '1152', '1226', '1233', '1345', '1376', '1448', '1474', '601', '888', '1150', '1721', '494', '1029', '1145', '1647', '74', '417', '997', '1055', '1229', '1322', '1408', '1458', '1716', '1026', '1188', '1580', '618', '709', '836', '1149', '1231', '1351', '1410', '1463', '1489', '1496', '1505', '1619', '1663', '205', '208', '666', '954', '973', '1034', '1047', '1222', '1366', '1713', '1715', '204', '352', '423', '493', '610', '996', '1049', '1230', '1714', '643', '851', '1154', '1262', '1362', '1368', '1407', '1444', '1516', '1609', '1673', '1743', '663', '920', '927', '1017', '1404', '1567', '1606', '499', '703', '921', '931', '1004', '1020', '1037', '1187', '1196', '1285', '1354', '1360', '1361', '1459', '1470', '1508', '1627', '731', '859', '914', '923', '1042', '1175', '1518', '503', '915', '916', '926', '930', '1003', '1045', '1072', '1106', '1138', '1486', '1517', '1521', '422', '479', '781', '924', '972', '1092', '1254', '1352', '1412', '1522', '1596', '1708', '1751', '17', '671', '1001', '1091', '1240', '1593', '1723', '453', '656', '665', '938', '1005', '1051', '1054', '1148', '1445', '1514', '1729', '420', '672', '937', '1684', '1002', '1052', '1601', '1679', '1681', '1697')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,258,1291,977,1359,454,1599,1272,855,986,1237,404,1594,780,1677,1067,1588,837,37,38,34,22,27,378,461,21,28,407,31,393,1607,817,1135,1247,1554,1555,1012,30,36,349,39,1424,726,35,1422,462,1415,792,1423,585,882,1245,1419,1420,1421,1176,1418,1215,1574,113,330,1405,24,711,11,439,1744,9,10,265,766,455,452,542,1141,1193,78,739,81,635,1572,69,124,674,3,1095,1454,770,1008,1372,5,850,874,338,116,340,573,1168,580,1471,1021,1569,553,1284,43,70,1302,25,66,160,253,285,332,405,716,1402,148,451,658,944,1678,111,390,1562,4,748,1172,386,520,797,966,1259,1260,1460,385,626,791,1320,1323,406,1455,974,1088,1108,1325,286,314,678,351,590,768,582,970,1195,1373,1575,63,119,327,434,508,526,108,335,375,616,993,1587,559,854,207,84,394,401,722,1208,1266,517,1398,1492,1571,657,775,1068,1268,150,421,1236,1586,485,1308,1672,114,403,704,1742,147,152,547,784,883,105,151,1064,1289,1319,223,325,652,683,958,1269,1724,123,149,262,348,715,1321,1270,75,163,389,483,1243,1389,1143,1159,1282,1561,1330,1437,1557,14,441,1013,1526,1579,1711,287,717,1139,1151,1214,1326,1327,1348,162,333,545,790,796,1367,1722,290,732,823,1216,1301,1539,1717,93,651,1738,291,884,968,1075,1318,201,673,1540,1602,82,98,212,769,818,1063,1137,1144,1303,1344,45,516,743,852,1040,1160,1343,1704,751,776,1163,1217,1452,1453,1604,701,1043,1218,1283,1409,1426,1566,1682,266,324,341,521,811,885,988,1025,1027,1090,1136,1157,1241,1449,448,669,1253,1413,1552,1632,1676,1740,467,574,738,795,1019,1073,1223,1358,1411,639,905,1152,1226,1233,1345,1376,1448,1474,601,888,1150,1721,494,1029,1145,1647,74,417,997,1055,1229,1322,1408,1458,1716,1026,1188,1580,618,709,836,1149,1231,1351,1410,1463,1489,1496,1505,1619,1663,205,208,666,954,973,1034,1047,1222,1366,1713,1715,204,352,423,493,610,996,1049,1230,1714,643,851,1154,1262,1362,1368,1407,1444,1516,1609,1673,1743,663,920,927,1017,1404,1567,1606,499,703,921,931,1004,1020,1037,1187,1196,1285,1354,1360,1361,1459,1470,1508,1627,731,859,914,923,1042,1175,1518,503,915,916,926,930,1003,1045,1072,1106,1138,1486,1517,1521,422,479,781,924,972,1092,1254,1352,1412,1522,1596,1708,1751,17,671,1001,1091,1240,1593,1723,453,656,665,938,1005,1051,1054,1148,1445,1514,1729,420,672,937,1684,1002,1052,1601,1679,1681,1697') 0.084872007369995
(119) DESCRIBE `cruisetypes` 0.0018401145935059
(120) DESCRIBE `destinations` 0.0050461292266846
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '55', '39', '38', '28', '7', '40', '26', '30', '48', '11', '21', '29', '45', '49', '56', '44', '10', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,55,39,38,28,7,40,26,30,48,11,21,29,45,49,56,44,10,34,52,46,32') 0.0031411647796631