Movielogr

Home

movie poster

Average Rating: 9.5/10

View on: IMDb | TMDb

The Nightmare Before Christmas (1993)

Directed by Henry Selick

Most recently watched by noahphex, jenerator

Overview

Tired of scaring humans every October 31 with the same old bag of tricks, Jack Skellington, the spindly king of Halloween Town, kidnaps Santa Claus and plans to deliver shrunken heads and other ghoulish gifts to children on Christmas morning. But as Christmas approaches, Jack’s rag-doll girlfriend, Sally, tries to foil his misguided plans.

Rated PG | Length 76 minutes

Actors

Tim Burton | Danny Elfman | Paul Reubens | Joe Ranft | Catherine O'Hara | Glenn Shadix | Chris Sarandon | William Hickey | Greg Proops | Ken Page | Daamen J. Krall | Gary Schwartz | Judi M. Durand | David McCharen | David J. Randolph | Bobbi Page | John Morris | Carmen Twillie | Debi Durst | Edward Ivory | Doris Hess | Jesse McClurg | Kerry Katz | Randy Crenshaw | Glenn Walters | Sherwood Ball | Elena Praskin | Christina MacGregor | Susan McBride | Mia Brown | L. Peter Callender | Ann Fraser | Jennifer Levey | Robert Olague | Trampas Warman | Gary Raff

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0251
Total Execution Time  0.0265
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,288 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3407
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0042 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('edfd47a5cb67737440e3f983b6c59307', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3407
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 3407
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` = 3407
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3407 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 21 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)