Symfony Profiler

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

Query Metrics

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.password AS password_3, u0_.nb_post AS nb_post_4, u0_.role AS role_5, u0_.avatar_url AS avatar_url_6, u0_.date_create AS date_create_7, u0_.date_update AS date_update_8, u0_.civilite AS civilite_9, u0_.prenom AS prenom_10, u0_.nom AS nom_11, u0_.organisme AS organisme_12, u0_.telephone_perso AS telephone_perso_13, u0_.annee_naissance AS annee_naissance_14, u0_.biographie AS biographie_15, u0_.activites AS activites_16, u0_.numero_adherent AS numero_adherent_17, u0_.banned AS banned_18, u0_.opt_in AS opt_in_19, u0_.actif AS actif_20, u0_.referent AS referent_21, u0_.anonyme AS anonyme_22, u0_.newsletter AS newsletter_23, u0_.fiche_individuelle_id AS fiche_individuelle_id_24, u0_.date_expiration AS date_expiration_25, u0_.paiement AS paiement_26, u0_.formule AS formule_27, u0_.adresse AS adresse_28, u0_.codepostal AS codepostal_29, u0_.ville AS ville_30, u0_.pays AS pays_31, u0_.dolibarr_id AS dolibarr_id_32, u0_.date_fin_validite AS date_fin_validite_33, u0_.statut_adhesion AS statut_adhesion_34, u0_.image_name AS image_name_35, u0_.parcours_pro AS parcours_pro_36, u0_.password_token AS password_token_37, u0_.attente_validation AS attente_validation_38, u0_.referent_user_id AS referent_user_id_39, u0_.entreprise_id AS entreprise_id_40, u0_.newsletter_jour_id AS newsletter_jour_id_41 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE ? AND u0_.date_fin_validite >= ? ORDER BY u0_.nom ASC

[
  "%.adbs"
  "2025-01-18 01:49:55"
]

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.password AS password_3,
  u0_.nb_post AS nb_post_4,
  u0_.role AS role_5,
  u0_.avatar_url AS avatar_url_6,
  u0_.date_create AS date_create_7,
  u0_.date_update AS date_update_8,
  u0_.civilite AS civilite_9,
  u0_.prenom AS prenom_10,
  u0_.nom AS nom_11,
  u0_.organisme AS organisme_12,
  u0_.telephone_perso AS telephone_perso_13,
  u0_.annee_naissance AS annee_naissance_14,
  u0_.biographie AS biographie_15,
  u0_.activites AS activites_16,
  u0_.numero_adherent AS numero_adherent_17,
  u0_.banned AS banned_18,
  u0_.opt_in AS opt_in_19,
  u0_.actif AS actif_20,
  u0_.referent AS referent_21,
  u0_.anonyme AS anonyme_22,
  u0_.newsletter AS newsletter_23,
  u0_.fiche_individuelle_id AS fiche_individuelle_id_24,
  u0_.date_expiration AS date_expiration_25,
  u0_.paiement AS paiement_26,
  u0_.formule AS formule_27,
  u0_.adresse AS adresse_28,
  u0_.codepostal AS codepostal_29,
  u0_.ville AS ville_30,
  u0_.pays AS pays_31,
  u0_.dolibarr_id AS dolibarr_id_32,
  u0_.date_fin_validite AS date_fin_validite_33,
  u0_.statut_adhesion AS statut_adhesion_34,
  u0_.image_name AS image_name_35,
  u0_.parcours_pro AS parcours_pro_36,
  u0_.password_token AS password_token_37,
  u0_.attente_validation AS attente_validation_38,
  u0_.referent_user_id AS referent_user_id_39,
  u0_.entreprise_id AS entreprise_id_40,
  u0_.newsletter_jour_id AS newsletter_jour_id_41
FROM
  `user` u0_
WHERE
  u0_.actif = 1
  AND u0_.statut_adhesion = 'valide'
  AND u0_.anonyme = 0
  AND u0_.email NOT LIKE ?
  AND u0_.date_fin_validite >= ?
ORDER BY
  u0_.nom ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.password AS password_3, u0_.nb_post AS nb_post_4, u0_.role AS role_5, u0_.avatar_url AS avatar_url_6, u0_.date_create AS date_create_7, u0_.date_update AS date_update_8, u0_.civilite AS civilite_9, u0_.prenom AS prenom_10, u0_.nom AS nom_11, u0_.organisme AS organisme_12, u0_.telephone_perso AS telephone_perso_13, u0_.annee_naissance AS annee_naissance_14, u0_.biographie AS biographie_15, u0_.activites AS activites_16, u0_.numero_adherent AS numero_adherent_17, u0_.banned AS banned_18, u0_.opt_in AS opt_in_19, u0_.actif AS actif_20, u0_.referent AS referent_21, u0_.anonyme AS anonyme_22, u0_.newsletter AS newsletter_23, u0_.fiche_individuelle_id AS fiche_individuelle_id_24, u0_.date_expiration AS date_expiration_25, u0_.paiement AS paiement_26, u0_.formule AS formule_27, u0_.adresse AS adresse_28, u0_.codepostal AS codepostal_29, u0_.ville AS ville_30, u0_.pays AS pays_31, u0_.dolibarr_id AS dolibarr_id_32, u0_.date_fin_validite AS date_fin_validite_33, u0_.statut_adhesion AS statut_adhesion_34, u0_.image_name AS image_name_35, u0_.parcours_pro AS parcours_pro_36, u0_.password_token AS password_token_37, u0_.attente_validation AS attente_validation_38, u0_.referent_user_id AS referent_user_id_39, u0_.entreprise_id AS entreprise_id_40, u0_.newsletter_jour_id AS newsletter_jour_id_41 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE '%.adbs' AND u0_.date_fin_validite >= '2025-01-18 01:49:55' ORDER BY u0_.nom ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.alias AS alias_4, t0.groupe_id AS groupe_id_5 FROM segment t0 WHERE t0.type = ? ORDER BY t0.name ASC

[
  "Secteur"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.alias AS alias_4,
  t0.groupe_id AS groupe_id_5
FROM
  segment t0
WHERE
  t0.type = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.alias AS alias_4, t0.groupe_id AS groupe_id_5 FROM segment t0 WHERE t0.type = 'Secteur' ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.numero AS numero_3, t0.alias AS alias_4 FROM departement t0 ORDER BY t0.numero ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.numero AS numero_3,
  t0.alias AS alias_4
FROM
  departement t0
ORDER BY
  t0.numero ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.numero AS numero_3, t0.alias AS alias_4 FROM departement t0 ORDER BY t0.numero ASC;

SELECT DISTINCT u0_.pays AS pays_0 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE ? ORDER BY u0_.pays ASC

[
  "%.adbs"
]

SELECT
  DISTINCT u0_.pays AS pays_0
FROM
  `user` u0_
WHERE
  u0_.actif = 1
  AND u0_.statut_adhesion = 'valide'
  AND u0_.anonyme = 0
  AND u0_.email NOT LIKE ?
ORDER BY
  u0_.pays ASC

SELECT DISTINCT u0_.pays AS pays_0 FROM `user` u0_ WHERE u0_.actif = 1 AND u0_.statut_adhesion = 'valide' AND u0_.anonyme = 0 AND u0_.email NOT LIKE '%.adbs' ORDER BY u0_.pays ASC;