Movielogr

Home

Movies seen in June, 2009

sleestakk has logged 27 movies in June, 2009. Back to Movies seen in 2009

Movies logged in June, 2009
TitleDirector(s)Year ReleasedViewed On
UpPete Docter200906/05/2009
Land of the LostBrad Silberling200906/06/2009
Laid to RestRobert Hall200906/06/2009
Red SonjaRichard Fleischer198506/07/2009
OutlandPeter Hyams198106/07/2009
Fist of LegendGordon Chan199406/07/2009
Hound of the Baskervilles, TheTerence Fisher195906/08/2009
MoonbasePaolo Mazzucato199706/08/2009
BadlandersArmand Gazarian199206/10/2009
Star Trek Into DarknessJ.J. Abrams201306/11/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0022
Controller Execution Time ( Members / Movies Seen By Month )  0.0488
Total Execution Time  0.0510
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,768 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/stats/2009/06
  CLASS/METHOD  
members/movies_seen_by_month
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0324 seconds)  (Hide)
0.0009  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '71f3800374fd1d0724688224222a4f9fd3787ac3'
AND `ip_address` = '216.73.216.6' ?>
0.0179  
SELECT GET_LOCK('90d49b45466c73c647c0fa755fdd3959', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '71f3800374fd1d0724688224222a4f9fd3787ac3'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0075  
SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND YEAR(MV.date_viewed) = 2009
AND MONTH(MV.date_viewed) = 6
GROUP BY `MV`.`movie_id` ?>
0.0053  
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` = 9
AND YEAR(MV.date_viewed) = 2009
AND MONTH(MV.date_viewed) = 6
GROUP BY `MV`.`movie_id`
ORDER BY `date_viewed` ASC, `date_created` ASC
 LIMIT 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)