Movielogr

Home

Movies by Source

jenerator has logged 594 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
MacheteRobert Rodriguez, Ethan Maniquis201009/02/2010
Losers, TheSylvain White201009/02/2010
Resident Evil: AfterlifePaul W.S. Anderson201009/01/2010
Birds, TheAlfred Hitchcock196308/08/2010
CatfishHenry Joost, Ariel Schulman201008/06/2010
Cop OutKevin Smith201008/02/2010
Ruins, TheCarter Smith200807/24/2010
Bourne Supremacy, ThePaul Greengrass200407/19/2010
Book of Eli, TheAlbert Hughes, Allen Hughes201007/18/2010
Prophecy 3: The Ascent, ThePatrick Lussier200007/18/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0415
Total Execution Time  0.0430
  GET DATA  
No GET data exists
  MEMORY USAGE  
538,216 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/date_viewed/desc/510
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0329 seconds)  (Hide)
0.0002   SELECT GET_LOCK('d0d216ef4c489a4f542e10c48abcaec8', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cd63fc250158bd2d018d15bc655fe3a5b1310f06'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 
0.0088   SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 61
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` 
0.0233   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_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`
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 `MV`.`user_id` = 61
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` DESC
 LIMIT 510, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)