Movielogr

Home

Movies seen in February, 2012

sensoria has logged 29 movies in February, 2012. Back to Movies seen in 2012

Movies logged in February, 2012
TitleDirector(s)Year ReleasedViewed On
ChronicleJosh Trank201202/12/2012
Innkeepers, TheTi West201102/03/2012
In TimeAndrew Niccol201102/04/2012
BlackthornMateo Gil201102/02/2012
BellflowerEvan Glodell201102/09/2012
Take ShelterJeff Nichols201102/19/2012
Rum Diary, TheBruce Robinson201102/23/2012
BellflowerEvan Glodell201102/25/2012
Tinker Tailor Soldier SpyTomas Alfredson201102/26/2012
Tucker and Dale vs. EvilEli Craig201002/11/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0108
Controller Execution Time ( Members / Movies Seen By Month )  0.0465
Total Execution Time  0.0628
  GET DATA  
No GET data exists
  MEMORY USAGE  
812,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/stats/2012/02/year/desc
  CLASS/METHOD  
members/movies_seen_by_month
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0096 seconds)  (Hide)
0.0002   SELECT GET_LOCK('fd6c5ca95b017b99bd94a489deaf0abc', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8ef1d7576a666e3c076eec23e4f80c7341b454d6'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0050   SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 1
AND YEAR(MV.date_viewed) = 2012
AND MONTH(MV.date_viewed) = 2
GROUP BY `MV`.`movie_id` 
0.0037   SELECT `MV`.`movie_id`, `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `date_viewed`, `date_created`, 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_movies` `MV`
JOIN `ml_movie_titles` `MT` 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 YEAR(MV.date_viewed) = 2012
AND MONTH(MV.date_viewed) = 2
GROUP BY `MV`.`movie_id`
ORDER BY `year` DESC, `date_created` ASC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)