Movielogr

Home

Malcolm McDowell

noahphex has logged 10 out of 18 movies featuring Malcolm McDowell. Back to Actors by Popularity.

Movies logged featuring Malcolm McDowell
TitleDirector(s)Year ReleasedWatchedViewed On
BoltChris Williams, Byron Howard2008NoN/A
DelgoMarc F. Adler, Jason Maurer2008NoN/A
DoomsdayNeil Marshall2008NoN/A
In Good CompanyPaul Weitz2004NoN/A
Stanley Kubrick: A Life in PicturesJan Harlan2001Yes07/29/2012
Gangster No. 1Paul McGuigan2000NoN/A
Star Trek: GenerationsDavid Carson1994NoN/A
Clockwork Orange, AStanley Kubrick1971NoN/A
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Actor )  0.0133
Total Execution Time  0.0147
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,424 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/actor/56890/year/desc/10
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0069 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '0b2e36ad4f6b647e21bc8d411099322f49a64075'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('118dc536dc755604532c18d618e89d92', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '0b2e36ad4f6b647e21bc8d411099322f49a64075'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0030  
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` = 56890
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` = 56890
GROUP BY `MT`.`title_id` ?>
0.0006  
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` = 56890
AND `MV`.`user_id` = 8
GROUP BY `MT`.`title_id` ?>
0.0016  
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` = 56890
GROUP BY `MT`.`title_id`
ORDER BY `year` DESC
 LIMIT 10, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 56890 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)