Movielogr

Home

Jack Black

sleestakk has logged 10 out of 21 movies featuring Jack Black. Back to Actors by Popularity.

Movies logged featuring Jack Black
TitleDirector(s)Year ReleasedWatchedViewed On
Jackal, TheMichael Caton-Jones1997NoN/A
King KongPeter Jackson2005Yes12/16/2005
Kung Fu PandaMark Osborne, John Stevenson2008Yes03/26/2009
Kung Fu Panda 2Jennifer Yuh Nelson2011Yes01/08/2012
Mars Attacks!Tim Burton1996NoN/A
Muppets, TheJames Bobin2011NoN/A
Nacho LibreJared Hess2006Yes02/13/2009
School of RockRichard Linklater2003NoN/A
Tropic ThunderBen Stiller2008Yes08/30/2008
Walk Hard: The Dewey Cox StoryJake Kasdan2007Yes01/27/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Actor )  0.0109
Total Execution Time  0.0123
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,184 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/70851/title/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0043 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '94c59f960ea1150adfbe38eccea554a30569b883'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('6a747efa09be6c2ec98fe84446ef0598', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '94c59f960ea1150adfbe38eccea554a30569b883'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
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` = 70851
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` = 70851
GROUP BY `MT`.`title_id` ?>
0.0008  
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` = 70851
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0011  
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` = 70851
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 70851 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)