Movielogr

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

Hotel Transylvania (2012)

Directed by Genndy Tartakovsky

Most recently watched by sleestakk, zombiefreak

Overview

Welcome to Hotel Transylvania, Dracula’s lavish five-stake resort, where monsters and their families can live it up and no humans are allowed. One special weekend, Dracula has invited all his best friends to celebrate his beloved daughter Mavis’s 118th birthday. For Dracula catering to all of these legendary monsters is no problem but the party really starts when one ordinary guy stumbles into the hotel and changes everything!

Rated PG | Length 91 minutes

Actors

Steve Buscemi | Luenell | Rif Hutton | Jon Lovitz | Adam Sandler | Allen Covert | Molly Shannon | Rose Abdoo | Kevin James | Corey Burton | Chris Parnell | Fran Drescher | Robert Smigel | Brian George | Cam Clarke | David Spade | Jackie Sandler | Andy Samberg | Rob Riggle | Selena Gomez | Tom Kenny | Scott Menville | Maddie Taylor | Eddie Frierson | Bridget Hoffman | Jessica Pennington | Kirk Baily | Cee Lo Green | Edie Mirman | James C.J. Williams | Katie Silverman | Sadie Sandler | David Zyler | Michael Corbett | Jim Wise | Rachel Crane | Sarah Thyre | Brian Stack | Brian McCann | Sunny Sandler | John Hans Tester | Collin Dean | Ranjani Brow | Jonny Solomon | Paul Brittain | Ashley Lambert | Craig Kellman | Chris Titone | Alec Rosenthal

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0379
Total Execution Time  0.0395
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,544 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5673
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0045 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('01ca37e9d2f753d88b3e751725b82248'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
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` = 5673
 LIMIT 1 
0.0003   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 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` = 5673
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` = 5673
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5673 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)