https://app.qebok.fr/p-demo/

Query Metrics

109 Database Queries
6 Different statements
46.64 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
32.66 ms
(70.04%)
76
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:
[
  1
]
8.48 ms
(18.19%)
14
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_projet_id = ? AND t0.lot = ?
Parameters:
[
  1
  "5"
]
4.25 ms
(9.11%)
14
SELECT t0.id AS id_1, t0.lot AS lot_2, t0.email AS email_3, t0.copie_a AS copie_a_4, t0.repondre_a AS repondre_a_5, t0.preambule AS preambule_6, t0.rappel AS rappel_7, t0.rappel_date AS rappel_date_8, t0.envoi_email AS envoi_email_9, t0.id_projet_id AS id_projet_id_10 FROM visa_bilans t0 WHERE t0.id_projet_id = ? AND t0.lot = ? LIMIT 1
Parameters:
[
  1
  "5"
]
0.76 ms
(1.63%)
3
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_projet_id = ?
Parameters:
[
  1
]
0.26 ms
(0.55%)
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"
]
0.23 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.lot AS lot_2, t0.email AS email_3, t0.copie_a AS copie_a_4, t0.repondre_a AS repondre_a_5, t0.preambule AS preambule_6, t0.rappel AS rappel_7, t0.rappel_date AS rappel_date_8, t0.envoi_email AS envoi_email_9, t0.id_projet_id AS id_projet_id_10 FROM visa_bilans t0 WHERE t0.id_projet_id = ?
Parameters:
[
  1
]

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\VisaBilans No errors.
App\Entity\Visa\VisaJustificatifs No errors.