Movielogr

Simon Jones

Movielogr users have logged 5 movies featuring Simon Jones.

Movies logged featuring Simon Jones
TitleDirector(s)Year Released
BrazilTerry Gilliam1985
Devil's Own, TheAlan J. Pakula1997
Hitchhiker's Guide to the Galaxy, TheGarth Jennings2005
Thomas Crown Affair, TheJohn McTiernan1999
Twelve MonkeysTerry Gilliam1995
  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Overview / Movies By Actor )  0.0118
Total Execution Time  0.0138
  GET DATA  
No GET data exists
  MEMORY USAGE  
503,072 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actor/37891
  CLASS/METHOD  
overview/movies_by_actor
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (0.0037 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '26a9cc33fc3f5c41b6bef7aacd8a10e825e2327e'
AND `ip_address` = '216.73.216.145' ?>
0.0002  
SELECT GET_LOCK('974082b161d5ad6f5a3ce8c37a8e7112', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '26a9cc33fc3f5c41b6bef7aacd8a10e825e2327e'
AND `ip_address` = '216.73.216.145' ?>
0.0008  
SELECT `actor_name`, `tmdb_actor_id`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 37891 ?>
0.0023  
SELECT `MV`.`title_id`, `title`, `prefix`, `year`, 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_movies` `MV`
LEFT JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
LEFT 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` = 37891
GROUP BY `title_id`
ORDER BY `title` ASC ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)