Movielogr

Home

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

The Great Yokai War (2005)

Directed by Takashi Miike

Most recently watched by sleestakk

Overview

A young boy with a troubled home life becomes “chosen,” and he stumbles into the middle of a great war of yōkai (a class of mythological creatures), where he meets a group of friendly yōkai who become his companions through his journey. Now he must fight to protect his friends and free the world of the yōkai from oppression. The yōkai originate in Japanese folklore and range from the cute and silly to the disturbing.

Rated PG-13 | Length 124 minutes

Actors

Chiaki Kuriyama | Kanji Tsuda | Akira Emoto | Asumi Miwa | Ken'ichi Endô | Itsuji Itao | Toshiya Nagasawa | Renji Ishibashi | Mai Takahashi | Naoto Takenaka | Yu Tokui | Hiroyuki Miyasako | Toshie Negishi | Shirô Sano | Kiyoshiro Imawano | Etsushi Toyokawa | Riko Narumi | Kaho Minami | Sadao Abe | Yôji Tanaka | Bunta Sugawara | Rei Yoshii | Masaomi Kondo | Hiroshi Aramata | Ryunosuke Kamiki | Miyuki Miyabe | Mame Yamada | Hiromasa Taguchi | Takashi Okamura | Taru Honkonen | Natsuhiko Kyogoku | Shigeru Mizuki | Tôru Hotohara | Arimasa Osawa

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0223
Total Execution Time  0.0239
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,648 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4419
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0044 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('018ff58b57b009f1d2b2870c60743909', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4419
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0021   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` = 4419
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` = 4419
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4419 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)