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

Query Metrics

13 Database Queries
10 Different statements
262.45 ms Query time
0 Invalid entities
259 Managed entities

Grouped Statements

Show all queries

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.