Query Metrics
9
Database Queries
9
Different statements
5.27 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.65 ms (31.33%) |
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.ape AS ape_19, t14.siren AS siren_20, t14.capital AS capital_21, t14.effectif AS effectif_22, t14.implantation AS implantation_23, t14.creation AS creation_24, t14.modifiation AS modifiation_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.etat_id AS etat_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 FROM client t0 LEFT JOIN organisation t14 ON t14.client_id = t0.id WHERE t0.id IN (?)
Parameters:
[ [ 20 312 241 279 362 350 262 359 363 268 335 150 376 378 337 381 214 366 253 375 216 361 386 387 379 133 ] ] |
0.78 ms (14.80%) |
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:
[
129
]
|
0.53 ms (10.13%) |
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:
[
"rZJSKrNnINrO3kmcnMqWgAAjqCuvfyBYfcZgN8KdMOPavzmjEht8qCg0UYhgF7F95w="
]
|
0.48 ms (9.05%) |
1 |
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.date AS date_3, t0.titre AS titre_4, t0.commentaires AS commentaires_5, t0.niveau AS niveau_6, t0.a_paraitre AS a_paraitre_7, t0.inclure_ra AS inclure_ra_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.creation AS creation_11, t0.modification AS modification_12, t0.suivi_par_id AS suivi_par_id_13, t0.mutualisation_id AS mutualisation_id_14, t0.contact_id AS contact_id_15, t0.type_relation_id AS type_relation_id_16, t0.vecteur_id AS vecteur_id_17, t0.statut_id AS statut_id_18, t0.auteur_id AS auteur_id_19 FROM suivi t0 WHERE t0.id = ?
Parameters:
[
"4073"
]
|
0.47 ms (8.97%) |
1 |
SELECT t0.id AS id_1, t0.axe AS axe_2, t0.interesse AS interesse_3, t0.sujet AS sujet_4, t0.theme_itw AS theme_itw_5, t0.interlocuteur AS interlocuteur_6, t0.raison AS raison_7, t0.commentaire AS commentaire_8, t0.date_itw AS date_itw_9, t0.suivi_id AS suivi_id_10, t0.nature_id AS nature_id_11, t0.opportunites_client_id AS opportunites_client_id_12 FROM suivi_nature t0 WHERE t0.suivi_id = ?
Parameters:
[
4073
]
|
0.46 ms (8.82%) |
1 |
SELECT t0.id AS id_1, t0.ancien_id AS ancien_id_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.mode_envoi_pref AS mode_envoi_pref_5, t0.pieces_jointes AS pieces_jointes_6, t0.contact_perso AS contact_perso_7, t0.commentaires AS commentaires_8, t0.objet AS objet_9, t0.date_conclusion AS date_conclusion_10, t0.creation AS creation_11, t0.modification AS modification_12, t0.auteur_id AS auteur_id_13, t0.civilite_id AS civilite_id_14, t0.fonction_id AS fonction_id_15, t0.coordonnees_id AS coordonnees_id_16, t0.genre_id AS genre_id_17 FROM contact t0 WHERE t0.id = ?
Parameters:
[
885
]
|
0.33 ms (6.28%) |
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.28 ms (5.37%) |
1 |
SELECT t0.id AS id_1, t0.article AS article_2, t0.client_id AS client_id_3, t0.mailing_id AS mailing_id_4, t0.calendrier_redactionnel_id AS calendrier_redactionnel_id_5, t0.suivi_id AS suivi_id_6 FROM client_mailing_calendrier_redactionnel t0 WHERE t0.suivi_id = ?
Parameters:
[
4073
]
|
0.28 ms (5.25%) |
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:
[
[
99
]
]
|
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\Etat | No errors. |
App\Entity\CategoriesGenerales | No errors. |
App\Entity\Coordonnees | No errors. |
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\TypeRelationSuivi | No errors. |
App\Entity\VecteurSuivi | No errors. |
App\Entity\StatutSuivi | No errors. |
App\Entity\Support | No errors. |
App\Entity\SuiviNature | No errors. |
App\Entity\ClientMailingCalendrierRedactionnel | No errors. |
App\Entity\Fonction | No errors. |
App\Entity\Genre | No errors. |
App\Entity\SousCategoriesGenerales | No errors. |
App\Entity\Langues | No errors. |
App\Entity\Pays | No errors. |
App\Entity\ContactOrganisation | No errors. |
App\Entity\ContactSupport | No errors. |
App\Entity\NatureSuivi | No errors. |