GET https://flux.web.selmet.inrae.fr/?pp=env

Query Metrics

814 Database Queries
8 Different statements
266.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
164.07 ms
(61.50%)
517
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.data_calc AS data_calc_3, t0.cice_id AS cice_id_4, t0.unite_id AS unite_id_5, t0.biomasse_type_id AS biomasse_type_id_6, t0.operation_technique_id AS operation_technique_id_7 FROM valeur_flux_biomasse t0 WHERE t0.cice_id = ?
Parameters:
[
  445
]
80.23 ms
(30.07%)
279
SELECT t0.id AS id_1, t0.id_cice AS id_cice_2, t0.exploitation_id AS exploitation_id_3, t0.type_flux_id AS type_flux_id_4 FROM cice t0 WHERE t0.type_flux_id = ?
Parameters:
[
  1
]
9.21 ms
(3.45%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_type_flux AS id_type_flux_3, t0.description AS description_4 FROM flux t0
Parameters:
[]
6.49 ms
(2.43%)
1
SELECT t0.id AS id_1, t0.biomasse_type_id AS biomasse_type_id_2, t0.description_e AS description_e_3, t0.description_f AS description_f_4, t0.dry_matter_conversion_factor AS dry_matter_conversion_factor_5, t0.crud_protein AS crud_protein_6, t0.nitrogen_conversion_factor_dm AS nitrogen_conversion_factor_dm_7, t0.nitrogen_conversion_factor_cp AS nitrogen_conversion_factor_cp_8, t0.exploitation_id AS exploitation_id_9, t0.reference_conv_fact_id AS reference_conv_fact_id_10 FROM biomasse_type t0
Parameters:
[]
2.27 ms
(0.85%)
7
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.88 ms
(0.70%)
4
SELECT t0.id AS id_1, t0.compartiment_origine_id AS compartiment_origine_id_2, t0.compartiment_destination_id AS compartiment_destination_id_3, t0.flux_id AS flux_id_4 FROM type_flux t0 WHERE t0.flux_id = ?
Parameters:
[
  1
]
1.62 ms
(0.61%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM compartiment t0
Parameters:
[]
1.01 ms
(0.38%)
2
SELECT t0.id AS id_1, t0.nombre_exploitations_pour_creer_typologie AS nombre_exploitations_pour_creer_typologie_2, t0.nombre_types AS nombre_types_3, t0.annee_collecte_donnees AS annee_collecte_donnees_4, t0.id_bdd AS id_bdd_5, t0.objet AS objet_6, t0.reference_biblio_bdd_id AS reference_biblio_bdd_id_7, t0.pays_id AS pays_id_8 FROM base_de_donnees t0
Parameters:
[]

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.