Symfony Profiler

Query Metrics

48 Database Queries

5 Different statements

6.84 ms Query time

3 Invalid entities

99 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.52 ms
(36.77%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.category AS category_3,
  t0.category_param AS category_param_4
FROM
  category_values t0
WHERE
  t0.category = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 535)
9	Doctrine\ORM\PersistentCollection->isEmpty (line 185)
10	App\Service\CategoryService->getCategoryValues (line 164)
11	App\Service\CategoryService->{closure:App\Service\CategoryService::getCategoriesForApi():149} (line 72)
12	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
13	Symfony\Component\Cache\LockRegistry::compute (line 102)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
17	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
18	App\Util\Api\AbstractService->_cacheRebuild (line 45)
19	App\Util\Api\AbstractService->withCache (line 149)
20	App\Service\CategoryService->getCategoriesForApi (line 28)
21	App\Controller\Api\CategoryController->{closure:App\Controller\Api\CategoryController::index():26} (line 255)
22	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
23	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 26)
24	App\Controller\Api\CategoryController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 50)

2.07 ms
(30.28%)

SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?

Parameters:

[
  1
  "mainphoto"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  te.file_id AS file_id,
  te.fid AS fid,
  te.file_type AS file_type,
  te.file_name AS file_name,
  te.file_label AS file_label,
  te.file_desc AS file_desc,
  te.file_size AS file_size,
  te.file_ext AS file_ext,
  te.file_link AS file_link,
  te.file_created_at AS file_created_at,
  te.file_tmp_status AS file_tmp_status,
  te.file_width AS file_width,
  te.file_height AS file_height,
  te.file_blurhash AS file_blurhash,
  te.file_mime_type AS file_mime_type,
  te.file_original_name AS file_original_name
FROM
  file te
  JOIN category_to_file t ON t.file_id = te.file_id
WHERE
  t.category_id = ?
  AND te.file_type = ?

SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = 1 AND te.file_type = 'mainphoto';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 282)
2	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->loadCriteria (line 662)
3	Doctrine\ORM\PersistentCollection->matching (line 525)
4	App\Entity\Category\Category->getMainphotos (line 226)
5	App\Service\CategoryService->getCategoryMainPhoto (line 169)
6	App\Service\CategoryService->{closure:App\Service\CategoryService::getCategoriesForApi():149} (line 72)
7	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
13	App\Util\Api\AbstractService->_cacheRebuild (line 45)
14	App\Util\Api\AbstractService->withCache (line 149)
15	App\Service\CategoryService->getCategoriesForApi (line 28)
16	App\Controller\Api\CategoryController->{closure:App\Controller\Api\CategoryController::index():26} (line 255)
17	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
18	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 26)
19	App\Controller\Api\CategoryController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 50)

1.68 ms
(24.50%)

SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category_type AS category_type_2,
  t0.short_name AS short_name_3,
  t0.label AS label_4,
  t0.field_type AS field_type_5,
  t0.form_field_type AS form_field_type_6,
  t0.form_field_required AS form_field_required_7,
  t0.dict AS dict_8
FROM
  category_params t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\Category\CategoryParams::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Category\CategoryParams->__get (line 59)
8	App\Entity\Category\CategoryParams->getShortName (line 187)
9	App\Service\CategoryService->getCategoryValues (line 164)
10	App\Service\CategoryService->{closure:App\Service\CategoryService::getCategoriesForApi():149} (line 72)
11	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 102)
13	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
14	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
15	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
16	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
17	App\Util\Api\AbstractService->_cacheRebuild (line 45)
18	App\Util\Api\AbstractService->withCache (line 149)
19	App\Service\CategoryService->getCategoriesForApi (line 28)
20	App\Controller\Api\CategoryController->{closure:App\Controller\Api\CategoryController::index():26} (line 255)
21	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
22	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 26)
23	App\Controller\Api\CategoryController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 50)

0.30 ms
(4.40%)

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)

0.28 ms
(4.05%)

SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_desc AS category_desc_3, t0.category_type AS category_type_4, t0.category_theme AS category_theme_5, t0.category_priority AS category_priority_6, t0.category_option AS category_option_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_email_notification AS category_email_notification_10, t0.created_by AS created_by_11, t0.outside_system_created_by_id AS outside_system_created_by_id_12 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.category_id AS category_id_1,
  t0.category_name AS category_name_2,
  t0.category_desc AS category_desc_3,
  t0.category_type AS category_type_4,
  t0.category_theme AS category_theme_5,
  t0.category_priority AS category_priority_6,
  t0.category_option AS category_option_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.category_email_notification AS category_email_notification_10,
  t0.created_by AS created_by_11,
  t0.outside_system_created_by_id AS outside_system_created_by_id_12
FROM
  category t0

SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_desc AS category_desc_3, t0.category_type AS category_type_4, t0.category_theme AS category_theme_5, t0.category_priority AS category_priority_6, t0.category_option AS category_option_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_email_notification AS category_email_notification_10, t0.created_by AS created_by_11, t0.outside_system_created_by_id AS outside_system_created_by_id_12 FROM category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 154)
5	App\Service\CategoryService->{closure:App\Service\CategoryService::getCategoriesForApi():149} (line 72)
6	App\Util\Api\AbstractService->{closure:App\Util\AppCache::_cacheRebuild():69} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\TagAwareAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
9	Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet (line 85)
10	Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\TagAwareAdapter->get (line 69)
12	App\Util\Api\AbstractService->_cacheRebuild (line 45)
13	App\Util\Api\AbstractService->withCache (line 149)
14	App\Service\CategoryService->getCategoriesForApi (line 28)
15	App\Controller\Api\CategoryController->{closure:App\Controller\Api\CategoryController::index():26} (line 255)
16	App\Util\Api\AbstractApiController->prepareAPIRequest (line 317)
17	App\Util\Api\AbstractApiController->prepareAPIRequestNAC (line 26)
18	App\Controller\Api\CategoryController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Category\CategoryValues	68
App\Entity\Category\Category	16
App\Entity\Category\CategoryParams	14
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\UserStatus	No errors.
App\Entity\User\User	The association App\Entity\User\User#queuePushes refers to the owning side field App\Entity\Queue\QueuePush#user which does not exist. The mappings App\Entity\User\User#visitSchedulerReservationsAppended and App\Entity\VisitScheduler\VisitSchedulerReservation#appendedTo are inconsistent with each other.
App\Entity\Enums\ContentStatus	No errors.
App\Entity\Content\Content	No errors.
App\Entity\User\UserMobDeviceToCategory	No errors.
App\Entity\Notice	No errors.
App\Entity\File	No errors.
App\Entity\Partner\PartnerAddress	The association App\Entity\Partner\PartnerAddress#itemLimits refers to the owning side field App\Entity\Card\CardItemLimit#partnerAddresses which does not exist.
App\Entity\Category\CategoryValues	No errors.
App\Entity\Enums\PartnerStatus	No errors.
App\Entity\Partner\Partner	No errors.
App\Entity\Enums\SiteStatus	No errors.
App\Entity\Site\Site	The association App\Entity\Site\Site#parent refers to the inverse side field App\Entity\Site\Site#children which does not exist.
App\Entity\Category\CategoryParams	No errors.

Symfony Profiler

GET https://apka.adamow.gmina.pl/api/category?extended=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping