Symfony Profiler

Query Metrics

11 Database Queries

4 Different statements

2.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.06 ms
(45.12%)

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"
  "/oferty-pracy/esg"
]

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 = '/oferty-pracy/esg' 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 53)
11	__TwigTemplate_290999fc245cd0ef0555b4a5b3e39eb5->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 46)
17	App\Controller\ErrorController->show (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.82 ms
(34.62%)

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 53)
13	__TwigTemplate_290999fc245cd0ef0555b4a5b3e39eb5->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 46)
19	App\Controller\ErrorController->show (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
22	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.27 ms
(11.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.place AS place_3, t0.specialization AS specialization_4, t0.main_site AS main_site_5, t0.active AS active_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.other_meta_tags AS other_meta_tags_11, t0.lang AS lang_12, t0.created_at AS created_at_13, t0.updatedAt AS updatedAt_14, t0.job_position_id AS job_position_id_15 FROM job_offers t0 WHERE t0.lang = ? AND t0.active = ? AND t0.slug = ? ORDER BY t0.created_at DESC LIMIT 1

Parameters:

[
  "pl"
  1
  "esg"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.place AS place_3,
  t0.specialization AS specialization_4,
  t0.main_site AS main_site_5,
  t0.active AS active_6,
  t0.slug AS slug_7,
  t0.meta_title AS meta_title_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.meta_description AS meta_description_10,
  t0.other_meta_tags AS other_meta_tags_11,
  t0.lang AS lang_12,
  t0.created_at AS created_at_13,
  t0.updatedAt AS updatedAt_14,
  t0.job_position_id AS job_position_id_15
FROM
  job_offers t0
WHERE
  t0.lang = ?
  AND t0.active = ?
  AND t0.slug = ?
ORDER BY
  t0.created_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.place AS place_3, t0.specialization AS specialization_4, t0.main_site AS main_site_5, t0.active AS active_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.other_meta_tags AS other_meta_tags_11, t0.lang AS lang_12, t0.created_at AS created_at_13, t0.updatedAt AS updatedAt_14, t0.job_position_id AS job_position_id_15 FROM job_offers t0 WHERE t0.lang = 'pl' AND t0.active = 1 AND t0.slug = 'esg' ORDER BY t0.created_at DESC 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 35)
4	App\Controller\Frontend\JobOffersController->jobOfferAction (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.21 ms
(8.75%)

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:

[
  "/oferty-pracy/esg"
  "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 = '/oferty-pracy/esg' 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 285)
8	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->block_metaTags (line 437)
9	Twig\Template->yieldBlock (line 61)
10	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
11	Twig\Template->yield (line 53)
12	__TwigTemplate_290999fc245cd0ef0555b4a5b3e39eb5->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 46)
18	App\Controller\ErrorController->show (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 117)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
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)

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

Symfony Profiler

GET https://ipopema.bloomnet.pl/oferty-pracy/esg

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping