Symfony Profiler

Query Metrics

21 Database Queries

7 Different statements

33.62 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

dplan connection

Time▼

Count

Info

23.66 ms
(70.38%)

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)

3.77 ms
(11.21%)

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:

[
  "8e4172c6-ada2-3352-a3ec-f585a3969933"
]

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 = '8e4172c6-ada2-3352-a3ec-f585a3969933' 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\MiscContent\DemosPlanMiscContentController->dataProtection (line 146)
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)

1.92 ms
(5.72%)

SELECT t0_._o_id AS sclr_0, t0_._o_name AS sclr_1, t0_.data_protection AS sclr_2 FROM _orga t0_ LEFT JOIN relation_customer_orga_orga_type r1_ ON t0_._o_id = r1_._o_id LEFT JOIN _orga_type t2_ ON r1_._ot_id = t2_._ot_id WHERE t2_._ot_name = ? AND t0_._o_deleted = ? AND r1_.status = ? AND r1_._c_id = ? AND t0_.data_protection <> ? ORDER BY t0_._o_name ASC

Parameters:

[
  "OLAUTH"
  0
  "accepted"
  "8e4172c6-ada2-3352-a3ec-f585a3969933"
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_._o_id AS sclr_0,
  t0_._o_name AS sclr_1,
  t0_.data_protection AS sclr_2
FROM
  _orga t0_
  LEFT JOIN relation_customer_orga_orga_type r1_ ON t0_._o_id = r1_._o_id
  LEFT JOIN _orga_type t2_ ON r1_._ot_id = t2_._ot_id
WHERE
  t2_._ot_name = ?
  AND t0_._o_deleted = ?
  AND r1_.status = ?
  AND r1_._c_id = ?
  AND t0_.data_protection <> ?
ORDER BY
  t0_._o_name ASC

SELECT t0_._o_id AS sclr_0, t0_._o_name AS sclr_1, t0_.data_protection AS sclr_2 FROM _orga t0_ LEFT JOIN relation_customer_orga_orga_type r1_ ON t0_._o_id = r1_._o_id LEFT JOIN _orga_type t2_ ON r1_._ot_id = t2_._ot_id WHERE t2_._ot_name = 'OLAUTH' AND t0_._o_deleted = 0 AND r1_.status = 'accepted' AND r1_._c_id = '8e4172c6-ada2-3352-a3ec-f585a3969933' AND t0_.data_protection <> '' ORDER BY t0_._o_name ASC;

#	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\OrgaRepository->getDataProtectionMunicipalities (line 520)
9	demosplan\DemosPlanCoreBundle\Logic\User\OrgaService->getDataProtectionMunicipalities (line 135)
10	demosplan\DemosPlanCoreBundle\Logic\User\OrgaHandler->getDataProtectionMunicipalities (line 43)
11	demosplan\DemosPlanCoreBundle\Controller\MiscContent\DemosPlanMiscContentController->dataProtection (line 144)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 208)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 13)

1.85 ms
(5.51%)

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

Parameters:

[
  "c2c5ce48-8af4-4887-aaea-bd5702496a9f"
]

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 = 'c2c5ce48-8af4-4887-aaea-bd5702496a9f';

#	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\MiscContent\DemosPlanMiscContentController->dataProtection (line 146)
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)

1.21 ms
(3.60%)

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 = ?

Parameters:

[
  "d5badb1f-4690-4ac9-a8f6-de016909ef8b"
]

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 = ?

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 = 'd5badb1f-4690-4ac9-a8f6-de016909ef8b';

#	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\File::{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\File->__get (line 184)
9	demosplan\DemosPlanCoreBundle\Entity\File->getHash (line 240)
10	Twig\Extension\CoreExtension->getAttribute (line 1928)
11	__TwigTemplate_9a4bc91f2d3715dcdbfc976565f84120::block_header_logo_left (line 340)
12	Twig\Template->yieldBlock (line 458)
13	__TwigTemplate_9a4bc91f2d3715dcdbfc976565f84120->{closure:__TwigTemplate_9a4bc91f2d3715dcdbfc976565f84120::doDisplay():68} (line 99)
14	Twig\Extension\CoreExtension->captureOutput (line 2140)
15	__TwigTemplate_9a4bc91f2d3715dcdbfc976565f84120::doDisplay (line 68)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_934d40a7d863b5ae2cc299ec69dcda2f->doDisplay (line 56)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_6e2701c4db2c98c2c40e0432a0f975fb->block_header (line 551)
20	Twig\Template->yieldBlock (line 458)
21	__TwigTemplate_6e2701c4db2c98c2c40e0432a0f975fb->block_oeb (line 501)
22	Twig\Template->yieldBlock (line 458)
23	__TwigTemplate_6e2701c4db2c98c2c40e0432a0f975fb->doDisplay (line 150)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_f1cb6adbb036d0b325a7a91e4948657a->doDisplay (line 57)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_9193419070d551a650f1dac850d29881->doDisplay (line 83)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_7fadc707c4c767a4979599fb98001f4f->doDisplay (line 58)
30	Twig\Template->yield (line 411)
31	Twig\Template->display (line 366)
32	Twig\Template->render (line 381)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
38	demosplan\DemosPlanCoreBundle\Controller\Base\BaseController->render (line 280)
39	demosplan\DemosPlanCoreBundle\Controller\MiscContent\DemosPlanMiscContentController->dataProtection (line 146)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 208)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 29)
45	require_once (line 13)

0.60 ms
(1.79%)

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 124)
7	demosplan\DemosPlanCoreBundle\Logic\Permission\AccessControlService->getPermissions (line 92)
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.60 ms
(1.78%)

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 86)
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)

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
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\UserAccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl	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\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\Procedure\ProcedurePhaseDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\CustomFields\CustomFieldConfiguration	No errors.
demosplan\DemosPlanCoreBundle\Entity\EmailAddress	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Statement	No errors.
demosplan\DemosPlanCoreBundle\Entity\ManualListSort	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTag	No errors.
demosplan\DemosPlanCoreBundle\Entity\FileContainer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Workflow\Place	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\SegmentComment	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\ConsultationToken	No errors.
demosplan\DemosPlanCoreBundle\Entity\StatementAttachment	No errors.
demosplan\DemosPlanCoreBundle\Entity\EntitySyncLink	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\ParagraphVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocumentVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\Paragraph	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Tag	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\TagTopic	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementVote	No errors.
demosplan\DemosPlanCoreBundle\Entity\File	No errors.

install entity manager

No loaded entities.

Symfony Profiler

GET http://diplanbau-dev-debug-docker.demos-europe.eu/datenschutz

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