Query Metrics
8
Database Queries
7
Different statements
5.72 ms
Query time
1
Invalid entities
Grouped Statements
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 |
|
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. |