Movielogr

Home

Brian Cox

jenerator has logged 10 out of 29 movies featuring Brian Cox. Back to Actors by Popularity.

Movies logged featuring Brian Cox
TitleDirector(s)Year ReleasedWatchedViewed On
Escapist, TheRupert Wyatt2008NoN/A
Exit HumanityJohn Geddes2011NoN/A
Fantastic Mr. FoxWes Anderson2009NoN/A
IroncladJonathan English2011Yes07/31/2011
Key Man, ThePeter Himmelstein2011NoN/A
Long Kiss Goodnight, TheRenny Harlin1996Yes07/03/2011
Match PointWoody Allen2005NoN/A
Poodle SpringsBob Rafelson1998NoN/A
REDRobert Schwentke2010Yes09/29/2010
Red EyeWes Craven2005NoN/A
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Actor )  0.0116
Total Execution Time  0.0130
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,000 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/actor/1248/title/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0051 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '8f3f93943a792e1447d7464445ae47077f5c2026'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('a3ef330214b144862db3f5ca665b8007', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8f3f93943a792e1447d7464445ae47077f5c2026'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0010  
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` = 1248
GROUP BY `MT`.`title_id` ?>
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` = 1248
GROUP BY `MT`.`title_id` ?>
0.0010  
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` = 1248
AND `MV`.`user_id` = 61
GROUP BY `MT`.`title_id` ?>
0.0012  
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` = 61
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` = 1248
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 1248 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)