Movielogr

Home

Steve Buscemi

sleestakk has logged 14 out of 32 movies featuring Steve Buscemi. Back to Actors by Popularity.

Movies logged featuring Steve Buscemi
TitleDirector(s)Year ReleasedWatchedViewed On
Things to Do in Denver When You're DeadGary Fleder1995NoN/A
RampartOren Moverman2011NoN/A
I Knew It Was You: Rediscovering John CazaleRichard Shepard2009NoN/A
Big FishTim Burton2003NoN/A
Coffee and CigarettesJim Jarmusch2004NoN/A
Ghost WorldTerry Zwigoff2001NoN/A
Domestic DisturbanceHarold Becker2001NoN/A
Art School ConfidentialTerry Zwigoff2006NoN/A
IgorAnthony Leondis2008Yes05/12/2012
Escape from L.A.John Carpenter1996Yes05/16/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Actor )  0.0800
Total Execution Time  0.0813
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,008 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/884/watched/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0695 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '5842921d523c5b00616018af934d965605208efa'
AND `ip_address` = '216.73.216.6' ?>
0.0228  
SELECT GET_LOCK('8379518ed0a8866cce715dd7ffcbec06', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5842921d523c5b00616018af934d965605208efa'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 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` = 884
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` = 884
GROUP BY `MT`.`title_id` ?>
0.0397  
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` = 884
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0044  
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` = 884
GROUP BY `MT`.`title_id`
ORDER BY `movie_id` ASC
 LIMIT 10, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 884 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)