Query Metrics
6
Database Queries
6
Different statements
6.48 ms
Query time
7
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.57 ms (70.53%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.55 ms (8.42%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.usercode AS usercode_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.telephone AS telephone_8, t0.lastvisit AS lastvisit_9, t0.lastip AS lastip_10, t0.password_request AS password_request_11, t0.password_request_at AS password_request_at_12, t0.password_updated_at AS password_updated_at_13, t0.point_vente_id AS point_vente_id_14, t0.region_id AS region_id_15 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
127
]
|
|
0.50 ms (7.75%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.validated AS validated_3, t0.status AS status_4, t0.created_by_id AS created_by_id_5, t0.validated_by_id AS validated_by_id_6, t0.point_vente_id AS point_vente_id_7, t0.declaration_id AS declaration_id_8, t0.region_id AS region_id_9 FROM annulation_vente t0 WHERE t0.status = ? AND t0.declaration_id = ? AND t0.point_vente_id = ?
Parameters:
[ 0 377211 230 ] |
|
0.36 ms (5.62%) |
1 |
INSERT INTO annulation_vente (created, validated, status, created_by_id, validated_by_id, point_vente_id, declaration_id, region_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-01-19 09:47:34" null 0 127 null 230 377211 6 ] |
|
0.34 ms (5.21%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
377211
]
|
|
0.16 ms (2.47%) |
1 |
"START TRANSACTION"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
| App\Entity\PointVente | 1 |
| App\Entity\Region | 1 |
| App\Entity\DeclarationVente | 1 |
| App\Entity\AnnulationVente | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User |
|
| App\Entity\PointVente |
|
| App\Entity\Region |
|
| App\Entity\DeclarationVente | No errors. |
| App\Entity\DeclarationCommande | No errors. |
| App\Entity\Vente |
|
| App\Entity\Commande | No errors. |
| App\Entity\AnnulationVente |
|
| App\Entity\PasswordRequest | No errors. |
| App\Entity\Prix | No errors. |
| App\Entity\Affectation | No errors. |
| App\Entity\DeclarationVenteHistorique |
|
| App\Entity\ProduitDemande |
|