Movielogr

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Battle Royale II: Requiem (2003)

Directed by Kenta Fukasaku, Kinji Fukasaku

Most recently watched by sensoria, sleestakk

Overview

It’s three years after the events of the original Battle Royale, and Shuya Nanahara is now an internationally-known terrorist determined to bring down the government. His terrorist group, Wild Seven, stages an attack that levels several buildings in Tokyo on Christmas Day, killing 8000 people. In order for the government to study the benefits of “teamwork”, the new students work in pairs, with their collars electronically linked so that if one of them is killed, the other dies as well. They must kill Nanahara in three days - or die.

Rated NR | Length 155 minutes

Actors

Sonny Chiba | Takeshi Kitano | Tatsuya Fujiwara | Aki Maeda | Mitsu Murata | Yuma Ishigaki | Riki Takeuchi | Soko Wada | Shugo Oshinari | Ryo Katsuji | Kazuki Yamamoto | Munetaka Aoki | Masaya Kikawada | Hitomi Hasebe | Yoshiko Mita | Masahiko Tsugawa | Makoto Sakamoto | Yoko Maki | Toshiyuki Toyonaga | Natsuki Katô | Ayana Sakai | Kazutoshi Yokoyama | Asami Katsura | Haruka Suenaga | Yuki Ito | Takeru Shibaki | Nana Yanagisawa | Ai Iwamura | Mika Kikuchi | Aja | Kei Tamura | Miyuki Kanbe | Yasutake Yuboku | Miku Kuga | Kotaru Kamijou | Yuuko Morimoto | Michiho Matsumoto | Kenji Harada | Ayumi Hanada | Ryoji Fujihira | Shoko Sato | Riasu Arama | Kouta Yamada | Ai Maeda | Maki Hamada | Takaaki Ikeyama | Minami Kanazawa | Chisato Miyao | Rika Sakagushi | Maika Matsumoto | Aiko Moriuchi | Ami Nakagawa | Takeshi Tanaka | Musashi Kubota | Kayo Nayuki | Sae Shimizu | Asuka Shingu

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0221
Total Execution Time  0.0236
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4578
  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` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
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` = 4578
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0023   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4578
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4578
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4578 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)