Symfony Profiler

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

Query Metrics

PRAGMA foreign_keys = ON

[]

PRAGMA foreign_keys = ON

PRAGMA foreign_keys = ON;

PRAGMA journal_mode = WAL

[]

PRAGMA journal_mode = WAL

PRAGMA journal_mode = WAL;

PRAGMA busy_timeout = 5000

[]

PRAGMA busy_timeout = 5000

PRAGMA busy_timeout = 5000;

SELECT t0.id AS id_1, t0.discord_id AS discord_id_2, t0.username AS username_3, t0.global_name AS global_name_4, t0.avatar_hash AS avatar_hash_5, t0.roles AS roles_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8 FROM "user" t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.discord_id AS discord_id_2,
  t0.username AS username_3,
  t0.global_name AS global_name_4,
  t0.avatar_hash AS avatar_hash_5,
  t0.roles AS roles_6,
  t0.created_at AS created_at_7,
  t0.last_login_at AS last_login_at_8
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.discord_id AS discord_id_2, t0.username AS username_3, t0.global_name AS global_name_4, t0.avatar_hash AS avatar_hash_5, t0.roles AS roles_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8 FROM "user" t0 WHERE t0.id = 3;

SELECT d0_.id AS id_0, d0_.day AS day_1, d0_.unlock_date AS unlock_date_2, d0_.title AS title_3, d0_.description AS description_4 FROM door d0_ WHERE d0_.day BETWEEN ? AND ? ORDER BY d0_.day ASC

[
  1
  24
]

SELECT
  d0_.id AS id_0,
  d0_.day AS day_1,
  d0_.unlock_date AS unlock_date_2,
  d0_.title AS title_3,
  d0_.description AS description_4
FROM
  door d0_
WHERE
  d0_.day BETWEEN ?
  AND ?
ORDER BY
  d0_.day ASC

SELECT d0_.id AS id_0, d0_.day AS day_1, d0_.unlock_date AS unlock_date_2, d0_.title AS title_3, d0_.description AS description_4 FROM door d0_ WHERE d0_.day BETWEEN 1 AND 24 ORDER BY d0_.day ASC;

SELECT s0_.door_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM steam_key s0_ WHERE s0_.claimed_by_id IS NULL GROUP BY s0_.door_id

[]

SELECT
  s0_.door_id AS sclr_0,
  COUNT(s0_.id) AS sclr_1
FROM
  steam_key s0_
WHERE
  s0_.claimed_by_id IS NULL
GROUP BY
  s0_.door_id

SELECT s0_.door_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM steam_key s0_ WHERE s0_.claimed_by_id IS NULL GROUP BY s0_.door_id;

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.claimed_at AS claimed_at_2, s0_.is_demo AS is_demo_3, s0_.label AS label_4, d1_.id AS id_5, d1_.day AS day_6, d1_.unlock_date AS unlock_date_7, d1_.title AS title_8, d1_.description AS description_9, s0_.door_id AS door_id_10, s0_.claimed_by_id AS claimed_by_id_11 FROM steam_key s0_ INNER JOIN door d1_ ON s0_.door_id = d1_.id WHERE s0_.claimed_by_id = ? ORDER BY d1_.day ASC

[
  3
]

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.claimed_at AS claimed_at_2,
  s0_.is_demo AS is_demo_3,
  s0_.label AS label_4,
  d1_.id AS id_5,
  d1_.day AS day_6,
  d1_.unlock_date AS unlock_date_7,
  d1_.title AS title_8,
  d1_.description AS description_9,
  s0_.door_id AS door_id_10,
  s0_.claimed_by_id AS claimed_by_id_11
FROM
  steam_key s0_
  INNER JOIN door d1_ ON s0_.door_id = d1_.id
WHERE
  s0_.claimed_by_id = ?
ORDER BY
  d1_.day ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.claimed_at AS claimed_at_2, s0_.is_demo AS is_demo_3, s0_.label AS label_4, d1_.id AS id_5, d1_.day AS day_6, d1_.unlock_date AS unlock_date_7, d1_.title AS title_8, d1_.description AS description_9, s0_.door_id AS door_id_10, s0_.claimed_by_id AS claimed_by_id_11 FROM steam_key s0_ INNER JOIN door d1_ ON s0_.door_id = d1_.id WHERE s0_.claimed_by_id = 3 ORDER BY d1_.day ASC;

SELECT t0.id AS id_1, t0.day AS day_2, t0.unlock_date AS unlock_date_3, t0.title AS title_4, t0.description AS description_5 FROM door t0 WHERE t0.day = ? LIMIT 1

[
  24
]

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.unlock_date AS unlock_date_3,
  t0.title AS title_4,
  t0.description AS description_5
FROM
  door t0
WHERE
  t0.day = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.day AS day_2, t0.unlock_date AS unlock_date_3, t0.title AS title_4, t0.description AS description_5 FROM door t0 WHERE t0.day = 24 LIMIT 1;