Query Metrics
6
Database Queries
6
Different statements
5.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.55 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:
[
"hipQPW3AgReq64enLog7IYJ9blbMxYmC340LOdpTZquYUboVMlizUP1HMz0ZNkOuHk="
]
|
| 2 | 1.04 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 FROM auth_user t0 LEFT JOIN user t16 ON t0.user_id = t16.id WHERE t0.id = ?
Parameters:
[
85
]
|
| 3 | 0.64 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:
[
3
]
|
| 4 | 0.92 ms |
SELECT t0.id AS id_1, t0.role AS role_2, t0.adresse_coupure AS adresse_coupure_3, t0.adresse_generique AS adresse_generique_4, t0.color AS color_5, t0.id_client AS id_client_6, t7.id AS id_8, t7.nom AS nom_9, t7.adresse_generique AS adresse_generique_10, t7.adresse_coupure AS adresse_coupure_11, t7.actuel AS actuel_12, t7.ancien_id AS ancien_id_13, t7.dirigeant AS dirigeant_14, t7.date_entree AS date_entree_15, t7.date_sortie AS date_sortie_16, t7.duree AS duree_17, t7.score AS score_18, t7.logo_id AS logo_id_19, t7.pressroom_client AS pressroom_client_20, t7.etat_id AS etat_id_21, t7.liste_journaliste_interview_article_id AS liste_journaliste_interview_article_id_22, t0.id_user AS id_user_23 FROM client_role_user t0 LEFT JOIN client t7 ON t0.id_client = t7.id WHERE t0.id_user IN (?)
Parameters:
[
85
]
|
| 5 | 0.40 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:
[
60
]
|
| 6 | 0.61 ms |
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.dernier_import AS dernier_import_13, t0.auteur_id AS auteur_id_14, t0.civilite_id AS civilite_id_15, t0.fonction_id AS fonction_id_16, t0.coordonnees_id AS coordonnees_id_17, t0.genre_id AS genre_id_18, t0.reseaux_sociaux_id AS reseaux_sociaux_id_19 FROM contact t0 WHERE t0.id = ?
Parameters:
[
"281517"
]
|
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.