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

 
 
 
  • Cruise and Maritime Voyages
    Marco Polo

    Marco Polo

    The 22,080grt Bahamian flagged Marco Polo, with her handsome traditional profile, beautiful teak decks and distinctive dark blue hull is a fully stabilised and air...

    Star Rating 3 Star
  • Uniworld Boutique River Cruise Collection
    Maria Theresa

    Maria Theresa

    Uniworld’s newest Super Ship, S.S. Maria Theresa, will set sail along the breathtaking Rhine, Main, and Danube rivers in 2015. Sister ship to the S.S....

    Star Rating River
     
    Uniworld Solo Traveller Savings for 2018 Whether you're a first-timer or solo travel veteran, a Uniworld cruise is the most enriching and rewarding way to experience Europe. You get to explore from city to city at your own pace, build new friendships with kindred spirits and enjoy relaxation time whenever you'd like. Book from a selection of 2018 Solo Traveller cruises and Uniworld will waive or reduce the Single Supplement*. Don't wait. Book today to take advantage of this offer! Call for details. Terms and conditions apply.
  • Oceania Cruises
    Marina

    Marina

    Marina is one of the most beautiful, elegant and sophisticated ships to debut in the past 50 years. Designer touches are everywhere, from the magnificent...

    Star Rating 5 Star
  • Royal Caribbean International
    Mariner of the Seas

    Mariner of the Seas

    Guests on Mariner of the Seas experience one of the most exciting cruise ships ever built. With a total length of 1,020 feet, a weight...

    Star Rating 4 Star
  • Nicko Tours
    Maxima

    Maxima

    Our MS MAXIMA is a classic comfortable ship. The spacious outer cabins are equipped in style and comfort. On the middle and upper deck, all...

    Star Rating River
  • Avalon Waterways
    Mayfair

    Mayfair

    With her avant garde touch and luxury accommodations, the MS Mayfair is an exclusive invitation to truly sophisticated accommodation, tranquil relaxation and deletctable dining -...

    Star Rating River
     
    AVALON WATERWAYS - AIR CREDIT OFFER Book your 2018 Avalon Europe, Mekong or Irrawaddy River Cruise before 27 Sep 2017 and receive up to $3000 Air Credit per couple to use towards flights of your choice! Terms and conditions apply. Call for details!
     
    AVALON WATERWAYS -SOLO TRAVELLER OFFER Book any 2018 Avalon Waterways Europe, Mekong or Irrawaddy River Cruise and pay NO single supplement! Terms and conditions apply. Call for details.
  • Viking River Cruises
    Mayfair

    Mayfair

    Float along the life-giving Nile on MS Mayfair, enjoying comfort and style the ancient pharaohs could only dream of, and witness the monuments of ancient...

    Star Rating River
  • Uniworld Boutique River Cruise Collection
    Mekong Navigator

    Mekong Navigator

    Reminiscent in design of the French Colonial–era manor homes that once lined the streets of Old Saigon, the 34-suite Mekong Navigator lends a sophisticated yet...

    Star Rating River
     
    Uniworld Solo Traveller Savings for 2018 Whether you're a first-timer or solo travel veteran, a Uniworld cruise is the most enriching and rewarding way to experience Europe. You get to explore from city to city at your own pace, build new friendships with kindred spirits and enjoy relaxation time whenever you'd like. Book from a selection of 2018 Solo Traveller cruises and Uniworld will waive or reduce the Single Supplement*. Don't wait. Book today to take advantage of this offer! Call for details. Terms and conditions apply.
  • Pandaw Cruises
    Mekong Pandaw

    Mekong Pandaw

    Pandaw's boutique ships were built new and designed and finished as replicas of colonial river steamers, replete in teak and brass, potted palms, open decks,...

    Star Rating River
  • Lernidee Cruises
    Mekong Pearl

    Mekong Pearl

    This new boutique river vessel is expected to go on its maiden voyage and start operating from fall 2017.

    The Mekong Pearl offers 15 cabins on...

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

Total elapsed time: 0.30025792121887

# Query Time
(1) connect 0.00049090385437012
(2) DESCRIBE `ships` 0.001539945602417
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'm') 0.0046939849853516
(4) connect 0.00042510032653809
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'm') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.0042428970336914
(6) DESCRIBE `cruiselines` 0.0011429786682129
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00024104118347168
(8) DESCRIBE `orchid_image` 0.00066184997558594
(9) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '187') 0.028990983963013
(10) DESCRIBE `cruiselines` 0.0011308193206787
(11) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00022101402282715
(12) DESCRIBE `ships` 0.0014941692352295
(13) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00021195411682129
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015902519226074
(15) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00014686584472656
(16) DESCRIBE `avid_specials` 0.00057196617126465
(17) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 818 AND class = 'Ship') OR (item_id = 187 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.00087094306945801
(18) DESCRIBE `cruiselines` 0.00083398818969727
(19) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.0002129077911377
(20) DESCRIBE `orchid_image` 0.00068998336791992
(21) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '96') 0.028013944625854
(22) DESCRIBE `cruiselines` 0.0011091232299805
(23) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00023198127746582
(24) DESCRIBE `ships` 0.001244068145752
(25) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1283') 0.00018811225891113
(26) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015616416931152
(27) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014615058898926
(28) DESCRIBE `avid_specials` 0.00056791305541992
(29) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1283 AND class = 'Ship') OR (item_id = 96 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.00083613395690918
(30) DESCRIBE `cruiselines` 0.00086402893066406
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00020289421081543
(32) DESCRIBE `orchid_image` 0.00092911720275879
(33) DESCRIBE `cruiselines` 0.0012428760528564
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00020718574523926
(35) DESCRIBE `ships` 0.0012331008911133
(36) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00017499923706055
(37) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015997886657715
(38) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014781951904297
(39) DESCRIBE `avid_specials` 0.00057315826416016
(40) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 850 AND class = 'Ship') OR (item_id = 91 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.00085210800170898
(41) DESCRIBE `cruiselines` 0.00096583366394043
(42) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00020694732666016
(43) DESCRIBE `orchid_image` 0.00066399574279785
(44) DESCRIBE `cruiselines` 0.0008080005645752
(45) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00020790100097656
(46) DESCRIBE `ships` 0.0012140274047852
(47) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00017213821411133
(48) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014519691467285
(50) DESCRIBE `avid_specials` 0.00054597854614258
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 393 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.00080084800720215
(52) DESCRIBE `cruiselines` 0.00084400177001953
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00021100044250488
(54) DESCRIBE `orchid_image` 0.00064516067504883
(55) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '204') 0.029052972793579
(56) DESCRIBE `cruiselines` 0.0055649280548096
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00034904479980469
(58) DESCRIBE `ships` 0.0014128684997559
(59) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1536') 0.0001990795135498
(60) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(62) DESCRIBE `avid_specials` 0.00055599212646484
(63) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1536 AND class = 'Ship') OR (item_id = 204 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.00082302093505859
(64) DESCRIBE `cruiselines` 0.00084018707275391
(65) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00020599365234375
(66) DESCRIBE `orchid_image` 0.00066018104553223
(67) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '101') 0.044744968414307
(68) DESCRIBE `cruiselines` 0.00142502784729
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.0002439022064209
(70) DESCRIBE `ships` 0.0018010139465332
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '976') 0.00025415420532227
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022482872009277
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020408630371094
(74) DESCRIBE `avid_specials` 0.00078701972961426
(75) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 976 AND class = 'Ship') OR (item_id = 101 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.001492977142334
(76) DESCRIBE `cruiselines` 0.0012328624725342
(77) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00020599365234375
(78) DESCRIBE `orchid_image` 0.0006561279296875
(79) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '77') 0.027876138687134
(80) DESCRIBE `cruiselines` 0.0012040138244629
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00021100044250488
(82) DESCRIBE `ships` 0.0012218952178955
(83) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1576') 0.00018501281738281
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(86) DESCRIBE `avid_specials` 0.00054192543029785
(87) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1576 AND class = 'Ship') OR (item_id = 77 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.00080013275146484
(88) DESCRIBE `cruiselines` 0.0008080005645752
(89) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00020098686218262
(90) DESCRIBE `orchid_image` 0.00069594383239746
(91) DESCRIBE `cruiselines` 0.00078010559082031
(92) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00016188621520996
(93) DESCRIBE `ships` 0.0011179447174072
(94) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1462') 0.00016283988952637
(95) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015687942504883
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(97) DESCRIBE `avid_specials` 0.000518798828125
(98) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1462 AND class = 'Ship') OR (item_id = 96 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.00072598457336426
(99) DESCRIBE `cruiselines` 0.00083684921264648
(100) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00018906593322754
(101) DESCRIBE `orchid_image` 0.00065708160400391
(102) DESCRIBE `cruiselines` 0.00080990791320801
(103) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00015997886657715
(104) DESCRIBE `ships` 0.0011560916900635
(105) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00015997886657715
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015401840209961
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(108) DESCRIBE `avid_specials` 0.00052905082702637
(109) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 521 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.00079894065856934
(110) DESCRIBE `cruiselines` 0.00086307525634766
(111) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 219))) 0.00019001960754395
(112) DESCRIBE `orchid_image` 0.00066494941711426
(113) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '219') 0.027806997299194
(114) DESCRIBE `cruiselines` 0.0013539791107178
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '219') 0.00022101402282715
(116) DESCRIBE `ships` 0.0012600421905518
(117) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1629') 0.00019001960754395
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016689300537109
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001671314239502
(120) DESCRIBE `avid_specials` 0.00069499015808105
(121) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1629 AND class = 'Ship') OR (item_id = 219 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.00088810920715332
(122) DESCRIBE `cruises` 0.002100944519043
(123) SELECT `cruises`.* FROM `cruises` WHERE (id IN (13509, 13510, 26945, 29119, 34156, 34174, 34195, 35653, 38122, 38147)) ORDER BY FIND_IN_SET(id, '13509,13510,26945,29119,34156,34174,34195,35653,38122,38147') 0.00073909759521484
(124) DESCRIBE `cruiselines` 0.001039981842041
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '77', '19', '7', '26', '144', '23', '12', '221', '20', '120', '171', '101', '18', '96', '8', '206', '131', '50', '37', '15', '103', '220', '29', '208', '110', '156', '181', '91', '191', '141', '268', '33', '31', '28', '232', '195', '211', '137', '14', '24', '114', '196', '49', '30', '187', '16', '38', '168', '262', '170', '212', '36', '108', '4', '151', '115', '118', '47', '204', '73', '59', '180', '146', '159', '174', '269', '216', '35', '140', '200', '153', '213', '39', '182', '188', '88', '113', '132', '62', '264', '95', '48', '52', '57', '219', '223', '263', '116', '266', '64', '209', '82', '119', '136', '105', '177', '147', '172', '134')) ORDER BY FIND_IN_SET(id, '218,183,77,19,7,26,144,23,12,221,20,120,171,101,18,96,8,206,131,50,37,15,103,220,29,208,110,156,181,91,191,141,268,33,31,28,232,195,211,137,14,24,114,196,49,30,187,16,38,168,262,170,212,36,108,4,151,115,118,47,204,73,59,180,146,159,174,269,216,35,140,200,153,213,39,182,188,88,113,132,62,264,95,48,52,57,219,223,263,116,266,64,209,82,119,136,105,177,147,172,134') 0.0023219585418701
(126) DESCRIBE `ships` 0.0015780925750732
(127) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1554', '1555', '1359', '1247', '977', '726', '1272', '974', '859', '797', '1291', '731', '1199', '1067', '1205', '520', '1581', '258', '405', '28', '22', '461', '21', '27', '116', '452', '1032', '521', '766', '31', '37', '480', '36', '38', '378', '585', '34', '35', '1012', '30', '39', '610', '1599', '393', '113', '986', '1135', '993', '882', '553', '1405', '10', '454', '351', '1417', '25', '780', '439', '1415', '517', '738', '1245', '11', '349', '503', '404', '770', '1455', '24', '716', '1372', '701', '1571', '857', '1588', '207', '265', '732', '573', '59', '1237', '1021', '1082', '1501', '1087', '1292', '4', '5', '1552', '1614', '462', '542', '674', '769', '1285', '1402', '1243', '333', '9', '327', '792', '1489', '455', '765', '854', '1088', '1241', '1325', '286', '390', '748', '1320', '150', '434', '739', '791', '1302', '1574', '590', '1027', '1323', '855', '970', '1064', '1068', '1224', '14', '711', '883', '669', '1109', '1615', '582', '3', '189', '441', '616', '837', '253', '451', '657', '678', '1139', '1193', '635', '652', '1284', '1308', '594', '595', '722', '1330', '406', '574', '593', '1008', '43', '212', '290', '775', '784', '966', '1063', '1505', '78', '314', '123', '325', '817', '1319', '211', '262', '626', '1095', '151', '1145', '1157', '1233', '1345', '1355', '1602', '81', '163', '958', '1586', '152', '160', '559', '743', '823', '93', '338', '340', '1195', '1376', '82', '332', '407', '1326', '1327', '483', '715', '737', '850', '1058', '119', '704', '1168', '375', '985', '1471', '1526', '66', '580', '1565', '1568', '1579', '105', '111', '448', '1013', '1240', '683', '751', '394', '547', '673', '988', '1149', '261', '348', '1136', '1223', '1343', '1344', '1454', '1463', '287', '291', '1137', '1143', '1260', '1318', '74', '75', '1160', '1373', '98', '148', '403', '658', '796', '852', '1043', '1132', '1151', '1283', '1301', '1367', '1452', '1453', '45', '201', '288', '639', '968', '1071', '1144', '1289', '108', '651', '1217', '1611', '1612', '223', '508', '1025', '1090', '1108', '1163', '1282', '1322', '1358', '1601', '324', '744', '905', '1037', '1152', '1426', '417', '869', '1421', '1448', '162', '313', '665', '954', '1026', '1075', '1321', '1458', '1613', '198', '330', '601', '785', '811', '997', '1047', '1424', '1468', '70', '266', '768', '776', '821', '1148', '1208', '1231', '69', '401', '545', '795', '996', '1154', '1159', '1445', '1569', '208', '1226', '149', '335', '663', '1040', '1230', '1366', '1419', '1420', '1422', '341', '421', '618', '937', '973', '1019', '1232', '717', '851', '927', '1034', '1110', '1147', '1389', '1418', '1470', '385', '453', '627', '684', '871', '885', '920', '1146', '1486', '1516', '485', '836', '931', '1003', '1004', '1035', '1045', '1354', '1398', '1461', '1496', '1508', '1558', '733', '786', '914', '921', '923', '930', '944', '1002', '1044', '1049', '1266', '1509', '1521', '1594', '205', '422', '707', '790', '858', '915', '916', '926', '972', '994', '1001', '1048', '1072', '1073', '1140', '1492', '1518', '1596', '285', '389', '687', '727', '818', '924', '995', '1051', '1052', '1106', '1150', '1519', '225', '420', '487', '761', '1294', '1423', '1604', '84', '204', '504', '703', '990', '1020', '1042', '1055', '1175', '1206', '1348', '1407', '1514', '1559', '467', '526', '666', '884', '929', '999', '1054', '1115', '1189', '1262', '1444', '1134', '1172', '1397', '1481', '1575', '423', '479', '494', '781', '1029', '1259', '1293', '1522', '1607', '147', '798', '888', '938', '1036', '1138', '1362', '1368', '124', '516', '868', '1254', '1299', '1341', '1498', '1609', '932', '1236', '1340', '1462', '493', '656', '987', '1011', '1297', '1404', '1053', '1155', '1169', '240')) ORDER BY FIND_IN_SET(id, '1127,1554,1555,1359,1247,977,726,1272,974,859,797,1291,731,1199,1067,1205,520,1581,258,405,28,22,461,21,27,116,452,1032,521,766,31,37,480,36,38,378,585,34,35,1012,30,39,610,1599,393,113,986,1135,993,882,553,1405,10,454,351,1417,25,780,439,1415,517,738,1245,11,349,503,404,770,1455,24,716,1372,701,1571,857,1588,207,265,732,573,59,1237,1021,1082,1501,1087,1292,4,5,1552,1614,462,542,674,769,1285,1402,1243,333,9,327,792,1489,455,765,854,1088,1241,1325,286,390,748,1320,150,434,739,791,1302,1574,590,1027,1323,855,970,1064,1068,1224,14,711,883,669,1109,1615,582,3,189,441,616,837,253,451,657,678,1139,1193,635,652,1284,1308,594,595,722,1330,406,574,593,1008,43,212,290,775,784,966,1063,1505,78,314,123,325,817,1319,211,262,626,1095,151,1145,1157,1233,1345,1355,1602,81,163,958,1586,152,160,559,743,823,93,338,340,1195,1376,82,332,407,1326,1327,483,715,737,850,1058,119,704,1168,375,985,1471,1526,66,580,1565,1568,1579,105,111,448,1013,1240,683,751,394,547,673,988,1149,261,348,1136,1223,1343,1344,1454,1463,287,291,1137,1143,1260,1318,74,75,1160,1373,98,148,403,658,796,852,1043,1132,1151,1283,1301,1367,1452,1453,45,201,288,639,968,1071,1144,1289,108,651,1217,1611,1612,223,508,1025,1090,1108,1163,1282,1322,1358,1601,324,744,905,1037,1152,1426,417,869,1421,1448,162,313,665,954,1026,1075,1321,1458,1613,198,330,601,785,811,997,1047,1424,1468,70,266,768,776,821,1148,1208,1231,69,401,545,795,996,1154,1159,1445,1569,208,1226,149,335,663,1040,1230,1366,1419,1420,1422,341,421,618,937,973,1019,1232,717,851,927,1034,1110,1147,1389,1418,1470,385,453,627,684,871,885,920,1146,1486,1516,485,836,931,1003,1004,1035,1045,1354,1398,1461,1496,1508,1558,733,786,914,921,923,930,944,1002,1044,1049,1266,1509,1521,1594,205,422,707,790,858,915,916,926,972,994,1001,1048,1072,1073,1140,1492,1518,1596,285,389,687,727,818,924,995,1051,1052,1106,1150,1519,225,420,487,761,1294,1423,1604,84,204,504,703,990,1020,1042,1055,1175,1206,1348,1407,1514,1559,467,526,666,884,929,999,1054,1115,1189,1262,1444,1134,1172,1397,1481,1575,423,479,494,781,1029,1259,1293,1522,1607,147,798,888,938,1036,1138,1362,1368,124,516,868,1254,1299,1341,1498,1609,932,1236,1340,1462,493,656,987,1011,1297,1404,1053,1155,1169,240') 0.022994041442871
(128) DESCRIBE `cruisetypes` 0.00084400177001953
(129) DESCRIBE `destinations` 0.00083088874816895
(130) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '37', '9', '43', '2', '44', '8', '53', '39', '55', '28', '38', '48', '40', '26', '7', '21', '52', '11', '29', '49', '30', '34', '46', '45', '10', '56', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,37,9,43,2,44,8,53,39,55,28,38,48,40,26,7,21,52,11,29,49,30,34,46,45,10,56,32') 0.00097298622131348