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

Yokohama, Japan

Yokohama is the capital city of Kanagawa Prefecture and the second largest city in Japan by population after Tokyo. It lies on Tokyo Bay, south of Tokyo, in the Kantō region of the main island of Honshū. It is a major commercial hub of the Greater Tokyo Area.

Yokahama offers a wide variety of attractions. The historic port area is Kannai. Next to the waterfront Yamashita Park is Yokohama Marine Tower, the tallest inland lighthouse in the world. Further inland lies Yokohama Chinatown, the largest Chinatown in Japan and one of the largest in the world. Nearby is Yokohama Stadium, the Silk Center, and the Yokohama Doll Museum. The Isezakichō and Noge areas offer many colourful shops and bars.

The futuristic Minato Mirai 21 harbourside redevelopment offers many points of interest. The highlights are the Landmark Tower which is the tallest building in Japan, Queen's Square Yokohama (a shopping mall) and the Cosmo Clock 21, which was the tallest Ferris wheel in the world when it was built in 1989 and which also doubles as "the world's biggest clock".

Things to See & Do

* Chinatown
* Bay Stars Stadium
* Minato Mirai Area
* Marine Tower
* Yamahsita Park

General information

Cruise Season – Jan - Dec
Currency – Yen (JPY)
Language – Japanese
Population – 3,700,000
Land Area - 437.35 km2
Electricity – 2 perpendicular flat pins USA style or with a round pin below
Time - GMT plus hours nine hours
International Country Telephone Code – 81

Port Location – The Port of Yokohama is located in Tokyo Bay, conveniently situated near a variety of tourist attractions and approximately 7 mins of foot to the nearest station (Nihon-odori).

Travel Links – Yokohama does not have its own airport. You can reach Yokohama from Tokyo's two main airports; Narita and Haneda airports.

Yokohama is serviced by the Tōkaidō Shinkansen, a high-speed rail line with a stop at Shin-Yokohama Station. Yokohama Station is also a major station, with two million passengers daily. The Yokohama Municipal Subway provides metro services.

#	Query	Time
(1)	connect	0.00087404251098633
(2)	DESCRIBE `ports`	0.0020749568939209
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'yokohama-japan') AND (orchid_available = 1) LIMIT 1	0.0088539123535156
(4)	DESCRIBE `destinations`	0.0026009082794189
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 35)))	0.00046610832214355
(6)	DESCRIBE `avid_specials`	0.0015280246734619
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '35' 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.0016880035400391
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833')	0.00035405158996582
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '833')	0.0016360282897949
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '833')	0.00164794921875
(11)	DESCRIBE `cruises`	0.0039961338043213
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (68756, 73975, 71100, 71101, 71102, 71620, 67832, 68766, 68819, 73528)) ORDER BY FIND_IN_SET(id, '68756,73975,71100,71101,71102,71620,67832,68766,68819,73528')	0.0017490386962891
(13)	DESCRIBE `cruiselines`	0.0028870105743408
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '15', '187', '12', '26', '91', '20', '29', '33', '151', '24', '105')) ORDER BY FIND_IN_SET(id, '23,18,8,15,187,12,26,91,20,29,33,151,24,105')	0.0016560554504395
(15)	DESCRIBE `ships`	0.0043938159942627
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '45', '780', '547', '105', '401', '1454', '75', '62', '508', '1738', '287', '652', '776', '1266', '1398', '448', '485', '506', '1141', '1168', '1409')) ORDER BY FIND_IN_SET(id, '349,45,780,547,105,401,1454,75,62,508,1738,287,652,776,1266,1398,448,485,506,1141,1168,1409')	0.0027861595153809
(17)	DESCRIBE `cruisetypes`	0.0017929077148438
(18)	DESCRIBE `destinations`	0.0025629997253418
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '40', '2', '34', '43')) ORDER BY FIND_IN_SET(id, '35,40,2,34,43')	0.0010819435119629
(20)	DESCRIBE `ports`	0.002086877822876
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833)))	0.0005030632019043

Query

Time

(1)

connect

0.00087404251098633

(2)

DESCRIBE `ports`

0.0020749568939209

(3)

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

0.0088539123535156

(4)

DESCRIBE `destinations`

0.0026009082794189

(5)

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

0.00046610832214355

(6)

DESCRIBE `avid_specials`

0.0015280246734619

(7)

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

(8)

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

0.00035405158996582

(9)

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

0.0016360282897949

(10)

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

0.00164794921875

(11)

DESCRIBE `cruises`

0.0039961338043213

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (68756, 73975, 71100, 71101, 71102, 71620, 67832, 68766, 68819, 73528)) ORDER BY FIND_IN_SET(id, '68756,73975,71100,71101,71102,71620,67832,68766,68819,73528')

0.0017490386962891

(13)

DESCRIBE `cruiselines`

0.0028870105743408

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '15', '187', '12', '26', '91', '20', '29', '33', '151', '24', '105')) ORDER BY FIND_IN_SET(id, '23,18,8,15,187,12,26,91,20,29,33,151,24,105')

0.0016560554504395

(15)

DESCRIBE `ships`

0.0043938159942627

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '45', '780', '547', '105', '401', '1454', '75', '62', '508', '1738', '287', '652', '776', '1266', '1398', '448', '485', '506', '1141', '1168', '1409')) ORDER BY FIND_IN_SET(id, '349,45,780,547,105,401,1454,75,62,508,1738,287,652,776,1266,1398,448,485,506,1141,1168,1409')

0.0027861595153809

(17)

DESCRIBE `cruisetypes`

0.0017929077148438

(18)

DESCRIBE `destinations`

0.0025629997253418

(19)

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

0.0010819435119629

(20)

DESCRIBE `ports`

0.002086877822876

(21)

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

0.0005030632019043

Find Your Cruise

Yokohama, Japan

Database Profiling Report