or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Your 'Port' has been chosen Clear this filter or visit another page to change

Nawiliwili Kauai, Hawaii

Enquire about cruises in this region

Tour to Waimea, the "Grand Canyon of the Pacific." Visit Spouting Horn Park, where a reliable blowhole sends its geyser whoofing 50 feet into the air. Marvel at the breathtaking Na Pali Coast, unmarred by roads and unapproachable except by foot trail, helicopter

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

Total elapsed time: 0.099868535995483

# Query Time
(1) connect 0.0011730194091797
(2) DESCRIBE `ports` 0.0026359558105469
(3) SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'nawiliwili-kauai-hawaii') AND (orchid_available = 1) LIMIT 1 0.003403902053833
(4) DESCRIBE `destinations` 0.0029950141906738
(5) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 29))) 0.00067281723022461
(6) DESCRIBE `avid_specials` 0.0020599365234375
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '29' 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.001737117767334
(8) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00041389465332031
(9) SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '383') 0.0027289390563965
(10) SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '383') 0.0026090145111084
(11) DESCRIBE `cruises` 0.0045249462127686
(12) SELECT `cruises`.* FROM `cruises` WHERE (id IN (43678, 69778, 69819, 63072, 74726, 69326, 69327, 69328, 73388, 73389)) ORDER BY FIND_IN_SET(id, '43678,69778,69819,63072,74726,69326,69327,69328,73388,73389') 0.0023360252380371
(13) DESCRIBE `cruiselines` 0.025993824005127
(14) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('20', '23', '18', '218', '91', '14', '26', '24', '262', '151', '159')) ORDER BY FIND_IN_SET(id, '20,23,18,218,91,14,26,24,262,151,159') 0.0076291561126709
(15) DESCRIBE `ships` 0.01751708984375
(16) SELECT `ships`.* FROM `ships` WHERE (id IN ('404', '98', '290', '451', '441', '547', '678', '66', '580', '75', '105', '108', '287', '394', '485', '657', '1108', '1303', '1474', '74', '348', '389', '616', '692')) ORDER BY FIND_IN_SET(id, '404,98,290,451,441,547,678,66,580,75,105,108,287,394,485,657,1108,1303,1474,74,348,389,616,692') 0.0039291381835938
(17) DESCRIBE `cruisetypes` 0.0026609897613525
(18) DESCRIBE `destinations` 0.0029098987579346
(19) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('29', '43', '40', '35', '48')) ORDER BY FIND_IN_SET(id, '29,43,40,35,48') 0.00130295753479
(20) DESCRIBE `ports` 0.0099070072174072
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00072789192199707