Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Hellboy (2004)

Directed by Guillermo del Toro

Most recently watched by sleestakk, sensoria

Overview

In the final days of World War II, the Nazis attempt to use black magic to aid their dying cause. The Allies raid the camp where the ceremony is taking place, but not before they summon a baby demon who is rescued by Allied forces and dubbed “Hellboy”. Sixty years later, Hellboy serves the cause of good rather than evil as an agent in the Bureau of Paranormal Research & Defense, along with Abe Sapien - a merman with psychic powers, and Liz Sherman - a woman with pyrokinesis, protecting America against dark forces.

Rated PG-13 | Length 122 minutes

Actors

Ron Perlman | Jeffrey Tambor | John Hurt | Jeremy Zimmermann | Guillermo del Toro | Karel Roden | Santiago Segura | David Hyde Pierce | Selma Blair | Brian Steele | Doug Jones | Corey Johnson | Rupert Evans | James Babson | Richard Haas | Todd Kramer | Brian Caspe | Angus MacInnes | Tara Hugo | Mike Mignola | Ladislav Beran | Biddy Hodson | Bob Sherman | Winter Ave Zoli | Stephen Fisher | Andrea Miltner | Jim Howick | William Hoyland | Monty L. Simons | Aleš Košnar | Justin Svoboda | Ellen Savaria | Pavel Cajzl | Miroslav Lhotka | Helene Wilson | Kevin Trainor | Rory Copus | Jo Eastwood | Garth Cooper | Charles Grisham | Mark Taylor | Jan Holíček | Petr Sekanina | Daniel Aarsman | Bettina Ask | Alvaro Navarro | Emilio Navarro | Andrea Stuart | Millie Wilkie | Albert Moy | Michael Lindsay

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0219
Total Execution Time  0.0233
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4485
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0046 seconds)  (Hide)
0.0004   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.0003   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` = 4485
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0020   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` = 4485
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` = 4485
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0005   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4485 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)