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.0016
Controller Execution Time ( Members / Movies Seen By Year Months )  0.0099
Total Execution Time  0.0115
  GET DATA  
No GET data exists
  MEMORY USAGE  
505,720 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.0031 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '15e002aeab5153902fbc68ad57989a4494f5c8f3'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('e62b9f2b1b818e898e03b5701ae81e40', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '15e002aeab5153902fbc68ad57989a4494f5c8f3'
AND `ip_address` = '216.73.216.6' ?>
0.0016  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'testguy'
 LIMIT 1 ?>
0.0006  
SELECT DATE_FORMAT(date_viewed, "%m") AS month, COUNT(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)