Movielogr

Movies seen in 2010

Number of movies testguy has logged in 2010, by month.

Movies in 2010 by month
MonthNumber of movies seen
February2
March3
April2
May6
June2
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies Seen By Year Months )  0.0080
Total Execution Time  0.0094
  GET DATA  
No GET data exists
  MEMORY USAGE  
508,744 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/testguy/stats/overview/2010
  CLASS/METHOD  
members/movies_seen_by_year_months
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0017 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '4c575e268191d6ac8d9809da79c615d0006759d8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('e2bf5be13907f411235db9e3903c38b0'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '4c575e268191d6ac8d9809da79c615d0006759d8'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'testguy'
 
LIMIT 1 
0.0006   SELECT DATE_FORMAT(date_viewed"%m") AS monthCOUNT(date_viewed) AS total
FROM 
`ml_movies` `MV`
WHERE `MV`.`user_id` = 89
AND YEAR(date_viewed) = 2010
GROUP BY 
`month
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)