Movielogr

Home

Hours Watched By Day in December, 2011

Number of hours jenerator has logged in December, 2011, by day.

Hours watched in December, 2011 by day
DayDay of WeekHours Watched
03Saturday1 hr, 45 min
04Sunday1 hr, 54 min
 
05Monday3 hrs, 27 min
09Friday1 hr, 49 min
17Saturday7 hrs, 35 min
18Sunday4 hrs, 29 min
 
07Wednesday1 hr, 16 min
20Tuesday2 hrs, 13 min
21Wednesday1 hr, 25 min
22Thursday3 hrs, 20 min
23Friday12 hrs, 27 min
24Saturday6 hrs, 25 min
25Sunday8 hrs, 13 min
 
26Monday7 hrs, 46 min
27Tuesday1 hr, 22 min
28Wednesday1 hr, 51 min
29Thursday4 hrs, 16 min
30Friday3 hrs
31Saturday7 hrs, 8 min
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0124
Total Execution Time  0.0139
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,168 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/hours/2011/12
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0065 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '4a46ac2471699b1c509bd7ff654f2fcc10b47ea9'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('76b0d0423d6c8a7fbc68be753ec89409', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '4a46ac2471699b1c509bd7ff654f2fcc10b47ea9'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 
0.0054   SELECT DATE_FORMAT(date_viewed, "%d") AS day, SUM(MT.runtime) AS minutes_watched
FROM `ml_movies` `MV`
LEFT JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 61
AND YEAR(date_viewed) = 2011
AND MONTH(date_viewed) = 12
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)