Symfony Profiler

Query Metrics

64 Database Queries

14 Different statements

10.10 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.63 ms
(16.10%)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)

Parameters:

[
  "00000000-0000-0000-0000-000000000000"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.uuid = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = '00000000-0000-0000-0000-000000000000') AND (rg.status = 1);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->loadRuleGroupData (line 193)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->loadRuleGroup (line 65)
7	Netgen\Layouts\Core\Service\LayoutResolverService->loadRuleGroup (line 107)
8	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 29)
9	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
10	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
11	Twig\Extension\CoreExtension->getAttribute (line 1919)
12	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
13	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
14	Twig\Template->getParent (line 83)
15	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
16	Twig\Template->yield (line 402)
17	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
23	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

1.55 ms
(15.35%)

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b.*,
  bt.*,
  l.uuid as layout_uuid
FROM
  nglayouts_block b
  INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id)
  AND (bt.status = b.status)
  INNER JOIN nglayouts_layout l ON (l.id = b.layout_id)
  AND (l.status = b.status)
WHERE
  (b.parent_id = ?)
  AND (b.status = ?)
ORDER BY
  b.placeholder ASC,
  b.position ASC

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = 8) AND (b.status = 1) ORDER BY b.placeholder ASC, b.position ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\BlockQueryHandler->loadChildBlocksData (line 124)
6	Netgen\Layouts\Persistence\Doctrine\Handler\BlockHandler->loadChildBlocks (line 70)
7	Netgen\Layouts\Core\Service\BlockService->loadZoneBlocks (line 106)
8	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 148)
9	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
14	Twig\Template->yield (line 402)
15	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
16	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
19	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
22	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
30	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

1.51 ms
(14.91%)

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC

Parameters:

[
  1
  1
  1
  "ibexa_location"
  1
  506
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = ?)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (rt.value = ?)
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'ibexa_location') AND (r.status = 1) AND (rt.value = 506) ORDER BY rd.priority DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->matchRules (line 178)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->matchRules (line 112)
7	Netgen\Layouts\Core\Service\LayoutResolverService->matchRules (line 264)
8	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveGroupRules (line 89)
9	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 57)
10	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
11	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
12	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
15	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
25	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

1.33 ms
(13.18%)

SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.layout_id = ?) AND (z.status = ?) ORDER BY z.identifier ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT z.*,
  l.uuid as layout_uuid
FROM
  nglayouts_zone z
  INNER JOIN nglayouts_layout l ON (l.id = z.layout_id)
  AND (l.status = z.status)
WHERE
  (z.layout_id = ?)
  AND (z.status = ?)
ORDER BY
  z.identifier ASC

SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.layout_id = 53) AND (z.status = 1) ORDER BY z.identifier ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutQueryHandler->loadLayoutZonesData (line 301)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutHandler->loadLayoutZones (line 124)
7	Netgen\Layouts\Core\Mapper\LayoutMapper->{closure:Netgen\Layouts\Core\Mapper\LayoutMapper::mapLayout():90} (line 92)
8	Netgen\Layouts\API\Values\LazyCollection->doInitialize (line 47)
9	Doctrine\Common\Collections\AbstractLazyCollection->initialize (line 402)
10	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
11	Netgen\Layouts\API\Values\Layout\Layout->$zones::get (line 70)
12	Netgen\Layouts\API\Values\Layout\Layout->getZone (line 88)
13	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 146)
14	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
19	Twig\Template->yield (line 402)
20	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
21	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
22	Twig\Template->yield (line 402)
23	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
24	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
25	Twig\Template->yield (line 402)
26	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
27	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
28	Twig\Template->yield (line 402)
29	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
35	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
36	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
37	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
38	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
39	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 5)

0.98 ms
(9.70%)

SELECT DISTINCT c.*, cr.rule_id, r.uuid AS rule_uuid FROM nglayouts_rule_condition c INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id) AND (cr.condition_status = c.status) INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id) AND (r.status = cr.rule_status) WHERE (cr.rule_id = ?) AND (c.status = ?) ORDER BY c.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c.*,
  cr.rule_id,
  r.uuid AS rule_uuid
FROM
  nglayouts_rule_condition c
  INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id)
  AND (cr.condition_status = c.status)
  INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id)
  AND (r.status = cr.rule_status)
WHERE
  (cr.rule_id = ?)
  AND (c.status = ?)
ORDER BY
  c.id ASC

SELECT DISTINCT c.*, cr.rule_id, r.uuid AS rule_uuid FROM nglayouts_rule_condition c INNER JOIN nglayouts_rule_condition_rule cr ON (cr.condition_id = c.id) AND (cr.condition_status = c.status) INNER JOIN nglayouts_rule r ON (r.id = cr.rule_id) AND (r.status = cr.rule_status) WHERE (cr.rule_id = 36) AND (c.status = 1) ORDER BY c.id ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->loadRuleConditionsData (line 330)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->loadRuleConditions (line 167)
7	Netgen\Layouts\Core\Mapper\LayoutResolverMapper->{closure:Netgen\Layouts\Core\Mapper\LayoutResolverMapper::mapRule():69} (line 71)
8	Netgen\Layouts\API\Values\LazyCollection->doInitialize (line 47)
9	Doctrine\Common\Collections\AbstractLazyCollection->initialize (line 402)
10	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
11	Netgen\Layouts\API\Values\LayoutResolver\Rule->$conditions::get (line 56)
12	Netgen\Layouts\Layout\Resolver\LayoutResolver->{closure:Netgen\Layouts\Layout\Resolver\LayoutResolver::resolveGroupRules():90} (line 91)
13	array_filter (line 380)
14	Doctrine\Common\Collections\ArrayCollection::filter (line 380)
15	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 241)
16	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveGroupRules (line 89)
17	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 57)
18	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
19	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
20	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
21	Twig\Extension\CoreExtension->getAttribute (line 1919)
22	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
23	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
24	Twig\Template->getParent (line 83)
25	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
26	Twig\Template->yield (line 402)
27	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
33	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
34	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
35	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
37	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 32)
43	require_once (line 5)

0.70 ms
(6.93%)

SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = ?) AND (l.uuid = ?) AND (l.status = ?)

Parameters:

[
  "header"
  "fd0aa7af-77a8-5a03-bf10-80018f5db1dc"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT z.*,
  l.uuid as layout_uuid
FROM
  nglayouts_zone z
  INNER JOIN nglayouts_layout l ON (l.id = z.layout_id)
  AND (l.status = z.status)
WHERE
  (z.identifier = ?)
  AND (l.uuid = ?)
  AND (l.status = ?)

SELECT DISTINCT z.*, l.uuid as layout_uuid FROM nglayouts_zone z INNER JOIN nglayouts_layout l ON (l.id = z.layout_id) AND (l.status = z.status) WHERE (z.identifier = 'header') AND (l.uuid = 'fd0aa7af-77a8-5a03-bf10-80018f5db1dc') AND (l.status = 1);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutQueryHandler->loadZoneData (line 282)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutHandler->loadZone (line 57)
7	Netgen\Layouts\Core\Mapper\LayoutMapper->{closure:Netgen\Layouts\Core\Mapper\LayoutMapper::mapZone():45} (line 52)
8	Netgen\Layouts\API\Values\Layout\Zone->{closure:{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34}:36} (line 36)
9	array_map (line 35)
10	Netgen\Layouts\API\Values\Layout\Zone::{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34} (line 35)
11	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime::renderZone (line 149)
12	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
19	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
22	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
25	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
26	Twig\Template->yield (line 402)
27	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
33	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
34	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
35	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
37	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 193)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 32)
43	require_once (line 5)

0.66 ms
(6.51%)

SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = ?) AND (bc.block_status = ?) ORDER BY bc.identifier ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c.*,
  ct.*,
  bc.*
FROM
  nglayouts_collection c
  INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id)
  AND (ct.status = c.status)
  INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id)
  AND (c.status = bc.collection_status)
WHERE
  (bc.block_id = ?)
  AND (bc.block_status = ?)
ORDER BY
  bc.identifier ASC

SELECT DISTINCT c.*, ct.*, bc.* FROM nglayouts_collection c INNER JOIN nglayouts_collection_translation ct ON (ct.collection_id = c.id) AND (ct.status = c.status) INNER JOIN nglayouts_block_collection bc ON (c.id = bc.collection_id) AND (c.status = bc.collection_status) WHERE (bc.block_id = 13) AND (bc.block_status = 1) ORDER BY bc.identifier ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\CollectionQueryHandler->loadBlockCollectionsData (line 61)
6	Netgen\Layouts\Persistence\Doctrine\Handler\CollectionHandler->loadCollections (line 64)
7	Netgen\Layouts\Core\Mapper\BlockMapper->{closure:Netgen\Layouts\Core\Mapper\BlockMapper::mapBlock():108} (line 110)
8	Netgen\Layouts\API\Values\LazyCollection->doInitialize (line 47)
9	Doctrine\Common\Collections\AbstractLazyCollection->initialize (line 402)
10	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
11	Netgen\Layouts\API\Values\Block\Block->$collections::get (line 85)
12	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 55)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
18	Netgen\Layouts\View\Renderer->renderValue (line 16)
19	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
20	__TwigTemplate_5b0e594fc8c46c7bc0302996497e771a->doDisplay (line 56)
21	Twig\Template->yield (line 402)
22	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
28	Netgen\Layouts\View\Renderer->renderValue (line 16)
29	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
30	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
31	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
36	Twig\Template->yield (line 402)
37	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
38	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
39	Twig\Template->yield (line 402)
40	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
41	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
42	Twig\Template->yield (line 402)
43	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
44	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
45	Twig\Template->yield (line 402)
46	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
52	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
53	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
54	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
55	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
56	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
57	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
58	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
59	Symfony\Component\HttpKernel\Kernel->handle (line 193)
60	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
61	require_once (line 32)
62	require_once (line 5)

0.36 ms
(3.58%)

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((LENGTH(TRIM(rt.value)) > ?) AND (? LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC

Parameters:

[
  1
  1
  1
  "ibexa_semantic_path_info_prefix"
  1
  0
  "/privacy-policy"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = ?)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (
    (
      LENGTH(
        TRIM(rt.value)
      ) > ?
    )
    AND (
      ? LIKE TRIM(rt.value) || '%'
    )
  )
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'ibexa_semantic_path_info_prefix') AND (r.status = 1) AND ((LENGTH(TRIM(rt.value)) > 0) AND ('/privacy-policy' LIKE TRIM(rt.value) || '%')) ORDER BY rd.priority DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->matchRules (line 178)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->matchRules (line 112)
7	Netgen\Layouts\Core\Service\LayoutResolverService->matchRules (line 264)
8	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveGroupRules (line 89)
9	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 57)
10	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
11	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
12	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
15	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
25	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.34 ms
(3.34%)

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = ?) AND (b.placeholder = ?) AND (b.status = ?) ORDER BY b.placeholder ASC, b.position ASC

Parameters:

[
  475
  "main"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b.*,
  bt.*,
  l.uuid as layout_uuid
FROM
  nglayouts_block b
  INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id)
  AND (bt.status = b.status)
  INNER JOIN nglayouts_layout l ON (l.id = b.layout_id)
  AND (l.status = b.status)
WHERE
  (b.parent_id = ?)
  AND (b.placeholder = ?)
  AND (b.status = ?)
ORDER BY
  b.placeholder ASC,
  b.position ASC

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.parent_id = 475) AND (b.placeholder = 'main') AND (b.status = 1) ORDER BY b.placeholder ASC, b.position ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\BlockQueryHandler->loadChildBlocksData (line 124)
6	Netgen\Layouts\Persistence\Doctrine\Handler\BlockHandler->loadChildBlocks (line 70)
7	Netgen\Layouts\Core\Mapper\BlockMapper->{closure:Netgen\Layouts\Core\Mapper\BlockMapper::mapPlaceholders():157} (line 159)
8	Netgen\Layouts\API\Values\LazyCollection->doInitialize (line 47)
9	Doctrine\Common\Collections\AbstractLazyCollection->initialize (line 402)
10	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
11	Netgen\Layouts\API\Values\Block\Placeholder->$blocks::get (line 28)
12	Twig\Extension\CoreExtension->getAttribute (line 1795)
13	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
14	__TwigTemplate_e2c17ffaf7c874f68b0e7ef680ea72e4::doDisplay (line 70)
15	Twig\Template->yield (line 402)
16	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
22	Netgen\Layouts\View\Renderer->renderValue (line 16)
23	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
24	__TwigTemplate_220504550d7cbe4e461c931b79e79a5c->block_content (line 86)
25	Twig\Template->yieldBlock (line 446)
26	Twig\Template->displayBlock (line 138)
27	Twig\Template->renderBlock (line 199)
28	__TwigTemplate_c0722213489c60393e2f0198ab4ba8ee->doDisplay (line 141)
29	Twig\Template->yield (line 402)
30	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
31	__TwigTemplate_220504550d7cbe4e461c931b79e79a5c->doDisplay (line 56)
32	Twig\Template->yield (line 402)
33	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
39	Netgen\Layouts\View\Renderer->renderValue (line 16)
40	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
41	__TwigTemplate_5b0e594fc8c46c7bc0302996497e771a->doDisplay (line 56)
42	Twig\Template->yield (line 402)
43	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
44	Twig\Template->display (line 358)
45	Twig\Template->render (line 373)
46	Twig\TemplateWrapper->render (line 51)
47	Twig\Environment->render (line 333)
48	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
49	Netgen\Layouts\View\Renderer->renderValue (line 16)
50	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
51	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
52	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
53	Twig\Template->yieldBlock (line 446)
54	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
55	Twig\Template->yieldBlock (line 446)
56	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
59	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
60	Twig\Template->yield (line 402)
61	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
62	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
63	Twig\Template->yield (line 402)
64	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
65	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
66	Twig\Template->yield (line 402)
67	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
68	Twig\Template->display (line 358)
69	Twig\Template->render (line 373)
70	Twig\TemplateWrapper->render (line 51)
71	Twig\Environment->render (line 333)
72	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
73	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
74	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
75	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
76	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
77	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
78	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
79	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
80	Symfony\Component\HttpKernel\Kernel->handle (line 193)
81	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
82	require_once (line 32)
83	require_once (line 5)

0.33 ms
(3.28%)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.id = ?) AND (rg.status = ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (rg.id = ?)
  AND (rg.status = ?)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.id = 1) AND (rg.status = 1);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->loadRuleGroupData (line 193)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->loadRuleGroup (line 65)
7	Netgen\Layouts\Core\Mapper\LayoutResolverMapper->mapRule (line 54)
8	array_map (line 262)
9	Netgen\Layouts\Core\Service\LayoutResolverService::matchRules (line 262)
10	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveGroupRules (line 89)
11	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 57)
12	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
13	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
14	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
15	Twig\Extension\CoreExtension->getAttribute (line 1919)
16	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
17	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
18	Twig\Template->getParent (line 83)
19	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
27	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

0.33 ms
(3.23%)

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = ?) AND (b.status = ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b.*,
  bt.*,
  l.uuid as layout_uuid
FROM
  nglayouts_block b
  INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id)
  AND (bt.status = b.status)
  INNER JOIN nglayouts_layout l ON (l.id = b.layout_id)
  AND (l.status = b.status)
WHERE
  (b.id = ?)
  AND (b.status = ?)

SELECT DISTINCT b.*, bt.*, l.uuid as layout_uuid FROM nglayouts_block b INNER JOIN nglayouts_block_translation bt ON (bt.block_id = b.id) AND (bt.status = b.status) INNER JOIN nglayouts_layout l ON (l.id = b.layout_id) AND (l.status = b.status) WHERE (b.id = 8) AND (b.status = 1);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\BlockQueryHandler->loadBlockData (line 41)
6	Netgen\Layouts\Persistence\Doctrine\Handler\BlockHandler->loadBlock (line 45)
7	Netgen\Layouts\Core\Service\BlockService->loadZoneBlocks (line 98)
8	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 148)
9	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 92)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
14	Twig\Template->yield (line 402)
15	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
16	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
19	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
22	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
30	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.19 ms
(1.88%)

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = ?) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value IN (?, ?, ?, ?)) ORDER BY rd.priority DESC

Parameters:

[
  1
  1
  1
  "ibexa_subtree"
  1
  1
  2
  385
  506
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r.*,
  rd.*,
  l.uuid AS layout_uuid
FROM
  nglayouts_rule r
  INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id
  LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid)
  AND (l.status = ?)
  INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id)
  AND (r.status = rt.status)
WHERE
  (r.rule_group_id = ?)
  AND (rd.enabled = ?)
  AND (rt.type = ?)
  AND (r.status = ?)
  AND (
    rt.value IN (?, ?, ?, ?)
  )
ORDER BY
  rd.priority DESC

SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = 1) AND (rd.enabled = 1) AND (rt.type = 'ibexa_subtree') AND (r.status = 1) AND (rt.value IN (1, 2, 385, 506)) ORDER BY rd.priority DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->matchRules (line 178)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->matchRules (line 112)
7	Netgen\Layouts\Core\Service\LayoutResolverService->matchRules (line 264)
8	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveGroupRules (line 89)
9	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 57)
10	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
11	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
12	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
15	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
25	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.13 ms
(1.27%)

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = ?) AND (rg.status = ?) ORDER BY rgd.priority DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT rg.*,
  rgd.*
FROM
  nglayouts_rule_group rg
  INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id
WHERE
  (parent_id = ?)
  AND (rg.status = ?)
ORDER BY
  rgd.priority DESC

SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = 1) AND (rg.status = 1) ORDER BY rgd.priority DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutResolverQueryHandler->loadRuleGroupsData (line 234)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutResolverHandler->loadRuleGroups (line 100)
7	Netgen\Layouts\Core\Service\LayoutResolverService->loadRuleGroups (line 225)
8	Netgen\Layouts\Layout\Resolver\LayoutResolver->innerResolveRules (line 52)
9	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
10	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
11	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
12	Twig\Extension\CoreExtension->getAttribute (line 1919)
13	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
14	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
15	Twig\Template->getParent (line 83)
16	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
24	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.08 ms
(0.75%)

SELECT DISTINCT l.*, lt.* FROM nglayouts_layout l INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id) AND (lt.status = l.status) WHERE (l.uuid = ?) AND (l.status = ?)

Parameters:

[
  "f1775089-48fc-4f9b-b053-0d6f7c50d657"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l.*,
  lt.*
FROM
  nglayouts_layout l
  INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id)
  AND (lt.status = l.status)
WHERE
  (l.uuid = ?)
  AND (l.status = ?)

SELECT DISTINCT l.*, lt.* FROM nglayouts_layout l INNER JOIN nglayouts_layout_translation lt ON (lt.layout_id = l.id) AND (lt.status = l.status) WHERE (l.uuid = 'f1775089-48fc-4f9b-b053-0d6f7c50d657') AND (l.status = 1);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 295)
5	Netgen\Layouts\Persistence\Doctrine\QueryHandler\LayoutQueryHandler->loadLayoutData (line 43)
6	Netgen\Layouts\Persistence\Doctrine\Handler\LayoutHandler->loadLayout (line 45)
7	Netgen\Layouts\Core\Service\LayoutService->loadLayout (line 54)
8	Netgen\Layouts\Core\Mapper\LayoutResolverMapper->{closure:Netgen\Layouts\Core\Mapper\LayoutResolverMapper::mapRule():79} (line 83)
9	Netgen\Layouts\API\Values\LayoutResolver\Rule->{closure:{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34}:36} (line 36)
10	array_map (line 35)
11	Netgen\Layouts\API\Values\LayoutResolver\Rule::{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34} (line 35)
12	Netgen\Layouts\Layout\Resolver\LayoutResolver::innerResolveRules (line 68)
13	Netgen\Layouts\Layout\Resolver\LayoutResolver->resolveRule (line 31)
14	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->buildLayoutView (line 248)
15	Netgen\Bundle\LayoutsBundle\Templating\Twig\GlobalVariable->getLayoutTemplate (line 155)
16	Twig\Extension\CoreExtension->getAttribute (line 1919)
17	Netgen\Bundle\IbexaSiteApiBundle\Templating\Twig\Node\GetAttrExpressionDecorator::twigGetAttribute (line 213)
18	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0::doGetParent (line 44)
19	Twig\Template->getParent (line 83)
20	__TwigTemplate_dd2ff5e339eb2419e3bec36f2e40baa0->doDisplay (line 71)
21	Twig\Template->yield (line 402)
22	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
28	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
ibexa_default	doctrine.orm.ibexa_default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

ibexa_default entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://site.v5.nexus.alpha.se7enx.com/privacy-policy

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

ibexa_default entity manager

Entities Mapping

default entity manager

ibexa_default entity manager

Symfony Profiler

GET https://site.v5.nexus.alpha.se7enx.com/privacy-policy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

ibexa_default entity manager

Entities Mapping

default entity manager

ibexa_default entity manager