Query Metrics
1058
Database Queries
44
Different statements
743.59 ms
Query time
6
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
186.70 ms (25.11%) |
1 |
SELECT SUM(l0_.cubage_lignepagebrh) AS sclr_0 FROM metier.lignepagebrh l0_ WHERE l0_.exercice_id = ?
Parameters:
[
7
]
|
|
168.23 ms (22.62%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM metier.lignepagebrh l0_ INNER JOIN metier.pagebrh p1_ ON l0_.code_pagebrh_id = p1_.id INNER JOIN metier.essence e2_ ON l0_.nom_essencebrh_id = e2_.id
Parameters:
[] |
|
86.55 ms (11.64%) |
513 |
SELECT t0.id AS id_1, t0.numero_lignepagebrh AS numero_lignepagebrh_2, t0.x_lignepagebrh AS x_lignepagebrh_3, t0.y_lignepagebrh AS y_lignepagebrh_4, t0.lettre_lignepagebrh AS lettre_lignepagebrh_5, t0.longeur_lignepagebrh AS longeur_lignepagebrh_6, t0.diametre_lignepagebrh AS diametre_lignepagebrh_7, t0.cubage_lignepagebrh AS cubage_lignepagebrh_8, t0.observationbrh AS observationbrh_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.entre_lje AS entre_lje_14, t0.transformation AS transformation_15, t0.nom_essencebrh_id AS nom_essencebrh_id_16, t0.zh_lignepagebrh_id AS zh_lignepagebrh_id_17, t0.code_pagebrh_id AS code_pagebrh_id_18, t0.exercice_id AS exercice_id_19, t0.code_ligne_cp_id AS code_ligne_cp_id_20 FROM metier.lignepagebrh t0 WHERE t0.exercice_id = ? AND t0.nom_essencebrh_id = ? LIMIT 1
Parameters:
[ 7 1 ] |
|
73.20 ms (9.84%) |
1 |
SELECT COUNT(l0_.id) AS sclr_0 FROM metier.lignepagebrh l0_ INNER JOIN metier.pagebrh p1_ ON l0_.code_pagebrh_id = p1_.id INNER JOIN metier.essence e2_ ON l0_.nom_essencebrh_id = e2_.id WHERE l0_.exercice_id = ?
Parameters:
[
7
]
|
|
59.01 ms (7.94%) |
1 |
SELECT SUM(l0_.cubage_lignepagebrh) AS sclr_0 FROM metier.lignepagebrh l0_
Parameters:
[] |
|
35.44 ms (4.77%) |
197 |
SELECT COUNT(*) FROM metier.attribution t0 WHERE t0.exercice_id = ? AND t0.code_exploitant_id = ?
Parameters:
[ 7 112 ] |
|
20.24 ms (2.72%) |
202 |
SELECT COUNT(*) FROM metier.attribution t0 WHERE t0.exercice_id = ? AND t0.code_exploitant_id IS NULL
Parameters:
[
7
]
|
|
15.84 ms (2.13%) |
1 |
SELECT e0_.id AS id_0, e0_.nom_vernaculaire AS nom_vernaculaire_1, SUM(l1_.volume_arbrecp) AS sclr_2, COUNT(l1_.id) AS sclr_3 FROM metier.lignepagecp l1_ INNER JOIN metier.essence e0_ ON l1_.nom_essencecp_id = e0_.id WHERE l1_.exercice = ? AND l1_.volume_arbrecp IS NOT NULL GROUP BY e0_.id, e0_.nom_vernaculaire ORDER BY sclr_2 DESC LIMIT 10
Parameters:
[
2024
]
|
|
13.67 ms (1.84%) |
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
]
|
|
11.92 ms (1.60%) |
1 |
SELECT t0.id AS id_1, t0.numero_docbrh AS numero_docbrh_2, t0.delivre_docbrh AS delivre_docbrh_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.unique_doc AS unique_doc_8, t0.etat AS etat_9, t0.transmission AS transmission_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.fini AS fini_13, t0.volume AS volume_14, t0.num_foret AS num_foret_15, t0.code_reprise_id AS code_reprise_id_16, t0.type_document_id AS type_document_id_17, t0.code_generation_id AS code_generation_id_18, t0.exercice_id AS exercice_id_19, t0.code_demande_id AS code_demande_id_20 FROM metier.documentbrh t0 WHERE t0.type_document_id = ?
Parameters:
[
2
]
|
|
4.94 ms (0.66%) |
1 |
SELECT t0.id AS id_1, t0.numero_doccp AS numero_doccp_2, t0.delivre_doccp AS delivre_doccp_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.unique_doc AS unique_doc_8, t0.etat AS etat_9, t0.transmission AS transmission_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.fini AS fini_13, t0.num_foret AS num_foret_14, t0.volume AS volume_15, t0.type_document_id AS type_document_id_16, t0.code_reprise_id AS code_reprise_id_17, t0.code_generation_id AS code_generation_id_18, t0.exercice_id AS exercice_id_19, t0.code_demande_id AS code_demande_id_20 FROM metier.documentcp t0 WHERE t0.type_document_id = ?
Parameters:
[
1
]
|
|
4.64 ms (0.62%) |
1 |
SELECT COUNT(*) FROM metier.reprise t0
Parameters:
[] |
|
3.96 ms (0.53%) |
12 |
SELECT t0.id AS id_1, t0.numero_billon AS numero_billon_2, t0.lng AS lng_3, t0.dm AS dm_4, t0.volume AS volume_5, t0.date_billonnage AS date_billonnage_6, t0.nb_elements AS nb_elements_7, t0.cloture AS cloture_8, t0.rebus AS rebus_9, t0.cloture_prod AS cloture_prod_10, t0.code_lignepagelje_id AS code_lignepagelje_id_11, t0.type_transformation_id AS type_transformation_id_12, t0.code_lot_id AS code_lot_id_13 FROM transformation.billon t0
Parameters:
[] |
|
3.43 ms (0.46%) |
2 |
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:
[] |
|
3.10 ms (0.42%) |
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
]
|
|
2.95 ms (0.40%) |
1 |
SELECT t0.id AS id_1, t0.numero_docbtgu AS numero_docbtgu_2, t0.delivre_docbtgu AS delivre_docbtgu_3, t0.etat AS etat_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.unique_doc AS unique_doc_9, t0.transmission AS transmission_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.type_document_id AS type_document_id_14, t0.code_generation_id AS code_generation_id_15, t0.exercice_id AS exercice_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentbtgu t0 WHERE t0.type_document_id = ?
Parameters:
[
6
]
|
|
2.88 ms (0.39%) |
1 |
SELECT t0.id AS id_1, t0.numero_doclje AS numero_doclje_2, t0.delivre_doclje AS delivre_doclje_3, t0.etat AS etat_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.unique_doc AS unique_doc_9, t0.transmission AS transmission_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentlje t0 WHERE t0.type_document_id = ?
Parameters:
[
5
]
|
|
2.53 ms (0.34%) |
1 |
SELECT t0.id AS id_1, t0.numero_docetate2 AS numero_docetate2_2, t0.delivre_docetate2 AS delivre_docetate2_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentetate2 t0 WHERE t0.type_document_id = ?
Parameters:
[
9
]
|
|
2.50 ms (0.34%) |
1 |
SELECT t0.id AS id_1, t0.numero_docetath AS numero_docetath_2, t0.delivre_docetath AS delivre_docetath_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.type_document_id AS type_document_id_14, t0.code_generation_id AS code_generation_id_15, t0.exercice_id AS exercice_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentetath t0 WHERE t0.type_document_id = ?
Parameters:
[
11
]
|
|
2.44 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4 FROM blog.categorie t0
Parameters:
[] |
|
2.33 ms (0.31%) |
1 |
SELECT t0.id AS id_1, t0.nom_prenoms AS nom_prenoms_2, t0.mot_ministre AS mot_ministre_3, t0.photo_ministre AS photo_ministre_4 FROM blog.autres_rubriques t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2.28 ms (0.31%) |
2 |
SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0
Parameters:
[] |
|
2.18 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.numero_docetatg AS numero_docetatg_2, t0.delivre_docetatg AS delivre_docetatg_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.exercice_id AS exercice_id_14, t0.type_document_id AS type_document_id_15, t0.code_generation_id AS code_generation_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentetatg t0 WHERE t0.type_document_id = ?
Parameters:
[
10
]
|
|
2.17 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.numero_docrsdpf AS numero_docrsdpf_2, t0.delivre_docresdpf AS delivre_docresdpf_3, t0.etat AS etat_4, t0.transmission AS transmission_5, t0.unique_doc AS unique_doc_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_commercant_id AS code_commercant_id_13, t0.type_document_id AS type_document_id_14, t0.code_generation_id AS code_generation_id_15, t0.code_demande_id AS code_demande_id_16, t0.exercice_id AS exercice_id_17 FROM metier.documentrsdpf t0 WHERE t0.type_document_id = ?
Parameters:
[
20
]
|
|
2.13 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.numero_docfp AS numero_docfp_2, t0.delivre_docfp AS delivre_docfp_3, t0.etat AS etat_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.unique_doc AS unique_doc_9, t0.transmission AS transmission_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usin_id AS code_usin_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentfp t0 WHERE t0.type_document_id = ?
Parameters:
[
7
]
|
|
2.12 ms (0.29%) |
1 |
SELECT max(a0_.id) AS sclr_0 FROM blog.article_blog a0_
Parameters:
[] |
|
2.09 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.numero_docdmv AS numero_docdmv_2, t0.delivre_docdmv AS delivre_docdmv_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_usine_id AS code_usine_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentdmv t0 WHERE t0.type_document_id = ?
Parameters:
[
13
]
|
|
2.08 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.numero_docdmp AS numero_docdmp_2, t0.delivre_docdmp AS delivre_docdmp_3, t0.unique_doc AS unique_doc_4, t0.transmission AS transmission_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.signature_dr AS signature_dr_10, t0.signature_cef AS signature_cef_11, t0.etat AS etat_12, t0.code_usine_id AS code_usine_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentdmp t0 WHERE t0.type_document_id = ?
Parameters:
[
12
]
|
|
2.08 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.numero_docpdtdrv AS numero_docpdtdrv_2, t0.delivre_docpdtdrv AS delivre_docpdtdrv_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.exercice_id AS exercice_id_13, t0.code_generation_id AS code_generation_id_14, t0.type_document_id AS type_document_id_15, t0.code_demande_id AS code_demande_id_16, t0.code_usine_id AS code_usine_id_17 FROM metier.documentpdtdrv t0 WHERE t0.type_document_id = ?
Parameters:
[
15
]
|
|
1.97 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.abv AS abv_2, t0.denomination AS denomination_3, t0.description AS description_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.nb_pages AS nb_pages_10, t0.tarif AS tarif_11, t0.stock_alert AS stock_alert_12, t0.lettre AS lettre_13, t0.limitation_pages AS limitation_pages_14, t0.nb_lignes AS nb_lignes_15, t0.code_type_operateur_id AS code_type_operateur_id_16 FROM metier.type_document_statistique t0 WHERE t0.statut = ?
Parameters:
[
"ACTIF"
]
|
|
1.91 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.type_diffusion AS type_diffusion_2, t0.source_diffusion AS source_diffusion_3, t0.duree AS duree_4, t0.date_emission AS date_emission_5, t0.date_arret AS date_arret_6, t0.contenu AS contenu_7, t0.id_element AS id_element_8, t0.rubrique AS rubrique_9, t0.titre AS titre_10, t0.created_at AS created_at_11, t0.created_by AS created_by_12, t0.updated_at AS updated_at_13, t0.updated_by AS updated_by_14, t0.fichier AS fichier_15, t0.code_type_diffusion_id AS code_type_diffusion_id_16 FROM admin.diffusion t0
Parameters:
[] |
|
1.91 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.resume AS resume_3, t0.fichier AS fichier_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.valide AS valide_9, t0.statut AS statut_10, t0.x AS x_11, t0.y AS y_12, t0.code_oi_id AS code_oi_id_13 FROM observateur.publication_rapport t0 WHERE t0.statut = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
"PUBLIE"
]
|
|
1.76 ms (0.24%) |
3 |
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.67 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.numero_docbrepf AS numero_docbrepf_2, t0.delivre_docbrepf AS delivre_docbrepf_3, t0.etat AS etat_4, t0.transmission AS transmission_5, t0.unique_doc AS unique_doc_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.exercice_id AS exercice_id_13, t0.code_generation_id AS code_generation_id_14, t0.type_document_id AS type_document_id_15, t0.code_demande_id AS code_demande_id_16, t0.code_autorisation_exportateur_id AS code_autorisation_exportateur_id_17 FROM metier.documentbrepf t0 WHERE t0.type_document_id = ?
Parameters:
[
19
]
|
|
1.67 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.numero_usine AS numero_usine_2, t0.raison_sociale_usine AS raison_sociale_usine_3, t0.personne_ressource AS personne_ressource_4, t0.cc_usine AS cc_usine_5, t0.tel_usine AS tel_usine_6, t0.fax_usine AS fax_usine_7, t0.adresse_usine AS adresse_usine_8, t0.localisation_usine AS localisation_usine_9, t0.ville AS ville_10, t0.capacite_usine AS capacite_usine_11, t0.sigle AS sigle_12, t0.email_personne_ressource AS email_personne_ressource_13, t0.mobile_personne_ressource AS mobile_personne_ressource_14, t0.export AS export_15, t0.code_exportateur AS code_exportateur_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.updated_at AS updated_at_20, t0.agree AS agree_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.code_cantonnement_id AS code_cantonnement_id_24, t0.code_exploitant_id AS code_exploitant_id_25 FROM metier.usine t0
Parameters:
[] |
|
1.42 ms (0.19%) |
1 |
SELECT t0.id AS id_1, t0.numero_docbcburb AS numero_docbcburb_2, t0.delivre_docbcburb AS delivre_docbcburb_3, t0.unique_doc AS unique_doc_4, t0.etat AS etat_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.permis_id AS permis_id_13, t0.type_document_id AS type_document_id_14, t0.code_generation_id AS code_generation_id_15, t0.exercice_id AS exercice_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentbcburb t0 WHERE t0.type_document_id = ?
Parameters:
[
18
]
|
|
1.41 ms (0.19%) |
1 |
SELECT t0.id AS id_1, t0.version AS version_2, t0.date_deploiement AS date_deploiement_3, t0.statut AS statut_4, t0.observations AS observations_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.fichier AS fichier_8 FROM admin.apk_ver t0 WHERE t0.statut = ? LIMIT 1
Parameters:
[
1
]
|
|
1.33 ms (0.18%) |
1 |
SELECT t0.id AS id_1, t0.numero_docetatb AS numero_docetatb_2, t0.delivre_docetatb AS delivre_docetatb_3, t0.etat AS etat_4, t0.unique_doc AS unique_doc_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_foret_id AS code_foret_id_13, t0.exercice_id AS exercice_id_14, t0.code_generation_id AS code_generation_id_15, t0.type_document_id AS type_document_id_16, t0.code_demande_id AS code_demande_id_17 FROM metier.documentetatb t0 WHERE t0.type_document_id = ?
Parameters:
[
4
]
|
|
1.10 ms (0.15%) |
2 |
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
Parameters:
[] |
|
1.07 ms (0.14%) |
1 |
SELECT t0.id AS id_1, t0.numero_docbcbp AS numero_docbcbp_2, t0.delivre_docbcbp AS delivre_docbcbp_3, t0.unique_doc AS unique_doc_4, t0.etat AS etat_5, t0.transmission AS transmission_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.signature_dr AS signature_dr_11, t0.signature_cef AS signature_cef_12, t0.code_generation_id AS code_generation_id_13, t0.type_document_id AS type_document_id_14, t0.exercice_id AS exercice_id_15, t0.code_demande_id AS code_demande_id_16, t0.code_autorisation_pv_id AS code_autorisation_pv_id_17 FROM metier.documentbcbp t0 WHERE t0.type_document_id = ?
Parameters:
[
3
]
|
|
0.91 ms (0.12%) |
1 |
SELECT COUNT(*) FROM metier.reprise t0 WHERE t0.exercice_id = ?
Parameters:
[
7
]
|
|
0.80 ms (0.11%) |
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 WHERE t0.cloture = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
0
]
|
|
0.69 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt_text AS alt_text_3, t0.filename AS filename_4 FROM blog.media t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.32 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.featured_text AS featured_text_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.featured_image_id AS featured_image_id_8 FROM blog.article_blog 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.