Query Metrics
844
Database Queries
5
Different statements
121.15 ms
Query time
6
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
50.27 ms (41.49%) |
367 |
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.id = ? LIMIT 1
Parameters:
[
1605
]
|
46.37 ms (38.28%) |
358 |
SELECT t0.id AS id_1, t0.numero_foret AS numero_foret_2, t0.denomination AS denomination_3, t0.superficie AS superficie_4, t0.date_premiere_attribution AS date_premiere_attribution_5, t0.updated_by AS updated_by_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.attribue AS attribue_10, t0.reprise AS reprise_11, t0.dernier_numero AS dernier_numero_12, t0.code_type_foret_id AS code_type_foret_id_13, t0.code_cantonnement_id AS code_cantonnement_id_14, t0.code_ugf_id AS code_ugf_id_15 FROM metier.foret t0 WHERE t0.id = ?
Parameters:
[
157
]
|
20.97 ms (17.31%) |
117 |
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 WHERE t0.id = ?
Parameters:
[
29
]
|
1.77 ms (1.46%) |
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.77 ms (1.46%) |
1 |
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.exercice_id = ?
Parameters:
[
7
]
|
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\Administration\DemandeOperateur | No errors. |
App\Entity\References\Exploitant | No errors. |
App\Entity\References\Foret |
|
App\Entity\Administration\FicheProspection | No errors. |
App\Entity\References\Cantonnement | No errors. |
App\Entity\User |
|
App\Entity\References\QualiteExploitant | No errors. |
App\Entity\References\Usine | No errors. |
App\Entity\DocStats\Saisie\Lignepageetate | No errors. |
App\Entity\DocStats\Saisie\Lignepageetate2 | No errors. |
App\Entity\References\TypeForet | No errors. |
App\Entity\References\Ugf | No errors. |
App\Entity\Administration\InventaireForestier | No errors. |
App\Entity\DocStats\Pages\Pageetatb | No errors. |
App\Entity\Autorisation\AttributionPv | No errors. |
App\Entity\Autorisation\ContratBcbgfh |
|
App\Entity\Observateur\PublicationRapport | No errors. |
App\Entity\DocStats\Entetes\Documentetatb |
|