GET https://complexehotelierlabonte.com/restaurant

Query Metrics

45 Database Queries
3 Different statements
8.82 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.44 ms
(50.31%)
22
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:
[
  "P0000058"
]
2.68 ms
(30.39%)
22
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:
[
  "P0000058"
]
1.70 ms
(19.30%)
1
SELECT p0_.codeprix_applique AS codeprix_applique_0, p0_.codeservices AS codeservices_1, p0_.prix AS prix_2, p0_.stock AS stock_3, p0_.qteVendu AS qteVendu_4, p0_.qteapprovisionne AS qteapprovisionne_5, p0_.qteretourne AS qteretourne_6, p0_.ID AS ID_7, p0_.codeservices AS codeservices_8 FROM Prix_A_Appliquer p0_ INNER JOIN produit p1_ ON p0_.ID = p1_.ID INNER JOIN images_produits i2_ ON p1_.ID = i2_.produit_id INNER JOIN famille f3_ ON p1_.CodeFamille = f3_.CodeFamille WHERE f3_.numeroS NOT IN (5, 2, 3)
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\PrixAAppliquer No errors.
App\Entity\Produit No errors.
App\Entity\ImagesProduits No errors.
App\Entity\Famille 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.