Movielogr

Home

Hours Watched By Day in August, 2012

Number of hours sensoria has logged in August, 2012, by day.

Hours watched in August, 2012 by day
DayDay of WeekHours Watched
07Tuesday1 hr, 33 min
08Wednesday2 hrs, 58 min
09Thursday1 hr, 38 min
10Friday1 hr, 15 min
11Saturday7 hrs, 34 min
13Monday4 hrs, 32 min
14Tuesday3 hrs, 21 min
15Wednesday3 hrs, 54 min
16Thursday1 hr, 10 min
17Friday1 hr, 25 min
18Saturday4 hrs
19Sunday3 hrs, 25 min
 
20Monday1 hr, 48 min
21Tuesday1 hr, 41 min
22Wednesday3 hrs, 48 min
23Thursday1 hr, 31 min
24Friday3 hrs, 59 min
25Saturday1 hr, 30 min
26Sunday3 hrs, 11 min
 
27Monday3 hrs, 19 min
28Tuesday1 hr, 47 min
29Wednesday1 hr, 28 min
30Thursday2 hrs, 38 min
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0122
Total Execution Time  0.0135
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,976 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/hours/2012/08
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0056 seconds)  (Hide)
0.0005   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3cc31f141da0a31671d6d37841b3dde6a5a227d7'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('a3b072a9fc65a06fd0e61b7cb2b0a183', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3cc31f141da0a31671d6d37841b3dde6a5a227d7'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0045   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) = 2012
AND MONTH(date_viewed) = 8
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)