Symfony Profiler

Query Metrics

104 Database Queries

5 Different statements

20.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.29 ms
(68.14%)

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:

[
  "14c27a49c28b"
  "pl"
  "/kariera"
]

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 = '14c27a49c28b' AND t0.lang = 'pl' AND t0.location = '/kariera' 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 121)
7	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->block_content (line 437)
8	Twig\Template->yieldBlock (line 188)
9	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->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 71)
20	App\Controller\Frontend\JobOffersController->careerAction (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)

3.01 ms
(14.33%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.created_at AS created_at_4, t0.updatedAt AS updatedAt_5, t0.active AS active_6 FROM job_positions t0 WHERE t0.lang = ? AND t0.active = ? ORDER BY t0.created_at DESC

Parameters:

[
  "pl"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.created_at AS created_at_4,
  t0.updatedAt AS updatedAt_5,
  t0.active AS active_6
FROM
  job_positions t0
WHERE
  t0.lang = ?
  AND t0.active = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.created_at AS created_at_4, t0.updatedAt AS updatedAt_5, t0.active AS active_6 FROM job_positions t0 WHERE t0.lang = 'pl' AND t0.active = 1 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 69)
4	App\Controller\Frontend\JobOffersController->careerAction (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)

1.62 ms
(7.73%)

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_e595fdc33c37e0ce14418379bcc7cf78->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 71)
22	App\Controller\Frontend\JobOffersController->careerAction (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.42 ms
(6.75%)

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.job_position_id = ? ORDER BY t0.created_at DESC

Parameters:

[
  10
]

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.job_position_id = ?
ORDER BY
  t0.created_at DESC

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.job_position_id = 10 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 140)
8	App\Entity\JobPosition->getActiveByLocale (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 51)
10	__TwigTemplate_1efcbe0ba7507206952570ec4b67e1c1->doDisplay (line 393)
11	Twig\Template->yield (line 434)
12	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->block_content (line 437)
13	Twig\Template->yieldBlock (line 188)
14	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->doDisplay (line 393)
17	Twig\Template->yield (line 349)
18	Twig\Template->display (line 364)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 306)
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 71)
25	App\Controller\Frontend\JobOffersController->careerAction (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.64 ms
(3.06%)

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:

[
  "/kariera"
  "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 = '/kariera' 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 105)
8	__TwigTemplate_53a14e77eb3e73566d15a3821121cf73->doDisplay (line 393)
9	Twig\Template->yield (line 81)
10	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->block_metaTags (line 437)
11	Twig\Template->yieldBlock (line 61)
12	__TwigTemplate_9dc2cf55ac3fe0b5b6e57263fe616fab->doDisplay (line 393)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_e595fdc33c37e0ce14418379bcc7cf78->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
23	App\Controller\Frontend\JobOffersController->careerAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\JobPosition	No errors.
App\Entity\JobOffer	No errors.
App\Entity\MenuItem	No errors.
App\Entity\EditableBlock	No errors.
App\Entity\JobList	No errors.

Symfony Profiler

GET https://ipopema.bloomnet.pl/kariera

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping