Movielogr

Home

Movies by Source

sensoria has logged 140 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
Girl Who Kicked the Hornet's Nest, TheDaniel Alfredson200910/04/2011
ExtractMike Judge200910/28/2011
Ruins, TheCarter Smith200807/10/2011
Kung Fu PandaMark Osborne, John Stevenson200806/10/2011
Hellboy II: The Golden ArmyGuillermo del Toro200807/21/2011
Never Back DownJeff Wadlow200807/22/2011
Resident Evil: DegenerationMakoto Kamiya200812/27/2011
Contractor, TheJosef Rusnak200707/18/2011
Bourne Ultimatum, ThePaul Greengrass200712/23/2011
Lives of Others, TheFlorian Henckel von Donnersmarck200606/11/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0215
Total Execution Time  0.0230
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,960 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/200/year/desc/60
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0138 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '24d4b3ed9f87db68e2085d6c556d366aac9f603b'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('f3561d929bacd8d03f60d4183be977b0', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '24d4b3ed9f87db68e2085d6c556d366aac9f603b'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0069   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` = 1
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` 
0.0058   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` = 1
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `year` DESC
 LIMIT 60, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)