Query Metrics
5
Database Queries
5
Different statements
71.35 ms
Query time
88
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 62.09 ms |
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom_original AS nom_original_3, t0.date_arrete AS date_arrete_4, t0.date_inserion AS date_inserion_5, t0.code AS code_6, t0.libelle AS libelle_7, t0.categorie AS categorie_8, t0.numero AS numero_9, t0.numero_ordre AS numero_ordre_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.operateur_id AS operateur_id_14, t0.type_arrete_id AS type_arrete_id_15, t16.id AS id_17, t16.libelle AS libelle_18, t16.date_validite_debut AS date_validite_debut_19, t16.date_validite_fin AS date_validite_fin_20, t16.created_at AS created_at_21, t16.updated_at AS updated_at_22, t16.deleted_at AS deleted_at_23, t16.province_id AS province_id_24, t16.operateur_id AS operateur_id_25, t16.arrete_id AS arrete_id_26, t16.user_id AS user_id_27, t28.id AS id_29, t28.date_nomination AS date_nomination_30, t28.membre1 AS membre1_31, t28.membre2 AS membre2_32, t28.membre3 AS membre3_33, t28.membre4 AS membre4_34, t28.membre5 AS membre5_35, t28.nom AS nom_36, t28.created_at AS created_at_37, t28.updated_at AS updated_at_38, t28.deleted_at AS deleted_at_39, t28.arrete_id AS arrete_id_40, t28.etd_id AS etd_id_41, t28.user_id AS user_id_42, t0.user_id AS user_id_43 FROM arrete t0 LEFT JOIN agrement t16 ON t16.arrete_id = t0.id LEFT JOIN comite_pilotage t28 ON t28.arrete_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||
2 | 0.42 ms |
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 type_arrete t0
Parameters:
[]
|
||||||||||||||||||||||
3 | 7.98 ms |
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
Parameters:
[]
|
||||||||||||||||||||||
4 | 0.50 ms |
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:
[] |
||||||||||||||||||||||
5 | 0.36 ms |
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\CadreJuridique\Arrete |
|
App\Entity\Emine\Operateur\Operateur |
|
App\Entity\Emine\CadreJuridique\TypeArrete |
|
App\Entity\Emine\Activite\Agrement |
|
App\Entity\Emine\Operateur\Province |
|
App\Entity\User |
|
App\Entity\Emine\Autres\ComitePilotage |
|
App\Entity\Emine\Autres\Amodiation |
|
App\Entity\Emine\Activite\Cession |
|
App\Entity\Emine\Activite\Option |
|
App\Entity\Emine\Activite\TitreMinier |
|
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\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\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\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\Operateur\CahierDeCharge |
|
App\Entity\Emine\Operateur\Filiere |
|
App\Entity\Emine\Operateur\TypeCommodite | No errors. |
App\Entity\Emine\Impact\Environemental |
|
App\Entity\Emine\Activite\Transformation |
|
App\Entity\Emine\CadreJuridique\ContratRelatif |
|
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\Localisation |
|
App\Entity\Emine\Activite\Ressource |
|
App\Entity\Emine\Activite\Reserve |
|
App\Entity\Estat\Autres\RessourceEntreprise |
|
App\Entity\Estat\Autres\ReserveEntreprise |
|
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\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 |
|