Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 29
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 65
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Blocks 0
• Configuration

Query Metrics

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 6 FOR 2) AS sclr_1 FROM redevance r0_ WHERE r0_.date_redevance BETWEEN ? AND ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

[
  "2024-01-01 00:00:00"
  "2024-12-31 23:59:00"
]

SELECT
  SUM(r0_.montant) AS sclr_0,
  SUBSTRING(
    r0_.date_redevance
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  redevance r0_
WHERE
  r0_.date_redevance BETWEEN ?
  AND ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 6 FOR 2) AS sclr_1 FROM redevance r0_ WHERE r0_.date_redevance BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:00' GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 1 FOR 4) AS sclr_1 FROM redevance r0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC

[]

SELECT
  SUM(r0_.montant) AS sclr_0,
  SUBSTRING(
    r0_.date_redevance
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  redevance r0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(r0_.montant) AS sclr_0, SUBSTRING(r0_.date_redevance FROM 1 FOR 4) AS sclr_1 FROM redevance r0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.unite AS unite_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  filiere t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0;