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

Corinto, Nicaragua

The country's principal port on the Pacific Ocean, Corinto is located in sheltered Corinto Bay, which lies at the southeastern end of low-lying Aserradores (Punta Icaco) Island, connected by bridges with the mainland. It is the main port of entry for passengers and cargo bound for Nicaragua, and it handles most of the country's exports.

The word 'Corinto' from Puerto Corinto means friendly people, a nice town and a safe natural port offering an authentic experience of the country. The beaches in Corinto are very beautiful and often very desolate. However if you like to play soccer you should find the spot where the locals hang out. The locals play soccer on the beach almost every day.

Things to see and do

* Chinandega
* Colonial City of Leon
* San Jacinto
* El Cardon island

Cruise Season – Jan - Dec
Currency – gold cordoba (NIO)
Language – Spanish
Land Area - 120,254 sq km
Population – 5,700,000 Nicaragua
Electricity – 2 perpendicular flat pins USA style or with a round pin below
Time – GMT minus six hours
International Country Telephone Code – 505

Transport Links – There is an array of car rental services for traveling to most tourism destinations. Traveling on public buses is a great opportunity for those seeking to know Nicaraguans. Ferry and boat services are available in Lake Nicaragua and the San Juan River, reaching destinations with interesting tourism attractions.

Domestic flights to several destinations in the country including the Islands in the Caribbean, are served by national airlines.
Several international airlines such as American Airlines, Continental, Copa, Grupo Taca, Iberia and Sol Air operate into Managua International Airport.

#	Query	Time
(1)	connect	0.00093579292297363
(2)	DESCRIBE `ports`	0.0023431777954102
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'corinto-nicaragua') AND (orchid_available = 1) LIMIT 1	0.021263837814331
(4)	DESCRIBE `destinations`	0.0028078556060791
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 48)))	0.00060915946960449
(6)	DESCRIBE `avid_specials`	0.0018320083618164
(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.0013201236724854
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863')	0.00044918060302734
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '2863')	0.0023739337921143
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '2863')	0.0017609596252441
(11)	DESCRIBE `cruisetypes`	0.0019888877868652
(12)	DESCRIBE `destinations`	0.0036170482635498
(13)	SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '18') AND (cruises_and_specials.ship_id = '74') AND (ports.id = '2863') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC	0.046370983123779
(14)	DESCRIBE `cruiselines`	0.0036170482635498
(15)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.00061607360839844
(16)	DESCRIBE `ships`	0.0047330856323242
(17)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.00061392784118652
(18)	DESCRIBE `cruiselines`	0.0031859874725342
(19)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.00054812431335449
(20)	DESCRIBE `ships`	0.0037729740142822
(21)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.00045299530029297
(22)	DESCRIBE `ports`	0.0018391609191895
(23)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863)))	0.00052690505981445

Query

Time

(1)

connect

0.00093579292297363

(2)

DESCRIBE `ports`

0.0023431777954102

(3)

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

0.021263837814331

(4)

DESCRIBE `destinations`

0.0028078556060791

(5)

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

0.00060915946960449

(6)

DESCRIBE `avid_specials`

0.0018320083618164

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

(8)

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

0.00044918060302734

(9)

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

0.0023739337921143

(10)

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

0.0017609596252441

(11)

DESCRIBE `cruisetypes`

0.0019888877868652

(12)

DESCRIBE `destinations`

0.0036170482635498

(13)

SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '18') AND (cruises_and_specials.ship_id = '74') AND (ports.id = '2863') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC

0.046370983123779

(14)

DESCRIBE `cruiselines`

0.0036170482635498

(15)

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

0.00061607360839844

(16)

DESCRIBE `ships`

0.0047330856323242

(17)

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

0.00061392784118652

(18)

DESCRIBE `cruiselines`

0.0031859874725342

(19)

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

0.00054812431335449

(20)

DESCRIBE `ships`

0.0037729740142822

(21)

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

0.00045299530029297

(22)

DESCRIBE `ports`

0.0018391609191895

(23)

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

0.00052690505981445

My Favourite Cruises

Corinto, Nicaragua

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Corinto, Nicaragua

Database Profiling Report