Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.81 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.34 ms
(41.41%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.mot_cle AS mot_cle_4, t0.mot_cle_en AS mot_cle_en_5, t0.reference AS reference_6, t0.image1 AS image1_7, t0.image2 AS image2_8, t0.legende AS legende_9, t0.legende_en AS legende_en_10, t0.created_at AS created_at_11, t0.contenu AS contenu_12, t0.contenu_en AS contenu_en_13, t0.ala_une AS ala_une_14, t0.redacteur_id AS redacteur_id_15, t0.sous_thematique_id AS sous_thematique_id_16 FROM actualite t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.titre_en AS titre_en_3,
  t0.mot_cle AS mot_cle_4,
  t0.mot_cle_en AS mot_cle_en_5,
  t0.reference AS reference_6,
  t0.image1 AS image1_7,
  t0.image2 AS image2_8,
  t0.legende AS legende_9,
  t0.legende_en AS legende_en_10,
  t0.created_at AS created_at_11,
  t0.contenu AS contenu_12,
  t0.contenu_en AS contenu_en_13,
  t0.ala_une AS ala_une_14,
  t0.redacteur_id AS redacteur_id_15,
  t0.sous_thematique_id AS sous_thematique_id_16
FROM
  actualite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_en AS titre_en_3, t0.mot_cle AS mot_cle_4, t0.mot_cle_en AS mot_cle_en_5, t0.reference AS reference_6, t0.image1 AS image1_7, t0.image2 AS image2_8, t0.legende AS legende_9, t0.legende_en AS legende_en_10, t0.created_at AS created_at_11, t0.contenu AS contenu_12, t0.contenu_en AS contenu_en_13, t0.ala_une AS ala_une_14, t0.redacteur_id AS redacteur_id_15, t0.sous_thematique_id AS sous_thematique_id_16 FROM actualite t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\AccueilController->detailsActualite (line 56)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.27 ms
(32.80%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.thematique_id AS thematique_id_4
FROM
  sous_thematique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.thematique_id AS thematique_id_4 FROM sous_thematique t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\SousThematique::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\SousThematique->__get (line 153)
7	App\Entity\SousThematique->getLibelle (line 52)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_5dbe62de99638852ed69cecb5d828617::block_body (line 111)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2218bf7b4776a892baf76bc44b9f7bf1->doDisplay (line 291)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5dbe62de99638852ed69cecb5d828617->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\AccueilController->detailsActualite (line 62)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.21 ms
(25.80%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_utilisateur AS nom_utilisateur_5, t0.type AS type_6, t0.etat AS etat_7, t0.created_at AS created_at_8 FROM utilisateur t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom_utilisateur AS nom_utilisateur_5,
  t0.type AS type_6,
  t0.etat AS etat_7,
  t0.created_at AS created_at_8
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_utilisateur AS nom_utilisateur_5, t0.type AS type_6, t0.etat AS etat_7, t0.created_at AS created_at_8 FROM utilisateur t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Utilisateur::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Utilisateur->__get (line 153)
7	App\Entity\Utilisateur->getNomUtilisateur (line 150)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_5dbe62de99638852ed69cecb5d828617::block_body (line 134)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2218bf7b4776a892baf76bc44b9f7bf1->doDisplay (line 291)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5dbe62de99638852ed69cecb5d828617->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\AccueilController->detailsActualite (line 62)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Actualite	1
App\Entity\Utilisateur	1
App\Entity\SousThematique	1
App\Entity\Thematique	1

Entities Mapping

Class	Mapping errors
App\Entity\Actualite	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\SousThematique	No errors.
App\Entity\Thematique	No errors.

Symfony Profiler

GET https://www.yusiip.cm/actualite/details/7

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping