Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1183
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• JMS Serializer 0
• VichUploader
• Configuration

Query Metrics

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.body AS body_2, b0_.post_date AS post_date_3, b0_.posted_by AS posted_by_4, b0_.created AS created_5, b0_.created_by AS created_by_6, b0_.modified AS modified_7, b0_.modified_by AS modified_by_8, b0_.posted_by AS posted_by_9 FROM blog_post b0_ WHERE b0_.post_date >= ? AND b0_.post_date < ? AND b0_.post_date <= CURRENT_DATE ORDER BY b0_.post_date DESC

[
  "2025-02-01 00:00:00"
  "2025-03-01 00:00:00"
]

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.body AS body_2,
  b0_.post_date AS post_date_3,
  b0_.posted_by AS posted_by_4,
  b0_.created AS created_5,
  b0_.created_by AS created_by_6,
  b0_.modified AS modified_7,
  b0_.modified_by AS modified_by_8,
  b0_.posted_by AS posted_by_9
FROM
  blog_post b0_
WHERE
  b0_.post_date >= ?
  AND b0_.post_date < ?
  AND b0_.post_date <= CURRENT_DATE
ORDER BY
  b0_.post_date DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.body AS body_2, b0_.post_date AS post_date_3, b0_.posted_by AS posted_by_4, b0_.created AS created_5, b0_.created_by AS created_by_6, b0_.modified AS modified_7, b0_.modified_by AS modified_by_8, b0_.posted_by AS posted_by_9 FROM blog_post b0_ WHERE b0_.post_date >= '2025-02-01 00:00:00' AND b0_.post_date < '2025-03-01 00:00:00' AND b0_.post_date <= CURRENT_DATE ORDER BY b0_.post_date DESC;

SELECT SUBSTRING(b0_.post_date FROM 1 FOR 4) AS sclr_0, SUBSTRING(b0_.post_date FROM 6 FOR 2) AS sclr_1, CONCAT(SUBSTRING(b0_.post_date FROM 1 FOR 4), SUBSTRING(b0_.post_date FROM 6 FOR 2)) AS sclr_2, b0_.post_date AS post_date_3 FROM blog_post b0_ WHERE b0_.post_date <= CURRENT_DATE GROUP BY sclr_2 ORDER BY sclr_0 DESC, sclr_1 DESC

[]

SELECT
  SUBSTRING(
    b0_.post_date
    FROM
      1 FOR 4
  ) AS sclr_0,
  SUBSTRING(
    b0_.post_date
    FROM
      6 FOR 2
  ) AS sclr_1,
  CONCAT(
    SUBSTRING(
      b0_.post_date
      FROM
        1 FOR 4
    ),
    SUBSTRING(
      b0_.post_date
      FROM
        6 FOR 2
    )
  ) AS sclr_2,
  b0_.post_date AS post_date_3
FROM
  blog_post b0_
WHERE
  b0_.post_date <= CURRENT_DATE
GROUP BY
  sclr_2
ORDER BY
  sclr_0 DESC,
  sclr_1 DESC

SELECT SUBSTRING(b0_.post_date FROM 1 FOR 4) AS sclr_0, SUBSTRING(b0_.post_date FROM 6 FOR 2) AS sclr_1, CONCAT(SUBSTRING(b0_.post_date FROM 1 FOR 4), SUBSTRING(b0_.post_date FROM 6 FOR 2)) AS sclr_2, b0_.post_date AS post_date_3 FROM blog_post b0_ WHERE b0_.post_date <= CURRENT_DATE GROUP BY sclr_2 ORDER BY sclr_0 DESC, sclr_1 DESC;