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
My Soul to TakeWes Craven201006/16/2011
My Sucky Teen RomanceEmily Hagins201109/14/2011
Mystics in BaliH. Tjut Djalil198111/05/2011
Myth of the American Sleepover, TheDavid Robert Mitchell201108/14/2011
Nail Gun Massacre, TheBill Leslie, Terry Lofton198509/20/2011
Naked VengeanceCirio H. Santiago198506/11/2011
National Lampoon's Van WilderWalt Becker200206/12/2011
Near DarkKathryn Bigelow198705/31/2011
Never Let Me GoMark Romanek201012/24/2010
Never Sleep Again: The Elm Street LegacyDaniel Farrands, Andrew Kasch201005/16/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movies By Source )  0.0268
Total Execution Time  0.0285
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,008 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/title/asc/360
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0193 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '7058fc22941f86b970202b7dd9403740faef84d8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c7a16348719c9481065e3591ae8acb4d', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '7058fc22941f86b970202b7dd9403740faef84d8'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 
0.0056   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.0125   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 `title` ASC
 LIMIT 360, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)