or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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

Cruise Ships

Search for Cruise Ships

 
 
 
  • P&O International
    Oceana

    Oceana

    Family-friendly, mid-sized ship

    Oceana is a mid-sized cruise ship with a particularly stunning atrium that creates a real ‘wow’. Her bars, restaurants, shops and lounges...

    Star Rating 4 Star
  • Sea Trek Sailing Adventures
    Ombak Putih

    Ombak Putih

    The Ombak Putih is a traditional Indonesian schooner custom built from ironwood by Buginese ship builders in Batulicin, Kalimantan. Her keel was laid in 1995,...

    Star Rating Specialty
  • Holland America Line
    Oosterdam

    Oosterdam

    Officially christened in 2003 by Her Dutch Royal Highness, Princess Margriet of the Netherlands, the ms Oosterdam is the second in our series of Vista-class...

    Star Rating 5 Star
  • Wings Nile Cruises
    Orchid

    Orchid

    Welcome aboard the M/S Orchid. It was inaugurated in 1989 and then renovated in 2000.

    M/S Orchid is a 5 Star Nile Cruise ... Total...

    Star Rating River
  • P&O International
    Oriana

    Oriana

    Exclusively for adults, mid-sized ship

    With her signature tiered stern decks, Oriana is elegant and attractive. She has been specifically designed to suit British tastes; the...

    Star Rating 4 Star
  • Pandaw Cruises
    Orient Pandaw

    Orient Pandaw

    Each ship, hand finished in brass and teak by traditional craftsmen are in themselves objects of great beauty. The secret of our success is that...

    Star Rating River
  • Oceanwide Expeditions
    Ortelius

    Ortelius

    The vessel "Marina Svetaeva" will be re-flagged and renamed
    "Ortellius". As Plancius, Ortelius was a Dutch / Flemish cartographer. Abraham Ortelius (1527 – 1598)...

    Star Rating Specialty
  • Riviera Travel
    Oscar Wilde

    Oscar Wilde

    After years of painstaking research to create the most perfect vessels afloat, a new era in river cruising dawns as we introduce our brand new,...

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

    Ovation of the Seas

    Marvel at the newest and third ship in the Quantum Class, Ovation of the Seas. Featuring the same groundbreaking venues as its sister ships, Quantum...

    Star Rating 4 Star
  • Cruiseco
    Ovation of the Seas - Charter

    Ovation of the Seas - Charter

    Marvel at the third ship in the Quantum Class, Ovation of the Seas. Featuring the same groundbreaking venues as its sister ships, Quantum of the...

    Star Rating 4 Star
 

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

# Query Time
(1) connect 0.00059914588928223
(2) DESCRIBE `ships` 0.0036659240722656
(3) SELECT COUNT(1) AS `zend_paginator_row_count` FROM `ships` WHERE (LEFT(ships.name, 1) = 'o') 0.010199069976807
(4) connect 0.00076007843017578
(5) SELECT DISTINCT `ships`.* FROM `ships` WHERE (LEFT(ships.name, 1) = 'o') ORDER BY `name` ASC LIMIT 10 OFFSET 10 0.015716075897217
(6) DESCRIBE `cruiselines` 0.0025300979614258
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00042414665222168
(8) DESCRIBE `orchid_image` 0.0016531944274902
(9) DESCRIBE `cruiselines` 0.0021049976348877
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00032186508178711
(11) DESCRIBE `ships` 0.0028140544891357
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00030899047851562
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026917457580566
(15) DESCRIBE `avid_specials` 0.0013289451599121
(16) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 265 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.0026850700378418
(17) DESCRIBE `cruiselines` 0.0021910667419434
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 182))) 0.00038003921508789
(19) DESCRIBE `orchid_image` 0.001615047454834
(20) DESCRIBE `cruiselines` 0.0020411014556885
(21) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '182') 0.00033402442932129
(22) DESCRIBE `ships` 0.0028660297393799
(23) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1407') 0.00036883354187012
(24) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028800964355469
(25) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002751350402832
(26) DESCRIBE `avid_specials` 0.0013620853424072
(27) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1407 AND class = 'Ship') OR (item_id = 182 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.001378059387207
(28) DESCRIBE `cruiselines` 0.0020589828491211
(29) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00047183036804199
(30) DESCRIBE `orchid_image` 0.0016679763793945
(31) DESCRIBE `cruiselines` 0.0020148754119873
(32) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0003349781036377
(33) DESCRIBE `ships` 0.0028750896453857
(34) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00031590461730957
(35) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028610229492188
(36) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027203559875488
(37) DESCRIBE `avid_specials` 0.0013351440429688
(38) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 340 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.0013768672943115
(39) DESCRIBE `cruiselines` 0.0020859241485596
(40) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 137))) 0.00035476684570312
(41) DESCRIBE `orchid_image` 0.0015928745269775
(42) DESCRIBE `cruiselines` 0.0020110607147217
(43) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '137') 0.00037908554077148
(44) DESCRIBE `ships` 0.0027990341186523
(45) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '596') 0.00036811828613281
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029206275939941
(47) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002739429473877
(48) DESCRIBE `avid_specials` 0.0012588500976562
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 596 AND class = 'Ship') OR (item_id = 137 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.0011692047119141
(50) DESCRIBE `cruiselines` 0.001802921295166
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.0003199577331543
(52) DESCRIBE `orchid_image` 0.0014359951019287
(53) DESCRIBE `cruiselines` 0.0018439292907715
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00040197372436523
(55) DESCRIBE `ships` 0.0031321048736572
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '204') 0.00038313865661621
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029182434082031
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024986267089844
(59) DESCRIBE `avid_specials` 0.0014019012451172
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 204 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.0011179447174072
(61) DESCRIBE `cruiselines` 0.0019588470458984
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00030398368835449
(63) DESCRIBE `orchid_image` 0.0015108585357666
(64) DESCRIBE `cruiselines` 0.0018899440765381
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00038599967956543
(66) DESCRIBE `ships` 0.0025920867919922
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00037503242492676
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032520294189453
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025010108947754
(70) DESCRIBE `avid_specials` 0.0012288093566895
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 701 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.0013229846954346
(72) DESCRIBE `cruiselines` 0.0024538040161133
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 59))) 0.00034713745117188
(74) DESCRIBE `orchid_image` 0.0014910697937012
(75) DESCRIBE `cruiselines` 0.0018138885498047
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '59') 0.00029683113098145
(77) DESCRIBE `ships` 0.0026459693908691
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '990') 0.00028204917907715
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033402442932129
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033020973205566
(81) DESCRIBE `avid_specials` 0.0017020702362061
(82) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 990 AND class = 'Ship') OR (item_id = 59 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.0016920566558838
(83) DESCRIBE `cruiselines` 0.0028550624847412
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 268))) 0.00052118301391602
(85) DESCRIBE `orchid_image` 0.0021839141845703
(86) DESCRIBE `cruiselines` 0.0027239322662354
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '268') 0.00046396255493164
(88) DESCRIBE `ships` 0.0038938522338867
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1522') 0.00049805641174316
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032305717468262
(92) DESCRIBE `avid_specials` 0.0017211437225342
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1522 AND class = 'Ship') OR (item_id = 268 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.0012218952178955
(94) DESCRIBE `cruiselines` 0.0024430751800537
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00041818618774414
(96) DESCRIBE `orchid_image` 0.0017650127410889
(97) DESCRIBE `cruiselines` 0.0018899440765381
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029110908508301
(99) DESCRIBE `ships` 0.0026769638061523
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00031208992004395
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025081634521484
(103) DESCRIBE `avid_specials` 0.0012209415435791
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1330 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.0010719299316406
(105) DESCRIBE `cruiselines` 0.001878023147583
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00030994415283203
(107) DESCRIBE `orchid_image` 0.0016171932220459
(108) DESCRIBE `cruiselines` 0.002194881439209
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00026679039001465
(110) DESCRIBE `ships` 0.0027029514312744
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1482') 0.00030398368835449
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003049373626709
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(114) DESCRIBE `avid_specials` 0.0012969970703125
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1482 AND class = 'Ship') OR (item_id = 263 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.00099301338195801
(116) DESCRIBE `cruises` 0.0036079883575439
(117) SELECT `cruises`.* FROM `cruises` WHERE (id IN (4424, 21383, 26729, 27114, 27841, 29015, 29602, 29606, 34159, 34181)) ORDER BY FIND_IN_SET(id, '4424,21383,26729,27114,27841,29015,29602,29606,34159,34181') 0.0012860298156738
(118) DESCRIBE `cruiselines` 0.0020418167114258
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '144', '171', '31', '18', '101', '20', '8', '183', '7', '96', '120', '191', '12', '103', '221', '50', '29', '15', '268', '37', '91', '262', '28', '110', '33', '114', '141', '208', '232', '153', '187', '14', '24', '118', '49', '131', '181', '258', '156', '206', '151', '36', '204', '220', '212', '30', '256', '140', '4', '249', '238', '16', '47', '239', '174', '195', '35', '264', '113', '216', '211', '90', '146', '182', '188', '213', '159', '136', '168', '196', '237', '115', '209', '73', '180', '95', '57', '219', '248', '229', '59', '170', '184', '225', '231', '52', '108', '261', '88', '276', '269', '132', '275', '244', '82', '230', '105', '48', '119', '38', '64', '116', '240', '266', '39', '134', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,144,171,31,18,101,20,8,183,7,96,120,191,12,103,221,50,29,15,268,37,91,262,28,110,33,114,141,208,232,153,187,14,24,118,49,131,181,258,156,206,151,36,204,220,212,30,256,140,4,249,238,16,47,239,174,195,35,264,113,216,211,90,146,182,188,213,159,136,168,196,237,115,209,73,180,95,57,219,248,229,59,170,184,225,231,52,108,261,88,276,269,132,275,244,82,230,105,48,119,38,64,116,240,266,39,134,210,224,245') 0.0074260234832764
(120) DESCRIBE `ships` 0.0041990280151367
(121) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1247', '1554', '1555', '977', '1199', '1205', '1291', '1359', '1588', '1067', '1237', '407', '258', '1599', '1594', '22', '27', '461', '726', '21', '28', '393', '1424', '817', '1135', '1422', '349', '1423', '780', '1419', '1420', '1421', '1418', '1415', '452', '462', '113', '404', '24', '766', '265', '11', '439', '711', '1245', '1574', '10', '9', '330', '542', '1215', '585', '455', '1141', '674', '207', '770', '1460', '124', '797', '739', '974', '5', '635', '520', '792', '1572', '553', '1607', '1272', '1454', '1455', '573', '3', '116', '25', '517', '1372', '1193', '340', '1325', '78', '580', '1021', '874', '390', '1068', '1402', '253', '1095', '1284', '748', '1302', '4', '43', '285', '434', '1172', '1320', '332', '765', '14', '66', '421', '658', '791', '559', '1323', '1586', '1575', '582', '327', '590', '855', '970', '1259', '1260', '1571', '119', '286', '526', '678', '1139', '160', '406', '854', '993', '883', '1064', '454', '1492', '1678', '405', '616', '1321', '722', '1236', '1308', '823', '850', '1348', '1569', '114', '732', '1008', '81', '403', '441', '547', '1208', '784', '84', '163', '871', '338', '966', '1088', '1319', '1330', '348', '652', '657', '1108', '1326', '1327', '111', '325', '333', '451', '521', '1282', '1672', '1027', '1143', '1389', '262', '351', '610', '731', '859', '1376', '1581', '1587', '30', '31', '34', '35', '36', '37', '38', '39', '82', '378', '1012', '1579', '123', '389', '508', '1151', '1367', '1471', '148', '290', '314', '683', '1214', '1318', '1724', '93', '483', '626', '1243', '1405', '287', '751', '1013', '1157', '1398', '162', '394', '651', '1075', '545', '673', '1040', '1137', '1144', '1223', '1344', '1345', '291', '335', '352', '743', '852', '1063', '1159', '1233', '1343', '98', '768', '1043', '1145', '1168', '1413', '1452', '1453', '1604', '152', '401', '716', '818', '1602', '149', '669', '968', '1025', '1090', '1136', '1241', '1283', '1301', '1552', '45', '150', '151', '769', '988', '1149', '1163', '1303', '1373', '59', '467', '1463', '1526', '1711', '201', '223', '324', '639', '776', '905', '1152', '1226', '1448', '1449', '888', '1150', '1614', '108', '266', '601', '1539', '1647', '1717', '341', '503', '973', '1029', '1411', '1458', '74', '417', '790', '885', '1026', '1188', '1738', '796', '1231', '1351', '1489', '882', '954', '986', '996', '1049', '1055', '1253', '1292', '1496', '75', '105', '811', '851', '1034', '1047', '1366', '1505', '1609', '1704', '666', '704', '1073', '1154', '1230', '1285', '1362', '1368', '1382', '1408', '1417', '1632', '494', '574', '701', '837', '985', '1176', '1409', '1470', '1516', '1540', '1682', '205', '208', '480', '493', '738', '1037', '1474', '147', '857', '1134', '1518', '1740', '618', '836', '884', '1521', '1615', '423', '1054', '1196', '1407', '1627', '204', '422', '643', '1051', '1224', '1410', '1486', '448', '672', '1042', '1437', '1593', '671', '709', '795', '1138', '1148', '1229', '1262', '1517', '1522', '1716', '485', '717', '781', '938', '972', '994', '1352', '1383', '1384', '1501', '1628', '1017', '1514', '1619', '1684', '479', '665', '749', '995', '1254', '1645', '1713', '1715', '499', '821', '937', '1045', '1175', '1412', '1461', '1481', '1601', '1673', '1714', '17', '1011', '1106', '1240', '420', '1028', '1439', '1515', '1606', '313', '453', '1053', '1206', '1266', '1360', '1361', '1459', '1611', '212', '744', '1052', '1256', '1293', '1676', '375', '419', '487', '1639', '1708', '70', '775', '808', '969', '1035', '1048', '1071', '1089', '1110', '1189', '1232', '1274', '1612', '1631', '1722', '1723', '715', '798', '1192', '1338', '1697', '1729', '958', '1060', '1158', '1339', '1342', '1355', '1385', '69', '1036', '1491', '1679', '225', '288', '886')) ORDER BY FIND_IN_SET(id, '1127,1032,1247,1554,1555,977,1199,1205,1291,1359,1588,1067,1237,407,258,1599,1594,22,27,461,726,21,28,393,1424,817,1135,1422,349,1423,780,1419,1420,1421,1418,1415,452,462,113,404,24,766,265,11,439,711,1245,1574,10,9,330,542,1215,585,455,1141,674,207,770,1460,124,797,739,974,5,635,520,792,1572,553,1607,1272,1454,1455,573,3,116,25,517,1372,1193,340,1325,78,580,1021,874,390,1068,1402,253,1095,1284,748,1302,4,43,285,434,1172,1320,332,765,14,66,421,658,791,559,1323,1586,1575,582,327,590,855,970,1259,1260,1571,119,286,526,678,1139,160,406,854,993,883,1064,454,1492,1678,405,616,1321,722,1236,1308,823,850,1348,1569,114,732,1008,81,403,441,547,1208,784,84,163,871,338,966,1088,1319,1330,348,652,657,1108,1326,1327,111,325,333,451,521,1282,1672,1027,1143,1389,262,351,610,731,859,1376,1581,1587,30,31,34,35,36,37,38,39,82,378,1012,1579,123,389,508,1151,1367,1471,148,290,314,683,1214,1318,1724,93,483,626,1243,1405,287,751,1013,1157,1398,162,394,651,1075,545,673,1040,1137,1144,1223,1344,1345,291,335,352,743,852,1063,1159,1233,1343,98,768,1043,1145,1168,1413,1452,1453,1604,152,401,716,818,1602,149,669,968,1025,1090,1136,1241,1283,1301,1552,45,150,151,769,988,1149,1163,1303,1373,59,467,1463,1526,1711,201,223,324,639,776,905,1152,1226,1448,1449,888,1150,1614,108,266,601,1539,1647,1717,341,503,973,1029,1411,1458,74,417,790,885,1026,1188,1738,796,1231,1351,1489,882,954,986,996,1049,1055,1253,1292,1496,75,105,811,851,1034,1047,1366,1505,1609,1704,666,704,1073,1154,1230,1285,1362,1368,1382,1408,1417,1632,494,574,701,837,985,1176,1409,1470,1516,1540,1682,205,208,480,493,738,1037,1474,147,857,1134,1518,1740,618,836,884,1521,1615,423,1054,1196,1407,1627,204,422,643,1051,1224,1410,1486,448,672,1042,1437,1593,671,709,795,1138,1148,1229,1262,1517,1522,1716,485,717,781,938,972,994,1352,1383,1384,1501,1628,1017,1514,1619,1684,479,665,749,995,1254,1645,1713,1715,499,821,937,1045,1175,1412,1461,1481,1601,1673,1714,17,1011,1106,1240,420,1028,1439,1515,1606,313,453,1053,1206,1266,1360,1361,1459,1611,212,744,1052,1256,1293,1676,375,419,487,1639,1708,70,775,808,969,1035,1048,1071,1089,1110,1189,1232,1274,1612,1631,1722,1723,715,798,1192,1338,1697,1729,958,1060,1158,1339,1342,1355,1385,69,1036,1491,1679,225,288,886') 0.057751893997192
(122) DESCRIBE `cruisetypes` 0.0017819404602051
(123) DESCRIBE `destinations` 0.0024290084838867
(124) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '9', '2', '43', '25', '8', '53', '55', '39', '28', '26', '40', '38', '11', '30', '21', '48', '7', '44', '49', '45', '29', '56', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,9,2,43,25,8,53,55,39,28,26,40,38,11,30,21,48,7,44,49,45,29,56,34,10,52,46,32') 0.0025990009307861