Symfony Profiler

Query Metrics

4 Database Queries

1 Different statements

1.74 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.97 ms

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = ?

Parameters:

[
  "auth.password_enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.group_name AS group_name_1,
  s0_.key_name AS key_name_2,
  s0_.key_value AS key_value_3,
  s0_.is_serialised AS is_serialised_4,
  s0_.more_info AS more_info_5
FROM
  system_config s0_
WHERE
  s0_.key_name = ?

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = 'auth.password_enabled';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\System\SystemConfigRepository->findConfigByKey (line 168)
7	App\Security\AuthSettings->value (line 47)
8	App\Security\AuthSettings->isPasswordEnabled (line 21)
9	App\Controller\Auth\AuthenticationController->login (line 109)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.32 ms

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = ?

Parameters:

[
  "auth.google_enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.group_name AS group_name_1,
  s0_.key_name AS key_name_2,
  s0_.key_value AS key_value_3,
  s0_.is_serialised AS is_serialised_4,
  s0_.more_info AS more_info_5
FROM
  system_config s0_
WHERE
  s0_.key_name = ?

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = 'auth.google_enabled';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\System\SystemConfigRepository->findConfigByKey (line 168)
7	App\Security\AuthSettings->value (line 47)
8	App\Security\AuthSettings->isGoogleEnabled (line 26)
9	App\Controller\Auth\AuthenticationController->login (line 110)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.25 ms

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = ?

Parameters:

[
  "auth.otp_enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.group_name AS group_name_1,
  s0_.key_name AS key_name_2,
  s0_.key_value AS key_value_3,
  s0_.is_serialised AS is_serialised_4,
  s0_.more_info AS more_info_5
FROM
  system_config s0_
WHERE
  s0_.key_name = ?

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = 'auth.otp_enabled';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\System\SystemConfigRepository->findConfigByKey (line 168)
7	App\Security\AuthSettings->value (line 47)
8	App\Security\AuthSettings->isOtpEnabled (line 36)
9	App\Controller\Auth\AuthenticationController->login (line 111)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.20 ms

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = ?

Parameters:

[
  "auth.remember_me_enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.group_name AS group_name_1,
  s0_.key_name AS key_name_2,
  s0_.key_value AS key_value_3,
  s0_.is_serialised AS is_serialised_4,
  s0_.more_info AS more_info_5
FROM
  system_config s0_
WHERE
  s0_.key_name = ?

SELECT s0_.id AS id_0, s0_.group_name AS group_name_1, s0_.key_name AS key_name_2, s0_.key_value AS key_value_3, s0_.is_serialised AS is_serialised_4, s0_.more_info AS more_info_5 FROM system_config s0_ WHERE s0_.key_name = 'auth.remember_me_enabled';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\System\SystemConfigRepository->findConfigByKey (line 168)
7	App\Security\AuthSettings->value (line 47)
8	App\Security\AuthSettings->isRememberMeEnabled (line 41)
9	App\Controller\Auth\AuthenticationController->login (line 112)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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\System\SystemConfig	4

Entities Mapping

Class	Mapping errors
App\Entity\System\SystemConfig	No errors.

Symfony Profiler

GET http://fretka.lnk2.me/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping