or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

We'd love to hear from You

Please either call us toll-free on 0800 60 82 60 or complete your details below, let us know how we can be of help, and we'll be in touch.

You are enquiring about: 7 Night Hawaii Cruise Package

Norwegian Cruise Line
7
Pride of America
How would you prefer to be contacted?

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

Total elapsed time: 0.10098576545715

# Query Time
(1) connect 0.001086950302124
(2) DESCRIBE `specials` 0.0063281059265137
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '7-night-hawaii-cruise-package') AND (orchid_available = 1) LIMIT 1 0.0013558864593506
(4) DESCRIBE `specialsailingdates` 0.0017120838165283
(5) DESCRIBE `sailingdates` 0.0014758110046387
(6) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 386454))) 0.00053596496582031
(7) DESCRIBE `cruises` 0.0037398338317871
(8) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 43678))) 0.00064206123352051
(9) DESCRIBE `cruiselines` 0.0028069019317627
(10) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00046205520629883
(11) SELECT MAX(day) from specialitineraries WHERE special_id = 1524704 AND type = 'pre' 0.00043916702270508
(12) SELECT MAX(day) from specialitineraries WHERE special_id = 1524704 AND type = 'post' 0.00038313865661621
(13) DESCRIBE `ships` 0.0035181045532227
(14) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00044393539428711
(15) DESCRIBE `cruises` 0.0046579837799072
(16) SELECT `cruises`.* FROM `cruises` WHERE (id IN (34165, 34185, 34711, 38185, 44275, 44276, 48660, 49176, 49177, 51126)) ORDER BY FIND_IN_SET(id, '34165,34185,34711,38185,44275,44276,48660,49176,49177,51126') 0.0019998550415039
(17) DESCRIBE `cruiselines` 0.0030591487884521
(18) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '131', '12', '8', '171', '18', '144', '221', '31', '103', '101', '232', '156', '96', '239', '50', '258', '33', '29', '251', '15', '206', '191', '91', '114', '212', '14', '268', '24', '37', '170', '16', '187', '262', '256', '36', '28', '110', '195', '47', '240', '208', '146', '204', '220', '181', '174', '153', '118', '120', '229', '141', '49', '108', '151', '128', '38', '35', '159', '30', '216', '168', '196', '236', '88', '4', '200', '264', '90', '225', '238', '211', '73', '140', '39', '147', '184', '249', '57', '59', '48', '275', '132', '213', '257', '276', '219', '64', '261', '113', '182', '115', '230', '237', '188', '95', '180', '248', '231', '52', '209', '116', '266', '235', '62', '105', '82', '134', '177', '244', '119', '210', '224', '245', '263')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,131,12,8,171,18,144,221,31,103,101,232,156,96,239,50,258,33,29,251,15,206,191,91,114,212,14,268,24,37,170,16,187,262,256,36,28,110,195,47,240,208,146,204,220,181,174,153,118,120,229,141,49,108,151,128,38,35,159,30,216,168,196,236,88,4,200,264,90,225,238,211,73,140,39,147,184,249,57,59,48,275,132,213,257,276,219,64,261,113,182,115,230,237,188,95,180,248,231,52,209,116,266,235,62,105,82,134,177,244,119,210,224,245,263') 0.0066158771514893
(19) DESCRIBE `ships` 0.0032320022583008
(20) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1555', '1324', '517', '974', '1032', '1794', '1292', '797', '22', '461', '21', '393', '28', '977', '330', '207', '258', '1205', '1599', '480', '349', '1291', '737', '1010', '11', '10', '1199', '439', '404', '333', '1417', '780', '986', '9', '739', '1135', '1588', '14', '726', '265', '1272', '454', '855', '1677', '24', '817', '25', '1359', '770', '731', '1067', '859', '1607', '1237', '3', '113', '1481', '38', '34', '837', '31', '37', '378', '1372', '985', '1594', '1239', '542', '1163', '1744', '1768', '748', '66', '390', '1320', '1526', '1579', '43', '573', '1323', '1422', '1424', '526', '970', '1402', '1413', '39', '1420', '30', '36', '327', '407', '854', '882', '1012', '1411', '1419', '1423', '332', '1418', '1421', '582', '1410', '27', '1454', '160', '590', '1013', '1586', '1773', '791', '792', '674', '958', '1552', '1245', '1284', '580', '35', '114', '441', '1183', '1308', '455', '1184', '1348', '1587', '585', '1193', '1303', '1376', '162', '1415', '1236', '1682', '434', '1159', '1742', '325', '722', '857', '1382', '1461', '1501', '639', '644', '858', '1176', '711', '1215', '1405', '1574', '163', '452', '852', '1412', '462', '658', '683', '1289', '1408', '1678', '78', '81', '119', '285', '338', '1021', '1008', '1172', '673', '1168', '1019', '1373', '69', '1095', '1141', '211', '1160', '111', '610', '678', '776', '850', '1217', '286', '335', '1319', '1383', '1426', '1628', '1782', '1384', '1743', '1711', '45', '253', '1572', '1630', '314', '1569', '348', '403', '451', '851', '869', '1259', '1358', '405', '766', '818', '1302', '1760', '553', '626', '651', '749', '968', '4', '508', '1068', '1266', '1455', '70', '116', '966', '1108', '124', '148', '386', '467', '944', '1082', '1330', '1632', '63', '324', '385', '389', '616', '768', '1260', '1301', '1562', '84', '262', '340', '375', '485', '885', '1195', '1672', '108', '123', '291', '1325', '198', '421', '635', '663', '1639', '1751', '287', '784', '1064', '1088', '483', '1212', '1322', '1575', '98', '1614', '1721', '290', '1208', '1580', '1581', '1781', '652', '703', '883', '954', '1492', '1020', '394', '401', '1321', '1724', '147', '657', '1139', '1398', '1486', '1611', '1722', '1750', '406', '716', '1269', '1601', '1717', '547', '1268', '1539', '1615', '223', '1557', '1738', '149', '150', '152', '341', '516', '1143', '1282', '1326', '1327', '1437', '1445', '1571', '1645', '151', '559', '704', '775', '796', '1771', '717', '1040', '1075', '1704', '105', '545', '886', '1262', '1270', '1444', '1679', '1681', '503', '790', '1151', '1673', '1684', '75', '656', '982', '1254', '1367', '1389', '1063', '1318', '1676', '1740', '205', '351', '574', '761', '1561', '1766', '1043', '1213', '1218', '1471', '1540', '1566', '868', '1144', '1157', '93', '701', '751', '1137', '1223', '1226', '1344', '82', '212', '479', '715', '874', '1027', '1029', '1214', '1229', '1343', '1716', '1767', '665', '808', '823', '884', '1158', '1283', '1452', '1453', '1604', '1772', '687', '1025', '1073', '1090', '1612', '1613', '1706', '201', '266', '795', '988', '1055', '1136', '1216', '1409', '1448', '1713', '1715', '1788', '417', '601', '905', '996', '1026', '1145', '1233', '1458', '1496', '1714', '1791', '695', '767', '1188', '1297', '1602', '1783', '643', '669', '707', '769', '888', '973', '1034', '1149', '1156', '1351', '1366', '1404', '1516', '1609', '448', '743', '979', '1049', '1150', '1155', '1196', '1222', '1231', '1345', '1360', '1361', '1362', '1368', '1414', '1459', '1522', '1647', '1730', '666', '685', '692', '920', '921', '927', '931', '1047', '1230', '1296', '1354', '1474', '1517', '1627', '1729', '74', '423', '914', '923', '997', '1004', '1110', '1253', '1295', '1518', '1567', '618', '915', '916')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1555,1324,517,974,1032,1794,1292,797,22,461,21,393,28,977,330,207,258,1205,1599,480,349,1291,737,1010,11,10,1199,439,404,333,1417,780,986,9,739,1135,1588,14,726,265,1272,454,855,1677,24,817,25,1359,770,731,1067,859,1607,1237,3,113,1481,38,34,837,31,37,378,1372,985,1594,1239,542,1163,1744,1768,748,66,390,1320,1526,1579,43,573,1323,1422,1424,526,970,1402,1413,39,1420,30,36,327,407,854,882,1012,1411,1419,1423,332,1418,1421,582,1410,27,1454,160,590,1013,1586,1773,791,792,674,958,1552,1245,1284,580,35,114,441,1183,1308,455,1184,1348,1587,585,1193,1303,1376,162,1415,1236,1682,434,1159,1742,325,722,857,1382,1461,1501,639,644,858,1176,711,1215,1405,1574,163,452,852,1412,462,658,683,1289,1408,1678,78,81,119,285,338,1021,1008,1172,673,1168,1019,1373,69,1095,1141,211,1160,111,610,678,776,850,1217,286,335,1319,1383,1426,1628,1782,1384,1743,1711,45,253,1572,1630,314,1569,348,403,451,851,869,1259,1358,405,766,818,1302,1760,553,626,651,749,968,4,508,1068,1266,1455,70,116,966,1108,124,148,386,467,944,1082,1330,1632,63,324,385,389,616,768,1260,1301,1562,84,262,340,375,485,885,1195,1672,108,123,291,1325,198,421,635,663,1639,1751,287,784,1064,1088,483,1212,1322,1575,98,1614,1721,290,1208,1580,1581,1781,652,703,883,954,1492,1020,394,401,1321,1724,147,657,1139,1398,1486,1611,1722,1750,406,716,1269,1601,1717,547,1268,1539,1615,223,1557,1738,149,150,152,341,516,1143,1282,1326,1327,1437,1445,1571,1645,151,559,704,775,796,1771,717,1040,1075,1704,105,545,886,1262,1270,1444,1679,1681,503,790,1151,1673,1684,75,656,982,1254,1367,1389,1063,1318,1676,1740,205,351,574,761,1561,1766,1043,1213,1218,1471,1540,1566,868,1144,1157,93,701,751,1137,1223,1226,1344,82,212,479,715,874,1027,1029,1214,1229,1343,1716,1767,665,808,823,884,1158,1283,1452,1453,1604,1772,687,1025,1073,1090,1612,1613,1706,201,266,795,988,1055,1136,1216,1409,1448,1713,1715,1788,417,601,905,996,1026,1145,1233,1458,1496,1714,1791,695,767,1188,1297,1602,1783,643,669,707,769,888,973,1034,1149,1156,1351,1366,1404,1516,1609,448,743,979,1049,1150,1155,1196,1222,1231,1345,1360,1361,1362,1368,1414,1459,1522,1647,1730,666,685,692,920,921,927,931,1047,1230,1296,1354,1474,1517,1627,1729,74,423,914,923,997,1004,1110,1253,1295,1518,1567,618,915,916') 0.049304008483887
(21) DESCRIBE `cruisetypes` 0.0019130706787109
(22) DESCRIBE `destinations` 0.0027918815612793
(23) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '39', '44', '55', '53', '26', '28', '38', '49', '11', '21', '40', '7', '56', '30', '48', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,39,44,55,53,26,28,38,49,11,21,40,7,56,30,48,46,29,45,34,10,52,32') 0.0024819374084473