Symfony Profiler

Query Metrics

11 Database Queries

6 Different statements

1.81 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.77 ms
(42.43%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.detach AS detach_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.parent_id AS parent_id_6 FROM blog_categorie t0 WHERE t0.parent_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.detach AS detach_3,
  t0.ordre AS ordre_4,
  t0.actif AS actif_5,
  t0.parent_id AS parent_id_6
FROM
  blog_categorie t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.detach AS detach_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.parent_id AS parent_id_6 FROM blog_categorie t0 WHERE t0.parent_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1274)
9	Twig\Extension\CoreExtension::testEmpty (line 74)
10	__TwigTemplate_a7b3b817cccba74c8ded0d8180088073->doDisplay (line 360)
11	Twig\Template->yield (line 97)
12	__TwigTemplate_d31b5c3a566a56b8c6953c9cce75cf4b->block_body (line 430)
13	Twig\Template->yieldBlock (line 261)
14	__TwigTemplate_5a2574ec5dd5c0a479dee701a56a6726->doDisplay (line 360)
15	Twig\Template->yield (line 50)
16	__TwigTemplate_d31b5c3a566a56b8c6953c9cce75cf4b->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 307)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 318)
24	App\Controller\ZZFrontController->blog_cookies (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.38 ms
(21.10%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.eternel AS eternel_3, t4.id AS id_5, t4.png32 AS png32_6, t4.png16 AS png16_7, t4.ico AS ico_8, t4.png180 AS png180_9, t4.theme_color AS theme_color_10, t4.png192 AS png192_11, t4.png512 AS png512_12, t4.svg_icon AS svg_icon_13, t4.svg_color AS svg_color_14, t4.tile_color AS tile_color_15, t4.png70 AS png70_16, t4.png150 AS png150_17, t4.png310 AS png310_18, t4.png310w150 AS png310w150_19, t4.background_color AS background_color_20, t4.head_id AS head_id_21, t0.css_id AS css_id_22 FROM systeme_head t0 LEFT JOIN systeme_favicon t4 ON t4.head_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.eternel AS eternel_3,
  t4.id AS id_5,
  t4.png32 AS png32_6,
  t4.png16 AS png16_7,
  t4.ico AS ico_8,
  t4.png180 AS png180_9,
  t4.theme_color AS theme_color_10,
  t4.png192 AS png192_11,
  t4.png512 AS png512_12,
  t4.svg_icon AS svg_icon_13,
  t4.svg_color AS svg_color_14,
  t4.tile_color AS tile_color_15,
  t4.png70 AS png70_16,
  t4.png150 AS png150_17,
  t4.png310 AS png310_18,
  t4.png310w150 AS png310w150_19,
  t4.background_color AS background_color_20,
  t4.head_id AS head_id_21,
  t0.css_id AS css_id_22
FROM
  systeme_head t0
  LEFT JOIN systeme_favicon t4 ON t4.head_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.eternel AS eternel_3, t4.id AS id_5, t4.png32 AS png32_6, t4.png16 AS png16_7, t4.ico AS ico_8, t4.png180 AS png180_9, t4.theme_color AS theme_color_10, t4.png192 AS png192_11, t4.png512 AS png512_12, t4.svg_icon AS svg_icon_13, t4.svg_color AS svg_color_14, t4.tile_color AS tile_color_15, t4.png70 AS png70_16, t4.png150 AS png150_17, t4.png310 AS png310_18, t4.png310w150 AS png310w150_19, t4.background_color AS background_color_20, t4.head_id AS head_id_21, t0.css_id AS css_id_22 FROM systeme_head t0 LEFT JOIN systeme_favicon t4 ON t4.head_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 310)
7	App\Controller\ZZFrontController->blog_cookies (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.18 ms
(9.80%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.sous_titre AS sous_titre_3,
  t0.logo AS logo_4
FROM
  blog_header t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 312)
7	App\Controller\ZZFrontController->blog_cookies (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.17 ms
(9.59%)

SELECT b0_.id AS id_0, b0_.nom AS nom_1, b0_.detach AS detach_2, b0_.ordre AS ordre_3, b0_.actif AS actif_4, b0_.parent_id AS parent_id_5 FROM blog_categorie b0_ WHERE b0_.parent_id IS NULL ORDER BY b0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.nom AS nom_1,
  b0_.detach AS detach_2,
  b0_.ordre AS ordre_3,
  b0_.actif AS actif_4,
  b0_.parent_id AS parent_id_5
FROM
  blog_categorie b0_
WHERE
  b0_.parent_id IS NULL
ORDER BY
  b0_.ordre ASC

SELECT b0_.id AS id_0, b0_.nom AS nom_1, b0_.detach AS detach_2, b0_.ordre AS ordre_3, b0_.actif AS actif_4, b0_.parent_id AS parent_id_5 FROM blog_categorie b0_ WHERE b0_.parent_id IS NULL ORDER BY b0_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 48)
7	App\Repository\BlogCategorieRepository->findAllRacine (line 314)
8	App\Controller\ZZFrontController->blog_cookies (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.17 ms
(9.59%)

SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = ? ORDER BY b0_.ordre ASC, b1_.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.titre AS titre_1,
  b0_.image AS image_2,
  b0_.texte AS texte_3,
  b0_.ordre AS ordre_4,
  b0_.actif AS actif_5,
  b0_.parent_id AS parent_id_6
FROM
  blog_rubrique b0_
  LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id
WHERE
  b0_.parent_id IS NULL
  AND b0_.actif = ?
ORDER BY
  b0_.ordre ASC,
  b1_.ordre ASC

SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = 1 ORDER BY b0_.ordre ASC, b1_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 58)
7	App\Repository\BlogRubriqueRepository->findNiv0Actif (line 316)
8	App\Controller\ZZFrontController->blog_cookies (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.14 ms
(7.49%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.head_id AS head_id_4 FROM systeme_css t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.head_id AS head_id_4
FROM
  systeme_css t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.head_id AS head_id_4 FROM systeme_css t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 59)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
6	Proxies\__CG__\App\Entity\SystemeCss->__get (line 58)
7	App\Entity\SystemeCss->getCode (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 244)
9	__TwigTemplate_5a2574ec5dd5c0a479dee701a56a6726->doDisplay (line 360)
10	Twig\Template->yield (line 50)
11	__TwigTemplate_d31b5c3a566a56b8c6953c9cce75cf4b->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 307)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 318)
19	App\Controller\ZZFrontController->blog_cookies (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\SystemeHead	No errors.
App\Entity\SystemeFavicon	No errors.
App\Entity\SystemeCss	No errors.
App\Entity\BlogHeader	No errors.
App\Entity\BlogCategorie	No errors.
App\Entity\BlogArticle	No errors.
App\Entity\BlogRubrique	No errors.
App\Entity\BlogPublication	The association App\Entity\BlogPublication#auteur refers to the inverse side field App\Entity\SecurUser#publications which does not exist.

Symfony Profiler

GET https://enmarge.ovh/cookies

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping