or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

Sign up to our newsletter and become the first to know about our latest deals and promotions

Itinerary for Cruise Orchestra, Germany UK Iceland Greenland ex Hamburg Return

Day Port Arrive Depart
Day 1 Hamburg, Germany 06:00 PM
Day 2 At Sea
Day 3 Invergordon, Scotland 08:00 AM 06:00 PM
Day 4 At Sea
Day 5 Seysdisfjordur, Iceland 08:00 AM 05:00 PM
Day 6 Akureyri, Iceland 09:00 AM 07:00 PM
Day 7 At Sea
Day 8 At Sea
Day 9 At Sea
Day 10 Nuuk, Greenland 06:00 AM 04:00 PM
Day 11 Ilulissat, Greenland 04:00 PM overnight
Day 12 Ilulissat, Greenland 06:00 PM
Day 13 At Sea
Day 14 Qaqortoq, Greenland 09:00 AM 09:00 PM
Day 15 At Sea
Day 16 At Sea
Day 17 Isafjordur, Iceland 07:00 AM 07:00 PM
Day 18 Reykjavik, Iceland 08:00 AM 06:00 PM
Day 19 At Sea
Day 20 Kirkwall, Scotland 08:00 AM 06:00 PM
Day 21 At Sea
Day 22 Hamburg, Germany 08:00 AM

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

Total elapsed time: 0.32514691352844

# Query Time
(1) connect 0.0015909671783447
(2) DESCRIBE `cruises` 0.0033600330352783
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'orchestra-germany-uk-iceland-greenland-ex-hamburg-return') AND (orchid_available = 1) LIMIT 1 0.099837064743042
(4) DESCRIBE `avid_specials` 0.0016839504241943
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76574 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 49 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001431941986084
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76574') 0.00040006637573242
(7) DESCRIBE `ships` 0.0031261444091797
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00046086311340332
(9) DESCRIBE `ships` 0.0029110908508301
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.00034594535827637
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052905082702637
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027799606323242
(13) DESCRIBE `itineraries` 0.0017640590667725
(14) DESCRIBE `ports` 0.0013489723205566
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00032997131347656
(16) DESCRIBE `ports` 0.0013189315795898
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00031495094299316
(18) DESCRIBE `ports` 0.0013802051544189
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.0002899169921875
(20) DESCRIBE `sailingdates` 0.0013699531555176
(21) DESCRIBE `ports` 0.00089406967163086
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00037693977355957
(23) DESCRIBE `ports` 0.0014159679412842
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00028085708618164
(25) DESCRIBE `ports` 0.0012869834899902
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00036001205444336
(27) DESCRIBE `ports` 0.0016250610351562
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.0003199577331543
(29) DESCRIBE `ports` 0.0013358592987061
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00030303001403809
(31) DESCRIBE `ports` 0.0012969970703125
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00027585029602051
(33) DESCRIBE `ports` 0.0014088153839111
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00038504600524902
(35) DESCRIBE `ports` 0.0012710094451904
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00031709671020508
(37) DESCRIBE `ports` 0.0016438961029053
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00034999847412109
(39) DESCRIBE `ports` 0.0013988018035889
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00030803680419922
(41) DESCRIBE `ports` 0.0012931823730469
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00032377243041992
(43) DESCRIBE `ports` 0.0013339519500732
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00029802322387695
(45) DESCRIBE `ports` 0.0016710758209229
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00032305717468262
(47) DESCRIBE `ports` 0.0013139247894287
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00028204917907715
(49) DESCRIBE `ports` 0.0014522075653076
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.0003659725189209
(51) DESCRIBE `ports` 0.0013189315795898
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00027990341186523
(53) DESCRIBE `ports` 0.0013890266418457
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00030183792114258
(55) DESCRIBE `ports` 0.0012509822845459
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00027799606323242
(57) DESCRIBE `ports` 0.0014150142669678
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00029897689819336
(59) DESCRIBE `ports` 0.0012490749359131
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00031399726867676
(61) DESCRIBE `ports` 0.0013420581817627
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00036406517028809
(63) DESCRIBE `ports` 0.001572847366333
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00031089782714844
(65) DESCRIBE `ports` 0.0012738704681396
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00033092498779297
(67) DESCRIBE `ports` 0.0014419555664062
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00026798248291016
(69) DESCRIBE `cruiselines` 0.001917839050293
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032210350036621
(71) DESCRIBE `orchid_image` 0.0016219615936279
(72) DESCRIBE `cruiselines` 0.0020098686218262
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031590461730957
(74) DESCRIBE `cabins` 0.0009918212890625
(75) DESCRIBE `deckplans` 0.0012621879577637
(76) DESCRIBE `shipphotos` 0.0010199546813965
(77) DESCRIBE `ports` 0.0015368461608887
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00034308433532715
(79) DESCRIBE `ports` 0.0013089179992676
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00029921531677246
(81) DESCRIBE `ports` 0.00063085556030273
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00027894973754883
(83) DESCRIBE `ports` 0.0013461112976074
(84) DESCRIBE `ports` 0.00096511840820312
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.0003049373626709
(86) DESCRIBE `ports` 0.0014550685882568
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00029492378234863
(88) DESCRIBE `ports` 0.0014450550079346
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00032711029052734
(90) DESCRIBE `ports` 0.0014371871948242
(91) DESCRIBE `ports` 0.0015480518341064
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00040912628173828
(93) DESCRIBE `ports` 0.0012850761413574
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2906') 0.00028300285339355
(95) DESCRIBE `ports` 0.0014350414276123
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2906))) 0.00038790702819824
(97) DESCRIBE `ports` 0.0014259815216064
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00040388107299805
(99) DESCRIBE `ports` 0.0018091201782227
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00031113624572754
(101) DESCRIBE `ports` 0.0017809867858887
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00040102005004883
(103) DESCRIBE `ports` 0.0018379688262939
(104) DESCRIBE `ports` 0.0016770362854004
(105) DESCRIBE `ports` 0.001708984375
(106) DESCRIBE `ports` 0.001533031463623
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00042104721069336
(108) DESCRIBE `ports` 0.0015361309051514
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00032210350036621
(110) DESCRIBE `ports` 0.0014631748199463
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00033807754516602
(112) DESCRIBE `ports` 0.0015192031860352
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00031900405883789
(114) DESCRIBE `ports` 0.0013759136199951
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00039315223693848
(116) DESCRIBE `ports` 0.001352071762085
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00041413307189941
(118) DESCRIBE `ports` 0.0018231868743896
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00031590461730957
(120) DESCRIBE `ports` 0.0015430450439453
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1196') 0.00029706954956055
(122) DESCRIBE `ports` 0.0013360977172852
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1196))) 0.00029492378234863
(124) DESCRIBE `ports` 0.0015139579772949
(125) DESCRIBE `ports` 0.0013258457183838
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00046110153198242
(127) DESCRIBE `ports` 0.0013730525970459
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00028610229492188
(129) DESCRIBE `ports` 0.0015268325805664
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.0011169910430908
(131) DESCRIBE `ports` 0.00069713592529297
(132) DESCRIBE `ports` 0.0015339851379395
(133) DESCRIBE `ports` 0.0014908313751221
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.0003509521484375
(135) DESCRIBE `ports` 0.0014290809631348
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00037217140197754
(137) DESCRIBE `ports` 0.001727819442749
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00030899047851562
(139) DESCRIBE `ports` 0.0015039443969727
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00031495094299316
(141) DESCRIBE `ports` 0.0015549659729004
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00030612945556641
(143) DESCRIBE `ports` 0.0015809535980225
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00029897689819336
(145) DESCRIBE `ports` 0.0013771057128906
(146) DESCRIBE `ports` 0.0014278888702393
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00030994415283203
(148) DESCRIBE `ports` 0.0017929077148438
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00034713745117188
(150) DESCRIBE `ports` 0.0016758441925049
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00033211708068848
(152) DESCRIBE `ports` 0.0013430118560791
(153) DESCRIBE `ports` 0.0014760494232178
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00033307075500488
(155) DESCRIBE `ports` 0.00136399269104
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00027108192443848
(157) DESCRIBE `ports` 0.001384973526001
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00029206275939941
(159) DESCRIBE `cruises` 0.0039849281311035
(160) SELECT `cruises`.* FROM `cruises` WHERE (id IN (11517, 16987, 22963, 22966, 24930, 27114, 29015, 32836, 34165, 34185)) ORDER BY FIND_IN_SET(id, '11517,16987,22963,22966,24930,27114,29015,32836,34165,34185') 0.0013458728790283
(161) DESCRIBE `cruiselines` 0.0033018589019775
(162) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '12', '8', '18', '171', '221', '144', '31', '101', '103', '232', '131', '96', '50', '29', '239', '258', '15', '191', '251', '206', '33', '91', '114', '170', '37', '14', '16', '24', '268', '262', '36', '256', '187', '28', '120', '195', '47', '240', '146', '208', '110', '156', '174', '220', '141', '153', '118', '229', '108', '49', '151', '128', '30', '35', '216', '168', '196', '181', '236', '88', '4', '200', '212', '38', '264', '73', '225', '238', '159', '90', '211', '39', '147', '115', '140', '184', '249', '59', '48', '257', '275', '57', '219', '132', '213', '276', '113', '182', '230', '261', '64', '188', '237', '180', '95', '248', '235', '209', '231', '62', '52', '116', '266', '105', '82', '177', '119', '134', '244', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,12,8,18,171,221,144,31,101,103,232,131,96,50,29,239,258,15,191,251,206,33,91,114,170,37,14,16,24,268,262,36,256,187,28,120,195,47,240,146,208,110,156,174,220,141,153,118,229,108,49,151,128,30,35,216,168,196,181,236,88,4,200,212,38,264,73,225,238,159,90,211,39,147,115,140,184,249,59,48,257,275,57,219,132,213,276,113,182,230,261,64,188,237,180,95,248,235,209,231,62,52,116,266,105,82,177,119,134,244,210,224,245') 0.0067069530487061
(163) DESCRIBE `ships` 0.0038459300994873
(164) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1127', '1554', '1555', '1247', '1324', '517', '1032', '974', '797', '21', '22', '461', '1292', '393', '207', '28', '977', '1205', '330', '258', '480', '1291', '1599', '737', '1199', '1010', '1417', '11', '780', '10', '349', '439', '9', '333', '404', '739', '1135', '986', '1359', '14', '454', '1272', '265', '1677', '855', '1237', '24', '25', '1067', '731', '859', '817', '770', '1594', '1607', '113', '1481', '1588', '3', '38', '34', '837', '31', '37', '378', '985', '1239', '1372', '542', '407', '390', '1320', '39', '43', '748', '1579', '30', '36', '970', '1012', '573', '726', '1323', '1744', '66', '854', '1376', '1402', '1768', '526', '582', '27', '1245', '1422', '1424', '327', '332', '882', '1413', '590', '1420', '1411', '1419', '1423', '1552', '1418', '1421', '1454', '1586', '35', '791', '792', '1284', '1410', '441', '674', '1773', '585', '1587', '1183', '1415', '455', '1184', '114', '580', '1501', '857', '858', '711', '1176', '1193', '1308', '434', '1382', '462', '1405', '1574', '162', '722', '1215', '1236', '1682', '160', '325', '1742', '452', '639', '1021', '78', '119', '285', '658', '1141', '852', '81', '683', '1412', '69', '1008', '1168', '1095', '1408', '1678', '338', '1373', '1572', '678', '1172', '1760', '163', '776', '850', '869', '1082', '1319', '211', '335', '1630', '111', '253', '610', '1782', '45', '1302', '1383', '1569', '1628', '314', '348', '403', '451', '503', '1384', '70', '124', '340', '405', '1259', '116', '766', '1711', '4', '635', '966', '968', '626', '651', '851', '944', '1159', '148', '286', '386', '324', '385', '508', '553', '749', '1303', '1330', '63', '123', '262', '389', '559', '768', '1068', '1260', '1455', '198', '616', '1266', '1301', '375', '406', '467', '485', '1088', '1108', '1325', '1632', '1672', '84', '291', '784', '1562', '1575', '287', '1195', '1212', '108', '483', '716', '1781', '421', '1208', '1639', '98', '1064', '1571', '290', '394', '401', '1398', '1492', '1614', '1721', '652', '657', '1645', '883', '954', '147', '150', '152', '341', '1321', '1724', '149', '151', '704', '874', '1139', '1389', '1486', '1611', '1722', '223', '775', '1269', '1539', '1601', '1717', '885', '1268', '1615', '547', '958', '1289', '1557', '1738', '105', '1143', '1326', '1327', '1437', '545', '717', '1771', '516', '1040', '1075', '1704', '75', '351', '790', '818', '1270', '1679', '868', '1063', '1151', '1213', '1282', '1471', '1673', '1684', '796', '823', '1367', '479', '665', '1013', '1214', '1262', '1318', '1676', '1740', '205', '574', '701', '1561', '1766', '82', '93', '520', '1043', '1218', '1460', '1526', '1540', '1566', '1681', '673', '715', '988', '1144', '1157', '743', '751', '1137', '1223', '1226', '1344', '212', '644', '669', '884', '1027', '1029', '1163', '1229', '1343', '1409', '1716', '201', '266', '1160', '1217', '1283', '1452', '1453', '1602', '1604', '707', '769', '795', '1025', '1090', '1414', '1612', '1613', '1055', '1073', '1136', '1216', '1426', '1448', '1713', '1715', '417', '448', '601', '695', '905', '996', '1019', '1026', '1110', '1145', '1233', '1458', '1496', '1714', '643', '1188', '1211', '1243', '1253', '1743', '1772', '1783', '74', '888', '973', '997', '1034', '1149', '1351', '1358', '1366', '1404', '1516', '1609', '811', '1049', '1150', '1196', '1222', '1231', '1241', '1345', '1360', '1361', '1362', '1368', '1395', '1449', '1459', '1522', '1619', '1647', '1730', '666', '920', '921', '927', '931', '1047', '1230', '1354', '1474', '1627', '1729', '423', '618', '733', '914', '923', '1004', '1152', '1322', '1348', '1517', '1518', '1567', '1580', '1663', '261', '663', '740', '836', '915', '916', '926', '930', '993', '1037', '1042', '1072', '1138', '1521', '1674', '1708', '1751', '453', '494', '499', '703')) ORDER BY FIND_IN_SET(id, '1761,1127,1554,1555,1247,1324,517,1032,974,797,21,22,461,1292,393,207,28,977,1205,330,258,480,1291,1599,737,1199,1010,1417,11,780,10,349,439,9,333,404,739,1135,986,1359,14,454,1272,265,1677,855,1237,24,25,1067,731,859,817,770,1594,1607,113,1481,1588,3,38,34,837,31,37,378,985,1239,1372,542,407,390,1320,39,43,748,1579,30,36,970,1012,573,726,1323,1744,66,854,1376,1402,1768,526,582,27,1245,1422,1424,327,332,882,1413,590,1420,1411,1419,1423,1552,1418,1421,1454,1586,35,791,792,1284,1410,441,674,1773,585,1587,1183,1415,455,1184,114,580,1501,857,858,711,1176,1193,1308,434,1382,462,1405,1574,162,722,1215,1236,1682,160,325,1742,452,639,1021,78,119,285,658,1141,852,81,683,1412,69,1008,1168,1095,1408,1678,338,1373,1572,678,1172,1760,163,776,850,869,1082,1319,211,335,1630,111,253,610,1782,45,1302,1383,1569,1628,314,348,403,451,503,1384,70,124,340,405,1259,116,766,1711,4,635,966,968,626,651,851,944,1159,148,286,386,324,385,508,553,749,1303,1330,63,123,262,389,559,768,1068,1260,1455,198,616,1266,1301,375,406,467,485,1088,1108,1325,1632,1672,84,291,784,1562,1575,287,1195,1212,108,483,716,1781,421,1208,1639,98,1064,1571,290,394,401,1398,1492,1614,1721,652,657,1645,883,954,147,150,152,341,1321,1724,149,151,704,874,1139,1389,1486,1611,1722,223,775,1269,1539,1601,1717,885,1268,1615,547,958,1289,1557,1738,105,1143,1326,1327,1437,545,717,1771,516,1040,1075,1704,75,351,790,818,1270,1679,868,1063,1151,1213,1282,1471,1673,1684,796,823,1367,479,665,1013,1214,1262,1318,1676,1740,205,574,701,1561,1766,82,93,520,1043,1218,1460,1526,1540,1566,1681,673,715,988,1144,1157,743,751,1137,1223,1226,1344,212,644,669,884,1027,1029,1163,1229,1343,1409,1716,201,266,1160,1217,1283,1452,1453,1602,1604,707,769,795,1025,1090,1414,1612,1613,1055,1073,1136,1216,1426,1448,1713,1715,417,448,601,695,905,996,1019,1026,1110,1145,1233,1458,1496,1714,643,1188,1211,1243,1253,1743,1772,1783,74,888,973,997,1034,1149,1351,1358,1366,1404,1516,1609,811,1049,1150,1196,1222,1231,1241,1345,1360,1361,1362,1368,1395,1449,1459,1522,1619,1647,1730,666,920,921,927,931,1047,1230,1354,1474,1627,1729,423,618,733,914,923,1004,1152,1322,1348,1517,1518,1567,1580,1663,261,663,740,836,915,916,926,930,993,1037,1042,1072,1138,1521,1674,1708,1751,453,494,499,703') 0.044384002685547
(165) DESCRIBE `cruisetypes` 0.0023589134216309
(166) DESCRIBE `destinations` 0.0031750202178955
(167) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '44', '55', '53', '39', '26', '28', '38', '49', '7', '40', '11', '21', '56', '48', '30', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,44,55,53,39,26,28,38,49,7,40,11,21,56,48,30,46,29,45,34,10,52,32') 0.0019209384918213