Query Metrics
5
Database Queries
4
Different statements
2.39 ms
Query time
88
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.77 ms (32.48%) |
1 |
SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.categorie_id AS categorie_id_42, t0.forme_juridique_id AS forme_juridique_id_43, t0.ville_id AS ville_id_44, t0.sous_secteur_id AS sous_secteur_id_45, t0.etd_id AS etd_id_46, t0.province_id AS province_id_47, t0.user_id AS user_id_48 FROM operateur t0 WHERE t0.id = ?
Parameters:
[
"7847"
]
|
||||||||||||||||||||||||||||
0.72 ms (30.05%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0
Parameters:
[]
|
||||||||||||||||||||||||||||
0.68 ms (28.71%) |
1 |
SELECT SUM(r0_.quantite) AS sclr_0, SUM(r1_.quantite) AS sclr_1, c2_.nom AS nom_2 FROM reserve_entreprise r0_ INNER JOIN projet p3_ ON r0_.projet_id = p3_.id INNER JOIN commodite c2_ ON r0_.commodite_id = c2_.id LEFT JOIN ressource_entreprise r1_ ON c2_.id = r1_.commite_id AND (r1_.commite_id = c2_.id) WHERE c2_.filiere_id = ? AND p3_.operateur_id = ? AND (r0_.date_reserve BETWEEN ? AND ?) GROUP BY c2_.nom
Parameters:
[ 1 7847 "2024-01-01 00:00:00" "2024-12-31 23:59:00" ]
|
||||||||||||||||||||||||||||
0.21 ms (8.75%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_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\Emine\Operateur\Operateur |
|
App\Entity\Emine\Operateur\Categorie |
|
App\Entity\Emine\Operateur\FormeJuridique |
|
App\Entity\Emine\Operateur\Ville |
|
App\Entity\Emine\Operateur\SousSecteur |
|
App\Entity\Emine\Autres\Etd |
|
App\Entity\Emine\Operateur\Province |
|
App\Entity\User |
|
App\Entity\Emine\Operateur\Commodite |
|
App\Entity\Emine\Operateur\Acquisition |
|
App\Entity\Emine\Operateur\Membre |
|
App\Entity\Emine\Operateur\InformationEmploi |
|
App\Entity\Emine\Actionnariat\Investissement |
|
App\Entity\Emine\CadreJuridique\ContratPrincipal |
|
App\Entity\Emine\Obligation\Taxe |
|
App\Entity\Emine\Obligation\Redevance |
|
App\Entity\Emine\Obligation\Rapatriement |
|
App\Entity\Emine\Obligation\EtatFinancier |
|
App\Entity\Emine\Obligation\Paiement |
|
App\Entity\Emine\Activite\TitreMinier |
|
App\Entity\Emine\CadreJuridique\Arrete |
|
App\Entity\Emine\Autres\Gisement |
|
App\Entity\Emine\Autres\BesoinEnergetique |
|
App\Entity\Emine\Autres\Contribution |
|
App\Entity\Emine\Obligation\InformationFinanciere |
|
App\Entity\Emine\Actionnariat\PartActionnaire |
|
App\Entity\Emine\Actionnariat\PartInvestisseur |
|
App\Entity\Emine\Impact\Accident |
|
App\Entity\Emine\Impact\Mst |
|
App\Entity\Emine\Impact\Pollution |
|
App\Entity\Emine\Production\VenteLocal |
|
App\Entity\Emine\Autres\Amodiation |
|
App\Entity\Emine\Activite\Cession |
|
App\Entity\Emine\Activite\Option |
|
App\Entity\Emine\Activite\Transfert |
|
App\Entity\Estat\Projection\Projection |
|
App\Entity\Emine\Production\Production |
|
App\Entity\Emine\Production\Exportation |
|
App\Entity\Estat\Autres\Usine |
|
App\Entity\Emine\Activite\Projet |
|
App\Entity\Emine\Operateur\Mandataire |
|
App\Entity\Emine\Autres\BesoinIntrant |
|
App\Entity\Emine\Autres\Zea |
|
App\Entity\Emine\Operateur\Site |
|
App\Entity\Emine\Activite\Agrement |
|
App\Entity\Emine\Operateur\CahierDeCharge |
|
App\Entity\Emine\Operateur\Filiere |
|
App\Entity\Estat\Autres\ReserveEntreprise |
|
App\Entity\Estat\Autres\RessourceEntreprise |
|
App\Entity\Emine\Operateur\Secteur |
|
App\Entity\Emine\Autres\Comite |
|
App\Entity\Emine\Autres\Entreprise |
|
App\Entity\Emine\Autres\EtdSecondaire |
|
App\Entity\Emine\Autres\DepenseEtd |
|
App\Entity\Emine\Autres\ProjetEtd |
|
App\Entity\Emine\Operateur\TypeCommodite | No errors. |
App\Entity\Emine\Operateur\Localisation |
|
App\Entity\Emine\CadreJuridique\ContratRelatif |
|
App\Entity\Emine\Activite\Ressource |
|
App\Entity\Emine\Activite\Reserve |
|
App\Entity\Emine\Autres\CoursMoyensDesMetaux |
|
App\Entity\Estat\Autres\DecouverteReserve |
|
App\Entity\Estat\Autres\DecouverteRessource |
|
App\Entity\Estat\Autres\ReserveHistorique |
|
App\Entity\Estat\Autres\RessourceHistorique |
|
App\Entity\Emine\Activite\Traitement |
|
App\Entity\Emine\Operateur\ProprietaireReel |
|
App\Entity\Emine\Actionnariat\Pays |
|
App\Entity\Emine\CadreJuridique\PartContrat |
|
App\Entity\Emine\CadreJuridique\TypeContrat |
|
App\Entity\Emine\CadreJuridique\TypeDocument |
|
App\Entity\Emine\CadreJuridique\EntiteGouvernementale |
|
App\Entity\Emine\Obligation\TypeTaxe |
|
App\Entity\Emine\Obligation\RepartitionRedevance |
|
App\Entity\Emine\Obligation\ServiceEtat |
|
App\Entity\Emine\Impact\Environemental |
|
App\Entity\Emine\Activite\Transformation |
|
App\Entity\Emine\CadreJuridique\TypeArrete |
|
App\Entity\Emine\Autres\ComitePilotage |
|
App\Entity\Emine\Activite\Mine |
|
App\Entity\Emine\Autres\TypeContribution |
|
App\Entity\Emine\Obligation\RepartitionDotation |
|
App\Entity\Emine\Actionnariat\Actionnaire |
|
App\Entity\Emine\Actionnariat\Investisseur |
|
App\Entity\Emine\Impact\TypeMaladie | No errors. |
App\Entity\Emine\Impact\TypePollution | No errors. |
App\Entity\Emine\Production\Rejet |
|
App\Entity\Emine\Production\ProduitValorisable |
|
App\Entity\Emine\Activite\Extraction |
|
App\Entity\Emine\Activite\Intrant |
|
App\Entity\Emine\Operateur\ProjetCahierDeCharge |
|