Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Maniac Cop (1988)

Directed by William Lustig

Most recently watched by sensoria

Overview

In New York, people are slain and strangled to death brutally on the open street. All witnesses agree that the murderer was in a cop’s uniform. Soon the police search and find a suspect in its own ranks: Jack Forrest, suspected of murdering his own wife and the rest of the unfortunate individuals to die by the Maniac Cop’s reign of terror. To prove his innocence, he investigates the case with his partner, Theresa Mallory.

Rated R | Length 85 minutes

Actors

Richard Roundtree | Sam Raimi | Charles Croughwell | Bruce Campbell | Dan Hicks | Tom Atkins | Sheree North | William Lustig | Marcia Karr | Patrick Wright | Ken Lerner | John F. Goff | George Buck Flower | Leo Rossi | Laurene Landon | Robert Z'Dar | William Smith | James Dixon | Lou Bonacki | Frank Pesce | Jill Gatsby | Carla Reynolds | Rocky Giordani | Tom Taylor | Corey Michael Eubanks | Vic Manni | Victoria Catlin | Erik Holland | Judy Kerr | Jake LaMotta | Ron Holmstrom | Jefferson Richard | Barry Brenner | Louis Pastore | Nick Barbaro | Jon Greene | Ed Polgardy | Judy Levitt | Bernie Pock | Adele Sparks | Jason Lustig | Lee Arnone | Nay K. Dorsey | Ingrid Van Dorn | Luke Walter | Alma Washington | Teddy M. Haggarty | Bill Waldron | Tito Núñez | Nina Arvesen | William J. Gorman | Dennis Junt | Daniel Ortiz | Nicholas Yee

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0208
Total Execution Time  0.0222
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,016 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4196
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '8ea3f263a0d0e801fd1db7eb7a205a48b1c270ce'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('76db66929390f9c72efcc8605fc70511', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8ea3f263a0d0e801fd1db7eb7a205a48b1c270ce'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4196
 LIMIT 1 
0.0003   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 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` = 4196
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` = 4196
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4196 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)