Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Saw VI (2009)

Directed by Kevin Greutert

Most recently watched by noahphex

Overview

Special Agent Strahm is dead, and Detective Hoffman has emerged as the unchallenged successor to Jigsaw’s legacy. However, when the FBI draws closer to Hoffman, he is forced to set a game into motion, and Jigsaw’s grand scheme is finally understood.

Rated R | Length 90 minutes

Actors

Shawnee Smith | Tobin Bell | Angus Macfadyen | Bahar Soomekh | Mark Rolston | Peter Outerbridge | Betsy Russell | Costas Mandylor | Scott Patterson | Athena Karkanis | Billy Otis | Niamh Wilson | Gerry Mendicino | Larissa Gomes | Shawn Mathieson | George Newbern | Mpho Koaho | Darius McCrary | Joris Jarsky | Devon Bostick | James Van Patten | John Watson | Karen Cliche | Jessie Rusu | François Sagat | Chris Owens | Elle Downs | Marty Moreau | Dan Duran | Vickie Papavs | Shauna MacDonald | Melanie Scrofano | James Gilbert | Caroline Cave | Tenika Davis | Jon Mack | Samantha Lemole | Tanedra Howard | Karl Campbell | Shawn Ahmed | Janelle Hutchison | Ginger Ruriko Busch | Catherine Rix

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0261
Total Execution Time  0.0277
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,552 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2544
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('01ca37e9d2f753d88b3e751725b82248', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
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` = 2544
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0017   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` = 2544
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2544
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2544 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)