Query Metrics
14
Database Queries
10
Different statements
5.96 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.06 ms (17.75%) |
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:
[
"330"
]
|
1.00 ms (16.75%) |
2 |
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:
[
330
]
|
0.79 ms (13.30%) |
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:
[
"330"
]
|
0.73 ms (12.28%) |
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"
]
|
0.60 ms (10.08%) |
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:
[
7
]
|
0.41 ms (6.81%) |
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:
[] |
0.39 ms (6.56%) |
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:
[] |
0.37 ms (6.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_
Parameters:
[] |
0.32 ms (5.37%) |
1 |
SELECT m0_.id AS id_0, m0_.nom AS nom_1 FROM marque m0_
Parameters:
[] |
0.29 ms (4.95%) |
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:
[] |
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.
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. |