Symfony Profiler

Query Metrics

47 Database Queries

12 Different statements

34.43 ms Query time

0 Invalid entities

56 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.99 ms
(37.72%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.parent_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.titre AS titre_3,
  t0.slug AS slug_4,
  t0.navbar AS navbar_5,
  t0.ordre AS ordre_6,
  t0.actif AS actif_7,
  t0.home_page AS home_page_8,
  t0.layout AS layout_9,
  t0.content AS content_10,
  t0.date_crea AS date_crea_11,
  t0.date_modif AS date_modif_12,
  t0.user_crea_id AS user_crea_id_13,
  t0.user_modif_id AS user_modif_id_14,
  t0.parent_id AS parent_id_15
FROM
  pages t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.parent_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
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 1417)
9	Twig\Extension\CoreExtension::testEmpty (line 153)
10	__TwigTemplate_e4957d8523c1a20ac96bea9f4f8a3065->doDisplay (line 402)
11	Twig\Template->yield (line 157)
12	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
23	App\Controller\ZFrontController->front_index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

5.84 ms
(16.96%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.titre AS titre_4, t0.description AS description_5, t0.date_upload AS date_upload_6, t0.storage_url AS storage_url_7, t0.flickr AS flickr_8, t0.storage_url_bdef AS storage_url_bdef_9, t0.user_proprio_id AS user_proprio_id_10 FROM album_docs t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.mime_type AS mime_type_3,
  t0.titre AS titre_4,
  t0.description AS description_5,
  t0.date_upload AS date_upload_6,
  t0.storage_url AS storage_url_7,
  t0.flickr AS flickr_8,
  t0.storage_url_bdef AS storage_url_bdef_9,
  t0.user_proprio_id AS user_proprio_id_10
FROM
  album_docs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.mime_type AS mime_type_3, t0.titre AS titre_4, t0.description AS description_5, t0.date_upload AS date_upload_6, t0.storage_url AS storage_url_7, t0.flickr AS flickr_8, t0.storage_url_bdef AS storage_url_bdef_9, t0.user_proprio_id AS user_proprio_id_10 FROM album_docs t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():269} (line 348)
5	Proxies\__CG__\App\Entity\AlbumDocs::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():346}:347} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\AlbumDocs->__get (line 148)
8	App\Entity\AlbumDocs->getStorageUrlBDef (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 86)
10	__TwigTemplate_af572d9ad87585aa6aab108120f9650f->doDisplay (line 402)
11	Twig\Template->yield (line 64)
12	__TwigTemplate_67e0b4040dec4fc0f71d572c49df3ca6->doDisplay (line 402)
13	Twig\Template->yield (line 389)
14	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
15	Twig\Template->yield (line 165)
16	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
17	Twig\Template->yield (line 57)
18	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
27	App\Controller\ZFrontController->front_index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.65 ms
(7.68%)

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.actif AS actif_3, t0.visuel_id AS visuel_id_4 FROM datas_carousel t0 INNER JOIN conf_article_datas_carousel ON t0.id = conf_article_datas_carousel.datas_carousel_id WHERE conf_article_datas_carousel.conf_article_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.actif AS actif_3,
  t0.visuel_id AS visuel_id_4
FROM
  datas_carousel t0
  INNER JOIN conf_article_datas_carousel ON t0.id = conf_article_datas_carousel.datas_carousel_id
WHERE
  conf_article_datas_carousel.conf_article_id = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.actif AS actif_3, t0.visuel_id AS visuel_id_4 FROM datas_carousel t0 INNER JOIN conf_article_datas_carousel ON t0.id = conf_article_datas_carousel.datas_carousel_id WHERE conf_article_datas_carousel.conf_article_id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2717)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
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 1272)
9	Twig\Extension\CoreExtension::length (line 59)
10	__TwigTemplate_67e0b4040dec4fc0f71d572c49df3ca6->doDisplay (line 402)
11	Twig\Template->yield (line 389)
12	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
13	Twig\Template->yield (line 165)
14	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
25	App\Controller\ZFrontController->front_index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

2.63 ms
(7.65%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 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_.titre AS titre_2,
  p0_.slug AS slug_3,
  p0_.navbar AS navbar_4,
  p0_.ordre AS ordre_5,
  p0_.actif AS actif_6,
  p0_.home_page AS home_page_7,
  p0_.layout AS layout_8,
  p0_.content AS content_9,
  p0_.date_crea AS date_crea_10,
  p0_.date_modif AS date_modif_11,
  p0_.user_crea_id AS user_crea_id_12,
  p0_.user_modif_id AS user_modif_id_13,
  p0_.parent_id AS parent_id_14
FROM
  pages p0_
WHERE
  p0_.actif = 1
  AND p0_.home_page = 1

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 52)
7	App\Repository\PagesRepository->findHomePage (line 2707)
8	App\Controller\ZFrontController->front_index (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)

2.34 ms
(6.79%)

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.position_diapo_id AS position_diapo_id_3, t0.colonne_id AS colonne_id_4 FROM conf_article t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.article_id AS article_id_2,
  t0.position_diapo_id AS position_diapo_id_3,
  t0.colonne_id AS colonne_id_4
FROM
  conf_article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.position_diapo_id AS position_diapo_id_3, t0.colonne_id AS colonne_id_4 FROM conf_article t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 521)
7	App\Controller\ConfController->recupCases (line 2950)
8	App\Controller\ZFrontController->front_index (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)

1.65 ms
(4.79%)

SELECT c0_.id AS id_0, c0_.nom_template AS nom_template_1, c0_.ordre AS ordre_2, c0_.id_conf AS id_conf_3, c0_.actif AS actif_4, c0_.page_id AS page_id_5, c0_.contenu_id AS contenu_id_6 FROM cases_pages c0_ WHERE c0_.page_id = ? AND c0_.actif = 1 ORDER BY c0_.ordre ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom_template AS nom_template_1,
  c0_.ordre AS ordre_2,
  c0_.id_conf AS id_conf_3,
  c0_.actif AS actif_4,
  c0_.page_id AS page_id_5,
  c0_.contenu_id AS contenu_id_6
FROM
  cases_pages c0_
WHERE
  c0_.page_id = ?
  AND c0_.actif = 1
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.nom_template AS nom_template_1, c0_.ordre AS ordre_2, c0_.id_conf AS id_conf_3, c0_.actif AS actif_4, c0_.page_id AS page_id_5, c0_.contenu_id AS contenu_id_6 FROM cases_pages c0_ WHERE c0_.page_id = 10 AND c0_.actif = 1 ORDER BY c0_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 41)
7	App\Repository\CasesPagesRepository->findCaseActifByOrdre (line 2938)
8	App\Controller\ZFrontController->front_index (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)

1.61 ms
(4.69%)

SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_quill t0 WHERE t0.id = ?

Parameters:

[
  106
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2
FROM
  data_quill t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_quill t0 WHERE t0.id = 106;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():269} (line 348)
5	Proxies\__CG__\App\Entity\DataQuill::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():346}:347} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\DataQuill->__get (line 27)
8	App\Entity\DataQuill->getContenu (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 85)
10	__TwigTemplate_67e0b4040dec4fc0f71d572c49df3ca6->doDisplay (line 402)
11	Twig\Template->yield (line 389)
12	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
13	Twig\Template->yield (line 165)
14	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
25	App\Controller\ZFrontController->front_index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.47 ms
(4.26%)

SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_boolean t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2
FROM
  data_boolean t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_boolean t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():269} (line 348)
5	Proxies\__CG__\App\Entity\DataBoolean::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():346}:347} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\DataBoolean->__get (line 26)
8	App\Entity\DataBoolean->isContenu (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_67e0b4040dec4fc0f71d572c49df3ca6->doDisplay (line 402)
11	Twig\Template->yield (line 389)
12	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
13	Twig\Template->yield (line 165)
14	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
25	App\Controller\ZFrontController->front_index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.34 ms
(3.89%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.url AS url_4, t0.js AS js_5, t0.css AS css_6, t0.actif AS actif_7 FROM contenu t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contenu AS contenu_3,
  t0.url AS url_4,
  t0.js AS js_5,
  t0.css AS css_6,
  t0.actif AS actif_7
FROM
  contenu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.url AS url_4, t0.js AS js_5, t0.css AS css_6, t0.actif AS actif_7 FROM contenu t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():269} (line 348)
5	Proxies\__CG__\App\Entity\Contenu::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():346}:347} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Contenu->__get (line 66)
8	App\Entity\Contenu->getUrl (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 389)
10	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
11	Twig\Template->yield (line 165)
12	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2977)
23	App\Controller\ZFrontController->front_index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.78 ms
(2.27%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.home_page = 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_.titre AS titre_2,
  p0_.slug AS slug_3,
  p0_.navbar AS navbar_4,
  p0_.ordre AS ordre_5,
  p0_.actif AS actif_6,
  p0_.home_page AS home_page_7,
  p0_.layout AS layout_8,
  p0_.content AS content_9,
  p0_.date_crea AS date_crea_10,
  p0_.date_modif AS date_modif_11,
  p0_.user_crea_id AS user_crea_id_12,
  p0_.user_modif_id AS user_modif_id_13,
  p0_.parent_id AS parent_id_14
FROM
  pages p0_
WHERE
  p0_.home_page = 1

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.home_page = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 61)
7	App\Repository\PagesRepository->findAllHomePage (line 2710)
8	App\Controller\ZFrontController->front_index (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.58 ms
(1.70%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = ?

Parameters:

[
  "/creneaux/running-loisir-du-dimanche"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.titre AS titre_2,
  p0_.slug AS slug_3,
  p0_.navbar AS navbar_4,
  p0_.ordre AS ordre_5,
  p0_.actif AS actif_6,
  p0_.home_page AS home_page_7,
  p0_.layout AS layout_8,
  p0_.content AS content_9,
  p0_.date_crea AS date_crea_10,
  p0_.date_modif AS date_modif_11,
  p0_.user_crea_id AS user_crea_id_12,
  p0_.user_modif_id AS user_modif_id_13,
  p0_.parent_id AS parent_id_14
FROM
  pages p0_
WHERE
  p0_.actif = 1
  AND p0_.slug = ?

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = '/creneaux/running-loisir-du-dimanche';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 73)
7	App\Repository\PagesRepository->findPagesByUrlActive (line 2919)
8	App\Controller\ZFrontController->front_index (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.55 ms
(1.61%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.titre AS titre_3,
  t0.slug AS slug_4,
  t0.navbar AS navbar_5,
  t0.ordre AS ordre_6,
  t0.actif AS actif_7,
  t0.home_page AS home_page_8,
  t0.layout AS layout_9,
  t0.content AS content_10,
  t0.date_crea AS date_crea_11,
  t0.date_modif AS date_modif_12,
  t0.user_crea_id AS user_crea_id_13,
  t0.user_modif_id AS user_modif_id_14,
  t0.parent_id AS parent_id_15
FROM
  pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():269} (line 348)
5	Proxies\__CG__\App\Entity\Pages::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():346}:347} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Pages->__get (line 229)
8	App\Entity\Pages->getParent (line 2973)
9	App\Controller\ZFrontController->front_index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\Pages	29
App\Entity\DatasCarousel	10
App\Entity\AlbumDocs	10
App\Entity\DataQuill	2
App\Entity\SecurUser	1
App\Entity\CasesPages	1
App\Entity\Contenu	1
App\Entity\ConfArticle	1
App\Entity\DataBoolean	1

Entities Mapping

Class	Mapping errors
App\Entity\Pages	No errors.
App\Entity\SecurUser	No errors.
App\Entity\CasesPages	No errors.
App\Entity\Contenu	No errors.
App\Entity\ConfArticle	No errors.
App\Entity\DataQuill	No errors.
App\Entity\DataBoolean	No errors.
App\Entity\DatasCarousel	No errors.
App\Entity\AlbumDocs	No errors.

Symfony Profiler

GET https://asfivillejuif.com/creneaux/running-loisir-du-dimanche

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping