Symfony Profiler

Query Metrics

43 Database Queries

10 Different statements

9.01 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.81 ms
(42.31%)

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?

Parameters:

[
  "name"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parameter_key AS parameter_key_1,
  p0_.parameter_value AS parameter_value_2,
  p0_.parameter_label AS parameter_label_3,
  p0_.parameter_type AS parameter_type_4,
  p0_.parameter_category AS parameter_category_5,
  p0_.in_session AS in_session_6,
  p0_.parameter_category_enabled AS parameter_category_enabled_7,
  p0_.is_deleted AS is_deleted_8
FROM
  parameter p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.parameter_key = ?

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'name';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 66)
7	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 78)
8	Graphlife\CMSBundle\Repository\ParameterRepository->findOneBy (line 222)
9	Graphlife\CMSBundle\Extension\CmsExtension->getParameter (line 51)
10	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
11	Twig\Template->yield (line 60)
12	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 307)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
20	App\Controller\PageController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

2.68 ms
(29.81%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?

Parameters:

[
  "sliderBanner"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'sliderBanner';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 66)
7	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 500)
8	Graphlife\CMSBundle\Extension\CmsExtension->getWidgetTemplate (line 248)
9	__TwigTemplate_c5ab4d8cb5fb852a52b9f41fc1d017e0->doDisplay (line 360)
10	Twig\Template->yield (line 184)
11	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->block_body (line 430)
12	Twig\Template->yieldBlock (line 647)
13	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_main (line 430)
14	Twig\Template->yieldBlock (line 348)
15	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
16	Twig\Template->yield (line 60)
17	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
18	Twig\Template->yield (line 335)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 307)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
25	App\Controller\PageController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.63 ms
(6.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image_bkg AS image_bkg_4,
  t0.header_image AS header_image_5,
  t0.subtitle AS subtitle_6,
  t0.is_home AS is_home_7,
  t0.header_type AS header_type_8,
  t0.header_detail AS header_detail_9,
  t0.keywords AS keywords_10,
  t0.content AS content_11,
  t0.is_deleted AS is_deleted_12
FROM
  PAGE t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\Graphlife\CMSBundle\Entity\Page->__get (line 73)
7	Graphlife\CMSBundle\Entity\Page->getCode (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 90)
9	__TwigTemplate_5ce69f5fe083a8adbc435297115cb42d->doDisplay (line 360)
10	Twig\Template->yield (line 722)
11	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_mainMenu (line 430)
12	Twig\Template->yieldBlock (line 580)
13	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_main (line 430)
14	Twig\Template->yieldBlock (line 348)
15	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
16	Twig\Template->yield (line 60)
17	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
18	Twig\Template->yield (line 335)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 307)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
25	App\Controller\PageController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.48 ms
(5.32%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.is_home = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.image_bkg AS image_bkg_3,
  p0_.header_image AS header_image_4,
  p0_.subtitle AS subtitle_5,
  p0_.is_home AS is_home_6,
  p0_.header_type AS header_type_7,
  p0_.header_detail AS header_detail_8,
  p0_.keywords AS keywords_9,
  p0_.content AS content_10,
  p0_.is_deleted AS is_deleted_11
FROM
  PAGE p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.is_home = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.is_home = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 66)
7	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 43)
8	App\Controller\PageController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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
(4.43%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.image_bkg AS image_bkg_3,
  p0_.header_image AS header_image_4,
  p0_.subtitle AS subtitle_5,
  p0_.is_home AS is_home_6,
  p0_.header_type AS header_type_7,
  p0_.header_detail AS header_detail_8,
  p0_.keywords AS keywords_9,
  p0_.content AS content_10,
  p0_.is_deleted AS is_deleted_11
FROM
  PAGE p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 46)
7	Graphlife\CMSBundle\Repository\BaseRepository->find (line 248)
8	Graphlife\CMSBundle\Extension\CmsExtension->getPageUrl (line 90)
9	__TwigTemplate_c8e9c27a2eac275707e781f237d5ed99->doDisplay (line 360)
10	Twig\Template->yield (line 248)
11	__TwigTemplate_c5ab4d8cb5fb852a52b9f41fc1d017e0->doDisplay (line 360)
12	Twig\Template->yield (line 184)
13	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->block_body (line 430)
14	Twig\Template->yieldBlock (line 647)
15	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_main (line 430)
16	Twig\Template->yieldBlock (line 348)
17	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
18	Twig\Template->yield (line 60)
19	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
20	Twig\Template->yield (line 335)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 307)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
27	App\Controller\PageController->index (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.26 ms
(2.86%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5
FROM
  widget w0_

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 913)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 60)
7	Graphlife\CMSBundle\Extension\CmsExtension->__construct (line 715)
8	Container7ZGexVe\App_KernelDevDebugContainer::getCmsExtensionService (line 2379)
9	Container7ZGexVe\App_KernelDevDebugContainer::getTwigService (line 403)
10	Symfony\Component\DependencyInjection\Container->getService (line 40)
11	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 448)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
15	App\Controller\PageController->index (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.23 ms
(2.50%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.subscription_class_id AS subscription_class_id_11, f0_.product_type_id AS product_type_id_12 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.options AS options_3,
  f0_.price AS price_4,
  f0_.is_subscription_open AS is_subscription_open_5,
  f0_.payment_configuration AS payment_configuration_6,
  f0_.price_ht AS price_ht_7,
  f0_.is_in_top_bar AS is_in_top_bar_8,
  f0_.top_bar_message AS top_bar_message_9,
  f0_.is_deleted AS is_deleted_10,
  f0_.subscription_class_id AS subscription_class_id_11,
  f0_.product_type_id AS product_type_id_12
FROM
  formation f0_
WHERE
  COALESCE(f0_.is_deleted, 0) = 0
  AND f0_.is_in_top_bar = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.subscription_class_id AS subscription_class_id_11, f0_.product_type_id AS product_type_id_12 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 66)
7	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 41)
8	App\Twig\Runtime\LessonExtensionsRuntime->getInTopBarSubscription (line 477)
9	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_main (line 430)
10	Twig\Template->yieldBlock (line 348)
11	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
12	Twig\Template->yield (line 60)
13	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
21	App\Controller\PageController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.20 ms
(2.21%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.image AS image_3, b0_.bkg AS bkg_4, b0_.is_visible AS is_visible_5, b0_.with_text AS with_text_6, b0_.type AS type_7, b0_.overlay_background AS overlay_background_8, b0_.text AS text_9, b0_.link AS link_10, b0_.link_type AS link_type_11, b0_.page AS page_12, b0_.bkg_color AS bkg_color_13, b0_.is_deleted AS is_deleted_14 FROM banner b0_ WHERE COALESCE(b0_.is_deleted, 0) = 0 AND b0_.id IN (?)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.title AS title_2,
  b0_.image AS image_3,
  b0_.bkg AS bkg_4,
  b0_.is_visible AS is_visible_5,
  b0_.with_text AS with_text_6,
  b0_.type AS type_7,
  b0_.overlay_background AS overlay_background_8,
  b0_.text AS text_9,
  b0_.link AS link_10,
  b0_.link_type AS link_type_11,
  b0_.page AS page_12,
  b0_.bkg_color AS bkg_color_13,
  b0_.is_deleted AS is_deleted_14
FROM
  banner b0_
WHERE
  COALESCE(b0_.is_deleted, 0) = 0
  AND b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.image AS image_3, b0_.bkg AS bkg_4, b0_.is_visible AS is_visible_5, b0_.with_text AS with_text_6, b0_.type AS type_7, b0_.overlay_background AS overlay_background_8, b0_.text AS text_9, b0_.link AS link_10, b0_.link_type AS link_type_11, b0_.page AS page_12, b0_.bkg_color AS bkg_color_13, b0_.is_deleted AS is_deleted_14 FROM banner b0_ WHERE COALESCE(b0_.is_deleted, 0) = 0 AND b0_.id IN (1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 141)
7	Graphlife\CMSBundle\Repository\BaseRepository->findBy (line 145)
8	Graphlife\CMSBundle\Extension\CmsExtension->getBanners (line 54)
9	__TwigTemplate_529e160d453ba82d6e3b7ac3edfbf452->doDisplay (line 360)
10	Twig\Template->yield (line 248)
11	__TwigTemplate_c5ab4d8cb5fb852a52b9f41fc1d017e0->doDisplay (line 360)
12	Twig\Template->yield (line 184)
13	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->block_body (line 430)
14	Twig\Template->yieldBlock (line 647)
15	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->block_main (line 430)
16	Twig\Template->yieldBlock (line 348)
17	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
18	Twig\Template->yield (line 60)
19	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
20	Twig\Template->yield (line 335)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 307)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
27	App\Controller\PageController->index (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.16 ms
(1.80%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.name AS name_2,
  p0_.footer_name AS footer_name_3,
  p0_.content AS content_4,
  p0_.is_deleted AS is_deleted_5
FROM
  policy_term p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 78)
7	Graphlife\CMSBundle\Repository\BaseRepository->findAll (line 167)
8	Graphlife\CMSBundle\Extension\CmsExtension->getPolicies (line 126)
9	__TwigTemplate_c8ba3284405889f63418bf539732aeb8->doDisplay (line 360)
10	Twig\Template->yield (line 354)
11	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
12	Twig\Template->yield (line 60)
13	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 307)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
21	App\Controller\PageController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.16 ms
(1.79%)

SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link_name AS link_name_2,
  t0.url AS url_3,
  t0.on_top AS on_top_4,
  t0.ordre AS ordre_5,
  t0.visibility AS visibility_6,
  t0.link_type AS link_type_7,
  t0.page_id AS page_id_8
FROM
  menu t0

SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 62)
4	Graphlife\CMSBundle\Repository\MenuRepository->findBy (line 217)
5	Graphlife\CMSBundle\Extension\CmsExtension->getMenu (line 342)
6	__TwigTemplate_0a152cbd74a58b102f8af46756d58827->doDisplay (line 360)
7	Twig\Template->yield (line 60)
8	__TwigTemplate_cf318b30e4a24b21887195c41d984d99->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
16	App\Controller\PageController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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.

Entities Mapping

Class	Mapping errors
App\Entity\Document	No errors.
App\Entity\Event	No errors.
App\Entity\Formation	No errors.
App\Entity\Lesson	No errors.
App\Entity\LiveSession	No errors.
App\Entity\QuestionFAQ	No errors.
App\Entity\StudentClass	No errors.
App\Entity\Test	The association App\Entity\Test#account refers to the inverse side field Graphlife\CMSBundle\Entity\User#tests which does not exist. The association App\Entity\Test#course refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Product#tests which does not exist.
App\Entity\UserCourse	No errors.
App\Entity\Question	No errors.
Graphlife\CMSBundle\Entity\Banner	No errors.
Graphlife\CMSBundle\Entity\Country	No errors.
Graphlife\CMSBundle\Entity\Email	No errors.
Graphlife\CMSBundle\Entity\Menu	No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail	No errors.
Graphlife\CMSBundle\Entity\Notification	The association Graphlife\CMSBundle\Entity\Notification#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#notifications which does not exist.
Graphlife\CMSBundle\Entity\Page	No errors.
Graphlife\CMSBundle\Entity\Parameter	No errors.
Graphlife\CMSBundle\Entity\ParameterCategory	No errors.
Graphlife\CMSBundle\Entity\PolicyTerm	No errors.
Graphlife\CMSBundle\Entity\Post	No errors.
Graphlife\CMSBundle\Entity\PostCategory	No errors.
Graphlife\CMSBundle\Entity\User	No errors.
Graphlife\CMSBundle\Entity\Widget	No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo	No errors.
Graphlife\CMSPaymentBundle\Entity\Product	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductType	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter	No errors.
Graphlife\CMSPaymentBundle\Entity\Transaction	No errors.
Graphlife\CMSPaymentBundle\Entity\Currency	No errors.
Graphlife\CMSPaymentBundle\Entity\Payment	The mappings Graphlife\CMSPaymentBundle\Entity\Payment#shippments and Graphlife\CMSPaymentBundle\Entity\Shippment#payment are inconsistent with each other. The association Graphlife\CMSPaymentBundle\Entity\Payment#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#payments which does not exist.
Graphlife\CMSPaymentBundle\Entity\Category	No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod	The association Graphlife\CMSPaymentBundle\Entity\ShippingMethod#countries refers to the inverse side field Graphlife\CMSBundle\Entity\Country#shippingMethods which does not exist.
Graphlife\CMSPaymentBundle\Entity\Shippment	The association Graphlife\CMSPaymentBundle\Entity\Shippment#payment refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Payment#shippment which does not exist.
Graphlife\CMSPaymentBundle\Entity\Stock	No errors.

Symfony Profiler

GET https://centre-rac.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping