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

Query Metrics

630 Database Queries
13 Different statements
161.67 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
98.17 ms
(60.72%)
432
SELECT t0.id AS id_1, t0.numero_autorisation AS numero_autorisation_2, t0.date_autorisation AS date_autorisation_3, t0.created_by AS created_by_4, t0.created_at AS created_at_5, t0.updated_by AS updated_by_6, t0.updated_at AS updated_at_7, t0.validation_document AS validation_document_8, t0.statut AS statut_9, t0.motif AS motif_10, t0.code_attribution_id AS code_attribution_id_11, t0.exercice_id AS exercice_id_12 FROM metier.reprise t0 WHERE t0.code_attribution_id = ? LIMIT 1
Parameters:
[
  1774
]
48.70 ms
(30.12%)
187
SELECT t0.id AS id_1, t0.numero_decision AS numero_decision_2, t0.date_decision AS date_decision_3, t0.statut AS statut_4, t0.reprise AS reprise_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.validation_document AS validation_document_8, t0.retire AS retire_9, t0.abandonne AS abandonne_10, t0.motif AS motif_11, t0.date_retrait AS date_retrait_12, t0.date_abandon AS date_abandon_13, t0.code_exploitant_id AS code_exploitant_id_14, t0.code_foret_id AS code_foret_id_15, t0.exercice_id AS exercice_id_16 FROM metier.attribution t0 WHERE t0.code_exploitant_id = ? AND t0.statut = ? AND t0.exercice_id = ?
Parameters:
[
  84
  1
  7
]
6.21 ms
(3.84%)
1
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
]
1.73 ms
(1.07%)
1
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:
[]
1.26 ms
(0.78%)
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.20 ms
(0.74%)
1
SELECT COUNT(*) FROM metier.usine t0
Parameters:
[]
0.79 ms
(0.49%)
1
SELECT COUNT(*) FROM metier.exportateur t0
Parameters:
[]
0.78 ms
(0.48%)
1
SELECT COUNT(*) FROM metier.cantonnement t0
Parameters:
[]
0.63 ms
(0.39%)
1
SELECT COUNT(*) FROM metier.poste_forestier t0
Parameters:
[]
0.62 ms
(0.38%)
1
SELECT COUNT(*) FROM metier.ddef t0
Parameters:
[]
0.59 ms
(0.37%)
1
SELECT COUNT(*) FROM metier.dr t0
Parameters:
[]
0.53 ms
(0.33%)
1
SELECT COUNT(*) FROM metier.exploitant t0
Parameters:
[]
0.46 ms
(0.29%)
1
SELECT COUNT(*) FROM metier.oi 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\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\References\QualiteExploitant No errors.
App\Entity\DocStats\Saisie\Lignepageetate No errors.
App\Entity\DocStats\Saisie\Lignepageetate2 No errors.
App\Entity\Administration\FicheProspection No errors.
App\Entity\References\Foret
  • The association App\Entity\References\Foret#documentetatbs refers to the owning side field App\Entity\DocStats\Entetes\Documentetatb#code_exploitant which does not exist.