Movielogr

Home

Sam Rockwell

testguy has logged 1 out of 20 movies featuring Sam Rockwell. Back to Actors by Popularity.

Movies logged featuring Sam Rockwell
TitleDirector(s)Year ReleasedWatchedViewed On
Assassination of Jesse James by the Coward Robert Ford, TheAndrew Dominik2007NoN/A
JoshuaGeorge Ratliff2007NoN/A
Frost/NixonRon Howard2008NoN/A
ChokeClark Gregg2008NoN/A
I Knew It Was You: Rediscovering John CazaleRichard Shepard2009NoN/A
G-ForceHoyt Yeatman2009NoN/A
MoonDuncan Jones2009NoN/A
Iron Man 2Jon Favreau2010Yes06/04/2010
Sitter, TheDavid Gordon Green2011NoN/A
Cowboys & AliensJon Favreau2011NoN/A
  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Members / Movies By Actor )  0.0183
Total Execution Time  0.0202
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,344 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/testguy/actor/6807/year/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0101 seconds)  (Hide)
0.0006  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '790160ef71cb3d6bc63863181dbc477309cdbdae'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('89bf994dcb76d304e8663699daed4ade', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '790160ef71cb3d6bc63863181dbc477309cdbdae'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'testguy'
 LIMIT 1 ?>
0.0043  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 6807
GROUP BY `MT`.`title_id` ?>
0.0007  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 6807
GROUP BY `MT`.`title_id` ?>
0.0008  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 6807
AND `MV`.`user_id` = 89
GROUP BY `MT`.`title_id` ?>
0.0025  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `tmdb_id`, MAX(MV.movie_id) AS movie_id, MAX(date_viewed) AS date_viewed, MAX(actor_name) AS actor_name, `ACT`.`tmdb_actor_id`, 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
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id` AND `MV`.`user_id` = 89
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_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`
WHERE `JMA`.`tmdb_actor_id` = 6807
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10, 10 ?>
0.0003  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 6807 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)