or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

    Harmony G

    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

    Experience Harmony of the Seas®– the third of its kind to join the groundbreaking Oasis class of ships. Harmony of the Seas® will feature the...

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

    Haumana

    As soon as you will board the ship, you will be welcomed with colourful flower lei. You will be immediately charmed by the legendary Polynesian...

    Star Rating Specialty
  • Hebridean Island Cruises
    Hebridean Princess

    Hebridean Princess

    Hebridean Princess is Hebridean's original vessel. Specially commissioned in 1965 for the waters of the rugged west coast of Scotland, she commenced sailing under the...

    Star Rating 5 Star
  • Noble Caledonia
    Hebridean Sky

    Hebridean Sky

    The MS Hebridean Sky is one of our three flag ships and sister vessel to the MS Island Sky and MS Caledonian Sky. All three...

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

# Query Time
(1) connect 0.00057506561279297
(2) DESCRIBE `ships` 0.002338171005249
(3) DESCRIBE `cruiselines` 0.0012588500976562
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 172))) 0.0002899169921875
(5) DESCRIBE `orchid_image` 0.0007469654083252
(6) DESCRIBE `cruiselines` 0.0009310245513916
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '172') 0.00018811225891113
(8) DESCRIBE `ships` 0.0012729167938232
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '730') 0.00018119812011719
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(12) DESCRIBE `avid_specials` 0.00057411193847656
(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.00087594985961914
(14) DESCRIBE `cruiselines` 0.00088095664978027
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 159))) 0.0002140998840332
(16) DESCRIBE `orchid_image` 0.00066995620727539
(17) DESCRIBE `cruiselines` 0.0010180473327637
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '159') 0.00018405914306641
(19) DESCRIBE `ships` 0.001230001449585
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '693') 0.00019407272338867
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017380714416504
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014996528625488
(23) DESCRIBE `avid_specials` 0.00070095062255859
(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.00098013877868652
(25) DESCRIBE `cruiselines` 0.00098299980163574
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00027894973754883
(27) DESCRIBE `orchid_image` 0.0007479190826416
(28) DESCRIBE `cruiselines` 0.00105881690979
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00026416778564453
(30) DESCRIBE `ships` 0.0014560222625732
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '743') 0.00020909309387207
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016188621520996
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016593933105469
(34) DESCRIBE `avid_specials` 0.00061511993408203
(35) 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.0013191699981689
(36) DESCRIBE `cruiselines` 0.0012099742889404
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 90))) 0.00031208992004395
(38) DESCRIBE `orchid_image` 0.0008080005645752
(39) DESCRIBE `cruiselines` 0.00090384483337402
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '90') 0.00020909309387207
(41) DESCRIBE `ships` 0.0016360282897949
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1700') 0.00030803680419922
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021004676818848
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019502639770508
(45) DESCRIBE `avid_specials` 0.00063705444335938
(46) 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.001133918762207
(47) DESCRIBE `cruiselines` 0.00095796585083008
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00027012825012207
(49) DESCRIBE `orchid_image` 0.00085783004760742
(50) DESCRIBE `cruiselines` 0.0010960102081299
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023913383483887
(52) DESCRIBE `ships` 0.0013880729675293
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1323') 0.00022196769714355
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019097328186035
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019192695617676
(56) DESCRIBE `avid_specials` 0.00074410438537598
(57) 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.0014820098876953
(58) DESCRIBE `cruiselines` 0.0010650157928467
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00028777122497559
(60) DESCRIBE `orchid_image` 0.00071597099304199
(61) DESCRIBE `cruiselines` 0.00097894668579102
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00020194053649902
(63) DESCRIBE `ships` 0.0018658638000488
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '744') 0.00025582313537598
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018811225891113
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017905235290527
(67) DESCRIBE `avid_specials` 0.000823974609375
(68) 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.0013711452484131
(69) DESCRIBE `cruiselines` 0.0013108253479004
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00029587745666504
(71) DESCRIBE `orchid_image` 0.0010268688201904
(72) DESCRIBE `cruiselines` 0.001227855682373
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00023388862609863
(74) DESCRIBE `ships` 0.0018908977508545
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1618') 0.00018596649169922
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019502639770508
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017094612121582
(78) DESCRIBE `avid_specials` 0.00058317184448242
(79) 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.0008399486541748
(80) DESCRIBE `cruiselines` 0.0011940002441406
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 275))) 0.00025200843811035
(82) DESCRIBE `orchid_image` 0.001046895980835
(83) DESCRIBE `cruiselines` 0.000946044921875
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '275') 0.00022196769714355
(85) DESCRIBE `ships` 0.0012760162353516
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1639') 0.0002589225769043
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001990795135498
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00014710426330566
(89) DESCRIBE `avid_specials` 0.00078010559082031
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1639 AND class = 'Ship') OR (item_id = 275 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.0013129711151123
(91) DESCRIBE `cruiselines` 0.0010199546813965
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 95))) 0.00022196769714355
(93) DESCRIBE `orchid_image` 0.00067400932312012
(94) DESCRIBE `cruiselines` 0.00081515312194824
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '95') 0.00017905235290527
(96) DESCRIBE `ships` 0.0012998580932617
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '417') 0.00021696090698242
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001528263092041
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014185905456543
(100) DESCRIBE `avid_specials` 0.00058817863464355
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 417 AND class = 'Ship') OR (item_id = 95 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.00085210800170898
(102) DESCRIBE `cruiselines` 0.00089287757873535
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 209))) 0.00026988983154297
(104) DESCRIBE `orchid_image` 0.00084590911865234
(105) DESCRIBE `cruiselines` 0.00099897384643555
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '209') 0.00023698806762695
(107) DESCRIBE `ships` 0.0013070106506348
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1400') 0.00021505355834961
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001990795135498
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018191337585449
(111) DESCRIBE `avid_specials` 0.00072383880615234
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1400 AND class = 'Ship') OR (item_id = 209 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.0013580322265625
(113) DESCRIBE `cruises` 0.0020740032196045
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4424, 11517, 22963, 23463, 24582, 27114, 29015, 34157, 34171, 34192)) ORDER BY FIND_IN_SET(id, '4424,11517,22963,23463,24582,27114,29015,34157,34171,34192') 0.00092482566833496
(115) DESCRIBE `cruiselines` 0.001276969909668
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '26', '19', '183', '77', '23', '7', '18', '20', '144', '8', '12', '171', '221', '120', '232', '101', '103', '96', '50', '208', '29', '37', '15', '206', '131', '91', '156', '204', '220', '33', '24', '28', '256', '36', '110', '114', '268', '258', '16', '191', '181', '187', '174', '195', '141', '211', '118', '47', '153', '14', '262', '30', '49', '216', '239', '35', '238', '151', '168', '196', '4', '146', '212', '249', '159', '115', '229', '136', '170', '225', '108', '209', '240', '140', '275', '59', '73', '180', '269', '88', '219', '276', '184', '248', '213', '52', '38', '182', '264', '132', '188', '90', '57', '113', '261', '244', '82', '95', '200', '230', '39', '231', '48', '62', '116', '236', '64', '266', '119', '235', '223', '177', '257', '263', '105', '245', '134', '224', '251')) ORDER BY FIND_IN_SET(id, '218,26,19,183,77,23,7,18,20,144,8,12,171,221,120,232,101,103,96,50,208,29,37,15,206,131,91,156,204,220,33,24,28,256,36,110,114,268,258,16,191,181,187,174,195,141,211,118,47,153,14,262,30,49,216,239,35,238,151,168,196,4,146,212,249,159,115,229,136,170,225,108,209,240,140,275,59,73,180,269,88,219,276,184,248,213,52,38,182,264,132,188,90,57,113,261,244,82,95,200,230,39,231,48,62,116,236,64,266,119,235,223,177,257,263,105,245,134,224,251') 0.0034859180450439
(117) DESCRIBE `ships` 0.0017609596252441
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '22', '461', '21', '27', '977', '258', '393', '207', '113', '1359', '517', '1272', '439', '974', '1135', '24', '855', '10', '797', '1460', '407', '349', '14', '1581', '1215', '1599', '726', '330', '1067', '25', '265', '731', '859', '770', '452', '739', '585', '780', '405', '520', '766', '462', '28', '542', '817', '1199', '1376', '1291', '792', '1205', '1415', '31', '1032', '30', '36', '38', '39', '378', '791', '34', '35', '37', '1012', '1323', '327', '573', '1285', '1588', '351', '590', '970', '1245', '434', '1348', '526', '454', '553', '1586', '43', '521', '1193', '1614', '1402', '986', '333', '404', '340', '580', '711', '11', '882', '78', '163', '716', '1405', '1176', '1417', '116', '1021', '338', '480', '325', '701', '837', '1382', '1134', '993', '4', '657', '610', '722', '732', '59', '286', '678', '1639', '1455', '82', '124', '765', '857', '683', '253', '503', '850', '1095', '1237', '1284', '1615', '406', '985', '1236', '84', '111', '547', '1168', '441', '1075', '114', '451', '852', '966', '160', '769', '988', '1449', '1501', '1008', '1319', '1373', '5', '45', '1243', '9', '81', '401', '1302', '1383', '1384', '1489', '1628', '639', '1088', '93', '784', '455', '854', '616', '749', '968', '1607', '314', '574', '1141', '1301', '1602', '212', '390', '483', '666', '1109', '75', '348', '885', '996', '1241', '1325', '1372', '1552', '1587', '324', '626', '748', '954', '1320', '1569', '285', '290', '658', '704', '776', '150', '508', '582', '3', '108', '313', '651', '851', '1411', '148', '291', '1027', '1087', '1292', '1574', '119', '669', '1068', '1398', '332', '403', '674', '1505', '652', '1253', '1571', '74', '151', '352', '1139', '1408', '147', '208', '223', '394', '467', '768', '1064', '1308', '1330', '70', '1486', '98', '335', '485', '883', '1413', '1454', '1612', '66', '69', '123', '937', '1260', '1611', '149', '341', '790', '1172', '1355', '262', '775', '938', '944', '1345', '152', '823', '874', '1108', '1145', '1159', '1579', '559', '1017', '1233', '1575', '375', '884', '958', '1157', '1183', '1184', '1326', '1327', '1461', '1613', '162', '665', '1195', '796', '1058', '1149', '105', '287', '738', '1106', '1189', '1224', '1439', '1632', '389', '1011', '1481', '448', '673', '1240', '1262', '1601', '479', '1013', '205', '751', '1410', '1412', '1471', '1526', '204', '715', '1063', '1082', '1132', '1223', '1303', '1492', '288', '635', '717', '1043', '1110', '1143', '1318', '1539', '1545', '1136', '1137', '1344', '1437', '1543', '1594', '1090', '1163', '1274', '1282', '1283', '1343', '1546', '1025', '1144', '1150', '1151', '1160', '1239', '1338', '1367', '1452', '1453', '417', '601', '905', '1322', '1604', '17', '201', '385', '386', '743', '795', '997', '1037', '1073', '1148', '1448', '266', '545', '618', '818', '821', '1217', '1231', '1358', '62', '1321', '1458', '1649', '225', '672', '692', '811', '1026', '1049', '1259', '1289', '1350', '1426', '1463', '1541', '421', '920', '927', '973', '1034', '1040', '1047', '1055', '1140', '1147', '1230', '1257', '1362', '1366', '1368', '1496', '1533', '1538', '1678', '211', '453', '931', '1003', '1004', '1054', '1146', '1154', '1354', '1389', '1508', '1516', '1518', '1558', '1609', '198', '422', '687', '695', '733', '858', '914', '921', '923', '930', '994', '995', '1002', '1019', '1042', '1051', '1152', '1226', '1261', '1351', '1407', '1509', '1521', '1532', '1540', '487', '627', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1470', '1559', '1561', '1593', '1596', '1650', '261', '703', '707', '785', '836', '924', '990', '1048', '1208', '1266', '1445', '1474', '1647', '1697', '420', '504', '671', '761', '798', '1020', '1045', '1092', '1580', '1629')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,22,461,21,27,977,258,393,207,113,1359,517,1272,439,974,1135,24,855,10,797,1460,407,349,14,1581,1215,1599,726,330,1067,25,265,731,859,770,452,739,585,780,405,520,766,462,28,542,817,1199,1376,1291,792,1205,1415,31,1032,30,36,38,39,378,791,34,35,37,1012,1323,327,573,1285,1588,351,590,970,1245,434,1348,526,454,553,1586,43,521,1193,1614,1402,986,333,404,340,580,711,11,882,78,163,716,1405,1176,1417,116,1021,338,480,325,701,837,1382,1134,993,4,657,610,722,732,59,286,678,1639,1455,82,124,765,857,683,253,503,850,1095,1237,1284,1615,406,985,1236,84,111,547,1168,441,1075,114,451,852,966,160,769,988,1449,1501,1008,1319,1373,5,45,1243,9,81,401,1302,1383,1384,1489,1628,639,1088,93,784,455,854,616,749,968,1607,314,574,1141,1301,1602,212,390,483,666,1109,75,348,885,996,1241,1325,1372,1552,1587,324,626,748,954,1320,1569,285,290,658,704,776,150,508,582,3,108,313,651,851,1411,148,291,1027,1087,1292,1574,119,669,1068,1398,332,403,674,1505,652,1253,1571,74,151,352,1139,1408,147,208,223,394,467,768,1064,1308,1330,70,1486,98,335,485,883,1413,1454,1612,66,69,123,937,1260,1611,149,341,790,1172,1355,262,775,938,944,1345,152,823,874,1108,1145,1159,1579,559,1017,1233,1575,375,884,958,1157,1183,1184,1326,1327,1461,1613,162,665,1195,796,1058,1149,105,287,738,1106,1189,1224,1439,1632,389,1011,1481,448,673,1240,1262,1601,479,1013,205,751,1410,1412,1471,1526,204,715,1063,1082,1132,1223,1303,1492,288,635,717,1043,1110,1143,1318,1539,1545,1136,1137,1344,1437,1543,1594,1090,1163,1274,1282,1283,1343,1546,1025,1144,1150,1151,1160,1239,1338,1367,1452,1453,417,601,905,1322,1604,17,201,385,386,743,795,997,1037,1073,1148,1448,266,545,618,818,821,1217,1231,1358,62,1321,1458,1649,225,672,692,811,1026,1049,1259,1289,1350,1426,1463,1541,421,920,927,973,1034,1040,1047,1055,1140,1147,1230,1257,1362,1366,1368,1496,1533,1538,1678,211,453,931,1003,1004,1054,1146,1154,1354,1389,1508,1516,1518,1558,1609,198,422,687,695,733,858,914,921,923,930,994,995,1002,1019,1042,1051,1152,1226,1261,1351,1407,1509,1521,1532,1540,487,627,663,915,916,926,1001,1072,1293,1404,1470,1559,1561,1593,1596,1650,261,703,707,785,836,924,990,1048,1208,1266,1445,1474,1647,1697,420,504,671,761,798,1020,1045,1092,1580,1629') 0.019608020782471
(119) DESCRIBE `cruisetypes` 0.00097489356994629
(120) DESCRIBE `destinations` 0.0013089179992676
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '2', '9', '43', '37', '8', '53', '55', '39', '28', '26', '44', '40', '38', '11', '21', '48', '7', '49', '52', '56', '10', '29', '46', '34', '30', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,2,9,43,37,8,53,55,39,28,26,44,40,38,11,21,48,7,49,52,56,10,29,46,34,30,45,32') 0.001427173614502