Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Se7en (1995)

Directed by David Fincher

Most recently watched by sleestakk

Overview

Two homicide detectives are on a desperate hunt for a serial killer whose crimes are based on the “seven deadly sins” in this dark and haunting film that takes viewers from the tortured remains of one victim to the next. The seasoned Det. Sommerset researches each sin in an effort to get inside the killer’s mind, while his novice partner, Mills, scoffs at his efforts to unravel the case.

Rated R | Length 127 minutes

Actors

Morgan Freeman | Brad Pitt | Mark Boone Junior | Arthur Max | Kevin Spacey | Leland Orser | Richard Portnow | Richard Roundtree | Richmond Arquette | R. Lee Ermey | Michael Massee | Lexie Bigham | Harris Savides | Heidi Schanz | John C. McGinley | Andrew Kevin Walker | Gwyneth Paltrow | Daniel Zacapa | John Cassini | Hawthorne James | Charles A. Tamburro | Bob Stephenson | Charles S. Dutton | Peter Crombie | Richard Schiff | Allan Kolman | Reg E. Cathey | Lennie Loftin | Endre Hules | Alfonso Freeman | James Deeth | David Correia | Dominique Jennings | Shannon Wilcox | Pamala Tyson | Gene Borkan | Emily Wagner | Brian Evers | Michael Reid MacKay | Evan Mirand | Mario Di Donato | William Davidson | Bob Collins | Martin Serene | Rachel Flanagan | Harrison White | Paul Eckstein | Julie Araskog | George Christy | Jennifer Mueller | Duffy Gaver | Tudor Sherrard | Sarah Reinhardt | Jimmy Dale Hartsell | Bob Mack | Charline Su | Beverly Burke | John Santin | Ron Blair

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0192
Total Execution Time  0.0207
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,064 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4871
  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` = 'fc10446e35b952af9add9fbaead90e29163c9135'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('3e07e022fb460450f98b0cfb19ce9d70', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'fc10446e35b952af9add9fbaead90e29163c9135'
AND `ip_address` = '216.73.216.137' 
0.0015   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4871
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0010   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` = 4871
GROUP BY `title_id` 
0.0001   SET SESSION group_concat_max_len = 1024 
0.0002   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` = 4871
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4871 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)