Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.14 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.26 ms
(58.61%)

SELECT t0.id AS id_1, t0.menu_parent AS menu_parent_2, t0.menu_type AS menu_type_3, t0.menu_module AS menu_module_4, t0.menu_url AS menu_url_5, t0.menu_config AS menu_config_6, t0.menu_icon_name AS menu_icon_name_7, t0.menu_icon_pkg AS menu_icon_pkg_8, t0.menu_title AS menu_title_9, t0.menu_name AS menu_name_10, t0.menu_desc AS menu_desc_11, t0.menu_caption AS menu_caption_12, t0.menu_html AS menu_html_13, t0.menu_form AS menu_form_14, t0.menu_enabled AS menu_enabled_15, t0.menu_sort AS menu_sort_16 FROM menu t0 WHERE t0.id = ? AND t0.menu_enabled = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.menu_parent AS menu_parent_2,
  t0.menu_type AS menu_type_3,
  t0.menu_module AS menu_module_4,
  t0.menu_url AS menu_url_5,
  t0.menu_config AS menu_config_6,
  t0.menu_icon_name AS menu_icon_name_7,
  t0.menu_icon_pkg AS menu_icon_pkg_8,
  t0.menu_title AS menu_title_9,
  t0.menu_name AS menu_name_10,
  t0.menu_desc AS menu_desc_11,
  t0.menu_caption AS menu_caption_12,
  t0.menu_html AS menu_html_13,
  t0.menu_form AS menu_form_14,
  t0.menu_enabled AS menu_enabled_15,
  t0.menu_sort AS menu_sort_16
FROM
  menu t0
WHERE
  t0.id = ?
  AND t0.menu_enabled = ?

SELECT t0.id AS id_1, t0.menu_parent AS menu_parent_2, t0.menu_type AS menu_type_3, t0.menu_module AS menu_module_4, t0.menu_url AS menu_url_5, t0.menu_config AS menu_config_6, t0.menu_icon_name AS menu_icon_name_7, t0.menu_icon_pkg AS menu_icon_pkg_8, t0.menu_title AS menu_title_9, t0.menu_name AS menu_name_10, t0.menu_desc AS menu_desc_11, t0.menu_caption AS menu_caption_12, t0.menu_html AS menu_html_13, t0.menu_form AS menu_form_14, t0.menu_enabled AS menu_enabled_15, t0.menu_sort AS menu_sort_16 FROM menu t0 WHERE t0.id = 0 AND t0.menu_enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 94)
4	App\Service\ConfigService->{closure:App\Service\ConfigService::getNavigation():91} (line 72)
5	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
6	Symfony\Component\Cache\LockRegistry::compute (line 102)
7	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
8	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
11	App\Util\Api\AbstractService->_cacheRebuild (line 45)
12	App\Util\Api\AbstractService->withCache (line 91)
13	App\Service\ConfigService->getNavigation (line 57)
14	App\Controller\Api\ConfigController->{closure:App\Controller\Api\ConfigController::menu():56} (line 255)
15	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
16	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 56)
17	App\Controller\Api\ConfigController->menu (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 50)

0.49 ms
(22.86%)

SELECT t0.id AS id_1, t0.menu_parent AS menu_parent_2, t0.menu_type AS menu_type_3, t0.menu_module AS menu_module_4, t0.menu_url AS menu_url_5, t0.menu_config AS menu_config_6, t0.menu_icon_name AS menu_icon_name_7, t0.menu_icon_pkg AS menu_icon_pkg_8, t0.menu_title AS menu_title_9, t0.menu_name AS menu_name_10, t0.menu_desc AS menu_desc_11, t0.menu_caption AS menu_caption_12, t0.menu_html AS menu_html_13, t0.menu_form AS menu_form_14, t0.menu_enabled AS menu_enabled_15, t0.menu_sort AS menu_sort_16 FROM menu t0 WHERE t0.menu_parent = ? AND t0.menu_enabled = ? ORDER BY t0.menu_sort ASC, t0.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.menu_parent AS menu_parent_2,
  t0.menu_type AS menu_type_3,
  t0.menu_module AS menu_module_4,
  t0.menu_url AS menu_url_5,
  t0.menu_config AS menu_config_6,
  t0.menu_icon_name AS menu_icon_name_7,
  t0.menu_icon_pkg AS menu_icon_pkg_8,
  t0.menu_title AS menu_title_9,
  t0.menu_name AS menu_name_10,
  t0.menu_desc AS menu_desc_11,
  t0.menu_caption AS menu_caption_12,
  t0.menu_html AS menu_html_13,
  t0.menu_form AS menu_form_14,
  t0.menu_enabled AS menu_enabled_15,
  t0.menu_sort AS menu_sort_16
FROM
  menu t0
WHERE
  t0.menu_parent = ?
  AND t0.menu_enabled = ?
ORDER BY
  t0.menu_sort ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.menu_parent AS menu_parent_2, t0.menu_type AS menu_type_3, t0.menu_module AS menu_module_4, t0.menu_url AS menu_url_5, t0.menu_config AS menu_config_6, t0.menu_icon_name AS menu_icon_name_7, t0.menu_icon_pkg AS menu_icon_pkg_8, t0.menu_title AS menu_title_9, t0.menu_name AS menu_name_10, t0.menu_desc AS menu_desc_11, t0.menu_caption AS menu_caption_12, t0.menu_html AS menu_html_13, t0.menu_form AS menu_form_14, t0.menu_enabled AS menu_enabled_15, t0.menu_sort AS menu_sort_16 FROM menu t0 WHERE t0.menu_parent = 0 AND t0.menu_enabled = 1 ORDER BY t0.menu_sort ASC, t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	App\Service\ConfigService->{closure:App\Service\ConfigService::getNavigation():91} (line 72)
5	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
6	Symfony\Component\Cache\LockRegistry::compute (line 102)
7	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
8	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
11	App\Util\Api\AbstractService->_cacheRebuild (line 45)
12	App\Util\Api\AbstractService->withCache (line 91)
13	App\Service\ConfigService->getNavigation (line 57)
14	App\Controller\Api\ConfigController->{closure:App\Controller\Api\ConfigController::menu():56} (line 255)
15	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
16	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 56)
17	App\Controller\Api\ConfigController->menu (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 50)

0.40 ms
(18.52%)

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)

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\Menu	6
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\Config\Menu	No errors.

Symfony Profiler

GET https://apka.adamow.gmina.pl/api/app/menu/0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping