Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Godzilla: Final Wars (2004)

Directed by Ryûhei Kitamura

Most recently watched by sensoria

Overview

Humanity finally rids themselves of Godzilla, imprisoning him in an icy tomb in the South Pole. All is peaceful until various monsters emerge to lay waste to Earth’s cities. Overwhelmed, humanity is seemingly saved by a race of benevolent aliens known as Xiliens. But not all is what it seems with these bizarre visitors. If humanity wishes to survive, they must reluctantly resurrect their most hated enemy, Godzilla.

Rated PG-13 | Length 125 minutes

Actors

Jun Kunimura | Kazuki Kitamura | Kenji Sahara | Akira Takarada | Kôichi Yamadera | Kumi Mizuno | Tak Sakaguchi | Akira Nakao | Kôichi Ueda | Kane Kosugi | Masakatsu Funaki | Don Frye | Masanobu Takashima | Masami Nagasawa | Masahiro Matsuoka | Rei Kikukawa | Maki Mizuno | Masatō Ibu | Yôji Tanaka | Reika Kirishima | Shigeru Izumiya | Chihiro Otsuka | Ray Sefo | Kenta Suga | Wataru Shihodo | Shuya Yoshimoto | Tsutomu Kitagawa | Motokuni Nakagawa | Naoko Kamio | Toshihiro Ogura | Kazuhiro Yoshida

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