Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.31 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.47 ms

SELECT c0_.path AS path_0, c0_.history AS history_1, c0_.uuid AS uuid_2, c0_.created AS created_3, c0_.changed AS changed_4, c0_.customUrl AS customUrl_5, c0_.target_route_uuid AS target_route_uuid_6 FROM cu_custom_url_route c0_ WHERE c0_.path = ? LIMIT 1

Parameters:

[
  "dev.prismx.eu/https%3A/dev.prismx.eu/nl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.path AS path_0,
  c0_.history AS history_1,
  c0_.uuid AS uuid_2,
  c0_.created AS created_3,
  c0_.changed AS changed_4,
  c0_.customUrl AS customUrl_5,
  c0_.target_route_uuid AS target_route_uuid_6
FROM
  cu_custom_url_route c0_
WHERE
  c0_.path = ?
LIMIT
  1

SELECT c0_.path AS path_0, c0_.history AS history_1, c0_.uuid AS uuid_2, c0_.created AS created_3, c0_.changed AS changed_4, c0_.customUrl AS customUrl_5, c0_.target_route_uuid AS target_route_uuid_6 FROM cu_custom_url_route c0_ WHERE c0_.path = 'dev.prismx.eu/https%3A/dev.prismx.eu/nl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Sulu\CustomUrl\Infrastructure\Doctrine\Repository\CustomUrlRouteRepository->findOneBy (line 42)
7	Sulu\CustomUrl\Application\Routing\CustomUrlRouteCollectionLoader->getRouteCollectionForRequest (line 62)
8	Sulu\Route\Infrastructure\SymfonyCmf\Routing\CmfRouteProvider->getRouteCollectionForRequest (line 39)
9	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
10	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
11	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
14	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
15	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
16	Symfony\Component\EventDispatcher\EventDispatcher->{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 246)
17	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	handle (line 69)

0.56 ms

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1

Parameters:

[
  "prismx"
  "nl"
  "/https%3A/dev.prismx.eu/nl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  (
    (
      r0_.webspace = ?
      OR r0_.webspace IS NULL
    )
  )
  AND r0_.locale = ?
  AND r0_.slug = ?
ORDER BY
  r0_.webspace DESC
LIMIT
  1

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = 'prismx' OR r0_.webspace IS NULL)) AND r0_.locale = 'nl' AND r0_.slug = '/https%3A/dev.prismx.eu/nl' ORDER BY r0_.webspace DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Sulu\Route\Infrastructure\Doctrine\Repository\RouteRepository->findFirstBy (line 81)
7	Sulu\Route\Application\Routing\Matcher\RouteCollectionForRequestRouteLoader->getRouteCollectionForRequest (line 85)
8	Sulu\Route\Infrastructure\SymfonyCmf\Routing\CmfRouteProvider->getRouteCollectionForRequest (line 39)
9	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
10	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
11	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
14	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->matchUrl (line 178)
15	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->matchRoute (line 162)
16	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->redirectPartialMatch (line 146)
17	Symfony\Component\EventDispatcher\EventDispatcher->{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 246)
18	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	handle (line 69)

0.28 ms

SELECT c0_.path AS path_0, c0_.history AS history_1, c0_.uuid AS uuid_2, c0_.created AS created_3, c0_.changed AS changed_4, c0_.customUrl AS customUrl_5, c0_.target_route_uuid AS target_route_uuid_6 FROM cu_custom_url_route c0_ WHERE c0_.path = ? LIMIT 1

Parameters:

[
  "dev.prismx.eu/nl/https%3A/dev.prismx.eu/nl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.path AS path_0,
  c0_.history AS history_1,
  c0_.uuid AS uuid_2,
  c0_.created AS created_3,
  c0_.changed AS changed_4,
  c0_.customUrl AS customUrl_5,
  c0_.target_route_uuid AS target_route_uuid_6
FROM
  cu_custom_url_route c0_
WHERE
  c0_.path = ?
LIMIT
  1

SELECT c0_.path AS path_0, c0_.history AS history_1, c0_.uuid AS uuid_2, c0_.created AS created_3, c0_.changed AS changed_4, c0_.customUrl AS customUrl_5, c0_.target_route_uuid AS target_route_uuid_6 FROM cu_custom_url_route c0_ WHERE c0_.path = 'dev.prismx.eu/nl/https%3A/dev.prismx.eu/nl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Sulu\CustomUrl\Infrastructure\Doctrine\Repository\CustomUrlRouteRepository->findOneBy (line 42)
7	Sulu\CustomUrl\Application\Routing\CustomUrlRouteCollectionLoader->getRouteCollectionForRequest (line 62)
8	Sulu\Route\Infrastructure\SymfonyCmf\Routing\CmfRouteProvider->getRouteCollectionForRequest (line 39)
9	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
10	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
11	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
14	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->matchUrl (line 178)
15	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->matchRoute (line 162)
16	Sulu\Bundle\WebsiteBundle\EventListener\RedirectExceptionSubscriber->redirectPartialMatch (line 146)
17	Symfony\Component\EventDispatcher\EventDispatcher->{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 246)
18	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	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\Route\Domain\Model\Route	No errors.
Sulu\Page\Domain\Model\Page	No errors.
Sulu\Bundle\ReferenceBundle\Domain\Model\Reference	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Page\Domain\Model\PageDimensionContent	No errors.
Sulu\CustomUrl\Domain\Model\CustomUrlRoute	No errors.
Sulu\CustomUrl\Domain\Model\CustomUrl	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Article\Domain\Model\Article	No errors.
Sulu\Article\Domain\Model\ArticleDimensionContent	No errors.
Sulu\Snippet\Domain\Model\Snippet	No errors.
Sulu\Snippet\Domain\Model\SnippetDimensionContent	No errors.
Sulu\Snippet\Domain\Model\SnippetArea	No errors.

Symfony Profiler

GET https://dev.prismx.eu/https%3A/dev.prismx.eu/nl

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping