GET http://patch.altaria-online.pl/public/en/checkServer?variant=line

Query Metrics

30 Database Queries
3 Different statements
7.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
6.30 ms
(82.75%)
28
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
(10.07%)
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
(7.19%)
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.