Movielogr

Home

Hours Watched By Day in April, 2012

Number of hours sleestakk has logged in April, 2012, by day.

Hours watched in April, 2012 by day
DayDay of WeekHours Watched
09Monday1 hr, 35 min
08Sunday4 hrs, 12 min
 
07Saturday4 hrs, 53 min
06Friday2 hrs, 41 min
05Thursday2 hrs, 13 min
04Wednesday1 hr, 28 min
03Tuesday3 hrs, 28 min
10Tuesday1 hr, 36 min
11Wednesday1 hr, 34 min
12Thursday1 hr, 32 min
13Friday5 hrs, 19 min
14Saturday7 hrs, 21 min
15Sunday3 hrs, 23 min
 
16Monday1 hr, 42 min
17Tuesday2 hrs, 31 min
18Wednesday3 hrs, 49 min
19Thursday1 hr, 33 min
20Friday3 hrs, 7 min
21Saturday4 hrs, 38 min
22Sunday1 hr, 30 min
 
23Monday3 hrs, 2 min
24Tuesday1 hr, 20 min
30Monday1 hr, 34 min
29Sunday4 hrs, 31 min
 
25Wednesday2 hrs, 17 min
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0146
Total Execution Time  0.0161
  GET DATA  
No GET data exists
  MEMORY USAGE  
528,144 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/hours/2012/04
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0088 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '49f3868e7cef3641951f7c8c13c61c559afffff5'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3b6d2e3e708309f7a8f1dea7daa172c1', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '49f3868e7cef3641951f7c8c13c61c559afffff5'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0078   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` = 9
AND YEAR(date_viewed) = 2012
AND MONTH(date_viewed) = 4
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)