Movielogr

Home

Gary Oldman

sleestakk has logged 10 out of 23 movies featuring Gary Oldman. Back to Actors by Popularity.

Movies logged featuring Gary Oldman
TitleDirector(s)Year ReleasedWatchedViewed On
Harry Potter and the Order of the PhoenixDavid Yates2007Yes07/14/2007
Harry Potter and the Goblet of FireMike Newell2005Yes11/20/2005
Harry Potter and the Deathly Hallows: Part 2David Yates2011NoN/A
Harry Potter and the Deathly Hallows: Part 2David Yates2011NoN/A
Harry Potter and the Deathly Hallows: Part 2David Yates2011NoN/A
Fifth Element, TheLuc Besson1997NoN/A
Dark Knight Rises, TheChristopher Nolan2012Yes08/01/2012
Dark Knight, TheChristopher Nolan2008Yes07/22/2012
Book of Eli, TheAlbert Hughes, Allen Hughes2010Yes01/23/2010
Batman BeginsChristopher Nolan2005Yes06/16/2005
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Actor )  0.0124
Total Execution Time  0.0138
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,488 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/64/title/desc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0061 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'd7ee3310f120f719de92a33190190a9ca60d21e4'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('0f6f6e59500726e28e6dee7a4d6aedd4', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd7ee3310f120f719de92a33190190a9ca60d21e4'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
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` = 64
GROUP BY `MT`.`title_id` ?>
0.0005  
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` = 64
GROUP BY `MT`.`title_id` ?>
0.0014  
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` = 64
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0020  
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` = 9
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` = 64
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 10, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 64 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)