Movielogr

Home

Samuel L. Jackson

sensoria has logged 10 out of 44 movies featuring Samuel L. Jackson. Back to Actors by Popularity.

Movies logged featuring Samuel L. Jackson
TitleDirector(s)Year ReleasedWatchedViewed On
Exterminator, TheJames Glickenhaus1980Yes09/04/2011
Coming to AmericaJohn Landis1988NoN/A
Do the Right ThingSpike Lee1989NoN/A
Sea of LoveHarold Becker1989NoN/A
GoodFellasMartin Scorsese1990NoN/A
Jungle FeverSpike Lee1991NoN/A
Jurassic ParkSteven Spielberg1993NoN/A
True RomanceTony Scott1993Yes03/01/2011
Pulp FictionQuentin Tarantino1994NoN/A
Die Hard: With a VengeanceJohn McTiernan1995NoN/A
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Actor )  0.0199
Total Execution Time  0.0213
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,656 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/actor/2231/year/asc
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 8 (0.0123 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('1aa8582e46ac7ce552ef29f38fbf8453', 300) AS ci_session_lock ?>
0.0023  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '639fcda9ad4d49bf3b79d82ce81dbf8b5d2fe52f'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0036  
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` = 2231
GROUP BY `MT`.`title_id` ?>
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` = 2231
GROUP BY `MT`.`title_id` ?>
0.0014  
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` = 2231
AND `MV`.`user_id` = 1
GROUP BY `MT`.`title_id` ?>
0.0029  
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` = 2231
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10 ?>
0.0008  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 2231 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)