Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.user_id AS user_id_22 FROM commodite t0

[]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.color AS color_3,
  t0.unite AS unite_4,
  t0.symbole_chimique AS symbole_chimique_5,
  t0.max AS max_6,
  t0.maxim AS maxim_7,
  t0.amount AS amount_8,
  t0.min_annuel AS min_annuel_9,
  t0.max_annuel AS max_annuel_10,
  t0.amout_annuel AS amout_annuel_11,
  t0.max_semestre AS max_semestre_12,
  t0.amount_semestre AS amount_semestre_13,
  t0.min_trimestre AS min_trimestre_14,
  t0.max_trimestre AS max_trimestre_15,
  t0.amount_trimestre AS amount_trimestre_16,
  t0.min_semetre AS min_semetre_17,
  t0.id_dw AS id_dw_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.user_id AS user_id_22
FROM
  commodite t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.user_id AS user_id_22 FROM commodite t0;

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

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

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

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

SELECT SUM(e0_.quantite) AS sclr_0, p1_.libelle AS libelle_1 FROM exportation e0_ INNER JOIN pays p1_ ON e0_.pays_id = p1_.id WHERE (e0_.date_exportation BETWEEN ? AND ?) AND e0_.is_publish = 1 AND e0_.commodite_id = ? GROUP BY p1_.libelle ORDER BY libelle_1 ASC

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

SELECT
  SUM(e0_.quantite) AS sclr_0,
  p1_.libelle AS libelle_1
FROM
  exportation e0_
  INNER JOIN pays p1_ ON e0_.pays_id = p1_.id
WHERE
  (
    e0_.date_exportation BETWEEN ?
    AND ?
  )
  AND e0_.is_publish = 1
  AND e0_.commodite_id = ?
GROUP BY
  p1_.libelle
ORDER BY
  libelle_1 ASC

SELECT SUM(e0_.quantite) AS sclr_0, p1_.libelle AS libelle_1 FROM exportation e0_ INNER JOIN pays p1_ ON e0_.pays_id = p1_.id WHERE (e0_.date_exportation BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:00') AND e0_.is_publish = 1 AND e0_.commodite_id = 1 GROUP BY p1_.libelle ORDER BY libelle_1 ASC;

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

[
  1
]

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

SELECT SUM(e0_.quantite) AS sclr_0, SUBSTRING(e0_.date_exportation FROM 1 FOR 4) AS sclr_1 FROM exportation e0_ WHERE e0_.is_publish = 1 AND e0_.commodite_id = 1 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(e0_.quantite) AS sclr_0, p1_.libelle AS libelle_1 FROM exportation e0_ INNER JOIN pays p1_ ON e0_.pays_id = p1_.id WHERE e0_.is_publish = 1 AND e0_.commodite_id = ? GROUP BY p1_.libelle ORDER BY libelle_1 ASC

[
  1
]

SELECT
  SUM(e0_.quantite) AS sclr_0,
  p1_.libelle AS libelle_1
FROM
  exportation e0_
  INNER JOIN pays p1_ ON e0_.pays_id = p1_.id
WHERE
  e0_.is_publish = 1
  AND e0_.commodite_id = ?
GROUP BY
  p1_.libelle
ORDER BY
  libelle_1 ASC

SELECT SUM(e0_.quantite) AS sclr_0, p1_.libelle AS libelle_1 FROM exportation e0_ INNER JOIN pays p1_ ON e0_.pays_id = p1_.id WHERE e0_.is_publish = 1 AND e0_.commodite_id = 1 GROUP BY p1_.libelle ORDER BY libelle_1 ASC;