Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

18.37 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.42 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.is_wide AS is_wide_3, t0.thumbnail_name AS thumbnail_name_4, t0.thumbnail_background AS thumbnail_background_5, t0.project_id AS project_id_6, t0.is_expert AS is_expert_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM media t0 WHERE t0.id = ?

Parameters:

[
  809
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.is_wide AS is_wide_3,
  t0.thumbnail_name AS thumbnail_name_4,
  t0.thumbnail_background AS thumbnail_background_5,
  t0.project_id AS project_id_6,
  t0.is_expert AS is_expert_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.is_wide AS is_wide_3, t0.thumbnail_name AS thumbnail_name_4, t0.thumbnail_background AS thumbnail_background_5, t0.project_id AS project_id_6, t0.is_expert AS is_expert_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM media t0 WHERE t0.id = 809;

#	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\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	App\Repository\MediaTranslationRepository->fromQueryParams (line 39)
9	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 116)
10	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 59)
11	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 240)
12	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 65)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
15	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

13.95 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.legends AS legends_4, t0.goals AS goals_5, t0.more AS more_6, t0.scenario AS scenario_7, t0.features AS features_8, t0.published_at AS published_at_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM media_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  809
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.legends AS legends_4,
  t0.goals AS goals_5,
  t0.more AS more_6,
  t0.scenario AS scenario_7,
  t0.features AS features_8,
  t0.published_at AS published_at_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  media_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.legends AS legends_4, t0.goals AS goals_5, t0.more AS more_6, t0.scenario AS scenario_7, t0.features AS features_8, t0.published_at AS published_at_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM media_translation t0 WHERE t0.translatable_id = 809;

#	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\Media->findTranslationByLocale (line 190)
11	App\Entity\Media->doTranslate (line 138)
12	App\Entity\Media->traitTranslate (line 75)
13	App\Entity\Media->translate (line 290)
14	App\Repository\MediaTranslationRepository->fromQueryParams (line 45)
15	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 116)
16	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 59)
17	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->findViaExpression (line 240)
18	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 65)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
20	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
21	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	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\MediaTranslation	6
App\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Entity\Media	No errors.
App\Entity\MediaTranslation	No errors.
App\Entity\NodeMedia	No errors.
App\Entity\TranslationJobItem	No errors.
App\Entity\Node	No errors.
App\Entity\TranslationJob	No errors.
App\Entity\NodeTranslation	No errors.
App\Entity\User	No errors.
App\Entity\Bookmark	No errors.
App\Entity\CaptureObjectData	No errors.
App\Entity\Capture	No errors.
App\Entity\Comment	No errors.
App\Entity\ConnectorIdentifier	No errors.
App\Entity\Favorite	No errors.
App\Entity\FavoriteDirectory	No errors.
App\Entity\File	No errors.
App\Entity\InstitutionAddress	No errors.
App\Entity\Institution	No errors.
App\Entity\InstitutionContact	No errors.
App\Entity\InstitutionGroupContact	No errors.
App\Entity\InstitutionGroup	No errors.
App\Entity\MarketingCampaign	No errors.
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.
App\Entity\PastCode	No errors.
App\Entity\Price	No errors.
App\Entity\PriceSnapshot	No errors.
App\Entity\Purchase	No errors.
App\Entity\Tag	No errors.
App\Entity\Tagging	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Algolia\SearchBundle\Entity\Aggregator	No errors.

Symfony Profiler

GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/de/media/809-media

Configuration Settings

Theme

Page Width