Symfony Profiler

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

Query Metrics

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 GROUP BY sclr_1 ORDER BY sclr_1 ASC

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

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
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 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT SUM(p0_.quantite) AS sclr_0, SUBSTRING(p0_.date_production FROM 6 FOR 2) AS sclr_1 FROM production p0_ WHERE (p0_.date_production BETWEEN ? AND ?) AND p0_.is_publish = 1 GROUP BY sclr_1 ORDER BY sclr_1 ASC

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

SELECT
  SUM(p0_.quantite) AS sclr_0,
  SUBSTRING(
    p0_.date_production
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  production p0_
WHERE
  (
    p0_.date_production BETWEEN ?
    AND ?
  )
  AND p0_.is_publish = 1
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

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

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.photo AS photo_4, t0.date_actualite AS date_actualite_5, t0.slug AS slug_6, t0.auteur AS auteur_7, t0.is_pubie AS is_pubie_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.categorie_actualite_id AS categorie_actualite_id_12, t0.user_id AS user_id_13 FROM actualite t0 WHERE t0.is_pubie = ? ORDER BY t0.id DESC LIMIT 4

[
  1
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.photo AS photo_4,
  t0.date_actualite AS date_actualite_5,
  t0.slug AS slug_6,
  t0.auteur AS auteur_7,
  t0.is_pubie AS is_pubie_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.categorie_actualite_id AS categorie_actualite_id_12,
  t0.user_id AS user_id_13
FROM
  actualite t0
WHERE
  t0.is_pubie = ?
ORDER BY
  t0.id DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.photo AS photo_4, t0.date_actualite AS date_actualite_5, t0.slug AS slug_6, t0.auteur AS auteur_7, t0.is_pubie AS is_pubie_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.categorie_actualite_id AS categorie_actualite_id_12, t0.user_id AS user_id_13 FROM actualite t0 WHERE t0.is_pubie = 1 ORDER BY t0.id DESC LIMIT 4;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM projet p0_ WHERE p0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  projet p0_
WHERE
  p0_.is_publish = 1

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM projet p0_ WHERE p0_.is_publish = 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 GROUP BY sclr_1 ORDER BY sclr_1 ASC

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

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
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 '2025-01-01 00:00:00' AND '2025-12-31 23:59:00') AND e0_.is_publish = 1 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM titre_minier t0_ WHERE t0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  titre_minier t0_
WHERE
  t0_.is_publish = 1

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM titre_minier t0_ WHERE t0_.is_publish = 1;

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_

[]

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_relatif c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_;

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM environemental e0_ WHERE e0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  environemental e0_
WHERE
  e0_.is_publish = 1

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM environemental e0_ WHERE e0_.is_publish = 1;

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM arrete a0_ WHERE a0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  arrete a0_
WHERE
  a0_.is_publish = 1

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM arrete a0_ WHERE a0_.is_publish = 1;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM part_actionnaire p0_

[]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  part_actionnaire p0_

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM part_actionnaire p0_;

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_
WHERE
  c0_.is_publish = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.is_publish = 1;

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM resource_hydrolique r0_

[]

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  resource_hydrolique r0_

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM resource_hydrolique r0_;

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cahier_de_charge c0_ WHERE c0_.is_publish = 1

[]

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  cahier_de_charge c0_
WHERE
  c0_.is_publish = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cahier_de_charge c0_ WHERE c0_.is_publish = 1;