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

 
 
 
  • 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
  • P&O International
    Adonia

    Adonia

    The smallest of our eight ships, Adonia offers a delightfully intimate cruising experience. As she carries just 710 guests, Adonia is a very sociable ship,...

    Star Rating 4 Star
  • Royal Caribbean International
    Adventure of the Seas

    Adventure of the Seas

    Royal Caribbean International have taken cruising to a whole new level. Enjoy one-of-a-kind features like an ice-skating rink, the Royal Promenade and a rock-climbing wall...

    Star Rating 4 Star
  • Voyages to Antiquity
    Aegean Odyssey

    Aegean Odyssey

    AEGEAN ODYSSEY is apremium class ship that is being especially rebuilt to cater for cruising in the coastal waters of the central and southern Mediterranean....

    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
  • CroisiEurope
    African Dream

    African Dream

    The African Dream sails on the Chobe river.

    Facilities: panoramic lounge bar restaurant and a large observation deck for an hitherto unseen immersion in nature a...

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

Total elapsed time: 0.1433584690094

# Query Time
(1) connect 0.00047588348388672
(2) DESCRIBE `ships` 0.0016539096832275
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') 0.0059311389923096
(4) connect 0.00041413307189941
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'a') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0056500434875488
(6) DESCRIBE `cruiselines` 0.0011420249938965
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00025391578674316
(8) DESCRIBE `orchid_image` 0.00067901611328125
(9) DESCRIBE `cruiselines` 0.00084900856018066
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00018501281738281
(11) DESCRIBE `ships` 0.001305103302002
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1270') 0.00018000602722168
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017213821411133
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(15) DESCRIBE `avid_specials` 0.00059795379638672
(16) 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.001215934753418
(17) DESCRIBE `cruiselines` 0.0010550022125244
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00024104118347168
(19) DESCRIBE `orchid_image` 0.00068998336791992
(20) DESCRIBE `cruiselines` 0.00086283683776855
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00017690658569336
(22) DESCRIBE `ships` 0.0012319087982178
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1211') 0.00017499923706055
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014686584472656
(26) DESCRIBE `avid_specials` 0.00059986114501953
(27) 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.00097084045410156
(28) DESCRIBE `cruiselines` 0.0011410713195801
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00030112266540527
(30) DESCRIBE `orchid_image` 0.0010099411010742
(31) DESCRIBE `cruiselines` 0.0013179779052734
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00030088424682617
(33) DESCRIBE `ships` 0.0017709732055664
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1213') 0.00025701522827148
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020003318786621
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019311904907227
(37) DESCRIBE `avid_specials` 0.0008242130279541
(38) 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.0010149478912354
(39) DESCRIBE `cruiselines` 0.00098299980163574
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00024104118347168
(41) DESCRIBE `orchid_image` 0.0008690357208252
(42) DESCRIBE `cruiselines` 0.00089693069458008
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.00019288063049316
(44) DESCRIBE `ships` 0.0026710033416748
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.00039196014404297
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026988983154297
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021910667419434
(48) DESCRIBE `avid_specials` 0.00095510482788086
(49) 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.0019450187683105
(50) DESCRIBE `cruiselines` 0.0016469955444336
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213))) 0.00035905838012695
(52) DESCRIBE `orchid_image` 0.0012679100036621
(53) DESCRIBE `cruiselines` 0.0015769004821777
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213') 0.00032687187194824
(55) DESCRIBE `ships` 0.0021929740905762
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022') 0.00032401084899902
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023794174194336
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022697448730469
(59) DESCRIBE `avid_specials` 0.0010049343109131
(60) 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.0018131732940674
(61) DESCRIBE `cruiselines` 0.0013279914855957
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.0002901554107666
(63) DESCRIBE `orchid_image` 0.0008549690246582
(64) DESCRIBE `cruiselines` 0.00092506408691406
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00021696090698242
(66) DESCRIBE `ships` 0.0013439655303955
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1568') 0.00019288063049316
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015902519226074
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014781951904297
(70) DESCRIBE `avid_specials` 0.00099682807922363
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1568 AND class = 'Ship') OR (item_id = 50 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.0015478134155273
(72) DESCRIBE `cruiselines` 0.0013790130615234
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031805038452148
(74) DESCRIBE `orchid_image` 0.00118088722229
(75) DESCRIBE `cruiselines` 0.0015618801116943
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028491020202637
(77) DESCRIBE `ships` 0.0019259452819824
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.00024104118347168
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021219253540039
(81) DESCRIBE `avid_specials` 0.00070095062255859
(82) 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.00098896026611328
(83) DESCRIBE `cruiselines` 0.0010120868682861
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 188))) 0.0002591609954834
(85) DESCRIBE `orchid_image` 0.00078392028808594
(86) DESCRIBE `cruiselines` 0.00094199180603027
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '188') 0.00026702880859375
(88) DESCRIBE `ships` 0.0017428398132324
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '823') 0.00023293495178223
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020289421081543
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016880035400391
(92) DESCRIBE `avid_specials` 0.0007479190826416
(93) 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.0010199546813965
(94) DESCRIBE `cruiselines` 0.0011370182037354
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 134))) 0.0002601146697998
(96) DESCRIBE `orchid_image` 0.00079107284545898
(97) DESCRIBE `cruiselines` 0.0012469291687012
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '134') 0.00022506713867188
(99) DESCRIBE `ships` 0.0014629364013672
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '568') 0.00022387504577637
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017714500427246
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016689300537109
(103) DESCRIBE `avid_specials` 0.00063991546630859
(104) 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.0012400150299072
(105) DESCRIBE `cruiselines` 0.0010249614715576
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022697448730469
(107) DESCRIBE `orchid_image` 0.00080204010009766
(108) DESCRIBE `cruiselines` 0.0009608268737793
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0001978874206543
(110) DESCRIBE `ships` 0.0013689994812012
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1581') 0.00019502639770508
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021600723266602
(114) DESCRIBE `avid_specials` 0.00080108642578125
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1581 AND class = 'Ship') OR (item_id = 144 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.0020089149475098
(116) DESCRIBE `cruises` 0.0031890869140625
(117) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34156, 34163, 34184, 36041, 44275, 44276, 45750, 46038, 46504, 47845)) ORDER BY FIND_IN_SET(id, '34156,34163,34184,36041,44275,44276,45750,46038,46504,47845') 0.0014231204986572
(118) DESCRIBE `cruiselines` 0.001471996307373
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '26', '19', '183', '77', '7', '18', '23', '144', '12', '171', '8', '20', '221', '120', '232', '101', '103', '96', '208', '29', '15', '206', '131', '91', '50', '156', '37', '204', '33', '220', '24', '28', '256', '36', '110', '16', '258', '191', '268', '181', '114', '187', '174', '141', '195', '262', '47', '14', '239', '211', '118', '30', '153', '49', '216', '35', '196', '238', '168', '151', '146', '140', '4', '212', '249', '159', '240', '115', '170', '108', '225', '229', '136', '209', '73', '59', '275', '180', '38', '88', '269', '219', '184', '248', '276', '182', '264', '213', '188', '132', '200', '113', '57', '230', '261', '82', '244', '39', '62', '95', '231', '52', '236', '48', '116', '137', '64', '119', '223', '266', '235', '257', '105', '177', '245', '263', '134', '31', '224', '172', '237', '251')) ORDER BY FIND_IN_SET(id, '218,26,19,183,77,7,18,23,144,12,171,8,20,221,120,232,101,103,96,208,29,15,206,131,91,50,156,37,204,33,220,24,28,256,36,110,16,258,191,268,181,114,187,174,141,195,262,47,14,239,211,118,30,153,49,216,35,196,238,168,151,146,140,4,212,249,159,240,115,170,108,225,229,136,209,73,59,275,180,38,88,269,219,184,248,276,182,264,213,188,132,200,113,57,230,261,82,244,39,62,95,231,52,236,48,116,137,64,119,223,266,235,257,105,177,245,263,134,31,224,172,237,251') 0.0040161609649658
(120) DESCRIBE `ships` 0.0028600692749023
(121) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '461', '22', '21', '27', '977', '258', '1359', '207', '393', '113', '1272', '517', '974', '407', '439', '797', '24', '1460', '855', '1581', '10', '726', '14', '859', '1215', '731', '452', '330', '780', '1599', '1067', '25', '520', '585', '739', '1291', '1376', '405', '553', '1199', '462', '766', '1205', '1032', '1415', '28', '31', '37', '36', '38', '39', '378', '792', '34', '35', '817', '1012', '30', '521', '327', '791', '1323', '1348', '351', '454', '590', '1135', '526', '970', '163', '986', '1588', '43', '78', '480', '993', '1586', '1176', '1405', '11', '116', '340', '1614', '333', '338', '404', '434', '711', '1417', '349', '716', '837', '882', '1245', '1382', '701', '732', '610', '542', '325', '503', '657', '59', '770', '857', '1571', '722', '985', '1237', '1134', '1639', '4', '286', '1285', '265', '124', '573', '1455', '82', '111', '1095', '850', '1236', '160', '683', '1501', '441', '451', '1615', '114', '769', '966', '1021', '1168', '1243', '988', '1302', '1075', '5', '9', '81', '401', '852', '1449', '1319', '1373', '1402', '1489', '45', '1141', '1241', '1552', '455', '639', '1383', '1384', '1628', '854', '968', '1109', '616', '678', '285', '658', '748', '885', '1087', '1292', '1325', '212', '390', '749', '765', '1372', '1607', '324', '704', '1301', '1320', '1574', '1602', '75', '108', '150', '666', '1088', '313', '406', '776', '996', '119', '148', '253', '508', '582', '954', '1398', '1454', '547', '291', '332', '403', '669', '3', '674', '851', '1284', '1411', '874', '1027', '1587', '151', '652', '1068', '1193', '1253', '66', '69', '70', '123', '1308', '1505', '147', '223', '483', '768', '1330', '1408', '74', '394', '574', '1064', '1355', '1601', '352', '790', '1139', '1260', '1486', '467', '1008', '149', '314', '775', '784', '823', '944', '152', '626', '883', '1082', '1106', '1108', '1413', '1579', '1612', '262', '937', '1611', '335', '1172', '1183', '1184', '1345', '93', '162', '375', '938', '1017', '1239', '105', '738', '884', '958', '1145', '1159', '348', '559', '1195', '1233', '1575', '290', '580', '1157', '1326', '1327', '1461', '1481', '1613', '287', '389', '448', '673', '1240', '1439', '715', '1058', '1149', '1471', '1189', '1224', '1526', '1569', '1632', '1011', '1132', '98', '796', '1013', '1412', '288', '635', '751', '1063', '1410', '717', '1043', '1110', '1223', '1492', '201', '479', '651', '743', '1136', '1137', '1143', '1318', '1343', '1344', '1545', '385', '485', '601', '1282', '1283', '1303', '1437', '1543', '1594', '84', '341', '386', '665', '795', '997', '1090', '1160', '1163', '1274', '1338', '1546', '211', '261', '266', '905', '1025', '1144', '1150', '1151', '1208', '1289', '1322', '1367', '1452', '1453', '62', '417', '453', '545', '618', '811', '1037', '1217', '1350', '1358', '1539', '1604', '17', '818', '1148', '1448', '692', '821', '1152', '1231', '1259', '225', '733', '1047', '1257', '1321', '1389', '1426', '1458', '1470', '1649', '627', '672', '707', '1026', '1040', '1049', '1073', '1407', '1541', '208', '421', '695', '836', '869', '920', '927', '973', '1034', '1055', '1140', '1147', '1230', '1362', '1366', '1368', '1533', '1538', '1561', '1678', '198', '858', '931', '1003', '1004', '1019', '1042', '1054', '1092', '1146', '1154', '1261', '1266', '1354', '1463', '1508', '1516', '1518', '1558', '1609', '1645', '422', '487', '687', '914', '921', '923', '930', '990', '994', '995', '1002', '1051', '1071', '1226', '1268', '1351', '1474', '1509', '1519', '1521', '1532', '205', '663', '781', '915', '916', '926', '1001', '1048', '1072', '1293', '1294', '1404', '1540', '1559', '1562', '1596', '1629', '1650', '703', '785', '924', '1045', '1445', '1496', '1647', '204', '420', '504')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,461,22,21,27,977,258,1359,207,393,113,1272,517,974,407,439,797,24,1460,855,1581,10,726,14,859,1215,731,452,330,780,1599,1067,25,520,585,739,1291,1376,405,553,1199,462,766,1205,1032,1415,28,31,37,36,38,39,378,792,34,35,817,1012,30,521,327,791,1323,1348,351,454,590,1135,526,970,163,986,1588,43,78,480,993,1586,1176,1405,11,116,340,1614,333,338,404,434,711,1417,349,716,837,882,1245,1382,701,732,610,542,325,503,657,59,770,857,1571,722,985,1237,1134,1639,4,286,1285,265,124,573,1455,82,111,1095,850,1236,160,683,1501,441,451,1615,114,769,966,1021,1168,1243,988,1302,1075,5,9,81,401,852,1449,1319,1373,1402,1489,45,1141,1241,1552,455,639,1383,1384,1628,854,968,1109,616,678,285,658,748,885,1087,1292,1325,212,390,749,765,1372,1607,324,704,1301,1320,1574,1602,75,108,150,666,1088,313,406,776,996,119,148,253,508,582,954,1398,1454,547,291,332,403,669,3,674,851,1284,1411,874,1027,1587,151,652,1068,1193,1253,66,69,70,123,1308,1505,147,223,483,768,1330,1408,74,394,574,1064,1355,1601,352,790,1139,1260,1486,467,1008,149,314,775,784,823,944,152,626,883,1082,1106,1108,1413,1579,1612,262,937,1611,335,1172,1183,1184,1345,93,162,375,938,1017,1239,105,738,884,958,1145,1159,348,559,1195,1233,1575,290,580,1157,1326,1327,1461,1481,1613,287,389,448,673,1240,1439,715,1058,1149,1471,1189,1224,1526,1569,1632,1011,1132,98,796,1013,1412,288,635,751,1063,1410,717,1043,1110,1223,1492,201,479,651,743,1136,1137,1143,1318,1343,1344,1545,385,485,601,1282,1283,1303,1437,1543,1594,84,341,386,665,795,997,1090,1160,1163,1274,1338,1546,211,261,266,905,1025,1144,1150,1151,1208,1289,1322,1367,1452,1453,62,417,453,545,618,811,1037,1217,1350,1358,1539,1604,17,818,1148,1448,692,821,1152,1231,1259,225,733,1047,1257,1321,1389,1426,1458,1470,1649,627,672,707,1026,1040,1049,1073,1407,1541,208,421,695,836,869,920,927,973,1034,1055,1140,1147,1230,1362,1366,1368,1533,1538,1561,1678,198,858,931,1003,1004,1019,1042,1054,1092,1146,1154,1261,1266,1354,1463,1508,1516,1518,1558,1609,1645,422,487,687,914,921,923,930,990,994,995,1002,1051,1071,1226,1268,1351,1474,1509,1519,1521,1532,205,663,781,915,916,926,1001,1048,1072,1293,1294,1404,1540,1559,1562,1596,1629,1650,703,785,924,1045,1445,1496,1647,204,420,504') 0.030444145202637
(122) DESCRIBE `cruisetypes` 0.0011489391326904
(123) DESCRIBE `destinations` 0.0012340545654297
(124) 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', '11', '49', '21', '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,11,49,21,52,56,29,46,30,34,10,45,32') 0.0014598369598389