Movielogr

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Harry Potter and the Philosopher's Stone (2001)

Directed by Chris Columbus

Most recently watched by sleestakk, suspectk, sleestakk

Overview

Harry Potter has lived under the stairs at his aunt and uncle’s house his whole life. But on his 11th birthday, he learns he’s a powerful wizard—with a place waiting for him at the Hogwarts School of Witchcraft and Wizardry. As he learns to harness his newfound powers with the help of the school’s kindly headmaster, Harry uncovers the truth about his parents’ deaths—and about the villain who’s to blame.

Rated PG | Length 152 minutes

Actors

Richard Harris | Julie Walters | Adrian Rawlins | Robbie Coltrane | Alan Rickman | John Hurt | John Cleese | Leslie Phillips | Terence Bayler | Maggie Smith | Saunders Triplets | Daniel Radcliffe | Fiona Shaw | Harry Melling | Richard Griffiths | Derek Deadman | Ian Hart | Ben Borowiecki | Verne Troyer | Geraldine Somerville | Rupert Grint | Emma Watson | Bonnie Wright | Chris Rankin | Tom Felton | Sean Biggerstaff | David Bradley | Eleanor Columbus | Warwick Davis | Emily Dale | Josh Herdman | Richard Bremmer | Zoë Wanamaker | Ray Fearon | Nina Young | Matthew Lewis | James Phelps | Oliver Phelps | Julianne Hough | Paul Marc Davis | Devon Murray | Alfie Enoch | Leila Hoffman | Luke Youngblood | Jamie Waylett | Derek Hough | Jimmy Vee | Elizabeth Spriggs | Dani Harmer | Mark Ballas | Simon Fisher-Becker | Paul Grant | Zoe Sugg | Violet Columbus | Kieri Kennedy | Jean Southern | Danielle Tabor | Leilah Sutherland | David Holmes | Will Theakston | Scot Fearn | Jamie Yeates | Harry Taylor

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0241
Total Execution Time  0.0254
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,400 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4547
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0051 seconds)  (Hide)
0.0003   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.0002   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` = 4547
 LIMIT 1 
0.0005   SET SESSION group_concat_max_len 12288 
0.0024   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` = 4547
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0005   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` = 4547
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4547 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)