Movielogr

Home

Movies by Source

sensoria has logged 37 movies from the Library. Back to Sources by Popularity.

Movies logged from the Library
TitleDirector(s)Year ReleasedViewed On
Tokyo GodfathersSatoshi Kon, Shougo Furuya200305/14/2004
Black Swan, TheHenry King194205/30/2011
Wall Street: Money Never SleepsOliver Stone201001/14/2012
Norwegian NinjaThomas Cappelen Malling201002/17/2012
Protector, ThePrachya Pinkaew200503/06/2012
TremorsRon Underwood199003/10/2012
Your HighnessDavid Gordon Green201103/10/2012
Step Up 2: The StreetsJon M. Chu200804/28/2012
Perfect Getaway, ADavid Twohy200904/29/2012
Piranha 3DAlexandre Aja201004/29/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movies By Source )  0.0215
Total Execution Time  0.0233
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,584 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/7/date_viewed/asc
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0132 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a0a7af2d88a7306ee4ee6bb0effd77d6534cb77f'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('38a6d415a11213d328c146ff7deebe36', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a0a7af2d88a7306ee4ee6bb0effd77d6534cb77f'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0052  
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` = 7
GROUP BY `MT`.`title_id` ?>
0.0065  
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` = 7
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 10 ?>
0.0003  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 7
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)