Query Metrics
11
Database Queries
7
Different statements
16.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.27 ms (82.79%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.89 ms (5.54%) |
3 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.timestamp AS timestamp_3, t0.dateDebut AS dateDebut_4, t0.dateFin AS dateFin_5, t0.id_objet AS id_objet_6, t0.objet AS objet_7, t0.action AS action_8, t0.ecriture AS ecriture_9, t0.utilisateur_id AS utilisateur_id_10 FROM commerciale__activite t0 WHERE t0.id = ?
Parameters:
[
"230"
]
|
|
0.65 ms (4.03%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.session_id AS session_id_7, t0.last_login AS last_login_8, t0.visible AS visible_9, t0.visible_agenda AS visible_agenda_10, t0.archive AS archive_11, t0.couleurAgenda AS couleurAgenda_12, t0.reference AS reference_13, t0.google_agenda AS google_agenda_14, t0.badge AS badge_15, t0.receptionner AS receptionner_16, t0.fabriquer AS fabriquer_17, t0.preparer AS preparer_18, t0.emballer AS emballer_19, t0.signature_mail AS signature_mail_20, t0.date AS date_21, t0.date_maj AS date_maj_22, t0.date_supression AS date_supression_23, t0.telephone AS telephone_24, t0.skype AS skype_25, t0.type_menu AS type_menu_26, t0.toolbar_closed AS toolbar_closed_27, t0.mouvemente_recherche_article AS mouvemente_recherche_article_28, t0.tri_recherche_article AS tri_recherche_article_29, t0.ordre_tri_recherche_article AS ordre_tri_recherche_article_30, t0.id_import AS id_import_31, t0.type_id AS type_id_32 FROM utilisateur__utilisateurs t0 WHERE t0.id = ? AND ((t0.date_supression IS NULL))
Parameters:
[
3
]
|
|
0.44 ms (2.72%) |
1 |
SELECT c0_.id AS id_0, c0_.url AS url_1, c0_.timestamp AS timestamp_2, c0_.dateDebut AS dateDebut_3, c0_.dateFin AS dateFin_4, c0_.id_objet AS id_objet_5, c0_.objet AS objet_6, c0_.action AS action_7, c0_.ecriture AS ecriture_8, c0_.utilisateur_id AS utilisateur_id_9 FROM commerciale__activite c0_ WHERE c0_.objet = ? AND c0_.action = ? AND c0_.id_objet = ? AND c0_.dateFin IS NULL AND c0_.utilisateur_id <> ? GROUP BY c0_.utilisateur_id ORDER BY c0_.id DESC
Parameters:
[ "Commande" "modifier" 65 3 ] |
|
0.28 ms (1.77%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.27 ms (1.70%) |
1 |
UPDATE commerciale__activite SET timestamp = ? WHERE id = ?
Parameters:
[ "2025-12-15 13:09:40" 230 ] |
|
0.23 ms (1.44%) |
1 |
UPDATE commerciale__activite SET dateFin = ? WHERE id = ?
Parameters:
[ null 230 ] |
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.