Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 33
• Events
• Routing
• Cache
• Translation 21
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations 38
• Debug
• Messages
• E-mails
• Notifications
• EasyAdmin
• Configuration

Query Metrics

Grouped Statements

Show all queries

SELECT COUNT(w0_.id) AS sclr_0 FROM word w0_ LEFT JOIN game_word g1_ ON w0_.id = g1_.word_id LEFT JOIN game_sound g2_ ON g1_.sound_id = g2_.id LEFT JOIN game g3_ ON g2_.game_id = g3_.id WHERE g3_.published_at < CURRENT_TIMESTAMP GROUP BY w0_.id

[]

SELECT
  COUNT(w0_.id) AS sclr_0
FROM
  word w0_
  LEFT JOIN game_word g1_ ON w0_.id = g1_.word_id
  LEFT JOIN game_sound g2_ ON g1_.sound_id = g2_.id
  LEFT JOIN game g3_ ON g2_.game_id = g3_.id
WHERE
  g3_.published_at < CURRENT_TIMESTAMP
GROUP BY
  w0_.id

SELECT COUNT(w0_.id) AS sclr_0 FROM word w0_ LEFT JOIN game_word g1_ ON w0_.id = g1_.word_id LEFT JOIN game_sound g2_ ON g1_.sound_id = g2_.id LEFT JOIN game g3_ ON g2_.game_id = g3_.id WHERE g3_.published_at < CURRENT_TIMESTAMP GROUP BY w0_.id;

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_

[]

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_;

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.subscription_date IS NOT NULL

[]

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.subscription_date IS NOT NULL

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.subscription_date IS NOT NULL;

SELECT COUNT(g0_.id) AS sclr_0 FROM game g0_ WHERE g0_.published_at < CURRENT_TIMESTAMP

[]

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  game g0_
WHERE
  g0_.published_at < CURRENT_TIMESTAMP

SELECT COUNT(g0_.id) AS sclr_0 FROM game g0_ WHERE g0_.published_at < CURRENT_TIMESTAMP;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping