or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

 
 

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

Total elapsed time: 0.22444915771484

# Query Time
(1) connect 0.0011169910430908
(2) DESCRIBE `cruises` 0.0041849613189697
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45260, 45259)) ORDER BY FIND_IN_SET(id, '45260,45259') 0.0017049312591553
(4) DESCRIBE `specials` 0.0048558712005615
(5) DESCRIBE `specials` 0.0053529739379883
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1595182') 0.00045680999755859
(7) DESCRIBE `ships` 0.0038058757781982
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00056791305541992
(9) DESCRIBE `ships` 0.0038840770721436
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00048112869262695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00052189826965332
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035214424133301
(13) DESCRIBE `itineraries` 0.0019168853759766
(14) DESCRIBE `ports` 0.0020320415496826
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0043370723724365
(16) DESCRIBE `ports` 0.0032849311828613
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00047516822814941
(18) DESCRIBE `ports` 0.0018789768218994
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00049304962158203
(20) DESCRIBE `specialsailingdates` 0.001554012298584
(21) DESCRIBE `sailingdates` 0.001662015914917
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504243))) 0.00052499771118164
(23) DESCRIBE `sailingdates` 0.0015509128570557
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504244))) 0.00037693977355957
(25) DESCRIBE `sailingdates` 0.0021440982818604
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504245))) 0.00036191940307617
(27) DESCRIBE `sailingdates` 0.0019090175628662
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504248))) 0.0004119873046875
(29) DESCRIBE `sailingdates` 0.0021610260009766
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504249))) 0.00051093101501465
(31) DESCRIBE `sailingdates` 0.0022208690643311
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504250))) 0.00043511390686035
(33) DESCRIBE `sailingdates` 0.002140998840332
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504251))) 0.00043988227844238
(35) DESCRIBE `sailingdates` 0.0020861625671387
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504252))) 0.0004279613494873
(37) DESCRIBE `sailingdates` 0.0018980503082275
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504253))) 0.00039386749267578
(39) DESCRIBE `sailingdates` 0.001896858215332
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504254))) 0.00046014785766602
(41) DESCRIBE `sailingdates` 0.0019080638885498
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504255))) 0.00040483474731445
(43) DESCRIBE `sailingdates` 0.0020079612731934
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504256))) 0.0003809928894043
(45) DESCRIBE `ports` 0.0021519660949707
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00044512748718262
(47) DESCRIBE `ports` 0.0023651123046875
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041913986206055
(49) DESCRIBE `ports` 0.0018041133880615
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00046086311340332
(51) DESCRIBE `ports` 0.0021469593048096
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.0003659725189209
(53) DESCRIBE `ports` 0.0023009777069092
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00053811073303223
(55) DESCRIBE `ports` 0.0025589466094971
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038599967956543
(57) DESCRIBE `ports` 0.001939058303833
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00041699409484863
(59) DESCRIBE `ports` 0.0020380020141602
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0003819465637207
(61) DESCRIBE `ports` 0.0019171237945557
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00040102005004883
(63) DESCRIBE `ports` 0.0020089149475098
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00047683715820312
(65) DESCRIBE `ports` 0.0022051334381104
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040507316589355
(67) DESCRIBE `ports` 0.002065896987915
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003812313079834
(69) DESCRIBE `cruises` 0.0035619735717773
(70) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45260))) 0.00049400329589844
(71) DESCRIBE `avid_specials` 0.0017890930175781
(72) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1595182 and class = 'Special') OR (item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0011818408966064
(73) DESCRIBE `cruiselines` 0.0032620429992676
(74) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0003960132598877
(75) DESCRIBE `orchid_image` 0.0022850036621094
(76) DESCRIBE `cruiselines` 0.002863883972168
(77) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00052595138549805
(78) DESCRIBE `specials` 0.0049371719360352
(79) DESCRIBE `specials` 0.0055019855499268
(80) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1595215') 0.00046110153198242
(81) DESCRIBE `ships` 0.0041089057922363
(82) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00049591064453125
(83) DESCRIBE `ships` 0.003633975982666
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.0004270076751709
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036406517028809
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039291381835938
(87) DESCRIBE `itineraries` 0.0018661022186279
(88) DESCRIBE `ports` 0.0023500919342041
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045204162597656
(90) DESCRIBE `ports` 0.002514123916626
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00055289268493652
(92) DESCRIBE `ports` 0.002284049987793
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00038385391235352
(94) DESCRIBE `specialsailingdates` 0.0015912055969238
(95) DESCRIBE `sailingdates` 0.0017600059509277
(96) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504333))) 0.00046110153198242
(97) DESCRIBE `sailingdates` 0.0023739337921143
(98) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504335))) 0.0004429817199707
(99) DESCRIBE `sailingdates` 0.0021259784698486
(100) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504336))) 0.00037980079650879
(101) DESCRIBE `sailingdates` 0.0016939640045166
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504337))) 0.00036811828613281
(103) DESCRIBE `sailingdates` 0.0017440319061279
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504339))) 0.0003960132598877
(105) DESCRIBE `sailingdates` 0.0021660327911377
(106) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 504340))) 0.00036907196044922
(107) DESCRIBE `ports` 0.0020220279693604
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00042605400085449
(109) DESCRIBE `ports` 0.0018408298492432
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00037622451782227
(111) DESCRIBE `ports` 0.00180983543396
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00043296813964844
(113) DESCRIBE `ports` 0.0017380714416504
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00037503242492676
(115) DESCRIBE `ports` 0.0026540756225586
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044894218444824
(117) DESCRIBE `ports` 0.0018091201782227
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00037407875061035
(119) DESCRIBE `ports` 0.0019519329071045
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00048303604125977
(121) DESCRIBE `ports` 0.0018460750579834
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00037598609924316
(123) DESCRIBE `ports` 0.001788854598999
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00047707557678223
(125) DESCRIBE `ports` 0.0018768310546875
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00037288665771484
(127) DESCRIBE `ports` 0.0018579959869385
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00045108795166016
(129) DESCRIBE `ports` 0.0020492076873779
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00038480758666992
(131) DESCRIBE `cruises` 0.0034139156341553
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00048398971557617
(133) DESCRIBE `avid_specials` 0.0020570755004883
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1595215 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0011899471282959
(135) DESCRIBE `cruiselines` 0.0028619766235352
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0005340576171875
(137) DESCRIBE `orchid_image` 0.0020909309387207
(138) DESCRIBE `cruiselines` 0.0026381015777588
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00051593780517578
(140) DESCRIBE `ships` 0.0038800239562988
(141) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.0005638599395752
(142) DESCRIBE `cruisetypes` 0.0015280246734619
(143) DESCRIBE `destinations` 0.0023200511932373
(144) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.0005650520324707
(145) DESCRIBE `cruiselines` 0.0027339458465576
(146) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00040102005004883
(147) DESCRIBE `cruiselines` 0.0025300979614258
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00040602684020996