GET https://playmagicsoldier.com/en/players

Query Metrics

341 Database Queries
3 Different statements
186.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
182.01 ms
(97.70%)
339
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"
]
3.19 ms
(1.71%)
1
SELECT
                name,
                level,
                exp,
                id as user
            FROM playerdata.players
            WHERE level >= 1 AND name != 'Admin'
Parameters:
[]
1.09 ms
(0.59%)
1
SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = ? AND t0.is_visible = ?
Parameters:
[
  "game"
  1
]

Database Connections

Name Service
default doctrine.dbal.default_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.
App\Entity\CmsPages No errors.