GET http://nstats.rt-zen.pt/index.php/rounds-chatlog.php?id=68&serverid=1

Query Metrics

5 Database Queries
5 Different statements
1.53 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
0.54 ms
(35.23%)
1
SELECT stats_chat.PLAYERID, stats_chat.TextSaid FROM stats_chat WHERE stats_chat.ROUNDID=68 GROUP BY stats_chat.TextSaid ORDER BY stats_chat.ID
Parameters:
[]
0.29 ms
(18.96%)
1
SELECT * FROM stats_servers WHERE ID = ?
Parameters:
[
  1
]
0.26 ms
(16.89%)
1
SELECT name, value FROM stats_config
Parameters:
[]
0.26 ms
(16.78%)
1
SELECT GUID FROM stats_players_static WHERE stats_players_static.ISBANNED = 1
Parameters:
[]
0.19 ms
(12.14%)
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 (4279534630, 2378959285, 4279534630) AND stats_players_topalias.SERVERID = 1 GROUP BY stats_aliases.PLAYERID
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.