POST https://diy-lab.fr/dashboard

Query Metrics

14 Database Queries
10 Different statements
5.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.