Movielogr

Home

Robert De Niro

sensoria has logged 12 out of 36 movies featuring Robert De Niro. Back to Actors by Popularity.

Movies logged featuring Robert De Niro
TitleDirector(s)Year ReleasedWatchedViewed On
Wag the DogBarry Levinson1997NoN/A
Angel HeartAlan Parker1987NoN/A
Meet the FockersJay Roach2004NoN/A
SleepersBarry Levinson1996NoN/A
Cop LandJames Mangold1997NoN/A
GoodFellasMartin Scorsese1990NoN/A
Meet the ParentsJay Roach2000NoN/A
Untouchables, TheBrian De Palma1987NoN/A
Little FockersPaul Weitz2010NoN/A
Fahrenheit 9/11Michael Moore2004NoN/A
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movies By Actor )  0.0182
Total Execution Time  0.0199
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/actor/380/watched/desc/20
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0101 seconds)  (Hide)
0.0010  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '90e979f5590b2342f13bce84c8e0a94520c51d13'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('cbedd320d31a44f9bd90f51d95b699a0', 300) AS ci_session_lock ?>
0.0009  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '90e979f5590b2342f13bce84c8e0a94520c51d13'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 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` = 380
GROUP BY `MT`.`title_id` ?>
0.0009  
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` = 380
GROUP BY `MT`.`title_id` ?>
0.0007  
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` = 380
AND `MV`.`user_id` = 1
GROUP BY `MT`.`title_id` ?>
0.0015  
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` = 1
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` = 380
GROUP BY `MT`.`title_id`
ORDER BY `movie_id` DESC
 LIMIT 20, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 380 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)