Movielogr

Home

Hours Watched By Day in April, 2011

Number of hours sensoria has logged in April, 2011, by day.

Hours watched in April, 2011 by day
DayDay of WeekHours Watched
01Friday1 hr, 42 min
02Saturday2 hrs, 42 min
03Sunday3 hrs, 44 min
 
04Monday1 hr, 39 min
05Tuesday2 hrs, 20 min
06Wednesday1 hr, 27 min
07Thursday3 hrs, 23 min
08Friday5 hrs, 21 min
09Saturday1 hr, 46 min
10Sunday1 hr, 34 min
 
11Monday2 hrs, 48 min
12Tuesday2 hrs, 58 min
16Saturday3 hrs, 34 min
17Sunday2 hrs, 58 min
 
19Tuesday2 hrs, 30 min
20Wednesday0 hr, 48 min
21Thursday3 hrs, 20 min
22Friday1 hr, 38 min
23Saturday3 hrs, 15 min
24Sunday2 hrs, 56 min
 
25Monday4 hrs, 25 min
26Tuesday3 hrs, 39 min
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0126
Total Execution Time  0.0140
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,528 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/hours/2011/04
  CLASS/METHOD  
members/hours_watched_by_year_month_days
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0063 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'ccea5c3910f4bc4f89e7f0389eda9da4cc679b2b'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('9f304fa216d9b7dd8209bcdf9d5dd6ff', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ccea5c3910f4bc4f89e7f0389eda9da4cc679b2b'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 
0.0050   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) = 2011
AND MONTH(date_viewed) = 4
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)