Movielogr

Home

John Hurt

sleestakk has logged 13 out of 34 movies featuring John Hurt. Back to Actors by Popularity.

Movies logged featuring John Hurt
TitleDirector(s)Year ReleasedWatchedViewed On
Captain Corelli's MandolinJohn Madden2001NoN/A
Harry Potter and the Philosopher's StoneChris Columbus2001Yes06/05/2002
DogvilleLars von Trier2003NoN/A
HellboyGuillermo del Toro2004Yes04/03/2004
Skeleton Key, TheIain Softley2005NoN/A
Proposition, TheJohn Hillcoat2005Yes05/26/2007
Perfume: The Story of a MurdererTom Tykwer2006Yes04/16/2009
V for VendettaJames McTeigue2006Yes03/19/2006
Oxford Murders, TheÁlex de la Iglesia2008NoN/A
OutlanderHoward McCain2008Yes01/24/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0021
Controller Execution Time ( Members / Movies By Actor )  0.0197
Total Execution Time  0.0219
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,256 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/5049/year/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 8 (0.0072 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('a9a70daff60c2f5043c95d611f1d994c', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'aa0197441f342884ed303fbaad93190fc489a518'
AND `ip_address` = '216.73.216.6' ?>
0.0018  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
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` = 5049
GROUP BY `MT`.`title_id` ?>
0.0004  
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` = 5049
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` = 5049
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0030  
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` = 5049
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` = 5049 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)