Movielogr

Home

movie poster

View on: IMDb | TMDb

A Nightmare on Elm Street (1984)

Directed by Wes Craven

Overview

Teenagers in a small town are dropping like flies, apparently in the grip of mass hysteria causing their suicides. A cop’s daughter, Nancy Thompson, traces the cause to child molester Fred Krueger, who was burned alive by angry parents many years before. Krueger has now come back in the dreams of his killers’ children, claiming their lives as his revenge. Nancy and her boyfriend, Glen, must devise a plan to lure the monster out of the realm of nightmares and into the real world…

Rated R | Length 91 minutes

Actors

Johnny Depp | Robert Englund | Heather Langenkamp | David Andrews | Lin Shaye | John Saxon | Jeff Levine | Charles Fleischer | Ronee Blakley | Amanda Wyss | Jsu Garcia | Joseph Whipp | Joe Unger | Mimi Craven | Robert Shaye | Shashawnee Hall | Chris Tashima | Ed Call | Jack Shea | Ash Adams | Leslie Hoffman | Don Hannah | Sandy Lipton | Donna Woodrum | Paul Grenier | Brian Reise | Carol Pritikin | Kathi Gibbs | Antonia Yannouli | John Richard Petersen

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0225
Total Execution Time  0.0239
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,608 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6171
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('35517b52ac0b9236e38b69209c6c7c0c', 300) AS ci_session_lock 
0.0005   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
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` = 6171
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0017   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` = 6171
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0002   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` = 6171
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6171 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)