Your 'Port' has been chosen Clear this filter or visit another page to change

Atuona (French Polynesia)

Atuona, located on Atuona Bay on the southern side of Hiva Oa island, French Polynesia, is the administrative centre of the commune of Hiva-Oa. Atuona was the capital of all the Marquesas Islands but it has been replaced by Taiohae.

Cruise Season – Jan - Dec
Currency – CFP franc (XPF)
Language – French, Tahitian
Electricity – 2 angled flat pins and 1 round pin centred below Australian style
Time – GMT minus ten hours
International Country Telephone Code – + 689

#	Query	Time
(1)	connect	0.0013320446014404
(2)	DESCRIBE `ports`	0.0036120414733887
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'atuona-french-polynesia-') AND (orchid_available = 1) LIMIT 1	0.069413185119629
(4)	DESCRIBE `destinations`	0.0053679943084717
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43)))	0.00084400177001953
(6)	DESCRIBE `avid_specials`	0.0046689510345459
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0024919509887695
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5360')	0.00072407722473145
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5360')	0.0030510425567627
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5360')	0.0032739639282227
(11)	DESCRIBE `cruises`	0.0049059391021729
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (65854)) ORDER BY FIND_IN_SET(id, '65854')	0.0012049674987793
(13)	DESCRIBE `cruiselines`	0.0042321681976318
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('114')) ORDER BY FIND_IN_SET(id, '114')	0.00090503692626953
(15)	DESCRIBE `ships`	0.0047662258148193
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('795')) ORDER BY FIND_IN_SET(id, '795')	0.00059318542480469
(17)	DESCRIBE `cruisetypes`	0.0027530193328857
(18)	DESCRIBE `destinations`	0.003061056137085
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43')	0.00065016746520996
(20)	DESCRIBE `ports`	0.0032558441162109
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5360)))	0.00079798698425293

Query

Time

(1)

connect

0.0013320446014404

(2)

DESCRIBE `ports`

0.0036120414733887

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'atuona-french-polynesia-') AND (orchid_available = 1) LIMIT 1

0.069413185119629

(4)

DESCRIBE `destinations`

0.0053679943084717

(5)

SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43)))

0.00084400177001953

(6)

DESCRIBE `avid_specials`

0.0046689510345459

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0024919509887695

(8)

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

0.00072407722473145

(9)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5360')

0.0030510425567627

(10)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5360')

0.0032739639282227

(11)

DESCRIBE `cruises`

0.0049059391021729

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (65854)) ORDER BY FIND_IN_SET(id, '65854')

0.0012049674987793

(13)

DESCRIBE `cruiselines`

0.0042321681976318

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('114')) ORDER BY FIND_IN_SET(id, '114')

0.00090503692626953

(15)

DESCRIBE `ships`

0.0047662258148193

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('795')) ORDER BY FIND_IN_SET(id, '795')

0.00059318542480469

(17)

DESCRIBE `cruisetypes`

0.0027530193328857

(18)

DESCRIBE `destinations`

0.003061056137085

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43')

0.00065016746520996

(20)

DESCRIBE `ports`

0.0032558441162109

(21)

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

0.00079798698425293

Find Your Cruise

Atuona (French Polynesia)

Database Profiling Report