GET https://complexehotelierlabonte.com/hebergement/TA0000002

Query Metrics

2 Database Queries
2 Different statements
0.78 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.43 ms
(54.99%)
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 famille f2_ ON p1_.CodeFamille = f2_.CodeFamille INNER JOIN services s3_ ON p0_.codeservices = s3_.codeservices WHERE s3_.codeservices = ? AND f2_.CodeFamille = ? AND p1_.photo <> ''
Parameters:
[
  "S0000011"
  "TA0000002"
]
0.35 ms
(45.01%)
1
SELECT f0_.CodeFamille AS CodeFamille_0, f0_.libelle AS libelle_1, f0_.IDSOCIETE AS IDSOCIETE_2, f0_.IDAnnee AS IDAnnee_3, f0_.supprimer AS supprimer_4, f0_.description AS description_5, f0_.numeroS AS numeroS_6, f0_.urlimage AS urlimage_7, f0_.slug AS slug_8 FROM famille f0_ WHERE f0_.slug = ? OR f0_.CodeFamille = ?
Parameters:
[
  "TA0000002"
  "TA0000002"
]

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\Famille No errors.
App\Entity\Produit No errors.
App\Entity\PrixAAppliquer 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.