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
Tinker Tailor Soldier SpyTomas Alfredson2011NoN/A
Unborn, TheDavid S. Goyer2009NoN/A
True RomanceTony Scott1993NoN/A
Harry Potter and the Prisoner of AzkabanAlfonso Cuarón2004Yes06/05/2004
Batman BeginsChristopher Nolan2005Yes06/16/2005
Harry Potter and the Goblet of FireMike Newell2005Yes11/20/2005
Harry Potter and the Order of the PhoenixDavid Yates2007Yes07/14/2007
Léon: The ProfessionalLuc Besson1994Yes05/18/2009
Book of Eli, TheAlbert Hughes, Allen Hughes2010Yes01/23/2010
Kung Fu Panda 2Jennifer Yuh Nelson2011Yes01/08/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Actor )  0.0112
Total Execution Time  0.0126
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,552 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/64/date_viewed/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0047 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '203a756b4fa277c699ef8b0b9b6cdc2a346f8e0f'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('aaf072ac83953dcfd2df3e1f95375b89', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '203a756b4fa277c699ef8b0b9b6cdc2a346f8e0f'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0006  
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.0003  
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.0006  
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.0017  
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 `date_viewed` ASC
 LIMIT 10, 10 ?>
0.0003  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 64 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)