GET http://boislegal.ci/snvlt/st752c938b59b99200fa3bb26e80efc9d1/pt/6LfpPfooAAAAAIiyD9NpidUyC9x-yAy8Y17L5hl4

Query Metrics

3 Database Queries
3 Different statements
171.74 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
167.94 ms
(97.79%)
1
SELECT t0.id AS id_1, t0.abv AS abv_2, t0.nb_delivres AS nb_delivres_3, t0.nb_saisi AS nb_saisi_4, t0.exo AS exo_5 FROM metier.docs_stats t0 ORDER BY t0.nb_delivres DESC LIMIT 5
Parameters:
[]
2.04 ms
(1.19%)
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
]
1.75 ms
(1.02%)
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
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
  • The mappings App\Entity\Admin\Exercice#lignepagebcbps and App\Entity\DocStats\Saisie\Lignepagebcbp#exercice are inconsistent with each other.
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
  • The field 'App\Entity\DocStats\Entetes\Documentetate#updated_at' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
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\TypeDocumentStatistique
  • The field App\Entity\References\TypeDocumentStatistique#documentetatbs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocStats\Entetes\Documentetatb#type_document does not contain the required 'inversedBy="documentetatbs"' attribute.
App\Entity\References\TypeOperateur No errors.
App\Entity\Administration\StockDoc No errors.
App\Entity\Administration\DocStatsGen No errors.
App\Entity\Administration\DemandeOperateur No errors.
App\Entity\DocStats\Entetes\Documentetatb
  • The field 'App\Entity\DocStats\Entetes\Documentetatb#updated_at' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
  • The mappings App\Entity\DocStats\Entetes\Documentetatb#code_foret and App\Entity\References\Foret#documentetatbs are inconsistent with each other.
  • The association App\Entity\DocStats\Entetes\Documentetatb#exercice refers to the inverse side field App\Entity\Admin\Exercice#documentetatbs which does not exist.
  • The association App\Entity\DocStats\Entetes\Documentetatb#code_generation refers to the inverse side field App\Entity\Administration\DocStatsGen#documentetatbs which does not exist.
  • The association App\Entity\DocStats\Entetes\Documentetatb#code_demande refers to the inverse side field App\Entity\Administration\DemandeOperateur#documentetatbs which does not exist.
App\Entity\DocStats\DocsStats No errors.