Query Metrics
128
Database Queries
6
Different statements
36.03 ms
Query time
17
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Admin\Exercice |
|
| App\Entity\DocStats\Entetes\Documentlje | No errors. |
| App\Entity\DocStats\Entetes\Documentbtgu | No errors. |
| App\Entity\DocStats\Saisie\Lignepagelje | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebcbp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebtgu | No errors. |
| App\Entity\DocStats\Entetes\Documentfp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagefp | No errors. |
| App\Entity\DocStats\Entetes\Documentcp | No errors. |
| App\Entity\DocStats\Entetes\Documentbrh | No errors. |
| App\Entity\DocStats\Entetes\Documentbcbp | No errors. |
| App\Entity\DocStats\Entetes\Documentetate |
|
| App\Entity\DocStats\Entetes\Documentetate2 | No errors. |
| App\Entity\DocStats\Entetes\Documentetatg | No errors. |
| App\Entity\DocStats\Entetes\Documentetath | No errors. |
| App\Entity\DocStats\Entetes\Documentdmp | No errors. |
| App\Entity\DocStats\Entetes\Documentdmv | No errors. |
| App\Entity\DocStats\Entetes\Documentpdtdrv | No errors. |
| App\Entity\Autorisation\AutorisationPs | No errors. |
| App\Entity\Autorisation\AutorisationPv | No errors. |
| App\Entity\Autorisation\AutorisationPdtdrv | No errors. |
| App\Entity\Transformation\Contrat | No errors. |
| App\Entity\DocStats\Entetes\Documentbcburb | No errors. |
| App\Entity\DocStats\Entetes\Documentbrepf | No errors. |
| App\Entity\Autorisation\AutorisationExportateur | No errors. |
| App\Entity\DocStats\Entetes\Documentrsdpf | No errors. |
| App\Entity\DocStats\Entetes\Documentbth | No errors. |
| App\Entity\Transformation\Colis | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebrh | No errors. |
| App\Entity\Autorisation\Attribution | No errors. |
| App\Entity\Autorisation\Reprise | No errors. |
| App\Entity\DocStats\Saisie\Lignepagecp | No errors. |
| App\Entity\DocStats\Entetes\SuiviDoc | No errors. |
| App\Entity\References\ZoneHemispherique | No errors. |
| App\Entity\References\Essence | No errors. |
| App\Entity\DocStats\Pages\Pagecp | No errors. |
| App\Entity\Administration\InventaireForestier | No errors. |
| App\Entity\DocStats\Pages\Pagebcbp | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetate | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetate2 | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetatg | No errors. |
| App\Entity\DocStats\Saisie\Lignepageetath | No errors. |
| App\Entity\DocStats\Saisie\Lignepagedmp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagedmv | No errors. |
| App\Entity\Transformation\FicheJourTransfo | No errors. |
| App\Entity\DocStats\Saisie\Lignepagebrepf | No errors. |
| App\Entity\Transformation\Details2Transfo | No errors. |
| App\Entity\Transformation\Elements | No errors. |
| App\Entity\Blog\CategoryPublication | No errors. |
| App\Entity\Blog\GroupePublication | No errors. |
| App\Entity\Blog\Publication | No errors. |
| App\Entity\Blog\FichierPublication | No errors. |
| App\Entity\References\Usine | No errors. |
| App\Entity\Administration\DocStatsGen | No errors. |
| App\Entity\References\TypeDocumentStatistique |
|
| App\Entity\DocStats\Pages\Pagelje | No errors. |
| App\Entity\Administration\DemandeOperateur | No errors. |
| App\Entity\DocStats\Pages\Pagebtgu | No errors. |
| App\Entity\Transformation\Billon | No errors. |
| App\Entity\References\Exploitant | No errors. |
| App\Entity\DocStats\Saisie\HistoriqueLje | No errors. |
| App\Entity\DocStats\Pages\Pagefp | No errors. |
| App\Entity\DocStats\Pages\Pagebrh | No errors. |
| App\Entity\DocStats\Pages\Pageetate | No errors. |
| App\Entity\DocStats\Pages\Pageetate2 | No errors. |
| App\Entity\DocStats\Pages\Pageetatg | No errors. |
| App\Entity\DocStats\Pages\Pageetath | No errors. |
| App\Entity\DocStats\Pages\Pagedmp | No errors. |
| App\Entity\DocStats\Pages\Pagedmv | No errors. |
| App\Entity\DocStats\Pages\Pagepdtdrv | No errors. |
| App\Entity\Autorisation\AgreementPs | No errors. |
| App\Entity\References\NaturePs | No errors. |
| App\Entity\Autorisation\AttributionPv | No errors. |
| App\Entity\Autorisation\AgreementPdtdrv | No errors. |
| App\Entity\References\Pays | No errors. |
| App\Entity\References\TypeTransformation | No errors. |
| App\Entity\Transformation\TypeContrat | No errors. |
| App\Entity\Admin\Coupon | No errors. |
| App\Entity\DocStats\Pages\Pagebcburb | No errors. |
| App\Entity\DocStats\Pages\Pagebrepf | No errors. |
| App\Entity\Autorisation\AgreementExportateur | No errors. |
| App\Entity\References\Commercant | No errors. |
| App\Entity\DocStats\Pages\Pagersdpf | No errors. |
| App\Entity\DocStats\Pages\Pagebth | No errors. |
| App\Entity\Transformation\ElementsColis | No errors. |
| App\Entity\References\Foret |
|
| App\Entity\Administration\FicheProspection | No errors. |
| App\Entity\References\PageDocGen | No errors. |
| App\Entity\Administration\FicheProspectionFc |
|
| App\Entity\References\Cantonnement | No errors. |
| App\Entity\References\ProduitsUsine | No errors. |
| App\Entity\Transformation\DetailFicheJourTransfo | No errors. |
| App\Entity\Transformation\Fiche2Transfo | No errors. |
| App\Entity\Transformation\FicheLotProd | No errors. |
| App\Entity\Transformation\FicheLot | No errors. |
| App\Entity\User |
|
| App\Entity\DocStats\Saisie\Lignepagersdpf | No errors. |
| App\Entity\Administration\StockDoc | No errors. |
| App\Entity\References\TypeOperateur | No errors. |
| App\Entity\DocStats\Entetes\Documentetatb |
|
| App\Entity\References\CircuitCommunication | No errors. |
| App\Entity\References\Exportateur | No errors. |
| App\Entity\References\QualiteExploitant | No errors. |
| App\Entity\References\Dr | No errors. |
| App\Entity\References\Ddef | No errors. |
| App\Entity\References\AttributairePs | No errors. |
| App\Entity\References\TypeDossierPs | No errors. |
| App\Entity\Transformation\Pdt2Transfo | No errors. |
| App\Entity\Admin\DocumentsCoupon |
|
| App\Entity\DocStats\Saisie\Lignepagebcburb | No errors. |
| App\Entity\References\Nationalite | No errors. |
| App\Entity\Autorisation\AgreementCommercant | No errors. |
| App\Entity\References\TypeForet | No errors. |
| App\Entity\DocStats\Pages\Pageetatb | No errors. |
| App\Entity\Autorisation\ContratBcbgfh |
|
| App\Entity\References\Ugf | No errors. |
| App\Entity\Observateur\PublicationRapport | No errors. |
| App\Entity\Administration\ProspectionTemp | No errors. |
| App\Entity\DocStats\Saisie\Lignepagepdtdrv | No errors. |
| App\Entity\References\PosteForestier | No errors. |
| App\Entity\Observateur\Ticket | No errors. |
| App\Entity\Transformation\EltsProd | No errors. |
| App\Entity\Admin\LogSnvlt | No errors. |
| App\Entity\Admin\Option | No errors. |
| App\Entity\Administration\ApkVer | No errors. |
| App\Entity\Administration\Gadget | No errors. |
| App\Entity\Administration\Messagerie |
|
| App\Entity\Administration\Notification | No errors. |
| App\Entity\Administration\PieceJointe | No errors. |
| App\Entity\Autorisation\DepotCommercant | No errors. |
| App\Entity\Autres\Contacter | No errors. |
| App\Entity\Blog\Abonne | No errors. |
| App\Entity\Blog\ArticleBlog | No errors. |
| App\Entity\Blog\AutresRubriques | No errors. |
| App\Entity\Blog\Categorie | No errors. |
| App\Entity\Blog\Comment | No errors. |
| App\Entity\Blog\Media | No errors. |
| App\Entity\Blog\MenuBlog |
|
| App\Entity\Blog\Page | No errors. |
| App\Entity\DemandeAutorisation\DemandeDocument | No errors. |
| App\Entity\DemandeAutorisation\Document | No errors. |
| App\Entity\DemandeAutorisation\EtapeValidation | No errors. |
| App\Entity\DemandeAutorisation\NouvelleDemande | No errors. |
| App\Entity\DemandeAutorisation\TypeDemande |
|
| App\Entity\DemandeAutorisation\TypeDemandeDetail | No errors. |
| App\Entity\DemandeAutorisation\TypeDocument | No errors. |
| App\Entity\DemandeAutorisation\ValidationAction | No errors. |
| App\Entity\DetailsCircuitActes |
|
| App\Entity\Diffusion | No errors. |
| App\Entity\DisponibiliteParcBilles | No errors. |
| App\Entity\DisponibiliteParcBillons | No errors. |
| App\Entity\DocStats\DocsStats | No errors. |
| App\Entity\DocStats\DonneesSodefor | No errors. |
| App\Entity\DocStats\Entetes\Documentbcbgfh |
|
| App\Entity\DocStats\ImportData |
|
| App\Entity\DocStats\Pages\Pagebcbgfh |
|
| App\Entity\DocStats\Saisie\Lignepagebcbgfh |
|
| App\Entity\Document | No errors. |
| App\Entity\Employe | No errors. |
| App\Entity\Groupe | No errors. |
| App\Entity\Helper\Media | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuPermission | No errors. |
| App\Entity\Observateur\AnalyseRapport | No errors. |
| App\Entity\Observateur\AnnexeRapport | No errors. |
| App\Entity\Observateur\Fichiers | No errors. |
| App\Entity\Observateur\RecommendationAnalyse | No errors. |
| App\Entity\Observateur\StatutAlerte | No errors. |
| App\Entity\Observateur\StatutRapportOI | No errors. |
| App\Entity\Observateur\TicketFiles | No errors. |
| App\Entity\Observateur\TypeRapport | No errors. |
| App\Entity\Observateur\TypeRapportOi | No errors. |
| App\Entity\Paiement\CatalogueServices | No errors. |
| App\Entity\Paiement\Transaction | No errors. |
| App\Entity\Paiement\TypePaiement | No errors. |
| App\Entity\Pef | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\References\Caroi | No errors. |
| App\Entity\References\Dcg | No errors. |
| App\Entity\References\DetailsModele | No errors. |
| App\Entity\References\Direction | No errors. |
| App\Entity\References\DocumentOperateur | No errors. |
| App\Entity\References\GrilleLegalite | No errors. |
| App\Entity\References\Imprimeur | No errors. |
| App\Entity\References\ModeleCommunication | No errors. |
| App\Entity\References\Oi | No errors. |
| App\Entity\References\Preference | No errors. |
| App\Entity\References\ServiceMinef | No errors. |
| App\Entity\References\SousPrefecture | No errors. |
| App\Entity\References\Titre | No errors. |
| App\Entity\References\TypeAutorisation | No errors. |
| App\Entity\References\TypeDemande | No errors. |
| App\Entity\References\TypeDiffusion | No errors. |
| App\Entity\References\TypeModeleCommunication | No errors. |
| App\Entity\References\TypesDemandeur | No errors. |
| App\Entity\References\TypesService | No errors. |
| App\Entity\Requetes\CubageEssences | No errors. |
| App\Entity\Requetes\MenuRequetes | No errors. |
| App\Entity\Requetes\PerformanceBrh | No errors. |
| App\Entity\Requetes\PerformanceBrhJour | No errors. |
| App\Entity\Requetes\Qt | No errors. |
| App\Entity\Requetes\QuotaTransferable | No errors. |
| App\Entity\Requetes\StatsByExploitantAnneeEssence | No errors. |
| App\Entity\Requetes\StatsByForetAnneeEssence | No errors. |
| App\Entity\Requetes\StatsMensuelles | No errors. |
| App\Entity\Requetes\TypeRequetes | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\Vues\ChargementCours | No errors. |
| App\Entity\Vues\EssenceVolumeTop10 | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |