Recent Top Users

 
 
 
 
  BENCHMARKS  
Loading Time: Base Classes  0.0024
Controller Execution Time ( User / Top Users )  0.0336
Total Execution Time  0.0365
  GET DATA  
No GET data exists
  MEMORY USAGE  
783,320 bytes
  POST DATA  
No POST data exists
  URI STRING  
user/top_users
  CLASS/METHOD  
user/top_users
  DATABASE:  killthez_db (User:$db)   QUERIES: 3 (0.0231 seconds)  (Hide)
0.0172   SELECT `plays`.`user_id`, `username`, count(*) total_plays
FROM 
`plays`
JOIN `usersON `plays`.`user_id` = `users`.`id`
WHERE `plays`.`created` > date_sub(current_timestampinterval 1 month)
GROUP BY `plays`.`user_id`, `username`
ORDER BY `total_playsDESC
 LIMIT 5 
0.0058   SELECT `plays`.`user_id`, `username`, count(*) total_plays
FROM 
`plays`
JOIN `usersON `plays`.`user_id` = `users`.`id`
WHERE `plays`.`created` > date_sub(current_timestampinterval 1 month)
GROUP BY `plays`.`user_id`, `username`
ORDER BY `total_playsDESC
 LIMIT 20 
0.0001   SELECT `users_groups`.`group_id` as `id`, `groups`.`name`, `groups`.`description`
FROM `users_groups`
JOIN `groupsON `users_groups`.`group_id`=`groups`.`id`
WHERE `users_groups`.`user_idIS NULL 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)