Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0

[]

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0;

SELECT SUM(p0_.quantite) AS sclr_0, p1_.nom AS nom_1 FROM production p0_ INNER JOIN province p1_ ON p0_.province_id = p1_.id WHERE (p0_.date_production BETWEEN ? AND ?) AND p0_.commodite_id = ? AND p0_.province_id IS NOT NULL GROUP BY p1_.nom ORDER BY nom_1 ASC

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

SELECT
  SUM(p0_.quantite) AS sclr_0,
  p1_.nom AS nom_1
FROM
  production p0_
  INNER JOIN province p1_ ON p0_.province_id = p1_.id
WHERE
  (
    p0_.date_production BETWEEN ?
    AND ?
  )
  AND p0_.commodite_id = ?
  AND p0_.province_id IS NOT NULL
GROUP BY
  p1_.nom
ORDER BY
  nom_1 ASC

SELECT SUM(p0_.quantite) AS sclr_0, p1_.nom AS nom_1 FROM production p0_ INNER JOIN province p1_ ON p0_.province_id = p1_.id WHERE (p0_.date_production BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:00') AND p0_.commodite_id = 1 AND p0_.province_id IS NOT NULL GROUP BY p1_.nom ORDER BY nom_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;