Query Metrics
5
Database Queries
5
Different statements
2.47 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 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:
[
"IZ74iNcWSvAlV8OWFZhQdgzFKUKsjIEjzfFF5IfPErJXsaG9FCMUcLSTt9Os2Y8TX4="
]
|
| 2 | 0.58 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:
[
170
]
|
| 3 | 0.32 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:
[
[
2
]
]
|
| 4 | 0.30 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:
[
[
139
]
]
|
| 5 | 0.86 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:
[
[
123
272
389
403
]
]
|
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\Membre | No errors. |
| App\Entity\Support | No errors. |
| App\Entity\Emission | No errors. |
| App\Entity\ContactOrganisation | No errors. |
| App\Entity\ListeOrganisationOrganisation | No errors. |