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

Prince Rupert, BC. Canada

The Port of Prince Rupert on the Northwest Coast of British Columbia is Canada's marine gateway to Alaska, located some 700 kilometers North of Vancouver, British Columbia. As the northernmost railhead on the continent, the Port of Prince Rupert is directly linked to the North American Heartland by road, rail and air.

It is also a tourism center, located on traditional Tsimshian First Nations Territory with shopping, dining, museums, amazing wildlife on it's doorstep. Surrounding the city you will find some of the most breath-taking scenery anywhere as water, rainforest, mountains and fresh air meet in a spellbinding array of panoramic viewpoints.

Things to do

* Stubbs Island Whale watching
* Seaplane flights
* Prince Rupert to Terrace drive

General information

Cruise Season – May - September
Currency - Canadian Dollar (CAD)
Language - English
Population – 15,000
Electricity – 110 vlt 2 perpendicular flat pins USA style or with a round pin below
Time - GMT minus 10
International Country Telephone Code - 1

Port Location – Prince Rupert has two new terminals. Northland terminal built in 2005 and Atlin terminal built in 2002. Both are close to the city.

Transport Links - Daily jet services. Airport (YPR) is on Digby Island and the airport runs a bus/ferry service to take passengers to/from town. Accessble by road and rail. Serviced by both BC Ferries and the Alaska Marine Highway Ferries.

#	Query	Time
(1)	connect	0.0011861324310303
(2)	DESCRIBE `ports`	0.0031499862670898
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'prince-rupert-bc-canada') AND (orchid_available = 1) LIMIT 1	0.017055988311768
(4)	DESCRIBE `destinations`	0.003525972366333
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 2)))	0.00071287155151367
(6)	DESCRIBE `avid_specials`	0.0022749900817871
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '2' 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.0045490264892578
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262')	0.00066900253295898
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1262')	0.0031290054321289
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1262')	0.0018670558929443
(11)	DESCRIBE `cruises`	0.0052077770233154
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (80707, 80707, 87287, 84493, 81579, 81579, 82900, 82907, 84518, 87290)) ORDER BY FIND_IN_SET(id, '80707,80707,87287,84493,81579,81579,82900,82907,84518,87290')	0.002418041229248
(13)	DESCRIBE `cruiselines`	0.0038681030273438
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('28', '15', '33', '91', '7', '14', '23', '29', '114')) ORDER BY FIND_IN_SET(id, '28,15,33,91,7,14,23,29,114')	0.0018680095672607
(15)	DESCRIBE `ships`	0.0052409172058105
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('790', '394', '780', '1282', '341', '796', '1606', '147', '332', '1398', '1749')) ORDER BY FIND_IN_SET(id, '790,394,780,1282,341,796,1606,147,332,1398,1749')	0.0027530193328857
(17)	DESCRIBE `cruisetypes`	0.0025780200958252
(18)	DESCRIBE `destinations`	0.0032780170440674
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2')) ORDER BY FIND_IN_SET(id, '2')	0.00066804885864258
(20)	DESCRIBE `ports`	0.0028250217437744
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262)))	0.00065398216247559

Query

Time

(1)

connect

0.0011861324310303

(2)

DESCRIBE `ports`

0.0031499862670898

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'prince-rupert-bc-canada') AND (orchid_available = 1) LIMIT 1

0.017055988311768

(4)

DESCRIBE `destinations`

0.003525972366333

(5)

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

0.00071287155151367

(6)

DESCRIBE `avid_specials`

0.0022749900817871

(7)

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

(8)

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

0.00066900253295898

(9)

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

0.0031290054321289

(10)

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

0.0018670558929443

(11)

DESCRIBE `cruises`

0.0052077770233154

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (80707, 80707, 87287, 84493, 81579, 81579, 82900, 82907, 84518, 87290)) ORDER BY FIND_IN_SET(id, '80707,80707,87287,84493,81579,81579,82900,82907,84518,87290')

0.002418041229248

(13)

DESCRIBE `cruiselines`

0.0038681030273438

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('28', '15', '33', '91', '7', '14', '23', '29', '114')) ORDER BY FIND_IN_SET(id, '28,15,33,91,7,14,23,29,114')

0.0018680095672607

(15)

DESCRIBE `ships`

0.0052409172058105

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('790', '394', '780', '1282', '341', '796', '1606', '147', '332', '1398', '1749')) ORDER BY FIND_IN_SET(id, '790,394,780,1282,341,796,1606,147,332,1398,1749')

0.0027530193328857

(17)

DESCRIBE `cruisetypes`

0.0025780200958252

(18)

DESCRIBE `destinations`

0.0032780170440674

(19)

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

0.00066804885864258

(20)

DESCRIBE `ports`

0.0028250217437744

(21)

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

0.00065398216247559

Find Your Cruise

Prince Rupert, BC. Canada

Database Profiling Report