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

 
 
 
  • Quark Expeditions
    50 Years of Victory

    50 Years of Victory

    Twenty years in the making, 50 Years of Victory is the first Arktika-class icebreaker to have a spoon-shaped bow. Boosting the efficiency is the all-new...

    Star Rating Specialty
  • A-Rosa Cruises
    A-Rosa Aqua

    A-Rosa Aqua

    The modern cruise ships of A-ROSA offer a lot of open space. At 125 to 135 metres, the ships spend space for various activities and...

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

    A-Rosa Bella

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

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

    A-Rosa Brava

    Cruising on a river is certainly not the fastest mode of transportation. And the countless meanders of the Rhine, Danube and Rhône are not the...

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

    A-Rosa Donna

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Those seeking privacy &...

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

    A-Rosa Flora

    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 Luna

    A-Rosa Luna

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Rhone/Saone. Whether you are seeking for...

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

    A-Rosa Mia

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

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

    A-Rosa Riva

    Whatever you’re looking for on vacation – you will find it on board the A-ROSA river vessels on the Danube. Whether you are seeking for...

    Star Rating River
  • 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
 

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

# Query Time
(1) connect 0.00047492980957031
(2) DESCRIBE `ships` 0.0017309188842773
(3) DESCRIBE `cruiselines` 0.0012161731719971
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 73))) 0.00030207633972168
(5) DESCRIBE `orchid_image` 0.00077295303344727
(6) DESCRIBE `cruiselines` 0.00092697143554688
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '73') 0.00019407272338867
(8) DESCRIBE `ships` 0.0013370513916016
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '758') 0.00019097328186035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020003318786621
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017094612121582
(12) DESCRIBE `avid_specials` 0.00065898895263672
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 758 AND class = 'Ship') OR (item_id = 73 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.00099682807922363
(14) DESCRIBE `cruiselines` 0.00093197822570801
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.0002439022064209
(16) DESCRIBE `orchid_image` 0.00078892707824707
(17) DESCRIBE `cruiselines` 0.00090694427490234
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00019693374633789
(19) DESCRIBE `ships` 0.001284122467041
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1218') 0.00019407272338867
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018787384033203
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(23) DESCRIBE `avid_specials` 0.00060081481933594
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1218 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.00091218948364258
(25) DESCRIBE `cruiselines` 0.0009911060333252
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00026917457580566
(27) DESCRIBE `orchid_image` 0.00075507164001465
(28) DESCRIBE `cruiselines` 0.00094890594482422
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00019979476928711
(30) DESCRIBE `ships` 0.0012650489807129
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1562') 0.0001990795135498
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017786026000977
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017189979553223
(34) DESCRIBE `avid_specials` 0.00060200691223145
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1562 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.00093197822570801
(36) DESCRIBE `cruiselines` 0.00092411041259766
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00023603439331055
(38) DESCRIBE `orchid_image` 0.00073599815368652
(39) DESCRIBE `cruiselines` 0.00089788436889648
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00019598007202148
(41) DESCRIBE `ships` 0.0012290477752686
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1566') 0.00019216537475586
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(45) DESCRIBE `avid_specials` 0.00067281723022461
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1566 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.00089097023010254
(47) DESCRIBE `cruiselines` 0.00091290473937988
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00022196769714355
(49) DESCRIBE `orchid_image` 0.00075697898864746
(50) DESCRIBE `cruiselines` 0.00089192390441895
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00018882751464844
(52) DESCRIBE `ships` 0.0012650489807129
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1268') 0.00020217895507812
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016212463378906
(56) DESCRIBE `avid_specials` 0.00063896179199219
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1268 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.0010747909545898
(58) DESCRIBE `cruiselines` 0.00093317031860352
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00023388862609863
(60) DESCRIBE `orchid_image` 0.00074410438537598
(61) DESCRIBE `cruiselines` 0.00095105171203613
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00018787384033203
(63) DESCRIBE `ships` 0.0012648105621338
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1269') 0.00019001960754395
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019192695617676
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(67) DESCRIBE `avid_specials` 0.00060796737670898
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1269 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.00087499618530273
(69) DESCRIBE `cruiselines` 0.00093507766723633
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00022506713867188
(71) DESCRIBE `orchid_image` 0.00073003768920898
(72) DESCRIBE `cruiselines` 0.00090217590332031
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00018715858459473
(74) DESCRIBE `ships` 0.0012600421905518
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1567') 0.00018692016601562
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024199485778809
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(78) DESCRIBE `avid_specials` 0.00063705444335938
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1567 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.00092101097106934
(80) DESCRIBE `cruiselines` 0.0011179447174072
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00023984909057617
(82) DESCRIBE `orchid_image` 0.00075411796569824
(83) DESCRIBE `cruiselines` 0.00090479850769043
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00019598007202148
(85) DESCRIBE `ships` 0.0014140605926514
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1561') 0.00020503997802734
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016283988952637
(89) DESCRIBE `avid_specials` 0.00060582160949707
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1561 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.00093293190002441
(91) DESCRIBE `cruiselines` 0.00093889236450195
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00022983551025391
(93) DESCRIBE `orchid_image` 0.00074219703674316
(94) DESCRIBE `cruiselines` 0.00095415115356445
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00020694732666016
(96) DESCRIBE `ships` 0.0013160705566406
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1557') 0.00022101402282715
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017786026000977
(100) DESCRIBE `avid_specials` 0.00064182281494141
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1557 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.00094819068908691
(102) DESCRIBE `cruiselines` 0.00095582008361816
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00024700164794922
(104) DESCRIBE `orchid_image` 0.00079798698425293
(105) DESCRIBE `cruiselines` 0.00093913078308105
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.0001981258392334
(107) DESCRIBE `ships` 0.0013129711151123
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1216') 0.00019717216491699
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019717216491699
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016689300537109
(111) DESCRIBE `avid_specials` 0.00060510635375977
(112) 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.00095009803771973
(113) DESCRIBE `cruises` 0.0017499923706055
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (24928, 34159, 38575, 44275, 44276, 46506, 48005, 49176, 49177, 52230)) ORDER BY FIND_IN_SET(id, '24928,34159,38575,44275,44276,46506,48005,49176,49177,52230') 0.00093388557434082
(115) DESCRIBE `cruiselines` 0.0024428367614746
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '26', '19', '183', '77', '7', '18', '144', '23', '12', '171', '20', '221', '8', '120', '101', '232', '103', '96', '208', '29', '15', '206', '131', '91', '50', '156', '37', '33', '204', '220', '24', '28', '256', '110', '36', '16', '191', '258', '268', '181', '114', '187', '174', '141', '195', '262', '14', '47', '239', '211', '30', '49', '118', '153', '216', '35', '196', '168', '238', '151', '146', '140', '4', '212', '249', '159', '240', '170', '115', '108', '225', '229', '136', '73', '209', '59', '275', '38', '180', '88', '269', '184', '219', '248', '264', '276', '188', '182', '213', '132', '200', '113', '57', '230', '82', '261', '39', '62', '244', '95', '137', '231', '236', '52', '48', '116', '223', '64', '119', '266', '235', '257', '105', '177', '245', '263', '31', '134', '224', '172', '237', '251')) ORDER BY FIND_IN_SET(id, '218,26,19,183,77,7,18,144,23,12,171,20,221,8,120,101,232,103,96,208,29,15,206,131,91,50,156,37,33,204,220,24,28,256,110,36,16,191,258,268,181,114,187,174,141,195,262,14,47,239,211,30,49,118,153,216,35,196,168,238,151,146,140,4,212,249,159,240,170,115,108,225,229,136,73,209,59,275,38,180,88,269,184,219,248,264,276,188,182,213,132,200,113,57,230,82,261,39,62,244,95,137,231,236,52,48,116,223,64,119,266,235,257,105,177,245,263,31,134,224,172,237,251') 0.0039961338043213
(117) DESCRIBE `ships` 0.0019969940185547
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '461', '21', '22', '27', '977', '258', '1359', '207', '393', '113', '1272', '517', '974', '407', '439', '24', '797', '1460', '1581', '726', '855', '10', '14', '859', '731', '1215', '330', '452', '1599', '1067', '25', '780', '520', '585', '739', '1376', '1291', '405', '1199', '1205', '553', '462', '766', '1032', '1415', '28', '31', '34', '35', '36', '37', '38', '39', '378', '792', '1012', '521', '817', '30', '791', '327', '454', '1237', '1323', '351', '1135', '1348', '590', '970', '526', '163', '986', '1588', '993', '43', '480', '78', '1586', '11', '1176', '1405', '116', '338', '340', '404', '711', '882', '1245', '1417', '1614', '333', '349', '837', '1382', '716', '701', '657', '732', '610', '59', '503', '770', '857', '1571', '722', '850', '985', '1639', '265', '286', '542', '1134', '1285', '4', '124', '573', '1455', '82', '160', '1095', '1236', '111', '1501', '441', '5', '451', '769', '1021', '1243', '1615', '9', '114', '966', '988', '1168', '1302', '401', '1075', '1402', '1449', '81', '852', '1319', '1373', '1489', '1141', '434', '639', '1241', '1552', '455', '854', '1109', '1383', '1384', '1628', '678', '616', '658', '1087', '1292', '285', '390', '748', '765', '1325', '1372', '212', '704', '749', '1320', '1574', '1607', '150', '406', '1301', '1602', '75', '108', '313', '666', '1088', '253', '582', '996', '1454', '3', '119', '148', '508', '547', '954', '1398', '332', '669', '1284', '1579', '403', '874', '1139', '674', '683', '851', '1411', '652', '1027', '1193', '1253', '1587', '45', '66', '69', '70', '123', '151', '968', '1068', '1308', '1505', '223', '483', '1330', '1408', '147', '394', '574', '768', '776', '823', '1355', '324', '1064', '1601', '74', '325', '352', '784', '790', '885', '1008', '1260', '1486', '149', '467', '944', '314', '775', '1082', '1106', '1108', '152', '262', '335', '626', '883', '1413', '1612', '105', '937', '1183', '1184', '1239', '1611', '93', '162', '1172', '1224', '1345', '375', '938', '1017', '1159', '738', '884', '958', '1145', '290', '348', '389', '559', '1195', '1233', '1481', '1575', '287', '448', '580', '673', '1157', '1326', '1327', '1461', '1613', '715', '1240', '1439', '1471', '1058', '1149', '1526', '1132', '1189', '1318', '1569', '1632', '1011', '1013', '98', '288', '291', '635', '751', '796', '1223', '1410', '1412', '1063', '717', '201', '743', '1043', '1110', '1136', '1343', '1344', '1492', '1545', '84', '385', '479', '485', '651', '1137', '1143', '1282', '1283', '386', '601', '1160', '1208', '1303', '1338', '1437', '1543', '1594', '211', '261', '341', '545', '665', '795', '973', '997', '1090', '1151', '1163', '1274', '1322', '1367', '1452', '1453', '1546', '266', '618', '811', '905', '1025', '1144', '1150', '1289', '62', '417', '453', '1037', '1154', '1217', '1321', '1350', '1358', '1539', '1604', '17', '818', '1148', '1152', '1259', '1448', '225', '692', '821', '1231', '1389', '1426', '1470', '707', '733', '1047', '1257', '1458', '1649', '627', '672', '869', '1026', '1040', '1049', '1073', '1541', '1561', '208', '421', '695', '836', '920', '927', '1019', '1034', '1055', '1140', '1147', '1230', '1261', '1362', '1366', '1368', '1463', '1533', '1538', '1645', '1678', '198', '858', '931', '990', '1003', '1004', '1054', '1071', '1092', '1146', '1266', '1268', '1354', '1407', '1474', '1508', '1516', '1518', '1558', '1609', '205', '422', '487', '687', '785', '914', '921', '923', '930', '994', '995', '1002', '1048', '1051', '1226', '1294', '1351', '1509', '1519', '1521', '1532', '1540', '1562', '663', '786', '915', '916', '926', '1001', '1029', '1045', '1072', '1293', '1404', '1445', '1559', '1596', '1629', '1650', '703', '781', '888', '924', '1028', '1052', '1091')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,461,21,22,27,977,258,1359,207,393,113,1272,517,974,407,439,24,797,1460,1581,726,855,10,14,859,731,1215,330,452,1599,1067,25,780,520,585,739,1376,1291,405,1199,1205,553,462,766,1032,1415,28,31,34,35,36,37,38,39,378,792,1012,521,817,30,791,327,454,1237,1323,351,1135,1348,590,970,526,163,986,1588,993,43,480,78,1586,11,1176,1405,116,338,340,404,711,882,1245,1417,1614,333,349,837,1382,716,701,657,732,610,59,503,770,857,1571,722,850,985,1639,265,286,542,1134,1285,4,124,573,1455,82,160,1095,1236,111,1501,441,5,451,769,1021,1243,1615,9,114,966,988,1168,1302,401,1075,1402,1449,81,852,1319,1373,1489,1141,434,639,1241,1552,455,854,1109,1383,1384,1628,678,616,658,1087,1292,285,390,748,765,1325,1372,212,704,749,1320,1574,1607,150,406,1301,1602,75,108,313,666,1088,253,582,996,1454,3,119,148,508,547,954,1398,332,669,1284,1579,403,874,1139,674,683,851,1411,652,1027,1193,1253,1587,45,66,69,70,123,151,968,1068,1308,1505,223,483,1330,1408,147,394,574,768,776,823,1355,324,1064,1601,74,325,352,784,790,885,1008,1260,1486,149,467,944,314,775,1082,1106,1108,152,262,335,626,883,1413,1612,105,937,1183,1184,1239,1611,93,162,1172,1224,1345,375,938,1017,1159,738,884,958,1145,290,348,389,559,1195,1233,1481,1575,287,448,580,673,1157,1326,1327,1461,1613,715,1240,1439,1471,1058,1149,1526,1132,1189,1318,1569,1632,1011,1013,98,288,291,635,751,796,1223,1410,1412,1063,717,201,743,1043,1110,1136,1343,1344,1492,1545,84,385,479,485,651,1137,1143,1282,1283,386,601,1160,1208,1303,1338,1437,1543,1594,211,261,341,545,665,795,973,997,1090,1151,1163,1274,1322,1367,1452,1453,1546,266,618,811,905,1025,1144,1150,1289,62,417,453,1037,1154,1217,1321,1350,1358,1539,1604,17,818,1148,1152,1259,1448,225,692,821,1231,1389,1426,1470,707,733,1047,1257,1458,1649,627,672,869,1026,1040,1049,1073,1541,1561,208,421,695,836,920,927,1019,1034,1055,1140,1147,1230,1261,1362,1366,1368,1463,1533,1538,1645,1678,198,858,931,990,1003,1004,1054,1071,1092,1146,1266,1268,1354,1407,1474,1508,1516,1518,1558,1609,205,422,487,687,785,914,921,923,930,994,995,1002,1048,1051,1226,1294,1351,1509,1519,1521,1532,1540,1562,663,786,915,916,926,1001,1029,1045,1072,1293,1404,1445,1559,1596,1629,1650,703,781,888,924,1028,1052,1091') 0.021413087844849
(119) DESCRIBE `cruisetypes` 0.0012609958648682
(120) DESCRIBE `destinations` 0.0016069412231445
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '9', '37', '43', '2', '8', '53', '55', '39', '44', '40', '28', '7', '26', '48', '38', '49', '21', '11', '52', '56', '29', '46', '30', '34', '10', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,9,37,43,2,8,53,55,39,44,40,28,7,26,48,38,49,21,11,52,56,29,46,30,34,10,45,32') 0.0016899108886719