Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Black Rain (1989)

Directed by Ridley Scott

Most recently watched by sensoria

Overview

Two New York cops get involved in a gang war between members of the Yakuza, the Japanese Mafia. They arrest one of their killers and are ordered to escort him back to Japan. However, in Japan he manages to escape, and as they try to track him down, they get deeper and deeper into the Japanese Mafia scene and they have to learn that they can only win by playing the game—the Japanese way.

Rated R | Length 125 minutes

Actors

Kate Capshaw | Andy Garcia | Jun Kunimura | Michael Douglas | Vondie Curtis-Hall | Josip Elic | Professor Tanaka | Stephen Root | Clem Caserta | Richard Riehle | Yûsaku Matsuda | Shigeru Kôyama | John Spencer | Bruce Locke | Luis Guzmán | Al Leong | Tim Kelleher | Ken Takakura | Tomisaburo Wakayama | Keone Young | Yuya Uchida | Rikiya Yasuoka | Miyuki Ono | Jim Ishida | Chris Nelson Norris | George Kyle | Joe Perce | John Costelloe | Ken Enomoto | Linda Gillen | Guts Ishimatsu | Shôtarô Hayashi | Toshishiro Obata | Daisuke Awaji | Ken Kensei | Doug Yasuda | Bruce Katzman | Taro Ibuki | Nathan Jung | Edmund Ikeda | Tomo Nagasue | Louis Cantarini | Toshio Sato | Roy K. Ogata | Shirô Oishi | Jôji Shimaki | Gorô Sasa | Michiko Tsushima | John Gotay | Matthew Porac | Mitchell Bahr | Dennis Y. Takeda | Celia Xavier

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0203
Total Execution Time  0.0216
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4987
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5c63e7dda8ad846f1b707d27edd49878', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4987
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0013   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filename, GROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directors, GROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_ids, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movie_posters` `MP` ON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMD` ON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4987
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0003   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4987
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4987 
0.0005   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)