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

San Francisco, California, USA

San Francisco is a bustling cosmopolitan city in California, surrounded by water on three sides. It is a spectacular city, with many world-famous steep hills offering incredible views of the Bay and is full of major attractions and landmarks.

San Francisco is often classed as one of the top tourist destinations in the world with top attractions such as the San Francisco Golden Gate Bridge, Alcatraz island - which was once the most notorious prison in the world, Pier 39 on Fisherman's Wharf - a lively bay area with numerous shops, arcades, seafood restaurants, cafés, fairground rides, ocean views and its own colony of sea lions, Lombard Street - probably the world's most bendy street, and the famous San Francisco cable cars, which provide cheap and easy access to the whole of San Francisco.

Things to see and do

* Golden Gate Bridge
* Pier 39
* Alcatraz island
* Lombard Street

Cruise Season – May - Sept
Currency – US Dollar (US$)
Language – English
Land Area - 127 square kilometers
Population – 785,000
Electricity – 2 perpendicular flat pins USA style or with a round pin below
Time – GMT minus eight hours
International Country Telephone Code – + 1

Port Location – The Port of San Francisco is located in downtown San Francisco and offers many of the city's leading tourist attractions These include Hyde Street Pier, Fisherman's Wharf, PIER 39 and access to Alcatraz.

Transport Links – The Bay Area has three major airports: San Francisco International Airport , Oakland International Airport and San Jose International Airport. Greyhound buses and Amtrak trains also provide links to other states and cities.
San Francisco is easily accessible on foot, otherwise there is an excellent bus and subway system, electric trolley buses and cable cars. Ferries are also available.

#	Query	Time
(1)	connect	0.00099492073059082
(2)	DESCRIBE `ports`	0.0025899410247803
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'san-francisco-california-usa') AND (orchid_available = 1) LIMIT 1	0.0024540424346924
(4)	DESCRIBE `destinations`	0.0028610229492188
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 34)))	0.0006101131439209
(6)	DESCRIBE `avid_specials`	0.0021519660949707
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '34' 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.0013439655303955
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')	0.00049495697021484
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '142')	0.003652811050415
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '142')	0.0025489330291748
(11)	DESCRIBE `cruises`	0.0039489269256592
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76929, 63072, 28282, 75774, 75775, 75776, 75777, 74531, 78017, 50803)) ORDER BY FIND_IN_SET(id, '76929,63072,28282,75774,75775,75776,75777,74531,78017,50803')	0.0021200180053711
(13)	DESCRIBE `cruiselines`	0.0037381649017334
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '91', '218', '15', '50', '24', '18', '20', '28', '14', '19', '8', '29', '159', '16', '26', '33')) ORDER BY FIND_IN_SET(id, '23,91,218,15,50,24,18,20,28,14,19,8,29,159,16,26,33')	0.0026140213012695
(15)	DESCRIBE `ships`	0.0045490264892578
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('441', '290', '678', '1108', '98', '483', '394', '585', '111', '1021', '105', '790', '580', '780', '1854', '332', '674', '82', '657', '1569', '75', '147', '626', '692', '776', '1302', '1742', '66', '70', '340', '389', '1282', '1721')) ORDER BY FIND_IN_SET(id, '441,290,678,1108,98,483,394,585,111,1021,105,790,580,780,1854,332,674,82,657,1569,75,147,626,692,776,1302,1742,66,70,340,389,1282,1721')	0.0061440467834473
(17)	DESCRIBE `cruisetypes`	0.00199294090271
(18)	DESCRIBE `destinations`	0.0025169849395752
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '34', '2', '53', '29', '48', '43', '35', '32')) ORDER BY FIND_IN_SET(id, '40,34,2,53,29,48,43,35,32')	0.0016608238220215
(20)	DESCRIBE `ports`	0.0023348331451416
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))	0.00054097175598145

Query

Time

(1)

connect

0.00099492073059082

(2)

DESCRIBE `ports`

0.0025899410247803

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'san-francisco-california-usa') AND (orchid_available = 1) LIMIT 1

0.0024540424346924

(4)

DESCRIBE `destinations`

0.0028610229492188

(5)

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

0.0006101131439209

(6)

DESCRIBE `avid_specials`

0.0021519660949707

(7)

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

(8)

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

0.00049495697021484

(9)

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

0.003652811050415

(10)

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

0.0025489330291748

(11)

DESCRIBE `cruises`

0.0039489269256592

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (76929, 63072, 28282, 75774, 75775, 75776, 75777, 74531, 78017, 50803)) ORDER BY FIND_IN_SET(id, '76929,63072,28282,75774,75775,75776,75777,74531,78017,50803')

0.0021200180053711

(13)

DESCRIBE `cruiselines`

0.0037381649017334

(14)

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

0.0026140213012695

(15)

DESCRIBE `ships`

0.0045490264892578

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('441', '290', '678', '1108', '98', '483', '394', '585', '111', '1021', '105', '790', '580', '780', '1854', '332', '674', '82', '657', '1569', '75', '147', '626', '692', '776', '1302', '1742', '66', '70', '340', '389', '1282', '1721')) ORDER BY FIND_IN_SET(id, '441,290,678,1108,98,483,394,585,111,1021,105,790,580,780,1854,332,674,82,657,1569,75,147,626,692,776,1302,1742,66,70,340,389,1282,1721')

0.0061440467834473

(17)

DESCRIBE `cruisetypes`

0.00199294090271

(18)

DESCRIBE `destinations`

0.0025169849395752

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '34', '2', '53', '29', '48', '43', '35', '32')) ORDER BY FIND_IN_SET(id, '40,34,2,53,29,48,43,35,32')

0.0016608238220215

(20)

DESCRIBE `ports`

0.0023348331451416

(21)

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

0.00054097175598145

Find Your Cruise

San Francisco, California, USA

Database Profiling Report