Symfony Profiler

Query Metrics

43 Database Queries

10 Different statements

17.22 ms Query time

0 Invalid entities

94 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.26 ms
(47.97%)

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

3.60 ms
(20.92%)

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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 267)
9	__TwigTemplate_e339607aceabad73cdbdd80f45ae55d3->doDisplay (line 402)
10	Twig\Template->yield (line 389)
11	__TwigTemplate_908b08ccb02f7203c61208973504076d->doDisplay (line 402)
12	Twig\Template->yield (line 165)
13	__TwigTemplate_87038fd2e9da20ea0504b37c07a71fcc->doDisplay (line 402)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_ec280ffe05487afd661f180a5f651cee->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 2782)
24	App\Controller\ZFrontController->front_index (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)

1.12 ms
(6.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.96 ms
(5.60%)

SELECT a0_.id AS id_0, a0_.date_crea AS date_crea_1, a0_.date_modif AS date_modif_2, a0_.date_publi AS date_publi_3, a0_.actif AS actif_4, a0_.titre_id AS titre_id_5, a0_.texte_id AS texte_id_6, a0_.user_crea_id AS user_crea_id_7, a0_.user_modif_id AS user_modif_id_8, a0_.visuel_id AS visuel_id_9 FROM articles a0_ INNER JOIN articles_date_event a1_ ON a0_.id = a1_.article_id WHERE a0_.actif = ? AND (a1_.date_event BETWEEN ? AND ?) ORDER BY a1_.date_event ASC

Parameters:

[
  1
  "2029-01-01 00:00:00"
  "2029-01-31 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.date_crea AS date_crea_1,
  a0_.date_modif AS date_modif_2,
  a0_.date_publi AS date_publi_3,
  a0_.actif AS actif_4,
  a0_.titre_id AS titre_id_5,
  a0_.texte_id AS texte_id_6,
  a0_.user_crea_id AS user_crea_id_7,
  a0_.user_modif_id AS user_modif_id_8,
  a0_.visuel_id AS visuel_id_9
FROM
  articles a0_
  INNER JOIN articles_date_event a1_ ON a0_.id = a1_.article_id
WHERE
  a0_.actif = ?
  AND (
    a1_.date_event BETWEEN ?
    AND ?
  )
ORDER BY
  a1_.date_event ASC

SELECT a0_.id AS id_0, a0_.date_crea AS date_crea_1, a0_.date_modif AS date_modif_2, a0_.date_publi AS date_publi_3, a0_.actif AS actif_4, a0_.titre_id AS titre_id_5, a0_.texte_id AS texte_id_6, a0_.user_crea_id AS user_crea_id_7, a0_.user_modif_id AS user_modif_id_8, a0_.visuel_id AS visuel_id_9 FROM articles a0_ INNER JOIN articles_date_event a1_ ON a0_.id = a1_.article_id WHERE a0_.actif = 1 AND (a1_.date_event BETWEEN '2029-01-01 00:00:00' AND '2029-01-31 23:59:59') ORDER BY a1_.date_event 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 146)
7	App\Repository\ArticlesRepository->findAllActifByMois (line 2779)
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.73 ms
(4.21%)

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 2776)
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.65 ms
(3.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:

[
  19
]

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 = 19 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 2750)
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
(3.36%)

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:

[
  8
]

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

#	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 2782)
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.57 ms
(3.29%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM conf_calendrier 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
FROM
  conf_calendrier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM conf_calendrier t0 WHERE t0.id = 1;

#	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 497)
7	App\Controller\ConfController->recupCases (line 2753)
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.40 ms
(2.29%)

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.36 ms
(2.10%)

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:

[
  "/agenda"
]

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 = '/agenda';

#	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 27)
7	App\Repository\PagesRepository->findAgendaByUrlActive (line 2745)
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)

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	18
App\Entity\CreneauEvent	16
App\Entity\Creneaux	9
App\Entity\DataVarchar	9
App\Entity\DataImage	9
App\Entity\SecurUser	1
App\Entity\CasesPages	1
App\Entity\Contenu	1
App\Entity\ConfCalendrier	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\ConfCalendrier	No errors.
App\Entity\Creneaux	No errors.
App\Entity\DataVarchar	No errors.
App\Entity\DataQuill	No errors.
App\Entity\DataImage	No errors.
App\Entity\CreneauEvent	No errors.
App\Entity\Articles	No errors.
App\Entity\ArticlesDateEvent	No errors.

Symfony Profiler

GET https://asfivillejuif.com/agenda/2029/01/19

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping