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.0025
Controller Execution Time ( Overview / Movie Detail )  0.0228
Total Execution Time  0.0254
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,576 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.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'fda50926b8ad7cb79084050053f5a1acb076b5da'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('11694abaa1a6609117e101c07e99bf5c', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'fda50926b8ad7cb79084050053f5a1acb076b5da'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 6171
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0013   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.0003   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.0004   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)