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

La Paz, Mexico

La Paz is the capital of Baja California Sur, Mexico. It enjoys all year balmy weather and the town offers good shopping, eateries and night life.

Things to do
Explore historic museums or shop for authentic Mexican arts and crafts. Experience legendary sportfishing for marlin, wahoo, tuna, dorado and more. Snorkel with playful sea lions or scuba dive with hammerhead sharks and giant mantas. Kayak alongside friendly dolphins and whales or venture into the tranquil bays of Espiritu Santo Island. Discover ancient cave paintings in distant canyons. Or just relax and do nothing at all on an endless white sand beach.

#	Query	Time
(1)	connect	0.0013160705566406
(2)	DESCRIBE `ports`	0.0035800933837891
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'la-paz-mexico') AND (orchid_available = 1) LIMIT 1	0.011662006378174
(4)	DESCRIBE `destinations`	0.0037200450897217
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 53)))	0.00077605247497559
(6)	DESCRIBE `avid_specials`	0.0047760009765625
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '53' 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.0038268566131592
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '719')	0.00055217742919922
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '719')	0.0029160976409912
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '719')	0.0028061866760254
(11)	DESCRIBE `cruisetypes`	0.0022740364074707
(12)	DESCRIBE `destinations`	0.0042281150817871
(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 = '719') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC	0.04798698425293
(14)	DESCRIBE `cruiselines`	0.0044071674346924
(15)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.00081706047058105
(16)	DESCRIBE `ships`	0.0058159828186035
(17)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.00087308883666992
(18)	DESCRIBE `cruiselines`	0.004396915435791
(19)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18)))	0.0008389949798584
(20)	DESCRIBE `ships`	0.0058979988098145
(21)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 74)))	0.00092101097106934
(22)	DESCRIBE `ports`	0.0029611587524414
(23)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 719)))	0.00066590309143066

Query

Time

(1)

connect

0.0013160705566406

(2)

DESCRIBE `ports`

0.0035800933837891

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'la-paz-mexico') AND (orchid_available = 1) LIMIT 1

0.011662006378174

(4)

DESCRIBE `destinations`

0.0037200450897217

(5)

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

0.00077605247497559

(6)

DESCRIBE `avid_specials`

0.0047760009765625

(7)

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

(8)

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

0.00055217742919922

(9)

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

0.0029160976409912

(10)

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

0.0028061866760254

(11)

DESCRIBE `cruisetypes`

0.0022740364074707

(12)

DESCRIBE `destinations`

0.0042281150817871

(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 = '719') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC

0.04798698425293

(14)

DESCRIBE `cruiselines`

0.0044071674346924

(15)

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

0.00081706047058105

(16)

DESCRIBE `ships`

0.0058159828186035

(17)

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

0.00087308883666992

(18)

DESCRIBE `cruiselines`

0.004396915435791

(19)

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

0.0008389949798584

(20)

DESCRIBE `ships`

0.0058979988098145

(21)

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

0.00092101097106934

(22)

DESCRIBE `ports`

0.0029611587524414

(23)

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

0.00066590309143066

My Favourite Cruises

La Paz, Mexico

Database Profiling Report

Find Your Cruise

My Favourite Cruises

La Paz, Mexico

Database Profiling Report