Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.78 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(28.82%)

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 37)
7	App\Repository\PagesRepository->findHomePage (line 658)
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.57 ms
(20.39%)

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:

[
  6
]

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 = 6 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 699)
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.51 ms
(18.49%)

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:

[
  "/filmography"
]

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

#	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 58)
7	App\Repository\PagesRepository->findPagesByUrlActive (line 683)
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.48 ms
(17.38%)

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 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
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 FROM contenu t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Contenu::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Contenu->__get (line 72)
8	App\Entity\Contenu->getJs (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 74)
10	__TwigTemplate_f9f2041ecaef20d13ccf13cff4da891e->doDisplay (line 388)
11	Twig\Template->yield (line 165)
12	__TwigTemplate_524d7b10e6d6f14400beb3479db76af1->doDisplay (line 388)
13	Twig\Template->yield (line 57)
14	__TwigTemplate_fda7dbd002fc1d0a88b633d2ab81508b->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 726)
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.41 ms
(14.92%)

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 46)
7	App\Repository\PagesRepository->findAllHomePage (line 686)
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	2
App\Entity\SecurUser	1
App\Entity\CasesPages	1
App\Entity\Contenu	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.

Symfony Profiler

GET https://philippegautier.com/filmography

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping