Movielogr

Home

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

Take Aim at the Police Van (1960)

Directed by Seijun Suzuki

Most recently watched by sensoria

Overview

A sharpshooter kills two prisoners in a police van at night. The guard on the van is suspended for six months; he’s Tamon, an upright, modest man. He begins his own investigation into the murders. Who were the victims, who are their relatives and girlfriends, who else was on the van that night? As he doggedly investigates, others die, coincidences occur, and several leads take him to the Hamaju Agency, which may be supplying call girls. Its owner is in jail, his daughter, the enigmatic Yuko, keeps turning up where Tamon goes. Tamon believes he can awaken good in people, but has he met his match? Will he solve the murders or be the next victim? And who is Akiba?

Length 79 minutes

Actors

Kotoe Hatsui | Shinsuke Ashida | Tôru Abe | Misako Watanabe | Hiroshi Chô | Arata Shibata | Shoichi Ozawa | Tomio Aoki | Ryôhei Uchida | Mari Shiraki | Michitaro Mizushima | Saburo Hiromatsu | Tatsuo Matsushita | Reiko Arai | Toyo Fukuda | Akira Hisamatsu | Tamaki Katori | Hiroshi Midorikawa | Keisuke Noro | Yôko Yokota | Koichi Uenoyama | Sho Furuta | Norikatsu Hanamura | Ayako Fukuda | Kyoko Natsu | Kaoru Yamamoto | Eiko Takada | Shigeno Iwasaki | Reina Hanayagi | Hiroshi Nagashi

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0222
Total Execution Time  0.0237
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,856 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4161
  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` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0fea357d757995380c040d3ea929c528', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
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` = 4161
 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` = 4161
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0004   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` = 4161
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4161 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)