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
Rite, TheMikael Håfström201109/02/2011
Season of the WitchDominic Sena201107/28/2011
Quarantine 2: TerminalJohn Pogue201110/14/2011
30 Minutes or LessRuben Fleischer201112/04/2011
WarriorGavin O'Connor201101/06/2012
Meek's CutoffKelly Reichardt201111/17/2011
PriestScott Stewart201109/02/2011
BridesmaidsPaul Feig201111/07/2011
Cedar RapidsMiguel Arteta201112/09/2011
LimitlessNeil Burger201109/17/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0021
Controller Execution Time ( Members / Movies By Source )  0.0224
Total Execution Time  0.0245
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,432 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/200/year/desc
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0137 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'eb17dc46e4a292f5bec275b5af53fa5bef8b7c33'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT GET_LOCK('851c56825b853863f4641eb582bea5f6', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'eb17dc46e4a292f5bec275b5af53fa5bef8b7c33'
AND `ip_address` = '216.73.216.6' ?>
0.0012  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 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` = 1
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` ?>
0.0055  
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 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)