Movielogr

Home

John C. Reilly

noahphex has logged 6 out of 17 movies featuring John C. Reilly. Back to Actors by Popularity.

Movies logged featuring John C. Reilly
TitleDirector(s)Year ReleasedWatchedViewed On
Tim and Eric's Billion Dollar MovieTim Heidecker, Eric Wareheim2012NoN/A
9Shane Acker2009Yes01/08/2010
Promotion, TheSteve Conrad2008Yes08/09/2010
CyrusJay Duplass, Mark Duplass2010Yes12/30/2010
Cedar RapidsMiguel Arteta2011Yes06/19/2011
We Need to Talk About KevinLynne Ramsay2011Yes09/24/2011
TerriAzazel Jacobs2011Yes01/29/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Actor )  0.0115
Total Execution Time  0.0132
  GET DATA  
No GET data exists
  MEMORY USAGE  
523,720 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/actor/4764/watched/asc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0042 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'e72840f87b5e9206a347396b90a670814444dd5c'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('bde6913c5d589318d65cd8013196dc07', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'e72840f87b5e9206a347396b90a670814444dd5c'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0010  
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` = 4764
GROUP BY `MT`.`title_id` ?>
0.0004  
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` = 4764
GROUP BY `MT`.`title_id` ?>
0.0004  
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` = 4764
AND `MV`.`user_id` = 8
GROUP BY `MT`.`title_id` ?>
0.0010  
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` = 4764
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` = 4764 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)