https://deltainformatique.org/ECF/homepage/horaire Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
1.26 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.utilisateur_id AS utilisateur_id_1, t0.email AS email_2, t0.password AS password_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.telephone AS telephone_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.adresse_postal AS adresse_postal_9, t10.utilisateur_id AS utilisateur_id_11, t10.role_id AS role_id_12, t13.utilisateur_id AS utilisateur_id_14, t13.avis_id AS avis_id_15 FROM `utilisateur` t0 LEFT JOIN `possede` t10 ON t10.utilisateur_id = t0.utilisateur_id LEFT JOIN `publie` t13 ON t13.utilisateur_id = t0.utilisateur_id WHERE t0.utilisateur_id = ?
Parameters:
[
  18
]
2 0.35 ms
SELECT t0.role_id AS role_id_1, t0.libelle AS libelle_2 FROM `role` t0 WHERE t0.role_id = ?
Parameters:
[
  2
]
3 0.30 ms
SELECT t0.horaire_id AS horaire_id_1, t0.jour AS jour_2, t0.heure_ouverture AS heure_ouverture_3, t0.heure_fermeture AS heure_fermeture_4 FROM `horaire` 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\Utilisateur
  • The field App\Entity\Utilisateur#publie is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Publie#utilisateur_id does not contain the required 'inversedBy: "publie"' attribute.
  • The field App\Entity\Utilisateur#commande is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#utilisateur_id does not contain the required 'inversedBy: "commande"' attribute.
App\Entity\Possede No errors.
App\Entity\Role No errors.
App\Entity\Publie No errors.
App\Entity\Avis
  • The field App\Entity\Avis#publie is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Publie#avis_id does not contain the required 'inversedBy: "publie"' attribute.
App\Entity\Commande No errors.
App\Entity\Horaire No errors.