Query Metrics

6 Database Queries
4 Different statements
5.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.01 ms
(0.00%)
3
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "templatewebsite"
]
1.56 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.description AS description_4, t0.date AS date_5, t0.nbvote AS nbvote_6, t0.totalnote AS totalnote_7, t0.nblike AS nblike_8, t0.nbenregistrer AS nbenregistrer_9, t0.nbpartage AS nbpartage_10, t0.nbvente AS nbvente_11, t0.nbpoint AS nbpoint_12, t0.nbpiece AS nbpiece_13, t0.produitdetail AS produitdetail_14, t0.valide AS valide_15, t0.recommander AS recommander_16, t0.newprise AS newprise_17, t0.lastprise AS lastprise_18, t0.difference AS difference_19, t0.prixlivraison AS prixlivraison_20, t0.prod_number AS prod_number_21, t0.user_id AS user_id_22, t0.souscategorie_id AS souscategorie_id_23, t0.marqueproduit_id AS marqueproduit_id_24, t0.produitgro_id AS produitgro_id_25 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
1.35 ms
(0.00%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.contenu AS contenu_2, p0_.description AS description_3, p0_.date AS date_4, p0_.nbvote AS nbvote_5, p0_.totalnote AS totalnote_6, p0_.nblike AS nblike_7, p0_.nbenregistrer AS nbenregistrer_8, p0_.nbpartage AS nbpartage_9, p0_.nbvente AS nbvente_10, p0_.nbpoint AS nbpoint_11, p0_.nbpiece AS nbpiece_12, p0_.produitdetail AS produitdetail_13, p0_.valide AS valide_14, p0_.recommander AS recommander_15, p0_.newprise AS newprise_16, p0_.lastprise AS lastprise_17, p0_.difference AS difference_18, p0_.prixlivraison AS prixlivraison_19, p0_.prod_number AS prod_number_20, s1_.id AS id_21, s1_.nom AS nom_22, s1_.description AS description_23, s1_.link AS link_24, s1_.date AS date_25, s1_.nbvente AS nbvente_26, s1_.nbproduit AS nbproduit_27, s1_.rang AS rang_28, s1_.src AS src_29, s1_.alt AS alt_30, p0_.user_id AS user_id_31, p0_.souscategorie_id AS souscategorie_id_32, p0_.marqueproduit_id AS marqueproduit_id_33, p0_.produitgro_id AS produitgro_id_34, s1_.user_id AS user_id_35, s1_.categorie_id AS categorie_id_36 FROM produit p0_ LEFT JOIN souscategorie s1_ ON p0_.souscategorie_id = s1_.id WHERE p0_.id <> ? AND s1_.id = ? ORDER BY p0_.nbpoint DESC LIMIT 7
Parameters:
[
  22
  22
]
0.78 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.valeur AS valeur_3, t0.date AS date_4, t0.produit_id AS produit_id_5 FROM detailproduit t0 WHERE t0.produit_id = ? ORDER BY t0.date ASC
Parameters:
[
  22
]

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\Produit\Produit\Produit No errors.
App\Entity\Users\User\User No errors.
App\Entity\Produit\Produit\Souscategorie No errors.
App\Entity\Produit\Produit\Marqueproduit No errors.
App\Entity\Produit\Produit\Imgproduit No errors.
App\Entity\Produit\Produit\Produitboutique No errors.
App\Entity\Produit\Produit\Categorie No errors.
App\Entity\Produit\Produit\Detailproduit No errors.
App\Entity\Produit\Produit\Coutlivraison No errors.
App\Entity\Users\Adminuser\Parametreadmin No errors.