Movielogr

Martin Compston

Movielogr users have logged 5 movies featuring Martin Compston.

Movies logged featuring Martin Compston
TitleDirector(s)Year Released
Disappearance of Alice Creed, TheJ Blakeson2009
Disappearance of Alice Creed, TheJ Blakeson2009
DoomsdayNeil Marshall2008
Guide to Recognizing Your Saints, ADito Montiel2006
Red RoadAndrea Arnold2006
  BENCHMARKS  
Loading Time: Base Classes  0.0030
Controller Execution Time ( Overview / Movies By Actor )  0.0117
Total Execution Time  0.0147
  GET DATA  
No GET data exists
  MEMORY USAGE  
503,088 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actor/16628
  CLASS/METHOD  
overview/movies_by_actor
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (0.0023 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c51fec9068050b6a84e69b2ecbf56aef0a66a461'
AND `ip_address` = '216.73.217.135' ?>
0.0002  
SELECT GET_LOCK('a370d95393b03a15c5b3e294ba021e3e', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c51fec9068050b6a84e69b2ecbf56aef0a66a461'
AND `ip_address` = '216.73.217.135' ?>
0.0005  
SELECT `actor_name`, `tmdb_actor_id`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 16628 ?>
0.0011  
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` = 16628
GROUP BY `title_id`
ORDER BY `title` ASC ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)