Symfony Profiler

Query Metrics

15 Database Queries

8 Different statements

9.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.75 ms
(19.16%)

SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = ? ORDER BY m0_.parent_id ASC, m0_.position ASC

Parameters:

[
  "pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.lang AS lang_0,
  m0_.id AS id_1,
  m0_.label AS label_2,
  m0_.url AS url_3,
  m0_.seo_title AS seo_title_4,
  m0_.seo_description AS seo_description_5,
  m0_.seo_keywords AS seo_keywords_6,
  m0_.enabled AS enabled_7,
  m0_.position AS position_8,
  m0_.icon AS icon_9,
  m0_.parent_id AS parent_id_10
FROM
  menu_item m0_
WHERE
  m0_.lang = ?
ORDER BY
  m0_.parent_id ASC,
  m0_.position ASC

SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = 'pl' ORDER BY m0_.parent_id ASC, m0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 153)
7	App\Repository\MenuItemRepository->findTreeArrayByLang (line 60)
8	App\Twig\Frontend\MenuExtension->getMenu (line 81)
9	__TwigTemplate_6efb83c51571e57884d8fc52296c33b1->doDisplay (line 393)
10	Twig\Template->yield (line 179)
11	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_42fc26f75173e6152f18d55f31099f9f->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 151)
22	App\Controller\Frontend\NewsController->eventAction (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.61 ms
(17.67%)

SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1

Parameters:

[
  "b33388c3ad5b"
  "pl"
  "/wydarzenia/sap-innovation-day"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hash_id AS hash_id_2,
  t0.lang AS lang_3,
  t0.content AS content_4,
  t0.location AS location_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  editable_blocks t0
WHERE
  t0.hash_id = ?
  AND t0.lang = ?
  AND t0.location = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = 'b33388c3ad5b' AND t0.lang = 'pl' AND t0.location = '/wydarzenia/sap-innovation-day' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 37)
5	App\Twig\Frontend\Editor\EditableBlockRenderer->render (line 13)
6	App\Twig\Frontend\Editor\EditableBlockRuntime->render (line 74)
7	__TwigTemplate_0a7e7a4368afcd4b09113f91aeb3867b->doDisplay (line 393)
8	Twig\Template->yield (line 197)
9	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_42fc26f75173e6152f18d55f31099f9f->doDisplay (line 393)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
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 151)
20	App\Controller\Frontend\NewsController->eventAction (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)

1.24 ms
(13.62%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.date AS date_2, e0_.intro AS intro_3, e0_.content AS content_4, e0_.miniature_file_name AS miniature_file_name_5, e0_.active AS active_6, e0_.slug AS slug_7, e0_.author AS author_8, e0_.meta_title AS meta_title_9, e0_.meta_keywords AS meta_keywords_10, e0_.meta_description AS meta_description_11, e0_.other_meta_tags AS other_meta_tags_12, e0_.lang AS lang_13, e0_.created_at AS created_at_14, e0_.updatedAt AS updatedAt_15, e0_.highlighted AS highlighted_16 FROM events e0_ WHERE e0_.id <> ? AND e0_.active = ? AND e0_.lang LIKE ? ORDER BY e0_.highlighted DESC, e0_.date DESC LIMIT 4

Parameters:

[
  42
  1
  "pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.date AS date_2,
  e0_.intro AS intro_3,
  e0_.content AS content_4,
  e0_.miniature_file_name AS miniature_file_name_5,
  e0_.active AS active_6,
  e0_.slug AS slug_7,
  e0_.author AS author_8,
  e0_.meta_title AS meta_title_9,
  e0_.meta_keywords AS meta_keywords_10,
  e0_.meta_description AS meta_description_11,
  e0_.other_meta_tags AS other_meta_tags_12,
  e0_.lang AS lang_13,
  e0_.created_at AS created_at_14,
  e0_.updatedAt AS updatedAt_15,
  e0_.highlighted AS highlighted_16
FROM
  events e0_
WHERE
  e0_.id <> ?
  AND e0_.active = ?
  AND e0_.lang LIKE ?
ORDER BY
  e0_.highlighted DESC,
  e0_.date DESC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.date AS date_2, e0_.intro AS intro_3, e0_.content AS content_4, e0_.miniature_file_name AS miniature_file_name_5, e0_.active AS active_6, e0_.slug AS slug_7, e0_.author AS author_8, e0_.meta_title AS meta_title_9, e0_.meta_keywords AS meta_keywords_10, e0_.meta_description AS meta_description_11, e0_.other_meta_tags AS other_meta_tags_12, e0_.lang AS lang_13, e0_.created_at AS created_at_14, e0_.updatedAt AS updatedAt_15, e0_.highlighted AS highlighted_16 FROM events e0_ WHERE e0_.id <> 42 AND e0_.active = 1 AND e0_.lang LIKE 'pl' ORDER BY e0_.highlighted DESC, e0_.date DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 26)
7	App\Repository\EventRepository->findOtherEvents (line 149)
8	App\Controller\Frontend\NewsController->eventAction (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)

1.19 ms
(13.11%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.intro AS intro_4, t0.content AS content_5, t0.miniature_file_name AS miniature_file_name_6, t0.active AS active_7, t0.slug AS slug_8, t0.author AS author_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.other_meta_tags AS other_meta_tags_13, t0.lang AS lang_14, t0.created_at AS created_at_15, t0.updatedAt AS updatedAt_16, t0.highlighted AS highlighted_17 FROM events t0 WHERE t0.lang = ? AND t0.active = ? AND t0.slug = ? LIMIT 1

Parameters:

[
  "pl"
  1
  "sap-innovation-day"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.intro AS intro_4,
  t0.content AS content_5,
  t0.miniature_file_name AS miniature_file_name_6,
  t0.active AS active_7,
  t0.slug AS slug_8,
  t0.author AS author_9,
  t0.meta_title AS meta_title_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.meta_description AS meta_description_12,
  t0.other_meta_tags AS other_meta_tags_13,
  t0.lang AS lang_14,
  t0.created_at AS created_at_15,
  t0.updatedAt AS updatedAt_16,
  t0.highlighted AS highlighted_17
FROM
  events t0
WHERE
  t0.lang = ?
  AND t0.active = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.intro AS intro_4, t0.content AS content_5, t0.miniature_file_name AS miniature_file_name_6, t0.active AS active_7, t0.slug AS slug_8, t0.author AS author_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.other_meta_tags AS other_meta_tags_13, t0.lang AS lang_14, t0.created_at AS created_at_15, t0.updatedAt AS updatedAt_16, t0.highlighted AS highlighted_17 FROM events t0 WHERE t0.lang = 'pl' AND t0.active = 1 AND t0.slug = 'sap-innovation-day' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 138)
4	App\Controller\Frontend\NewsController->eventAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.86 ms
(9.47%)

SELECT count(e0_.id) AS sclr_0 FROM events e0_ WHERE e0_.active = ? AND e0_.lang LIKE ? AND e0_.id <> ?

Parameters:

[
  1
  "pl"
  42
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(e0_.id) AS sclr_0
FROM
  events e0_
WHERE
  e0_.active = ?
  AND e0_.lang LIKE ?
  AND e0_.id <> ?

SELECT count(e0_.id) AS sclr_0 FROM events e0_ WHERE e0_.active = 1 AND e0_.lang LIKE 'pl' AND e0_.id <> 42;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 44)
8	App\Repository\EventRepository->totalCount (line 146)
9	App\Controller\Frontend\NewsController->eventAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.83 ms
(9.09%)

SELECT e0_.id AS id_0 FROM events e0_ WHERE e0_.active = ? AND e0_.lang LIKE ? ORDER BY e0_.highlighted DESC, e0_.date DESC

Parameters:

[
  1
  "pl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0
FROM
  events e0_
WHERE
  e0_.active = ?
  AND e0_.lang LIKE ?
ORDER BY
  e0_.highlighted DESC,
  e0_.date DESC

SELECT e0_.id AS id_0 FROM events e0_ WHERE e0_.active = 1 AND e0_.lang LIKE 'pl' ORDER BY e0_.highlighted DESC, e0_.date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 82)
7	App\Repository\EventRepository->findNextArticle (line 142)
8	App\Controller\Frontend\NewsController->eventAction (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.83 ms
(9.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.intro AS intro_4, t0.content AS content_5, t0.miniature_file_name AS miniature_file_name_6, t0.active AS active_7, t0.slug AS slug_8, t0.author AS author_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.other_meta_tags AS other_meta_tags_13, t0.lang AS lang_14, t0.created_at AS created_at_15, t0.updatedAt AS updatedAt_16, t0.highlighted AS highlighted_17 FROM events t0 WHERE t0.id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.intro AS intro_4,
  t0.content AS content_5,
  t0.miniature_file_name AS miniature_file_name_6,
  t0.active AS active_7,
  t0.slug AS slug_8,
  t0.author AS author_9,
  t0.meta_title AS meta_title_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.meta_description AS meta_description_12,
  t0.other_meta_tags AS other_meta_tags_13,
  t0.lang AS lang_14,
  t0.created_at AS created_at_15,
  t0.updatedAt AS updatedAt_16,
  t0.highlighted AS highlighted_17
FROM
  events t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.intro AS intro_4, t0.content AS content_5, t0.miniature_file_name AS miniature_file_name_6, t0.active AS active_7, t0.slug AS slug_8, t0.author AS author_9, t0.meta_title AS meta_title_10, t0.meta_keywords AS meta_keywords_11, t0.meta_description AS meta_description_12, t0.other_meta_tags AS other_meta_tags_13, t0.lang AS lang_14, t0.created_at AS created_at_15, t0.updatedAt AS updatedAt_16, t0.highlighted AS highlighted_17 FROM events t0 WHERE t0.id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 87)
6	App\Repository\EventRepository->findNextArticle (line 142)
7	App\Controller\Frontend\NewsController->eventAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.80 ms
(8.82%)

SELECT t0.lang AS lang_1, t0.id AS id_2, t0.label AS label_3, t0.url AS url_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.icon AS icon_10, t0.parent_id AS parent_id_11 FROM menu_item t0 WHERE t0.url = ? AND t0.lang = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "/wydarzenia/sap-innovation-day"
  "pl"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lang AS lang_1,
  t0.id AS id_2,
  t0.label AS label_3,
  t0.url AS url_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.seo_keywords AS seo_keywords_7,
  t0.enabled AS enabled_8,
  t0.position AS position_9,
  t0.icon AS icon_10,
  t0.parent_id AS parent_id_11
FROM
  menu_item t0
WHERE
  t0.url = ?
  AND t0.lang = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.lang AS lang_1, t0.id AS id_2, t0.label AS label_3, t0.url AS url_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.icon AS icon_10, t0.parent_id AS parent_id_11 FROM menu_item t0 WHERE t0.url = '/wydarzenia/sap-innovation-day' AND t0.lang = 'pl' AND t0.enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 91)
5	App\Twig\Frontend\MenuExtension->getCurrentMenuItem (line 51)
6	__TwigTemplate_51f8a3240f07b982ea398b149545b1d0->doDisplay (line 393)
7	Twig\Template->yield (line 86)
8	__TwigTemplate_42fc26f75173e6152f18d55f31099f9f->block_metaTags (line 437)
9	Twig\Template->yieldBlock (line 61)
10	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_42fc26f75173e6152f18d55f31099f9f->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
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 151)
21	App\Controller\Frontend\NewsController->eventAction (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)

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\Event	No errors.
App\Entity\MenuItem	No errors.
App\Entity\EditableBlock	No errors.

Symfony Profiler

GET https://ipopema.bloomnet.pl/wydarzenia/sap-innovation-day

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping