https://lk1.test.genesii.fr/admin/core/append-form-field-element?_sonata_admin=admin.programme&_sonata_name=admin_app_programme_edit&elementId=s68bec4d19e069_pjs&id=203&objectId=203&uniqid=s68bec4d19e069 Return to referer URL

Query Metrics

7 Database Queries
5 Different statements
7.48 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.66 ms
(35.64%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.notification AS notification_5, t0.hide_account AS hide_account_6, t0.hide_entreprise AS hide_entreprise_7, t0.all_programmes AS all_programmes_8, t0.couleur AS couleur_9, t0.telephone AS telephone_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.prescripteur_coordonnees_responsable AS prescripteur_coordonnees_responsable_13, t0.peut_modifier AS peut_modifier_14, t0.entreprise_id AS entreprise_id_15 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
  12
]
1.96 ms
(26.21%)
2
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.description_courte AS description_courte_3, t0.ordre AS ordre_4, t0.show_public AS show_public_5, t0.est_un_plan AS est_un_plan_6, t0.est_image_admin AS est_image_admin_7, t0.lot_id AS lot_id_8, t0.programme_id AS programme_id_9, t0.piece_jointe_mere_id AS piece_jointe_mere_id_10 FROM piece_jointe t0 WHERE t0.programme_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  203
]
1.02 ms
(13.70%)
2
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.description_courte AS description_courte_3, t0.programme_id AS programme_id_4 FROM documents t0 WHERE t0.programme_id = ?
Parameters:
[
  203
]
1.00 ms
(13.38%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.date_livraison AS date_livraison_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.livraison AS livraison_9, t0.visu_livraison AS visu_livraison_10, t0.nom AS nom_11, t0.image AS image_12, t0.brochure AS brochure_13, t0.promoteur AS promoteur_14, t0.plan_masse AS plan_masse_15, t0.type_plan AS type_plan_16, t0.zoom_map AS zoom_map_17, t0.libelle_brochure AS libelle_brochure_18, t0.demande_suppression AS demande_suppression_19, t0.note_globale AS note_globale_20, t0.entreprise_id AS entreprise_id_21, t0.prescripteur_id AS prescripteur_id_22 FROM programme t0 WHERE t0.id = ?
Parameters:
[
  "203"
]
0.83 ms
(11.07%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.adresse AS adresse_5, t0.website AS website_6, t0.logo AS logo_7, t0.logo_admin AS logo_admin_8, t0.updated_at AS updated_at_9, t0.available_roles AS available_roles_10 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
  4
]

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 No errors.
App\Entity\Entreprise No errors.
App\Entity\Historique
  • The association App\Entity\Historique#entreprise refers to the inverse side field App\Entity\Entreprise#historiques which does not exist.
App\Entity\Prospect No errors.
App\Entity\Programme No errors.
App\Entity\InfosSuivi No errors.
App\Entity\ActionTrace No errors.
App\Entity\Lot No errors.
App\Entity\Denonciation No errors.
App\Entity\PieceJointe No errors.
App\Entity\Documents No errors.