Query Metrics
45
Database Queries
3
Different statements
11.34 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
10.03 ms (88.42%) |
43 |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_token"
]
|
|
0.77 ms (6.75%) |
1 |
SELECT p.name, p.level, COALESCE(g.name, 'Brak gildii') AS guild_name FROM playerdata.players p LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId WHERE p.level >= 1 AND p.name != 'Admin' ORDER BY p.level DESC, p.exp DESC, p.name ASC LIMIT 10
Parameters:
[] |
|
0.55 ms (4.82%) |
1 |
SELECT p.name, p.level, p.exp, p.id as user, COALESCE(g.name, 'Brak gildii') as guild_name FROM playerdata.players p LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId WHERE p.level >= 1 AND p.name != 'Admin' ORDER BY p.level DESC, p.exp DESC, p.name ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| flarum | doctrine.dbal.flarum_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\CmsSettings | No errors. |