Movielogr

Home

movie poster

Average Rating: 9.5/10

View on: IMDb | TMDb

Harry Potter and the Half-Blood Prince (2009)

Directed by David Yates

Most recently watched by jenerator, jenerator, jenerator, jenerator, suspectk

Overview

As Lord Voldemort tightens his grip on both the Muggle and wizarding worlds, Hogwarts is no longer a safe haven. Harry suspects perils may even lie within the castle, but Dumbledore is more intent upon preparing him for the final battle fast approaching. Together they work to find the key to unlock Voldemorts defenses and to this end, Dumbledore recruits his old friend and colleague Horace Slughorn, whom he believes holds crucial information. Even as the decisive showdown looms, romance blossoms for Harry, Ron, Hermione and their classmates. Love is in the air, but danger lies ahead and Hogwarts may never be the same again.

Rated PG | Length 153 minutes

Actors

Jim Broadbent | Julie Walters | Helena Bonham Carter | Robbie Coltrane | Natalia Tena | Alan Rickman | Michael Gambon | Gemma Jones | Timothy Spall | Maggie Smith | Daniel Radcliffe | Geraldine Somerville | Rupert Grint | Emma Watson | Bonnie Wright | Tom Felton | David Bradley | Warwick Davis | David Thewlis | Josh Herdman | Joerg Stadler | Helen McCrory | Mark Williams | Amelda Brown | Paul Ritter | Dave Legeno | Elarica Gallacher | Matthew Lewis | James Phelps | Evanna Lynch | Oliver Phelps | Georgina Leonidas | Ralph Ineson | Suzie Toase | Rod Hunt | Devon Murray | Alfie Enoch | Jessie Cave | Shefali Chowdhury | Afshan Azad | Louis Cordice | Scarlett Byrne | Anna Shaffer | Isabella Laughland | Katie Leung | Freddie Stroma | William Melling | Amber Evans | Ruby Evans | Jamie Waylett | Frank Dillane | Hero Fiennes-Tiffin | Olivia Jewson | Mark Lockyer | Robert Knox | Caroline Wildi | Nathan Clarke | Freddie Rose | Jack Pryor

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0220
Total Execution Time  0.0236
  GET DATA  
No GET data exists
  MEMORY USAGE  
522,600 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3779
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0046 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '9569bbff4de7f138de5f880ee79d0594c2a89b53'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('cd2e7828cb41c1e419246309c40c4ac5', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9569bbff4de7f138de5f880ee79d0594c2a89b53'
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` = 3779
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0021   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` = 3779
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 3779
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3779 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 21 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)