https://ultratex.smart-it-partner.com/produits/produitsepuises

Query Metrics

81 Database Queries
4 Different statements
44.03 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.85 ms
(90.50%)
75
SELECT t0.id AS id_1, t0.qte AS qte_2, t0.qtelimite AS qtelimite_3, t0.nombre_rouleaux AS nombre_rouleaux_4, t0.prixht AS prixht_5, t0.tva AS tva_6, t0.prixttc AS prixttc_7, t0.total AS total_8, t0.dimensionlogo AS dimensionlogo_9, t0.dimkappa AS dimkappa_10, t0.produit_id AS produit_id_11, t0.couleur_id AS couleur_id_12 FROM detailsproduit t0 WHERE t0.produit_id = ?
Parameters:
[
  1
]
1.77 ms
(4.03%)
4
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_archive AS is_archive_3 FROM coleur t0 WHERE t0.id = ?
Parameters:
[
  20
]
1.26 ms
(2.87%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.address AS address_7, t0.telphone AS telphone_8, t0.photo AS photo_9, t0.photocov AS photocov_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.14 ms
(2.60%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.coleur AS coleur_3, t0.prix AS prix_4, t0.stock AS stock_5, t0.image AS image_6, t0.dateajout AS dateajout_7, t0.poid AS poid_8, t0.description AS description_9, t0.prixht AS prixht_10, t0.tva AS tva_11, t0.reference AS reference_12, t0.is_archive AS is_archive_13, t0.totalepoid AS totalepoid_14, t0.societe AS societe_15, t0.composition AS composition_16, t0.is_tissu AS is_tissu_17, t0.quantitelimite AS quantitelimite_18, t0.totpoidlimite AS totpoidlimite_19, t0.typetissu AS typetissu_20, t0.nbtotalrouleaux AS nbtotalrouleaux_21, t0.total AS total_22, t0.fournisseur_id AS fournisseur_id_23, t0.tissu_id AS tissu_id_24, t0.coleurs_id AS coleurs_id_25, t0.accessoire_id AS accessoire_id_26 FROM produits t0
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\User No errors.
App\Entity\Trace No errors.
App\Entity\Produits
  • The association App\Entity\Produits#tissu refers to the inverse side field App\Entity\Tissu#produits which does not exist.
  • The mappings App\Entity\Produits#detailsproduits and App\Entity\Detailsproduit#produit are inconsistent with each other.
App\Entity\Fournisseur No errors.
App\Entity\Tissu
  • The association App\Entity\Tissu#produit refers to the inverse side field App\Entity\Produits#tissus which does not exist.
App\Entity\Coleur No errors.
App\Entity\Accessoire No errors.
App\Entity\Gestiondestock No errors.
App\Entity\Articlegestion No errors.
App\Entity\Detailsproduit
  • The association App\Entity\Detailsproduit#produit refers to the inverse side field App\Entity\Produits#detailsProduits which does not exist.
App\Entity\Articleachat No errors.
App\Entity\Articlebonsortie No errors.