or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  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

 
 
 
  • American Queen Steamboat Company
    American Empress

    American Empress

    Proudly serving as the largest overnight riverboat west of the Mississippi River, the American Empress delivers classic elegance and modern luxury on a grand...

    Star Rating River
  • American Cruise Lines
    American Glory

    American Glory

    The America Glory offers discerning travelers the most unique and modern style of small ship cruising. Each unique and off-the-beaten path port visited gives guests...

    Star Rating 2 Star
  • American Cruise Lines
    American Pride

    American Pride

    American Pride (previously Queen of the Mississippi) offers an unparalleled experience never before available on the Columbia and Snake Rivers. Aboard American Pride, guests will...

    Star Rating River
  • American Queen Steamboat Company
    American Queen

    American Queen

    The largest steamboat ever built, the grand American Queen is a gracious and elegant triumph of American ingenuity.

    Although filled with today’s modern amenities, her rooms...

    Star Rating 4 Star
  • American Cruise Lines
    American Song

    American Song

    With a capacity of 190 guests, the new line of modern riverboats from American Cruise Lines were developed to exceed all guest expectations. Carefully crafted,...

    Star Rating River
  • American Cruise Lines
    American Spirit

    American Spirit

    Small ship cruising with American Cruise Lines is not like cruising on a mega-ship for days on the open sea. Small ships, like the American...

    Star Rating 2 Star
  • American Cruise Lines
    American Star

    American Star

    American Star entered service in June 2007. Similar to the American Spirit, it will offer guests the same unique style of cruising that has become...

    Star Rating 2 Star
  • Holland America Line
    Amsterdam

    Amsterdam

    The ms Amsterdam is the third ship to bear the name of the Dutch capital in Holland America Line's over 135-year history. Built at the...

    Star Rating 5 Star
     
    VIEW & VERANDAH Move up, get more - Upgrade Event Book selected 2018/19 Cruises or Land+Sea journeys and receive stateroom upgrades, on board credit and discounts off shore excursions. T&C's apply.
  • Pandaw Cruises
    Anakonda

    Anakonda

    The Anakonda Amazon River Cruise is the only luxury ship in the Ecuadorian Amazon Rainforest. It was built to make the experience of the Amazon...

    Star Rating River
  • Anakonda Amazon Cruises
    Anakonda

    Anakonda

    The Anakonda Amazon River Cruise is the only luxury ship in the Ecuadorian Amazon Rainforest. It was built to make the experience of the Amazon...

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

# Query Time
(1) connect 0.00056600570678711
(2) DESCRIBE `ships` 0.0021641254425049
(3) DESCRIBE `cruiselines` 0.0013258457183838
(4) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033712387084961
(5) DESCRIBE `orchid_image` 0.00079798698425293
(6) DESCRIBE `cruiselines` 0.0017118453979492
(7) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00026202201843262
(8) DESCRIBE `ships` 0.001878023147583
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.0002739429473877
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021195411682129
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020289421081543
(12) DESCRIBE `avid_specials` 0.00067400932312012
(13) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1163 AND class = 'Ship') OR (item_id = 212 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.0010499954223633
(14) DESCRIBE `cruiselines` 0.00090408325195312
(15) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00021696090698242
(16) DESCRIBE `orchid_image` 0.00070095062255859
(17) DESCRIBE `cruiselines` 0.0015349388122559
(18) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00029087066650391
(19) DESCRIBE `ships` 0.0022408962249756
(20) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '466') 0.00037312507629395
(21) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00023412704467773
(22) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00021004676818848
(23) DESCRIBE `avid_specials` 0.0010190010070801
(24) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 466 AND class = 'Ship') OR (item_id = 103 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.0016579627990723
(25) DESCRIBE `cruiselines` 0.0014917850494385
(26) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00032997131347656
(27) DESCRIBE `orchid_image` 0.0010559558868408
(28) DESCRIBE `cruiselines` 0.00094509124755859
(29) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00020194053649902
(30) DESCRIBE `ships` 0.0020549297332764
(31) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '954') 0.00028204917907715
(32) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020408630371094
(33) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020194053649902
(34) DESCRIBE `avid_specials` 0.00088000297546387
(35) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 954 AND class = 'Ship') OR (item_id = 103 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.0011811256408691
(36) DESCRIBE `cruiselines` 0.0010271072387695
(37) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00027799606323242
(38) DESCRIBE `orchid_image` 0.00080990791320801
(39) DESCRIBE `cruiselines` 0.00091695785522461
(40) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00024294853210449
(41) DESCRIBE `ships` 0.0013101100921631
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00018620491027832
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001521110534668
(45) DESCRIBE `avid_specials` 0.00070405006408691
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1013 AND class = 'Ship') OR (item_id = 212 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.00085902214050293
(47) DESCRIBE `cruiselines` 0.00098919868469238
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00022697448730469
(49) DESCRIBE `orchid_image` 0.00075292587280273
(50) DESCRIBE `cruiselines` 0.0009918212890625
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00019192695617676
(52) DESCRIBE `ships` 0.001209020614624
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1632') 0.00018191337585449
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016188621520996
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019311904907227
(56) DESCRIBE `avid_specials` 0.00063920021057129
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1632 AND class = 'Ship') OR (item_id = 103 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.00094103813171387
(58) DESCRIBE `cruiselines` 0.0013349056243896
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00025296211242676
(60) DESCRIBE `orchid_image` 0.0009150505065918
(61) DESCRIBE `cruiselines` 0.00092291831970215
(62) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00020694732666016
(63) DESCRIBE `ships` 0.0014350414276123
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '467') 0.00029802322387695
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00016689300537109
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00015091896057129
(67) DESCRIBE `avid_specials` 0.00068807601928711
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 467 AND class = 'Ship') OR (item_id = 103 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.00083708763122559
(69) DESCRIBE `cruiselines` 0.00099301338195801
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00024604797363281
(71) DESCRIBE `orchid_image` 0.00082802772521973
(72) DESCRIBE `cruiselines` 0.0015740394592285
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00030279159545898
(74) DESCRIBE `ships` 0.0017721652984619
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '639') 0.00026106834411621
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00020098686218262
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00018095970153809
(78) DESCRIBE `avid_specials` 0.00079703330993652
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 639 AND class = 'Ship') OR (item_id = 103 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.00136399269104
(80) DESCRIBE `cruiselines` 0.0012869834899902
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00032401084899902
(82) DESCRIBE `orchid_image` 0.0011470317840576
(83) DESCRIBE `cruiselines` 0.0011820793151855
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00025105476379395
(85) DESCRIBE `ships` 0.0014340877532959
(86) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '74') 0.00023698806762695
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016498565673828
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001838207244873
(89) DESCRIBE `avid_specials` 0.00069618225097656
(90) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74 AND class = 'Ship') OR (item_id = 18 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.00093913078308105
(91) DESCRIBE `cruiselines` 0.0013899803161621
(92) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00028181076049805
(93) DESCRIBE `orchid_image` 0.00079512596130371
(94) DESCRIBE `cruiselines` 0.0009620189666748
(95) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00022315979003906
(96) DESCRIBE `ships` 0.0018501281738281
(97) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1473') 0.00030303001403809
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020289421081543
(99) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(100) DESCRIBE `avid_specials` 0.00071883201599121
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1473 AND class = 'Ship') OR (item_id = 120 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.0013999938964844
(102) DESCRIBE `cruiselines` 0.001291036605835
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 225))) 0.00032401084899902
(104) DESCRIBE `orchid_image` 0.00096607208251953
(105) DESCRIBE `cruiselines` 0.0011670589447021
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '225') 0.00024890899658203
(107) DESCRIBE `ships` 0.002269983291626
(108) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1176') 0.00029683113098145
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019502639770508
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018191337585449
(111) DESCRIBE `avid_specials` 0.00082492828369141
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1176 AND class = 'Ship') OR (item_id = 225 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.0015900135040283
(113) DESCRIBE `cruises` 0.0018959045410156
(114) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34157, 34171, 34192, 38802, 41031, 44275, 44276, 49176, 49177, 49599)) ORDER BY FIND_IN_SET(id, '34157,34171,34192,38802,41031,44275,44276,49176,49177,49599') 0.00084686279296875
(115) DESCRIBE `cruiselines` 0.0016720294952393
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '171', '19', '183', '31', '23', '20', '7', '18', '144', '8', '12', '221', '101', '120', '103', '232', '96', '208', '50', '29', '37', '206', '15', '131', '28', '91', '33', '156', '204', '220', '256', '24', '262', '36', '268', '114', '258', '110', '212', '191', '38', '16', '181', '187', '211', '118', '153', '174', '195', '141', '14', '47', '49', '239', '216', '30', '213', '151', '35', '238', '168', '196', '249', '159', '4', '146', '136', '209', '229', '140', '170', '225', '275', '59', '108', '115', '113', '180', '73', '269', '264', '240', '88', '219', '276', '57', '52', '188', '248', '182', '184', '132', '90', '261', '237', '244', '95', '82', '231', '116', '230', '39', '48', '64', '200', '266', '62', '236', '119', '235', '105', '134', '224', '245', '177', '257', '210', '223', '263', '251')) ORDER BY FIND_IN_SET(id, '218,77,26,171,19,183,31,23,20,7,18,144,8,12,221,101,120,103,232,96,208,50,29,37,206,15,131,28,91,33,156,204,220,256,24,262,36,268,114,258,110,212,191,38,16,181,187,211,118,153,174,195,141,14,47,49,239,216,30,213,151,35,238,168,196,249,159,4,146,136,209,229,140,170,225,275,59,108,115,113,180,73,269,264,240,88,219,276,57,52,188,248,182,184,132,90,261,237,244,95,82,231,116,230,39,48,64,200,266,62,236,119,235,105,134,224,245,177,257,210,223,263,251') 0.0032107830047607
(117) DESCRIBE `ships` 0.0017521381378174
(118) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '1199', '1291', '1424', '27', '977', '22', '461', '21', '1422', '1419', '1423', '1420', '1418', '1421', '258', '555', '393', '207', '113', '1359', '1272', '517', '1135', '1574', '439', '24', '10', '349', '974', '855', '407', '770', '871', '1599', '1460', '797', '1581', '404', '14', '1215', '265', '330', '1067', '25', '739', '874', '1572', '726', '731', '859', '585', '711', '780', '452', '542', '766', '817', '520', '1205', '405', '1193', '28', '462', '1032', '748', '1588', '791', '1323', '1415', '351', '31', '573', '1285', '1586', '30', '36', '38', '39', '378', '434', '590', '792', '34', '35', '37', '1012', '327', '526', '970', '43', '1376', '1614', '553', '163', '1348', '454', '1027', '580', '1245', '1402', '78', '1326', '1327', '340', '333', '986', '882', '1008', '521', '1325', '11', '1134', '325', '116', '1021', '547', '1013', '1382', '1405', '338', '716', '1088', '1176', '1292', '1417', '1569', '1639', '993', '1455', '314', '678', '722', '837', '1233', '124', '701', '850', '1345', '1615', '4', '162', '683', '732', '119', '286', '1145', '82', '480', '657', '765', '1075', '1575', '253', '857', '1149', '1236', '111', '285', '852', '966', '1095', '1284', '59', '93', '403', '451', '610', '1526', '84', '114', '160', '406', '441', '1163', '1373', '626', '1168', '1319', '1383', '1384', '1628', '769', '968', '988', '1330', '1604', '45', '639', '985', '1449', '352', '401', '1237', '1302', '749', '1607', '1243', '1489', '1602', '75', '616', '666', '784', '1150', '1301', '1501', '9', '996', '1587', '81', '455', '503', '954', '1026', '1458', '5', '348', '574', '290', '324', '389', '854', '1109', '1260', '508', '851', '885', '1366', '1372', '1411', '1571', '108', '313', '776', '1141', '1241', '390', '651', '1068', '1208', '1318', '1320', '1552', '123', '287', '291', '483', '704', '884', '1224', '1492', '148', '582', '658', '1344', '1398', '1611', '1647', '3', '332', '652', '1139', '1148', '1343', '1408', '150', '208', '467', '669', '1064', '1505', '674', '1308', '1321', '1413', '1452', '1453', '1486', '1612', '212', '223', '768', '823', '883', '1253', '74', '98', '147', '394', '937', '1579', '1172', '1454', '335', '938', '994', '1087', '66', '70', '341', '790', '1108', '262', '485', '559', '995', '1154', '1231', '1539', '151', '775', '958', '1017', '1157', '1347', '1461', '1613', '149', '69', '375', '944', '1058', '1159', '1230', '1355', '1362', '1368', '152', '1138', '1632', '1645', '665', '1195', '1385', '796', '1183', '1184', '1259', '1601', '1143', '1189', '105', '205', '738', '751', '1223', '1410', '1412', '204', '1011', '1439', '715', '973', '1023', '1043', '1144', '1262', '1545', '494', '673', '1136', '1137', '1240', '1282', '1303', '1437', '1481', '1543', '1594', '448', '717', '1090', '1132', '1214', '1229', '1266', '1283', '1471', '1546', '1025', '1063', '1106', '1110', '1151', '1160', '1226', '1274', '1367', '417', '905', '1322', '288', '601', '635', '743', '1037', '1338', '1448', '493', '795', '818', '821', '1217', '1358', '62', '386', '997', '1073', '1649', '1704', '17', '201', '266', '479', '618', '672', '1049', '1339', '1426', '1541', '385', '421', '920', '927', '1028', '1034', '1040', '1047', '1055', '1147', '1257', '1360', '1361', '1496', '1533', '1538', '1678', '545', '692', '931', '1003', '1004', '1054', '1140', '1146', '1342', '1354', '1474', '1508', '1516', '1518', '1521', '1558', '1609', '225', '422', '687', '914', '921', '923', '930', '1002', '1019', '1042', '1051', '1089', '1239', '1298', '1350', '1351', '1509', '1532', '1540', '453', '663', '915', '916', '926', '1001', '1072', '1293', '1404', '1559', '1561', '1593', '1596', '1650', '1697', '1708', '695', '703', '733', '785', '811', '858', '888')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,1199,1291,1424,27,977,22,461,21,1422,1419,1423,1420,1418,1421,258,555,393,207,113,1359,1272,517,1135,1574,439,24,10,349,974,855,407,770,871,1599,1460,797,1581,404,14,1215,265,330,1067,25,739,874,1572,726,731,859,585,711,780,452,542,766,817,520,1205,405,1193,28,462,1032,748,1588,791,1323,1415,351,31,573,1285,1586,30,36,38,39,378,434,590,792,34,35,37,1012,327,526,970,43,1376,1614,553,163,1348,454,1027,580,1245,1402,78,1326,1327,340,333,986,882,1008,521,1325,11,1134,325,116,1021,547,1013,1382,1405,338,716,1088,1176,1292,1417,1569,1639,993,1455,314,678,722,837,1233,124,701,850,1345,1615,4,162,683,732,119,286,1145,82,480,657,765,1075,1575,253,857,1149,1236,111,285,852,966,1095,1284,59,93,403,451,610,1526,84,114,160,406,441,1163,1373,626,1168,1319,1383,1384,1628,769,968,988,1330,1604,45,639,985,1449,352,401,1237,1302,749,1607,1243,1489,1602,75,616,666,784,1150,1301,1501,9,996,1587,81,455,503,954,1026,1458,5,348,574,290,324,389,854,1109,1260,508,851,885,1366,1372,1411,1571,108,313,776,1141,1241,390,651,1068,1208,1318,1320,1552,123,287,291,483,704,884,1224,1492,148,582,658,1344,1398,1611,1647,3,332,652,1139,1148,1343,1408,150,208,467,669,1064,1505,674,1308,1321,1413,1452,1453,1486,1612,212,223,768,823,883,1253,74,98,147,394,937,1579,1172,1454,335,938,994,1087,66,70,341,790,1108,262,485,559,995,1154,1231,1539,151,775,958,1017,1157,1347,1461,1613,149,69,375,944,1058,1159,1230,1355,1362,1368,152,1138,1632,1645,665,1195,1385,796,1183,1184,1259,1601,1143,1189,105,205,738,751,1223,1410,1412,204,1011,1439,715,973,1023,1043,1144,1262,1545,494,673,1136,1137,1240,1282,1303,1437,1481,1543,1594,448,717,1090,1132,1214,1229,1266,1283,1471,1546,1025,1063,1106,1110,1151,1160,1226,1274,1367,417,905,1322,288,601,635,743,1037,1338,1448,493,795,818,821,1217,1358,62,386,997,1073,1649,1704,17,201,266,479,618,672,1049,1339,1426,1541,385,421,920,927,1028,1034,1040,1047,1055,1147,1257,1360,1361,1496,1533,1538,1678,545,692,931,1003,1004,1054,1140,1146,1342,1354,1474,1508,1516,1518,1521,1558,1609,225,422,687,914,921,923,930,1002,1019,1042,1051,1089,1239,1298,1350,1351,1509,1532,1540,453,663,915,916,926,1001,1072,1293,1404,1559,1561,1593,1596,1650,1697,1708,695,703,733,785,811,858,888') 0.022247076034546
(119) DESCRIBE `cruisetypes` 0.0011849403381348
(120) DESCRIBE `destinations` 0.0014829635620117
(121) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '55', '28', '26', '38', '11', '44', '40', '21', '49', '48', '7', '30', '29', '56', '52', '10', '34', '46', '45', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,55,28,26,38,11,44,40,21,49,48,7,30,29,56,52,10,34,46,45,32') 0.0013728141784668