Movielogr

Home

Michael Papajohn

sensoria has logged 11 out of 24 movies featuring Michael Papajohn. Back to Actors by Popularity.

Movies logged featuring Michael Papajohn
TitleDirector(s)Year ReleasedWatchedViewed On
Predator 2Stephen Hopkins1990NoN/A
Man Apart, AF. Gary Gray2003NoN/A
Longest Yard, ThePeter Segal2005NoN/A
Live Free or Die HardLen Wiseman2007NoN/A
Last Boy Scout, TheTony Scott1991NoN/A
Land of the LostBrad Silberling2009NoN/A
HulkAng Lee2003Yes07/15/2011
Escape PlanMikael Håfström2013Yes02/10/2011
Drive AngryPatrick Lussier2011Yes12/25/2011
DominoTony Scott2005Yes04/03/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Actor )  0.0723
Total Execution Time  0.0738
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,096 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/actor/20582/title/desc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0644 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f240a96dc2ef0ddc72fa317a649346474c377c58'
AND `ip_address` = '216.73.216.6' ?>
0.0592  
SELECT GET_LOCK('bb1b7757471890ffb286ed4be6fe8a5e', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f240a96dc2ef0ddc72fa317a649346474c377c58'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 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` = 20582
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` = 20582
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` = 20582
AND `MV`.`user_id` = 1
GROUP BY `MT`.`title_id` ?>
0.0018  
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` = 20582
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 10, 10 ?>
0.0003  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 20582 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)