Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.79 ms Query time

32 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.79 ms
(100.00%)

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royalties AS royalties_21, t0.reserves AS reserves_22, t0.ressources AS ressources_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.actionnariats_locaux_id AS actionnariats_locaux_id_30, t0.user_id AS user_id_31 FROM contrat_principal t0 WHERE t0.id = ?

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom AS nom_3,
  t0.langue AS langue_4,
  t0.date_signature AS date_signature_5,
  t0.url_source AS url_source_6,
  t0.mode_divulgation AS mode_divulgation_7,
  t0.mode_text_divulgation AS mode_text_divulgation_8,
  t0.date_recuperation AS date_recuperation_9,
  t0.categorie AS categorie_10,
  t0.note AS note_11,
  t0.identifiant AS identifiant_12,
  t0.page_manquent AS page_manquent_13,
  t0.annexe_manquent AS annexe_manquent_14,
  t0.statut AS statut_15,
  t0.part_etat AS part_etat_16,
  t0.dure AS dure_17,
  t0.annee_signature AS annee_signature_18,
  t0.pas_de_porte AS pas_de_porte_19,
  t0.loyer_annuel AS loyer_annuel_20,
  t0.royalties AS royalties_21,
  t0.reserves AS reserves_22,
  t0.ressources AS ressources_23,
  t0.id_dw AS id_dw_24,
  t0.is_publish AS is_publish_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.deleted_at AS deleted_at_28,
  t0.type_document_id AS type_document_id_29,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_30,
  t0.user_id AS user_id_31
FROM
  contrat_principal t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royalties AS royalties_21, t0.reserves AS reserves_22, t0.ressources AS ressources_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.actionnariats_locaux_id AS actionnariats_locaux_id_30, t0.user_id AS user_id_31 FROM contrat_principal t0 WHERE t0.id = '5';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Transparence\ContratPrincipal	The field App\Entity\Transparence\ContratPrincipal#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\ContratPrincipal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\TypeDocument	The field App\Entity\Transparence\TypeDocument#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\TypeDocument#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\ActionnariatLocal	The field App\Entity\Actionnariat\ActionnariatLocal#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\Actionnariat\ActionnariatLocal#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.
App\Entity\Transparence\Pays	The field App\Entity\Transparence\Pays#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\Pays#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratRelatif	The field App\Entity\Transparence\ContratRelatif#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\ContratRelatif#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Projet	The field App\Entity\Activite\Projet#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\Activite\Projet#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\TitreMinier	The association App\Entity\Activite\TitreMinier#arrete refers to the inverse side field App\Entity\Transparence\Arrete#titreMiniers which does not exist. The field App\Entity\Activite\TitreMinier#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\Activite\TitreMinier#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\TypeContrat	The field App\Entity\Transparence\TypeContrat#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\TypeContrat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Commodite	The field App\Entity\Transparence\Commodite#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\Commodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\EntiteGouvernementale	The field App\Entity\Transparence\EntiteGouvernementale#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\EntiteGouvernementale#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\PartContrat	The field App\Entity\Transparence\PartContrat#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\PartContrat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\Actionnaire	The field App\Entity\Actionnariat\Actionnaire#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\Actionnariat\Actionnaire#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\Investisseur	The field App\Entity\Actionnariat\Investisseur#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\Actionnariat\Investisseur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\Production	The field App\Entity\Production\Production#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\Production\Production#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Reserve	The field App\Entity\Activite\Reserve#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\Activite\Reserve#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Ressource	The field App\Entity\Activite\Ressource#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\Activite\Ressource#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\Usine	The field App\Entity\Production\Usine#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\Production\Usine#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\Investissement	The field App\Entity\Actionnariat\Investissement#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\Actionnariat\Investissement#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\Gisement	The field App\Entity\Autres\Gisement#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\Gisement#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Obligation\SureteFinanciere	The field App\Entity\Obligation\SureteFinanciere#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\Obligation\SureteFinanciere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Impact\Environemental	The field App\Entity\Impact\Environemental#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\Impact\Environemental#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\Amodiation	The association App\Entity\Autres\Amodiation#arrete refers to the inverse side field App\Entity\Transparence\Arrete#amodiations which does not exist. The field App\Entity\Autres\Amodiation#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\Amodiation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Transformation	The field App\Entity\Activite\Transformation#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\Activite\Transformation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Cession	The association App\Entity\Activite\Cession#arrete refers to the inverse side field App\Entity\Transparence\Arrete#cessions which does not exist. The field App\Entity\Activite\Cession#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\Activite\Cession#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Transfert	The field App\Entity\Activite\Transfert#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\Activite\Transfert#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Option	The association App\Entity\Activite\Option#arrete refers to the inverse side field App\Entity\Transparence\Arrete#options which does not exist. The field App\Entity\Activite\Option#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\Activite\Option#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\Transparence\Arrete	The field App\Entity\Transparence\Arrete#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\Arrete#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\Exportation	The field 'App\Entity\Production\Exportation#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Production\Exportation#pays refers to the inverse side field App\Entity\Transparence\Pays#exportations which does not exist. The field App\Entity\Production\Exportation#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\Production\Exportation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Production\VenteLocal	The field 'App\Entity\Production\VenteLocal#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Production\VenteLocal#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\Production\VenteLocal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\TeneurCommodite	The field App\Entity\Autres\TeneurCommodite#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\TeneurCommodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://www.sodimico.cd/transparence/contrat/principalshow/5/tc/contrat

Configuration Settings

Theme