Movielogr

movie poster

View on: IMDb | TMDb

Saw IV (2007)

Directed by Darren Lynn Bousman

Overview

Jigsaw and his apprentice Amanda are dead. Now, upon the news of Detective Kerry’s murder, two seasoned FBI profilers, Agent Strahm and Agent Perez, arrive in the terrified community to assist the veteran Detective Hoffman in sifting through Jigsaw’s latest grisly remains and piecing together the puzzle. However, when SWAT Commander Rigg is abducted and thrust into a game, the last officer untouched by Jigsaw has but ninety minutes to overcome a series of demented traps and save an old friend or face the deadly consequences.

Rated R | Length 93 minutes

Actors

Dina Meyer | Mike Butters | Shawnee Smith | Tobin Bell | Oren Koules | Julian Richings | Angus Macfadyen | Kim Roberts | Bahar Soomekh | Donnie Wahlberg | Emmanuelle Vaugier | Lyriq Bent | Betsy Russell | Mike Realba | Noam Jenkins | Costas Mandylor | Ron Lea | Scott Patterson | Louis Ferreira | Athena Karkanis | Simon Reynolds | Marty Adams | Sarain Boylan | Billy Otis | Niamh Wilson | Tony Nappo | Kelly Jones | Devon Bostick | Joanne Boland | James Van Patten | Geoffrey Pounsett | Shauna Black | Catherine Fitch | J. Larose | Christopher Marren | Eric Gores | David Boyce | Darrell Dennis | Kevin Rushton | Janet Land | Tracey Ferencz | Ingrid Hart | Zoe Heath | Bill Vibert | Alison Luther | Sandra Manson | Christopher Morris | David Webster

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0218
Total Execution Time  0.0231
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6779
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0042 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
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` = 6779
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0018   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 6779
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6779
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6779 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)