Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.48 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.29 ms

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)

0.51 ms

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)

0.53 ms

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)

1.14 ms

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->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
11	Sulu\Component\CustomUrl\Manager\CustomUrlManager->findRouteByUrl (line 179)
12	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->matchCustomUrl (line 90)
13	Sulu\Bundle\CustomUrlBundle\Request\CustomUrlRequestProcessor->process (line 71)
14	Sulu\Component\Webspace\Analyzer\RequestAnalyzer->analyze (line 43)
15	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
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->handleThrowable (line 241)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	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.

Symfony Profiler

GET https://imagohealthsystems.com/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping