Global
Rank Player Score Country
1 Dhb 351 US
2 228 US
3 Stargirl1052 207 US
4 Stargirl1052 206 US
5 Stargirl1052 204 US
6 Stargirl1052 195 US
7 Dhb 191 US
8 Dhb 172 US
9 Dhb 172 US
10 Dhb 165 US
Tadow! Enabled
  URI STRING  
/accessible/leaderboard/76/Global
  CLASS/METHOD  
accessible/leaderboard
  MEMORY USAGE  
1,814,740 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0057
Controller Execution Time ( Accessible / Leaderboard )  6.9769
Total Execution Time  6.9827
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  tadow_production   QUERIES: 7   
0.0007   SELECT *
FROM (`sessions`)
WHERE `session_id` = 'd23097cf8ec283668b08afe27e8d00c1'
AND `user_agent` = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
0.0006   UPDATE `sessionsSET `last_activity` = 1280438505, `session_id` = 'c9e72d22419deb2210ebd1d1f365f3b2' WHERE session_id 'd23097cf8ec283668b08afe27e8d00c1' 
0.0043   DELETE FROM `sessions`
WHERE `last_activity` < 1280431305 
0.0530  
                select
                    games
.game_id GameID,
                    
games.game_description GameDescription,
                    
games.game_name GameName,
                    
games.game_image GameImage,
                    
games.game_image_small GameImageSmall,
                    
games.game_link GameLink,
                    
games.application_key ApplicationKey,
                    
games.application_secret ApplicationSecret,
                    
developers.publisher_name PublisherName
                from
                    games
                    inner join developers on developers
.user_id games.publisher_user_id
                where
                    1 
1
            
                    
and games.game_id 76 
0.0537  
                select
                    leaderboard_id LeaderboardId
,
                    
leaderboards.leaderboard_title LeaderboardTitle
                from
                    leaderboards
                where
                    leaderboard_key 
'Global'
            
                    
and leaderboards.game_id 76 
0.0007  
                select
                    leaderboard_id
,
                    
leaderboards.score_criteria,
                    
show_top,
                    
format_prefix,
                    
format_thousands,
                    
format_decimal,
                    
format_precision,
                    
format_suffix
                from
                    leaderboards
                    inner join games on games
.game_id leaderboards.game_id
                where
                    leaderboard_key 
'Global' and
                    
games.game_id 76
             
6.7086  
                    select
                        users
.user_id UserID,
                        
users.username Username,
                        
users.birth_date BirthDate,
                        
users.email_address EmailAddress,
                        
users.gender_id GenderID,
                        
users.country_id CountryID,
                        
users.postal_code PostalCode,
                        
users.unique_identifier UniqueIdentifier,
                        
users.last_login LastLogin,
                        
users.last_action LastAction,
                        
users.last_game_id LastGameID,
                        
users.is_online IsOnline,
                        
profiles.website Website,
                        
profiles.about_text AboutText,
                        
profiles.avatar_image AvatarImage,
                        
profiles.avatar_image_small AvatarImageSmall,
                        
profiles.avatar_image_small AvatarImageTiny,
                        
profiles.display_age DisplayAge,
                        
profiles.display_gender DisplayGender,
                        
profiles.location Location,
                        
games.game_id GameID,
                        
games.game_name GameName,
                        
games.game_image GameImage,
                        
games.game_image_small GameImageSmall,
                        
games.publisher_name PublisherName,
                        
games.publisher_user_id PublisherID,
                        
games.game_link GameLink,
                        
scores.score Score,
                        
scores.score_date ScoreDate
                    from
                        scores
                        inner join users on scores
.user_id users.user_id
                        inner join games on scores
.game_id games.game_id
                        left outer join profiles on users
.user_id profiles.user_id
                    where
                        games
.game_id 76 and
                        
scores.leaderboard_id 80 and
                        
scores.identifier_tag ''
                    
order by
                        scores
.score desc,
                        
scores.score_date desc
                    limit 0
10