Movielogr

Home

movie poster

View on: IMDb | TMDb

Scarface (1983)

Directed by Brian De Palma

Overview

After getting a green card in exchange for assassinating a Cuban government official, Tony Montana stakes a claim on the drug trade in Miami. Viciously murdering anyone who stands in his way, Tony eventually becomes the biggest drug lord in the state, controlling nearly all the cocaine that comes through Miami. But increased pressure from the police, wars with Colombian drug cartels and his own drug-fueled paranoia serve to fuel the flames of his eventual downfall.

Rated R | Length 170 minutes

Actors

Al Pacino | Steven Bauer | Michelle Pfeiffer | Mary Elizabeth Mastrantonio | Robert Loggia | Miriam Colon | F. Murray Abraham | Paul Shenar | Harris Yulin | Ángel Salazar | Arnaldo Santana | Pepe Serna | Michael P. Moran | Al Israel | Dennis Holahan | Mark Margolis | Charles Durning | Gregg Henry | Kevyn Major Howard | Brett Ratner | Dennis Franz | Manuel Padilla Jr. | Charles A. Tamburro | Henry Kingi | Richard Belzer | Mario Machado | Angela Aames | Santos Morales | Gary Carlos Cervantes | Lana Clarkson | Geno Silva | John Carter | Gregory Cruz | Tony Perez | John Brandon | Victor Millan | Mike Moroff | Katt Shea | Roberto Contreras | Ronald G. Joseph | Gil Barreto | Victor Campos | Ben Frommer | Dante D'Andre | Albert Carrier | Rene Carrasco | Lee Benton | John McCann | Maxine Wasa | Michael Rougas | Linda Gillen | Emilia Crow | Ted Beniades | Shelley Taylor Morgan | Michael Alldredge | Ava Lazar | Garnett Smith | Margaret Michaels | Marcus Shirock | Carlos Augusto Cestero | Barclay DeVeau | Terri Taylor | Ilka Tanya Payán | Richard Delmonte | Caesar Cordova | Jeanette Linne | Heather Benna | Sue Bowser | Paul Espel | Loren Almaguer | Tina Leigh Cameron | Robert Hammer Cannerday | Richard Caselnova | Johnny Contardo | Tammy Lynn Leppert

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