Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

23.45 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	22.42 ms	SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0 SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0;
2	1.03 ms	SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0 SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0;

#▲

Time

Info

22.42 ms

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.district AS district_3,
  t0.subdistrict AS subdistrict_4,
  t0.auteur AS auteur_5,
  t0.universite_ecole_etudiant AS universite_ecole_etudiant_6,
  t0.organisme_accueil AS organisme_accueil_7,
  t0.annee_terrain AS annee_terrain_8,
  t0.heures_par_hj AS heures_par_hj_9,
  t0.sdp_graph AS sdp_graph_10,
  t0.sds_graph AS sds_graph_11,
  t0.seuils_nb_actifs AS seuils_nb_actifs_12,
  t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13,
  t0.infos_seuils AS infos_seuils_14,
  t0.x AS x_15,
  t0.y AS y_16,
  t0.type_subdistrict AS type_subdistrict_17,
  t0.code AS code_18,
  t0.zone_etude_graph AS zone_etude_graph_19
FROM
  diagnostic_agraire t0

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0;

1.03 ms

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.district AS district_3,
  t0.subdistrict AS subdistrict_4,
  t0.auteur AS auteur_5,
  t0.universite_ecole_etudiant AS universite_ecole_etudiant_6,
  t0.organisme_accueil AS organisme_accueil_7,
  t0.annee_terrain AS annee_terrain_8,
  t0.heures_par_hj AS heures_par_hj_9,
  t0.sdp_graph AS sdp_graph_10,
  t0.sds_graph AS sds_graph_11,
  t0.seuils_nb_actifs AS seuils_nb_actifs_12,
  t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13,
  t0.infos_seuils AS infos_seuils_14,
  t0.x AS x_15,
  t0.y AS y_16,
  t0.type_subdistrict AS type_subdistrict_17,
  t0.code AS code_18,
  t0.zone_etude_graph AS zone_etude_graph_19
FROM
  diagnostic_agraire t0

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.district AS district_3, t0.subdistrict AS subdistrict_4, t0.auteur AS auteur_5, t0.universite_ecole_etudiant AS universite_ecole_etudiant_6, t0.organisme_accueil AS organisme_accueil_7, t0.annee_terrain AS annee_terrain_8, t0.heures_par_hj AS heures_par_hj_9, t0.sdp_graph AS sdp_graph_10, t0.sds_graph AS sds_graph_11, t0.seuils_nb_actifs AS seuils_nb_actifs_12, t0.seuils_nb_pers_famille AS seuils_nb_pers_famille_13, t0.infos_seuils AS infos_seuils_14, t0.x AS x_15, t0.y AS y_16, t0.type_subdistrict AS type_subdistrict_17, t0.code AS code_18, t0.zone_etude_graph AS zone_etude_graph_19 FROM diagnostic_agraire t0;

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\DiagnosticAgraire	No errors.
App\Entity\SystemeProduction	No errors.
App\Entity\SystemeCulture	No errors.
App\Entity\Culture	No errors.
App\Entity\BienServiceProduit	No errors.
App\Entity\SystemeElevage	No errors.
App\Entity\SpScTenure	No errors.
App\Entity\SystemeProductionMateriel	No errors.
App\Entity\SalaireMost	No errors.
App\Entity\SalaireMosp	No errors.
App\Entity\Subvention	No errors.
App\Entity\Impot	No errors.
App\Entity\InteretsEmprunts	No errors.
App\Entity\Commission	No errors.
App\Entity\RfTerresPrisesLocation	No errors.
App\Entity\RfTerresDonneesLocation	No errors.
App\Entity\RfTerresDonneesMetayage	No errors.
App\Entity\SPAutoconsopcultures	No errors.
App\Entity\SpAutresBSP	No errors.
App\Entity\ServiceMateriel	No errors.
App\Entity\TravailExt	No errors.
App\Entity\SystemeCultureCulture	No errors.
App\Entity\Intervention	No errors.
App\Entity\CultureBSP	No errors.
App\Entity\SEP	No errors.
App\Entity\SEAlimPayeProp	No errors.
App\Entity\SEBSPHorsAlim	No errors.
App\Entity\SEAlimIntraconso	No errors.
App\Entity\SEAlim	No errors.
App\Entity\LotAlim	No errors.
App\Entity\InterventionBSP	No errors.
App\Entity\SPSCTenureBS	No errors.
App\Entity\SpScTenureP	No errors.

Symfony Profiler

GET https://ips.web.selmet.inrae.fr/

Configuration Settings

Theme