Movielogr

Home

John Hurt

sensoria has logged 10 out of 34 movies featuring John Hurt. Back to Actors by Popularity.

Movies logged featuring John Hurt
TitleDirector(s)Year ReleasedWatchedViewed On
Frankenstein UnboundRoger Corman1990NoN/A
Indiana Jones and the Kingdom of the Crystal SkullSteven Spielberg2008NoN/A
MelancholiaLars von Trier2011NoN/A
Nineteen Eighty-FourMichael Radford1984NoN/A
HellboyGuillermo del Toro2004Yes04/03/2004
Proposition, TheJohn Hillcoat2005Yes05/26/2007
Harry Potter and the Deathly Hallows: Part 1David Yates2010Yes06/19/2011
Harry Potter and the Deathly Hallows: Part 2David Yates2011Yes07/16/2011
Hellboy II: The Golden ArmyGuillermo del Toro2008Yes07/21/2011
AlienRidley Scott1979Yes01/03/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Actor )  0.0138
Total Execution Time  0.0152
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,592 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/actor/5049/date_viewed/asc/20
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0068 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f1025ccacb0367a7731d0c401d0f7a7d9cfd224d'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('f1c92b772ed4460a88447f5d633390d3', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f1025ccacb0367a7731d0c401d0f7a7d9cfd224d'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0015  
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.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` = 5049
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` = 5049
AND `MV`.`user_id` = 1
GROUP BY `MT`.`title_id` ?>
0.0023  
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` = 5049
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 20, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 5049 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)