Movielogr

Home

Movies seen in June, 2013

sensoria has logged 10 movies in June, 2013. Back to Movies seen in 2013

Movies logged in June, 2013
TitleDirector(s)Year ReleasedViewed On
TrainspottingDanny Boyle199606/09/2013
Star Trek Into DarknessJ.J. Abrams201306/08/2013
Star Trek Into DarknessJ.J. Abrams201306/08/2013
Star Trek Into DarknessJ.J. Abrams201306/08/2013
Star Trek Into DarknessJ.J. Abrams201306/08/2013
Star Trek Into DarknessJ.J. Abrams201306/09/2013
LionheartSheldon Lettich199006/08/2013
Kill ListBen Wheatley201106/08/2013
Kill ListBen Wheatley201106/08/2013
Cloud AtlasTom Tykwer, Lilly Wachowski, Lana Wachowski201206/09/2013
  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Members / Movies Seen By Month )  0.0176
Total Execution Time  0.0195
  GET DATA  
No GET data exists
  MEMORY USAGE  
528,488 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/stats/2013/06/title/desc
  CLASS/METHOD  
members/movies_seen_by_month
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0096 seconds)  (Hide)
0.0002   SELECT GET_LOCK('cfc6d7ddd4022f7259b6e5a5e96851b6', 300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '58b3b23b9e500ca673c388026dc8fc13bbd15709'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0049   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) = 2013
AND MONTH(MV.date_viewed) = 6
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) = 2013
AND MONTH(MV.date_viewed) = 6
GROUP BY `MV`.`movie_id`
ORDER BY `title` DESC, `date_created` ASC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)