https://lk1.test.genesii.fr/admin/app/programme/list

Query Metrics

9 Database Queries
7 Different statements
12.09 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • 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.
App\Entity\Proposition No errors.