Query Metrics
9
Database Queries
9
Different statements
3.45 ms
Query time
9
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.66 ms (19.18%) |
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:
[
168
]
|
0.63 ms (18.32%) |
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:
[ [ 214 216 401 402 397 411 399 ] ] |
0.54 ms (15.77%) |
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:
[
"TIAQQOuWlwHouhfvymf8hk4AuZXcIa7zsQAmm3nl18YJ1i4qclDaasfSIEQu1Eo8="
]
|
0.47 ms (13.59%) |
1 |
SELECT v0_.id AS id_0, v0_.thematique_id AS thematique_id_1, v0_.veille_id AS veille_id_2 FROM veille_thematique v0_ WHERE v0_.id = ?
Parameters:
[
31542
]
|
0.30 ms (8.81%) |
1 |
INSERT INTO element_veille (titre, liens, veille_thematique) VALUES (?, ?, ?)
Parameters:
[ 1 => "Fuite de données : 184 millions de mots de passe Netflix, Facebook et Paypal en danger" 2 => "https://www.msn.com/fr-fr/actualite/technologie-et-sciences/fuite-de-donn%C3%A9es-184-millions-de-mots-de-passe-netflix-facebook-et-paypal-en-danger/ar-AA1H0SAK?apiversion=v2&noservercache=1&domshim=1&renderwebcomponents=1&wcseo=1&batchservertelemetry=1&noservertelemetry=1" 3 => 31542 ] |
0.30 ms (8.69%) |
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:
[
[
3
]
]
|
0.29 ms (8.32%) |
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:
[
[
137
]
]
|
0.14 ms (4.17%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.11 ms (3.13%) |
1 |
"ROLLBACK"
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 |
|
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. |
App\Entity\VeilleThematique |
|
App\Entity\Thematique | No errors. |
App\Entity\Veille |
|
App\Entity\ElementVeille | No errors. |
App\Entity\GroupeUser | No errors. |
App\Entity\Salle |
|
App\Entity\TypeRelationSuivi | No errors. |
App\Entity\VecteurSuivi | No errors. |
App\Entity\StatutSuivi | No errors. |
App\Entity\SuiviNature | No errors. |
App\Entity\ClientMailingCalendrierRedactionnel | No errors. |
App\Entity\EvenementMetier | No errors. |
App\Entity\Fonction | No errors. |
App\Entity\SousCategoriesGenerales | No errors. |
App\Entity\Langues | No errors. |
App\Entity\Pays | No errors. |
App\Entity\ContactSupport | No errors. |
App\Entity\ReseauxSociaux | No errors. |
App\Entity\ListeContactContact | No errors. |
App\Entity\Pressroom\ImagePressroom | No errors. |
App\Entity\Pressroom\PressroomAccueil |
|
App\Entity\Pressroom\PressroomCommunique | No errors. |
App\Entity\Pressroom\PressroomArticle | No errors. |
App\Entity\Pressroom\PressroomEvenement | No errors. |
App\Entity\PieceJointeMailling | No errors. |
App\Entity\SuivitOuvertureMailling |
|
App\Entity\PartieCp |
|
App\Entity\Pdf | No errors. |
App\Entity\PhotoMailling | No errors. |
App\Entity\LogoMailling | No errors. |
App\Entity\CategorieDesMotsCles | No errors. |
App\Entity\SousCategorieDesMotsCles | No errors. |
App\Entity\Casier | No errors. |
App\Entity\TypeMedia | No errors. |
App\Entity\Famille | No errors. |
App\Entity\Periodicite | No errors. |
App\Entity\TypeOJD | No errors. |
App\Entity\ZoneDiffusion | No errors. |
App\Entity\Secteur | No errors. |
App\Entity\LogoSupport | No errors. |
App\Entity\ListeOrganisation | No errors. |