Movielogr

Home

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

The Last Boy Scout (1991)

Directed by Tony Scott

Most recently watched by sleestakk

Overview

When the girl that detective Joe Hallenback is protecting gets murdered, the boyfriend of the murdered girl attempts to investigate and solve the case. What they discover is that there is deep seated corruption going on between a crooked politician and the owner of a pro football team.

Rated R | Length 105 minutes

Actors

Bruce Willis | Jack Kehler | Frank Collison | Rick Ducommun | James Keane | Halle Berry | James Gandolfini | Joe Santos | Kim Coates | Morris Chestnut | Chelcie Ross | Tony Longo | Bruce McGill | Michael Papajohn | Robert Apisa | Danielle Harris | Damon Wayans | Chelsea Field | Noble Willingham | Taylor Negron | Donna W. Scott | Eddie Griffin | Clarence Felder | Doug Simpson | Ryan Cutrona | Dick Butkus | Julie K. Smith | Sara Suzanne Brown | Denise Ames | Teal Roberts | Badja Djola | E. Brian Dean | Billy Blanks | Frank Ferrara | Vic Manni | Gene Borkan | Dick Ziker | Lynn Swann | Frank Kopyc | Ken Kells | John Meier | Bill Medley | John Cenatiempo | Verne Lundquist | Michael J. Fisher | Joe El Rady | Duke Valenti | Manny Perry | Shane Dixon | Fred Lerner | Adam DiSpirito

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0222
Total Execution Time  0.0236
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,808 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5429
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a15090d5a8437a3fbf850af16096dd5dcbe6167d'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5fd932da10ab59ebf7d8abedcfe4efec', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a15090d5a8437a3fbf850af16096dd5dcbe6167d'
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` = 5429
 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` = 5429
GROUP BY `title_id` 
0.0001   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` = 5429
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5429 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)