https://app.qebok.fr/demo/lot-5

Query Metrics

11 Database Queries
6 Different statements
4.09 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.50 ms
(36.72%)
5
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
]
1.39 ms
(34.11%)
1
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.societe AS societe_4, t0.adresse_societe AS adresse_societe_5, t0.telephone AS telephone_6, t0.email AS email_7, t0.lot AS lot_8, t0.copie_a AS copie_a_9, t0.repondre_a AS repondre_a_10, t0.preambule AS preambule_11, t0.rappel AS rappel_12, t0.rappel_date AS rappel_date_13, t0.id_projet_id AS id_projet_id_14, t0.id_user_id AS id_user_id_15 FROM visa_contacts t0 WHERE t0.id_projet_id = ? AND t0.lot = ? LIMIT 1
Parameters:
[
  1
  "5"
]
0.48 ms
(11.81%)
2
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"
]
0.27 ms
(6.56%)
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.22 ms
(5.50%)
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 = ? AND t0.lot = ? LIMIT 1
Parameters:
[
  1
  "5"
]
0.22 ms
(5.31%)
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:
[
  229
]

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