Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.18 ms Query time

12 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.68 ms
(57.41%)

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)

0.50 ms
(42.59%)

SELECT c0_.id AS id_0, c0_.fichier AS fichier_1, c0_.nom AS nom_2, c0_.langue AS langue_3, c0_.date_signature AS date_signature_4, c0_.url_source AS url_source_5, c0_.mode_divulgation AS mode_divulgation_6, c0_.mode_text_divulgation AS mode_text_divulgation_7, c0_.date_recuperation AS date_recuperation_8, c0_.categorie AS categorie_9, c0_.note AS note_10, c0_.identifiant AS identifiant_11, c0_.page_manquent AS page_manquent_12, c0_.annexe_manquent AS annexe_manquent_13, c0_.statut AS statut_14, c0_.part_etat AS part_etat_15, c0_.dure AS dure_16, c0_.annee_signature AS annee_signature_17, c0_.pas_de_porte AS pas_de_porte_18, c0_.loyer_annuel AS loyer_annuel_19, c0_.royaltie AS royaltie_20, c0_.ressources AS ressources_21, c0_.reserves AS reserves_22, c0_.id_dw AS id_dw_23, c0_.is_publish AS is_publish_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.deleted_at AS deleted_at_27, c0_.type_document_id AS type_document_id_28, c0_.contrat_principal_id AS contrat_principal_id_29, c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30, c0_.user_id AS user_id_31 FROM contrat_relatif c0_ WHERE c0_.contrat_principal_id = ? ORDER BY c0_.id ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.fichier AS fichier_1,
  c0_.nom AS nom_2,
  c0_.langue AS langue_3,
  c0_.date_signature AS date_signature_4,
  c0_.url_source AS url_source_5,
  c0_.mode_divulgation AS mode_divulgation_6,
  c0_.mode_text_divulgation AS mode_text_divulgation_7,
  c0_.date_recuperation AS date_recuperation_8,
  c0_.categorie AS categorie_9,
  c0_.note AS note_10,
  c0_.identifiant AS identifiant_11,
  c0_.page_manquent AS page_manquent_12,
  c0_.annexe_manquent AS annexe_manquent_13,
  c0_.statut AS statut_14,
  c0_.part_etat AS part_etat_15,
  c0_.dure AS dure_16,
  c0_.annee_signature AS annee_signature_17,
  c0_.pas_de_porte AS pas_de_porte_18,
  c0_.loyer_annuel AS loyer_annuel_19,
  c0_.royaltie AS royaltie_20,
  c0_.ressources AS ressources_21,
  c0_.reserves AS reserves_22,
  c0_.id_dw AS id_dw_23,
  c0_.is_publish AS is_publish_24,
  c0_.created_at AS created_at_25,
  c0_.updated_at AS updated_at_26,
  c0_.deleted_at AS deleted_at_27,
  c0_.type_document_id AS type_document_id_28,
  c0_.contrat_principal_id AS contrat_principal_id_29,
  c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30,
  c0_.user_id AS user_id_31
FROM
  contrat_relatif c0_
WHERE
  c0_.contrat_principal_id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.fichier AS fichier_1, c0_.nom AS nom_2, c0_.langue AS langue_3, c0_.date_signature AS date_signature_4, c0_.url_source AS url_source_5, c0_.mode_divulgation AS mode_divulgation_6, c0_.mode_text_divulgation AS mode_text_divulgation_7, c0_.date_recuperation AS date_recuperation_8, c0_.categorie AS categorie_9, c0_.note AS note_10, c0_.identifiant AS identifiant_11, c0_.page_manquent AS page_manquent_12, c0_.annexe_manquent AS annexe_manquent_13, c0_.statut AS statut_14, c0_.part_etat AS part_etat_15, c0_.dure AS dure_16, c0_.annee_signature AS annee_signature_17, c0_.pas_de_porte AS pas_de_porte_18, c0_.loyer_annuel AS loyer_annuel_19, c0_.royaltie AS royaltie_20, c0_.ressources AS ressources_21, c0_.reserves AS reserves_22, c0_.id_dw AS id_dw_23, c0_.is_publish AS is_publish_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.deleted_at AS deleted_at_27, c0_.type_document_id AS type_document_id_28, c0_.contrat_principal_id AS contrat_principal_id_29, c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30, c0_.user_id AS user_id_31 FROM contrat_relatif c0_ WHERE c0_.contrat_principal_id = 5 ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Repository\Transparence\ContratRelatifRepository->getDocumentByContrat (line 102)
8	App\Controller\Transparence\ContratPrincipalController->contratRelatif (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Symfony Profiler

GET https://sokimo.ht2techinfo.cd/transparence/contrat/principal/contrat/relatif/5?sp=sp

Configuration Settings

Theme