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

 
 
 
  • A-Rosa Cruises
    A-Rosa Silva

    A-Rosa Silva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Stella

    A-Rosa Stella

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhône/Saône. Seeking for privacy or cozy...

    Star Rating River
  • A-Rosa Cruises
    A-Rosa Viva

    A-Rosa Viva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA cruise ships on the Rhine. Those seeking privacy & relaxation...

    Star Rating River
  • Assam Bengal Navigation
    ABN Charaidew

    ABN Charaidew

    The "ABN Charaidew" is a 38m long twin-engine steel hulled passenger boat. She was completely stripped down and rebuilt by ABN in 2003 to provide...

    Star Rating River
  • Assam Bengal Navigation
    ABN Rajmahal

    ABN Rajmahal

    Our new ship "ABN Rajmahal", nearing completion in Kolkata, enters service on the Hugli and the Ganges in February 2014. She is 50m long, is...

    Star Rating River
  • Assam Bengal Navigation
    ABN Sukapha

    ABN Sukapha

    Our second ship "ABN Sukapha" joined "ABN Charaidew" in Assam in October 2006. We have respected the fragile environment of the River Brahmaputra and resisted...

    Star Rating River
  • Alaskan Dream Cruises
    Admiralty Dream

    Admiralty Dream

    The Admiralty Dream is perfect for adventure in the wilderness waterways. With its shallow draft and stately pace of cruising, nothing will be missed in...

    Star Rating Specialty
  • Royal Caribbean International
    Adventure of the Seas

    Adventure of the Seas

    This is a Royal Caribbean® favourite upgraded with all-new thrills. Challenge a friend on the twisting, turning waterslides, Cyclone and Typhoon. Catch a perfect wave...

    Star Rating 4 Star
  • Voyages to Antiquity
    Aegean Odyssey

    Aegean Odyssey

    There is a particular pleasure that comes with cruising aboard a smaller ship. Hosting an average of just 350 passengers, Aegean Odyssey is no ‘floating...

    Star Rating 3 Star
  • Affinity Cruises
    Affinity

    Affinity

    Discover the wonders of these areas aboard our comfy vessel where we offer you a personalised nautical experience in a relaxed atmosphere that you only...

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

# Query Time
(1) connect 0.00079607963562012
(2) DESCRIBE `ships` 0.0033118724822998
(3) DESCRIBE `cruiselines` 0.0028409957885742
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00052905082702637
(5) DESCRIBE `orchid_image` 0.00154709815979
(6) DESCRIBE `cruiselines` 0.0023519992828369
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00036287307739258
(8) DESCRIBE `ships` 0.0026929378509521
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1216') 0.00029897689819336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027704238891602
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(12) DESCRIBE `avid_specials` 0.0012738704681396
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1216 AND class = 'Ship') OR (item_id = 239 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.0010058879852295
(14) DESCRIBE `cruiselines` 0.0020060539245605
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00039196014404297
(16) DESCRIBE `orchid_image` 0.001507043838501
(17) DESCRIBE `cruiselines` 0.0020389556884766
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00037598609924316
(19) DESCRIBE `ships` 0.0034849643707275
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1222') 0.00040316581726074
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025296211242676
(23) DESCRIBE `avid_specials` 0.0013089179992676
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222 AND class = 'Ship') OR (item_id = 239 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.0010771751403809
(25) DESCRIBE `cruiselines` 0.0021011829376221
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00046014785766602
(27) DESCRIBE `orchid_image` 0.0019569396972656
(28) DESCRIBE `cruiselines` 0.0018661022186279
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00034308433532715
(30) DESCRIBE `ships` 0.0025360584259033
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1270') 0.00039291381835938
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(34) DESCRIBE `avid_specials` 0.0014359951019287
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1270 AND class = 'Ship') OR (item_id = 239 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.001025915145874
(36) DESCRIBE `cruiselines` 0.0018489360809326
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00049304962158203
(38) DESCRIBE `orchid_image` 0.0015668869018555
(39) DESCRIBE `cruiselines` 0.002615213394165
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.0004279613494873
(41) DESCRIBE `ships` 0.0036289691925049
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1211') 0.0004270076751709
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034594535827637
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027704238891602
(45) DESCRIBE `avid_specials` 0.0016059875488281
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1211 AND class = 'Ship') OR (item_id = 236 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.0016331672668457
(47) DESCRIBE `cruiselines` 0.0025420188903809
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00049495697021484
(49) DESCRIBE `orchid_image` 0.0017459392547607
(50) DESCRIBE `cruiselines` 0.0018789768218994
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00031614303588867
(52) DESCRIBE `ships` 0.0026619434356689
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00034594535827637
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026798248291016
(56) DESCRIBE `avid_specials` 0.0012099742889404
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1213 AND class = 'Ship') OR (item_id = 236 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.0011708736419678
(58) DESCRIBE `cruiselines` 0.001849889755249
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00042510032653809
(60) DESCRIBE `orchid_image` 0.0013778209686279
(61) DESCRIBE `cruiselines` 0.0018777847290039
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00035190582275391
(63) DESCRIBE `ships` 0.0025129318237305
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.00029516220092773
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002598762512207
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025105476379395
(67) DESCRIBE `avid_specials` 0.0011279582977295
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1212 AND class = 'Ship') OR (item_id = 236 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.00095081329345703
(69) DESCRIBE `cruiselines` 0.0017509460449219
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00032401084899902
(71) DESCRIBE `orchid_image` 0.0013887882232666
(72) DESCRIBE `cruiselines` 0.002202033996582
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00032901763916016
(74) DESCRIBE `ships` 0.0032429695129395
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022') 0.0003199577331543
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002739429473877
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028705596923828
(78) DESCRIBE `avid_specials` 0.0012290477752686
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1022 AND class = 'Ship') OR (item_id = 213 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.0010380744934082
(80) DESCRIBE `cruiselines` 0.0018742084503174
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037002563476562
(82) DESCRIBE `orchid_image` 0.0015008449554443
(83) DESCRIBE `cruiselines` 0.0017979145050049
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028300285339355
(85) DESCRIBE `ships` 0.0029079914093018
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.0003659725189209
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(89) DESCRIBE `avid_specials` 0.001568078994751
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 286 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.0017189979553223
(91) DESCRIBE `cruiselines` 0.0025508403778076
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.00033092498779297
(93) DESCRIBE `orchid_image` 0.0014758110046387
(94) DESCRIBE `cruiselines` 0.0019180774688721
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00029301643371582
(96) DESCRIBE `ships` 0.0025708675384521
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00028014183044434
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027704238891602
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025606155395508
(100) DESCRIBE `avid_specials` 0.0011360645294189
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 823 AND class = 'Ship') OR (item_id = 188 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.00099301338195801
(102) DESCRIBE `cruiselines` 0.0018699169158936
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134))) 0.00031805038452148
(104) DESCRIBE `orchid_image` 0.0014259815216064
(105) DESCRIBE `cruiselines` 0.0017709732055664
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134') 0.00028085708618164
(107) DESCRIBE `ships` 0.0025088787078857
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568') 0.00036406517028809
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026702880859375
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025606155395508
(111) DESCRIBE `avid_specials` 0.0011560916900635
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 568 AND class = 'Ship') OR (item_id = 134 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.0014078617095947
(113) DESCRIBE `cruises` 0.0033218860626221
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (13509, 13510, 29952, 34150, 38122, 38147, 40592, 40595, 40988, 41312)) ORDER BY FIND_IN_SET(id, '13509,13510,29952,34150,38122,38147,40592,40595,40988,41312') 0.0016329288482666
(115) DESCRIBE `cruiselines` 0.0029439926147461
(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', '183', '120', '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', '47', '90', '230', '182', '136', '256', '35', '213', '261', '237', '188', '174', '57', '264', '180', '64', '73', '248', '146', '195', '95', '204', '52', '115', '209', '196', '59', '168', '219', '231', '116', '82', '170', '229', '119', '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,183,120,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,47,90,230,182,136,256,35,213,261,237,188,174,57,264,180,64,73,248,146,195,95,204,52,115,209,196,59,168,219,231,116,82,170,229,119,244,134,105,240,276,48,108,275,132,224,210,269') 0.0072078704833984
(117) DESCRIBE `ships` 0.0030679702758789
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '258', '1291', '977', '1359', '454', '1599', '1272', '855', '1237', '986', '404', '1594', '780', '1677', '1067', '1588', '837', '34', '37', '38', '22', '27', '378', '407', '461', '21', '28', '31', '393', '1607', '817', '1135', '1247', '1554', '1555', '1012', '30', '36', '349', '39', '1424', '726', '35', '1422', '462', '1415', '792', '1419', '1423', '585', '882', '1245', '1420', '1176', '1418', '1421', '113', '1215', '1574', '330', '1405', '24', '711', '11', '439', '1744', '9', '10', '265', '766', '455', '452', '542', '1141', '1193', '78', '739', '1572', '69', '81', '635', '124', '674', '3', '1095', '1454', '770', '1008', '1372', '5', '850', '874', '338', '116', '340', '573', '1168', '1471', '580', '1021', '1284', '1569', '553', '43', '70', '405', '1302', '25', '66', '160', '253', '285', '332', '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', '207', '559', '854', '517', '84', '394', '401', '722', '1068', '1208', '1266', '1398', '1492', '1571', '421', '657', '775', '1268', '150', '883', '1236', '1586', '485', '1308', '1672', '114', '403', '704', '1742', '147', '152', '547', '784', '1319', '105', '151', '1064', '1289', '223', '325', '652', '683', '958', '1269', '1724', '123', '149', '262', '348', '715', '1321', '1270', '75', '163', '389', '483', '1243', '1389', '14', '1143', '1159', '1282', '1561', '1330', '1437', '1557', '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', '1602', '82', '201', '673', '1344', '1540', '98', '212', '769', '818', '1063', '1137', '1144', '1303', '1343', '45', '516', '743', '852', '1040', '1160', '1704', '751', '776', '1163', '1217', '1452', '1453', '1604', '701', '1025', '1043', '1090', '1136', '1218', '1283', '1409', '1426', '1566', '1682', '266', '324', '341', '521', '811', '885', '988', '1027', '1157', '1241', '1449', '448', '669', '1253', '1413', '1552', '1632', '1676', '1740', '467', '574', '738', '795', '1019', '1073', '1152', '1223', '1358', '1411', '639', '905', '1226', '1233', '1345', '1376', '1448', '1474', '601', '888', '1150', '1721', '494', '1029', '1145', '1322', '1647', '74', '417', '997', '1055', '1229', '1408', '1458', '1716', '1026', '1188', '1463', '1580', '618', '709', '836', '1149', '1231', '1351', '1366', '1410', '1489', '1496', '1505', '1619', '1663', '205', '208', '352', '666', '954', '973', '1034', '1047', '1222', '1713', '1715', '204', '423', '493', '610', '996', '1049', '1230', '1444', '1516', '1714', '643', '851', '1154', '1262', '1362', '1368', '1407', '1609', '1673', '1743', '663', '859', '920', '927', '1017', '1285', '1404', '1567', '1606', '499', '703', '921', '931', '1004', '1020', '1037', '1187', '1196', '1354', '1360', '1361', '1459', '1470', '1508', '1627', '731', '914', '923', '1042', '1175', '1518', '503', '915', '916', '926', '930', '1003', '1045', '1072', '1106', '1138', '1412', '1486', '1517', '1521', '422', '479', '781', '924', '972', '1092', '1254', '1352', '1522', '1596', '1708', '1751', '17', '671', '1001', '1051', '1091', '1240', '1593', '1723', '453', '656', '665', '938', '1005', '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,1237,986,404,1594,780,1677,1067,1588,837,34,37,38,22,27,378,407,461,21,28,31,393,1607,817,1135,1247,1554,1555,1012,30,36,349,39,1424,726,35,1422,462,1415,792,1419,1423,585,882,1245,1420,1176,1418,1421,113,1215,1574,330,1405,24,711,11,439,1744,9,10,265,766,455,452,542,1141,1193,78,739,1572,69,81,635,124,674,3,1095,1454,770,1008,1372,5,850,874,338,116,340,573,1168,1471,580,1021,1284,1569,553,43,70,405,1302,25,66,160,253,285,332,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,207,559,854,517,84,394,401,722,1068,1208,1266,1398,1492,1571,421,657,775,1268,150,883,1236,1586,485,1308,1672,114,403,704,1742,147,152,547,784,1319,105,151,1064,1289,223,325,652,683,958,1269,1724,123,149,262,348,715,1321,1270,75,163,389,483,1243,1389,14,1143,1159,1282,1561,1330,1437,1557,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,1602,82,201,673,1344,1540,98,212,769,818,1063,1137,1144,1303,1343,45,516,743,852,1040,1160,1704,751,776,1163,1217,1452,1453,1604,701,1025,1043,1090,1136,1218,1283,1409,1426,1566,1682,266,324,341,521,811,885,988,1027,1157,1241,1449,448,669,1253,1413,1552,1632,1676,1740,467,574,738,795,1019,1073,1152,1223,1358,1411,639,905,1226,1233,1345,1376,1448,1474,601,888,1150,1721,494,1029,1145,1322,1647,74,417,997,1055,1229,1408,1458,1716,1026,1188,1463,1580,618,709,836,1149,1231,1351,1366,1410,1489,1496,1505,1619,1663,205,208,352,666,954,973,1034,1047,1222,1713,1715,204,423,493,610,996,1049,1230,1444,1516,1714,643,851,1154,1262,1362,1368,1407,1609,1673,1743,663,859,920,927,1017,1285,1404,1567,1606,499,703,921,931,1004,1020,1037,1187,1196,1354,1360,1361,1459,1470,1508,1627,731,914,923,1042,1175,1518,503,915,916,926,930,1003,1045,1072,1106,1138,1412,1486,1517,1521,422,479,781,924,972,1092,1254,1352,1522,1596,1708,1751,17,671,1001,1051,1091,1240,1593,1723,453,656,665,938,1005,1054,1148,1445,1514,1729,420,672,937,1684,1002,1052,1601,1679,1681,1697') 0.052000999450684
(119) DESCRIBE `cruisetypes` 0.0018119812011719
(120) DESCRIBE `destinations` 0.0021851062774658
(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.0019600391387939