https://app.qebok.fr/demo/exigence-31

Query Metrics

4 Database Queries
3 Different statements
2.14 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(41.36%)
1
SELECT t0.id AS id_1, t0.numero_exigence AS numero_exigence_2, t0.lot AS lot_3, t0.sous_lot AS sous_lot_4, t0.cibles AS cibles_5, t0.elements_concernes AS elements_concernes_6, t0.exigences AS exigences_7, t0.commentaires_entreprise AS commentaires_entreprise_8, t0.commentaires_moe AS commentaires_moe_9, t0.localisation AS localisation_10, t0.validation AS validation_11, t0.id_user_id AS id_user_id_12, t0.id_projet_id AS id_projet_id_13 FROM visa_exigences t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
0.72 ms
(33.62%)
2
SELECT t0.id AS id_1, t0.nom_du_fichier AS nom_du_fichier_2, t0.date AS date_3, t0.commentaire_entreprise AS commentaire_entreprise_4, t0.commentaire_moe AS commentaire_moe_5, t0.exigence_id AS exigence_id_6, t0.projet_id AS projet_id_7 FROM visa_justificatifs t0 WHERE t0.exigence_id = ?
Parameters:
[
  31
]
0.54 ms
(25.02%)
1
SELECT t0.id AS id_1, t0.nom_du_projet AS nom_du_projet_2, t0.code AS code_3, t0.ville_du_projet AS ville_du_projet_4, t0.date_creation AS date_creation_5, t0.statut_paiement AS statut_paiement_6, t0.date_fin_paiement AS date_fin_paiement_7, t0.id_user_id AS id_user_id_8, t0.visa_exigences_id AS visa_exigences_id_9 FROM visa_projets t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "demo"
]

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\Visa\VisaProjets
  • The association App\Entity\Visa\VisaProjets#visaExigences refers to the inverse side field App\Entity\Visa\VisaExigences#projet which does not exist.
App\Entity\User\User
  • The association App\Entity\User\User#visaExigences refers to the inverse side field App\Entity\Visa\VisaExigences#User which does not exist.
App\Entity\Visa\VisaExigences No errors.
App\Entity\Visa\VisaJustificatifs No errors.