Query Metrics
10
Database Queries
10
Different statements
5.85 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.54 ms |
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="
]
|
2 | 0.80 ms |
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
]
|
3 | 0.55 ms |
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
]
]
|
4 | 0.37 ms |
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
]
]
|
5 | 0.73 ms |
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 ] ] |
6 | 0.61 ms |
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
]
|
7 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.45 ms |
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 ] |
9 | 1.30 ms |
"COMMIT"
Parameters:
[] |
10 | 0.32 ms |
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
]
|
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 |
|
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 |
|
App\Entity\Mailling |
|
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. |