Query Metrics
128
Database Queries
6
Different statements
36.03 ms
Query time
2
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
14.66 ms (40.69%) |
1 |
SELECT t0.id AS id_1, t0.numero_arbrecp AS numero_arbrecp_2, t0.x_arbrecp AS x_arbrecp_3, t0.y_arbrecp AS y_arbrecp_4, t0.jour_abattage AS jour_abattage_5, t0.numero_essencecp AS numero_essencecp_6, t0.longeur_arbrecp AS longeur_arbrecp_7, t0.diametre_arbrecp AS diametre_arbrecp_8, t0.volume_arbrecp AS volume_arbrecp_9, t0.longeura_billecp AS longeura_billecp_10, t0.diametrea_billecp AS diametrea_billecp_11, t0.volumea_billecp AS volumea_billecp_12, t0.longeurb_billecp AS longeurb_billecp_13, t0.diametreb_billecp AS diametreb_billecp_14, t0.volumeb_billecp AS volumeb_billecp_15, t0.longeurc_billecp AS longeurc_billecp_16, t0.diametrec_billecp AS diametrec_billecp_17, t0.volumec_billecp AS volumec_billecp_18, t0.longeurd_billecp AS longeurd_billecp_19, t0.diametred_billecp AS diametred_billecp_20, t0.volumed_billecp AS volumed_billecp_21, t0.a_utlise AS a_utlise_22, t0.b_utilise AS b_utilise_23, t0.c_utilise AS c_utilise_24, t0.d_utilise AS d_utilise_25, t0.a_abandon AS a_abandon_26, t0.b_abandon AS b_abandon_27, t0.c_abandon AS c_abandon_28, t0.d_abandon AS d_abandon_29, t0.fut_abandon AS fut_abandon_30, t0.motivation AS motivation_31, t0.created_at AS created_at_32, t0.created_by AS created_by_33, t0.updated_at AS updated_at_34, t0.updated_by AS updated_by_35, t0.exercice AS exercice_36, t0.charge AS charge_37, t0.zh_arbrecp_id AS zh_arbrecp_id_38, t0.nom_essencecp_id AS nom_essencecp_id_39, t0.code_pagecp_id AS code_pagecp_id_40, t0.code_inv_id AS code_inv_id_41, t0.code_exercice_id AS code_exercice_id_42 FROM metier.lignepagecp t0 WHERE t0.exercice = ?
Parameters:
[
2025
]
|
|
9.98 ms (27.71%) |
80 |
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.libelle AS libelle_3, t0.code_publication_id AS code_publication_id_4 FROM blog.fichier_publication t0 WHERE t0.code_publication_id = ?
Parameters:
[
49
]
|
|
6.06 ms (16.82%) |
34 |
SELECT t0.id AS id_1, t0.numero_essence AS numero_essence_2, t0.nom_vernaculaire AS nom_vernaculaire_3, t0.famille_essence AS famille_essence_4, t0.nom_scientifique AS nom_scientifique_5, t0.categorie_essence AS categorie_essence_6, t0.taxe_abattage AS taxe_abattage_7, t0.dm_minima AS dm_minima_8, t0.taxe_preservation AS taxe_preservation_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.updated_at AS updated_at_13, t0.autorisation AS autorisation_14 FROM metier.essence t0 WHERE t0.id = ?
Parameters:
[
192
]
|
|
2.23 ms (6.20%) |
11 |
SELECT t0.id AS id_1, t0.libelle_publication AS libelle_publication_2, t0.fichier AS fichier_3, t0.actif AS actif_4, t0.code_category_id AS code_category_id_5 FROM blog.publication t0 WHERE t0.code_category_id = ?
Parameters:
[
11
]
|
|
1.99 ms (5.52%) |
1 |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.cloture AS cloture_3, t0.date_expiration_rallonge AS date_expiration_rallonge_4, t0.rallonge AS rallonge_5, t0.nb_mois AS nb_mois_6, t0.date_debut AS date_debut_7, t0.datefin AS datefin_8 FROM admin.exercice t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
|
1.10 ms (3.05%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.code_groupe_id AS code_groupe_id_4 FROM blog.category_publication t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| alt | doctrine.dbal.alt_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.