Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.mail AS mail_2, t0.roles AS roles_3, t0.password AS password_4, t0.cree_le AS cree_le_5, t0.maj_le AS maj_le_6, t0.date_activation AS date_activation_7, t0.date_expiration AS date_expiration_8, t0.rgpd_validation AS rgpd_validation_9, t0.date_validation_rgpd AS date_validation_rgpd_10, t0.date_derniere_connexion AS date_derniere_connexion_11, t0.organisation AS organisation_12, t0.is_verified AS is_verified_13, t0.raison_demande_compte AS raison_demande_compte_14, t0.cree_par_id AS cree_par_id_15, t0.maj_par_id AS maj_par_id_16, t0.statut_utilisateur_id AS statut_utilisateur_id_17, t0.contact_id AS contact_id_18, t0.role_user_id AS role_user_id_19 FROM utilisateur t0 WHERE t0.id = ?

[
  130
]

SELECT
  t0.id AS id_1,
  t0.mail AS mail_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.cree_le AS cree_le_5,
  t0.maj_le AS maj_le_6,
  t0.date_activation AS date_activation_7,
  t0.date_expiration AS date_expiration_8,
  t0.rgpd_validation AS rgpd_validation_9,
  t0.date_validation_rgpd AS date_validation_rgpd_10,
  t0.date_derniere_connexion AS date_derniere_connexion_11,
  t0.organisation AS organisation_12,
  t0.is_verified AS is_verified_13,
  t0.raison_demande_compte AS raison_demande_compte_14,
  t0.cree_par_id AS cree_par_id_15,
  t0.maj_par_id AS maj_par_id_16,
  t0.statut_utilisateur_id AS statut_utilisateur_id_17,
  t0.contact_id AS contact_id_18,
  t0.role_user_id AS role_user_id_19
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.mail AS mail_2, t0.roles AS roles_3, t0.password AS password_4, t0.cree_le AS cree_le_5, t0.maj_le AS maj_le_6, t0.date_activation AS date_activation_7, t0.date_expiration AS date_expiration_8, t0.rgpd_validation AS rgpd_validation_9, t0.date_validation_rgpd AS date_validation_rgpd_10, t0.date_derniere_connexion AS date_derniere_connexion_11, t0.organisation AS organisation_12, t0.is_verified AS is_verified_13, t0.raison_demande_compte AS raison_demande_compte_14, t0.cree_par_id AS cree_par_id_15, t0.maj_par_id AS maj_par_id_16, t0.statut_utilisateur_id AS statut_utilisateur_id_17, t0.contact_id AS contact_id_18, t0.role_user_id AS role_user_id_19 FROM utilisateur t0 WHERE t0.id = 130;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.cree_le AS cree_le_4, t0.maj_le AS maj_le_5, t0.civilite_id AS civilite_id_6, t0.cree_par_id AS cree_par_id_7, t0.maj_par_id AS maj_par_id_8 FROM contact t0 WHERE t0.id = ?

[
  48136
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.cree_le AS cree_le_4,
  t0.maj_le AS maj_le_5,
  t0.civilite_id AS civilite_id_6,
  t0.cree_par_id AS cree_par_id_7,
  t0.maj_par_id AS maj_par_id_8
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.cree_le AS cree_le_4, t0.maj_le AS maj_le_5, t0.civilite_id AS civilite_id_6, t0.cree_par_id AS cree_par_id_7, t0.maj_par_id AS maj_par_id_8 FROM contact t0 WHERE t0.id = 48136;

SELECT t0.id AS id_1, t0.mail_parcours AS mail_parcours_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.fonction AS fonction_5, t0.cree_le AS cree_le_6, t0.maj_le AS maj_le_7, t0.telephone AS telephone_8, t0.telephone_portable AS telephone_portable_9, t0.parcours_principal AS parcours_principal_10, t0.parcours_desactive AS parcours_desactive_11, t0.cree_par_id AS cree_par_id_12, t0.maj_par_id AS maj_par_id_13, t0.contact_id AS contact_id_14, t0.entite_id AS entite_id_15, t0.manager_id AS manager_id_16 FROM parcours_utilisateur t0 WHERE t0.contact_id = ?

[
  48136
]

SELECT
  t0.id AS id_1,
  t0.mail_parcours AS mail_parcours_2,
  t0.date_entree AS date_entree_3,
  t0.date_sortie AS date_sortie_4,
  t0.fonction AS fonction_5,
  t0.cree_le AS cree_le_6,
  t0.maj_le AS maj_le_7,
  t0.telephone AS telephone_8,
  t0.telephone_portable AS telephone_portable_9,
  t0.parcours_principal AS parcours_principal_10,
  t0.parcours_desactive AS parcours_desactive_11,
  t0.cree_par_id AS cree_par_id_12,
  t0.maj_par_id AS maj_par_id_13,
  t0.contact_id AS contact_id_14,
  t0.entite_id AS entite_id_15,
  t0.manager_id AS manager_id_16
FROM
  parcours_utilisateur t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.mail_parcours AS mail_parcours_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.fonction AS fonction_5, t0.cree_le AS cree_le_6, t0.maj_le AS maj_le_7, t0.telephone AS telephone_8, t0.telephone_portable AS telephone_portable_9, t0.parcours_principal AS parcours_principal_10, t0.parcours_desactive AS parcours_desactive_11, t0.cree_par_id AS cree_par_id_12, t0.maj_par_id AS maj_par_id_13, t0.contact_id AS contact_id_14, t0.entite_id AS entite_id_15, t0.manager_id AS manager_id_16 FROM parcours_utilisateur t0 WHERE t0.contact_id = 48136;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3 FROM crm_api_coupe_circuit t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.actif AS actif_3
FROM
  crm_api_coupe_circuit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3 FROM crm_api_coupe_circuit t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  crm_type_odm_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_calendrier_statut t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  crm_type_calendrier_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_calendrier_statut t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_calendrier_statut t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  crm_type_calendrier_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_calendrier_statut t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  crm_type_odm_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  crm_type_odm_statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM crm_type_odm_statut t0 WHERE t0.id = 2;

SELECT count(c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.statut_id = ? AND c0_.calendrier_statut_id NOT IN (?, ?) AND EXTRACT(YEAR FROM c0_.date_debut) = ? AND EXTRACT(MONTH FROM c0_.date_debut) = ? AND c0_.demandeur_id = ?

[
  3
  3
  2
  2024
  11
  60756
]

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_odm c0_
WHERE
  c0_.statut_id = ?
  AND c0_.calendrier_statut_id NOT IN (?, ?)
  AND EXTRACT(
    YEAR
    FROM
      c0_.date_debut
  ) = ?
  AND EXTRACT(
    MONTH
    FROM
      c0_.date_debut
  ) = ?
  AND c0_.demandeur_id = ?

SELECT count(c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.statut_id = 3 AND c0_.calendrier_statut_id NOT IN (3, 2) AND EXTRACT(YEAR FROM c0_.date_debut) = 2024 AND EXTRACT(MONTH FROM c0_.date_debut) = 11 AND c0_.demandeur_id = 60756;

SELECT count(c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.statut_id IN (?, ?) AND EXTRACT(YEAR FROM c0_.date_debut) = ? AND EXTRACT(MONTH FROM c0_.date_debut) = ? AND c0_.demandeur_id = ?

[
  1
  2
  2024
  11
  60756
]

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_odm c0_
WHERE
  c0_.statut_id IN (?, ?)
  AND EXTRACT(
    YEAR
    FROM
      c0_.date_debut
  ) = ?
  AND EXTRACT(
    MONTH
    FROM
      c0_.date_debut
  ) = ?
  AND c0_.demandeur_id = ?

SELECT count(c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.statut_id IN (1, 2) AND EXTRACT(YEAR FROM c0_.date_debut) = 2024 AND EXTRACT(MONTH FROM c0_.date_debut) = 11 AND c0_.demandeur_id = 60756;

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.demandeur_id = ? AND ((YEAR(c0_.date_debut) = ? AND MONTH(c0_.date_debut) = ?) OR (YEAR(c0_.date_fin) = ? AND MONTH(c0_.date_fin) = ?))

[
  60756
  "2024"
  "11"
  "2024"
  "11"
]

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  crm_odm c0_
WHERE
  c0_.demandeur_id = ?
  AND (
    (
      YEAR(c0_.date_debut) = ?
      AND MONTH(c0_.date_debut) = ?
    )
    OR (
      YEAR(c0_.date_fin) = ?
      AND MONTH(c0_.date_fin) = ?
    )
  )

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.demandeur_id = 60756 AND ((YEAR(c0_.date_debut) = '2024' AND MONTH(c0_.date_debut) = '11') OR (YEAR(c0_.date_fin) = '2024' AND MONTH(c0_.date_fin) = '11'));

SELECT DISTINCT c0_.id AS id_0 FROM crm_odm c0_ WHERE c0_.demandeur_id = ? AND ((YEAR(c0_.date_debut) = ? AND MONTH(c0_.date_debut) = ?) OR (YEAR(c0_.date_fin) = ? AND MONTH(c0_.date_fin) = ?)) LIMIT 5

[
  60756
  "2024"
  "11"
  "2024"
  "11"
]

SELECT
  DISTINCT c0_.id AS id_0
FROM
  crm_odm c0_
WHERE
  c0_.demandeur_id = ?
  AND (
    (
      YEAR(c0_.date_debut) = ?
      AND MONTH(c0_.date_debut) = ?
    )
    OR (
      YEAR(c0_.date_fin) = ?
      AND MONTH(c0_.date_fin) = ?
    )
  )
LIMIT
  5

SELECT DISTINCT c0_.id AS id_0 FROM crm_odm c0_ WHERE c0_.demandeur_id = 60756 AND ((YEAR(c0_.date_debut) = '2024' AND MONTH(c0_.date_debut) = '11') OR (YEAR(c0_.date_fin) = '2024' AND MONTH(c0_.date_fin) = '11')) LIMIT 5;