Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

L.A. Confidential (1997)

Directed by Curtis Hanson

Most recently watched by sleestakk

Overview

Three detectives in the corrupt and brutal L.A. police force of the 1950s use differing methods to uncover a conspiracy behind the shotgun slayings of the patrons at an all-night diner.

Rated R | Length 138 minutes

Actors

Kim Basinger | Danny DeVito | Guy Pearce | Paul Guilfoyle | Russell Crowe | Tomas Arana | David St. James | Kevin Spacey | James Cromwell | Jimmy Ortega | Graham Beckel | Steve Rankin | David Strathairn | Ron Rifkin | Jack Knight | Jack Conley | Brenda Bakke | Sandra Taylor | Allan Graf | Chris Palermo | Nectar Rose | Lennie Loftin | Matt McCoy | Amber Smith | Thomas Rosales, Jr. | John Mahon | Jeff Sanders | Norman Howell | Irene Roseen | Jim Metzler | April Breneman | Steven Lambert | Michael Chieffo | Jeremiah Birkett | Bob Clendenin | Rocco Salata | Gregory White | Ingo Neuhaus | Dell Yount | Gene Wolande | Robert Thompson | Paolo Seganti | Robert Foster | Gilbert Rosales | Elisabeth Granli | Michael McCleery | Gwenda Deacon | Brian Lally | Scott McKinley | Rebecca Klingler | April Audia | Symba | Jeff Austin | Will Zahrn | Darrell Sandeen | Shawnee Free Jones | Marisol Padilla Sánchez | Scott Eberlein | Jordan Marder | Simon Baker | Michael Warwick | Salim Grant | T.J. Kennedy | Shane Dixon | Fred Lerner | Brian Bossetta | Precious Chong | Priscilla Cory | Kevin Patrick Kelly | Don Pulford | John Slade | Noel Evangelisti | Jody Wood | Colin Mitchell | J.P. Romano | Patrice Walters | Robert Barry Fleming | Bodie Newcomb | John H. Evans | Anne Zogby | George Yager | Ginger Slaughter | Karr Washington | Lisa Worthy | Beverly Sharpe | Kevin Maloney | Henry Marder | Monty McKee | Henry Meyers | Michael Ossmann | Dick Stilwell | Jess Thomas | Chris Short | Robert Harrison | Matthew Allen Bretz

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