Movielogr

Home

Hours Watched By Day in December, 2011

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

Hours watched in December, 2011 by day
DayDay of WeekHours Watched
10Saturday5 hrs, 40 min
01Thursday4 hrs, 16 min
02Friday1 hr, 51 min
03Saturday2 hrs, 52 min
04Sunday1 hr, 23 min
 
05Monday6 hrs, 10 min
06Tuesday4 hrs, 28 min
07Wednesday3 hrs, 7 min
08Thursday3 hrs, 25 min
09Friday3 hrs, 39 min
11Sunday2 hrs, 52 min
 
12Monday3 hrs, 40 min
13Tuesday5 hrs, 58 min
14Wednesday1 hr, 39 min
15Thursday5 hrs, 47 min
16Friday5 hrs, 56 min
17Saturday3 hrs, 39 min
18Sunday2 hrs, 24 min
 
19Monday2 hrs, 42 min
20Tuesday5 hrs
21Wednesday7 hrs, 6 min
22Thursday1 hr, 48 min
23Friday3 hrs, 52 min
25Sunday1 hr, 45 min
 
26Monday2 hrs, 18 min
27Tuesday4 hrs, 28 min
28Wednesday3 hrs, 8 min
29Thursday3 hrs, 8 min
30Friday4 hrs, 28 min
31Saturday3 hrs, 6 min
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0115
Total Execution Time  0.0130
  GET DATA  
No GET data exists
  MEMORY USAGE  
530,496 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/hours/2011/12
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0051 seconds)  (Hide)
0.0002   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'ccea5c3910f4bc4f89e7f0389eda9da4cc679b2b'
AND `ip_address` = '216.73.216.111' 
0.0001   SELECT GET_LOCK('9f304fa216d9b7dd8209bcdf9d5dd6ff', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ccea5c3910f4bc4f89e7f0389eda9da4cc679b2b'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0043   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` = 1
AND YEAR(date_viewed) = 2011
AND MONTH(date_viewed) = 12
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)