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
Wrath of the TitansJonathan Liebesman2012Yes04/07/2012
Total RecallLen Wiseman2012Yes08/21/2012
Best Exotic Marigold Hotel, TheJohn Madden2012NoN/A
Arthur ChristmasSarah Smith2011NoN/A
RangoGore Verbinski2011NoN/A
Wild TargetJonathan Lynn2010NoN/A
Harry Potter and the Deathly Hallows: Part 1David Yates2010NoN/A
Astro BoyDavid Bowers2009NoN/A
Astro BoyDavid Bowers2009NoN/A
Underworld: Rise of the LycansPatrick Tatopoulos2009Yes01/31/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Members / Movies By Actor )  0.0234
Total Execution Time  0.0253
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,456 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/2440/year/desc
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 8 (0.0153 seconds)  (Hide)
0.0003  
SELECT GET_LOCK('ec7c748cd43cb82e8ee131b7723e4142', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'b1681a4ae1d1d683e91e0d3b6db43304f266bf88'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0039  
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.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` = 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.0087  
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` DESC
 LIMIT 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 2440 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)