Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

The Treasure of the Sierra Madre (1948)

Directed by John Huston

Most recently watched by sleestakk

Overview

Fred C. Dobbs and Bob Curtin, both down on their luck in Tampico, Mexico in 1925, meet up with a grizzled prospector named Howard and decide to join with him in search of gold in the wilds of central Mexico. Through enormous difficulties, they eventually succeed in finding gold, but bandits, the elements, and most especially greed threaten to turn their success into disaster.

Rated NR | Length 126 minutes

Actors

Humphrey Bogart | John Huston | Robert Blake | Barton MacLane | Tim Holt | Walter Huston | Bruce Bennett | Alfonso Bedoya | Arturo Soto Rangel | Manuel Dondé | José Torvay | Margarito Luna | Ray Spiker | Roberto Cañedo | Jack Holt | Martin Garralaga | Clifton Young | Jacqueline Dalya | Ralph Dunn | Pat Flaherty | Julian Rivero | Guillermo Calles | Spencer Chan | Jay Silverheels | Harry J. Vejar | Ángela Rodríguez | Ignacio Villalbazo | Ernesto Escoto | Francisco Islas | Mario Mancilla | Valdespino | Ildefonso Vega

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0424
Total Execution Time  0.0440
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,600 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5181
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0269 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '433dd0021c30ffc60559f6ab3dff5a618bf223e7'
AND `ip_address` = '216.73.216.137' 
0.0207   SELECT GET_LOCK('d1eb69bc49b0c044e6b5ba4f6743e3a4', 300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '433dd0021c30ffc60559f6ab3dff5a618bf223e7'
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` = 5181
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0030   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` = 5181
GROUP BY `title_id` 
0.0004   SET SESSION group_concat_max_len = 1024 
0.0007   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` = 5181
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0006   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5181 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)