Query Metrics
6
Database Queries
6
Different statements
6.48 ms
Query time
7
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.55 ms |
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
]
|
| 2 | 0.34 ms |
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
]
|
| 3 | 0.50 ms |
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 ] |
| 4 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.36 ms |
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 ] |
| 6 | 4.57 ms |
"COMMIT"
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 |
|