Movielogr

Home

movie poster

View on: IMDb | TMDb

Saw III (2006)

Directed by Darren Lynn Bousman

Overview

Jigsaw has disappeared. Along with his new apprentice Amanda, the puppet-master behind the cruel, intricate games that have terrified a community and baffled police has once again eluded capture and vanished. While city detective scrambles to locate him, Doctor Lynn Denlon and Jeff Reinhart are unaware that they are about to become the latest pawns on his vicious chessboard.

Rated R | Length 108 minutes

Actors

Leigh Whannell | Dina Meyer | Mike Butters | Paul Gutrecht | Shawnee Smith | Tobin Bell | Sean Sullivan | Angus Macfadyen | Kim Roberts | Bahar Soomekh | Donnie Wahlberg | Franky G | Tim Burd | Lyriq Bent | Betsy Russell | Costas Mandylor | Barry Flatman | Niamh Wilson | Mpho Koaho | Billy Parrott | Kelly Jones | Vincent Rother | Alan van Sprang | Shauna Black | Brian Paul | J. Larose | Christopher Marren | Debra McCabe | Darrell Dennis | Jane Luk | Sandy Kellerman | Mark Poyser | Dylan Trowbridge | Stefan Georgiou | Zoe Heath | Nicholas Kaegi | Dan Sudek | Bill Vibert | Larry Yachimec

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0200
Total Execution Time  0.0214
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,768 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6549
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '882bbc90480d383bb22c265c8deb41f1d00623eb'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('ece41cbce079af44cd775de6bdb8316c', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '882bbc90480d383bb22c265c8deb41f1d00623eb'
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` = 6549
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 6549
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
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` = 6549
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6549 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)