Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

7.77 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.81 ms
(49.09%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1

Parameters:

[
  "helfen"
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.slug AS slug_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  page_translation t0
WHERE
  t0.slug = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.slug = 'helfen' AND t0.locale = 'de' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Repository\PageTranslationRepository->fromQueryParams (line 45)
7	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 116)
8	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 59)
9	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 240)
10	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 65)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
13	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

2.05 ms
(26.37%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.slug AS slug_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM page_translation t0 WHERE t0.translatable_id = 7;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
7	Doctrine\ORM\PersistentCollection->initialize (line 186)
8	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
9	Doctrine\ORM\PersistentCollection->get (line 380)
10	App\Entity\Page->findTranslationByLocale (line 190)
11	App\Entity\Page->doTranslate (line 138)
12	App\Entity\Page->translate (line 75)
13	App\Entity\PageTranslation->getEnglishSlug (line 111)
14	App\Controller\Localized\PageController->index (line 32)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

1.91 ms
(24.54%)

SELECT t0.id AS id_1, t0.is_public AS is_public_2 FROM page t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_public AS is_public_2
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_public AS is_public_2 FROM page t0 WHERE t0.id = 7;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
6	Proxies\__CG__\App\Entity\Page::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
8	Proxies\__CG__\App\Entity\Page->__get (line 153)
9	App\Entity\Page->getTranslations (line 20)
10	App\Entity\Page->findTranslationByLocale (line 189)
11	App\Entity\Page->doTranslate (line 138)
12	App\Entity\Page->translate (line 75)
13	App\Entity\PageTranslation->getEnglishSlug (line 111)
14	App\Controller\Localized\PageController->index (line 32)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

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\PageTranslation	4
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/de/page/helfen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping