Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 114
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• Doctrine
• Debug
• Emails
• EasyAdmin
• VichUploader
• GraphQL 1
• Configuration

Query Metrics

Grouped Statements

Show all queries

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT count(d0_.id) AS sclr_0 FROM duel d0_ INNER JOIN collection c1_ ON d0_.collection_id = c1_.id WHERE c1_.is_published = 1 AND (d0_.challenger_id = ? OR d0_.opponent_id = ?) AND DATE_ADD(d0_.created, INTERVAL 31 DAY) > CURRENT_DATE AND (d0_.score_challenger IS NULL OR d0_.score_opponent IS NULL)

[
  26982
  26982
]

SELECT
  count(d0_.id) AS sclr_0
FROM
  duel d0_
  INNER JOIN collection c1_ ON d0_.collection_id = c1_.id
WHERE
  c1_.is_published = 1
  AND (
    d0_.challenger_id = ?
    OR d0_.opponent_id = ?
  )
  AND DATE_ADD(d0_.created, INTERVAL 31 DAY) > CURRENT_DATE
  AND (
    d0_.score_challenger IS NULL
    OR d0_.score_opponent IS NULL
  )

SELECT count(d0_.id) AS sclr_0 FROM duel d0_ INNER JOIN collection c1_ ON d0_.collection_id = c1_.id WHERE c1_.is_published = 1 AND (d0_.challenger_id = 26982 OR d0_.opponent_id = 26982) AND DATE_ADD(d0_.created, INTERVAL 31 DAY) > CURRENT_DATE AND (d0_.score_challenger IS NULL OR d0_.score_opponent IS NULL);

SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.username AS username_5, t0.roles AS roles_6, t0.score AS score_7, t0.all_time_score AS all_time_score_8, t0.has_been_reset AS has_been_reset_9, t0.last_login_at AS last_login_at_10, t0.school_level_id AS school_level_id_11, t0.school_degree_id AS school_degree_id_12, t0.avatar_id AS avatar_id_13 FROM user t0 WHERE t0.username = ? LIMIT 1

[
  "MONNINA"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.username AS username_5,
  t0.roles AS roles_6,
  t0.score AS score_7,
  t0.all_time_score AS all_time_score_8,
  t0.has_been_reset AS has_been_reset_9,
  t0.last_login_at AS last_login_at_10,
  t0.school_level_id AS school_level_id_11,
  t0.school_degree_id AS school_degree_id_12,
  t0.avatar_id AS avatar_id_13
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.username AS username_5, t0.roles AS roles_6, t0.score AS score_7, t0.all_time_score AS all_time_score_8, t0.has_been_reset AS has_been_reset_9, t0.last_login_at AS last_login_at_10, t0.school_level_id AS school_level_id_11, t0.school_degree_id AS school_degree_id_12, t0.avatar_id AS avatar_id_13 FROM user t0 WHERE t0.username = 'MONNINA' LIMIT 1;

DELETE FROM user_school WHERE user_id = ?

[
  26982
]

DELETE FROM
  user_school
WHERE
  user_id = ?

DELETE FROM user_school WHERE user_id = 26982;

SELECT t0.id AS id_1, t0.name AS name_2, t0.uo_id AS uo_id_3, t0.school_level_id AS school_level_id_4 FROM school t0 INNER JOIN user_school ON t0.id = user_school.school_id WHERE user_school.user_id = ?

[
  26982
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uo_id AS uo_id_3,
  t0.school_level_id AS school_level_id_4
FROM
  school t0
  INNER JOIN user_school ON t0.id = user_school.school_id
WHERE
  user_school.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uo_id AS uo_id_3, t0.school_level_id AS school_level_id_4 FROM school t0 INNER JOIN user_school ON t0.id = user_school.school_id WHERE user_school.user_id = 26982;

UPDATE user SET last_login_at = ? WHERE id = ?

[
  "2025-12-16 11:39:53"
  26982
]

UPDATE
  user
SET
  last_login_at = ?
WHERE
  id = ?

UPDATE user SET last_login_at = '2025-12-16 11:39:53' WHERE id = 26982;

SELECT t0.id AS id_1, t0.name AS name_2, t0.uo_id AS uo_id_3, t0.school_level_id AS school_level_id_4 FROM school t0 WHERE t0.uo_id = ? LIMIT 1

[
  "UO0388"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uo_id AS uo_id_3,
  t0.school_level_id AS school_level_id_4
FROM
  school t0
WHERE
  t0.uo_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.uo_id AS uo_id_3, t0.school_level_id AS school_level_id_4 FROM school t0 WHERE t0.uo_id = 'UO0388' LIMIT 1;

INSERT INTO user_school (user_id, school_id) VALUES (?, ?)

[
  26982
  234
]

INSERT INTO user_school (user_id, school_id)
VALUES
  (?, ?)

INSERT INTO user_school (user_id, school_id) VALUES (26982, 234);

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

Database Connections

Entity Managers

Second Level Cache

Entities Mapping