Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.29 ms Query time

8 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.81 ms
(62.47%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.budget AS budget_2, p0_.localisation AS localisation_3, p0_.stade AS stade_4, p0_.annotation AS annotation_5, p0_.date_debut AS date_debut_6, p0_.date_fin AS date_fin_7, p0_.executant AS executant_8, p0_.reference_passation_marche AS reference_passation_marche_9, p0_.evaluation AS evaluation_10, p0_.satisfaction AS satisfaction_11, p0_.id_dw AS id_dw_12, p0_.is_publish AS is_publish_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.deleted_at AS deleted_at_16, p0_.dot_id AS dot_id_17, p0_.nature_id AS nature_id_18, p0_.user_id AS user_id_19 FROM projet_dot p0_ WHERE p0_.is_publish = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.budget AS budget_2,
  p0_.localisation AS localisation_3,
  p0_.stade AS stade_4,
  p0_.annotation AS annotation_5,
  p0_.date_debut AS date_debut_6,
  p0_.date_fin AS date_fin_7,
  p0_.executant AS executant_8,
  p0_.reference_passation_marche AS reference_passation_marche_9,
  p0_.evaluation AS evaluation_10,
  p0_.satisfaction AS satisfaction_11,
  p0_.id_dw AS id_dw_12,
  p0_.is_publish AS is_publish_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.deleted_at AS deleted_at_16,
  p0_.dot_id AS dot_id_17,
  p0_.nature_id AS nature_id_18,
  p0_.user_id AS user_id_19
FROM
  projet_dot p0_
WHERE
  p0_.is_publish = 1

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.budget AS budget_2, p0_.localisation AS localisation_3, p0_.stade AS stade_4, p0_.annotation AS annotation_5, p0_.date_debut AS date_debut_6, p0_.date_fin AS date_fin_7, p0_.executant AS executant_8, p0_.reference_passation_marche AS reference_passation_marche_9, p0_.evaluation AS evaluation_10, p0_.satisfaction AS satisfaction_11, p0_.id_dw AS id_dw_12, p0_.is_publish AS is_publish_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.deleted_at AS deleted_at_16, p0_.dot_id AS dot_id_17, p0_.nature_id AS nature_id_18, p0_.user_id AS user_id_19 FROM projet_dot p0_ WHERE p0_.is_publish = 1;

#	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 29)
7	App\Repository\Operateur\ProjetDotRepository->getProjet (line 35)
8	App\Controller\Operateur\ProjetDotController->index (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)

0.48 ms
(37.53%)

SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.nom AS nom_14, t0.date_creation AS date_creation_15, t0.id_dw AS id_dw_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.operateur_id AS operateur_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM dot t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.membre_communaute_local1 AS membre_communaute_local1_2,
  t0.membre_communaute_local2 AS membre_communaute_local2_3,
  t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4,
  t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5,
  t0.membre_operateur1 AS membre_operateur1_6,
  t0.membre_operateur2 AS membre_operateur2_7,
  t0.membre_autorite1 AS membre_autorite1_8,
  t0.membre_autorite2 AS membre_autorite2_9,
  t0.membre_fonds_national1 AS membre_fonds_national1_10,
  t0.membre_fonds_national2 AS membre_fonds_national2_11,
  t0.membre_direction1 AS membre_direction1_12,
  t0.membre_direction2 AS membre_direction2_13,
  t0.nom AS nom_14,
  t0.date_creation AS date_creation_15,
  t0.id_dw AS id_dw_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.operateur_id AS operateur_id_20,
  t0.arrete_id AS arrete_id_21,
  t0.user_id AS user_id_22
FROM
  dot t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.nom AS nom_14, t0.date_creation AS date_creation_15, t0.id_dw AS id_dw_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.operateur_id AS operateur_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM dot t0 WHERE t0.id = 1;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Operateur\Dot::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Operateur\Dot->__get (line 316)
8	App\Entity\Operateur\Dot->getNom (line 1635)
9	twig_get_attribute (line 204)
10	__TwigTemplate_a0a8f5d9b66adfd12640a8ba543709e3->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 50)
18	__TwigTemplate_a0a8f5d9b66adfd12640a8ba543709e3->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
27	App\Controller\Operateur\ProjetDotController->index (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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\ProjetDot	The association App\Entity\Operateur\ProjetDot#nature refers to the inverse side field App\Entity\Obligation\NatureProjet#projetDots which does not exist. The field App\Entity\Operateur\ProjetDot#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\ProjetDot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Dot	The field App\Entity\Operateur\Dot#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\Dot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Obligation\NatureProjet	The field App\Entity\Obligation\NatureProjet#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\NatureProjet#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\Operateur\Image	The field App\Entity\Operateur\Image#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\Image#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
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\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\Operateur\ComitePilotageDot	The field App\Entity\Operateur\ComitePilotageDot#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\ComitePilotageDot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://www.dot.cd/operateur/projet/dot/4

Configuration Settings

Theme