Movielogr

Home

movie poster

Rating: 4.5 stars

Tags

Alamo South

Seen 1 time

Seen on: 07/23/2011

View on: IMDb | TMDb

Harry Potter and the Deathly Hallows: Part 2 (2011)

Directed by David Yates

Fantasy

Most recently watched by noahphex

Overview

Harry, Ron and Hermione continue their quest to vanquish the evil Voldemort once and for all. Just as things begin to look hopeless for the young wizards, Harry discovers a trio of magical objects that endow him with powers to rival Voldemort’s formidable skills.

Rated PG-13 | Length 130 minutes

Actors

Gary Oldman | Jim Broadbent | Julie Walters | Nick Moran | Helena Bonham Carter | Adrian Rawlins | Robbie Coltrane | George Harris | Natalia Tena | Alan Rickman | John Hurt | Ralph Fiennes | Michael Gambon | Miriam Margolyes | Emma Thompson | Ciarán Hinds | Kelly Macdonald | Gemma Jones | Timothy Spall | Leslie Phillips | David Heyman | Maggie Smith | Daniel Radcliffe | Geraldine Somerville | Rupert Grint | Emma Watson | Bonnie Wright | Chris Rankin | Tom Felton | Sean Biggerstaff | David Bradley | Warwick Davis | David Thewlis | Josh Herdman | Clémence Poésy | Jason Isaacs | Helen McCrory | Mark Williams | Spencer Wilding | Guy Henry | Dave Legeno | Ashley McGuire | Domhnall Gleeson | Matthew Lewis | James Phelps | Evanna Lynch | Oliver Phelps | Granville Saxton | Pauline Stone | Georgina Leonidas | Jade Gordon | Ralph Ineson | Ian Peck | Emil Hostina | Luke Newberry | Suzie Toase | Devon Murray | Alfie Enoch | Jessie Cave | Afshan Azad | Louis Cordice | Scarlett Byrne | Anna Shaffer | Isabella Laughland | Katie Leung | Freddie Stroma | Rusty Goffe | Benn Northover | Helena Barlow | Anthony Allgood | Hebe Beardsall | William Melling | Sian Grace Phillips | Amber Evans | Ruby Evans | Jon Key | Gary Sayer | Tony Adkins | Penelope McGhie | Ellie Darcey-Alden | Ariella Paradise | Benedict Clarke | Rohan Gotobed | Toby Papworth | Peter G. Reed | Judith Sharp | Bob Yves Van Hellenberg Hubar | Tony Kirwood | Arthur Bowen | Daphne de Beistegui | Will Dunn | Bertie Gilbert | Ryan Turner | Graham Duff | Alfie McIlwain | Vinnie Clarke | Keijo J. Salmela | Phil Wright | Harrison Davis | Paul Bailey | Charlie Hobbs | Annabelle Davis

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Members / Movie Detail )  0.0294
Total Execution Time  0.0312
  GET DATA  
No GET data exists
  MEMORY USAGE  
546,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/movie_detail/4833
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0075 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '712a989892598dd5d8663258b8b072f4d3e2bbaa'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('8746df7f2341839e3aa085f2e1afac19', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '712a989892598dd5d8663258b8b072f4d3e2bbaa'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 4833
AND `MV`.`user_id` = 8
 LIMIT 1 
0.0004   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 8
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0033   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_name` AS `genre_name_01`, `G2`.`genre_name` AS `genre_name_02`, `G3`.`genre_name` AS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, 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_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MP` ON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1` ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2` ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3` ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMT` ON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRC` ON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVC` ON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_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 `MV`.`movie_id` = 4833
AND `MV`.`user_id` = 8
ORDER BY `date_viewed` DESC 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0003   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EV` ON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 4833 
0.0003   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MT` ON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 4833 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 8
 LIMIT 1 
0.0001   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 8
AND `MV`.`movie_id` = 4833
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_five_star` `MR`
WHERE `MR`.`rating_id` = '20'
 LIMIT 1 
0.0004   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2` ON `MV`.`title_id` = `MV2`.`title_id` AND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 8
AND `MV`.`movie_id` = 4833
GROUP BY `MV2`.`movie_id`
ORDER BY `MV2`.`date_viewed` DESC 
0.0003   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 4833 
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` = 3237
ORDER BY `date_viewed` DESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)