Movielogr

Home

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

Sin City (2005)

Directed by Quentin Tarantino, Frank Miller, Robert Rodriguez

Most recently watched by jenerator, suspectk, sleestakk, sensoria

Overview

Welcome to Sin City. This town beckons to the tough, the corrupt, the brokenhearted. Some call it dark… Hard-boiled. Then there are those who call it home — Crooked cops, sexy dames, desperate vigilantes. Some are seeking revenge, others lust after redemption, and then there are those hoping for a little of both. A universe of unlikely and reluctant heroes still trying to do the right thing in a city that refuses to care.

Rated R | Length 124 minutes

Actors

Bruce Willis | Elijah Wood | Michael Madsen | Brittany Murphy | Rutger Hauer | Benicio del Toro | Makenzie Vega | Frank Miller | Robert Rodriguez | Mickey Rourke | Clive Owen | Josh Hartnett | Tommy Flanagan | Patricia Vonne | Jaime King | Rosario Dawson | Devon Aoki | Alexis Bledel | Powers Boothe | Marley Shelton | Nick Stahl | Jude Ciccolella | Nick Offerman | Carla Gugino | Nicky Katt | Jason Douglas | Jeffrey J. Dashnaw | Jessica Alba | Ken Thomas | Ethan Maniquis | Michael Clarke Duncan | Arie Verveen | Tommy Nix | Rick Gomez | David H. Hickey | Chris Warner | Clark Middleton | Katherine Willis | Randal Reeder | Korey Simeone | Helen Kirk | Ethan Rains | Jesse De Luna | Marco Perella | Lisa Marie Newmyer | Texas Presley | Amanda Phillips | Paul T. Taylor | Emmy Robbin | John McLeod | Greg Ingram | Jeff Schwan | Charissa Allen | Rico Torres | Kelley Robins | Penny Vital | Ashley Moore | Cara D. Briggs | Christina Frankenfield | Evelyn Hurley | Jason McDonald | Monika Spruch | Jessica Hale | Samantha Inoue Harte | Lauren-Elaine Powell

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0224
Total Execution Time  0.0239
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,896 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3854
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0061 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '162477bd8460181d2adb089aa3299911e0d14406'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('d203a0f7c54aa71bc1eb3c6600485773', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '162477bd8460181d2adb089aa3299911e0d14406'
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` = 3854
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0039   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` = 3854
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` = 3854
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3854 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)