Symfony Profiler

Query Metrics

13 Database Queries

10 Different statements

12.50 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.11 ms
(16.89%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 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_.name AS name_4,
  p0_.title AS title_5,
  p0_.slug_en AS slug_en_6,
  p0_.navbar AS navbar_7,
  p0_.ordre AS ordre_8,
  p0_.actif AS actif_9,
  p0_.home_page AS home_page_10,
  p0_.layout AS layout_11,
  p0_.content AS content_12,
  p0_.date_crea AS date_crea_13,
  p0_.date_modif AS date_modif_14,
  p0_.user_crea_id AS user_crea_id_15,
  p0_.user_modif_id AS user_modif_id_16,
  p0_.parent_id AS parent_id_17
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_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Pages\PagesRepository->findHomePage (line 56)
7	App\Controller\ZFrontController->front_index (line 186)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.96 ms
(15.67%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.name AS name_5, t0.title AS title_6, t0.slug_en AS slug_en_7, t0.navbar AS navbar_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.home_page AS home_page_11, t0.layout AS layout_12, t0.content AS content_13, t0.date_crea AS date_crea_14, t0.date_modif AS date_modif_15, t0.user_crea_id AS user_crea_id_16, t0.user_modif_id AS user_modif_id_17, t0.parent_id AS parent_id_18 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.name AS name_5,
  t0.title AS title_6,
  t0.slug_en AS slug_en_7,
  t0.navbar AS navbar_8,
  t0.ordre AS ordre_9,
  t0.actif AS actif_10,
  t0.home_page AS home_page_11,
  t0.layout AS layout_12,
  t0.content AS content_13,
  t0.date_crea AS date_crea_14,
  t0.date_modif AS date_modif_15,
  t0.user_crea_id AS user_crea_id_16,
  t0.user_modif_id AS user_modif_id_17,
  t0.parent_id AS parent_id_18
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.name AS name_5, t0.title AS title_6, t0.slug_en AS slug_en_7, t0.navbar AS navbar_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.home_page AS home_page_11, t0.layout AS layout_12, t0.content AS content_13, t0.date_crea AS date_crea_14, t0.date_modif AS date_modif_15, t0.user_crea_id AS user_crea_id_16, t0.user_modif_id AS user_modif_id_17, t0.parent_id AS parent_id_18 FROM pages t0 WHERE t0.parent_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_a06a71e88e37fda62b23437cade9446a::doDisplay (line 122)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_48efdccbeb51e1a7f8e60299ec8070d9->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b870b4b087ba0170e36084c4d678947a->doDisplay (line 367)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_3333ecacb619da385d7c46cd18f6a957->doDisplay (line 56)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\ZFrontController->front_index (line 571)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.43 ms
(11.44%)

SELECT t0.id AS id_1, t0.png32 AS png32_2, t0.png16 AS png16_3, t0.ico AS ico_4, t0.png180 AS png180_5, t0.theme_color AS theme_color_6, t0.png192 AS png192_7, t0.png512 AS png512_8, t0.svg_icon AS svg_icon_9, t0.svg_color AS svg_color_10, t0.tile_color AS tile_color_11, t0.png70 AS png70_12, t0.png150 AS png150_13, t0.png310 AS png310_14, t0.png310w150 AS png310w150_15, t0.background_color AS background_color_16 FROM favicon t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.png32 AS png32_2,
  t0.png16 AS png16_3,
  t0.ico AS ico_4,
  t0.png180 AS png180_5,
  t0.theme_color AS theme_color_6,
  t0.png192 AS png192_7,
  t0.png512 AS png512_8,
  t0.svg_icon AS svg_icon_9,
  t0.svg_color AS svg_color_10,
  t0.tile_color AS tile_color_11,
  t0.png70 AS png70_12,
  t0.png150 AS png150_13,
  t0.png310 AS png310_14,
  t0.png310w150 AS png310w150_15,
  t0.background_color AS background_color_16
FROM
  favicon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.png32 AS png32_2, t0.png16 AS png16_3, t0.ico AS ico_4, t0.png180 AS png180_5, t0.theme_color AS theme_color_6, t0.png192 AS png192_7, t0.png512 AS png512_8, t0.svg_icon AS svg_icon_9, t0.svg_color AS svg_color_10, t0.tile_color AS tile_color_11, t0.png70 AS png70_12, t0.png150 AS png150_13, t0.png310 AS png310_14, t0.png310w150 AS png310w150_15, t0.background_color AS background_color_16 FROM favicon t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ZFrontController->front_index (line 193)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.33 ms
(10.68%)

SELECT t0.id AS id_1, t0.logo_fsp AS logo_fsp_2, t0.logo_fsm AS logo_fsm_3, t0.logo_fsg AS logo_fsg_4, t0.logo_fsv AS logo_fsv_5, t0.logo_fcp AS logo_fcp_6, t0.logo_fcm AS logo_fcm_7, t0.logo_fcg AS logo_fcg_8, t0.logo_fcv AS logo_fcv_9, t0.logo_nbfcp AS logo_nbfcp_10, t0.logo_nbfcm AS logo_nbfcm_11, t0.logo_nbfcg AS logo_nbfcg_12, t0.logo_nbfcv AS logo_nbfcv_13, t0.logo_nbfsp AS logo_nbfsp_14, t0.logo_nbfsm AS logo_nbfsm_15, t0.logo_nbfsg AS logo_nbfsg_16, t0.logo_nbfsv AS logo_nbfsv_17, t0.logo_fsvw AS logo_fsvw_18, t0.logo_fsvh AS logo_fsvh_19, t0.logo_fcvw AS logo_fcvw_20, t0.logo_fcvh AS logo_fcvh_21, t0.logo_nbfcvw AS logo_nbfcvw_22, t0.logo_nbfcvh AS logo_nbfcvh_23, t0.logo_nbfsvw AS logo_nbfsvw_24, t0.logo_nbfsvh AS logo_nbfsvh_25 FROM logo t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo_fsp AS logo_fsp_2,
  t0.logo_fsm AS logo_fsm_3,
  t0.logo_fsg AS logo_fsg_4,
  t0.logo_fsv AS logo_fsv_5,
  t0.logo_fcp AS logo_fcp_6,
  t0.logo_fcm AS logo_fcm_7,
  t0.logo_fcg AS logo_fcg_8,
  t0.logo_fcv AS logo_fcv_9,
  t0.logo_nbfcp AS logo_nbfcp_10,
  t0.logo_nbfcm AS logo_nbfcm_11,
  t0.logo_nbfcg AS logo_nbfcg_12,
  t0.logo_nbfcv AS logo_nbfcv_13,
  t0.logo_nbfsp AS logo_nbfsp_14,
  t0.logo_nbfsm AS logo_nbfsm_15,
  t0.logo_nbfsg AS logo_nbfsg_16,
  t0.logo_nbfsv AS logo_nbfsv_17,
  t0.logo_fsvw AS logo_fsvw_18,
  t0.logo_fsvh AS logo_fsvh_19,
  t0.logo_fcvw AS logo_fcvw_20,
  t0.logo_fcvh AS logo_fcvh_21,
  t0.logo_nbfcvw AS logo_nbfcvw_22,
  t0.logo_nbfcvh AS logo_nbfcvh_23,
  t0.logo_nbfsvw AS logo_nbfsvw_24,
  t0.logo_nbfsvh AS logo_nbfsvh_25
FROM
  logo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.logo_fsp AS logo_fsp_2, t0.logo_fsm AS logo_fsm_3, t0.logo_fsg AS logo_fsg_4, t0.logo_fsv AS logo_fsv_5, t0.logo_fcp AS logo_fcp_6, t0.logo_fcm AS logo_fcm_7, t0.logo_fcg AS logo_fcg_8, t0.logo_fcv AS logo_fcv_9, t0.logo_nbfcp AS logo_nbfcp_10, t0.logo_nbfcm AS logo_nbfcm_11, t0.logo_nbfcg AS logo_nbfcg_12, t0.logo_nbfcv AS logo_nbfcv_13, t0.logo_nbfsp AS logo_nbfsp_14, t0.logo_nbfsm AS logo_nbfsm_15, t0.logo_nbfsg AS logo_nbfsg_16, t0.logo_nbfsv AS logo_nbfsv_17, t0.logo_fsvw AS logo_fsvw_18, t0.logo_fsvh AS logo_fsvh_19, t0.logo_fcvw AS logo_fcvw_20, t0.logo_fcvh AS logo_fcvh_21, t0.logo_nbfcvw AS logo_nbfcvw_22, t0.logo_nbfcvh AS logo_nbfcvh_23, t0.logo_nbfsvw AS logo_nbfsvw_24, t0.logo_nbfsvh AS logo_nbfsvh_25 FROM logo t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ZFrontController->front_index (line 197)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.30 ms
(10.38%)

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_.conf_class AS conf_class_4, c0_.actif AS actif_5, c0_.page_id AS page_id_6, c0_.contenu_id AS contenu_id_7 FROM cases_pages c0_ WHERE c0_.page_id = ? AND c0_.actif = 1 ORDER BY c0_.ordre ASC

Parameters:

[
  3
]

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_.conf_class AS conf_class_4,
  c0_.actif AS actif_5,
  c0_.page_id AS page_id_6,
  c0_.contenu_id AS contenu_id_7
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_.conf_class AS conf_class_4, c0_.actif AS actif_5, c0_.page_id AS page_id_6, c0_.contenu_id AS contenu_id_7 FROM cases_pages c0_ WHERE c0_.page_id = 3 AND c0_.actif = 1 ORDER BY c0_.ordre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Pages\CasesPagesRepository->findCaseActifByOrdre (line 41)
7	App\Controller\ZFrontController->front_index (line 523)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.18 ms
(9.43%)

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.actif AS actif_2, t0_.code_head AS code_head_3, t0_.code_body AS code_body_4, t0_.date_crea AS date_crea_5 FROM template t0_ WHERE t0_.actif = 1 ORDER BY t0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.actif AS actif_2,
  t0_.code_head AS code_head_3,
  t0_.code_body AS code_body_4,
  t0_.date_crea AS date_crea_5
FROM
  template t0_
WHERE
  t0_.actif = 1
ORDER BY
  t0_.id DESC

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.actif AS actif_2, t0_.code_head AS code_head_3, t0_.code_body AS code_body_4, t0_.date_crea AS date_crea_5 FROM template t0_ WHERE t0_.actif = 1 ORDER BY t0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Interface\TemplateRepository->findActif (line 39)
7	App\Controller\ZFrontController->front_index (line 211)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.10 ms
(8.80%)

SELECT j0_.id AS id_0, j0_.version AS version_1, j0_.code_head AS code_head_2, j0_.code_body AS code_body_3, j0_.actif AS actif_4 FROM jquery j0_ WHERE j0_.actif = 1 ORDER BY j0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.version AS version_1,
  j0_.code_head AS code_head_2,
  j0_.code_body AS code_body_3,
  j0_.actif AS actif_4
FROM
  jquery j0_
WHERE
  j0_.actif = 1
ORDER BY
  j0_.id DESC

SELECT j0_.id AS id_0, j0_.version AS version_1, j0_.code_head AS code_head_2, j0_.code_body AS code_body_3, j0_.actif AS actif_4 FROM jquery j0_ WHERE j0_.actif = 1 ORDER BY j0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Interface\JqueryRepository->findActif (line 39)
7	App\Controller\ZFrontController->front_index (line 206)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.06 ms
(8.44%)

SELECT b0_.id AS id_0, b0_.version AS version_1, b0_.code_head AS code_head_2, b0_.code_body AS code_body_3, b0_.actif AS actif_4 FROM bootstrap b0_ WHERE b0_.actif = 1 ORDER BY b0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.version AS version_1,
  b0_.code_head AS code_head_2,
  b0_.code_body AS code_body_3,
  b0_.actif AS actif_4
FROM
  bootstrap b0_
WHERE
  b0_.actif = 1
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.version AS version_1, b0_.code_head AS code_head_2, b0_.code_body AS code_body_3, b0_.actif AS actif_4 FROM bootstrap b0_ WHERE b0_.actif = 1 ORDER BY b0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Interface\BootstrapRepository->findActif (line 42)
7	App\Controller\ZFrontController->front_index (line 201)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.54 ms
(4.32%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 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_.name AS name_4,
  p0_.title AS title_5,
  p0_.slug_en AS slug_en_6,
  p0_.navbar AS navbar_7,
  p0_.ordre AS ordre_8,
  p0_.actif AS actif_9,
  p0_.home_page AS home_page_10,
  p0_.layout AS layout_11,
  p0_.content AS content_12,
  p0_.date_crea AS date_crea_13,
  p0_.date_modif AS date_modif_14,
  p0_.user_crea_id AS user_crea_id_15,
  p0_.user_modif_id AS user_modif_id_16,
  p0_.parent_id AS parent_id_17
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_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 FROM pages p0_ WHERE p0_.home_page = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Pages\PagesRepository->findAllHomePage (line 65)
7	App\Controller\ZFrontController->front_index (line 189)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.49 ms
(3.95%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = ?

Parameters:

[
  "/boutique"
]

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_.name AS name_4,
  p0_.title AS title_5,
  p0_.slug_en AS slug_en_6,
  p0_.navbar AS navbar_7,
  p0_.ordre AS ordre_8,
  p0_.actif AS actif_9,
  p0_.home_page AS home_page_10,
  p0_.layout AS layout_11,
  p0_.content AS content_12,
  p0_.date_crea AS date_crea_13,
  p0_.date_modif AS date_modif_14,
  p0_.user_crea_id AS user_crea_id_15,
  p0_.user_modif_id AS user_modif_id_16,
  p0_.parent_id AS parent_id_17
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_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = '/boutique';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Pages\PagesRepository->findPagesByUrlActive (line 77)
7	App\Controller\ZFrontController->front_index (line 494)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (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\Pages	4
App\Entity\Securite\SecurUser	2
App\Entity\Interface\Favicon	1
App\Entity\Interface\Logo	1
App\Entity\Interface\Bootstrap	1
App\Entity\Interface\Jquery	1
App\Entity\Interface\Template	1

Entities Mapping

Class	Mapping errors
App\Entity\Pages\Pages	No errors.
App\Entity\Securite\SecurUser	No errors.
App\Entity\Interface\Favicon	No errors.
App\Entity\Interface\Logo	No errors.
App\Entity\Interface\Bootstrap	No errors.
App\Entity\Interface\Jquery	No errors.
App\Entity\Interface\Template	No errors.
App\Entity\Pages\CasesPages	No errors.
App\Entity\Pages\Contenu	No errors.

Symfony Profiler

GET https://justarigolo.fr/boutique

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping