Movielogr

Movies seen in 2008

Number of movies suspectk has logged in 2008, by month.

Movies in 2008 by month
MonthNumber of movies seen
November2
August2
June1
July1
February1
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies Seen By Year Months )  0.0133
Total Execution Time  0.0150
  GET DATA  
No GET data exists
  MEMORY USAGE  
504,800 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/suspectk/stats/overview/2008
  CLASS/METHOD  
members/movies_seen_by_year_months
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0042 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9a6fc00c3848776cf4f5fe92d867e91bd1a279ad'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('aff8cebd79619964e8ef7ba6628c8a15', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9a6fc00c3848776cf4f5fe92d867e91bd1a279ad'
AND `ip_address` = '216.73.216.6' ?>
0.0017  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'suspectk'
 LIMIT 1 ?>
0.0017  
SELECT DATE_FORMAT(date_viewed, "%m") AS month, COUNT(date_viewed) AS total
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 68
AND YEAR(date_viewed) = 2008
GROUP BY `month` ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)