Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.94 ms Query time

8 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.94 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.part_etat AS part_etat_39, t0.devise AS devise_40, t0.logo AS logo_41, t0.token AS token_42, t0.domaine AS domaine_43, t0.id_dw AS id_dw_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.deleted_at AS deleted_at_47, t0.categorie_id AS categorie_id_48, t0.forme_juridique_id AS forme_juridique_id_49, t0.ville_id AS ville_id_50, t0.sous_secteur_id AS sous_secteur_id_51, t0.etd_id AS etd_id_52, t0.province_id AS province_id_53, t0.user_id AS user_id_54 FROM operateur t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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.part_etat AS part_etat_39,
  t0.devise AS devise_40,
  t0.logo AS logo_41,
  t0.token AS token_42,
  t0.domaine AS domaine_43,
  t0.id_dw AS id_dw_44,
  t0.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.deleted_at AS deleted_at_47,
  t0.categorie_id AS categorie_id_48,
  t0.forme_juridique_id AS forme_juridique_id_49,
  t0.ville_id AS ville_id_50,
  t0.sous_secteur_id AS sous_secteur_id_51,
  t0.etd_id AS etd_id_52,
  t0.province_id AS province_id_53,
  t0.user_id AS user_id_54
FROM
  operateur t0

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.part_etat AS part_etat_39, t0.devise AS devise_40, t0.logo AS logo_41, t0.token AS token_42, t0.domaine AS domaine_43, t0.id_dw AS id_dw_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.deleted_at AS deleted_at_47, t0.categorie_id AS categorie_id_48, t0.forme_juridique_id AS forme_juridique_id_49, t0.ville_id AS ville_id_50, t0.sous_secteur_id AS sous_secteur_id_51, t0.etd_id AS etd_id_52, t0.province_id AS province_id_53, t0.user_id AS user_id_54 FROM operateur t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 23)
5	App\Controller\QuiSommeNousController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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\Operateur\Operateur	The association App\Entity\Operateur\Operateur#commodites refers to the inverse side field App\Entity\Transparence\Commodite#operateurs which does not exist. The association App\Entity\Operateur\Operateur#province refers to the inverse side field App\Entity\Transparence\Province#operateurs which does not exist. The field App\Entity\Operateur\Operateur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Operateur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Categorie	The field App\Entity\Operateur\Categorie#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Categorie#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\FormeJuridique	The field App\Entity\Operateur\FormeJuridique#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\FormeJuridique#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Ville	The association App\Entity\Operateur\Ville#province refers to the inverse side field App\Entity\Transparence\Province#villes which does not exist. The field App\Entity\Operateur\Ville#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\Ville#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\SousSecteur	The field App\Entity\Operateur\SousSecteur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Operateur\SousSecteur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\Etd	The association App\Entity\Autres\Etd#province refers to the inverse side field App\Entity\Transparence\Province#etds which does not exist. The field App\Entity\Autres\Etd#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Autres\Etd#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Province	The field App\Entity\Transparence\Province#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Province#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\User	The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://www.etdkaponda.cd/qui/somme/nous

Configuration Settings

Theme