Query Metrics
3
Database Queries
3
Different statements
2.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.05 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.type_menu_id AS type_menu_id_4, t0.acces_client_id AS acces_client_id_5, t0.acces_prospect_id AS acces_prospect_id_6, t0.acces_ressource_m_id AS acces_ressource_m_id_7, t0.acces_candidat_id AS acces_candidat_id_8, t0.acces_collaborateur_id AS acces_collaborateur_id_9, t0.acces_action_id AS acces_action_id_10, t0.acces_expert_comptable_id AS acces_expert_comptable_id_11, t0.acces_donnees_id AS acces_donnees_id_12 FROM profil t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"CHARGE-D'AFFAIRES"
]
|
| 2 | 0.43 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.numero_matricule AS numero_matricule_6, t0.invisible AS invisible_7, t0.temporaire AS temporaire_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.profil_id AS profil_id_11, t0.personne_id AS personne_id_12, t0.action_id AS action_id_13, t0.client_id AS client_id_14, t0.interlocuteur_id AS interlocuteur_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 3 | 0.68 ms |
SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.titre AS titre_2, m0_.created_at AS created_at_3, m0_.date AS date_4, m0_.auteur_id AS auteur_id_5 FROM memo m0_ WHERE EXISTS (SELECT 1 FROM memo_personne m1_ WHERE m1_.memo_id = m0_.id AND m1_.personne_id IN (?)) AND NOT EXISTS (SELECT 1 FROM memo_user m2_ WHERE m2_.memo_id = m0_.id AND m2_.user_id IN (?)) ORDER BY m0_.created_at ASC
Parameters:
[ 1 11 ] |
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.