Movielogr

movie poster

View on: IMDb | TMDb

Silverado (1985)

Directed by Lawrence Kasdan

Overview

Four unwitting heroes cross paths on their journey to the sleepy town of Silverado. Little do they know the town where their family and friends reside has been taken over by a corrupt sheriff and a murderous posse. It’s up to the sharp-shooting foursome to save the day, but first they have to break each other out of jail, and learn who their real friends are.

Rated PG-13 | Length 133 minutes

Actors

Scott Glenn | Brion James | Kevin Costner | Danny Glover | Rosanna Arquette | Sheb Wooley | Jeff Goldblum | Brian Dennehy | John Cleese | Kevin Kline | Jim Haynie | Linda Hunt | Ray Baker | Marvin J. McIntyre | Amanda Wyss | Lynn Whitfield | James Gammon | Jeff Fahey | Todd Allen | Richard Jenkins | Jon Kasdan | Bill Thurman | Joe Seneca | Jake Kasdan | Earl Hindman | Thomas Wilson Brown | Brad Leland | Dick Durock | Meg Kasdan | Patricia Gaul | Sam Gauny | Kenny Call | Gene Hartline | Roy McAdams | Autry Ward | Rusty Meyers | Zeke Davidson | Lois Geary | Troy Ward | Ken Farmer

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0202
Total Execution Time  0.0217
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,808 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6309
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
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` = 6309
 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 filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 6309
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6309
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6309 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)