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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.39 ms
(63.67%)
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
]
100.04 ms
(32.60%)
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
]
3.17 ms
(1.03%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM compartiment t0
Parameters:
[]
2.45 ms
(0.80%)
7
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.15 ms
(0.70%)
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.09 ms
(0.68%)
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
]
0.89 ms
(0.29%)
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:
[]
0.70 ms
(0.23%)
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:
[]

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.