or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • Dream Cruises
    Genting Dream

    Genting Dream

    Genting Dream will carry 3,400 guests and 2,000 crewmembers, giving the 150,000-ton vessel the largest guest space ratio of 45 tons per guest as well...

    Star Rating Not Rated
  • CroisiEurope
    Georgy Chicherin

    Georgy Chicherin

    The Georgy CHICHERIN cruises the Volga.

    Services: 2 restaurants, 2 or 3 bars, meeting room, music lounge, souvenir shop, ironing room, medical services, upper and...

    Star Rating River
  • CroisiEurope
    Gerard Schmitter

    Gerard Schmitter

    CroisiEurope has a fleet of 27 Prestige category boats with cabins, which ply the most beautiful rivers in Europe. Spacious and light, they offer a...

    Star Rating River
  • CroisiEurope
    Gil Eanes

    Gil Eanes

    The MS Gil Eanes cruises on the Douro and features a lounge with large picture windows, restaurant, library, TV, gift shop, elevator, sun deck with...

    Star Rating River
  • Heritage Line
    Ginger

    Ginger

    She is graceful and responsible, yet she exudes a delectable avant-garde ambiance.

    Heritage Line considers its boutique vessels to be part of a family. In Halong...

    Star Rating Specialty
  • Majestic Line
    Glen Etive

    Glen Etive

    The newest vessel, the Glen Etive, is built in the style of a "gentleman's yacht" and undertakes 10-day cruises to Islay, Skye, the Outer Hebrides...

    Star Rating Specialty
  • Majestic Line
    Glen Massan

    Glen Massan

    The Glen Massan is a traditional wooden fishing vessel that has been lovingly converted to offer 3-night and 6-night cruises to Argyll and the Hebrides...

    Star Rating Specialty
  • Majestic Line
    Glen Tarsan

    Glen Tarsan

    The Glen Tarsan is a traditional wooden fishing vessel that has been lovingly converted to offer 3-night and 6-night cruises to Argyll and the Hebrides...

    Star Rating Specialty
  • Princess Cruises
    Golden Princess

    Golden Princess

    Golden Princess has more ways to relax, dine, shop, play, swim, sun, dance and indulge than you can imagine, so you can experience the impressive...

    Star Rating 4 Star
     
    Princess Cruises: Twice as Nice Sale Book an interior or oceanview stateroom and receive up to AU$300 onboard credit. Book balcony stateroom or above for double (up to AU$600) onboard credit. Applies to selected cruises to the South Pacific, Australia, New Zealand, Asia, Europe and around the world. Conditions apply
  • Tauck
    Grace

    Grace

    Our new Inspiration Class ships maintain Tauck’s high standards for luxury and comfort... ms Grace will cruise exclusively on the Rhine River. With a maximum...

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

Total elapsed time: 0.17266201972961

# Query Time
(1) connect 0.00047588348388672
(2) DESCRIBE `ships` 0.0018370151519775
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'g') 0.0037801265716553
(4) connect 0.00041103363037109
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'g') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0042428970336914
(6) DESCRIBE `cruiselines` 0.0012290477752686
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00027084350585938
(8) DESCRIBE `orchid_image` 0.00076508522033691
(9) DESCRIBE `cruiselines` 0.0009617805480957
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00020694732666016
(11) DESCRIBE `ships` 0.0013959407806396
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00019383430480957
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017404556274414
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016093254089355
(15) DESCRIBE `avid_specials` 0.00074100494384766
(16) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1463 AND class = 'Ship') OR (item_id = 264 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.00060200691223145
(17) DESCRIBE `cruiselines` 0.00098991394042969
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00023007392883301
(19) DESCRIBE `orchid_image` 0.0007479190826416
(20) DESCRIBE `cruiselines` 0.0009307861328125
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019121170043945
(22) DESCRIBE `ships` 0.0013399124145508
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1511') 0.00018978118896484
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019502639770508
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018906593322754
(26) DESCRIBE `avid_specials` 0.00064706802368164
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511 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.00061178207397461
(28) DESCRIBE `cruiselines` 0.00096702575683594
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0002281665802002
(30) DESCRIBE `orchid_image` 0.0007481575012207
(31) DESCRIBE `cruiselines` 0.00094294548034668
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018405914306641
(33) DESCRIBE `ships` 0.0012989044189453
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1047') 0.00017881393432617
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017619132995605
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020194053649902
(37) DESCRIBE `avid_specials` 0.00063705444335938
(38) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1047 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.00058317184448242
(39) DESCRIBE `cruiselines` 0.00098490715026855
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0002281665802002
(41) DESCRIBE `orchid_image` 0.00074195861816406
(42) DESCRIBE `cruiselines` 0.00091791152954102
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019001960754395
(44) DESCRIBE `ships` 0.0013220310211182
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1293') 0.00019097328186035
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022387504577637
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046086311340332
(48) DESCRIBE `avid_specials` 0.00082302093505859
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1293 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.0006871223449707
(50) DESCRIBE `cruiselines` 0.0010190010070801
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00022697448730469
(52) DESCRIBE `orchid_image` 0.00076389312744141
(53) DESCRIBE `cruiselines` 0.0010278224945068
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00018882751464844
(55) DESCRIBE `ships` 0.0015912055969238
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1553') 0.00021505355834961
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019502639770508
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021100044250488
(59) DESCRIBE `avid_specials` 0.0008080005645752
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1553 AND class = 'Ship') OR (item_id = 183 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.00069499015808105
(61) DESCRIBE `cruiselines` 0.0011589527130127
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 269))) 0.00028896331787109
(63) DESCRIBE `orchid_image` 0.00087213516235352
(64) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '269') 0.045120000839233
(65) DESCRIBE `cruiselines` 0.0018370151519775
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '269') 0.00026297569274902
(67) DESCRIBE `ships` 0.0045421123504639
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1560') 0.00027894973754883
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id != '1560') 0.0041999816894531
(70) UPDATE `ships` SET `orchid_slug` = ? WHERE (id = '1560') 0.00071215629577637
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031399726867676
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017285346984863
(73) DESCRIBE `avid_specials` 0.00083208084106445
(74) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1560 AND class = 'Ship') OR (item_id = 269 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.00059103965759277
(75) DESCRIBE `cruiselines` 0.0009920597076416
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 269))) 0.00024890899658203
(77) DESCRIBE `orchid_image` 0.00074219703674316
(78) DESCRIBE `cruiselines` 0.00090503692626953
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '269') 0.00019693374633789
(80) DESCRIBE `ships` 0.0019140243530273
(81) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1559') 0.00025582313537598
(82) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id != '1559') 0.0043840408325195
(83) UPDATE `ships` SET `orchid_slug` = ? WHERE (id = '1559') 0.00033903121948242
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022792816162109
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017094612121582
(86) DESCRIBE `avid_specials` 0.00080394744873047
(87) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1559 AND class = 'Ship') OR (item_id = 269 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.00066304206848145
(88) DESCRIBE `cruiselines` 0.00097894668579102
(89) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 269))) 0.000244140625
(90) DESCRIBE `orchid_image` 0.00082111358642578
(91) DESCRIBE `cruiselines` 0.00093698501586914
(92) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '269') 0.00020194053649902
(93) DESCRIBE `ships` 0.0018758773803711
(94) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1558') 0.00025677680969238
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id != '1558') 0.0042810440063477
(96) UPDATE `ships` SET `orchid_slug` = ? WHERE (id = '1558') 0.00039315223693848
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031304359436035
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025296211242676
(99) DESCRIBE `avid_specials` 0.00085711479187012
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1558 AND class = 'Ship') OR (item_id = 269 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.00059008598327637
(101) DESCRIBE `cruiselines` 0.0010819435119629
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023102760314941
(103) DESCRIBE `orchid_image` 0.00093817710876465
(104) DESCRIBE `cruiselines` 0.0012819766998291
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0001990795135498
(106) DESCRIBE `ships` 0.0013389587402344
(107) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00019693374633789
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(110) DESCRIBE `avid_specials` 0.00061392784118652
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 253 AND class = 'Ship') OR (item_id = 23 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.00071287155151367
(112) DESCRIBE `cruiselines` 0.0010130405426025
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00022697448730469
(114) DESCRIBE `orchid_image` 0.00076103210449219
(115) DESCRIBE `cruiselines` 0.00092816352844238
(116) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00019001960754395
(117) DESCRIBE `ships` 0.001291036605835
(118) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1352') 0.00020313262939453
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017905235290527
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(121) DESCRIBE `avid_specials` 0.00062704086303711
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1352 AND class = 'Ship') OR (item_id = 153 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.00055909156799316
(123) DESCRIBE `cruises` 0.0016398429870605
(124) SELECT `cruises`.* FROM `cruises` WHERE (id IN (14972, 29952, 31627, 34157, 34171, 34192, 38147, 38149, 40904, 44079)) ORDER BY FIND_IN_SET(id, '14972,29952,31627,34157,34171,34192,38147,38149,40904,44079') 0.0012378692626953
(125) DESCRIBE `cruiselines` 0.0011649131774902
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '144', '23', '20', '18', '171', '8', '31', '232', '12', '120', '137', '101', '96', '15', '50', '29', '103', '183', '181', '91', '131', '206', '208', '16', '204', '37', '156', '33', '38', '28', '191', '221', '110', '14', '36', '220', '268', '153', '174', '114', '196', '47', '115', '141', '24', '187', '30', '35', '195', '216', '262', '211', '168', '170', '49', '151', '4', '200', '140', '159', '269', '108', '118', '39', '223', '88', '212', '59', '73', '180', '209', '113', '213', '264', '182', '64', '132', '147', '157', '128', '48', '92', '136', '188', '82', '95', '263', '52', '62', '266', '57', '116', '119', '105', '172', '94', '134', '166', '146', '219')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,144,23,20,18,171,8,31,232,12,120,137,101,96,15,50,29,103,183,181,91,131,206,208,16,204,37,156,33,38,28,191,221,110,14,36,220,268,153,174,114,196,47,115,141,24,187,30,35,195,216,262,211,168,170,49,151,4,200,140,159,269,108,118,39,223,88,212,59,73,180,209,113,213,264,182,64,132,147,157,128,48,92,136,188,82,95,263,52,62,266,57,116,119,105,172,94,134,166,146,219') 0.0025548934936523
(127) DESCRIBE `ships` 0.0017039775848389
(128) SELECT `ships`.* FROM `ships` WHERE (id IN ('1247', '738', '1127', '258', '594', '595', '859', '517', '593', '1199', '1291', '1359', '585', '503', '207', '1082', '766', '14', '855', '24', '731', '5', '780', '1376', '837', '1205', '974', '1032', '22', '21', '461', '726', '452', '27', '116', '113', '265', '405', '521', '610', '797', '28', '38', '34', '1424', '37', '404', '30', '39', '35', '1012', '36', '378', '1245', '31', '390', '462', '739', '657', '1372', '674', '1135', '441', '1421', '480', '211', '1420', '684', '1419', '1422', '1087', '1418', '439', '1068', '1115', '25', '555', '792', '1095', '857', '1021', '1423', '1292', '455', '1109', '10', '70', '711', '977', '1405', '770', '1064', '542', '1063', '11', '393', '483', '553', '850', '966', '1489', '69', '1272', '253', '451', '1302', '1552', '4', '434', '716', '883', '1067', '1169', '407', '1325', '639', '869', '1319', '1373', '580', '784', '1417', '769', '1455', '573', '737', '1088', '1301', '349', '454', '1071', '1565', '678', '1308', '291', '954', '1195', '59', '652', '658', '993', '75', '105', '286', '582', '590', '748', '765', '791', '1320', '332', '749', '944', '1323', '1330', '119', '854', '970', '3', '394', '467', '526', '1285', '150', '327', '508', '968', '1027', '149', '683', '768', '616', '651', '1193', '790', '1259', '314', '547', '1208', '1284', '9', '45', '205', '285', '1236', '324', '333', '340', '348', '1139', '1157', '148', '98', '162', '882', '1108', '1463', '82', '338', '403', '775', '1035', '1266', '160', '330', '401', '1008', '1505', '66', '111', '262', '485', '669', '704', '776', '874', '1240', '43', '81', '325', '341', '817', '852', '988', '1168', '1232', '223', '626', '937', '1241', '1282', '1397', '1398', '351', '596', '722', '885', '1159', '93', '151', '152', '743', '884', '1206', '1262', '1558', '62', '1189', '1224', '124', '389', '821', '868', '1145', '1233', '84', '114', '147', '559', '986', '1501', '288', '665', '1327', '406', '516', '650', '688', '1011', '1013', '204', '290', '673', '958', '996', '1010', '1040', '1058', '1326', '1471', '74', '198', '385', '717', '1006', '1243', '201', '448', '715', '1073', '1223', '1460', '1553', '1554', '1555', '1559', '287', '727', '728', '1449', '1486', '163', '313', '574', '701', '796', '1170', '1217', '1343', '1546', '212', '375', '386', '1136', '1237', '1344', '1415', '123', '545', '973', '1137', '1160', '1318', '1345', '1358', '1454', '818', '823', '961', '963', '1283', '1289', '1348', '1452', '1545', '108', '709', '751', '1049', '1151', '1303', '1445', '1453', '1468', '78', '612', '666', '795', '811', '1026', '1144', '1338', '266', '804', '905', '978', '1025', '1045', '1090', '1143', '1163', '1367', '1458', '1459', '417', '732', '800', '997', '1226', '1321', '1357', '1152', '1448', '487', '733', '1229', '1366', '1402', '1519', '335', '672', '786', '1019', '1075', '1148', '1149', '1231', '1322', '1533', '1538', '208', '601', '707', '740', '744', '1034', '1043', '1055', '1060', '1106', '1146', '1175', '1230', '1406', '1532', '1568', '421', '488', '494', '920', '927', '1047', '1051', '1140', '1147', '1426', '1496', '1541', '420', '422', '931', '1004', '1053', '1260', '1346', '466', '560', '692', '695', '785', '836', '914', '915', '921', '923', '1001', '1054', '1072', '1188', '1354', '1516', '1521', '493', '693', '916', '926', '930', '972', '994', '1002', '1257', '1351', '663', '671', '687', '761', '888', '924', '1003', '1154', '1389', '1443', '1518', '17', '225', '504', '627', '767', '1028', '1044', '1294', '1355', '752', '781', '932', '1020', '1038', '1341', '1350', '1407', '1450', '990', '1048', '1089', '1132', '1340', '1514', '1542', '1560', '643', '1017', '1030', '1052', '1299', '1352', '423', '938', '969', '1138', '1297')) ORDER BY FIND_IN_SET(id, '1247,738,1127,258,594,595,859,517,593,1199,1291,1359,585,503,207,1082,766,14,855,24,731,5,780,1376,837,1205,974,1032,22,21,461,726,452,27,116,113,265,405,521,610,797,28,38,34,1424,37,404,30,39,35,1012,36,378,1245,31,390,462,739,657,1372,674,1135,441,1421,480,211,1420,684,1419,1422,1087,1418,439,1068,1115,25,555,792,1095,857,1021,1423,1292,455,1109,10,70,711,977,1405,770,1064,542,1063,11,393,483,553,850,966,1489,69,1272,253,451,1302,1552,4,434,716,883,1067,1169,407,1325,639,869,1319,1373,580,784,1417,769,1455,573,737,1088,1301,349,454,1071,1565,678,1308,291,954,1195,59,652,658,993,75,105,286,582,590,748,765,791,1320,332,749,944,1323,1330,119,854,970,3,394,467,526,1285,150,327,508,968,1027,149,683,768,616,651,1193,790,1259,314,547,1208,1284,9,45,205,285,1236,324,333,340,348,1139,1157,148,98,162,882,1108,1463,82,338,403,775,1035,1266,160,330,401,1008,1505,66,111,262,485,669,704,776,874,1240,43,81,325,341,817,852,988,1168,1232,223,626,937,1241,1282,1397,1398,351,596,722,885,1159,93,151,152,743,884,1206,1262,1558,62,1189,1224,124,389,821,868,1145,1233,84,114,147,559,986,1501,288,665,1327,406,516,650,688,1011,1013,204,290,673,958,996,1010,1040,1058,1326,1471,74,198,385,717,1006,1243,201,448,715,1073,1223,1460,1553,1554,1555,1559,287,727,728,1449,1486,163,313,574,701,796,1170,1217,1343,1546,212,375,386,1136,1237,1344,1415,123,545,973,1137,1160,1318,1345,1358,1454,818,823,961,963,1283,1289,1348,1452,1545,108,709,751,1049,1151,1303,1445,1453,1468,78,612,666,795,811,1026,1144,1338,266,804,905,978,1025,1045,1090,1143,1163,1367,1458,1459,417,732,800,997,1226,1321,1357,1152,1448,487,733,1229,1366,1402,1519,335,672,786,1019,1075,1148,1149,1231,1322,1533,1538,208,601,707,740,744,1034,1043,1055,1060,1106,1146,1175,1230,1406,1532,1568,421,488,494,920,927,1047,1051,1140,1147,1426,1496,1541,420,422,931,1004,1053,1260,1346,466,560,692,695,785,836,914,915,921,923,1001,1054,1072,1188,1354,1516,1521,493,693,916,926,930,972,994,1002,1257,1351,663,671,687,761,888,924,1003,1154,1389,1443,1518,17,225,504,627,767,1028,1044,1294,1355,752,781,932,1020,1038,1341,1350,1407,1450,990,1048,1089,1132,1340,1514,1542,1560,643,1017,1030,1052,1299,1352,423,938,969,1138,1297') 0.019670963287354
(129) DESCRIBE `cruisetypes` 0.00094199180603027
(130) DESCRIBE `destinations` 0.00092506408691406
(131) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '25', '43', '9', '44', '2', '8', '40', '39', '48', '53', '26', '28', '21', '55', '38', '46', '7', '11', '29', '49', '34', '30', '45', '52', '10', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,25,43,9,44,2,8,40,39,48,53,26,28,21,55,38,46,7,11,29,49,34,30,45,52,10,56,32') 0.0011308193206787