Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

United Red Army (2007)

Directed by Kōji Wakamatsu

Most recently watched by sleestakk

Overview

The film is told in three acts, beginning with a historical background of Japan’s student movement of the 1960s and early 1970s, mostly using archive footage and a narrator. The second act follows the formation of the group to their mountain training camps in the southern Japanese Alps. It emphasizes the dogmatic (and eventually hypocritical) bullying of the group by Mori and Nagata, with 12 members being killed for infractions as small as improperly cleaning a gun, wearing make-up, and kissing. The third act shows the splitting up of the group after two members run off. It follows one group of five members to Karuizawa and a hostage-taking and police standoff known as the Asama-Sansō incident.

Length 190 minutes

Actors

Tak Sakaguchi | Yoshio Harada | Arata Iura | Hideo Nakaizumi | Kaoru Okunuki | Hassei Takano | Maki Sakai | Akie Namiki | Gô Jibiki | Shima Ohnishi | Keigo Kasuya | Erika Okuda | Akiko Monô | Nobuya Tamaichi | Yugo Saso | Nao Okabe | Tomori Abe | Kenji Date | Takaki Uda | Anri Ban | Maria Abe | Shinji Miyadai | Soran Tamoto | Kazuki Tsujimoto | Naoki Yamamoto | Megumi Ichinose | Yuki Fujii

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0231
Total Execution Time  0.0245
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,232 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3684
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0044 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '1c5b51a22c6ee46906e07eda76488e79ddc5972e'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('1e9b3d7d54bf7d3fd91f779f765d01ad', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '1c5b51a22c6ee46906e07eda76488e79ddc5972e'
AND `ip_address` = '216.73.216.6' ?>
0.0016  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3684
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0010  
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` = 3684
GROUP BY `title_id` ?>
0.0001  
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` = 3684
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0002  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3684 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)