Symfony Profiler

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

Query Metrics

SELECT count(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = ? AND m1_.visibility = ? AND (p0_.created_at BETWEEN ? AND ?) AND m1_.is_adult = ? AND p0_.is_adult = ? ORDER BY sclr_0 ASC

[
  "visible"
  "visible"
  "2025-04-30 07:07:24+0000"
  "2025-05-30 07:07:24+0000"
  0
  0
]

SELECT
  count(p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id
  INNER JOIN "user" u2_ ON p0_.user_id = u2_.id
WHERE
  p0_.visibility = ?
  AND m1_.visibility = ?
  AND (
    p0_.created_at BETWEEN ?
    AND ?
  )
  AND m1_.is_adult = ?
  AND p0_.is_adult = ?
ORDER BY
  sclr_0 ASC

SELECT count(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = 'visible' AND m1_.visibility = 'visible' AND (p0_.created_at BETWEEN '2025-04-30 07:07:24+0000' AND '2025-05-30 07:07:24+0000') AND m1_.is_adult = 0 AND p0_.is_adult = 0 ORDER BY sclr_0 ASC;