Query Metrics
6
Database Queries
6
Different statements
3.28 ms
Query time
57
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.13 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.sous_categorie_id AS sous_categorie_id_43, t0.user_id AS user_id_44 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.45 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 | 0.92 ms |
SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.nature AS nature_3, o0_.raison_sociale AS raison_sociale_4, o0_.regime_fiscal AS regime_fiscal_5, o0_.siege AS siege_6, o0_.annee_fermeture AS annee_fermeture_7, o0_.nombre_surccursale AS nombre_surccursale_8, o0_.code_unique AS code_unique_9, o0_.rccm AS rccm_10, o0_.id_nationnal AS id_nationnal_11, o0_.num_ident_fiscal AS num_ident_fiscal_12, o0_.num_import_export AS num_import_export_13, o0_.num_affactation_inss AS num_affactation_inss_14, o0_.num_affectation_inpp AS num_affectation_inpp_15, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_16, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_17, o0_.capital_social AS capital_social_18, o0_.num_tva AS num_tva_19, o0_.num_dgda AS num_dgda_20, o0_.num_dgi AS num_dgi_21, o0_.num_dgrad AS num_dgrad_22, o0_.num_occ AS num_occ_23, o0_.boite_postal AS boite_postal_24, o0_.fax AS fax_25, o0_.telephone AS telephone_26, o0_.site_web AS site_web_27, o0_.email AS email_28, o0_.fichier AS fichier_29, o0_.nom_original AS nom_original_30, o0_.description AS description_31, o0_.anne_creation AS anne_creation_32, o0_.code_operateur AS code_operateur_33, o0_.code_indentification AS code_indentification_34, o0_.date_creation AS date_creation_35, o0_.service AS service_36, o0_.profil_oil AS profil_oil_37, o0_.detail_regime AS detail_regime_38, o0_.zone AS zone_39, o0_.date_agrement AS date_agrement_40, o0_.date_expiration_agrement AS date_expiration_agrement_41, o0_.sous_categorie AS sous_categorie_42, o0_.created_at AS created_at_43, o0_.updated_at AS updated_at_44, o0_.deleted_at AS deleted_at_45, o0_.categorie_id AS categorie_id_46, o0_.forme_juridique_id AS forme_juridique_id_47, o0_.ville_id AS ville_id_48, o0_.sous_secteur_id AS sous_secteur_id_49, o0_.etd_id AS etd_id_50, o0_.province_id AS province_id_51, o0_.secteur_id AS secteur_id_52, o0_.statut_id AS statut_id_53, o0_.user_id AS user_id_54 FROM operateur o0_ INNER JOIN arrete a1_ ON o0_.id = a1_.operateur_id ORDER BY o0_.id ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 0.35 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.18 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:
[] |
||||||||||||||||||||||||||||
| 6 | 0.24 ms |
SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.user_id AS user_id_19 FROM gisement 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\CadreJuridique\SousCategorieArrete |
|
| 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\Secteur |
|
| App\Entity\Emine\Operateur\Statut |
|
| 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\Activite\Mine |
|
| App\Entity\Emine\Obligation\Assurance |
|
| App\Entity\Emine\Production\Importation |
|
| App\Entity\Emine\Operateur\SiegeExploitation |
|
| App\Entity\Emine\CadreJuridique\ContratRelatif |
|
| App\Entity\Emine\Operateur\Filiere |
|
| App\Entity\Emine\Operateur\TypeCommodite | No errors. |