Symfony Profiler

Query Metrics

80 Database Queries

12 Different statements

26.62 ms Query time

0 Invalid entities

96 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.97 ms
(29.93%)

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)

6.15 ms
(23.10%)

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

Parameters:

[
  114
]

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 = 114;

#	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 77)
10	__TwigTemplate_a358901eb7d2f3145677630a34166f6d->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)

3.00 ms
(11.26%)

SELECT t0.id AS id_1, t0.jour_semaine AS jour_semaine_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.canceled_dates AS canceled_dates_7, t0.ordre AS ordre_8, t0.creneau_id AS creneau_id_9 FROM creneau_event t0 WHERE t0.creneau_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.jour_semaine AS jour_semaine_2,
  t0.start_time AS start_time_3,
  t0.duration AS duration_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.canceled_dates AS canceled_dates_7,
  t0.ordre AS ordre_8,
  t0.creneau_id AS creneau_id_9
FROM
  creneau_event t0
WHERE
  t0.creneau_id = ?

SELECT t0.id AS id_1, t0.jour_semaine AS jour_semaine_2, t0.start_time AS start_time_3, t0.duration AS duration_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.canceled_dates AS canceled_dates_7, t0.ordre AS ordre_8, t0.creneau_id AS creneau_id_9 FROM creneau_event t0 WHERE t0.creneau_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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 154)
8	__TwigTemplate_a358901eb7d2f3145677630a34166f6d->doDisplay (line 402)
9	Twig\Template->yield (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)

2.91 ms
(10.92%)

SELECT t0.id AS id_1, t0.url_original AS url_original_2, t0.url AS url_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM data_image t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url_original AS url_original_2,
  t0.url AS url_3,
  t0.legende AS legende_4,
  t0.ordre AS ordre_5
FROM
  data_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url_original AS url_original_2, t0.url AS url_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM data_image t0 WHERE t0.id = 2;

#	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\DataImage::{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\DataImage->__get (line 51)
8	App\Entity\DataImage->getUrl (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 113)
10	__TwigTemplate_a358901eb7d2f3145677630a34166f6d->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.79 ms
(10.47%)

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

Parameters:

[
  75
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_varchar t0 WHERE t0.id = 75;

#	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\DataVarchar::{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\DataVarchar->__get (line 29)
8	App\Entity\DataVarchar->getContenu (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 59)
10	__TwigTemplate_a358901eb7d2f3145677630a34166f6d->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)

0.92 ms
(3.47%)

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)

0.81 ms
(3.04%)

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.titre_id AS titre_id_3, t0.texte_id AS texte_id_4 FROM conf_sommaire t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ref AS ref_2,
  t0.titre_id AS titre_id_3,
  t0.texte_id AS texte_id_4
FROM
  conf_sommaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.titre_id AS titre_id_3, t0.texte_id AS texte_id_4 FROM conf_sommaire t0 WHERE t0.id = 4;

#	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 483)
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)

0.46 ms
(1.73%)

SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.actif AS actif_2, c0_.lien AS lien_3, c0_.date_crea AS date_crea_4, c0_.date_modif AS date_modif_5, c0_.titre_id AS titre_id_6, c0_.texte_id AS texte_id_7, c0_.visuel_id AS visuel_id_8, c0_.texte2_id AS texte2_id_9 FROM creneaux c0_ WHERE c0_.actif = 1 ORDER BY c0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.ordre AS ordre_1,
  c0_.actif AS actif_2,
  c0_.lien AS lien_3,
  c0_.date_crea AS date_crea_4,
  c0_.date_modif AS date_modif_5,
  c0_.titre_id AS titre_id_6,
  c0_.texte_id AS texte_id_7,
  c0_.visuel_id AS visuel_id_8,
  c0_.texte2_id AS texte2_id_9
FROM
  creneaux c0_
WHERE
  c0_.actif = 1
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.actif AS actif_2, c0_.lien AS lien_3, c0_.date_crea AS date_crea_4, c0_.date_modif AS date_modif_5, c0_.titre_id AS titre_id_6, c0_.texte_id AS texte_id_7, c0_.visuel_id AS visuel_id_8, c0_.texte2_id AS texte2_id_9 FROM creneaux c0_ WHERE 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 50)
7	App\Repository\CreneauxRepository->findAllActifByOrdre (line 489)
8	App\Controller\ConfController->recupCases (line 2950)
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)

0.43 ms
(1.63%)

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.42 ms
(1.58%)

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:

[
  5
]

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 = 5 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)

0.41 ms
(1.53%)

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"
]

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';

#	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.35 ms
(1.33%)

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:

[
  13
]

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 = 13;

#	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)

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\DataQuill	19
App\Entity\CreneauEvent	16
App\Entity\DataVarchar	10
App\Entity\Creneaux	9
App\Entity\DataImage	9
App\Entity\SecurUser	1
App\Entity\CasesPages	1
App\Entity\Contenu	1
App\Entity\ConfSommaire	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\ConfSommaire	No errors.
App\Entity\DataVarchar	No errors.
App\Entity\DataQuill	No errors.
App\Entity\Creneaux	No errors.
App\Entity\DataImage	No errors.
App\Entity\CreneauEvent	No errors.

Symfony Profiler

GET https://www.asfivillejuif.com/creneaux

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping