Movielogr

Hours Watched By Day in August, 2010

Number of hours noahphex has logged in August, 2010, by day.

Hours watched in August, 2010 by day
DayDay of WeekHours Watched
21Saturday4 hrs, 36 min
07Saturday6 hrs, 9 min
27Friday1 hr, 29 min
31Tuesday1 hr, 24 min
20Friday1 hr, 5 min
28Saturday5 hrs, 10 min
29Sunday1 hr, 53 min
 
23Monday1 hr, 36 min
22Sunday1 hr, 47 min
 
15Sunday1 hr, 51 min
 
26Thursday1 hr, 27 min
25Wednesday1 hr, 46 min
24Tuesday1 hr, 36 min
09Monday5 hrs, 51 min
14Saturday5 hrs, 15 min
04Wednesday1 hr, 25 min
11Wednesday1 hr, 25 min
08Sunday4 hrs, 16 min
 
10Tuesday1 hr, 24 min
18Wednesday1 hr, 28 min
17Tuesday1 hr, 33 min
19Thursday1 hr, 27 min
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0139
Total Execution Time  0.0152
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,496 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/hours/2010/08
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0075 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '9cb92c29865f9242375f8fe6211caee3cf457cb6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('d894a3c04d3d2f253734d040c138e2b1'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9cb92c29865f9242375f8fe6211caee3cf457cb6'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 
LIMIT 1 
0.0065   SELECT DATE_FORMAT(date_viewed"%d") AS daySUM(MT.runtime) AS minutes_watched
FROM 
`ml_movies` `MV`
LEFT JOIN `ml_movie_titles` `MTON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND YEAR(date_viewed) = 2010
AND MONTH(date_viewed) = 8
GROUP BY 
`day
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)