GET http://patch.altaria-online.pl/public/en/players

Query Metrics

45 Database Queries
3 Different statements
11.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.