https://api.escalnet.escalconsulting.com/api/email_retours Return to referer URL

Query Metrics

10 Database Queries
10 Different statements
5.85 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.30 ms
(22.30%)
1
"COMMIT"
Parameters:
[]
0.80 ms
(13.60%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.password_mail AS password_mail_3, t0.password AS password_4, t0.roles AS roles_5, t0.old_login AS old_login_6, t0.old_password AS old_password_7, t0.actuel AS actuel_8, t0.fonction AS fonction_9, t0.date_arrive AS date_arrive_10, t0.tel_interne AS tel_interne_11, t0.adresse_envoi AS adresse_envoi_12, t0.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_13, t0.u_systeme AS u_systeme_14, t0.user_id AS user_id_15, t16.id AS id_17, t16.prenom AS prenom_18, t16.nom AS nom_19, t16.email AS email_20, t16.resp_conge AS resp_conge_21, t16.tel AS tel_22, t16.civilite AS civilite_23, t16.id_adress AS id_adress_24, t25.id AS id_26, t25.role AS role_27, t25.adresse_coupure AS adresse_coupure_28, t25.adresse_generique AS adresse_generique_29, t25.color AS color_30, t25.id_client AS id_client_31, t25.id_user AS id_user_32 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id LEFT JOIN client_role_user t25 ON t25.id_user = t0.id WHERE t0.id = ?
Parameters:
[
  166
]
0.73 ms
(12.41%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse_generique AS adresse_generique_3, t0.adresse_coupure AS adresse_coupure_4, t0.actuel AS actuel_5, t0.ancien_id AS ancien_id_6, t0.dirigeant AS dirigeant_7, t0.date_entree AS date_entree_8, t0.date_sortie AS date_sortie_9, t0.duree AS duree_10, t0.score AS score_11, t0.logo_id AS logo_id_12, t0.pressroom_client AS pressroom_client_13, t14.id AS id_15, t14.ancien_id AS ancien_id_16, t14.nom AS nom_17, t14.date_creation AS date_creation_18, t14.siren AS siren_19, t14.capital AS capital_20, t14.effectif AS effectif_21, t14.implantation AS implantation_22, t14.commentaires AS commentaires_23, t14.creation AS creation_24, t14.modification AS modification_25, t14.auteur_id AS auteur_id_26, t14.appartenir_a_id AS appartenir_a_id_27, t14.client_id AS client_id_28, t14.forme_juridique_id AS forme_juridique_id_29, t14.genre_id AS genre_id_30, t14.categorie_generale_id AS categorie_generale_id_31, t14.coordonnees_id AS coordonnees_id_32, t14.dirigeant_id AS dirigeant_id_33, t14.ape_id AS ape_id_34, t0.etat_id AS etat_id_35 FROM client t0 LEFT JOIN organisation t14 ON t14.client_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  [
    272
    389
    123
    345
  ]
]
0.61 ms
(10.35%)
1
SELECT a0_.id AS id_0, a0_.username AS username_1, a0_.password_mail AS password_mail_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.old_login AS old_login_5, a0_.old_password AS old_password_6, a0_.actuel AS actuel_7, a0_.fonction AS fonction_8, a0_.date_arrive AS date_arrive_9, a0_.tel_interne AS tel_interne_10, a0_.adresse_envoi AS adresse_envoi_11, a0_.count_email_verifier_existant_adelete AS count_email_verifier_existant_adelete_12, a0_.u_systeme AS u_systeme_13, a0_.user_id AS user_id_14 FROM auth_user a0_ WHERE a0_.id = ?
Parameters:
[
  166
]
0.55 ms
(9.36%)
1
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.libelle AS libelle_3, t0.genre AS genre_4 FROM civilite t0 WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
0.54 ms
(9.30%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.auth_user_id AS auth_user_id_4 FROM auth_tokens t0 WHERE t0.value = ? LIMIT 1
Parameters:
[
  "uEE26XJDYXuuigbZlCNpIkDcjalQYE3tILItB7Qd4OmIzPACrB3zUiYaDknASiDP5o="
]
0.45 ms
(7.73%)
1
INSERT INTO email_retour (email, raison, date_erreur, date_absence, mailing_id, contact_id, authUser_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "benjamin.veisse@nextep-health.com"
  2 => "autre"
  3 => "2025-02-24 09:42:41"
  4 => null
  5 => null
  6 => null
  7 => 166
]
0.37 ms
(6.24%)
1
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.ville AS ville_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.complement AS complement_6 FROM adresse t0 WHERE t0.id IN (?)
Parameters:
[
  [
    136
  ]
]
0.32 ms
(5.56%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.raison AS raison_3, t0.date_erreur AS date_erreur_4, t0.date_absence AS date_absence_5, t0.mailing_id AS mailing_id_6, t0.contact_id AS contact_id_7, t0.authUser_id AS authUser_id_8 FROM email_retour t0 WHERE t0.id = ?
Parameters:
[
  2563730
]
0.19 ms
(3.16%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Auth\AuthToken No errors.
App\Entity\Auth\AuthUser No errors.
App\Entity\User No errors.
App\Entity\Civilite No errors.
App\Entity\Adresse No errors.
App\Entity\ClientRoleUser No errors.
App\Entity\Client
  • The field App\Entity\Client#evenements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Evenement#client does not contain the required 'inversedBy="evenements"' attribute.
App\Entity\AuthUserGroupeUser No errors.
App\Entity\Evenement No errors.
App\Entity\Suivi No errors.
App\Entity\Contact No errors.
App\Entity\Logo No errors.
App\Entity\Pressroom No errors.
App\Entity\Organisation No errors.
App\Entity\FormeJuridique No errors.
App\Entity\Genre No errors.
App\Entity\CategoriesGenerales No errors.
App\Entity\Coordonnees No errors.
App\Entity\CodeApe No errors.
App\Entity\Etat
  • The association App\Entity\Etat#organisations refers to the owning side field App\Entity\Organisation#etat which does not exist.
App\Entity\Mailling
  • The mappings App\Entity\Mailling#partiesCp and App\Entity\PartieCp#mailling are inconsistent with each other.
App\Entity\ClientPersonne No errors.
App\Entity\MotsCles No errors.
App\Entity\Documents No errors.
App\Entity\CalendrierRedactionnel No errors.
App\Entity\Support No errors.
App\Entity\Emission No errors.
App\Entity\ContactOrganisation No errors.
App\Entity\Email\EmailRetour No errors.