Movielogr

Home

Hours Watched By Day in May, 2011

Number of hours noahphex has logged in May, 2011, by day.

Hours watched in May, 2011 by day
DayDay of WeekHours Watched
10Tuesday5 hrs, 6 min
21Saturday7 hrs, 32 min
31Tuesday7 hrs, 51 min
08Sunday3 hrs, 30 min
 
14Saturday4 hrs, 53 min
15Sunday4 hrs, 41 min
 
16Monday5 hrs, 8 min
18Wednesday1 hr, 36 min
20Friday3 hrs, 26 min
01Sunday10 hrs, 17 min
 
04Wednesday1 hr, 22 min
07Saturday5 hrs, 39 min
  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Members / Hours Watched By Year Month Days )  0.0162
Total Execution Time  0.0179
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/hours/2011/05
  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` = '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.0086   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) = 2011
AND MONTH(date_viewed) = 5
GROUP BY `day` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)