Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 9
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.email AS email_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.phone_number AS phone_number_11, t0.address AS address_12, t0.location AS location_13, t0.client_id AS client_id_14 FROM user t0 WHERE t0.id = ?

[
  17
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_password_changed AS is_password_changed_6,
  t0.last_login_at AS last_login_at_7,
  t0.email AS email_8,
  t0.last_name AS last_name_9,
  t0.first_name AS first_name_10,
  t0.phone_number AS phone_number_11,
  t0.address AS address_12,
  t0.location AS location_13,
  t0.client_id AS client_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.email AS email_8, t0.last_name AS last_name_9, t0.first_name AS first_name_10, t0.phone_number AS phone_number_11, t0.address AS address_12, t0.location AS location_13, t0.client_id AS client_id_14 FROM user t0 WHERE t0.id = 17;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.telephone AS telephone_3,
  t0.contact AS contact_4,
  t0.type AS type_5,
  t0.image AS image_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.code AS code_11,
  t0.le_responsable AS le_responsable_12,
  t0.date_debut_at AS date_debut_at_13,
  t0.date_fin_at AS date_fin_at_14,
  t0.district_id AS district_id_15,
  t0.region_id AS region_id_16,
  t0.departement_id AS departement_id_17,
  t0.commune_id AS commune_id_18,
  t0.ville_id AS ville_id_19
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.contact AS contact_4, t0.type AS type_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.code AS code_11, t0.le_responsable AS le_responsable_12, t0.date_debut_at AS date_debut_at_13, t0.date_fin_at AS date_fin_at_14, t0.district_id AS district_id_15, t0.region_id AS region_id_16, t0.departement_id AS departement_id_17, t0.commune_id AS commune_id_18, t0.ville_id AS ville_id_19 FROM client t0 WHERE t0.id = 3;

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ?

[
  3
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3;

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ? AND e0_.created_at < ?

[
  3
  "2026-04-19 00:00:00"
  "2026-04-20 00:00:00"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?
  AND e0_.created_at < ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-19 00:00:00' AND e0_.created_at < '2026-04-20 00:00:00';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ?

[
  3
  "2026-04-13 00:00:00"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-13 00:00:00';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ?

[
  3
  "2026-04-01 00:00:00"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-01 00:00:00';

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = ? AND a0_.action_type = ? AND e1_.client_id = ? AND a0_.action_date >= ? AND a0_.action_date < ?

[
  "Extrait"
  "impression"
  3
  "2026-04-19 00:00:00"
  "2026-04-20 00:00:00"
]

SELECT
  COUNT(DISTINCT a0_.entity_id) AS sclr_0
FROM
  audit_log a0_
  INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id)
WHERE
  a0_.entity = ?
  AND a0_.action_type = ?
  AND e1_.client_id = ?
  AND a0_.action_date >= ?
  AND a0_.action_date < ?

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = 'Extrait' AND a0_.action_type = 'impression' AND e1_.client_id = 3 AND a0_.action_date >= '2026-04-19 00:00:00' AND a0_.action_date < '2026-04-20 00:00:00';

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = ? AND a0_.action_type = ? AND e1_.client_id = ? AND a0_.action_date >= ?

[
  "Extrait"
  "impression"
  3
  "2026-04-13 00:00:00"
]

SELECT
  COUNT(DISTINCT a0_.entity_id) AS sclr_0
FROM
  audit_log a0_
  INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id)
WHERE
  a0_.entity = ?
  AND a0_.action_type = ?
  AND e1_.client_id = ?
  AND a0_.action_date >= ?

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = 'Extrait' AND a0_.action_type = 'impression' AND e1_.client_id = 3 AND a0_.action_date >= '2026-04-13 00:00:00';

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = ? AND a0_.action_type = ? AND e1_.client_id = ? AND a0_.action_date >= ?

[
  "Extrait"
  "impression"
  3
  "2026-04-01 00:00:00"
]

SELECT
  COUNT(DISTINCT a0_.entity_id) AS sclr_0
FROM
  audit_log a0_
  INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id)
WHERE
  a0_.entity = ?
  AND a0_.action_type = ?
  AND e1_.client_id = ?
  AND a0_.action_date >= ?

SELECT COUNT(DISTINCT a0_.entity_id) AS sclr_0 FROM audit_log a0_ INNER JOIN extrait e1_ ON (e1_.id = a0_.entity_id) WHERE a0_.entity = 'Extrait' AND a0_.action_type = 'impression' AND e1_.client_id = 3 AND a0_.action_date >= '2026-04-01 00:00:00';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.is_demande = ?

[
  3
  1
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.is_demande = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.is_demande = 1;

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ?

[
  3
  "2026-03-20 00:00:00"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-03-20 00:00:00';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.created_at >= ? AND e0_.created_at < ?

[
  3
  "2026-04-06 00:00:00"
  "2026-04-13 00:00:00"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.created_at >= ?
  AND e0_.created_at < ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.created_at >= '2026-04-06 00:00:00' AND e0_.created_at < '2026-04-13 00:00:00';

SELECT COUNT(r0_.id) AS sclr_0 FROM registre_naissance r0_ WHERE r0_.client_id = ?

[
  3
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  registre_naissance r0_
WHERE
  r0_.client_id = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM registre_naissance r0_ WHERE r0_.client_id = 3;

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.sexe = ?

[
  3
  "F"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.sexe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.sexe = 'F';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.sexe = ?

[
  3
  "M"
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.sexe = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.sexe = 'M';

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.is_etat = ?

[
  3
  1
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.is_etat = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.is_etat = 1;

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = ? AND e0_.is_etat = ?

[
  3
  0
]

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  extrait e0_
WHERE
  e0_.client_id = ?
  AND e0_.is_etat = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM extrait e0_ WHERE e0_.client_id = 3 AND e0_.is_etat = 0;