GET https://pixel-aventure.serv-kompixel.fr/coffres

Query Metrics

1 Database Queries
1 Different statements
8.21 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.21 ms
(100.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.difficulty AS difficulty_4, t0.reward_value AS reward_value_5, t0.reward_type AS reward_type_6, t0.reward_name AS reward_name_7, t0.reward_description AS reward_description_8, t0.image_name AS image_name_9, t0.code_length AS code_length_10, t0.code AS code_11, t0.is_public AS is_public_12, t0.is_premium_only AS is_premium_only_13, t0.daily_attempts_limit AS daily_attempts_limit_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.activated_at AS activated_at_17, t0.expires_at AS expires_at_18, t0.is_opened AS is_opened_19, t0.opened_at AS opened_at_20, t0.updated_at AS updated_at_21, t0.winner_id AS winner_id_22 FROM chest t0 WHERE t0.is_active = ? ORDER BY t0.created_at DESC
Parameters:
[
  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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Chest 4

Entities Mapping

Class Mapping errors
App\Entity\Chest No errors.
App\Entity\User No errors.
App\Entity\ChestHint No errors.
App\Entity\UnlockAttempt No errors.