Movielogr

Home

Hours Watched By Day in April, 2010

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

Hours watched in April, 2010 by day
DayDay of WeekHours Watched
24Saturday5 hrs, 44 min
30Friday2 hrs, 10 min
25Sunday1 hr, 24 min
 
26Monday1 hr, 31 min
27Tuesday2 hrs, 4 min
23Friday2 hrs, 38 min
22Thursday1 hr, 46 min
21Wednesday1 hr, 31 min
20Tuesday1 hr, 31 min
16Friday3 hrs, 9 min
14Wednesday1 hr, 33 min
13Tuesday1 hr, 31 min
10Saturday5 hrs, 57 min
11Sunday3 hrs, 48 min
 
09Friday7 hrs, 26 min
08Thursday3 hrs, 19 min
06Tuesday1 hr, 35 min
04Sunday1 hr, 36 min
 
05Monday1 hr, 37 min
03Saturday4 hrs, 37 min
02Friday1 hr, 41 min
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0169
Total Execution Time  0.0186
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,016 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/hours/2010/04
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0096 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '837510686b3c750150e2c635f47c352261a99017'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3e4fd895fc02f6cc2863e44f9cf818dc', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '837510686b3c750150e2c635f47c352261a99017'
AND `ip_address` = '216.73.216.111' 
0.0012   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 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` = 8
AND YEAR(date_viewed) = 2010
AND MONTH(date_viewed) = 4
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)