Movielogr

Home

Movies seen in June, 2012

noahphex has logged 38 movies in June, 2012. Back to Movies seen in 2012

Movies logged in June, 2012
TitleDirector(s)Year ReleasedViewed On
Man Who Shot Liberty Valance, TheJohn Ford196206/15/2012
Manchurian Candidate, TheJohn Frankenheimer196206/15/2012
Chitty Chitty Bang BangKen Hughes196806/30/2012
Daughters of SatanHollingsworth Morse197206/23/2012
CabaretBob Fosse197206/26/2012
Sword and the Sorcerer, TheAlbert Pyun198206/24/2012
White FireJean-Marie Pallardy198406/23/2012
Boys Next Door, ThePenelope Spheeris198606/23/2012
Salvation!Beth B198706/23/2012
Winners Take AllFritz Kiersch198706/29/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies Seen By Month )  0.0374
Total Execution Time  0.0389
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,168 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/stats/2012/06/year/asc
  CLASS/METHOD  
members/movies_seen_by_month
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0289 seconds)  (Hide)
0.0041  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'dc148c7871183a988c06160f4b9623031cbef960'
AND `ip_address` = '216.73.216.6' ?>
0.0009  
SELECT GET_LOCK('ed4b5a1ac416c0499a80c830ee2af965', 300) AS ci_session_lock ?>
0.0025  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'dc148c7871183a988c06160f4b9623031cbef960'
AND `ip_address` = '216.73.216.6' ?>
0.0077  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0074  
SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND YEAR(MV.date_viewed) = 2012
AND MONTH(MV.date_viewed) = 6
GROUP BY `MV`.`movie_id` ?>
0.0063  
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` = 8
AND YEAR(MV.date_viewed) = 2012
AND MONTH(MV.date_viewed) = 6
GROUP BY `MV`.`movie_id`
ORDER BY `year` ASC, `date_created` ASC
 LIMIT 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)