Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

The Untouchables (1987)

Directed by Brian De Palma

Most recently watched by sleestakk

Overview

Young Treasury Agent Eliot Ness arrives in Chicago and is determined to take down Al Capone, but it’s not going to be easy because Capone has the police in his pocket. Ness meets Jim Malone, a veteran patrolman and probably the most honorable one on the force. He asks Malone to help him get Capone, but Malone warns him that if he goes after Capone, he is going to war.

Rated R | Length 119 minutes

Actors

Robert De Niro | Sean Connery | Kevin Costner | Charles Martin Smith | Andy Garcia | Richard Bradford | Jack Kehoe | Brad Sullivan | Billy Drago | Patricia Clarkson | Vito D'Ambrosio | Steven Goldstein | Peter Aylward | Don Harvey | Robert Swan | Jack Fitzstephens | Clifton James | Chelcie Ross | Clem Caserta | Robert Miranda | Jennifer Anglin | Anthony Mockus Sr. | Larry Brandenburg | Del Close | Mike Bacarella | John Barrowman | Justin De Rosa | Stephen Burrows | Tim Gamble | Bob Martana | Will Zahrn | Joe Greco | Sam Smiley | Eddy Donno | Vince Viverito | Matt Johnston | Valentino Cimo | Greg Noonan | Collin Hymes | John J. Walsh | Colleen Bade | Sean Grennan | Larry Viverito Sr. | Kevin Michael Doyle | Michael P. Byrne | Kaitlin Montgomery | Aditra Kohl | Charles Keller Watson | Pat Billingsley | John Bracci | Eddie Minasian | Joseph Scianablo | George S. Spataro | James Guthrie | Basil Reale | Louie Lanciloti | William Rossman | Melody Rae | Patricia E. Harrington | Jimmy Borto | Ernest Capponi | Robert Minkoff

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0194
Total Execution Time  0.0210
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,304 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4948
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0049 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c1727ac4ab2613fc9c4fce5630df3b568254026e'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT GET_LOCK('312724a2c5604c1bbf30f9efaaec13b7', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c1727ac4ab2613fc9c4fce5630df3b568254026e'
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` = 4948
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0024   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` = 4948
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` = 4948
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4948 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)