Movielogr

Home

Movies by Source

sensoria has logged 34 movies that were Owned. Back to Sources by Popularity.

Movies logged that were Owned
TitleDirector(s)Year ReleasedViewed On
Fistful of Dollars, ASergio Leone196405/27/2011
Power, TheByron Haskin196807/07/2012
BullittPeter Yates196809/19/2012
No Blade of GrassCornel Wilde197007/08/2012
Shining, TheStanley Kubrick198009/07/2012
Blade RunnerRidley Scott198204/12/2015
HeatMichael Mann199505/07/2012
Gamera: Guardian of the UniverseShusuke Kaneko199503/31/2012
TrainspottingDanny Boyle199606/09/2013
RoninJohn Frankenheimer199812/08/2013
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Source )  0.0202
Total Execution Time  0.0216
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,264 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/4/year/asc
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0140 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'adedc2e9b3d89fe813bace7c20338cd40e9ea697'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('b590e63bbeb0c473057ea51238551339', 300) AS ci_session_lock ?>
0.0015  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'adedc2e9b3d89fe813bace7c20338cd40e9ea697'
AND `ip_address` = '216.73.216.6' ?>
0.0013  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0053  
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` = 4
GROUP BY `MT`.`title_id` ?>
0.0051  
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` = 4
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10 ?>
0.0002  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 4
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)