Query Metrics
7
Database Queries
4
Different statements
5.03 ms
Query time
75
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.86 ms |
SELECT t0_.id AS id_0, t0_.permis AS permis_1, t0_.titulaire AS titulaire_2, t0_.type_permis AS type_permis_3, t0_.status AS status_4, t0_.date_octroi AS date_octroi_5, t0_.date_expiration AS date_expiration_6, t0_.carres AS carres_7, t0_.localisation AS localisation_8, t0_.code AS code_9, t0_.libelle AS libelle_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_.province_id AS province_id_15, t0_.arrete_id AS arrete_id_16, t0_.projet_id AS projet_id_17, t0_.gisement_id AS gisement_id_18, t0_.user_id AS user_id_19 FROM titre_minier t0_ WHERE t0_.type_permis = ?
Parameters:
[
"PEPM"
]
|
||||||||||||||||||||||||||||
2 | 0.32 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:
[] |
||||||||||||||||||||||||||||
3 | 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:
[] |
||||||||||||||||||||||||||||
4 | 0.49 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 WHERE t0.id = ?
Parameters:
[
7773
]
|
||||||||||||||||||||||||||||
5 | 0.32 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 WHERE t0.id = ?
Parameters:
[
8397
]
|
||||||||||||||||||||||||||||
6 | 0.36 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 WHERE t0.id = ?
Parameters:
[
7931
]
|
||||||||||||||||||||||||||||
7 | 0.31 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 WHERE t0.id = ?
Parameters:
[
7723
]
|
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\Activite\TitreMinier |
|
App\Entity\Emine\Operateur\Operateur |
|
App\Entity\Emine\Operateur\Province |
|
App\Entity\Emine\CadreJuridique\Arrete |
|
App\Entity\Emine\Activite\Projet |
|
App\Entity\Emine\Autres\Gisement |
|
App\Entity\User |
|
App\Entity\Emine\Impact\Environemental |
|
App\Entity\Emine\Autres\Amodiation |
|
App\Entity\Emine\Activite\Transformation |
|
App\Entity\Emine\Activite\Cession |
|
App\Entity\Emine\Activite\Transfert |
|
App\Entity\Emine\Activite\Option |
|
App\Entity\Emine\CadreJuridique\ContratPrincipal |
|
App\Entity\Emine\CadreJuridique\ContratRelatif |
|
App\Entity\Emine\Operateur\Filiere |
|
App\Entity\Emine\Operateur\Commodite |
|
App\Entity\Emine\Autres\Etd |
|
App\Entity\Emine\Autres\Zea |
|
App\Entity\Emine\Operateur\Categorie |
|
App\Entity\Emine\Operateur\FormeJuridique |
|
App\Entity\Emine\Operateur\Ville |
|
App\Entity\Emine\Operateur\Acquisition |
|
App\Entity\Emine\Operateur\Membre |
|
App\Entity\Emine\Operateur\InformationEmploi |
|
App\Entity\Emine\Actionnariat\Investissement |
|
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\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\Estat\Projection\Projection |
|
App\Entity\Emine\Production\Production |
|
App\Entity\Emine\Production\Exportation |
|
App\Entity\Estat\Autres\Usine |
|
App\Entity\Emine\Operateur\SousSecteur |
|
App\Entity\Emine\Operateur\Mandataire |
|
App\Entity\Emine\Autres\BesoinIntrant |
|
App\Entity\Emine\Operateur\Site |
|
App\Entity\Emine\Activite\Agrement |
|
App\Entity\Emine\Operateur\CahierDeCharge |
|
App\Entity\Emine\CadreJuridique\TypeArrete |
|
App\Entity\Emine\Autres\ComitePilotage |
|
App\Entity\Emine\Activite\Extraction |
|
App\Entity\Emine\Activite\Traitement |
|
App\Entity\Emine\Activite\Mine |
|
App\Entity\Estat\Autres\RessourceEntreprise |
|
App\Entity\Estat\Autres\ReserveEntreprise |
|
App\Entity\Emine\Activite\Reserve |
|
App\Entity\Emine\Activite\Ressource |
|
App\Entity\Emine\Operateur\TypeCommodite | No errors. |
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\Operateur\Localisation |
|
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\Autres\Comite |
|
App\Entity\Emine\Autres\Entreprise |
|
App\Entity\Emine\Autres\EtdSecondaire |
|
App\Entity\Emine\Autres\DepenseEtd |
|
App\Entity\Emine\Autres\ProjetEtd |
|