Symfony Profiler

Query Metrics

11 Database Queries

6 Different statements

1.86 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.56 ms
(30.24%)

SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?

Parameters:

[
  "/"
  "sitemap.xml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'sitemap.xml';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	Pimcore\Model\Document\Dao->getByPath (line 62)
3	Pimcore\Model\Document->getByPath (line 153)
4	Pimcore\Routing\Dynamic\DocumentRouteHandler::matchRequest (line 105)
5	Pimcore\Routing\DynamicRouteProvider->getRouteCollectionForRequest (line 75)
6	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
7	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
8	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
9	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
10	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
11	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 105)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 19)

0.52 ms
(27.70%)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)

Parameters:

[
  1781019639
  "site_domain_ecd79c24c39d1f74476a7ddce3783096"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781019639 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_ecd79c24c39d1f74476a7ddce3783096');

#	File/Call
1	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doFetch (line 174)
2	Symfony\Component\Cache\Adapter\AbstractAdapter->generateItems (line 305)
3	Symfony\Component\Cache\Adapter\TagAwareAdapter->getItems (line 166)
4	Symfony\Component\Cache\Adapter\TagAwareAdapter->getItem (line 136)
5	Pimcore\Cache\Core\CoreCacheHandler->getItem (line 266)
6	Pimcore\Cache\Core\CoreCacheHandler->load (line 248)
7	Pimcore\Cache->load (line 70)
8	Pimcore\Model\Site::getByDomain (line 111)
9	Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener::resolveSite (line 112)
10	Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener->onKernelRequest (line 83)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 208)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 19)

0.29 ms
(15.73%)

SELECT id FROM documents_page WHERE prettyUrl = ?

Parameters:

[
  "/sitemap.xml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/sitemap.xml';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	Pimcore\Model\Document\Dao->getByPath (line 68)
3	Pimcore\Model\Document->getByPath (line 153)
4	Pimcore\Routing\Dynamic\DocumentRouteHandler::matchRequest (line 105)
5	Pimcore\Routing\DynamicRouteProvider->getRouteCollectionForRequest (line 75)
6	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
7	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
8	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
9	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
10	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
11	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 105)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 19)

0.22 ms
(11.60%)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)

Parameters:

[
  1781019639
  "system\x01tags\x01"
  "site\x01tags\x01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781019639 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');

#	File/Call
1	Symfony\Component\Cache\Adapter\DoctrineDbalAdapter->doFetch (line 174)
2	Symfony\Component\Cache\Adapter\AbstractAdapter->generateItems (line 305)
3	Symfony\Component\Cache\Adapter\TagAwareAdapter->getTagVersions (line 355)
4	Symfony\Component\Cache\Adapter\TagAwareAdapter->getItems (line 187)
5	Symfony\Component\Cache\Adapter\TagAwareAdapter->getItem (line 136)
6	Pimcore\Cache\Core\CoreCacheHandler->getItem (line 266)
7	Pimcore\Cache\Core\CoreCacheHandler->load (line 248)
8	Pimcore\Cache->load (line 70)
9	Pimcore\Model\Site::getByDomain (line 111)
10	Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener::resolveSite (line 112)
11	Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener->onKernelRequest (line 83)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 19)

0.16 ms
(8.71%)

SELECT * FROM tmp_store WHERE id = ?

Parameters:

[
  "maintenance_mode"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	Pimcore\Model\Tool\TmpStore\Dao->getById (line 59)
3	call_user_func_array (line 220)
4	Pimcore\Model\AbstractModel::__call (line 220)
5	Pimcore\Model\Tool\TmpStore->get (line 117)
6	Pimcore\Tool\MaintenanceModeHelper::getEntry (line 82)
7	Pimcore\Tool\MaintenanceModeHelper->isActive (line 65)
8	Pimcore\Bundle\CoreBundle\EventListener\MaintenancePageListener->onKernelRequest (line 87)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 208)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 19)

0.11 ms
(6.02%)

SELECT * FROM object_url_slugs WHERE slug = '/sitemap.xml' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/sitemap.xml'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/sitemap.xml' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	Pimcore\Model\DataObject\Data\UrlSlug->resolveSlug (line 228)
3	Pimcore\Routing\Dynamic\DataObjectRouteHandler::matchRequest (line 63)
4	Pimcore\Routing\DynamicRouteProvider->getRouteCollectionForRequest (line 75)
5	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
6	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
7	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
8	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
9	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
10	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 105)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 208)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 19)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET http://mtr-devnew.credencys.net/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

Entities Mapping