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

Tauranga, New Zealand

Tauranga is the largest city of the Bay of Plenty region of the North Island of New Zealand. It is located at the head of a large harbour which extends along the western Bay of Plenty. It is one of the major resort cities in New Zealand, famous for its beautiful beaches and is popular destination with retirees.

Tauranga has much to offer visitors, including excursions to Mayor and Motiti Islands, fishing trips (for big game and small) and scenic flights. The golden sands of nearby Mount Maunganui's magnificent ocean beach are popular with swimmers, sailors and surfers. Nearby is Wairoa River which is renowned for its canoeing and white water rafting. Dolphin watching cruises on the Bay of Plenty are also popular.

Things to see and do

* Dolphin watching cruises
* Excursions to Mayor and Motiti Islands
* Mount Maunganui ocean beach
* Canoeing and white water rafting
* Walk Mount Maunganui

Cruise Season – Jan - Dec
Currency – NZ Dollar (NZ$)
Language – English & Maori
Land Area – 168 km²
Population – 101,500 approx
Electricity – 2 angled pins and 1 flat pin centred below Australian style
Time – GMT plus twelve hours
International Country Telephone Code – + 64

Port Location – The port of Tauranga is located on Wharf Road, close to the Tauranga Harbor bridge.

Transport Links - Tauranga has a minor airport with regular Air New Zealand flights from Auckland and Wellington.
Intercity Coachlines also stop in downtown Tauranga on route from numerous parts of New Zealand.

#	Query	Time
(1)	connect	0.0010130405426025
(2)	DESCRIBE `ports`	0.002418041229248
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'tauranga-new-zealand') AND (orchid_available = 1) LIMIT 1	0.0056211948394775
(4)	DESCRIBE `destinations`	0.0029318332672119
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43)))	0.0005488395690918
(6)	DESCRIBE `avid_specials`	0.0017251968383789
(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.0019831657409668
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488')	0.00045990943908691
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '488')	0.0027718544006348
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '488')	0.0025479793548584
(11)	DESCRIBE `cruises`	0.0036900043487549
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (68752, 70760, 70761, 67334, 69311, 71200, 69301, 71131, 66817, 69294)) ORDER BY FIND_IN_SET(id, '68752,70760,70761,67334,69311,71200,69301,71131,66817,69294')	0.0018141269683838
(13)	DESCRIBE `cruiselines`	0.0028350353240967
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '20', '24', '262', '28', '187', '26', '50', '14', '114', '29', '151', '15', '19', '91', '12', '159', '105', '37')) ORDER BY FIND_IN_SET(id, '23,18,8,20,24,262,28,187,26,50,14,114,29,151,15,19,91,12,159,105,37')	0.0022411346435547
(15)	DESCRIBE `ships`	0.0042078495025635
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('253', '547', '683', '485', '75', '678', '1325', '1454', '483', '1409', '1492', '1539', '451', '111', '1330', '1398', '287', '338', '394', '766', '780', '66', '332', '775', '1474', '1672', '108', '506', '616', '776', '74', '652', '692', '695', '717', '997', '1168', '1749', '1758')) ORDER BY FIND_IN_SET(id, '253,547,683,485,75,678,1325,1454,483,1409,1492,1539,451,111,1330,1398,287,338,394,766,780,66,332,775,1474,1672,108,506,616,776,74,652,692,695,717,997,1168,1749,1758')	0.0040900707244873
(17)	DESCRIBE `cruisetypes`	0.0018508434295654
(18)	DESCRIBE `destinations`	0.0027589797973633
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '8')) ORDER BY FIND_IN_SET(id, '43,40,8')	0.00093698501586914
(20)	DESCRIBE `ports`	0.0023329257965088
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488)))	0.0005180835723877

Query

Time

(1)

connect

0.0010130405426025

(2)

DESCRIBE `ports`

0.002418041229248

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'tauranga-new-zealand') AND (orchid_available = 1) LIMIT 1

0.0056211948394775

(4)

DESCRIBE `destinations`

0.0029318332672119

(5)

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

0.0005488395690918

(6)

DESCRIBE `avid_specials`

0.0017251968383789

(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.0019831657409668

(8)

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

0.00045990943908691

(9)

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

0.0027718544006348

(10)

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

0.0025479793548584

(11)

DESCRIBE `cruises`

0.0036900043487549

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (68752, 70760, 70761, 67334, 69311, 71200, 69301, 71131, 66817, 69294)) ORDER BY FIND_IN_SET(id, '68752,70760,70761,67334,69311,71200,69301,71131,66817,69294')

0.0018141269683838

(13)

DESCRIBE `cruiselines`

0.0028350353240967

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '20', '24', '262', '28', '187', '26', '50', '14', '114', '29', '151', '15', '19', '91', '12', '159', '105', '37')) ORDER BY FIND_IN_SET(id, '23,18,8,20,24,262,28,187,26,50,14,114,29,151,15,19,91,12,159,105,37')

0.0022411346435547

(15)

DESCRIBE `ships`

0.0042078495025635

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('253', '547', '683', '485', '75', '678', '1325', '1454', '483', '1409', '1492', '1539', '451', '111', '1330', '1398', '287', '338', '394', '766', '780', '66', '332', '775', '1474', '1672', '108', '506', '616', '776', '74', '652', '692', '695', '717', '997', '1168', '1749', '1758')) ORDER BY FIND_IN_SET(id, '253,547,683,485,75,678,1325,1454,483,1409,1492,1539,451,111,1330,1398,287,338,394,766,780,66,332,775,1474,1672,108,506,616,776,74,652,692,695,717,997,1168,1749,1758')

0.0040900707244873

(17)

DESCRIBE `cruisetypes`

0.0018508434295654

(18)

DESCRIBE `destinations`

0.0027589797973633

(19)

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

0.00093698501586914

(20)

DESCRIBE `ports`

0.0023329257965088

(21)

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

0.0005180835723877

Find Your Cruise

Tauranga, New Zealand

Database Profiling Report