https://lk1.test.genesii.fr/admin/app/programme/203/lot/2258/edit

Query Metrics

8 Database Queries
7 Different statements
5.72 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.34 ms
(40.98%)
1
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.adresse AS adresse_2, p0_.ville AS ville_3, p0_.code_postal AS code_postal_4, p0_.date_livraison AS date_livraison_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.livraison AS livraison_8, p0_.visu_livraison AS visu_livraison_9, p0_.nom AS nom_10, p0_.image AS image_11, p0_.brochure AS brochure_12, p0_.promoteur AS promoteur_13, p0_.plan_masse AS plan_masse_14, p0_.type_plan AS type_plan_15, p0_.zoom_map AS zoom_map_16, p0_.libelle_brochure AS libelle_brochure_17, p0_.demande_suppression AS demande_suppression_18, p0_.note_globale AS note_globale_19, p0_.entreprise_id AS entreprise_id_20, p0_.prescripteur_id AS prescripteur_id_21 FROM programme p0_ WHERE p0_.entreprise_id = ?
Parameters:
[
  4
]
0.84 ms
(14.65%)
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.77 ms
(13.41%)
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.lot_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  2258
]
0.74 ms
(12.96%)
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
]
0.40 ms
(7.01%)
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
]
0.38 ms
(6.65%)
1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.type AS type_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.prix AS prix_7, t0.date_livraison AS date_livraison_8, t0.titre AS titre_9, t0.description AS description_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.etage AS etage_13, t0.superficie AS superficie_14, t0.terrasse AS terrasse_15, t0.orientation AS orientation_16, t0.annexes AS annexes_17, t0.livraison AS livraison_18, t0.promoteur AS promoteur_19, t0.programme AS programme_20, t0.image AS image_21, t0.jardin AS jardin_22, t0.terrasse2 AS terrasse2_23, t0.frais_notaire_type AS frais_notaire_type_24, t0.frais_notaire_inclus AS frais_notaire_inclus_25, t0.brochure AS brochure_26, t0.plan_masse AS plan_masse_27, t0.statut AS statut_28, t0.nature AS nature_29, t0.type_moteur_recherche AS type_moteur_recherche_30, t0.etage_moteur_recherche AS etage_moteur_recherche_31, t0.etat_lot AS etat_lot_32, t0.pj_progression AS pj_progression_33, t0.programme_parent_id AS programme_parent_id_34 FROM lot t0 WHERE t0.id = ?
Parameters:
[
  "2258"
]
0.25 ms
(4.34%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.date AS date_4, t0.lu AS lu_5, t0.utilisateur_id AS utilisateur_id_6, t0.auteur_id AS auteur_id_7, t0.connected_user_id AS connected_user_id_8, t0.historique_id AS historique_id_9, t0.programme_id AS programme_id_10 FROM infos_suivi t0 WHERE t0.utilisateur_id = ?
Parameters:
[
  12
]

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\PieceJointe No errors.
App\Entity\Proposition No errors.
App\Entity\Denonciation No errors.
App\Entity\Documents No errors.