Query Metrics
13
Database Queries
10
Different statements
262.45 ms
Query time
0
Invalid entities
259
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
79.98 ms (30.47%) |
3 |
SELECT t0.id AS id_1, t0.parametre AS parametre_2, t0.valeur AS valeur_3 FROM configuration t0 WHERE t0.parametre = ? LIMIT 1
Parameters:
[
"vendeurReferentPrimaire"
]
|
|
28.84 ms (10.99%) |
2 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.position AS position_2, p0_.marque_id AS marque_id_3 FROM produit p0_ WHERE p0_.id IN (?)
Parameters:
[
"382"
]
|
|
28.24 ms (10.76%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
27.27 ms (10.39%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.filtre AS filtre_3, t0.filtre_secondaire AS filtre_secondaire_4, t0.methode AS methode_5, t0.etat AS etat_6, t0.commentaire AS commentaire_7 FROM vendeur t0
Parameters:
[] |
|
26.70 ms (10.17%) |
1 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.position AS position_2, p0_.marque_id AS marque_id_3 FROM produit p0_ ORDER BY p0_.position ASC
Parameters:
[] |
|
15.28 ms (5.82%) |
1 |
SELECT v0_.id AS id_0, v0_.nom AS nom_1, v0_.filtre AS filtre_2, v0_.filtre_secondaire AS filtre_secondaire_3, v0_.methode AS methode_4, v0_.etat AS etat_5, v0_.commentaire AS commentaire_6 FROM vendeur v0_
Parameters:
[] |
|
14.44 ms (5.50%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.position AS position_3, t0.marque_id AS marque_id_4 FROM produit t0 WHERE t0.id IN (?)
Parameters:
[
382
]
|
|
14.08 ms (5.37%) |
1 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.position AS position_2, p0_.marque_id AS marque_id_3 FROM produit p0_
Parameters:
[] |
|
13.85 ms (5.28%) |
1 |
SELECT m0_.id AS id_0, m0_.nom AS nom_1 FROM marque m0_
Parameters:
[] |
|
13.76 ms (5.24%) |
1 |
SELECT u0_.id AS id_0, u0_.adresse AS adresse_1, u0_.prix AS prix_2, u0_.date_time_maj AS date_time_maj_3, u0_.erreur AS erreur_4, u0_.commentaire AS commentaire_5, u0_.crawl_prioritaire AS crawl_prioritaire_6, u0_.produit_id AS produit_id_7, u0_.vendeur_id AS vendeur_id_8 FROM url u0_ WHERE u0_.produit_id = ? ORDER BY u0_.vendeur_id ASC
Parameters:
[
382
]
|
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\Produit | 204 |
| App\Entity\Vendeur | 37 |
| App\Entity\Marque | 13 |
| App\Entity\Configuration | 3 |
| App\Entity\Utilisateur | 1 |
| App\Entity\Url | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Utilisateur | No errors. |
| App\Entity\Vendeur | No errors. |
| App\Entity\Url | No errors. |
| App\Entity\Action | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Marque | No errors. |
| App\Entity\Configuration | No errors. |