Movielogr

Home

movie poster

Average Rating: 8.5/10

View on: IMDb | TMDb

Serpico (1973)

Directed by Sidney Lumet

Most recently watched by krazykat

Overview

Frank Serpico is an idealistic New York City cop who refuses to take bribes, unlike the rest of the force. His actions get Frank shunned by the other officers, and often placed in dangerous situations by his partners. When his superiors ignore Frank’s accusations of corruption, he decides to go public with the allegations. Although this causes the Knapp Commission to investigate his claims, Frank has also placed a target on himself.

Rated R | Length 130 minutes

Actors

M. Emmet Walsh | James Tolkan | Al Pacino | F. Murray Abraham | Jack Kehoe | Tracey Walter | Judd Hirsch | Stephen Pearlman | Nathan George | Jaime Sánchez | Tony Roberts | Kenneth McMillan | Biff McGuire | Tony Lo Bianco | John Randolph | Judd Omen | John Lehne | Richard Foronjy | Alan North | Mary Louise Weller | Barbara Eda-Young | Cornelia Sharpe | James Bulleit | Tom Signorelli | Ben Slack | John Brandon | Val Bisoglio | Sam Coppola | Don Billett | Hank Garrett | Bernard Barrow | Mildred Clinton | Tim Pelt | Albert Henderson | Damien Leake | George Loros | Jay Rasumny | Lewis J. Stadlen | Woodie King Jr. | George Ede | Edward Grover | René Enríquez | Ed Crowley | Allan Rich | Ted Beniades | Joseph Bova | Conard Fowkes | Richard Kuss | John McQuade | Charles White | Sal Carollo | John Medici | Frank Gio | P.J. Benjamin | Gene Gross | John Stewart | Norman Ornellas | Gus Fleming | Roy Cheverie | Marjorie Eliot | Trent Gough | Paul E. Guskin | Nick Hardin | William Pelt | Franklin Scott

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0200
Total Execution Time  0.0214
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,320 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5480
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0003   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` = 5480
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 5480
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` = 5480
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5480 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 19 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)