Movielogr

Movies by Source

noahphex has logged 123 movies that were Borrowed. Back to Sources by Popularity.

Movies logged that were Borrowed
TitleDirector(s)Year ReleasedViewed On
Night of the DemonJames C. Wasson198004/20/2011
Blue MonkeyWilliam Fruet198702/09/2011
IcedJeff Kwitny198802/03/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Source )  0.0223
Total Execution Time  0.0238
  GET DATA  
No GET data exists
  MEMORY USAGE  
522,272 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/6/date_viewed/desc/120
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0153 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'e990bd8e02051542d5b51afb5abb743387f72505'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('4ab23c4b5d34cce0e348c88566e2aa3f'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'e990bd8e02051542d5b51afb5abb743387f72505'
AND `ip_address` = '216.73.216.137' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 
LIMIT 1 
0.0071   SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MVON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND `MV`.`source_id` = 6
GROUP BY 
`MT`.`title_id
0.0069   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_idGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_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` `MVON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
WHERE `MV`.`user_id` = 8
AND `MV`.`source_id` = 6
GROUP BY 
`MT`.`title_id`
ORDER BY `date_viewedDESC
 LIMIT 120
10 
0.0002   SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 6
 LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)