GET https://complexehotelierlabonte.com/restaurant/menu/PA0000283

Query Metrics

3 Database Queries
3 Different statements
0.76 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.30 ms
(40.35%)
1
SELECT t0.photo AS photo_1, t0.PrixHT AS PrixHT_2, t0.QteReappro AS QteReappro_3, t0.QteMini AS QteMini_4, t0.TauxTVA AS TauxTVA_5, t0.GenCode AS GenCode_6, t0.CodeBarre AS CodeBarre_7, t0.SaisiPar AS SaisiPar_8, t0.SaisiLe AS SaisiLe_9, t0.Observations AS Observations_10, t0.AIB AS AIB_11, t0.stockActuel AS stockActuel_12, t0.ID AS ID_13, t0.proFamille AS proFamille_14, t0.LibProd AS LibProd_15, t0.Description AS Description_16, t0.assujettiTVA AS assujettiTVA_17, t0.assujettiAIB AS assujettiAIB_18, t0.IDSOCIETE AS IDSOCIETE_19, t0.IDAnnee AS IDAnnee_20, t0.referenceInexistante AS referenceInexistante_21, t0.codebare AS codebare_22, t0.QTEAPPRO AS QTEAPPRO_23, t0.QteVente AS QteVente_24, t0.QteRebus AS QteRebus_25, t0.LibFamille AS LibFamille_26, t0.LibProdV AS LibProdV_27, t0.PrixRevient AS PrixRevient_28, t0.Marge AS Marge_29, t0.NIM_Facture_Preuve AS NIM_Facture_Preuve_30, t0.Signature_Facure_Preuve AS Signature_Facure_Preuve_31, t0.PTVA_Marge AS PTVA_Marge_32, t0.PTVA_HT AS PTVA_HT_33, t0.estMatieresPremiere AS estMatieresPremiere_34, t0.estStockable AS estStockable_35, t0.estdisponible AS estdisponible_36, t0.Reference AS Reference_37, t0.feat AS feat_38, t0.CodeFamille AS CodeFamille_39 FROM produit t0 WHERE t0.ID = ?
Parameters:
[
  "P0000067"
]
0.29 ms
(37.82%)
1
SELECT t0.codeprix_applique AS codeprix_applique_1, t0.codeservices AS codeservices_2, t0.prix AS prix_3, t0.stock AS stock_4, t0.qteVendu AS qteVendu_5, t0.qteapprovisionne AS qteapprovisionne_6, t0.qteretourne AS qteretourne_7, t0.ID AS ID_8, t0.codeservices AS codeservices_9 FROM Prix_A_Appliquer t0 WHERE t0.codeprix_applique = ? LIMIT 1
Parameters:
[
  "PA0000283"
]
0.16 ms
(21.83%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.produit_id AS produit_id_3 FROM images_produits t0 WHERE t0.produit_id = ?
Parameters:
[
  "P0000067"
]

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\PrixAAppliquer No errors.
App\Entity\Produit No errors.
App\Entity\Services
  • The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which is not defined as association, but as field.
  • The association App\Entity\Services#tables refers to the owning side field App\Entity\Table#codeservices which does not exist.
App\Entity\LigneFac No errors.
App\Entity\Famille No errors.
App\Entity\ImagesProduits No errors.