Movielogr

movie poster

View on: IMDb | TMDb

All the King's Men (2006)

Directed by Steven Zaillian

Overview

The story of an idealist’s rise to power in the world of Louisiana politics and the corruption that leads to his ultimate downfall. Based on the 1946 Pulitzer Prize-winning novel written by Robert Penn Warren, loosely based on the story of real-life politician Huey Long.

Rated PG-13 | Length 125 minutes

Actors

Mark Ruffalo | Kate Winslet | Patricia Clarkson | Kathy Baker | Sean Penn | Anthony Hopkins | James Gandolfini | Frederic Forrest | Jude Law | Eileen Ryan | Glenn Morshower | Kevin Dunn | Jackie Earle Haley | Thomas McCarthy | Travis Champagne | Connor Fox | Montgomery John | Lenka Peterson | Tom Aldredge | Marcus Hester | Gary Grubbs | Jordan Rhodes | Jay Patterson | Michael Cavanaugh | Talia Balsam | Keb' Mo' | Paul Desmond | Caroline Lagerfelt | Valerie Stodghill | Joe Knezevich | Nicole Bobek | Hunt Downer | T.J. Falterman | Luke Morris | Caroline Renee Christmann | Bruce Heinrich | Charlie Newell | Leila Bazzani | Luis Campos | Ralph E. Carroll Jr. | Benjamin C. Clement | Marlon Horton

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0228
Total Execution Time  0.0244
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/7192
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '22d6e183c1247bcf59223aba6215c36b31bb684d'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('ebc4243bce2c34505a98d15cf883428e'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '22d6e183c1247bcf59223aba6215c36b31bb684d'
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` = 7192
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0019   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` = 7192
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0004   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` = 7192
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 7192 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)