Query Metrics
9
Database Queries
7
Different statements
12.09 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.22 ms |
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
]
|
2 | 2.45 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM programme p0_ INNER JOIN entreprise e1_ ON p0_.entreprise_id = e1_.id WHERE e1_.id = ? AND p0_.demande_suppression IS NULL
Parameters:
[
4
]
|
3 | 0.70 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM programme p0_ INNER JOIN entreprise e1_ ON p0_.entreprise_id = e1_.id WHERE e1_.id = ? AND p0_.demande_suppression IS NULL ORDER BY p0_.id DESC LIMIT 250
Parameters:
[
4
]
|
4 | 0.99 ms |
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_ INNER JOIN entreprise e1_ ON p0_.entreprise_id = e1_.id WHERE e1_.id = ? AND p0_.demande_suppression IS NULL AND p0_.id IN (?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[ 4 203 200 199 ] |
5 | 4.18 ms |
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.programme_parent_id = ?
Parameters:
[
203
]
|
6 | 0.98 ms |
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.programme_parent_id = ?
Parameters:
[
200
]
|
7 | 0.92 ms |
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.programme_parent_id = ?
Parameters:
[
199
]
|
8 | 0.34 ms |
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
]
|
9 | 0.31 ms |
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\Denonciation | No errors. |
App\Entity\PieceJointe | No errors. |
App\Entity\Documents | No errors. |
App\Entity\Proposition | No errors. |