Symfony Profiler

Query Metrics

96 Database Queries

22 Different statements

100.68 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.29 ms
(9.23%)

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 126)
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_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
21	Twig\Template->yield (line 402)
22	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
36	Twig\Template->yield (line 402)
37	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
38	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
39	Twig\Template->yield (line 402)
40	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
41	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
42	Twig\Template->yield (line 402)
43	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
44	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
45	Twig\Template->yield (line 402)
46	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

7.59 ms
(7.54%)

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 ((CHAR_LENGTH(TRIM(rt.value)) > ?) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC

Parameters:

[
  1
  1
  1
  "ibexa_semantic_path_info_prefix"
  1
  0
  "/running"
]

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 (
    (
      CHAR_LENGTH(
        TRIM(rt.value)
      ) > ?
    )
    AND (
      ? LIKE CONCAT(
        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 ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND ('/running' LIKE CONCAT(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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

7.52 ms
(7.47%)

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

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 = 833) 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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

7.25 ms
(7.20%)

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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
14	Twig\Template->yield (line 402)
15	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
16	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
19	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
22	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

7.03 ms
(6.99%)

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 (t.is_invisible = ?) AND (t.node_id = t.main_node_id) 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/%"
  0
  44
  95
  45
  93
  8
  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 (t.is_invisible = ?)
      AND (t.node_id = t.main_node_id)
      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 (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (44, 95, 45, 93)) 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 (8))) 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	ContainerPxNxmxE\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\Layouts\Query\ContentByTopicHandler->getCount (line 134)
14	Netgen\Layouts\Collection\QueryType\QueryType->getCount (line 31)
15	Netgen\Layouts\Collection\Result\QueryRunner->count (line 28)
16	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->count (line 58)
17	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 42)
18	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
19	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
20	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
21	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
27	Netgen\Layouts\View\Renderer->renderValue (line 16)
28	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
29	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
30	Twig\Template->yield (line 402)
31	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
37	Netgen\Layouts\View\Renderer->renderValue (line 16)
38	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
39	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->block_content (line 89)
40	Twig\Template->yieldBlock (line 446)
41	Twig\Template->displayBlock (line 138)
42	Twig\Template->renderBlock (line 199)
43	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
44	Twig\Template->yield (line 402)
45	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
46	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->doDisplay (line 56)
47	Twig\Template->yield (line 402)
48	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
54	Netgen\Layouts\View\Renderer->renderValue (line 16)
55	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
56	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
59	Twig\Template->display (line 358)
60	Twig\Template->render (line 373)
61	Twig\TemplateWrapper->render (line 51)
62	Twig\Environment->render (line 333)
63	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
64	Netgen\Layouts\View\Renderer->renderValue (line 16)
65	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
66	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
67	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
68	Twig\Template->yieldBlock (line 446)
69	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
70	Twig\Template->yieldBlock (line 446)
71	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
72	Twig\Template->yield (line 402)
73	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
74	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
75	Twig\Template->yield (line 402)
76	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
77	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
78	Twig\Template->yield (line 402)
79	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
80	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
81	Twig\Template->yield (line 402)
82	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
83	Twig\Template->display (line 358)
84	Twig\Template->render (line 373)
85	Twig\TemplateWrapper->render (line 51)
86	Twig\Environment->render (line 333)
87	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
88	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
89	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
90	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
91	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
92	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
93	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
94	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
95	Symfony\Component\HttpKernel\Kernel->handle (line 193)
96	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
97	require_once (line 32)
98	require_once (line 5)

6.87 ms
(6.82%)

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_b1e9f14468b7ed83d75e794e9c4c89e8::doDisplay (line 70)
15	Twig\Template->yield (line 402)
16	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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_29de95ffc0e745990b99a6967ae2918f->block_content (line 86)
25	Twig\Template->yieldBlock (line 446)
26	Twig\Template->displayBlock (line 138)
27	Twig\Template->renderBlock (line 199)
28	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
29	Twig\Template->yield (line 402)
30	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
31	__TwigTemplate_29de95ffc0e745990b99a6967ae2918f->doDisplay (line 56)
32	Twig\Template->yield (line 402)
33	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
42	Twig\Template->yield (line 402)
43	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
53	Twig\Template->yieldBlock (line 446)
54	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
55	Twig\Template->yieldBlock (line 446)
56	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
59	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
60	Twig\Template->yield (line 402)
61	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
62	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
63	Twig\Template->yield (line 402)
64	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
65	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
66	Twig\Template->yield (line 402)
67	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

6.14 ms
(6.10%)

SELECT DISTINCT q.*, qt.*, c.uuid as collection_uuid FROM nglayouts_collection_query q INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id) AND (qt.status = q.status) INNER JOIN nglayouts_collection c ON (c.id = q.collection_id) AND (c.status = q.status) WHERE (q.collection_id = ?) AND (q.status = ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT q.*,
  qt.*,
  c.uuid as collection_uuid
FROM
  nglayouts_collection_query q
  INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id)
  AND (qt.status = q.status)
  INNER JOIN nglayouts_collection c ON (c.id = q.collection_id)
  AND (c.status = q.status)
WHERE
  (q.collection_id = ?)
  AND (q.status = ?)

SELECT DISTINCT q.*, qt.*, c.uuid as collection_uuid FROM nglayouts_collection_query q INNER JOIN nglayouts_collection_query_translation qt ON (qt.query_id = q.id) AND (qt.status = q.status) INNER JOIN nglayouts_collection c ON (c.id = q.collection_id) AND (c.status = q.status) WHERE (q.collection_id = 66) AND (q.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\CollectionQueryHandler->loadCollectionQueryData (line 201)
6	Netgen\Layouts\Persistence\Doctrine\Handler\CollectionHandler->loadCollectionQuery (line 160)
7	Netgen\Layouts\Core\Mapper\CollectionMapper->{closure:Netgen\Layouts\Core\Mapper\CollectionMapper::mapCollection():105} (line 107)
8	Netgen\Layouts\API\Values\Collection\Collection->{closure:{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34}:36} (line 36)
9	array_map (line 35)
10	Netgen\Layouts\API\Values\Collection\Collection::{closure:Netgen\Layouts\Utils\HydratorTrait::fromArray():34} (line 35)
11	Netgen\Layouts\API\Values\Collection\Collection::$hasQuery::get (line 52)
12	Netgen\Layouts\API\Values\Collection\Collection->$offset::get (line 29)
13	Netgen\Layouts\Collection\Result\Pagerfanta\PagerFactory->getPager (line 42)
14	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 58)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
20	Netgen\Layouts\View\Renderer->renderValue (line 16)
21	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
22	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
30	Netgen\Layouts\View\Renderer->renderValue (line 16)
31	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
32	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->block_content (line 89)
33	Twig\Template->yieldBlock (line 446)
34	Twig\Template->displayBlock (line 138)
35	Twig\Template->renderBlock (line 199)
36	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
37	Twig\Template->yield (line 402)
38	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
39	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->doDisplay (line 56)
40	Twig\Template->yield (line 402)
41	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
42	Twig\Template->display (line 358)
43	Twig\Template->render (line 373)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
47	Netgen\Layouts\View\Renderer->renderValue (line 16)
48	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
49	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
50	Twig\Template->yield (line 402)
51	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
52	Twig\Template->display (line 358)
53	Twig\Template->render (line 373)
54	Twig\TemplateWrapper->render (line 51)
55	Twig\Environment->render (line 333)
56	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
57	Netgen\Layouts\View\Renderer->renderValue (line 16)
58	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
59	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
60	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
61	Twig\Template->yieldBlock (line 446)
62	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
63	Twig\Template->yieldBlock (line 446)
64	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
65	Twig\Template->yield (line 402)
66	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
67	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
68	Twig\Template->yield (line 402)
69	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
70	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
71	Twig\Template->yield (line 402)
72	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
73	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
74	Twig\Template->yield (line 402)
75	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
76	Twig\Template->display (line 358)
77	Twig\Template->render (line 373)
78	Twig\TemplateWrapper->render (line 51)
79	Twig\Environment->render (line 333)
80	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
81	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
82	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
83	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
84	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
85	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
86	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
87	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
88	Symfony\Component\HttpKernel\Kernel->handle (line 193)
89	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
90	require_once (line 32)
91	require_once (line 5)

6.02 ms
(5.98%)

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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
14	Twig\Template->getParent (line 83)
15	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
16	Twig\Template->yield (line 402)
17	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

5.54 ms
(5.50%)

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 = 45) 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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
24	Twig\Template->getParent (line 83)
25	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
26	Twig\Template->yield (line 402)
27	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

5.06 ms
(5.03%)

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.path_string LIKE ?) AND (t.is_invisible = ?) AND (t.node_id = t.main_node_id) 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 & ?) > ?) ORDER BY `sort_column_0` DESC LIMIT 1

Parameters:

[
  "/1/2/385/%"
  0
  44
  95
  45
  93
  8
  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.path_string LIKE ?)
      AND (t.is_invisible = ?)
      AND (t.node_id = t.main_node_id)
      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 & ?) > ?
  )
ORDER BY
  `sort_column_0` DESC
LIMIT
  1

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.path_string LIKE '/1/2/385/%') AND (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (44, 95, 45, 93)) 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 (8))) 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 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	ContainerPxNxmxE\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\Layouts\Query\ContentByTopicHandler->getValues (line 109)
13	Netgen\Layouts\Collection\QueryType\QueryType->getValues (line 26)
14	Netgen\Layouts\Collection\Result\QueryRunner->runQuery (line 19)
15	Generator->valid (line 33)
16	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->runCollection (line 33)
17	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 44)
18	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
19	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
20	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
21	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
27	Netgen\Layouts\View\Renderer->renderValue (line 16)
28	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
29	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
30	Twig\Template->yield (line 402)
31	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
37	Netgen\Layouts\View\Renderer->renderValue (line 16)
38	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
39	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->block_content (line 89)
40	Twig\Template->yieldBlock (line 446)
41	Twig\Template->displayBlock (line 138)
42	Twig\Template->renderBlock (line 199)
43	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
44	Twig\Template->yield (line 402)
45	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
46	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->doDisplay (line 56)
47	Twig\Template->yield (line 402)
48	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
54	Netgen\Layouts\View\Renderer->renderValue (line 16)
55	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
56	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
59	Twig\Template->display (line 358)
60	Twig\Template->render (line 373)
61	Twig\TemplateWrapper->render (line 51)
62	Twig\Environment->render (line 333)
63	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
64	Netgen\Layouts\View\Renderer->renderValue (line 16)
65	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
66	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
67	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
68	Twig\Template->yieldBlock (line 446)
69	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
70	Twig\Template->yieldBlock (line 446)
71	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
72	Twig\Template->yield (line 402)
73	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
74	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
75	Twig\Template->yield (line 402)
76	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
77	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
78	Twig\Template->yield (line 402)
79	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
80	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
81	Twig\Template->yield (line 402)
82	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
83	Twig\Template->display (line 358)
84	Twig\Template->render (line 373)
85	Twig\TemplateWrapper->render (line 51)
86	Twig\Environment->render (line 333)
87	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
88	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
89	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
90	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
91	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
92	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
93	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
94	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
95	Symfony\Component\HttpKernel\Kernel->handle (line 193)
96	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
97	require_once (line 32)
98	require_once (line 5)

4.46 ms
(4.43%)

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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
18	Twig\Template->getParent (line 83)
19	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

4.05 ms
(4.02%)

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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
19	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
22	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
25	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
26	Twig\Template->yield (line 402)
27	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

3.59 ms
(3.57%)

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.path_string LIKE ?) AND (t.is_invisible = ?) AND (t.node_id = t.main_node_id) 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 & ?) > ?) ORDER BY `sort_column_0` DESC LIMIT 6 OFFSET 1

Parameters:

[
  "/1/2/385/%"
  0
  44
  95
  45
  93
  8
  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.path_string LIKE ?)
      AND (t.is_invisible = ?)
      AND (t.node_id = t.main_node_id)
      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 & ?) > ?
  )
ORDER BY
  `sort_column_0` DESC
LIMIT
  6
OFFSET
  1

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.path_string LIKE '/1/2/385/%') AND (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (44, 95, 45, 93)) 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 (8))) 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 6 OFFSET 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	ContainerPxNxmxE\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\Layouts\Query\ContentByTopicHandler->getValues (line 109)
13	Netgen\Layouts\Collection\QueryType\QueryType->getValues (line 26)
14	Netgen\Layouts\Collection\Result\QueryRunner->runQuery (line 19)
15	Generator->valid (line 33)
16	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->runCollection (line 33)
17	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 44)
18	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
19	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
20	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
21	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
27	Netgen\Layouts\View\Renderer->renderValue (line 16)
28	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
29	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
30	Twig\Template->yield (line 402)
31	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
37	Netgen\Layouts\View\Renderer->renderValue (line 16)
38	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
39	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
40	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
41	Twig\Template->yieldBlock (line 446)
42	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
43	Twig\Template->yieldBlock (line 446)
44	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
45	Twig\Template->yield (line 402)
46	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
47	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
48	Twig\Template->yield (line 402)
49	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
50	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
51	Twig\Template->yield (line 402)
52	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
53	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
54	Twig\Template->yield (line 402)
55	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
56	Twig\Template->display (line 358)
57	Twig\Template->render (line 373)
58	Twig\TemplateWrapper->render (line 51)
59	Twig\Environment->render (line 333)
60	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
61	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
62	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
63	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
64	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
65	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
66	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
67	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
68	Symfony\Component\HttpKernel\Kernel->handle (line 193)
69	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
70	require_once (line 32)
71	require_once (line 5)

3.51 ms
(3.48%)

SELECT DISTINCT s.*, c.uuid AS collection_uuid FROM nglayouts_collection_slot s INNER JOIN nglayouts_collection c ON (c.id = s.collection_id) AND (c.status = s.status) WHERE (s.collection_id = ?) AND (s.status = ?) ORDER BY s.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s.*,
  c.uuid AS collection_uuid
FROM
  nglayouts_collection_slot s
  INNER JOIN nglayouts_collection c ON (c.id = s.collection_id)
  AND (c.status = s.status)
WHERE
  (s.collection_id = ?)
  AND (s.status = ?)
ORDER BY
  s.position ASC

SELECT DISTINCT s.*, c.uuid AS collection_uuid FROM nglayouts_collection_slot s INNER JOIN nglayouts_collection c ON (c.id = s.collection_id) AND (c.status = s.status) WHERE (s.collection_id = 66) AND (s.status = 1) ORDER BY s.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\CollectionQueryHandler->loadCollectionSlotsData (line 236)
6	Netgen\Layouts\Persistence\Doctrine\Handler\CollectionHandler->loadCollectionSlots (line 189)
7	Netgen\Layouts\Core\Mapper\CollectionMapper->{closure:Netgen\Layouts\Core\Mapper\CollectionMapper::mapCollection():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\Collection\Collection->$slots::get (line 72)
12	Netgen\Layouts\API\Values\Collection\Collection->getSlot (line 142)
13	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->runCollection (line 39)
14	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 44)
15	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
16	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
17	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
18	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
24	Netgen\Layouts\View\Renderer->renderValue (line 16)
25	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
26	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
27	Twig\Template->yield (line 402)
28	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
34	Netgen\Layouts\View\Renderer->renderValue (line 16)
35	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
36	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->block_content (line 89)
37	Twig\Template->yieldBlock (line 446)
38	Twig\Template->displayBlock (line 138)
39	Twig\Template->renderBlock (line 199)
40	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
41	Twig\Template->yield (line 402)
42	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
43	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->doDisplay (line 56)
44	Twig\Template->yield (line 402)
45	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
46	Twig\Template->display (line 358)
47	Twig\Template->render (line 373)
48	Twig\TemplateWrapper->render (line 51)
49	Twig\Environment->render (line 333)
50	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
51	Netgen\Layouts\View\Renderer->renderValue (line 16)
52	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
53	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
54	Twig\Template->yield (line 402)
55	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
56	Twig\Template->display (line 358)
57	Twig\Template->render (line 373)
58	Twig\TemplateWrapper->render (line 51)
59	Twig\Environment->render (line 333)
60	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
61	Netgen\Layouts\View\Renderer->renderValue (line 16)
62	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
63	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
64	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
65	Twig\Template->yieldBlock (line 446)
66	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
67	Twig\Template->yieldBlock (line 446)
68	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
69	Twig\Template->yield (line 402)
70	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
71	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
72	Twig\Template->yield (line 402)
73	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
74	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
75	Twig\Template->yield (line 402)
76	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
77	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
78	Twig\Template->yield (line 402)
79	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
80	Twig\Template->display (line 358)
81	Twig\Template->render (line 373)
82	Twig\TemplateWrapper->render (line 51)
83	Twig\Environment->render (line 333)
84	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
85	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
86	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
87	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
88	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
89	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
90	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
91	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
92	Symfony\Component\HttpKernel\Kernel->handle (line 193)
93	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
94	require_once (line 32)
95	require_once (line 5)

3.35 ms
(3.33%)

SELECT DISTINCT i.*, c.uuid AS collection_uuid FROM nglayouts_collection_item i INNER JOIN nglayouts_collection c ON (c.id = i.collection_id) AND (c.status = i.status) WHERE (i.collection_id = ?) AND (i.status = ?) ORDER BY i.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i.*,
  c.uuid AS collection_uuid
FROM
  nglayouts_collection_item i
  INNER JOIN nglayouts_collection c ON (c.id = i.collection_id)
  AND (c.status = i.status)
WHERE
  (i.collection_id = ?)
  AND (i.status = ?)
ORDER BY
  i.position ASC

SELECT DISTINCT i.*, c.uuid AS collection_uuid FROM nglayouts_collection_item i INNER JOIN nglayouts_collection c ON (c.id = i.collection_id) AND (c.status = i.status) WHERE (i.collection_id = 66) AND (i.status = 1) ORDER BY i.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\CollectionQueryHandler->loadCollectionItemsData (line 144)
6	Netgen\Layouts\Persistence\Doctrine\Handler\CollectionHandler->loadCollectionItems (line 134)
7	Netgen\Layouts\Core\Mapper\CollectionMapper->{closure:Netgen\Layouts\Core\Mapper\CollectionMapper::mapCollection():84} (line 86)
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\Collection\Collection->$items::get (line 63)
12	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->count (line 61)
13	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 42)
14	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
15	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
16	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
17	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
22	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
23	Netgen\Layouts\View\Renderer->renderValue (line 16)
24	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
25	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
26	Twig\Template->yield (line 402)
27	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
33	Netgen\Layouts\View\Renderer->renderValue (line 16)
34	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
35	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->block_content (line 89)
36	Twig\Template->yieldBlock (line 446)
37	Twig\Template->displayBlock (line 138)
38	Twig\Template->renderBlock (line 199)
39	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
40	Twig\Template->yield (line 402)
41	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
42	__TwigTemplate_fd72da7b9022477a69dd69c93d4c9b12->doDisplay (line 56)
43	Twig\Template->yield (line 402)
44	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
45	Twig\Template->display (line 358)
46	Twig\Template->render (line 373)
47	Twig\TemplateWrapper->render (line 51)
48	Twig\Environment->render (line 333)
49	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
50	Netgen\Layouts\View\Renderer->renderValue (line 16)
51	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
52	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
53	Twig\Template->yield (line 402)
54	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
55	Twig\Template->display (line 358)
56	Twig\Template->render (line 373)
57	Twig\TemplateWrapper->render (line 51)
58	Twig\Environment->render (line 333)
59	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
60	Netgen\Layouts\View\Renderer->renderValue (line 16)
61	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
62	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
63	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
64	Twig\Template->yieldBlock (line 446)
65	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
66	Twig\Template->yieldBlock (line 446)
67	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
68	Twig\Template->yield (line 402)
69	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
70	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
71	Twig\Template->yield (line 402)
72	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
73	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
74	Twig\Template->yield (line 402)
75	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
76	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
77	Twig\Template->yield (line 402)
78	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
79	Twig\Template->display (line 358)
80	Twig\Template->render (line 373)
81	Twig\TemplateWrapper->render (line 51)
82	Twig\Environment->render (line 333)
83	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
84	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
85	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
86	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
87	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
88	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 193)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
93	require_once (line 32)
94	require_once (line 5)

2.80 ms
(2.79%)

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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
14	Twig\Template->yield (line 402)
15	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
16	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
19	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
22	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
23	Twig\Template->yield (line 402)
24	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

2.70 ms
(2.68%)

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:

[
  "91a4d984-203d-554d-b1c4-0bb00e5d55b7"
  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 = '91a4d984-203d-554d-b1c4-0bb00e5d55b7') 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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
19	Twig\Template->getParent (line 83)
20	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
21	Twig\Template->yield (line 402)
22	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

2.47 ms
(2.46%)

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
  829
  833
]

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, 829, 833)) 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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
16	Twig\Template->getParent (line 83)
17	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
18	Twig\Template->yield (line 402)
19	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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.89 ms
(1.87%)

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.path_string LIKE ?) AND (t.is_invisible = ?) AND (t.node_id = t.main_node_id) 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 & ?) > ?) ORDER BY `sort_column_0` DESC LIMIT 200

Parameters:

[
  "/1/2/385/%"
  0
  97
  8
  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.path_string LIKE ?)
      AND (t.is_invisible = ?)
      AND (t.node_id = t.main_node_id)
      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 & ?) > ?
  )
ORDER BY
  `sort_column_0` DESC
LIMIT
  200

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.path_string LIKE '/1/2/385/%') AND (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (97)) 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 (8))) 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 200;

#	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	ContainerPxNxmxE\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\Layouts\Query\ContentByTopicHandler->getValues (line 109)
13	Netgen\Layouts\Collection\QueryType\QueryType->getValues (line 26)
14	Netgen\Layouts\Collection\Result\QueryRunner->runQuery (line 19)
15	Generator->valid (line 33)
16	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->runCollection (line 33)
17	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 44)
18	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
19	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
20	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
21	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
27	Netgen\Layouts\View\Renderer->renderValue (line 16)
28	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
29	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
30	Twig\Template->yield (line 402)
31	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
37	Netgen\Layouts\View\Renderer->renderValue (line 16)
38	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
39	__TwigTemplate_29de95ffc0e745990b99a6967ae2918f->block_content (line 86)
40	Twig\Template->yieldBlock (line 446)
41	Twig\Template->displayBlock (line 138)
42	Twig\Template->renderBlock (line 199)
43	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
44	Twig\Template->yield (line 402)
45	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
46	__TwigTemplate_29de95ffc0e745990b99a6967ae2918f->doDisplay (line 56)
47	Twig\Template->yield (line 402)
48	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
54	Netgen\Layouts\View\Renderer->renderValue (line 16)
55	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
56	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
59	Twig\Template->display (line 358)
60	Twig\Template->render (line 373)
61	Twig\TemplateWrapper->render (line 51)
62	Twig\Environment->render (line 333)
63	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
64	Netgen\Layouts\View\Renderer->renderValue (line 16)
65	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
66	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
67	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
68	Twig\Template->yieldBlock (line 446)
69	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
70	Twig\Template->yieldBlock (line 446)
71	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
72	Twig\Template->yield (line 402)
73	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
74	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
75	Twig\Template->yield (line 402)
76	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
77	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
78	Twig\Template->yield (line 402)
79	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
80	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
81	Twig\Template->yield (line 402)
82	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
83	Twig\Template->display (line 358)
84	Twig\Template->render (line 373)
85	Twig\TemplateWrapper->render (line 51)
86	Twig\Environment->render (line 333)
87	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
88	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
89	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
90	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
91	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
92	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
93	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
94	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
95	Symfony\Component\HttpKernel\Kernel->handle (line 193)
96	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
97	require_once (line 32)
98	require_once (line 5)

1.34 ms
(1.34%)

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 (t.is_invisible = ?) AND (t.node_id = t.main_node_id) 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/%"
  0
  97
  8
  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 (t.is_invisible = ?)
      AND (t.node_id = t.main_node_id)
      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 (t.is_invisible = 0) AND (t.node_id = t.main_node_id) AND (c.content_type_id IN (97)) 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 (8))) 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	ContainerPxNxmxE\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\Layouts\Query\ContentByTopicHandler->getCount (line 134)
14	Netgen\Layouts\Collection\QueryType\QueryType->getCount (line 31)
15	Netgen\Layouts\Collection\Result\QueryRunner->count (line 28)
16	Netgen\Layouts\Collection\Result\DynamicCollectionRunner->count (line 58)
17	Netgen\Layouts\Collection\Result\ResultBuilder->build (line 42)
18	Netgen\Layouts\Collection\Result\Pagerfanta\ResultBuilderAdapter->getSlice (line 50)
19	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
20	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
21	Netgen\Bundle\LayoutsBundle\EventListener\BlockView\GetCollectionResultsListener->onRenderView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Netgen\Layouts\View\ViewRenderer->renderView (line 24)
27	Netgen\Layouts\View\Renderer->renderValue (line 16)
28	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
29	__TwigTemplate_b1e9f14468b7ed83d75e794e9c4c89e8->doDisplay (line 74)
30	Twig\Template->yield (line 402)
31	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
37	Netgen\Layouts\View\Renderer->renderValue (line 16)
38	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderPlaceholder (line 196)
39	__TwigTemplate_29de95ffc0e745990b99a6967ae2918f->block_content (line 86)
40	Twig\Template->yieldBlock (line 446)
41	Twig\Template->displayBlock (line 138)
42	Twig\Template->renderBlock (line 199)
43	__TwigTemplate_0db4f230d6808f1e3588386ad9508580->doDisplay (line 141)
44	Twig\Template->yield (line 402)
45	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
46	__TwigTemplate_29de95ffc0e745990b99a6967ae2918f->doDisplay (line 56)
47	Twig\Template->yield (line 402)
48	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
54	Netgen\Layouts\View\Renderer->renderValue (line 16)
55	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderBlock (line 173)
56	__TwigTemplate_cd6b86efb22dc73fe5db142a3f00c581->doDisplay (line 56)
57	Twig\Template->yield (line 402)
58	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
59	Twig\Template->display (line 358)
60	Twig\Template->render (line 373)
61	Twig\TemplateWrapper->render (line 51)
62	Twig\Environment->render (line 333)
63	Netgen\Layouts\View\ViewRenderer->renderView (line 30)
64	Netgen\Layouts\View\Renderer->renderValue (line 16)
65	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderValue (line 120)
66	Netgen\Bundle\LayoutsBundle\Templating\Twig\Runtime\RenderingRuntime->renderZone (line 153)
67	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 115)
68	Twig\Template->yieldBlock (line 446)
69	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
70	Twig\Template->yieldBlock (line 446)
71	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
72	Twig\Template->yield (line 402)
73	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
74	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
75	Twig\Template->yield (line 402)
76	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
77	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
78	Twig\Template->yield (line 402)
79	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
80	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
81	Twig\Template->yield (line 402)
82	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
83	Twig\Template->display (line 358)
84	Twig\Template->render (line 373)
85	Twig\TemplateWrapper->render (line 51)
86	Twig\Environment->render (line 333)
87	Ibexa\Core\MVC\Symfony\View\Renderer\TemplateRenderer->render (line 53)
88	Ibexa\Bundle\Core\EventListener\ViewRendererListener->renderView (line 42)
89	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
90	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
91	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
92	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
93	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
94	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
95	Symfony\Component\HttpKernel\Kernel->handle (line 193)
96	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
97	require_once (line 32)
98	require_once (line 5)

1.14 ms
(1.13%)

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_34d8f148f0c282d29fb3a9958249c8c6::doGetParent (line 42)
15	Twig\Template->getParent (line 83)
16	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
17	Twig\Template->yield (line 402)
18	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

1.05 ms
(1.04%)

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 = 26) 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_28400fcb5c26a626d9a825e6ad7205af->block_layout (line 92)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->block_pagelayout_content (line 174)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_9056d46d7c1ff2caa53508a3e38fe12b->doDisplay (line 261)
19	Twig\Template->yield (line 402)
20	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
21	__TwigTemplate_c6dca76c5e334c06bf3a0c075c139e92->doDisplay (line 69)
22	Twig\Template->yield (line 402)
23	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
24	__TwigTemplate_28400fcb5c26a626d9a825e6ad7205af->doDisplay (line 55)
25	Twig\Template->yield (line 402)
26	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
27	__TwigTemplate_34d8f148f0c282d29fb3a9958249c8c6->doDisplay (line 67)
28	Twig\Template->yield (line 402)
29	Netgen\Bundle\SiteBundle\Templating\Twig\DebugTemplate->yield (line 38)
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 126)
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)

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://media.alpha.se7enx.com/running

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://media.alpha.se7enx.com/running

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