Christmas in South Pacific - Oh Buoy Sale

$1 Deposits & up to $450 onboard credit*

Pacific Explorer, Christmas Cruise ex Brisbane Return

Nights	10	Ship	Pacific Explorer
Star Rating		Departs	Brisbane, QLD, Australia

Sailing	2020: 19 Dec
Ports of Call	Brisbane, Lifou, Isle of Pines, Noumea, Mystery Island, Port Vila Vanuatu

Special Pricing SpecialsPrice (Cabins)

Sailing Dates

Select a cabin to get pricing. Pricing is approximate.

NZ $2,129

NZ $2,309

NZ $1,679

Pacific Explorer, Christmas Cruise ex Brisbane Return

Pacific Explorer

Valid: 27 Nov 2019 - 25 Feb 2020

- 10 nights onboard Pacific Explorer
- All main meals & entertainment onboard
- Port charges & government fees

Bonus:
- Place an AU$1 deposit per person*
- Book an Interior or Oceanview stateroom & receive an AU$100 onboard credit per stateroom or book a Balcony stateroom & receive an AU$200 onboard credit per stateroom*

Special Conditions

*Valid for sale from 27 Nov 2019 until 25 Feb 2020, unless sold out prior. Fares are cruise only, per person twin share in NZD, inclusive of all discounts, charges and taxes (which are subject to change). Advertised fares are available until allocation is exhausted and may fluctuate during the campaign period. A non-refundable cruise deposit is due within 3 days of reservation. Full payment conditions apply. Onboard currency is in currency as specified, applies to the first two guests in the stateroom, is not transferable, non-refundable and cannot be used at the medical centre or casino. #AU$1 deposit per person is non-refundable and deposit conditions differ from the standard P&O Booking and Travel Conditions. Offer applies to cruises departing from 11 February 2020 booked at least 76 days prior to departure. Pay AU$1 per person deposit upfront and the remainder of the standard adult deposit amount for all passengers, including children as follows – for cruises departing between 22 June 2020 and 15 Aug 2020, 95 days prior to departure; for cruises departing between 16 Aug and 14 Sep 2020, 150 days prior to departure; for cruises departing between 15 Sep 2020 and 23 Nov 2020, 180 days prior to departure; and for cruises departing after 23 Nov 2020, 250 days prior to departure. For cruises departing between 11 Feb and 21 Jun 2020, remainder of deposit and final payment for cruise due 75 days before departure. Full payment is required for sailings booked within 75 days of departure. Standard cancellation and refunds conditions apply as per Booking and Travel Conditions. Campaign offers only available on P&O’s Value and Value Plus fare types only. Fare based on specified departure dates. Different fares apply to other dates listed. Valid for new bookings and not combinable with any other offer. Supplements apply for other room categories. Some oceanview rooms have obstructed views. Travel agents may charge additional fees - check with your travel agent. Whilst all information is correct at time of publication, offers are subject to change or withdrawal. Further conditions apply.

#	Query	Time
(1)	connect	0.0012009143829346
(2)	DESCRIBE `specials`	0.0089089870452881
(3)	SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'christmas-in-south-pacific-oh-buoy-sale') AND (orchid_available = 1) LIMIT 1	0.0023388862609863
(4)	DESCRIBE `cruises`	0.0043380260467529
(5)	SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80219)))	0.00066304206848145
(6)	DESCRIBE `avid_specials`	0.0019528865814209
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1643097 and class = 'Special') OR (item_id = 80219 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.0021860599517822
(8)	SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1643097')	0.00068902969360352
(9)	DESCRIBE `ships`	0.0044159889221191
(10)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402)))	0.00082087516784668
(11)	DESCRIBE `ships`	0.0058310031890869
(12)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402')	0.00074291229248047
(13)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3')	0.00049114227294922
(14)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3')	0.00048995018005371
(15)	DESCRIBE `itineraries`	0.002769947052002
(16)	DESCRIBE `ports`	0.0035068988800049
(17)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))	0.00076389312744141
(18)	DESCRIBE `ports`	0.0025959014892578
(19)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))	0.00064301490783691
(20)	DESCRIBE `ports`	0.0028598308563232
(21)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')	0.0006101131439209
(22)	DESCRIBE `specialsailingdates`	0.0022308826446533
(23)	DESCRIBE `sailingdates`	0.0024199485778809
(24)	SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494725)))	0.00083279609680176
(25)	DESCRIBE `ports`	0.0026710033416748
(26)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))	0.00054693222045898
(27)	DESCRIBE `ports`	0.0020101070404053
(28)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')	0.00048708915710449
(29)	DESCRIBE `ports`	0.0023620128631592
(30)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436)))	0.00076794624328613
(31)	DESCRIBE `ports`	0.0026509761810303
(32)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436')	0.00045204162597656
(33)	DESCRIBE `ports`	0.0024819374084473
(34)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439)))	0.00059103965759277
(35)	DESCRIBE `ports`	0.0021109580993652
(36)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439')	0.00048589706420898
(37)	DESCRIBE `ports`	0.0019910335540771
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435)))	0.00042486190795898
(39)	DESCRIBE `ports`	0.0018088817596436
(40)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435')	0.0003969669342041
(41)	DESCRIBE `ports`	0.0019469261169434
(42)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438)))	0.0004429817199707
(43)	DESCRIBE `ports`	0.0019199848175049
(44)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438')	0.00046777725219727
(45)	DESCRIBE `ports`	0.0021851062774658
(46)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80)))	0.00047802925109863
(47)	DESCRIBE `ports`	0.0022389888763428
(48)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80')	0.00040411949157715
(49)	DESCRIBE `ports`	0.0018610954284668
(50)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))	0.00051689147949219
(51)	DESCRIBE `ports`	0.0017800331115723
(52)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')	0.00057601928710938
(53)	DESCRIBE `specialsmultipricing`	0.0027580261230469
(54)	DESCRIBE `leadpricing`	0.0027270317077637
(55)	DESCRIBE `specialspricing`	0.0029997825622559
(56)	DESCRIBE `cabins`	0.0030319690704346
(57)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12917)))	0.00075602531433105
(58)	DESCRIBE `cabins`	0.0029168128967285
(59)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12914)))	0.00076794624328613
(60)	DESCRIBE `cabins`	0.003000020980835
(61)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12924)))	0.00073909759521484
(62)	DESCRIBE `currencies`	0.0024650096893311
(63)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00064206123352051
(64)	DESCRIBE `currencies`	0.0017819404602051
(65)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00038003921508789
(66)	DESCRIBE `currencies`	0.0016911029815674
(67)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00051212310791016
(68)	DESCRIBE `cruiselines`	0.0029470920562744
(69)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37)))	0.00065112113952637
(70)	DESCRIBE `orchid_image`	0.0022130012512207
(71)	DESCRIBE `cruiselines`	0.0027179718017578
(72)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37')	0.00042390823364258
(73)	DESCRIBE `cruises`	0.0038549900054932
(74)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80219')	0.00048494338989258
(75)	DESCRIBE `deckplans`	0.0022718906402588
(76)	DESCRIBE `cabins`	0.00217604637146
(77)	DESCRIBE `shipphotos`	0.0020289421081543
(78)	DESCRIBE `cruiselines`	0.0027210712432861
(79)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37)))	0.00048398971557617
(80)	DESCRIBE `orchid_image`	0.0020160675048828
(81)	DESCRIBE `cruiselines`	0.0025739669799805
(82)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37')	0.00047612190246582
(83)	DESCRIBE `cruises`	0.0038020610809326
(84)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')	0.0020620822906494
(85)	DESCRIBE `cruiselines`	0.0031349658966064
(86)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')	0.0023579597473145
(87)	DESCRIBE `ships`	0.0044999122619629
(88)	SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')	0.015239953994751
(89)	DESCRIBE `cruisetypes`	0.0024459362030029
(90)	DESCRIBE `destinations`	0.002838134765625
(91)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')	0.0024809837341309
(92)	DESCRIBE `cruises`	0.0040888786315918
(93)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34168')	0.00060105323791504

Query

Time

(1)

connect

0.0012009143829346

(2)

DESCRIBE `specials`

0.0089089870452881

(3)

SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'christmas-in-south-pacific-oh-buoy-sale') AND (orchid_available = 1) LIMIT 1

0.0023388862609863

(4)

DESCRIBE `cruises`

0.0043380260467529

(5)

SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80219)))

0.00066304206848145

(6)

DESCRIBE `avid_specials`

0.0019528865814209

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1643097 and class = 'Special') OR (item_id = 80219 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.0021860599517822

(8)

SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1643097')

0.00068902969360352

(9)

DESCRIBE `ships`

0.0044159889221191

(10)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402)))

0.00082087516784668

(11)

DESCRIBE `ships`

0.0058310031890869

(12)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402')

0.00074291229248047

(13)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3')

0.00049114227294922

(14)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3')

0.00048995018005371

(15)

DESCRIBE `itineraries`

0.002769947052002

(16)

DESCRIBE `ports`

0.0035068988800049

(17)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))

0.00076389312744141

(18)

DESCRIBE `ports`

0.0025959014892578

(19)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))

0.00064301490783691

(20)

DESCRIBE `ports`

0.0028598308563232

(21)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')

0.0006101131439209

(22)

DESCRIBE `specialsailingdates`

0.0022308826446533

(23)

DESCRIBE `sailingdates`

0.0024199485778809

(24)

SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494725)))

0.00083279609680176

(25)

DESCRIBE `ports`

0.0026710033416748

(26)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))

0.00054693222045898

(27)

DESCRIBE `ports`

0.0020101070404053

(28)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')

0.00048708915710449

(29)

DESCRIBE `ports`

0.0023620128631592

(30)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436)))

0.00076794624328613

(31)

DESCRIBE `ports`

0.0026509761810303

(32)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436')

0.00045204162597656

(33)

DESCRIBE `ports`

0.0024819374084473

(34)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439)))

0.00059103965759277

(35)

DESCRIBE `ports`

0.0021109580993652

(36)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439')

0.00048589706420898

(37)

DESCRIBE `ports`

0.0019910335540771

(38)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435)))

0.00042486190795898

(39)

DESCRIBE `ports`

0.0018088817596436

(40)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435')

0.0003969669342041

(41)

DESCRIBE `ports`

0.0019469261169434

(42)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438)))

0.0004429817199707

(43)

DESCRIBE `ports`

0.0019199848175049

(44)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438')

0.00046777725219727

(45)

DESCRIBE `ports`

0.0021851062774658

(46)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80)))

0.00047802925109863

(47)

DESCRIBE `ports`

0.0022389888763428

(48)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80')

0.00040411949157715

(49)

DESCRIBE `ports`

0.0018610954284668

(50)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27)))

0.00051689147949219

(51)

DESCRIBE `ports`

0.0017800331115723

(52)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27')

0.00057601928710938

(53)

DESCRIBE `specialsmultipricing`

0.0027580261230469

(54)

DESCRIBE `leadpricing`

0.0027270317077637

(55)

DESCRIBE `specialspricing`

0.0029997825622559

(56)

DESCRIBE `cabins`

0.0030319690704346

(57)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12917)))

0.00075602531433105

(58)

DESCRIBE `cabins`

0.0029168128967285

(59)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12914)))

0.00076794624328613

(60)

DESCRIBE `cabins`

0.003000020980835

(61)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 12924)))

0.00073909759521484

(62)

DESCRIBE `currencies`

0.0024650096893311

(63)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00064206123352051

(64)

DESCRIBE `currencies`

0.0017819404602051

(65)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00038003921508789

(66)

DESCRIBE `currencies`

0.0016911029815674

(67)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00051212310791016

(68)

DESCRIBE `cruiselines`

0.0029470920562744

(69)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37)))

0.00065112113952637

(70)

DESCRIBE `orchid_image`

0.0022130012512207

(71)

DESCRIBE `cruiselines`

0.0027179718017578

(72)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37')

0.00042390823364258

(73)

DESCRIBE `cruises`

0.0038549900054932

(74)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80219')

0.00048494338989258

(75)

DESCRIBE `deckplans`

0.0022718906402588

(76)

DESCRIBE `cabins`

0.00217604637146

(77)

DESCRIBE `shipphotos`

0.0020289421081543

(78)

DESCRIBE `cruiselines`

0.0027210712432861

(79)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37)))

0.00048398971557617

(80)

DESCRIBE `orchid_image`

0.0020160675048828

(81)

DESCRIBE `cruiselines`

0.0025739669799805

(82)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37')

0.00047612190246582

(83)

DESCRIBE `cruises`

0.0038020610809326

(84)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')

0.0020620822906494

(85)

DESCRIBE `cruiselines`

0.0031349658966064

(86)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')

0.0023579597473145

(87)

DESCRIBE `ships`

0.0044999122619629

(88)

SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')

0.015239953994751

(89)

DESCRIBE `cruisetypes`

0.0024459362030029

(90)

DESCRIBE `destinations`

0.002838134765625

(91)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')

0.0024809837341309

(92)

DESCRIBE `cruises`

0.0040888786315918

(93)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34168')

0.00060105323791504

My Favourite Cruises