Movielogr

Home

movie poster

View on: IMDb | TMDb

King of New York (1990)

Directed by Abel Ferrara

Overview

A former drug lord returns from prison determined to wipe out all his competition and distribute the profits of his operations to New York’s poor and lower classes in this stylish and ultra violent modern twist on Robin Hood.

Rated R | Length 103 minutes

Actors

Steve Buscemi | Victor Argo | Laurence Fishburne | Paul Calderon | Theresa Randle | Christopher Walken | Frank Adonis | Giancarlo Esposito | Harold Perrineau | Gary Landon Mills | Wesley Snipes | Leonard L. Thomas | David Caruso | Carlos Lauchu | Vanessa Angel | Roger Guenveur Smith | Janet Julian | Joey Chin | Carrie Nygren | Ernest Abuba | Robert LaSardo | Ariane | Lance Guecia | Erica Gimpel | Alonna Shaw | Pete Hamill | James Lorinz | Sari Chang | Jay Julien | Phoebe Legere | Lia Chang | Frank Aquilino | Frankie Cee | John Reidy | Frank Gio | David Batiste | Michael Guess | Gerard Murphy | Michael Battin | Jack Goode Jr. | Freddy Howard | Nancy Hunter | Susannah Julien | George Lawrence Perry | Marty Pesci | Peter Richardson | Mark Monto | Dhonna Harris Goodale | Phil Nelson

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