Movielogr

Home

movie poster

Average Rating: 8.5/10

View on: IMDb | TMDb

Hot Fuzz (2007)

Directed by Edgar Wright

Most recently watched by krazykat, sleestakk

Overview

Former London constable Nicholas Angel finds it difficult to adapt to his new assignment in the sleepy British village of Sandford. Not only does he miss the excitement of the big city, but he also has a well-meaning oaf for a partner. However, when a series of grisly accidents rocks Sandford, Angel smells something rotten in the idyllic village.

Rated R | Length 121 minutes

Actors

Peter Jackson | Cate Blanchett | Jim Broadbent | Paul Freeman | Bill Nighy | Rory McCann | Steve Coogan | Ron Cook | Martin Freeman | Billie Whitelaw | Timothy Dalton | Edgar Wright | Simon Pegg | Nick Frost | David Bradley | Stuart Wilson | Paddy Considine | Peter Wight | Bill Bailey | Kenneth Cranham | Rafe Spall | Kevin Eldon | Karl Johnson | Olivia Colman | Edward Woodward | Stephen Merchant | Garth Jennings | David Threlfall | Lucy Punch | Anne Reid | Tim Barlow | Lorraine Hilton | Chris Waitt | Patricia Franklin | Julia Deakin | Joe Cornish | Adam Buxton | Alice Lowe | Maria Charles | Robert Popper | Eric Mason | Graham Low | Elizabeth Elvin | Ben McKay | Colin Michael Carmichael | Trevor Nichols | Alexander King | Tom Strode Walton | Troy Woollan | Rory Lowings | Kevin Wilson | Nicholas Wilson

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0200
Total Execution Time  0.0218
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,344 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4924
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0fea357d757995380c040d3ea929c528', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
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` = 4924
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0016   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` = 4924
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` = 4924
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4924 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 19 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)