Symfony Profiler

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

Query Metrics

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.color AS color_2, c0_.unite AS unite_3, c0_.symbole_chimique AS symbole_chimique_4, c0_.max AS max_5, c0_.maxim AS maxim_6, c0_.amount AS amount_7, c0_.min_annuel AS min_annuel_8, c0_.max_annuel AS max_annuel_9, c0_.amout_annuel AS amout_annuel_10, c0_.max_semestre AS max_semestre_11, c0_.amount_semestre AS amount_semestre_12, c0_.min_trimestre AS min_trimestre_13, c0_.max_trimestre AS max_trimestre_14, c0_.amount_trimestre AS amount_trimestre_15, c0_.min_semetre AS min_semetre_16, c0_.id_dw AS id_dw_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.user_id AS user_id_21 FROM commodite c0_ WHERE c0_.id = ?

[
  10
]

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.color AS color_2,
  c0_.unite AS unite_3,
  c0_.symbole_chimique AS symbole_chimique_4,
  c0_.max AS max_5,
  c0_.maxim AS maxim_6,
  c0_.amount AS amount_7,
  c0_.min_annuel AS min_annuel_8,
  c0_.max_annuel AS max_annuel_9,
  c0_.amout_annuel AS amout_annuel_10,
  c0_.max_semestre AS max_semestre_11,
  c0_.amount_semestre AS amount_semestre_12,
  c0_.min_trimestre AS min_trimestre_13,
  c0_.max_trimestre AS max_trimestre_14,
  c0_.amount_trimestre AS amount_trimestre_15,
  c0_.min_semetre AS min_semetre_16,
  c0_.id_dw AS id_dw_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.deleted_at AS deleted_at_20,
  c0_.user_id AS user_id_21
FROM
  commodite c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.color AS color_2, c0_.unite AS unite_3, c0_.symbole_chimique AS symbole_chimique_4, c0_.max AS max_5, c0_.maxim AS maxim_6, c0_.amount AS amount_7, c0_.min_annuel AS min_annuel_8, c0_.max_annuel AS max_annuel_9, c0_.amout_annuel AS amout_annuel_10, c0_.max_semestre AS max_semestre_11, c0_.amount_semestre AS amount_semestre_12, c0_.min_trimestre AS min_trimestre_13, c0_.max_trimestre AS max_trimestre_14, c0_.amount_trimestre AS amount_trimestre_15, c0_.min_semetre AS min_semetre_16, c0_.id_dw AS id_dw_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.user_id AS user_id_21 FROM commodite c0_ WHERE c0_.id = 10;

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_1 FROM vente_local v0_ WHERE (v0_.date_vente BETWEEN ? AND ?) AND v0_.is_publish = 1 AND v0_.commodite_id = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

[
  "2025-01-01 00:00:00"
  "2025-12-31 23:59:00"
  10
]

SELECT
  SUM(v0_.quantite) AS sclr_0,
  SUBSTRING(
    v0_.date_vente
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  vente_local v0_
WHERE
  (
    v0_.date_vente BETWEEN ?
    AND ?
  )
  AND v0_.is_publish = 1
  AND v0_.commodite_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_1 FROM vente_local v0_ WHERE (v0_.date_vente BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:00') AND v0_.is_publish = 1 AND v0_.commodite_id = 10 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 1 FOR 4) AS sclr_1 FROM vente_local v0_ WHERE v0_.is_publish = 1 AND v0_.commodite_id = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC

[
  10
]

SELECT
  SUM(v0_.quantite) AS sclr_0,
  SUBSTRING(
    v0_.date_vente
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  vente_local v0_
WHERE
  v0_.is_publish = 1
  AND v0_.commodite_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 1 FOR 4) AS sclr_1 FROM vente_local v0_ WHERE v0_.is_publish = 1 AND v0_.commodite_id = 10 GROUP BY sclr_1 ORDER BY sclr_1 ASC;