Movielogr

Home

Movies by Source

sensoria has logged 113 movies at the Theater. Back to Sources by Popularity.

Movies logged at the Theater
TitleDirector(s)Year ReleasedViewed On
From Russia with LoveTerence Young196306/17/2012
Gammera the InvincibleNoriaki Yuasa, Sandy Howard196607/12/2012
Manos: The Hands of FateHarold P. Warren196608/16/2012
King Kong EscapesIshirô Honda196707/06/2007
Hour of the WolfIngmar Bergman196810/15/2011
Vampire Lovers, TheRoy Ward Baker197010/16/2011
Wizard of Gore, TheHerschell Gordon Lewis197010/15/2011
Abominable Dr. Phibes, TheRobert Fuest197110/15/2011
Wonder WomenRobert Vincent O'Neill197306/23/2012
Master of the Flying GuillotineJimmy Wang Yu197606/01/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Members / Movies By Source )  0.0298
Total Execution Time  0.0310
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,760 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/1/year/asc/10
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0145 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'e16c6d8b14fd70ff22ef9d70a7a883bcac74874b'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('04ad6f326ea7c1f9a113cd1b22d53c6d', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'e16c6d8b14fd70ff22ef9d70a7a883bcac74874b'
AND `ip_address` = '216.73.216.6' ?>
0.0008  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0058  
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` = 1
GROUP BY `MT`.`title_id` ?>
0.0067  
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` = 1
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10, 10 ?>
0.0002  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 1
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)