Movielogr

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.0018
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0171
Total Execution Time  0.0189
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,688 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.0091 seconds)  (Hide)
0.0007  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '459fad577c40bf3e0c15fadcadec9814ab43465e'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('eb8841d3b8a3c4a7f4720b7b7e8255c2', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '459fad577c40bf3e0c15fadcadec9814ab43465e'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0076  
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)