Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

108.82 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

98.06 ms
(90.11%)

SELECT COALESCE(SUM(LENGTH(d.content)),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COALESCE(
    SUM(
      LENGTH(d.content)
    ),
    0
  )
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COALESCE(SUM(LENGTH(d.content)),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

#	File/Call
1	App\Controller\SecurityController->login (line 27)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

4.41 ms
(4.05%)

SELECT COUNT(*) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COUNT(*) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

#	File/Call
1	App\Controller\SecurityController->login (line 24)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

4.38 ms
(4.02%)

SELECT COALESCE(SUM(d.words_count),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COALESCE(
    SUM(d.words_count),
    0
  )
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COALESCE(SUM(d.words_count),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

#	File/Call
1	App\Controller\SecurityController->login (line 25)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

1.11 ms
(1.02%)

SELECT "key", value FROM setting WHERE "key" LIKE 'frontend_%' OR "key" LIKE 'demo_%'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  "key",
  value
FROM
  setting
WHERE
  "key" LIKE 'frontend_%'
  OR "key" LIKE 'demo_%'

SELECT "key", value FROM setting WHERE "key" LIKE 'frontend_%' OR "key" LIKE 'demo_%';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Service\SettingsService->all (line 31)
3	App\Service\SettingsService->getFrontendDefaults (line 47)
4	App\Twig\SettingsExtension->getGlobals (line 16)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
15	App\Controller\SecurityController->login (line 29)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.86 ms
(0.79%)

SELECT COUNT(*) FROM volumes WHERE status = 'opublikowany'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  volumes
WHERE
  status = 'opublikowany'

SELECT COUNT(*) FROM volumes WHERE status = 'opublikowany';

#	File/Call
1	App\Controller\SecurityController->login (line 26)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	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

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://poznajwyszynskiego.pl/logowanie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping