Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.65 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.73 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.menu_name AS menu_name_6, t0.position AS position_7, t0.redirect AS redirect_8, t0.title AS title_9, t0.content AS content_10, t0.image AS image_11, t0.keywords AS keywords_12, t0.lead_image AS lead_image_13, t0.lead AS lead_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent_id AS parent_id_17, t0.template_id AS template_id_18 FROM page t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "polityka-prywatnosci"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.menu_name AS menu_name_6,
  t0.position AS position_7,
  t0.redirect AS redirect_8,
  t0.title AS title_9,
  t0.content AS content_10,
  t0.image AS image_11,
  t0.keywords AS keywords_12,
  t0.lead_image AS lead_image_13,
  t0.lead AS lead_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.parent_id AS parent_id_17,
  t0.template_id AS template_id_18
FROM
  page t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.menu_name AS menu_name_6, t0.position AS position_7, t0.redirect AS redirect_8, t0.title AS title_9, t0.content AS content_10, t0.image AS image_11, t0.keywords AS keywords_12, t0.lead_image AS lead_image_13, t0.lead AS lead_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent_id AS parent_id_17, t0.template_id AS template_id_18 FROM page t0 WHERE t0.url = 'polityka-prywatnosci' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 238)
4	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->findOneBy (line 93)
5	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
8	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 170)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.menu_name AS menu_name_6, t0.position AS position_7, t0.redirect AS redirect_8, t0.title AS title_9, t0.content AS content_10, t0.image AS image_11, t0.keywords AS keywords_12, t0.lead_image AS lead_image_13, t0.lead AS lead_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent_id AS parent_id_17, t0.template_id AS template_id_18 FROM page t0 WHERE t0.in_menu = ? AND t0.parent_id IS NULL AND t0.enabled = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enabled AS enabled_4,
  t0.in_menu AS in_menu_5,
  t0.menu_name AS menu_name_6,
  t0.position AS position_7,
  t0.redirect AS redirect_8,
  t0.title AS title_9,
  t0.content AS content_10,
  t0.image AS image_11,
  t0.keywords AS keywords_12,
  t0.lead_image AS lead_image_13,
  t0.lead AS lead_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.parent_id AS parent_id_17,
  t0.template_id AS template_id_18
FROM
  page t0
WHERE
  t0.in_menu = ?
  AND t0.parent_id IS NULL
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enabled AS enabled_4, t0.in_menu AS in_menu_5, t0.menu_name AS menu_name_6, t0.position AS position_7, t0.redirect AS redirect_8, t0.title AS title_9, t0.content AS content_10, t0.image AS image_11, t0.keywords AS keywords_12, t0.lead_image AS lead_image_13, t0.lead AS lead_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent_id AS parent_id_17, t0.template_id AS template_id_18 FROM page t0 WHERE t0.in_menu = 1 AND t0.parent_id IS NULL AND t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 112)
4	App\Controller\PageController->page (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
9	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
10	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.59 ms

SELECT t0.id AS id_1, t0.document AS document_2, t0.info AS info_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.tile_id AS tile_id_7, t0.unit_id AS unit_id_8 FROM attachment t0 WHERE t0.page_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.document AS document_2,
  t0.info AS info_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.page_id AS page_id_6,
  t0.tile_id AS tile_id_7,
  t0.unit_id AS unit_id_8
FROM
  attachment t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.document AS document_2, t0.info AS info_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.page_id AS page_id_6, t0.tile_id AS tile_id_7, t0.unit_id AS unit_id_8 FROM attachment t0 WHERE t0.page_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 177)
8	__TwigTemplate_020d60576c5517f0dded41182394eef3->block_main (line 171)
9	Twig\Template->displayBlock (line 673)
10	__TwigTemplate_714ba93966ffe25def1409d8adb21305->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_020d60576c5517f0dded41182394eef3->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 122)
21	App\Controller\PageController->page (line 182)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
27	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 448)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\Page	No errors.
App\Entity\Template	No errors.
App\Entity\Attachment	No errors.
App\Entity\Tile	No errors.
App\Entity\Unit	No errors.

Symfony Profiler

GET https://ccz.dev.biolabs.pl/p/polityka-prywatnosci

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping