Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.75 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.94 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.active AS active_4, s0_.is_system_page AS is_system_page_5, s0_.template AS template_6, s0_.title AS title_7, s0_.meta_title AS meta_title_8, s0_.meta_keywords AS meta_keywords_9, s0_.meta_description AS meta_description_10, s0_.image_id AS image_id_11 FROM static_page s0_ WHERE s0_.active = 1 AND s0_.is_system_page = ? AND s0_.slug = ?

Parameters:

[
  1
  "polityka-prywatnosci"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.content AS content_3,
  s0_.active AS active_4,
  s0_.is_system_page AS is_system_page_5,
  s0_.template AS template_6,
  s0_.title AS title_7,
  s0_.meta_title AS meta_title_8,
  s0_.meta_keywords AS meta_keywords_9,
  s0_.meta_description AS meta_description_10,
  s0_.image_id AS image_id_11
FROM
  static_page s0_
WHERE
  s0_.active = 1
  AND s0_.is_system_page = ?
  AND s0_.slug = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.active AS active_4, s0_.is_system_page AS is_system_page_5, s0_.template AS template_6, s0_.title AS title_7, s0_.meta_title AS meta_title_8, s0_.meta_keywords AS meta_keywords_9, s0_.meta_description AS meta_description_10, s0_.image_id AS image_id_11 FROM static_page s0_ WHERE s0_.active = 1 AND s0_.is_system_page = 1 AND s0_.slug = 'polityka-prywatnosci';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 54)
7	App\Repository\StaticPageRepository->findOneBySlug (line 34)
8	App\Controller\Frontend\StaticPageController->systemPage (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.81 ms

SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.value AS value_1
FROM
  setting s0_

SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 66)
7	App\Repository\SettingRepository->findAllOnlyValuesWithKey (line 25)
8	App\Service\SettingService->getList (line 37)
9	App\Service\SettingService->loadList (line 49)
10	App\Service\SettingService->get (line 18)
11	App\Twig\Runtime\SettingExtensionRuntime->setting (line 246)
12	__TwigTemplate_70d7e93218197b48cff238f406a78612->block_title (line 446)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_758e446dc8f7365136dcd2161a528fb6->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
25	App\Controller\Frontend\StaticPageController->systemPage (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\StaticPage	1

Entities Mapping

Class	Mapping errors
App\Entity\StaticPage	No errors.
App\Entity\Image	No errors.
App\Entity\Setting	No errors.

Symfony Profiler

GET https://dev.petso.halisz.pl/polityka-prywatnosci

Configuration Settings

Theme

Page Width