Movielogr

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

Hellboy II: The Golden Army (2008)

Directed by Guillermo del Toro

Most recently watched by sensoria, sleestakk

Overview

Hellboy, his pyrokinetic girlfriend, Liz, and aquatic empath, Abe Sapien, face their biggest battle when an underworld elven prince plans to reclaim Earth for his magical kindred. Tired of living in the shadow of humans, Prince Nuada tries to awaken an ancient force of killing machines, the all-powerful Golden Army, to clear the way for fantasy creatures to roam free. Only Hellboy can stop the dark prince and prevent humanity’s annihilation.

Rated PG-13 | Length 120 minutes

Actors

Ron Perlman | Roy Dotrice | Jeffrey Tambor | John Hurt | Jeremy Zimmermann | Guillermo del Toro | Luke Goss | Santiago Segura | Selma Blair | Brian Steele | Doug Jones | Richard Rifkin | Michael Mehlmann | Alex McSweeney | Seth MacFarlane | Matt Rippy | Jimmy Kimmel | Szonja Oroszlán | Kamarás Iván | Anna Walton | John Alexander | Elek Ferenc | James Dodd | Peter Horkay | Judit Viktor | Jeanne Mockford | Justin Pierre | Aidan Cook | Brian Herring | Matthew O'Toole | Tim Larsen | Tim Flavin | Julia Papp | Jamie Wilson | Montse Ribé | Mike Kelly | Pálma Pásztor | Blake Perlman | Andrew Hefler | Clive Llewellyn | Gavin McKenzie | Sándor Svigelj | Belinda Henley | Todd Williams | Beatrice Zentai

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0210
Total Execution Time  0.0226
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,552 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4116
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0029 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'b740498a638991cf484fd28a6ebe6a36e2c4c7af'
AND `ip_address` = '216.73.216.111' 
0.0001   SELECT GET_LOCK('facd70f69412bdf62a4cc89549ca4c5c'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'b740498a638991cf484fd28a6ebe6a36e2c4c7af'
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` = 4116
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0011   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` = 4116
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4116
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4116 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)