Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 128
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.userid = ? LIMIT 1

[
  2
]

SELECT
  t0.id AS id_1,
  t0.idUtilisateur AS idUtilisateur_2,
  t0.userid AS userid_3,
  t0.registerkey AS registerkey_4,
  t0.codetr AS codetr_5,
  t0.Fonction AS Fonction_6,
  t0.ClassPro AS ClassPro_7,
  t0.DateEmbauche AS DateEmbauche_8,
  t0.DateDebauche AS DateDebauche_9,
  t0.SalaireB AS SalaireB_10,
  t0.Nbenfant AS Nbenfant_11,
  t0.nb_enfant_fille AS nb_enfant_fille_12,
  t0.nb_enfant_garcon AS nb_enfant_garcon_13,
  t0.mere_en_vie AS mere_en_vie_14,
  t0.pere_en_vie AS pere_en_vie_15,
  t0.nb_proche AS nb_proche_16,
  t0.nb_proche_en_vie AS nb_proche_en_vie_17,
  t0.marital_status AS marital_status_18,
  t0.marriage_date AS marriage_date_19,
  t0.work_time_ratio AS work_time_ratio_20,
  t0.NbjourC AS NbjourC_21,
  t0.UpdateNbj AS UpdateNbj_22,
  t0.enable AS enable_23,
  t0.addDate AS addDate_24,
  t0.photo AS photo_25,
  t0.com AS com_26,
  t0.repartition AS repartition_27,
  t0.cicle AS cicle_28,
  t0.lastadd AS lastadd_29,
  t0.rang AS rang_30,
  t0.matricule AS matricule_31,
  t0.type_contrat AS type_contrat_32,
  t0.nextcloud_path AS nextcloud_path_33,
  t0.nextcloud_share_url AS nextcloud_share_url_34,
  t0.poste_id AS poste_id_35,
  t0.categorie_professionnelle_id AS categorie_professionnelle_id_36,
  t0.departement_id AS departement_id_37,
  t0.manager_id AS manager_id_38
FROM
  travailleur t0
WHERE
  t0.userid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.userid = 2 LIMIT 1;

SELECT
    SUM(CASE WHEN a.validat = 'D' AND (a.prevalidate IS NULL OR a.prevalidate = 0) THEN 1 ELSE 0 END) AS attente,
    SUM(CASE WHEN a.validat = 'D' AND a.prevalidate IS NOT NULL AND a.prevalidate <> 0 THEN 1 ELSE 0 END) AS prevalide,
    SUM(CASE WHEN a.validat = 'V' AND (a.etatde IS NULL OR a.etatde = 0) THEN 1 ELSE 0 END) AS valide,
    SUM(CASE WHEN a.validat = 'V' AND a.etatde = 1 THEN 1 ELSE 0 END) AS decaisse
FROM decaissement a
WHERE a.enabled = 1 AND a.idutilisateur = ?

[
  "37"
]

SELECT
  SUM(
    CASE WHEN a.validat = 'D'
    AND (
      a.prevalidate IS NULL
      OR a.prevalidate = 0
    ) THEN 1 ELSE 0 END
  ) AS attente,
  SUM(
    CASE WHEN a.validat = 'D'
    AND a.prevalidate IS NOT NULL
    AND a.prevalidate <> 0 THEN 1 ELSE 0 END
  ) AS prevalide,
  SUM(
    CASE WHEN a.validat = 'V'
    AND (
      a.etatde IS NULL
      OR a.etatde = 0
    ) THEN 1 ELSE 0 END
  ) AS valide,
  SUM(
    CASE WHEN a.validat = 'V'
    AND a.etatde = 1 THEN 1 ELSE 0 END
  ) AS decaisse
FROM
  decaissement a
WHERE
  a.enabled = 1
  AND a.idutilisateur = ?

SELECT
    SUM(CASE WHEN a.validat = 'D' AND (a.prevalidate IS NULL OR a.prevalidate = 0) THEN 1 ELSE 0 END) AS attente,
    SUM(CASE WHEN a.validat = 'D' AND a.prevalidate IS NOT NULL AND a.prevalidate <> 0 THEN 1 ELSE 0 END) AS prevalide,
    SUM(CASE WHEN a.validat = 'V' AND (a.etatde IS NULL OR a.etatde = 0) THEN 1 ELSE 0 END) AS valide,
    SUM(CASE WHEN a.validat = 'V' AND a.etatde = 1 THEN 1 ELSE 0 END) AS decaisse
FROM decaissement a
WHERE a.enabled = 1 AND a.idutilisateur = '37';

SELECT a.id, a.libelle, a.decaissement, a.datetode, a.validat, a.etatde, a.prevalidate, a.imprevu,
       c.nomc, ca.idcaisse AS caisse_code
FROM decaissement a
LEFT JOIN caisse_type c ON a.modep = c.id
LEFT JOIN caisse ca ON ca.id = a.idcaisse
WHERE a.enabled = 1
  AND a.idutilisateur = ?
ORDER BY
  CASE
    WHEN a.validat = 'D' AND (a.prevalidate IS NULL OR a.prevalidate = 0) THEN 0
    WHEN a.validat = 'D' THEN 1
    WHEN a.validat = 'V' AND (a.etatde IS NULL OR a.etatde = 0) THEN 2
    ELSE 3
  END,
  COALESCE(a.datetode, a.datede) DESC,
  a.id DESC
LIMIT 8

[
  "37"
]

SELECT
  a.id,
  a.libelle,
  a.decaissement,
  a.datetode,
  a.validat,
  a.etatde,
  a.prevalidate,
  a.imprevu,
  c.nomc,
  ca.idcaisse AS caisse_code
FROM
  decaissement a
  LEFT JOIN caisse_type c ON a.modep = c.id
  LEFT JOIN caisse ca ON ca.id = a.idcaisse
WHERE
  a.enabled = 1
  AND a.idutilisateur = ?
ORDER BY
  CASE WHEN a.validat = 'D'
  AND (
    a.prevalidate IS NULL
    OR a.prevalidate = 0
  ) THEN 0 WHEN a.validat = 'D' THEN 1 WHEN a.validat = 'V'
  AND (
    a.etatde IS NULL
    OR a.etatde = 0
  ) THEN 2 ELSE 3 END,
  COALESCE(a.datetode, a.datede) DESC,
  a.id DESC
LIMIT
  8

SELECT a.id, a.libelle, a.decaissement, a.datetode, a.validat, a.etatde, a.prevalidate, a.imprevu,
       c.nomc, ca.idcaisse AS caisse_code
FROM decaissement a
LEFT JOIN caisse_type c ON a.modep = c.id
LEFT JOIN caisse ca ON ca.id = a.idcaisse
WHERE a.enabled = 1
  AND a.idutilisateur = '37'
ORDER BY
  CASE
    WHEN a.validat = 'D' AND (a.prevalidate IS NULL OR a.prevalidate = 0) THEN 0
    WHEN a.validat = 'D' THEN 1
    WHEN a.validat = 'V' AND (a.etatde IS NULL OR a.etatde = 0) THEN 2
    ELSE 3
  END,
  COALESCE(a.datetode, a.datede) DESC,
  a.id DESC
LIMIT 8;

SELECT COALESCE(SUM(a.decaissement), 0)
FROM decaissement a
WHERE a.enabled = 1
  AND a.idutilisateur = ?
  AND a.validat = 'D'

[
  "37"
]

SELECT
  COALESCE(
    SUM(a.decaissement),
    0
  )
FROM
  decaissement a
WHERE
  a.enabled = 1
  AND a.idutilisateur = ?
  AND a.validat = 'D'

SELECT COALESCE(SUM(a.decaissement), 0)
FROM decaissement a
WHERE a.enabled = 1
  AND a.idutilisateur = '37'
  AND a.validat = 'D';