Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT COUNT(*) FROM chest t0

[]

SELECT
  COUNT(*)
FROM
  chest t0

SELECT COUNT(*) FROM chest t0;

SELECT COUNT(*) FROM `user` t0

[]

SELECT
  COUNT(*)
FROM
  `user` t0

SELECT COUNT(*) FROM `user` t0;

SELECT COUNT(*) FROM chest t0 WHERE t0.is_active = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  chest t0
WHERE
  t0.is_active = ?

SELECT COUNT(*) FROM chest t0 WHERE t0.is_active = 1;

SELECT COUNT(*) FROM unlock_attempt t0

[]

SELECT
  COUNT(*)
FROM
  unlock_attempt t0

SELECT COUNT(*) FROM unlock_attempt t0;

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 = ? AND t0.is_opened = ? ORDER BY t0.created_at DESC LIMIT 6

[
  1
  0
]

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 = ?
  AND t0.is_opened = ?
ORDER BY
  t0.created_at DESC
LIMIT
  6

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 = 1 AND t0.is_opened = 0 ORDER BY t0.created_at DESC LIMIT 6;

SELECT COUNT(*) FROM chest t0 WHERE t0.is_opened = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  chest t0
WHERE
  t0.is_opened = ?

SELECT COUNT(*) FROM chest t0 WHERE t0.is_opened = 1;

SELECT COUNT(*) FROM unlock_attempt t0 WHERE t0.is_successful = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  unlock_attempt t0
WHERE
  t0.is_successful = ?

SELECT COUNT(*) FROM unlock_attempt t0 WHERE t0.is_successful = 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_opened = ? ORDER BY t0.opened_at DESC LIMIT 5

[
  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_opened = ?
ORDER BY
  t0.opened_at DESC
LIMIT
  5

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_opened = 1 ORDER BY t0.opened_at DESC LIMIT 5;