Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

19.44 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.56 ms
(59.44%)

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->fetchFirstColumn (line 958)
2	Jackalope\Transport\DoctrineDBAL\Client->workspaceExists (line 416)
3	Jackalope\Transport\DoctrineDBAL\Client->login (line 349)
4	Jackalope\Transport\DoctrineDBAL\Client->assertLoggedIn (line 454)
5	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1183)
6	Jackalope\ObjectManager->getNodeByPath (line 189)
7	Jackalope\Session->getNode (line 228)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
10	Sulu\Component\DocumentManager\NodeManager->find (line 46)
11	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
12	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
13	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
16	Sulu\Component\CustomUrl\Manager\CustomUrlManager->findRouteByUrl (line 179)
17	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->matchCustomUrl (line 90)
18	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->process (line 71)
19	Sulu\Component\Webspace\Analyzer\RequestAnalyzer->analyze (line 43)
20	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
22	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	handle (line 69)

5.13 ms
(26.36%)

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

Parameters:

[
  "/cmf/website/custom-urls/routes/imagohealthsystems.com/sitemap"
  "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/website/custom-urls/routes/imagohealthsystems.com/sitemap'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1206)
2	Jackalope\ObjectManager->getNodeByPath (line 189)
3	Jackalope\Session->getNode (line 228)
4	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
6	Sulu\Component\DocumentManager\NodeManager->find (line 46)
7	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
8	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
12	Sulu\Component\CustomUrl\Manager\CustomUrlManager->findRouteByUrl (line 179)
13	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->matchCustomUrl (line 90)
14	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->process (line 71)
15	Sulu\Component\Webspace\Analyzer\RequestAnalyzer->analyze (line 43)
16	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
18	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	handle (line 69)

2.76 ms
(14.19%)

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	Jackalope\Transport\DoctrineDBAL\Client->getNamespacesObject (line 533)
2	Jackalope\Transport\DoctrineDBAL\Client->getNamespaces (line 523)
3	Jackalope\Transport\DoctrineDBAL\Client->getNamespacePrefixes (line 518)
4	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1184)
5	Jackalope\ObjectManager->getNodeByPath (line 189)
6	Jackalope\Session->getNode (line 228)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Component\DocumentManager\NodeManager->find (line 46)
10	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
11	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
15	Sulu\Component\CustomUrl\Manager\CustomUrlManager->findRouteByUrl (line 179)
16	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->matchCustomUrl (line 90)
17	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->process (line 71)
18	Sulu\Component\Webspace\Analyzer\RequestAnalyzer->analyze (line 43)
19	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
21	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	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.
Sulu\Bundle\FormBundle\Entity\Form	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup	No errors.
Sulu\Bundle\SecurityBundle\Entity\Role	No errors.
Sulu\Bundle\FormBundle\Entity\FormTranslation	No errors.
Sulu\Bundle\FormBundle\Entity\FormField	No errors.

Symfony Profiler

GET https://imagohealthsystems.com/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