Symfony Profiler

Query Metrics

15 Database Queries

5 Different statements

11.53 ms Query time

1 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

dplan connection

Time▼

Count

Info

8.96 ms
(77.68%)

SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_subdomain = ? LIMIT 1

Parameters:

[
  "blp-dev-debug"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._c_id AS _c_id_1,
  t0.imprint AS imprint_2,
  t0.data_protection AS data_protection_3,
  t0.terms_of_use AS terms_of_use_4,
  t0.xplanning AS xplanning_5,
  t0.map_attribution AS map_attribution_6,
  t0.base_layer_url AS base_layer_url_7,
  t0.base_layer_layers AS base_layer_layers_8,
  t0.accessibility_explanation AS accessibility_explanation_9,
  t0.sign_language_overview_description AS sign_language_overview_description_10,
  t0.simple_language_overview_description AS simple_language_overview_description_11,
  t0._c_name AS _c_name_12,
  t0._c_subdomain AS _c_subdomain_13,
  t0._procedure AS _procedure_14,
  t0.branding_id AS branding_id_15
FROM
  customer t0
WHERE
  t0._c_subdomain = ?
LIMIT
  1

SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_subdomain = 'blp-dev-debug' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	demosplan\DemosPlanCoreBundle\Repository\CustomerRepository->findCustomerBySubdomain (line 42)
7	demosplan\DemosPlanCoreBundle\Services\SubdomainHandler->getSubdomain (line 40)
8	demosplan\DemosPlanCoreBundle\Services\SubdomainHandler->setSubdomainParameter (line 30)
9	demosplan\DemosPlanCoreBundle\EventListener\SubdomainEventSubscriber->handle (line 39)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 208)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 13)

0.83 ms
(7.16%)

SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? LIMIT 1

Parameters:

[
  "fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_._c_id AS _c_id_0,
  c0_.imprint AS imprint_1,
  c0_.data_protection AS data_protection_2,
  c0_.terms_of_use AS terms_of_use_3,
  c0_.xplanning AS xplanning_4,
  c0_.map_attribution AS map_attribution_5,
  c0_.base_layer_url AS base_layer_url_6,
  c0_.base_layer_layers AS base_layer_layers_7,
  c0_.accessibility_explanation AS accessibility_explanation_8,
  c0_.sign_language_overview_description AS sign_language_overview_description_9,
  c0_.simple_language_overview_description AS simple_language_overview_description_10,
  c0_._c_name AS _c_name_11,
  c0_._c_subdomain AS _c_subdomain_12,
  c0_._procedure AS _procedure_13,
  c0_.branding_id AS branding_id_14
FROM
  customer c0_
WHERE
  c0_._c_id = ?
LIMIT
  1

SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = 'fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	EDT\DqlQuerying\ObjectProviders\DoctrineOrmEntityProvider->getEntities (line 50)
9	demosplan\DemosPlanCoreBundle\Logic\ApiRequest\EntityFetcher->listEntitiesUnrestricted (line 86)
10	demosplan\DemosPlanCoreBundle\Permissions\PermissionResolver->evaluate (line 163)
11	demosplan\DemosPlanCoreBundle\Permissions\PermissionResolver->isPermissionEnabled (line 121)
12	demosplan\DemosPlanCoreBundle\Permissions\Permissions->isResolvablePermissionEnabled (line 1249)
13	demosplan\DemosPlanCoreBundle\Permissions\Permissions->isPermissionEnabled (line 1064)
14	demosplan\DemosPlanCoreBundle\Logic\DefaultTwigVariablesService->{closure:demosplan\DemosPlanCoreBundle\Logic\DefaultTwigVariablesService::extractExposedPermissions():76} (line 79)
15	array_filter (line 911)
16	Illuminate\Support\Arr::where (line 911)
17	Illuminate\Support\Collection::filter (line 388)
18	demosplan\DemosPlanCoreBundle\Logic\DefaultTwigVariablesService->extractExposedPermissions (line 75)
19	demosplan\DemosPlanCoreBundle\Logic\DefaultTwigVariablesService->loadVariables (line 110)
20	demosplan\DemosPlanCoreBundle\Logic\ViewRenderer->processRequestParameters (line 51)
21	demosplan\DemosPlanCoreBundle\Controller\Base\BaseController->render (line 278)
22	demosplan\DemosPlanCoreBundle\Controller\Platform\HttpErrorController->custom404 (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 13)

0.67 ms
(5.80%)

SELECT t0_._r_id AS _r_id_0, t0_._r_code AS _r_code_1, t0_._r_group_code AS _r_group_code_2, t0_._r_group_name AS _r_group_name_3 FROM _role t0_ WHERE t0_._r_code IN (?)

Parameters:

[
  "RGUEST"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_._r_id AS _r_id_0,
  t0_._r_code AS _r_code_1,
  t0_._r_group_code AS _r_group_code_2,
  t0_._r_group_name AS _r_group_name_3
FROM
  _role t0_
WHERE
  t0_._r_code IN (?)

SELECT t0_._r_id AS _r_id_0, t0_._r_code AS _r_code_1, t0_._r_group_code AS _r_group_code_2, t0_._r_group_name AS _r_group_name_3 FROM _role t0_ WHERE t0_._r_code IN ('RGUEST');

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	demosplan\DemosPlanCoreBundle\Repository\RoleRepository->getUserRolesByCodes (line 70)
9	demosplan\DemosPlanCoreBundle\Logic\User\RoleService->getUserRolesByCodes (line 63)
10	demosplan\DemosPlanCoreBundle\Logic\User\RoleHandler->getUserRolesByCodes (line 64)
11	demosplan\DemosPlanCoreBundle\Logic\User\RoleHandler->getRoleByCode (line 79)
12	demosplan\DemosPlanCoreBundle\Logic\Permission\AccessControlService->getPermissions (line 90)
13	demosplan\DemosPlanCoreBundle\Permissions\Permissions->loadDynamicPermissions (line 160)
14	demosplan\DemosPlanCoreBundle\Permissions\Permissions->initPermissions (line 152)
15	demosplan\DemosPlanCoreBundle\Permissions\ProjectPermissions->initPermissions (line 22)
16	demosplan\DemosPlanCoreBundle\EventListener\ConfigurePermissionsListener->onKernelController (line 31)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 13)

0.66 ms
(5.73%)

SELECT t0.id AS id_1, t0.permission AS permission_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.orga_id AS orga_id_5, t0.role_id AS role_id_6, t0.customer_id AS customer_id_7 FROM access_control t0 WHERE t0.role_id IN (?) AND t0.orga_id IN (?) AND t0.customer_id IN (?)

Parameters:

[
  "71a2ebbc-0968-11e1-9d8e-1c64a3042bca"
  "cdec5e4b-3f06-11e4-a6a8-005056ae0004"
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.permission AS permission_2,
  t0.creation_date AS creation_date_3,
  t0.modification_date AS modification_date_4,
  t0.orga_id AS orga_id_5,
  t0.role_id AS role_id_6,
  t0.customer_id AS customer_id_7
FROM
  access_control t0
WHERE
  t0.role_id IN (?)
  AND t0.orga_id IN (?)
  AND t0.customer_id IN (?)

SELECT t0.id AS id_1, t0.permission AS permission_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.orga_id AS orga_id_5, t0.role_id AS role_id_6, t0.customer_id AS customer_id_7 FROM access_control t0 WHERE t0.role_id IN ('71a2ebbc-0968-11e1-9d8e-1c64a3042bca') AND t0.orga_id IN ('cdec5e4b-3f06-11e4-a6a8-005056ae0004') AND t0.customer_id IN (NULL);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
4	Doctrine\ORM\EntityRepository->findBy (line 110)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
6	demosplan\DemosPlanCoreBundle\Logic\Permission\AccessControlService->getEnabledPermissionNames (line 128)
7	demosplan\DemosPlanCoreBundle\Logic\Permission\AccessControlService->getPermissions (line 96)
8	demosplan\DemosPlanCoreBundle\Permissions\Permissions->loadDynamicPermissions (line 160)
9	demosplan\DemosPlanCoreBundle\Permissions\Permissions->initPermissions (line 152)
10	demosplan\DemosPlanCoreBundle\Permissions\ProjectPermissions->initPermissions (line 22)
11	demosplan\DemosPlanCoreBundle\EventListener\ConfigurePermissionsListener->onKernelController (line 31)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 13)

0.42 ms
(3.62%)

SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ?

Parameters:

[
  "e9af459e-7486-11ec-92ee-b026282c0641"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cssvars AS cssvars_2,
  t0.logo AS logo_3
FROM
  branding t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = 'e9af459e-7486-11ec-92ee-b026282c0641';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
6	Proxies\__CG__\demosplan\DemosPlanCoreBundle\Entity\Branding::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
8	Proxies\__CG__\demosplan\DemosPlanCoreBundle\Entity\Branding->__get (line 184)
9	demosplan\DemosPlanCoreBundle\Entity\Branding->getCssvars (line 58)
10	demosplan\DemosPlanCoreBundle\Logic\BrandingProvider->generateFullCss (line 48)
11	demosplan\DemosPlanCoreBundle\Services\BrandingLoader->setCustomerBranding (line 77)
12	demosplan\DemosPlanCoreBundle\Services\BrandingLoader->getBrandingObject (line 45)
13	demosplan\DemosPlanCoreBundle\Logic\DefaultTwigVariablesService->loadVariables (line 129)
14	demosplan\DemosPlanCoreBundle\Logic\ViewRenderer->processRequestParameters (line 51)
15	demosplan\DemosPlanCoreBundle\Controller\Base\BaseController->render (line 278)
16	demosplan\DemosPlanCoreBundle\Controller\Platform\HttpErrorController->custom404 (line 33)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 13)

Database Connections

Name	Service
dplan	doctrine.dbal.dplan_connection
dplan_install	doctrine.dbal.dplan_install_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
install	doctrine.orm.install_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
demosplan\DemosPlanCoreBundle\Entity\User\Role	1
demosplan\DemosPlanCoreBundle\Entity\User\Customer	1
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure	1
demosplan\DemosPlanCoreBundle\Entity\Branding	1

install entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
demosplan\DemosPlanCoreBundle\Entity\SluggedEntity	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\UserAccessControl	No errors.
DemosEurope\DemosplanAddon\DemosPipes\Entity\PdfImport\AnnotatedStatementPdf	The target entity 'DemosEurope\DemosplanAddon\Contracts\Entities\ProcedureInterface' specified on DemosEurope\DemosplanAddon\DemosPipes\Entity\PdfImport\AnnotatedStatementPdf#procedure is unknown or not an entity.
demosplan\DemosPlanCoreBundle\Entity\User\Customer	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Orga	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\User	No errors.
demosplan\DemosPlanCoreBundle\Entity\Branding	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OAuthToken	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerOAuthConfig	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Role	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerCounty	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaStatusInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Video	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\SupportContact	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTagCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\File	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedurePhaseDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Statement	No errors.

install entity manager

No loaded entities.

Symfony Profiler

GET http://blp-dev-debug.demos-europe.eu/notfound?currentPage=%2Fsitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

dplan connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

install entity manager

Entities Mapping

default entity manager

install entity manager