Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.31 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.72 ms
(63.09%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.content AS content_2, c0_.category AS category_3, c0_.priority AS priority_4, c0_.is_active AS is_active_5, c0_.published_at AS published_at_6, c0_.created_at AS created_at_7, c0_.deleted_at AS deleted_at_8, c0_.created_by_id AS created_by_id_9 FROM crisis_info c0_ WHERE c0_.is_active = ? AND c0_.deleted_at IS NULL ORDER BY c0_.priority DESC, c0_.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.content AS content_2,
  c0_.category AS category_3,
  c0_.priority AS priority_4,
  c0_.is_active AS is_active_5,
  c0_.published_at AS published_at_6,
  c0_.created_at AS created_at_7,
  c0_.deleted_at AS deleted_at_8,
  c0_.created_by_id AS created_by_id_9
FROM
  crisis_info c0_
WHERE
  c0_.is_active = ?
  AND c0_.deleted_at IS NULL
ORDER BY
  c0_.priority DESC,
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.content AS content_2, c0_.category AS category_3, c0_.priority AS priority_4, c0_.is_active AS is_active_5, c0_.published_at AS published_at_6, c0_.created_at AS created_at_7, c0_.deleted_at AS deleted_at_8, c0_.created_by_id AS created_by_id_9 FROM crisis_info c0_ WHERE c0_.is_active = 1 AND c0_.deleted_at IS NULL ORDER BY c0_.priority DESC, c0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\CrisisController->index (line 23)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.59 ms
(36.91%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.label AS label_5, t0.description AS description_6, t0.updated_at AS updated_at_7 FROM site_setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.setting_type AS setting_type_4,
  t0.label AS label_5,
  t0.description AS description_6,
  t0.updated_at AS updated_at_7
FROM
  site_setting t0

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.label AS label_5, t0.description AS description_6, t0.updated_at AS updated_at_7 FROM site_setting t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\SiteSettingsService->App\Service\{closure} (line 26)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
7	Symfony\Component\Cache\LockRegistry->compute (line 111)
8	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
13	App\Service\SiteSettingsService->getAllSettings (line 22)
14	App\Service\SiteSettingsService->get (line 41)
15	App\Service\SiteSettingsService->isInitiativesEnabled (line 58)
16	Twig\Extension\CoreExtension->getAttribute (line 1909)
17	__TwigTemplate_b8deb7727e0775006b439f67930b3962::doDisplay (line 83)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_cafb5af410df6e0a62f98a7416a44f65->doDisplay (line 77)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_03a861c660b9f1398c4f394e7b299f99->doDisplay (line 54)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
30	App\Controller\CrisisController->index (line 25)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	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\SiteSetting	16

Entities Mapping

Class	Mapping errors
App\Entity\CrisisInfo	No errors.
App\Entity\User	No errors.
App\Entity\SiteSetting	No errors.

Symfony Profiler

GET https://solechub.stowsolec.org/kryzys

Configuration Settings

Theme

Page Width