Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.07 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

dplan connection

#▲

Time

Info

0.48 ms

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:

[
  "diplanbau-dev-debug-docker"
]

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 = 'diplanbau-dev-debug-docker' 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.59 ms

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.37 ms

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)

3.63 ms

SELECT t0._f_id AS _f_id_1, t0._f_ident AS _f_ident_2, t0._f_hash AS _f_hash_3, t0._f_name AS _f_name_4, t0._f_description AS _f_description_5, t0._f_path AS _f_path_6, t0._f_filename AS _f_filename_7, t0._f_tags AS _f_tags_8, t0._f_author AS _f_author_9, t0._f_application AS _f_application_10, t0._f_mimetype AS _f_mimetype_11, t0._f_created AS _f_created_12, t0._f_modified AS _f_modified_13, t0._f_valid_until AS _f_valid_until_14, t0._f_deleted AS _f_deleted_15, t0._f_stat_down AS _f_stat_down_16, t0._f_infected AS _f_infected_17, t0._f_last_v_scan AS _f_last_v_scan_18, t0._f_blocked AS _f_blocked_19, t0.size AS size_20, t0.procedure_id AS procedure_id_21 FROM _files t0 WHERE t0._f_ident = ? AND t0._f_deleted = ? LIMIT 1

Parameters:

[
  "d4257220-9c45-4dfd-82b2-2a93817e5323"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0._f_id AS _f_id_1,
  t0._f_ident AS _f_ident_2,
  t0._f_hash AS _f_hash_3,
  t0._f_name AS _f_name_4,
  t0._f_description AS _f_description_5,
  t0._f_path AS _f_path_6,
  t0._f_filename AS _f_filename_7,
  t0._f_tags AS _f_tags_8,
  t0._f_author AS _f_author_9,
  t0._f_application AS _f_application_10,
  t0._f_mimetype AS _f_mimetype_11,
  t0._f_created AS _f_created_12,
  t0._f_modified AS _f_modified_13,
  t0._f_valid_until AS _f_valid_until_14,
  t0._f_deleted AS _f_deleted_15,
  t0._f_stat_down AS _f_stat_down_16,
  t0._f_infected AS _f_infected_17,
  t0._f_last_v_scan AS _f_last_v_scan_18,
  t0._f_blocked AS _f_blocked_19,
  t0.size AS size_20,
  t0.procedure_id AS procedure_id_21
FROM
  _files t0
WHERE
  t0._f_ident = ?
  AND t0._f_deleted = ?
LIMIT
  1

SELECT t0._f_id AS _f_id_1, t0._f_ident AS _f_ident_2, t0._f_hash AS _f_hash_3, t0._f_name AS _f_name_4, t0._f_description AS _f_description_5, t0._f_path AS _f_path_6, t0._f_filename AS _f_filename_7, t0._f_tags AS _f_tags_8, t0._f_author AS _f_author_9, t0._f_application AS _f_application_10, t0._f_mimetype AS _f_mimetype_11, t0._f_created AS _f_created_12, t0._f_modified AS _f_modified_13, t0._f_valid_until AS _f_valid_until_14, t0._f_deleted AS _f_deleted_15, t0._f_stat_down AS _f_stat_down_16, t0._f_infected AS _f_infected_17, t0._f_last_v_scan AS _f_last_v_scan_18, t0._f_blocked AS _f_blocked_19, t0.size AS size_20, t0.procedure_id AS procedure_id_21 FROM _files t0 WHERE t0._f_ident = 'd4257220-9c45-4dfd-82b2-2a93817e5323' AND t0._f_deleted = 0 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\FileRepository->getFile (line 39)
7	demosplan\DemosPlanCoreBundle\Logic\FileService->getFileInfo (line 118)
8	demosplan\DemosPlanCoreBundle\Controller\Platform\FileController->prepareResponseWithHash (line 88)
9	demosplan\DemosPlanCoreBundle\Controller\Platform\FileController->fileHash (line 45)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\File	1

install entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Customer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\UserAccessControl	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\Department	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Role	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaType	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\FileContainer	No errors.
demosplan\DemosPlanCoreBundle\Entity\File	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocument	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://diplanbau-dev-debug-docker.demos-europe.eu/file/d4257220-9c45-4dfd-82b2-2a93817e5323

Configuration Settings

Theme

Page Width

Query Metrics

Queries

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