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

Itinerary for Cruise America, Hawaii Cruise ex Honolulu Return

Cruise Itinerary

Day Port Arrive Depart
Day 1 Honolulu, Hawaii 07:00 PM
Day 2 Kahului-Maui, Hawaii 08:00 AM overnight
Day 3 Kahului-Maui, Hawaii 06:00 PM
Day 4 Hilo Hawaii 08:00 AM 06:00 PM
Day 5 Kailua Kona,Hawaii 07:00 AM 05:30 PM
Day 6 Nawiliwili Kauai, Hawaii 10:00 AM overnight
Day 7 Nawiliwili Kauai, Hawaii 02:00 PM
Day 8 Honolulu, Hawaii 07:00 AM

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

Total elapsed time: 0.60671424865723

# Query Time
(1) connect 0.0010960102081299
(2) DESCRIBE `specials` 0.0058679580688477
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '7-night-hawaii-cruise-package') AND (orchid_available = 1) LIMIT 1 0.0013551712036133
(4) DESCRIBE `cruises` 0.0037081241607666
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 43678))) 0.00066089630126953
(6) DESCRIBE `avid_specials` 0.0018689632415771
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1524704 and class = 'Special') OR (item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (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.0019371509552002
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1524704') 0.00049805641174316
(9) DESCRIBE `ships` 0.0043060779571533
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00069689750671387
(11) DESCRIBE `ships` 0.0038681030273438
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.000640869140625
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(15) DESCRIBE `itineraries` 0.001849889755249
(16) DESCRIBE `ports` 0.0026090145111084
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00073003768920898
(18) DESCRIBE `ports` 0.0020749568939209
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00053215026855469
(20) DESCRIBE `ports` 0.0019688606262207
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0011270046234131
(22) DESCRIBE `specialsailingdates` 0.0014970302581787
(23) DESCRIBE `sailingdates` 0.0018091201782227
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 386454))) 0.00060105323791504
(25) DESCRIBE `ports` 0.0020771026611328
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00080704689025879
(27) DESCRIBE `ports` 0.0020589828491211
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00045204162597656
(29) DESCRIBE `ports` 0.0018360614776611
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00061202049255371
(31) DESCRIBE `ports` 0.0020740032196045
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.0018949508666992
(33) DESCRIBE `ports` 0.0019810199737549
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00052809715270996
(35) DESCRIBE `ports` 0.0021138191223145
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00046586990356445
(37) DESCRIBE `ports` 0.0019440650939941
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00073885917663574
(39) DESCRIBE `ports` 0.0027170181274414
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00041317939758301
(41) DESCRIBE `ports` 0.0022270679473877
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00063395500183105
(43) DESCRIBE `ports` 0.0020630359649658
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00056290626525879
(45) DESCRIBE `ports` 0.0023159980773926
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00044822692871094
(47) DESCRIBE `ports` 0.0024211406707764
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00057721138000488
(49) DESCRIBE `ports` 0.0020020008087158
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00044012069702148
(51) DESCRIBE `ports` 0.0033540725708008
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00096297264099121
(53) DESCRIBE `ports` 0.0024800300598145
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00081110000610352
(55) DESCRIBE `ports` 0.002593994140625
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0005490779876709
(57) DESCRIBE `specialsmultipricing` 0.002072811126709
(58) DESCRIBE `leadpricing` 0.0020589828491211
(59) DESCRIBE `specialspricing` 0.0020039081573486
(60) DESCRIBE `cabins` 0.0020749568939209
(61) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 4781))) 0.00041294097900391
(62) DESCRIBE `cabins` 0.0019779205322266
(63) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 4771))) 0.00034594535827637
(64) DESCRIBE `cabins` 0.0020151138305664
(65) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 4778))) 0.00040507316589355
(66) DESCRIBE `currencies` 0.0017068386077881
(67) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00039482116699219
(68) DESCRIBE `currencies` 0.0016109943389893
(69) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00037908554077148
(70) DESCRIBE `currencies` 0.0020730495452881
(71) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00046086311340332
(72) DESCRIBE `cruiselines` 0.0031890869140625
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00048398971557617
(74) DESCRIBE `orchid_image` 0.0020630359649658
(75) DESCRIBE `cruiselines` 0.0026931762695312
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034189224243164
(77) DESCRIBE `cruises` 0.003309965133667
(78) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43678') 0.0004570484161377
(79) DESCRIBE `deckplans` 0.10816097259521
(80) DESCRIBE `cabins` 0.1080470085144
(81) DESCRIBE `shipphotos` 0.0021600723266602
(82) DESCRIBE `specialitineraries` 0.0020139217376709
(83) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'pre' AND special_id = '1524704') ORDER BY `order` ASC 0.00063490867614746
(84) DESCRIBE `ports` 0.0023219585418701
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00053906440734863
(86) DESCRIBE `ports` 0.0034079551696777
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0016260147094727
(88) DESCRIBE `ports` 0.0019879341125488
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0069639682769775
(90) DESCRIBE `ports` 0.003230094909668
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00059986114501953
(92) DESCRIBE `ports` 0.0041670799255371
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.0092520713806152
(94) DESCRIBE `ports` 0.008903980255127
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00059294700622559
(96) DESCRIBE `ports` 0.0055611133575439
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.0005040168762207
(98) DESCRIBE `ports` 0.0026421546936035
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.000579833984375
(100) DESCRIBE `ports` 0.0020549297332764
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00052118301391602
(102) DESCRIBE `ports` 0.0023770332336426
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00057482719421387
(104) DESCRIBE `ports` 0.0020010471343994
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00047898292541504
(106) DESCRIBE `ports` 0.0019588470458984
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.0072150230407715
(108) DESCRIBE `ports` 0.002100944519043
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.022490978240967
(110) DESCRIBE `ports` 0.00872802734375
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00047087669372559
(112) DESCRIBE `ports` 0.0020339488983154
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00049209594726562
(114) DESCRIBE `ports` 0.002018928527832
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.0076191425323486
(116) DESCRIBE `ports` 0.0020120143890381
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00048995018005371
(118) DESCRIBE `ports` 0.0024421215057373
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.023588895797729
(120) DESCRIBE `ports` 0.00394606590271
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00055694580078125
(122) DESCRIBE `ports` 0.0023229122161865
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00047492980957031
(124) DESCRIBE `ports` 0.0018649101257324
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00049304962158203
(126) DESCRIBE `ports` 0.0074260234832764
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.007490873336792
(128) DESCRIBE `ports` 0.021016836166382
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0010108947753906
(130) DESCRIBE `ports` 0.0018510818481445
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0007939338684082
(132) DESCRIBE `specialitineraries` 0.0029850006103516
(133) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'post' AND special_id = '1524704') ORDER BY `order` ASC 0.00093483924865723
(134) DESCRIBE `cruises` 0.0055351257324219
(135) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 63940, 71423, 63941, 43678, 67915, 75085)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,63940,71423,63941,43678,67915,75085') 0.0050070285797119
(136) DESCRIBE `cruiselines` 0.0036139488220215
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') 0.0021212100982666
(138) DESCRIBE `ships` 0.0042200088500977
(139) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') 0.0095069408416748
(140) DESCRIBE `cruisetypes` 0.010992050170898
(141) DESCRIBE `destinations` 0.014973878860474
(142) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') 0.010360956192017