Movielogr

Home

Lance Henriksen

noahphex has logged 11 out of 28 movies featuring Lance Henriksen. Back to Actors by Popularity.

Movies logged featuring Lance Henriksen
TitleDirector(s)Year ReleasedWatchedViewed On
Stone ColdCraig R. Baxley1991NoN/A
Dead ManJim Jarmusch1995NoN/A
AVP: Alien vs. PredatorPaul W.S. Anderson2004NoN/A
HouseRobby Henson2008NoN/A
Man's Best FriendJohn Lafia1993NoN/A
Pit and the Pendulum, TheStuart Gordon1991NoN/A
NightmaresJoseph Sargent1983NoN/A
Jennifer's BodyKaryn Kusama2009Yes01/02/2010
AliensJames Cameron1986Yes01/26/2010
Survival QuestDon Coscarelli1988Yes10/09/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Actor )  0.0128
Total Execution Time  0.0143
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/actor/2714/watched/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0052 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9829308bbb658f8baf3ff870f63841e14b2c62ff'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('74a4120e34243a08f30d0e81b4c03005', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9829308bbb658f8baf3ff870f63841e14b2c62ff'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0007  
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` = 2714
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` = 2714
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` = 2714
AND `MV`.`user_id` = 8
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` = 8
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` = 2714
GROUP BY `MT`.`title_id`
ORDER BY `movie_id` ASC
 LIMIT 10, 10 ?>
0.0006  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 2714 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)