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

Panama Canal

The Panama Canal is a 77 km (48 mi) ship canal in Panama that joins the Atlantic Ocean and the Pacific Ocean and is a key conduit for international maritime trade. Normally, the average time of a vessel in Canal waters is about 24 hours, 8 to 12 hours of which are spent in transit through the Canal proper. The Canal operates 24 hours a day, 365 days a year, and transiting vessels of all nations.

Visitors can access the attractions of Panama City and the Panama canal, as well as fine dining along the Amador Causeway and the chance to enjoy outdoor activities such as jogging, biking, rollerblading, or fishing, all with Panama City’s skyline as backdrop. Other attractions include the Miraflores and Pedro Miguel Locks.

Things to See and Do

* Panama City
* Miraflores locks
* Amador Causeway
* Casco Viejo – historic part of Panama City
* Pedro Miguel Locks

General information

Cruise Season – Jan - Dec
Currency - Balboa, U.S. dollar (PAB, USD)
Language – Spanish
Population – 820,000 approx
Land Area - 77 km2 (length)
Electricity – 2 perpendicular flat pins USA style or with a round pin below
Time - GMT minus five hours
International Country Telephone Code – +507

Port Location – Cruise ships dock at the port of Balboa (near Panama City).

Travel Links – International flights to Panama arrive at Tocumen International Airport (PTY), which lies about 20 miles east of Panama City (from all countries) or David Airport (from Costa Rica in AirPanama).

There's only train service between Panama City and Colon. It's mostly a freight train, but it has a very nice passenger car. The train ride offers excellent views of the Panama Canal and the tropical rainforest.

Panama City has one of the most modern bus terminals in Latin America. The terminal is next to the Albrook airport (the domestic terminal) and it is very easy to find a bus here. All of the internatinal buses(tica bus too) start and end in this terminal.

#	Query	Time
(1)	connect	0.0016188621520996
(2)	DESCRIBE `ports`	0.0040061473846436
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'panama-canal') AND (orchid_available = 1) LIMIT 1	0.0036501884460449
(4)	DESCRIBE `destinations`	0.0043849945068359
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 48)))	0.00086688995361328
(6)	DESCRIBE `avid_specials`	0.0025029182434082
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '48' 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.0022990703582764
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165')	0.00066995620727539
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '165')	0.0033919811248779
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '165')	0.0032148361206055
(11)	DESCRIBE `cruises`	0.0054960250854492
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (37676)) ORDER BY FIND_IN_SET(id, '37676')	0.0021529197692871
(13)	DESCRIBE `cruisetypes`	0.0031437873840332
(14)	DESCRIBE `destinations`	0.0039632320404053
(15)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40')) ORDER BY FIND_IN_SET(id, '40')	0.00087404251098633
(16)	DESCRIBE `cruiselines`	0.0050110816955566
(17)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.00079703330993652
(18)	DESCRIBE `ships`	0.0055968761444092
(19)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.0010061264038086
(20)	DESCRIBE `cruiselines`	0.029093980789185
(21)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.0071878433227539
(22)	DESCRIBE `ships`	0.0063159465789795
(23)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.00093722343444824
(24)	DESCRIBE `ports`	0.0028088092803955
(25)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165)))	0.00066804885864258

Query

Time

(1)

connect

0.0016188621520996

(2)

DESCRIBE `ports`

0.0040061473846436

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'panama-canal') AND (orchid_available = 1) LIMIT 1

0.0036501884460449

(4)

DESCRIBE `destinations`

0.0043849945068359

(5)

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

0.00086688995361328

(6)

DESCRIBE `avid_specials`

0.0025029182434082

(7)

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

(8)

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

0.00066995620727539

(9)

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

0.0033919811248779

(10)

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

0.0032148361206055

(11)

DESCRIBE `cruises`

0.0054960250854492

(12)

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

0.0021529197692871

(13)

DESCRIBE `cruisetypes`

0.0031437873840332

(14)

DESCRIBE `destinations`

0.0039632320404053

(15)

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

0.00087404251098633

(16)

DESCRIBE `cruiselines`

0.0050110816955566

(17)

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

0.00079703330993652

(18)

DESCRIBE `ships`

0.0055968761444092

(19)

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

0.0010061264038086

(20)

DESCRIBE `cruiselines`

0.029093980789185

(21)

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

0.0071878433227539

(22)

DESCRIBE `ships`

0.0063159465789795

(23)

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

0.00093722343444824

(24)

DESCRIBE `ports`

0.0028088092803955

(25)

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

0.00066804885864258

My Favourite Cruises

Panama Canal

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Panama Canal

Database Profiling Report