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

Puerto Quetzal, Guatemala

Puerto Quetzal is a cruise-port located in Escuintla department, alongside the city of Puerto San José. It serves as a gateway to Guatemala's fascinating ancient Mayan ruins. One-day tours of the ancient city of Tikal, one of the most important Mayan cities are available. The ruins that still stand today are among the best-preserved in the world.

The area around Puerto Quetzal is supposed to have some of the nicest beaches in all of Guatemala. About three miles west is Balneario Chulamar, and three miles to the east is Balneario Likín, a popular Guatemalan resort town. Bird watching and surfing are also popular pastimes in and around Puerto Quetzal.

Things to see and do

* Mayan ruins
* Ancient city of Tikal
* Deep sea fishing
* Surfing and bird watching

Cruise Season – Jan - Dec
Currency – Quetzal (GTQ) & US dollar (USD)
Population - 12,293,545 Guatemala
Language – Spanish, Quiche, Cakchiquel
Electricity – 2 perpendicular flat pins USA style or with a round pin below
Time – GMT minus six hours
International Country Telephone Code – 502

Port Location - Cruise ships dock at Puerto Quetzal. There is road access available directly from the port.

Transport Links – Buses do a fairly efficient job of getting you around town in Puerto Quetzal. However, taxis are your best bet for fast transportation. Tuc-tucs, small golf-cart sized are becoming perhaps the most prevalent mode of local tourist transportation in Guatemala.

#	Query	Time
(1)	connect	0.00085306167602539
(2)	DESCRIBE `ports`	0.0023109912872314
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'puerto-quetzal-guatemala') AND (orchid_available = 1) LIMIT 1	0.0022032260894775
(4)	DESCRIBE `destinations`	0.0026462078094482
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 48)))	0.0005028247833252
(6)	DESCRIBE `avid_specials`	0.0015978813171387
(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.0016200542449951
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357')	0.00036907196044922
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '357')	0.0025870800018311
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '357')	0.0024509429931641
(11)	DESCRIBE `cruises`	0.0029840469360352
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (73147, 48739, 67764, 47707, 74422, 71534, 38690, 66225, 66227, 66249)) ORDER BY FIND_IN_SET(id, '73147,48739,67764,47707,74422,71534,38690,66225,66227,66249')	0.0019309520721436
(13)	DESCRIBE `cruiselines`	0.0021989345550537
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18', '91', '24', '19', '20', '15', '26', '50', '114', '8', '28', '23', '209', '218', '262', '14', '29')) ORDER BY FIND_IN_SET(id, '18,91,24,19,20,15,26,50,114,8,28,23,209,218,262,14,29')	0.0013518333435059
(15)	DESCRIBE `ships`	0.0027790069580078
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('766', '1108', '82', '74', '780', '78', '111', '93', '108', '340', '483', '1319', '123', '394', '626', '790', '1742', '291', '792', '1168', '43', '325', '403', '657', '795', '1073', '1257', '1302', '1474', '1569', '1676', '66', '223', '389', '441', '796', '1303')) ORDER BY FIND_IN_SET(id, '766,1108,82,74,780,78,111,93,108,340,483,1319,123,394,626,790,1742,291,792,1168,43,325,403,657,795,1073,1257,1302,1474,1569,1676,66,223,389,441,796,1303')	0.0036580562591553
(17)	DESCRIBE `cruisetypes`	0.0013949871063232
(18)	DESCRIBE `destinations`	0.0020430088043213
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('48', '40', '37', '38', '12')) ORDER BY FIND_IN_SET(id, '48,40,37,38,12')	0.0010130405426025
(20)	DESCRIBE `ports`	0.0014510154724121
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357)))	0.00037503242492676

Query

Time

(1)

connect

0.00085306167602539

(2)

DESCRIBE `ports`

0.0023109912872314

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'puerto-quetzal-guatemala') AND (orchid_available = 1) LIMIT 1

0.0022032260894775

(4)

DESCRIBE `destinations`

0.0026462078094482

(5)

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

0.0005028247833252

(6)

DESCRIBE `avid_specials`

0.0015978813171387

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

(8)

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

0.00036907196044922

(9)

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

0.0025870800018311

(10)

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

0.0024509429931641

(11)

DESCRIBE `cruises`

0.0029840469360352

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (73147, 48739, 67764, 47707, 74422, 71534, 38690, 66225, 66227, 66249)) ORDER BY FIND_IN_SET(id, '73147,48739,67764,47707,74422,71534,38690,66225,66227,66249')

0.0019309520721436

(13)

DESCRIBE `cruiselines`

0.0021989345550537

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18', '91', '24', '19', '20', '15', '26', '50', '114', '8', '28', '23', '209', '218', '262', '14', '29')) ORDER BY FIND_IN_SET(id, '18,91,24,19,20,15,26,50,114,8,28,23,209,218,262,14,29')

0.0013518333435059

(15)

DESCRIBE `ships`

0.0027790069580078

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('766', '1108', '82', '74', '780', '78', '111', '93', '108', '340', '483', '1319', '123', '394', '626', '790', '1742', '291', '792', '1168', '43', '325', '403', '657', '795', '1073', '1257', '1302', '1474', '1569', '1676', '66', '223', '389', '441', '796', '1303')) ORDER BY FIND_IN_SET(id, '766,1108,82,74,780,78,111,93,108,340,483,1319,123,394,626,790,1742,291,792,1168,43,325,403,657,795,1073,1257,1302,1474,1569,1676,66,223,389,441,796,1303')

0.0036580562591553

(17)

DESCRIBE `cruisetypes`

0.0013949871063232

(18)

DESCRIBE `destinations`

0.0020430088043213

(19)

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

0.0010130405426025

(20)

DESCRIBE `ports`

0.0014510154724121

(21)

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

0.00037503242492676

Find Your Cruise

Puerto Quetzal, Guatemala

Database Profiling Report