Query Metrics
9
Database Queries
6
Different statements
3.05 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.42 ms (46.68%) |
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 "7" ] |
0.51 ms (16.58%) |
3 |
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:
[
8
]
|
0.41 ms (13.30%) |
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 "7" ] |
0.34 ms (11.33%) |
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.19 ms (6.18%) |
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 "7" ] |
0.18 ms (5.94%) |
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 |
|
App\Entity\User\User |
|
App\Entity\Visa\VisaExigences | No errors. |
App\Entity\Visa\VisaContacts | No errors. |
App\Entity\Visa\VisaJustificatifs | No errors. |
App\Entity\Visa\VisaBilans | No errors. |