Symfony Profiler

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

Query Metrics

SELECT
                COALESCE(SUM(nb_nc_regl), 0)     AS total_nc_regl,
                COALESCE(SUM(nb_nc_non_regl), 0) AS total_nc_non_regl,
                COALESCE(SUM(nb_rem_regl), 0)    AS total_rem_regl,
                COALESCE(SUM(nb_ncc_regl), 0)        AS total_ncc_regl,
                COALESCE(SUM(nb_ncc_non_regl), 0)    AS total_ncc_non_regl,
                COUNT(CASE WHEN date_cloture IS NOT NULL THEN 1 END) AS audits_clotures,
                COUNT(CASE WHEN resultat = 'Favorable' AND date_cloture IS NOT NULL THEN 1 END) AS audits_favorables
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = ?

[
  2026
]

SELECT
  COALESCE(
    SUM(nb_nc_regl),
    0
  ) AS total_nc_regl,
  COALESCE(
    SUM(nb_nc_non_regl),
    0
  ) AS total_nc_non_regl,
  COALESCE(
    SUM(nb_rem_regl),
    0
  ) AS total_rem_regl,
  COALESCE(
    SUM(nb_ncc_regl),
    0
  ) AS total_ncc_regl,
  COALESCE(
    SUM(nb_ncc_non_regl),
    0
  ) AS total_ncc_non_regl,
  COUNT(
    CASE WHEN date_cloture IS NOT NULL THEN
      1
    END
  ) AS audits_clotures,
  COUNT(
    CASE WHEN resultat = 'Favorable'
    AND date_cloture IS NOT NULL THEN
      1
    END
  ) AS audits_favorables
FROM
  aut_audit a
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?

SELECT
                COALESCE(SUM(nb_nc_regl), 0)     AS total_nc_regl,
                COALESCE(SUM(nb_nc_non_regl), 0) AS total_nc_non_regl,
                COALESCE(SUM(nb_rem_regl), 0)    AS total_rem_regl,
                COALESCE(SUM(nb_ncc_regl), 0)        AS total_ncc_regl,
                COALESCE(SUM(nb_ncc_non_regl), 0)    AS total_ncc_non_regl,
                COUNT(CASE WHEN date_cloture IS NOT NULL THEN 1 END) AS audits_clotures,
                COUNT(CASE WHEN resultat = 'Favorable' AND date_cloture IS NOT NULL THEN 1 END) AS audits_favorables
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = 2026;

SELECT a.type_centre AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.type_centre IS NOT NULL AND a.type_centre != ''
             GROUP BY a.type_centre
             ORDER BY count DESC

[
  2026
]

SELECT
  a.type_centre AS label,
  COUNT(*) AS count
FROM
  aut_audit a
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?
  AND a.type_centre IS NOT NULL
  AND a.type_centre != ''
GROUP BY
  a.type_centre
ORDER BY
  count DESC

SELECT a.type_centre AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = 2026 AND a.type_centre IS NOT NULL AND a.type_centre != ''
             GROUP BY a.type_centre
             ORDER BY count DESC;

SELECT COALESCE(p.Libelle, ca.libelle) AS label, SUM(ca.nc + ca.ncc) AS count
             FROM aut_contenu_audit ca
             INNER JOIN aut_audit a ON a.id = ca.aut_audit_id
             LEFT JOIN aut_point_audit p ON p.id = ca.aut_point_audit_id
             WHERE 1=1 AND YEAR(a.date_audit) = ? AND (ca.nc > 0 OR ca.ncc > 0)
             GROUP BY ca.aut_point_audit_id, COALESCE(p.Libelle, ca.libelle)
             ORDER BY count DESC
             LIMIT 10

[
  2026
]

SELECT
  COALESCE(p.Libelle, ca.libelle) AS label,
  SUM(ca.nc + ca.ncc) AS count
FROM
  aut_contenu_audit ca
  INNER JOIN aut_audit a ON a.id = ca.aut_audit_id
  LEFT JOIN aut_point_audit p ON p.id = ca.aut_point_audit_id
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?
  AND (
    ca.nc > 0
    OR ca.ncc > 0
  )
GROUP BY
  ca.aut_point_audit_id,
  COALESCE(p.Libelle, ca.libelle)
ORDER BY
  count DESC
LIMIT
  10

SELECT COALESCE(p.Libelle, ca.libelle) AS label, SUM(ca.nc + ca.ncc) AS count
             FROM aut_contenu_audit ca
             INNER JOIN aut_audit a ON a.id = ca.aut_audit_id
             LEFT JOIN aut_point_audit p ON p.id = ca.aut_point_audit_id
             WHERE 1=1 AND YEAR(a.date_audit) = 2026 AND (ca.nc > 0 OR ca.ncc > 0)
             GROUP BY ca.aut_point_audit_id, COALESCE(p.Libelle, ca.libelle)
             ORDER BY count DESC
             LIMIT 10;

SELECT a.auditeur_id, CONCAT(p.nom, ' ', p.prenom) AS auditeur, COUNT(a.id) AS count
             FROM aut_audit a
             LEFT JOIN bo_personnel_abs p ON p.id = a.auditeur_id
             WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.auditeur_id IS NOT NULL
             GROUP BY a.auditeur_id, p.nom, p.prenom
             ORDER BY count DESC
             LIMIT 10

[
  2026
]

SELECT
  a.auditeur_id,
  CONCAT(p.nom, ' ', p.prenom) AS auditeur,
  COUNT(a.id) AS count
FROM
  aut_audit a
  LEFT JOIN bo_personnel_abs p ON p.id = a.auditeur_id
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?
  AND a.auditeur_id IS NOT NULL
GROUP BY
  a.auditeur_id,
  p.nom,
  p.prenom
ORDER BY
  count DESC
LIMIT
  10

SELECT a.auditeur_id, CONCAT(p.nom, ' ', p.prenom) AS auditeur, COUNT(a.id) AS count
             FROM aut_audit a
             LEFT JOIN bo_personnel_abs p ON p.id = a.auditeur_id
             WHERE 1=1 AND YEAR(a.date_audit) = 2026 AND a.auditeur_id IS NOT NULL
             GROUP BY a.auditeur_id, p.nom, p.prenom
             ORDER BY count DESC
             LIMIT 10;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.auditeur AS auditeur_7,
  t0.formateur AS formateur_8,
  t0.etat AS etat_9,
  t0.image AS image_10,
  t0.create_at AS create_at_11,
  t0.create_by AS create_by_12,
  t0.comptable AS comptable_13,
  t0.informatique AS informatique_14,
  t0.commercial AS commercial_15,
  t0.hotline AS hotline_16,
  t0.direction AS direction_17,
  t0.administratif AS administratif_18,
  t0.telephone AS telephone_19,
  t0.id_rise_up AS id_rise_up_20,
  t0.superviseur_audit AS superviseur_audit_21,
  t0.initial AS initial_22,
  t0.fonction_id AS fonction_id_23,
  t0.FKUser AS FKUser_24
FROM
  bo_personnel_abs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = 16;

SELECT COUNT(*) FROM aut_audit WHERE date_cloture IS NULL

[]

SELECT
  COUNT(*)
FROM
  aut_audit
WHERE
  date_cloture IS NULL

SELECT COUNT(*) FROM aut_audit WHERE date_cloture IS NULL;

SELECT DATE_FORMAT(a.date_audit, '%Y-%m') AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = ?
             GROUP BY DATE_FORMAT(a.date_audit, '%Y-%m')
             ORDER BY label ASC
             LIMIT 60

[
  2026
]

SELECT
  DATE_FORMAT(a.date_audit, '%Y-%m') AS label,
  COUNT(*) AS count
FROM
  aut_audit a
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?
GROUP BY
  DATE_FORMAT(a.date_audit, '%Y-%m')
ORDER BY
  label ASC
LIMIT
  60

SELECT DATE_FORMAT(a.date_audit, '%Y-%m') AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = 2026
             GROUP BY DATE_FORMAT(a.date_audit, '%Y-%m')
             ORDER BY label ASC
             LIMIT 60;

SELECT a.lib_type_audit AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = ? AND a.lib_type_audit IS NOT NULL AND a.lib_type_audit != ''
             GROUP BY a.lib_type_audit
             ORDER BY count DESC

[
  2026
]

SELECT
  a.lib_type_audit AS label,
  COUNT(*) AS count
FROM
  aut_audit a
WHERE
  1 = 1
  AND YEAR(a.date_audit) = ?
  AND a.lib_type_audit IS NOT NULL
  AND a.lib_type_audit != ''
GROUP BY
  a.lib_type_audit
ORDER BY
  count DESC

SELECT a.lib_type_audit AS label, COUNT(*) AS count
             FROM aut_audit a
             WHERE 1=1 AND YEAR(a.date_audit) = 2026 AND a.lib_type_audit IS NOT NULL AND a.lib_type_audit != ''
             GROUP BY a.lib_type_audit
             ORDER BY count DESC;