Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

10.83 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.65 ms

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.email AS email_1,
  s0_.url AS url_2,
  s0_.country AS country_3,
  s0_.locale AS locale_4,
  s0_.currency AS currency_5,
  s0_.order_base_number AS order_base_number_6,
  s0_.order_email AS order_email_7,
  s0_.id AS id_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  store s0_
ORDER BY
  s0_.id ASC

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Repository\StoreRepository->findAll (line 56)
8	App\Context\StoreContext->getStores (line 88)
9	App\Context\StoreContext->getStoreByHost (line 44)
10	App\EventSubscriber\ResolveStoreSubscriber->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 30)

0.30 ms

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = ? AND s0_.locale IN (?, ?)

Parameters:

[
  "klimaanlage-daikin-comfora-2-0-kw-ftxp20n9-rxp20n9-wandgerat%E2%80%A6"
  "de_AT"
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.slug = ?
  AND s0_.locale IN (?, ?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = 'klimaanlage-daikin-comfora-2-0-kw-ftxp20n9-rxp20n9-wandgerat%E2%80%A6' AND s0_.locale IN ('de_AT', 'de');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Repository\SlugRepository->findOneBySlugAndLocale (line 81)
8	App\Routing\RouteProvider->findSlugsByCandidate (line 36)
9	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 30)

9.88 ms

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.previous_slug = ? AND s0_.locale IN (?, ?)

Parameters:

[
  "klimaanlage-daikin-comfora-2-0-kw-ftxp20n9-rxp20n9-wandgerat%E2%80%A6"
  "de_AT"
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.previous_slug = ?
  AND s0_.locale IN (?, ?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.previous_slug = 'klimaanlage-daikin-comfora-2-0-kw-ftxp20n9-rxp20n9-wandgerat%E2%80%A6' AND s0_.locale IN ('de_AT', 'de');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 62)
7	App\Repository\SlugRepository->findOneByPreviousSlugAndLocale (line 90)
8	App\Routing\RouteProvider->findOldRouteByCandidate (line 85)
9	App\Routing\RouteProvider->findSlugsByCandidate (line 36)
10	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
11	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
12	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
13	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
14	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
15	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
16	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 30)

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
App\Entity\Store	5

Entities Mapping

Class	Mapping errors
App\Entity\Store	No errors.
App\Entity\TaxRate	No errors.
App\Entity\Slug	No errors.

Symfony Profiler

GET https://sandbox.klimapro.at/klimaanlage-daikin-comfora-2-0-kw-ftxp20n9-rxp20n9-wandgerat%E2%80%A6

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping