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

 
  • Pacific Explorer, Moreton Island ex Sydney Return

    Nights 4 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2019: 25 Mar, 1 Apr, 23 Apr, 13 May, 28 May, 11 Jun, 6 Jul, 2 Sep, 30 Sep, 11 Nov, 18 Nov, 30 Nov, 5 Dec 2020: 23 Mar, 30 Mar, 11 May, 24 Jun, 15 Jul, 17 Sep, 21 Sep, 8 Oct
    Ports of Call Sydney, Moreton Island

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Aria, New Guinea Islands Encounter ex Brisbane Roundtrip

    Nights 10 Ship Pacific Aria
    Star Rating 3 Star Departs Brisbane, QLD, Australia
    Sailing 2019: 26 Mar, 13 Aug, 10 Sep, 19 Nov
    Ports of Call Brisbane, Alotau, Kitava Island, Rabaul, Kiriwina Island, Conflict Islands

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Explorer, Comedy Cruise ex Sydney Return

    Nights 3 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2019: 29 Mar, 27 Apr, 10 May, 8 Jun, 15 Jun, 19 Jul, 30 Aug, 27 Sep, 4 Oct, 8 Nov, 22 Nov, 14 Dec, 27 Dec 2020: 16 Jan, 27 Mar, 11 Apr, 24 Apr, 8 May, 15 May, 5 Jun, 31 Jul, 21 Aug, 4 Sep, 25 Sep
    Ports of Call Sydney

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Dawn, Pacific Island Hopper ex Brisbane Roundtrip

    Nights 7 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2019: 23 Mar, 30 Mar, 13 Apr, 27 Apr, 11 May, 8 Jun, 20 Jul, 14 Sep, 21 Sep, 12 Oct, 26 Oct, 23 Nov 2020: 18 Jan, 25 Jan, 7 Mar, 28 Mar, 30 May, 27 Jun, 4 Jul, 15 Aug, 5 Sep, 19 Sep, 26 Sep
    Ports of Call Brisbane, Noumea, Lifou, Port Vila Vanuatu

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Explorer, A Taste of New Caledonia ex Sydney Return

    Nights 8 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2019: 5 Apr, 20 May, 12 Aug, 6 Sep 2020: 28 Jun, 3 Aug
    Ports of Call Sydney, Noumea, Mare Island, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Aria, Comedy Cruise ex Brisbane to Auckland

    Nights 4 Ship Pacific Aria
    Star Rating 3 Star Departs Brisbane, QLD, Australia
    Sailing 2019: 5 Apr
    Ports of Call Brisbane, Auckland
    Please enquire about this cruise for pricing.
  • Pacific Dawn, Comedy Cruise ex Brisbane Return

    Nights 3 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2019: 6 Apr, 4 May, 6 Jul, 27 Jul, 28 Sep, 19 Oct, 9 Nov, 14 Dec, 27 Dec 2020: 15 Feb, 21 Mar, 18 Apr, 2 May, 15 May, 13 Jun, 11 Jul, 8 Aug, 12 Sep, 10 Oct
    Ports of Call Brisbane

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Dawn, Whitsundays (Airlie Beach) ex Brisbane Roundtrip

    Nights 4 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2019: 9 Apr, 7 May, 4 Jun, 9 Jul, 1 Oct, 22 Oct, 12 Nov, 10 Dec 2020: 7 Jan, 4 Feb, 18 Feb, 3 Mar, 24 Mar, 21 Apr, 16 Jun, 14 Jul, 11 Aug, 22 Aug, 15 Sep, 13 Oct
    Ports of Call Brisbane, Airlie Beach

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Aria, Napier Cruise ex Auckland Return

    Nights 4 Ship Pacific Aria
    Star Rating 3 Star Departs Auckland, New Zealand
    Sailing 2019: 9 Apr 2020: 30 Apr
    Ports of Call Auckland, Napier

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

  • Pacific Explorer, Discover Vanuatu ex Sydney Roundtrip

    Nights 10 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2019: 13 Apr
    Ports of Call Sydney, Noumea, Mystery Island, Port Vila Vanuatu, Mare Island

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

 

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

Total elapsed time: 0.44096684455872

# Query Time
(1) connect 0.00070691108703613
(2) DESCRIBE `cruises` 0.0032079219818115
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62161, 65470, 62156, 64368, 67246, 78909, 11217, 62566, 67145, 67250)) ORDER BY FIND_IN_SET(id, '62161,65470,62156,64368,67246,78909,11217,62566,67145,67250') 0.001600980758667
(4) DESCRIBE `cruises` 0.0027918815612793
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00035786628723145
(6) DESCRIBE `ships` 0.0027070045471191
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00049495697021484
(8) DESCRIBE `ships` 0.0024178028106689
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.0003361701965332
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002589225769043
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024199485778809
(12) DESCRIBE `itineraries` 0.0054099559783936
(13) DESCRIBE `ports` 0.0014269351959229
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003669261932373
(15) DESCRIBE `ports` 0.0014631748199463
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(17) DESCRIBE `ports` 0.0014679431915283
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044107437133789
(19) DESCRIBE `sailingdates` 0.0011630058288574
(20) DESCRIBE `ports` 0.0012760162353516
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037002563476562
(22) DESCRIBE `ports` 0.0012798309326172
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(24) DESCRIBE `ports` 0.0012531280517578
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00028109550476074
(26) DESCRIBE `ports` 0.0013079643249512
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00026106834411621
(28) DESCRIBE `ports` 0.0012850761413574
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028300285339355
(30) DESCRIBE `ports` 0.0013079643249512
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(32) DESCRIBE `avid_specials` 0.0011460781097412
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010330677032471
(34) DESCRIBE `cruiselines` 0.0018730163574219
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003659725189209
(36) DESCRIBE `orchid_image` 0.0014419555664062
(37) DESCRIBE `cruiselines` 0.001863956451416
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00027608871459961
(39) DESCRIBE `cruises` 0.002687931060791
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65470') 0.00036883354187012
(41) DESCRIBE `ships` 0.0026009082794189
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00034213066101074
(43) DESCRIBE `ships` 0.0024139881134033
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00027799606323242
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025796890258789
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024700164794922
(47) DESCRIBE `itineraries` 0.0012519359588623
(48) DESCRIBE `ports` 0.0012509822845459
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029492378234863
(50) DESCRIBE `ports` 0.0012409687042236
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029301643371582
(52) DESCRIBE `ports` 0.001230001449585
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026607513427734
(54) DESCRIBE `sailingdates` 0.0010969638824463
(55) DESCRIBE `ports` 0.001248836517334
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033211708068848
(57) DESCRIBE `ports` 0.0015521049499512
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00032401084899902
(59) DESCRIBE `ports` 0.00130295753479
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0003049373626709
(61) DESCRIBE `ports` 0.0012390613555908
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00027203559875488
(63) DESCRIBE `ports` 0.0012822151184082
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00029897689819336
(65) DESCRIBE `ports` 0.0014960765838623
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00030207633972168
(67) DESCRIBE `ports` 0.001392126083374
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00077009201049805
(69) DESCRIBE `ports` 0.0013132095336914
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00029587745666504
(71) DESCRIBE `ports` 0.0012481212615967
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00029301643371582
(73) DESCRIBE `ports` 0.0013258457183838
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00028491020202637
(75) DESCRIBE `ports` 0.0014081001281738
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00040507316589355
(77) DESCRIBE `ports` 0.0016000270843506
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00032305717468262
(79) DESCRIBE `ports` 0.0013580322265625
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00038003921508789
(81) DESCRIBE `ports` 0.0012600421905518
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031208992004395
(83) DESCRIBE `avid_specials` 0.0011351108551025
(84) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65470 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010180473327637
(85) DESCRIBE `cruiselines` 0.0017869472503662
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031185150146484
(87) DESCRIBE `orchid_image` 0.0014560222625732
(88) DESCRIBE `cruiselines` 0.0019979476928711
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00027012825012207
(90) DESCRIBE `cruises` 0.0025649070739746
(91) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62156') 0.00034594535827637
(92) DESCRIBE `ships` 0.0026910305023193
(93) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00042009353637695
(94) DESCRIBE `ships` 0.0025959014892578
(95) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00032806396484375
(96) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00028800964355469
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00027918815612793
(98) DESCRIBE `itineraries` 0.0012829303741455
(99) DESCRIBE `ports` 0.0021378993988037
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047802925109863
(101) DESCRIBE `ports` 0.0018610954284668
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040483474731445
(103) DESCRIBE `ports` 0.0018818378448486
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039386749267578
(105) DESCRIBE `sailingdates` 0.0015709400177002
(106) DESCRIBE `ports` 0.0014028549194336
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037288665771484
(108) DESCRIBE `ports` 0.0014820098876953
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030708312988281
(110) DESCRIBE `ports` 0.0012800693511963
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029611587524414
(112) DESCRIBE `ports` 0.0013189315795898
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(114) DESCRIBE `avid_specials` 0.0011231899261475
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62156 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010659694671631
(116) DESCRIBE `cruiselines` 0.0018231868743896
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00040197372436523
(118) DESCRIBE `orchid_image` 0.0014219284057617
(119) DESCRIBE `cruiselines` 0.0021998882293701
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037908554077148
(121) DESCRIBE `cruises` 0.003262996673584
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00034999847412109
(123) DESCRIBE `ships` 0.0025968551635742
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.0003809928894043
(125) DESCRIBE `ships` 0.0025300979614258
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00044107437133789
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(129) DESCRIBE `itineraries` 0.0015199184417725
(130) DESCRIBE `ports` 0.0018680095672607
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00057005882263184
(132) DESCRIBE `ports` 0.0017399787902832
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0003359317779541
(134) DESCRIBE `ports` 0.0013141632080078
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028586387634277
(136) DESCRIBE `sailingdates` 0.0014748573303223
(137) DESCRIBE `ports` 0.001439094543457
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034785270690918
(139) DESCRIBE `ports` 0.0012900829315186
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028109550476074
(141) DESCRIBE `ports` 0.0012681484222412
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00037503242492676
(143) DESCRIBE `ports` 0.0013558864593506
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028300285339355
(145) DESCRIBE `ports` 0.0012471675872803
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030303001403809
(147) DESCRIBE `ports` 0.0012969970703125
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00026798248291016
(149) DESCRIBE `ports` 0.0013229846954346
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00029587745666504
(151) DESCRIBE `ports` 0.001262903213501
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00027585029602051
(153) DESCRIBE `ports` 0.0013937950134277
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030899047851562
(155) DESCRIBE `ports` 0.0012691020965576
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0003199577331543
(157) DESCRIBE `avid_specials` 0.001298189163208
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0013558864593506
(159) DESCRIBE `cruiselines` 0.0018610954284668
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00035810470581055
(161) DESCRIBE `orchid_image` 0.0014970302581787
(162) DESCRIBE `cruiselines` 0.0017960071563721
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00035381317138672
(164) DESCRIBE `cruises` 0.0031421184539795
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67246') 0.00037097930908203
(166) DESCRIBE `ships` 0.0025539398193359
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.0004119873046875
(168) DESCRIBE `ships` 0.0026428699493408
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00042605400085449
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036382675170898
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034189224243164
(172) DESCRIBE `itineraries` 0.0019190311431885
(173) DESCRIBE `ports` 0.0018401145935059
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044393539428711
(175) DESCRIBE `ports` 0.0018858909606934
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041699409484863
(177) DESCRIBE `ports` 0.0018270015716553
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038814544677734
(179) DESCRIBE `sailingdates` 0.0015561580657959
(180) DESCRIBE `ports` 0.0018458366394043
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045609474182129
(182) DESCRIBE `ports` 0.0017950534820557
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(184) DESCRIBE `ports` 0.0017778873443604
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00046205520629883
(186) DESCRIBE `ports` 0.0018031597137451
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037503242492676
(188) DESCRIBE `ports` 0.0018148422241211
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00038385391235352
(190) DESCRIBE `ports` 0.0014350414276123
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00028705596923828
(192) DESCRIBE `ports` 0.0012938976287842
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00030207633972168
(194) DESCRIBE `ports` 0.0013279914855957
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030803680419922
(196) DESCRIBE `ports` 0.0012900829315186
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(198) DESCRIBE `ports` 0.001305103302002
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005950927734375
(200) DESCRIBE `avid_specials` 0.001802921295166
(201) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67246 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0017681121826172
(202) DESCRIBE `cruiselines` 0.0026910305023193
(203) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00054097175598145
(204) DESCRIBE `orchid_image` 0.001751184463501
(205) DESCRIBE `cruiselines` 0.0020148754119873
(206) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00035285949707031
(207) DESCRIBE `cruises` 0.0027198791503906
(208) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78909') 0.00034999847412109
(209) DESCRIBE `ships` 0.0027191638946533
(210) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00039815902709961
(211) DESCRIBE `ships` 0.0027937889099121
(212) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00040292739868164
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030398368835449
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002589225769043
(215) DESCRIBE `itineraries` 0.0015509128570557
(216) DESCRIBE `ports` 0.0015020370483398
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033378601074219
(218) DESCRIBE `ports` 0.0015618801116943
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00049519538879395
(220) DESCRIBE `ports` 0.0015749931335449
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034499168395996
(222) DESCRIBE `sailingdates` 0.0012979507446289
(223) DESCRIBE `ports` 0.0016481876373291
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043296813964844
(225) DESCRIBE `ports` 0.0013818740844727
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00030016899108887
(227) DESCRIBE `ports` 0.0012569427490234
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031900405883789
(229) DESCRIBE `ports` 0.0014219284057617
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028610229492188
(231) DESCRIBE `avid_specials` 0.0011718273162842
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78909 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010459423065186
(233) DESCRIBE `cruiselines` 0.001910924911499
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034809112548828
(235) DESCRIBE `orchid_image` 0.0014340877532959
(236) DESCRIBE `cruiselines` 0.0018768310546875
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00056695938110352
(238) DESCRIBE `cruises` 0.0034580230712891
(239) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '11217') 0.00044703483581543
(240) DESCRIBE `ships` 0.0029599666595459
(241) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00054311752319336
(242) DESCRIBE `ships` 0.0029568672180176
(243) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00038290023803711
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(246) DESCRIBE `itineraries` 0.0013737678527832
(247) DESCRIBE `ports` 0.0013871192932129
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037002563476562
(249) DESCRIBE `ports` 0.0015678405761719
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031900405883789
(251) DESCRIBE `ports` 0.001323938369751
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00032496452331543
(253) DESCRIBE `sailingdates` 0.0011928081512451
(254) DESCRIBE `ports` 0.0016748905181885
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036787986755371
(256) DESCRIBE `ports` 0.0016031265258789
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00033903121948242
(258) DESCRIBE `ports` 0.001643180847168
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033307075500488
(260) DESCRIBE `ports` 0.0013349056243896
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034213066101074
(262) DESCRIBE `ports` 0.0013079643249512
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031900405883789
(264) DESCRIBE `ports` 0.0013160705566406
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028705596923828
(266) DESCRIBE `ports` 0.0019149780273438
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00045895576477051
(268) DESCRIBE `ports` 0.0019021034240723
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039315223693848
(270) DESCRIBE `avid_specials` 0.0018610954284668
(271) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 11217 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0017940998077393
(272) DESCRIBE `cruiselines` 0.0025460720062256
(273) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00049686431884766
(274) DESCRIBE `orchid_image` 0.0020530223846436
(275) DESCRIBE `cruiselines` 0.0027339458465576
(276) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00042915344238281
(277) DESCRIBE `cruises` 0.003187894821167
(278) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62566') 0.00035691261291504
(279) DESCRIBE `ships` 0.002626895904541
(280) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00041389465332031
(281) DESCRIBE `ships` 0.0028109550476074
(282) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00031304359436035
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(285) DESCRIBE `itineraries` 0.0013179779052734
(286) DESCRIBE `ports` 0.0018999576568604
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0005190372467041
(288) DESCRIBE `ports` 0.0017740726470947
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00035500526428223
(290) DESCRIBE `ports` 0.0014240741729736
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00030088424682617
(292) DESCRIBE `sailingdates` 0.0011250972747803
(293) DESCRIBE `ports` 0.0016579627990723
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036501884460449
(295) DESCRIBE `ports` 0.0013151168823242
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002899169921875
(297) DESCRIBE `ports` 0.0013110637664795
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00031089782714844
(299) DESCRIBE `ports` 0.0015430450439453
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00034999847412109
(301) DESCRIBE `ports` 0.001352071762085
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040102005004883
(303) DESCRIBE `ports` 0.0012779235839844
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002899169921875
(305) DESCRIBE `avid_specials` 0.0012168884277344
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62566 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010528564453125
(307) DESCRIBE `cruiselines` 0.0019409656524658
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00049400329589844
(309) DESCRIBE `orchid_image` 0.0021960735321045
(310) DESCRIBE `cruiselines` 0.0025529861450195
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037813186645508
(312) DESCRIBE `cruises` 0.0026159286499023
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67145') 0.00031495094299316
(314) DESCRIBE `ships` 0.0025179386138916
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00037789344787598
(316) DESCRIBE `ships` 0.0025558471679688
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00031781196594238
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026297569274902
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025320053100586
(320) DESCRIBE `itineraries` 0.0013120174407959
(321) DESCRIBE `ports` 0.001270055770874
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003211498260498
(323) DESCRIBE `ports` 0.001255989074707
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033402442932129
(325) DESCRIBE `ports` 0.001255989074707
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028610229492188
(327) DESCRIBE `sailingdates` 0.0011320114135742
(328) DESCRIBE `ports` 0.0014710426330566
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031399726867676
(330) DESCRIBE `ports` 0.0012960433959961
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028777122497559
(332) DESCRIBE `ports` 0.0014729499816895
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00031185150146484
(334) DESCRIBE `ports` 0.0014810562133789
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00038313865661621
(336) DESCRIBE `ports` 0.0018191337585449
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00061583518981934
(338) DESCRIBE `ports` 0.0014059543609619
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030994415283203
(340) DESCRIBE `avid_specials` 0.0011610984802246
(341) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67145 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0011410713195801
(342) DESCRIBE `cruiselines` 0.0020871162414551
(343) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00033688545227051
(344) DESCRIBE `orchid_image` 0.0014288425445557
(345) DESCRIBE `cruiselines` 0.0017809867858887
(346) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00047183036804199
(347) DESCRIBE `cruises` 0.0033490657806396
(348) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67250') 0.00037503242492676
(349) DESCRIBE `ships` 0.0026490688323975
(350) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00043988227844238
(351) DESCRIBE `ships` 0.0026640892028809
(352) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00042295455932617
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038504600524902
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030398368835449
(355) DESCRIBE `itineraries` 0.0014171600341797
(356) DESCRIBE `ports` 0.0014510154724121
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033283233642578
(358) DESCRIBE `ports` 0.0014429092407227
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(360) DESCRIBE `ports` 0.001446008682251
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(362) DESCRIBE `sailingdates` 0.0011489391326904
(363) DESCRIBE `ports` 0.0012938976287842
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035381317138672
(365) DESCRIBE `ports` 0.0012660026550293
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002748966217041
(367) DESCRIBE `ports` 0.0012829303741455
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031614303588867
(369) DESCRIBE `ports` 0.0013320446014404
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031900405883789
(371) DESCRIBE `ports` 0.0016579627990723
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0003359317779541
(373) DESCRIBE `ports` 0.0014119148254395
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00035190582275391
(375) DESCRIBE `ports` 0.0013060569763184
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00033688545227051
(377) DESCRIBE `ports` 0.0014190673828125
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00030994415283203
(379) DESCRIBE `ports` 0.0013689994812012
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030803680419922
(381) DESCRIBE `ports` 0.0013771057128906
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00026392936706543
(383) DESCRIBE `ports` 0.0015988349914551
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033116340637207
(385) DESCRIBE `ports` 0.0013048648834229
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(387) DESCRIBE `avid_specials` 0.0012240409851074
(388) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67250 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0010380744934082
(389) DESCRIBE `cruiselines` 0.0021729469299316
(390) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034618377685547
(391) DESCRIBE `orchid_image` 0.0014679431915283
(392) DESCRIBE `cruiselines` 0.0018229484558105
(393) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00029492378234863
(394) DESCRIBE `ships` 0.003040075302124
(395) SELECT `ships`.* FROM `ships` WHERE (id IN ('1402', '573', '1284', '1758')) ORDER BY FIND_IN_SET(id, '1402,573,1284,1758') 0.0010151863098145
(396) DESCRIBE `cruisetypes` 0.0015699863433838
(397) DESCRIBE `destinations` 0.0026669502258301
(398) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00087404251098633
(399) DESCRIBE `cruiselines` 0.0025269985198975
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00039505958557129
(401) DESCRIBE `cruiselines` 0.0027740001678467
(402) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00061893463134766