POST http://boislegal.ci/snvlt/p/st/pt_docs_generated

Response
200 OK
Browse referrer URL
IP
54.39.240.7
Profiled on
Token
f1bd6d

Query Metrics

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

Queries

Group similar statements

default connection

#▲ Time Info
1 5.18 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nom_utilisateur AS nom_utilisateur_6, t0.prenoms_utilisateur AS prenoms_utilisateur_7, t0.photo AS photo_8, t0.statut AS statut_9, t0.agent_sodef AS agent_sodef_10, t0.actif AS actif_11, t0.nouveau AS nouveau_12, t0.mobile AS mobile_13, t0.profile_user AS profile_user_14, t0.numero_exploitant AS numero_exploitant_15, t0.log_code AS log_code_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_at AS updated_at_19, t0.updated_by AS updated_by_20, t0.is_responsable AS is_responsable_21, t0.code_sms AS code_sms_22, t0.locale AS locale_23, t0.fonction AS fonction_24, t0.superviseur_groupe AS superviseur_groupe_25, t0.code_groupe_id AS code_groupe_id_26, t0.codeexploitant_id AS codeexploitant_id_27, t0.code_service_id AS code_service_id_28, t0.code_direction_id AS code_direction_id_29, t0.codeindustriel_id AS codeindustriel_id_30, t0.code_dr_id AS code_dr_id_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.code_operateur_id AS code_operateur_id_33, t0.code_ddef_id AS code_ddef_id_34, t0.code_poste_controle_id AS code_poste_controle_id_35, t0.code_exportateur_id AS code_exportateur_id_36, t0.titre_id AS titre_id_37, t0.code_commercant_id AS code_commercant_id_38, t0.code_oi_id AS code_oi_id_39 FROM "user" t0 WHERE t0.id = ?
Parameters: 
[
  542
]
View formatted query    View runnable query    Explain query
2 1.00 ms 
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
]
View formatted query    View runnable query    Explain query
3 188.52 ms 
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 WHERE t0.exo = ? ORDER BY t0.nb_delivres DESC
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query

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\User
  • The mappings App\Entity\User#code_cantonnement and App\Entity\References\Cantonnement#utilisateurs are inconsistent with each other.
  • The mappings App\Entity\User#mes_messages and App\Entity\Administration\Messagerie#code_utilisateur are inconsistent with each other.
App\Entity\Groupe No errors.
App\Entity\References\Exploitant No errors.
App\Entity\References\ServiceMinef No errors.
App\Entity\References\Direction No errors.
App\Entity\References\Usine No errors.
App\Entity\References\Dr No errors.
App\Entity\References\Cantonnement No errors.
App\Entity\References\TypeOperateur No errors.
App\Entity\References\Ddef No errors.
App\Entity\References\PosteForestier No errors.
App\Entity\References\Exportateur No errors.
App\Entity\References\Titre No errors.
App\Entity\References\Commercant No errors.
App\Entity\References\Oi No errors.
App\Entity\Administration\Notification No errors.
App\Entity\Administration\DemandeOperateur No errors.
App\Entity\Administration\Messagerie
  • The association App\Entity\Administration\Messagerie#code_utilisateur refers to the inverse side field App\Entity\User#code_utilisateur which does not exist.
App\Entity\References\DocumentOperateur No errors.
App\Entity\Admin\LogSnvlt No errors.
App\Entity\Observateur\Ticket No errors.
App\Entity\References\Caroi No 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\DocStats\DocsStats No errors.