Symfony Profiler

Query Metrics

34 Database Queries

15 Different statements

6.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.16 ms
(31.66%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/montcaud/routes/de/newsletter"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/routes/de/newsletter') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
4	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
5	Jackalope\ObjectManager->getNodeByPath (line 228)
6	Jackalope\Session->getNode (line 78)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 241)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
19	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.23 ms
(18.08%)

SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC

Parameters:

[
  "/cmf/montcaud/routes/de/newsletter"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/montcaud/routes/de/newsletter'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1190)
2	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
3	Jackalope\ObjectManager->getNodeByPath (line 228)
4	Jackalope\Session->getNode (line 78)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
6	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 241)
7	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
8	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
9	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
16	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
17	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.62 ms
(9.03%)

SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?

Parameters:

[
  "6f3a60d3-71bf-4c67-9bf3-b97d3041846e"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  phpcr_nodes
WHERE
  identifier = ?
  AND workspace_name = ?

SELECT * FROM phpcr_nodes WHERE identifier = '6f3a60d3-71bf-4c67-9bf3-b97d3041846e' AND workspace_name = 'default_live';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 1407)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodeByIdentifier (line 536)
4	Jackalope\ObjectManager->getNodeByIdentifier (line 185)
5	Jackalope\Session->getNodeByIdentifier (line 63)
6	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 43)
8	Sulu\Component\DocumentManager\NodeManager->find (line 61)
9	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 34)
12	Sulu\Component\DocumentManager\DocumentManager->find (line 210)
13	Sulu\Component\Content\Mapper\ContentMapper->load (line 59)
14	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 155)
15	Sulu\Bundle\SnippetBundle\Content\SnippetContent->getSnippets (line 106)
16	Sulu\Bundle\SnippetBundle\Content\SnippetContent->getViewData (line 339)
17	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
18	Sulu\Component\Content\Types\BlockContentType->prepareData (line 336)
19	Sulu\Component\Content\Types\BlockContentType->getViewData (line 134)
20	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
21	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
23	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
24	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.55 ms
(8.01%)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)

Parameters:

[
  "default_live"
  "8cfdc2ce-302b-4143-90fc-91557506c129"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('8cfdc2ce-302b-4143-90fc-91557506c129');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1439)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesByIdentifier (line 581)
4	Jackalope\ObjectManager->getNodesByIdentifier (line 790)
5	Jackalope\Property->getReferencedNodes (line 424)
6	Jackalope\Property->getNode (line 211)
7	Jackalope\Property->getValue (line 763)
8	Jackalope\Node->getPropertyValue (line 253)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
19	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.46 ms
(6.73%)

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 1938)
3	Jackalope\Transport\DoctrineDBAL\Client->fetchUserNodeTypes (line 1889)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodeTypes (line 627)
5	Jackalope\ObjectManager->getNodeTypes (line 639)
6	Jackalope\ObjectManager->getNodeType (line 101)
7	Jackalope\NodeType\NodeTypeManager->fetchNodeTypes (line 219)
8	Jackalope\NodeType\NodeTypeManager->getNodeType (line 1287)
9	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
10	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
11	Jackalope\ObjectManager->getNodeByPath (line 228)
12	Jackalope\Session->getNode (line 78)
13	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
14	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 241)
15	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
16	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
17	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
18	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
19	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
20	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
21	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
22	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
23	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
24	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
25	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.25 ms
(3.61%)

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterRight"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2',
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterRight"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/montcaud/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterRight"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 570)
9	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.22 ms
(3.30%)

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterLeft"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2',
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterLeft"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/montcaud/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterLeft"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 543)
9	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.22 ms
(3.18%)

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

Parameters:

[
  "chateau-de-montcaud.ewm.dev/{localization}"
  "dev"
  "montcaud"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'chateau-de-montcaud.ewm.dev/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'montcaud' ORDER BY w0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 66)
7	Sulu\Bundle\WebsiteBundle\Entity\AnalyticsRepository->findByUrl (line 109)
8	Sulu\Bundle\WebsiteBundle\EventListener\AppendAnalyticsListener->onResponse (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 216)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.21 ms
(3.05%)

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="topNav"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2',
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="topNav"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/montcaud/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="topNav"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 257)
9	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.20 ms
(2.87%)

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ?) ORDER BY sort_order ASC

Parameters:

[
  "default_live"
  "/cmf/montcaud/contents/park"
  "/cmf/montcaud/contents/contact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/montcaud/contents/park' OR path = '/cmf/montcaud/contents/contact') ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1344)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
3	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
4	Jackalope\NodePathIterator->loadBatch (line 45)
5	Jackalope\NodePathIterator->__construct (line 243)
6	Jackalope\ObjectManager->getNodesByPath (line 252)
7	Jackalope\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
10	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
11	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
12	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
13	Sulu\Component\Cache\Memoize->memoizeById (line 51)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 121)
15	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.19 ms
(2.71%)

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="burgerNav"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2',
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="burgerNav"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/montcaud/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="burgerNav"]) > 0')) AND n0.path LIKE '/cmf/montcaud/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 121)
9	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
10	Twig\Template->yield (line 53)
11	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 320)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.15 ms
(2.20%)

SELECT 1 FROM phpcr_workspaces WHERE name = ?

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 400)
3	Jackalope\Transport\DoctrineDBAL\Client->workspaceExists (line 333)
4	Jackalope\Transport\DoctrineDBAL\Client->login (line 438)
5	Jackalope\Transport\DoctrineDBAL\Client->assertLoggedIn (line 1167)
6	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
7	Jackalope\ObjectManager->getNodeByPath (line 228)
8	Jackalope\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 241)
11	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
12	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
13	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
14	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
15	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
16	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
17	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
18	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
19	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
20	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
21	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.14 ms
(2.13%)

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC

Parameters:

[
  "default_live"
  "/cmf/montcaud/contents/gallery"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (path = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/montcaud/contents/gallery') ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1344)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
3	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
4	Jackalope\NodePathIterator->loadBatch (line 45)
5	Jackalope\NodePathIterator->__construct (line 243)
6	Jackalope\ObjectManager->getNodesByPath (line 252)
7	Jackalope\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
10	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
11	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
12	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
13	Sulu\Component\Cache\Memoize->memoizeById (line 51)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 257)
15	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
16	Twig\Template->yield (line 53)
17	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.13 ms
(1.84%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/montcaud/contents/park"
  "/cmf/montcaud/contents/contact"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents/park', '/cmf/montcaud/contents/contact') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1355)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
5	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
6	Jackalope\NodePathIterator->loadBatch (line 45)
7	Jackalope\NodePathIterator->__construct (line 243)
8	Jackalope\ObjectManager->getNodesByPath (line 252)
9	Jackalope\Session->getNodes (line 83)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
11	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
12	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
13	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 67)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->flatRootNavigationFunction (line 67)
15	Sulu\Component\Cache\Memoize->memoizeById (line 51)
16	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 121)
17	__TwigTemplate_fc6eec60029efb7b697dfb3771fa4399->doDisplay (line 387)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_afc48c206293fb1ebfe34ac6492d35f0->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
27	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
28	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.11 ms
(1.62%)

SELECT prefix, uri FROM phpcr_namespaces

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 517)
2	Jackalope\Transport\DoctrineDBAL\Client->getNamespacesObject (line 507)
3	Jackalope\Transport\DoctrineDBAL\Client->getNamespaces (line 502)
4	Jackalope\Transport\DoctrineDBAL\Client->getNamespacePrefixes (line 1168)
5	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
6	Jackalope\ObjectManager->getNodeByPath (line 228)
7	Jackalope\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 241)
10	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
11	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
12	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
13	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
14	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
15	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
16	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
17	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
18	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
19	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
20	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 69)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://chateau-de-montcaud.ewm.dev/de/newsletter

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping