Movielogr

Home

Bill Nighy

sleestakk has logged 12 out of 22 movies featuring Bill Nighy. Back to Actors by Popularity.

Movies logged featuring Bill Nighy
TitleDirector(s)Year ReleasedWatchedViewed On
Still CrazyBrian Gibson1998NoN/A
Love ActuallyRichard Curtis2003Yes05/09/2009
UnderworldLen Wiseman2003Yes01/25/2009
Shaun of the DeadEdgar Wright2004Yes10/09/2004
Hitchhiker's Guide to the Galaxy, TheGarth Jennings2005Yes05/01/2005
Pirates of the Caribbean: Dead Man's ChestGore Verbinski2006Yes07/30/2006
StormbreakerGeoffrey Sax2006Yes05/13/2012
Notes on a ScandalRichard Eyre2006NoN/A
Underworld: EvolutionLen Wiseman2006Yes01/21/2006
Pirates of the Caribbean: At World's EndGore Verbinski2007Yes06/30/2007
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Actor )  0.0121
Total Execution Time  0.0134
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/2440/year/asc
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 8 (0.0061 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('7d6bfad46e2b98c717ccbb70533c6890', 300) AS ci_session_lock ?>
0.0007  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3a3037d4cecbd09cc9007a32888b716f150e6214'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 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` = 2440
GROUP BY `MT`.`title_id` ?>
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` = 2440
GROUP BY `MT`.`title_id` ?>
0.0009  
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` = 2440
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0022  
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` = 2440
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10 ?>
0.0003  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 2440 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)