Symfony Profiler

Query Metrics

65 Database Queries

17 Different statements

7.13 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.56 ms
(21.83%)

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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.22 ms
(17.14%)

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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
14	Twig\Template->getParent (line 83)
15	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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)

0.64 ms
(9.01%)

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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.49 ms
(6.87%)

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
  277
]

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 = 277) 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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.49 ms
(6.84%)

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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.39 ms
(5.46%)

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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.35 ms
(4.85%)

SELECT COUNT(t.node_id) FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE ?) AND (NOT (t.node_id IN (?))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = ?) AND (c.content_type_id IN (?)) AND (c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (?))) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?)

Parameters:

[
  "/1/2/385/%"
  385
  0
  102
  1
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  1
  1
  0
  3
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(t.node_id)
FROM
  ibexa_content_tree t
  INNER JOIN ibexa_content c ON t.contentobject_id = c.id
  INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (t.path_string LIKE ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (t.node_id = t.main_node_id)
      AND (t.is_invisible = ?)
      AND (
        c.content_type_id IN (?)
      )
      AND (
        c.id IN (
          SELECT
            t1.id
          FROM
            ibexa_content t1
            INNER JOIN eztags_attribute_link t2 ON (
              t2.objectattribute_version = t1.current_version
            )
            AND (t2.object_id = t1.id)
          WHERE
            t2.keyword_id IN (?)
        )
      )
      AND (
        (
          c.section_id IN (?)
        )
        OR (
          (
            c.content_type_id IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?
            )
          )
          AND (
            c.section_id IN (?)
          )
        )
      )
    )
  )
  AND (c.status = ?)
  AND (v.status = ?)
  AND (t.depth <> ?)
  AND (
    (c.language_mask & ?) > ?
  )

SELECT COUNT(t.node_id) FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE '/1/2/385/%') AND (NOT (t.node_id IN (385))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = 0) AND (c.content_type_id IN (102)) AND (c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (1))) AND ((c.section_id IN (1)) OR ((c.content_type_id IN ('100', '103', '104', '105', '106', '107', '108', '111', '113', '118', '119', '120', '37', '41', '42', '49', '50', '51', '80', '81', '95', '97')) AND (c.section_id IN (3)))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0);

#	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	Ibexa\Core\Search\Legacy\Content\Location\Gateway\DoctrineDatabase->getTotalCount (line 199)
5	Ibexa\Core\Search\Legacy\Content\Location\Gateway\DoctrineDatabase->find (line 51)
6	Ibexa\Core\Search\Legacy\Content\Location\Gateway\ExceptionConversion->find (line 47)
7	Ibexa\Core\Search\Legacy\Content\Handler->findLocations (line 219)
8	ContainerFS34TSd\VersatileHandlerProxy7884708->findLocations (line 32)
9	Ibexa\Core\Repository\SearchService->findLocations (line 256)
10	Ibexa\Contracts\Core\Repository\Decorator\SearchServiceDecorator->findLocations (line 65)
11	Ibexa\Core\Repository\SiteAccessAware\SearchService->findLocations (line 98)
12	Netgen\IbexaSiteApi\Core\Site\FindService->findLocations (line 60)
13	Netgen\Bundle\SiteBundle\Topic\UrlGenerator->getTopicValueObject (line 74)
14	Netgen\Bundle\SiteBundle\Topic\UrlGenerator->generate (line 41)
15	Netgen\Bundle\SiteBundle\Templating\Twig\Extension\TopicUrlRuntime->getTopicPath (line 22)
16	__TwigTemplate_37a6b82d3bb97cab05218efb546c8627->doDisplay (line 80)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
19	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_article_header (line 157)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_content (line 102)
22	Twig\Template->yieldBlock (line 446)
23	Twig\Template->displayBlock (line 138)
24	Netgen\Layouts\View\Twig\ContextualizedTwigTemplate->renderBlock (line 64)
25	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->getTwigBlockContent (line 59)
26	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->onRenderView (line 34)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
32	Netgen\Layouts\View\Renderer->renderValue (line 16)
33	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
34	__TwigTemplate_5b0e594fc8c46c7bc0302996497e771a->doDisplay (line 56)
35	Twig\Template->yield (line 402)
36	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
37	Twig\Template->display (line 358)
38	Twig\Template->render (line 373)
39	Twig\TemplateWrapper->render (line 51)
40	Twig\Environment->render (line 333)
41	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
42	Netgen\Layouts\View\Renderer->renderValue (line 16)
43	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
44	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
45	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 115)
46	Twig\Template->yieldBlock (line 446)
47	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
48	Twig\Template->yieldBlock (line 446)
49	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
50	Twig\Template->yield (line 402)
51	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
52	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
53	Twig\Template->yield (line 402)
54	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
55	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
56	Twig\Template->yield (line 402)
57	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
58	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
59	Twig\Template->yield (line 402)
60	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
61	Twig\Template->display (line 358)
62	Twig\Template->render (line 373)
63	Twig\TemplateWrapper->render (line 51)
64	Twig\Environment->render (line 333)
65	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
66	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
67	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
68	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
69	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
70	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
71	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
72	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
73	Symfony\Component\HttpKernel\Kernel->handle (line 193)
74	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
75	require_once (line 32)
76	require_once (line 5)

0.32 ms
(4.49%)

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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.30 ms
(4.28%)

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 = 21) 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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
24	Twig\Template->getParent (line 83)
25	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.29 ms
(4.05%)

SELECT t.*, c.language_mask, c.initial_language_id FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE ?) AND (NOT (t.node_id IN (?))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = ?) AND (c.content_type_id IN (?)) AND (c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (?))) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?) LIMIT 1

Parameters:

[
  "/1/2/385/%"
  385
  0
  102
  1
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  1
  1
  0
  3
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t.*,
  c.language_mask,
  c.initial_language_id
FROM
  ibexa_content_tree t
  INNER JOIN ibexa_content c ON t.contentobject_id = c.id
  INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (t.path_string LIKE ?)
      AND (
        NOT (
          t.node_id IN (?)
        )
      )
      AND (t.node_id = t.main_node_id)
      AND (t.is_invisible = ?)
      AND (
        c.content_type_id IN (?)
      )
      AND (
        c.id IN (
          SELECT
            t1.id
          FROM
            ibexa_content t1
            INNER JOIN eztags_attribute_link t2 ON (
              t2.objectattribute_version = t1.current_version
            )
            AND (t2.object_id = t1.id)
          WHERE
            t2.keyword_id IN (?)
        )
      )
      AND (
        (
          c.section_id IN (?)
        )
        OR (
          (
            c.content_type_id IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?
            )
          )
          AND (
            c.section_id IN (?)
          )
        )
      )
    )
  )
  AND (c.status = ?)
  AND (v.status = ?)
  AND (t.depth <> ?)
  AND (
    (c.language_mask & ?) > ?
  )
LIMIT
  1

SELECT t.*, c.language_mask, c.initial_language_id FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.path_string LIKE '/1/2/385/%') AND (NOT (t.node_id IN (385))) AND (t.node_id = t.main_node_id) AND (t.is_invisible = 0) AND (c.content_type_id IN (102)) AND (c.id IN (SELECT t1.id FROM ibexa_content t1 INNER JOIN eztags_attribute_link t2 ON (t2.objectattribute_version = t1.current_version) AND (t2.object_id = t1.id) WHERE t2.keyword_id IN (1))) AND ((c.section_id IN (1)) OR ((c.content_type_id IN ('100', '103', '104', '105', '106', '107', '108', '111', '113', '118', '119', '120', '37', '41', '42', '49', '50', '51', '80', '81', '95', '97')) AND (c.section_id IN (3)))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0) LIMIT 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	Ibexa\Core\Search\Legacy\Content\Location\Gateway\DoctrineDatabase->find (line 132)
5	Ibexa\Core\Search\Legacy\Content\Location\Gateway\ExceptionConversion->find (line 47)
6	Ibexa\Core\Search\Legacy\Content\Handler->findLocations (line 219)
7	ContainerFS34TSd\VersatileHandlerProxy7884708->findLocations (line 32)
8	Ibexa\Core\Repository\SearchService->findLocations (line 256)
9	Ibexa\Contracts\Core\Repository\Decorator\SearchServiceDecorator->findLocations (line 65)
10	Ibexa\Core\Repository\SiteAccessAware\SearchService->findLocations (line 98)
11	Netgen\IbexaSiteApi\Core\Site\FindService->findLocations (line 60)
12	Netgen\Bundle\SiteBundle\Topic\UrlGenerator->getTopicValueObject (line 74)
13	Netgen\Bundle\SiteBundle\Topic\UrlGenerator->generate (line 41)
14	Netgen\Bundle\SiteBundle\Templating\Twig\Extension\TopicUrlRuntime->getTopicPath (line 22)
15	__TwigTemplate_37a6b82d3bb97cab05218efb546c8627->doDisplay (line 80)
16	Twig\Template->yield (line 402)
17	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
18	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_article_header (line 157)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_content (line 102)
21	Twig\Template->yieldBlock (line 446)
22	Twig\Template->displayBlock (line 138)
23	Netgen\Layouts\View\Twig\ContextualizedTwigTemplate->renderBlock (line 64)
24	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->getTwigBlockContent (line 59)
25	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->onRenderView (line 34)
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	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
31	Netgen\Layouts\View\Renderer->renderValue (line 16)
32	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
33	__TwigTemplate_5b0e594fc8c46c7bc0302996497e771a->doDisplay (line 56)
34	Twig\Template->yield (line 402)
35	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
41	Netgen\Layouts\View\Renderer->renderValue (line 16)
42	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
43	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
44	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 115)
45	Twig\Template->yieldBlock (line 446)
46	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
47	Twig\Template->yieldBlock (line 446)
48	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
49	Twig\Template->yield (line 402)
50	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
51	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
52	Twig\Template->yield (line 402)
53	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
54	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
55	Twig\Template->yield (line 402)
56	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
57	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
58	Twig\Template->yield (line 402)
59	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
60	Twig\Template->display (line 358)
61	Twig\Template->render (line 373)
62	Twig\TemplateWrapper->render (line 51)
63	Twig\Environment->render (line 333)
64	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
65	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
66	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
67	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
68	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
69	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
70	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
71	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
72	Symfony\Component\HttpKernel\Kernel->handle (line 193)
73	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
74	require_once (line 32)
75	require_once (line 5)

0.27 ms
(3.80%)

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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
18	Twig\Template->getParent (line 83)
19	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.26 ms
(3.67%)

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
  "/fitness/10-workout-terms-you-need-to-know"
]

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 ('/fitness/10-workout-terms-you-need-to-know' 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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.16 ms
(2.27%)

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 = 19) 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_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.15 ms
(2.11%)

SELECT t.*, c.language_mask, c.initial_language_id, c.published AS "sort_column_0" FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.parent_node_id IN (?)) AND ((t.is_hidden = ?) AND (t.is_invisible = ?) AND (c.is_hidden = ?)) AND (c.content_type_id IN (?, ?)) AND ((c.section_id IN (?)) OR ((c.content_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c.section_id IN (?)))))) AND (c.status = ?) AND (v.status = ?) AND (t.depth <> ?) AND ((c.language_mask & ?) > ?) ORDER BY "sort_column_0" DESC LIMIT 25

Parameters:

[
  277
  0
  0
  0
  81
  97
  1
  "100"
  "103"
  "104"
  "105"
  "106"
  "107"
  "108"
  "111"
  "113"
  "118"
  "119"
  "120"
  "37"
  "41"
  "42"
  "49"
  "50"
  "51"
  "80"
  "81"
  "95"
  "97"
  3
  1
  1
  0
  3
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t.*,
  c.language_mask,
  c.initial_language_id,
  c.published AS "sort_column_0"
FROM
  ibexa_content_tree t
  INNER JOIN ibexa_content c ON t.contentobject_id = c.id
  INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id
WHERE
  (
    (1 = 1)
    AND (
      (
        t.parent_node_id IN (?)
      )
      AND (
        (t.is_hidden = ?)
        AND (t.is_invisible = ?)
        AND (c.is_hidden = ?)
      )
      AND (
        c.content_type_id IN (?, ?)
      )
      AND (
        (
          c.section_id IN (?)
        )
        OR (
          (
            c.content_type_id IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?
            )
          )
          AND (
            c.section_id IN (?)
          )
        )
      )
    )
  )
  AND (c.status = ?)
  AND (v.status = ?)
  AND (t.depth <> ?)
  AND (
    (c.language_mask & ?) > ?
  )
ORDER BY
  "sort_column_0" DESC
LIMIT
  25

SELECT t.*, c.language_mask, c.initial_language_id, c.published AS "sort_column_0" FROM ibexa_content_tree t INNER JOIN ibexa_content c ON t.contentobject_id = c.id INNER JOIN ibexa_content_version v ON c.id = v.contentobject_id WHERE ((1 = 1) AND ((t.parent_node_id IN (277)) AND ((t.is_hidden = 0) AND (t.is_invisible = 0) AND (c.is_hidden = 0)) AND (c.content_type_id IN (81, 97)) AND ((c.section_id IN (1)) OR ((c.content_type_id IN ('100', '103', '104', '105', '106', '107', '108', '111', '113', '118', '119', '120', '37', '41', '42', '49', '50', '51', '80', '81', '95', '97')) AND (c.section_id IN (3)))))) AND (c.status = 1) AND (v.status = 1) AND (t.depth <> 0) AND ((c.language_mask & 3) > 0) ORDER BY "sort_column_0" DESC LIMIT 25;

#	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	Ibexa\Core\Search\Legacy\Content\Location\Gateway\DoctrineDatabase->find (line 132)
5	Ibexa\Core\Search\Legacy\Content\Location\Gateway\ExceptionConversion->find (line 47)
6	Ibexa\Core\Search\Legacy\Content\Handler->findLocations (line 219)
7	Ibexa\Core\Repository\SearchService->findLocations (line 256)
8	Netgen\IbexaSiteApi\Core\Site\FilterService->filterLocations (line 60)
9	Netgen\IbexaSiteApi\Core\Site\Pagination\Pagerfanta\FilterAdapter->executeQuery (line 30)
10	Netgen\IbexaSearchExtra\Core\Pagination\Pagerfanta\BaseAdapter->getSlice (line 79)
11	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
12	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
13	Netgen\Bundle\SiteBundle\Relation\MultimediaRelationResolver->loadRelations (line 28)
14	Netgen\Bundle\SiteBundle\Controller\Relations\RelatedMultimediaItems->__invoke (line 31)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
19	Ibexa\Bundle\Core\Fragment\InlineFragmentRenderer->render (line 66)
20	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
21	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
22	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
23	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_image (line 207)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_557efea762def1a638f6eeb955df0dce->block_content (line 107)
26	Twig\Template->yieldBlock (line 446)
27	Twig\Template->displayBlock (line 138)
28	Netgen\Layouts\View\Twig\ContextualizedTwigTemplate->renderBlock (line 64)
29	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->getTwigBlockContent (line 59)
30	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetTwigBlockContentListener->onRenderView (line 34)
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	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
36	Netgen\Layouts\View\Renderer->renderValue (line 16)
37	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
38	__TwigTemplate_5b0e594fc8c46c7bc0302996497e771a->doDisplay (line 56)
39	Twig\Template->yield (line 402)
40	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
41	Twig\Template->display (line 358)
42	Twig\Template->render (line 373)
43	Twig\TemplateWrapper->render (line 51)
44	Twig\Environment->render (line 333)
45	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
46	Netgen\Layouts\View\Renderer->renderValue (line 16)
47	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
48	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
49	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->block_layout (line 115)
50	Twig\Template->yieldBlock (line 446)
51	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->block_pagelayout_content (line 174)
52	Twig\Template->yieldBlock (line 446)
53	__TwigTemplate_7b641e9ec620bb825cc3f43ade41f8da->doDisplay (line 261)
54	Twig\Template->yield (line 402)
55	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
56	__TwigTemplate_9aa78b7cef39f6b1bfb19c4e38190ea7->doDisplay (line 69)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
59	__TwigTemplate_c620f2b60ea452c08e55729ed44d0cdb->doDisplay (line 55)
60	Twig\Template->yield (line 402)
61	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
62	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
63	Twig\Template->yield (line 402)
64	Netgen\Bundle\SiteBundle\Templating\Twig\BaseDebugTemplate->yield (line 37)
65	Twig\Template->display (line 358)
66	Twig\Template->render (line 373)
67	Twig\TemplateWrapper->render (line 51)
68	Twig\Environment->render (line 333)
69	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
70	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
71	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
72	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
73	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
74	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
75	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
76	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
77	Symfony\Component\HttpKernel\Kernel->handle (line 193)
78	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
79	require_once (line 32)
80	require_once (line 5)

0.10 ms
(1.42%)

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
  167
  277
]

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, 167, 277)) 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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.09 ms
(1.22%)

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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
15	Twig\Template->getParent (line 83)
16	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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.05 ms
(0.70%)

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:

[
  "1d969451-6743-5ac1-85b8-6cc0f9ef7084"
  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 = '1d969451-6743-5ac1-85b8-6cc0f9ef7084') 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_557efea762def1a638f6eeb955df0dce::doGetParent (line 43)
19	Twig\Template->getParent (line 83)
20	__TwigTemplate_557efea762def1a638f6eeb955df0dce->doDisplay (line 68)
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

Entities Mapping

default entity manager

Class	Mapping errors
Netgen\InformationCollection\Doctrine\Entity\EzInfoCollection	No errors.
Netgen\InformationCollection\Doctrine\Entity\EzInfoCollectionAttribute	No errors.

ibexa_default entity manager

No loaded entities.

Symfony Profiler

GET https://site.v5.nexus.alpha.se7enx.com/fitness/10-workout-terms-you-need-to-know

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