Movielogr

Home

Movies by Source

sensoria has logged 82 movies that were Rented. Back to Sources by Popularity.

Movies logged that were Rented
TitleDirector(s)Year ReleasedViewed On
Martha Marcy May MarleneSean Durkin201103/31/2012
Project NimJames Marsh201108/26/2012
Skin I Live In, ThePedro Almodóvar201103/31/2012
MoneyballBennett Miller201103/05/2012
HaywireSteven Soderbergh201108/07/2012
Hangover Part II, TheTodd Phillips201101/19/2012
Shark Night 3DDavid R. Ellis201103/31/2012
Killer EliteGary McKendry201103/18/2012
Thing, TheMatthijs van Heijningen Jr.201103/17/2012
Dangerous Method, ADavid Cronenberg201105/12/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Source )  0.0209
Total Execution Time  0.0223
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,944 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/5/year/asc/50
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0138 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '71411aaaf477726d307675019f1c3ea4a886a825'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('c407558473bbed94fd37cfe2aa11b702', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '71411aaaf477726d307675019f1c3ea4a886a825'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0067  
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` = 5
GROUP BY `MT`.`title_id` ?>
0.0057  
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` = 5
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 50, 10 ?>
0.0003  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 5
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)