0.42 ms (13.46%)
1
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT , stats_consolidated . VALUE_TXT , stats_consolidated . DescriptionID , stats_language_strings . TEXT as Description FROM stats_consolidated LEFT OUTER JOIN (stats_language_strings ) ON (stats_language_strings . STRINGID = stats_consolidated . DescriptionID ) WHERE stats_consolidated . NAME LIKE 'global_%' AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT , stats_consolidated . VALUE_TXT , stats_consolidated . DescriptionID , stats_language_strings . TEXT as Description FROM stats_consolidated LEFT OUTER JOIN (stats_language_strings ) ON (stats_language_strings . STRINGID = stats_consolidated . DescriptionID ) WHERE stats_consolidated . NAME LIKE 'global_%' AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID ;
Copy
0.31 ms (9.88%)
1
SELECT stats_players . GUID , sum (stats_players . Kills ) as Kills , sum (stats_players . Deaths ) as Deaths , sum (stats_players . Teamkills ) as Teamkills , sum (stats_players . Suicides ) as Suicides , sum (stats_players . Kills ) / sum (stats_players . Deaths ) as KillRatio FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY Suicides DESC LIMIT 0 , 50
SELECT stats_players . GUID , sum (stats_players . Kills ) as Kills , sum (stats_players . Deaths ) as Deaths , sum (stats_players . Teamkills ) as Teamkills , sum (stats_players . Suicides ) as Suicides , sum (stats_players . Kills ) / sum (stats_players . Deaths ) as KillRatio FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY Suicides DESC LIMIT 0 , 50 ;
Copy
0.29 ms (9.08%)
1
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY GUID ORDER BY Suicides DESC ) AS cnt_sub
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY GUID ORDER BY Suicides DESC ) AS cnt_sub ;
Copy
0.29 ms (9.07%)
1
SELECT * FROM stats_servers WHERE ID = ?
SELECT * FROM stats_servers WHERE ID = 1 ;
Copy
0.26 ms (8.28%)
1
SELECT name , value FROM stats_config
SELECT name , value FROM stats_config ;
Copy
0.25 ms (7.90%)
1
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (4108050209 , 1420733202 , 2378959285 , 4184764196 , 516204237 , 1411893074 , 2601224506 , 4279534630 , 1008427758 , 1086709141 , 2079358852 , 24882786 , 682876912 , 3369242101 , 4293707123 ) GROUP BY stats_time . PLAYERID
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (4108050209 , 1420733202 , 2378959285 , 4184764196 , 516204237 , 1411893074 , 2601224506 , 4279534630 , 1008427758 , 1086709141 , 2079358852 , 24882786 , 682876912 , 3369242101 , 4293707123 ) GROUP BY stats_time . PLAYERID ;
Copy
0.24 ms (7.73%)
1
SELECT GUID FROM stats_players_static WHERE stats_players_static . ISBANNED = 1
SELECT GUID FROM stats_players_static WHERE stats_players_static . ISBANNED = 1 ;
Copy
0.22 ms (6.91%)
1
SELECT stats_weapons . ID as WEAPONID , stats_weapons . INGAMENAME , stats_weapons . DisplayName as WeaponDisplayName , stats_weapons . WeaponType FROM stats_weapons INNER JOIN (stats_weapons_perserver ) ON (stats_weapons . ID = stats_weapons_perserver . WEAPONID ) WHERE stats_weapons_perserver . SERVERID = 1 GROUP BY stats_weapons . ID ORDER BY stats_weapons . WeaponType , stats_weapons . INGAMENAME
SELECT stats_weapons . ID as WEAPONID , stats_weapons . INGAMENAME , stats_weapons . DisplayName as WeaponDisplayName , stats_weapons . WeaponType FROM stats_weapons INNER JOIN (stats_weapons_perserver ) ON (stats_weapons . ID = stats_weapons_perserver . WEAPONID ) WHERE stats_weapons_perserver . SERVERID = 1 GROUP BY stats_weapons . ID ORDER BY stats_weapons . WeaponType , stats_weapons . INGAMENAME ;
Copy
0.21 ms (6.54%)
1
SELECT stats_aliases . PLAYERID , stats_aliases . Alias , stats_aliases . AliasAsHtml FROM stats_aliases LEFT OUTER JOIN (stats_players_topalias ) ON (stats_aliases . ID = stats_players_topalias . ALIASID ) WHERE stats_players_topalias . GUID IN (4108050209 , 1420733202 , 2378959285 , 4184764196 , 516204237 , 1411893074 , 2601224506 , 4279534630 , 1008427758 , 1086709141 , 2079358852 , 24882786 , 682876912 , 3369242101 , 4293707123 ) AND stats_players_topalias . SERVERID = 1 GROUP BY stats_aliases . PLAYERID
SELECT stats_aliases . PLAYERID , stats_aliases . Alias , stats_aliases . AliasAsHtml FROM stats_aliases LEFT OUTER JOIN (stats_players_topalias ) ON (stats_aliases . ID = stats_players_topalias . ALIASID ) WHERE stats_players_topalias . GUID IN (4108050209 , 1420733202 , 2378959285 , 4184764196 , 516204237 , 1411893074 , 2601224506 , 4279534630 , 1008427758 , 1086709141 , 2079358852 , 24882786 , 682876912 , 3369242101 , 4293707123 ) AND stats_players_topalias . SERVERID = 1 GROUP BY stats_aliases . PLAYERID ;
Copy
0.19 ms (5.99%)
1
SELECT DISTINCT stats_time . Time_Year , stats_time . Time_Month FROM stats_time ORDER BY stats_time . Time_Year DESC , stats_time . Time_Month DESC
SELECT DISTINCT stats_time . Time_Year , stats_time . Time_Month FROM stats_time ORDER BY stats_time . Time_Year DESC , stats_time . Time_Month DESC ;
Copy
0.12 ms (3.76%)
1
SELECT sum (stats_players . Kills ) / sum (stats_players . Deaths ) as MaxKillRatio FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY MaxKillRatio DESC LIMIT 1
SELECT sum (stats_players . Kills ) / sum (stats_players . Deaths ) as MaxKillRatio FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY MaxKillRatio DESC LIMIT 1 ;
Copy
0.11 ms (3.57%)
1
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT FROM stats_consolidated WHERE stats_consolidated . NAME LIKE 'server_total%' AND stats_consolidated . SERVERID = 1 AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT FROM stats_consolidated WHERE stats_consolidated . NAME LIKE 'server_total%' AND stats_consolidated . SERVERID = 1 AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID ;
Copy
0.09 ms (2.78%)
1
SELECT stats_gametypes . ID as GAMETYPEID , stats_gametypes . NAME , stats_gametypes . DisplayName as GameTypeDisplayName FROM stats_gametypes ORDER BY stats_gametypes . NAME
SELECT stats_gametypes . ID as GAMETYPEID , stats_gametypes . NAME , stats_gametypes . DisplayName as GameTypeDisplayName FROM stats_gametypes ORDER BY stats_gametypes . NAME ;
Copy
0.08 ms (2.56%)
1
SELECT stats_damagetypes . DAMAGETYPE , stats_damagetypes . DisplayName FROM stats_damagetypes ORDER BY stats_damagetypes . DisplayName , stats_damagetypes . DAMAGETYPE
SELECT stats_damagetypes . DAMAGETYPE , stats_damagetypes . DisplayName FROM stats_damagetypes ORDER BY stats_damagetypes . DisplayName , stats_damagetypes . DAMAGETYPE ;
Copy
0.08 ms (2.49%)
1
SELECT ID , Name FROM stats_servers ORDER BY ID
SELECT ID , Name FROM stats_servers ORDER BY ID ;
Copy