Symfony Profiler

Query Metrics

54 Database Queries

13 Different statements

22.44 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.14 ms
(14.01%)

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 (n0.path LIKE '/cmf/aeron/contents/%' OR n0.path = '/cmf/aeron/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 (
    n0.path LIKE '/cmf/aeron/contents/%'
    OR n0.path = '/cmf/aeron/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 (n0.path LIKE '/cmf/aeron/contents/%' OR n0.path = '/cmf/aeron/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 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
6	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
7	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
8	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
9	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
10	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.81 ms
(12.53%)

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 (n0.path LIKE '/cmf/ergon/contents/%' OR n0.path = '/cmf/ergon/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 (
    n0.path LIKE '/cmf/ergon/contents/%'
    OR n0.path = '/cmf/ergon/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 (n0.path LIKE '/cmf/ergon/contents/%' OR n0.path = '/cmf/ergon/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 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
6	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
7	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
8	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
9	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
10	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.49 ms
(11.09%)

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 (n0.path LIKE '/cmf/cago/contents/%' OR n0.path = '/cmf/cago/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 (
    n0.path LIKE '/cmf/cago/contents/%'
    OR n0.path = '/cmf/cago/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 (n0.path LIKE '/cmf/cago/contents/%' OR n0.path = '/cmf/cago/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 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
6	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
7	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
8	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
9	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
10	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.47 ms
(10.99%)

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 (n0.path LIKE '/cmf/terry/contents/%' OR n0.path = '/cmf/terry/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 (
    n0.path LIKE '/cmf/terry/contents/%'
    OR n0.path = '/cmf/terry/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 (n0.path LIKE '/cmf/terry/contents/%' OR n0.path = '/cmf/terry/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 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
6	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
7	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
8	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
9	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
10	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.46 ms
(10.95%)

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 (n0.path LIKE '/cmf/website/contents/%' OR n0.path = '/cmf/website/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 (
    n0.path LIKE '/cmf/website/contents/%'
    OR n0.path = '/cmf/website/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 (n0.path LIKE '/cmf/website/contents/%' OR n0.path = '/cmf/website/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 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
6	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
7	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
8	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
9	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
10	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.60 ms
(7.12%)

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 n0.parent = '/cmf/aeron/contents' LIMIT 1

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 n0.parent = '/cmf/aeron/contents'
LIMIT
  1

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 n0.parent = '/cmf/aeron/contents' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.55 ms
(6.92%)

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 n0.parent = '/cmf/ergon/contents' LIMIT 1

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 n0.parent = '/cmf/ergon/contents'
LIMIT
  1

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 n0.parent = '/cmf/ergon/contents' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.42 ms
(6.33%)

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 n0.parent = '/cmf/website/contents' LIMIT 1

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 n0.parent = '/cmf/website/contents'
LIMIT
  1

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 n0.parent = '/cmf/website/contents' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.36 ms
(6.06%)

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 n0.parent = '/cmf/terry/contents' LIMIT 1

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 n0.parent = '/cmf/terry/contents'
LIMIT
  1

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 n0.parent = '/cmf/terry/contents' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.33 ms
(5.95%)

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 n0.parent = '/cmf/cago/contents' LIMIT 1

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 n0.parent = '/cmf/cago/contents'
LIMIT
  1

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 n0.parent = '/cmf/cago/contents' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.84 ms
(3.73%)

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 2154)
6	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
7	Jackalope\Query\Query->execute (line 436)
8	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
10	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
11	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
12	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
13	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
14	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.76 ms
(3.36%)

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 238)
8	Jackalope\NodeType\NodeTypeManager->hasNodeType (line 179)
9	Jackalope\Transport\DoctrineDBAL\Query\QOMWalker->validateSelectorSource (line 161)
10	Jackalope\Transport\DoctrineDBAL\Query\QOMWalker->validateSource (line 100)
11	Jackalope\Transport\DoctrineDBAL\Query\QOMWalker->walkQOMQuery (line 2170)
12	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
13	Jackalope\Query\Query->execute (line 436)
14	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
15	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
16	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
17	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
18	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
19	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
20	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->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
(0.97%)

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 2169)
4	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
5	Jackalope\Query\Query->execute (line 436)
6	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
7	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 264)
8	Sulu\Component\Content\Repository\ContentRepository->findAllByPortal (line 55)
9	Sulu\Bundle\PageBundle\Sitemap\PagesSitemapProvider->build (line 62)
10	Sulu\Bundle\WebsiteBundle\Sitemap\XmlSitemapRenderer->renderSitemap (line 179)
11	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->sitemapPaginatedAction (line 114)
12	Sulu\Bundle\WebsiteBundle\Controller\SitemapController->indexAction (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	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.

Managed Entities

default entity manager

Class	Amount of managed objects

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.

Symfony Profiler

GET https://staging.focused-blackburn.217-160-36-56.plesk.page/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping