Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.49 ms Query time

0 Invalid entities

59 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.29 ms

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = ?

Parameters:

[
  "0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.name_hash AS name_hash_2,
  o0_.user_name AS user_name_3,
  o0_.user_name_hash AS user_name_hash_4,
  o0_.password AS password_5,
  o0_.token AS token_6,
  o0_.api_type AS api_type_7,
  o0_.base_url AS base_url_8,
  o0_.api_key AS api_key_9,
  o0_.status AS status_10,
  o0_.channel AS channel_11,
  o0_.short_name AS short_name_12
FROM
  outside_system o0_
WHERE
  o0_.user_name_hash = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = '0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 34)
7	App\Repository\OutsideSystemRepository->findOneByUserName (line 22)
8	App\Security\OutsideSystemUserProvider->loadUserByIdentifier (line 87)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
22	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 50)

1.20 ms

SELECT p0_.params_id AS params_id_0, p0_.params_short_name AS params_short_name_1, p0_.params_name AS params_name_2, p0_.params_desc AS params_desc_3, p0_.params_logo AS params_logo_4, p0_.params_enabled AS params_enabled_5, p0_.params_field_type AS params_field_type_6, p0_.params_field_length AS params_field_length_7, p0_.params_field_required AS params_field_required_8, p0_.params_field_validator AS params_field_validator_9, p0_.params_value AS params_value_10, p0_.params_updated_at AS params_updated_at_11, p0_.params_updated_by AS params_updated_by_12, p0_.app_enabled AS app_enabled_13, p0_.params_form_field_type AS params_form_field_type_14, p0_.params_order AS params_order_15, p0_.params_dict AS params_dict_16, p0_.params_default_value AS params_default_value_17, p0_.params_visibility AS params_visibility_18, p0_.status AS status_19, p0_.params_group_id AS params_group_id_20 FROM params p0_ WHERE ((p0_.params_enabled = 1 AND p0_.app_enabled = 1) AND (p0_.params_value <> p0_.params_default_value OR p0_.params_default_value IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.params_id AS params_id_0,
  p0_.params_short_name AS params_short_name_1,
  p0_.params_name AS params_name_2,
  p0_.params_desc AS params_desc_3,
  p0_.params_logo AS params_logo_4,
  p0_.params_enabled AS params_enabled_5,
  p0_.params_field_type AS params_field_type_6,
  p0_.params_field_length AS params_field_length_7,
  p0_.params_field_required AS params_field_required_8,
  p0_.params_field_validator AS params_field_validator_9,
  p0_.params_value AS params_value_10,
  p0_.params_updated_at AS params_updated_at_11,
  p0_.params_updated_by AS params_updated_by_12,
  p0_.app_enabled AS app_enabled_13,
  p0_.params_form_field_type AS params_form_field_type_14,
  p0_.params_order AS params_order_15,
  p0_.params_dict AS params_dict_16,
  p0_.params_default_value AS params_default_value_17,
  p0_.params_visibility AS params_visibility_18,
  p0_.status AS status_19,
  p0_.params_group_id AS params_group_id_20
FROM
  params p0_
WHERE
  (
    (
      p0_.params_enabled = 1
      AND p0_.app_enabled = 1
    )
    AND (
      p0_.params_value <> p0_.params_default_value
      OR p0_.params_default_value IS NULL
    )
  )

SELECT p0_.params_id AS params_id_0, p0_.params_short_name AS params_short_name_1, p0_.params_name AS params_name_2, p0_.params_desc AS params_desc_3, p0_.params_logo AS params_logo_4, p0_.params_enabled AS params_enabled_5, p0_.params_field_type AS params_field_type_6, p0_.params_field_length AS params_field_length_7, p0_.params_field_required AS params_field_required_8, p0_.params_field_validator AS params_field_validator_9, p0_.params_value AS params_value_10, p0_.params_updated_at AS params_updated_at_11, p0_.params_updated_by AS params_updated_by_12, p0_.app_enabled AS app_enabled_13, p0_.params_form_field_type AS params_form_field_type_14, p0_.params_order AS params_order_15, p0_.params_dict AS params_dict_16, p0_.params_default_value AS params_default_value_17, p0_.params_visibility AS params_visibility_18, p0_.status AS status_19, p0_.params_group_id AS params_group_id_20 FROM params p0_ WHERE ((p0_.params_enabled = 1 AND p0_.app_enabled = 1) AND (p0_.params_value <> p0_.params_default_value OR p0_.params_default_value IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\Config\ParamsRepository->findForAppConfig (line 54)
8	App\Service\ConfigService->{closure:App\Service\ConfigService::mobileConfig():51} (line 72)
9	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
15	App\Util\Api\AbstractService->_cacheRebuild (line 45)
16	App\Util\Api\AbstractService->withCache (line 51)
17	App\Service\ConfigService->mobileConfig (line 29)
18	App\Controller\Api\ConfigController->{closure:App\Controller\Api\ConfigController::mobileConfig():28} (line 255)
19	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
20	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 28)
21	App\Controller\Api\ConfigController->mobileConfig (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 50)

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\Config\Params	49
App\Entity\Config\ParamsGroup	9
App\Entity\Integration\OutsideSystem	1

Entities Mapping

Class	Mapping errors
App\Entity\Integration\OutsideSystem	No errors.
App\Entity\Enums\OutsideSystemServiceStatus	No errors.
App\Entity\Integration\OutsideSystemService	No errors.
App\Entity\Integration\UserToOutsideSystem	No errors.
App\Entity\Widget	No errors.
App\Entity\Category\Category	No errors.
App\Entity\Enums\ParamsStatus	No errors.
App\Entity\Config\Params	No errors.
App\Entity\Config\ParamsGroup	No errors.

Symfony Profiler

GET https://apka.adamow.gmina.pl/api/app/config?checksum=6a02314b

Configuration Settings

Theme

Page Width