or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 0.18345427513123

# Query Time
(1) connect 0.00053811073303223
(2) DESCRIBE `cruises` 0.0036098957061768
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45260, 45259)) ORDER BY FIND_IN_SET(id, '45258,45260,45259') 0.0018999576568604
(4) DESCRIBE `cruises` 0.0043048858642578
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 5.1975250244141E-5
(6) DESCRIBE `ships` 0.003835916519165
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00052213668823242
(8) DESCRIBE `ships` 0.0043649673461914
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00085997581481934
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003511905670166
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033903121948242
(12) DESCRIBE `itineraries` 0.0016500949859619
(13) DESCRIBE `ports` 0.0023729801177979
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00014400482177734
(15) DESCRIBE `ports` 0.0017039775848389
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046396255493164
(17) DESCRIBE `ports` 0.0016210079193115
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00048589706420898
(19) DESCRIBE `sailingdates` 0.0015668869018555
(20) DESCRIBE `ports` 0.0020079612731934
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00042510032653809
(22) DESCRIBE `ports` 0.0016410350799561
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00031399726867676
(24) DESCRIBE `ports` 0.0015380382537842
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00079607963562012
(26) DESCRIBE `ports` 0.0016419887542725
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00035500526428223
(28) DESCRIBE `ports` 0.0014839172363281
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00034689903259277
(30) DESCRIBE `ports` 0.0014162063598633
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00070095062255859
(32) DESCRIBE `ports` 0.001248836517334
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00032305717468262
(34) DESCRIBE `ports` 0.0015439987182617
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00027608871459961
(36) DESCRIBE `ports` 0.0013210773468018
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00033712387084961
(38) DESCRIBE `ports` 0.001439094543457
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00032305717468262
(40) DESCRIBE `ports` 0.0012760162353516
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00035214424133301
(42) DESCRIBE `ports` 0.0012989044189453
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.0003049373626709
(44) DESCRIBE `ports` 0.0014770030975342
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0003199577331543
(46) DESCRIBE `ports` 0.0013880729675293
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00041985511779785
(48) DESCRIBE `ports` 0.0014081001281738
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003809928894043
(50) DESCRIBE `ports` 0.0023279190063477
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00044417381286621
(52) DESCRIBE `avid_specials` 0.0013611316680908
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 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.001039981842041
(54) DESCRIBE `cruiselines` 0.0018808841705322
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00031709671020508
(56) DESCRIBE `orchid_image` 0.0016031265258789
(57) DESCRIBE `cruiselines` 0.0021450519561768
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00044012069702148
(59) DESCRIBE `cruises` 0.0035321712493896
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00043487548828125
(61) DESCRIBE `ships` 0.003687858581543
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00014710426330566
(63) DESCRIBE `ships` 0.0036361217498779
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00040292739868164
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037598609924316
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00059700012207031
(67) DESCRIBE `itineraries` 0.0017650127410889
(68) DESCRIBE `ports` 0.0017697811126709
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00044393539428711
(70) DESCRIBE `ports` 0.0017209053039551
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00039386749267578
(72) DESCRIBE `ports` 0.0018110275268555
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00037813186645508
(74) DESCRIBE `sailingdates` 0.0015609264373779
(75) DESCRIBE `ports` 0.0020730495452881
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046396255493164
(77) DESCRIBE `ports` 0.0018949508666992
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0005950927734375
(79) DESCRIBE `ports` 0.0017340183258057
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00039219856262207
(81) DESCRIBE `ports` 0.0018370151519775
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0003659725189209
(83) DESCRIBE `ports` 0.0016968250274658
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00038695335388184
(85) DESCRIBE `ports` 0.0021500587463379
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00036001205444336
(87) DESCRIBE `ports` 0.0017740726470947
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 2.0027160644531E-5
(89) DESCRIBE `ports` 0.0017349720001221
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041484832763672
(91) DESCRIBE `avid_specials` 0.0015730857849121
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0018939971923828
(93) DESCRIBE `cruiselines` 0.0027840137481689
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00046110153198242
(95) DESCRIBE `orchid_image` 0.002061128616333
(96) DESCRIBE `cruiselines` 0.0030272006988525
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00040602684020996
(98) DESCRIBE `cruises` 0.0031931400299072
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00077700614929199
(100) DESCRIBE `ships` 0.0039541721343994
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00051307678222656
(102) DESCRIBE `ships` 0.0037949085235596
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00013899803161621
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034308433532715
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031399726867676
(106) DESCRIBE `itineraries` 0.0020198822021484
(107) DESCRIBE `ports` 0.0016570091247559
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0002288818359375
(109) DESCRIBE `ports` 0.0016069412231445
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040602684020996
(111) DESCRIBE `ports` 0.0017759799957275
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00034499168395996
(113) DESCRIBE `sailingdates` 0.001262903213501
(114) DESCRIBE `ports` 0.0013830661773682
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00033402442932129
(116) DESCRIBE `ports` 0.0013010501861572
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028300285339355
(118) DESCRIBE `ports` 0.0011999607086182
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00029182434082031
(120) DESCRIBE `ports` 0.0012669563293457
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00037789344787598
(122) DESCRIBE `ports` 0.001276969909668
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00028800964355469
(124) DESCRIBE `ports` 0.0013442039489746
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00027298927307129
(126) DESCRIBE `ports` 0.0013120174407959
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0003349781036377
(128) DESCRIBE `ports` 0.0013158321380615
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00027894973754883
(130) DESCRIBE `ports` 0.001370906829834
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003509521484375
(132) DESCRIBE `ports` 0.0014069080352783
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00034284591674805
(134) DESCRIBE `avid_specials` 0.0012650489807129
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0012409687042236
(136) DESCRIBE `cruiselines` 0.002208948135376
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00038409233093262
(138) DESCRIBE `orchid_image` 0.0014808177947998
(139) DESCRIBE `cruiselines` 0.0018129348754883
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00028705596923828
(141) DESCRIBE `ships` 0.0030930042266846
(142) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00049901008605957
(143) DESCRIBE `cruisetypes` 0.0013630390167236
(144) DESCRIBE `destinations` 0.0020990371704102
(145) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.0004580020904541
(146) DESCRIBE `cruiselines` 0.0021908283233643
(147) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00040316581726074
(148) DESCRIBE `cruiselines` 0.002457857131958
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00043606758117676