Movielogr

movie poster

Average Rating: 8.5/10

View on: IMDb | TMDb

Harry Potter and the Prisoner of Azkaban (2004)

Directed by Alfonso Cuarón

Most recently watched by sleestakk

Overview

Year three at Hogwarts means new fun and challenges as Harry learns the delicate art of approaching a Hippogriff, transforming shape-shifting Boggarts into hilarity and even turning back time. But the term also brings danger: soul-sucking Dementors hover over the school, an ally of the accursed He-Who-Cannot-Be-Named lurks within the castle walls, and fearsome wizard Sirius Black escapes Azkaban. And Harry will confront them all.

Rated PG | Length 141 minutes

Actors

Gary Oldman | Julie Walters | Adrian Rawlins | Julie Christie | Robbie Coltrane | Alan Rickman | Dawn French | Michael Gambon | Emma Thompson | Timothy Spall | Maggie Smith | Daniel Radcliffe | Fiona Shaw | Harry Melling | Richard Griffiths | Geraldine Somerville | Rupert Grint | Emma Watson | Bonnie Wright | Chris Rankin | Tom Felton | David Bradley | Warwick Davis | David Thewlis | Josh Herdman | Pam Ferris | Mark Williams | Robert Hardy | Paul Whitehouse | Lenny Henry | Bronson Webb | Matthew Lewis | James Phelps | Oliver Phelps | Lee Ingleby | Devon Murray | Alfie Enoch | Jamie Waylett | Ian Brown | Freddie Davies | Jim Tavaré | Jimmy Gardner | Tom Ackerley | Annalisa Bugliani | Genevieve Gaunt | Violet Columbus | Abby Ford | Marianne Chase | Peter Best | Danielle Tabor | Sitara Shah | Jennifer Smith | Ekow Quartey | Kandice Morris | Samantha Clinch | Lewis Barnshaw | Tess Bu Cuarón | Ricky Sahota | Sharon Sandhu

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0217
Total Execution Time  0.0233
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,280 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4488
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0047 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'aad038abf34b9fbdd431eabca609d4622a6aa086'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('491dad835d6e931eef94b1f72aaf647d'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'aad038abf34b9fbdd431eabca609d4622a6aa086'
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` = 4488
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0023   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` = 4488
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` = 4488
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4488 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 19 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)