Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

51.91 ms Query time

0 Invalid entities

1410 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.28 ms
(41.00%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.locale = ? AND m0_.status = ?

Parameters:

[
  1010
  301
  375
  231
  314
  319
  380
  519
  568
  691
  696
  734
  785
  53
  122
  321
  636
  673
  807
  130
  256
  348
  358
  374
  543
  787
  795
  6
  23
  29
  79
  153
  155
  178
  235
  463
  474
  478
  547
  823
  820
  834
  921
  9
  14
  18
  32
  44
  61
  148
  373
  480
  497
  518
  551
  680
  781
  804
  936
  8
  "es"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.legends AS legends_3,
  m0_.goals AS goals_4,
  m0_.more AS more_5,
  m0_.scenario AS scenario_6,
  m0_.features AS features_7,
  m0_.published_at AS published_at_8,
  m0_.status AS status_9,
  m0_.created_at AS created_at_10,
  m0_.updated_at AS updated_at_11,
  m0_.locale AS locale_12,
  m1_.id AS id_13,
  m1_.type AS type_14,
  m1_.is_wide AS is_wide_15,
  m1_.thumbnail_name AS thumbnail_name_16,
  m1_.thumbnail_background AS thumbnail_background_17,
  m1_.project_id AS project_id_18,
  m1_.is_expert AS is_expert_19,
  m1_.created_at AS created_at_20,
  m1_.updated_at AS updated_at_21,
  m0_.translatable_id AS translatable_id_22
FROM
  media_translation m0_
  INNER JOIN media m1_ ON m0_.translatable_id = m1_.id
WHERE
  m1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND m0_.locale = ?
  AND m0_.status = ?

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (1010, 301, 375, 231, 314, 319, 380, 519, 568, 691, 696, 734, 785, 53, 122, 321, 636, 673, 807, 130, 256, 348, 358, 374, 543, 787, 795, 6, 23, 29, 79, 153, 155, 178, 235, 463, 474, 478, 547, 823, 820, 834, 921, 9, 14, 18, 32, 44, 61, 148, 373, 480, 497, 518, 551, 680, 781, 804, 936, 8) AND m0_.locale = 'es' AND m0_.status = 'published';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\MediaTranslationRepository->fromMediaIds (line 78)
9	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getMediaWallData():66} (line 82)
10	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
12	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
13	Symfony\Component\Cache\LockRegistry::compute (line 113)
14	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
15	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
16	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
17	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
18	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
19	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
20	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
21	App\Service\CacheService->getCached (line 71)
22	App\Service\CacheService->getData (line 31)
23	App\Service\ShowcaseService->getMediaWallData (line 60)
24	App\Twig\Components\Store\Showcase->getMediaWallData (line 25)
25	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 53)
26	Twig\Extension\CoreExtension->getAttribute (line 1918)
27	__TwigTemplate_e17dfc38e750e204c65eddf3aa7b1b7e::doDisplay (line 53)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
32	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
33	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
34	__TwigTemplate_56857071deec32baa4e70571b59f5b08->block_body (line 229)
35	Twig\Template->yieldBlock (line 456)
36	__TwigTemplate_b6e9da5b7716a05720e7bd7de44aeed8->doDisplay (line 113)
37	Twig\Template->yield (line 411)
38	__TwigTemplate_56857071deec32baa4e70571b59f5b08->doDisplay (line 58)
39	Twig\Template->yield (line 411)
40	Twig\Template->display (line 366)
41	Twig\Template->render (line 381)
42	Twig\TemplateWrapper->render (line 51)
43	Twig\Environment->render (line 333)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
47	App\Controller\Localized\DefaultController->index (line 46)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 193)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 32)
53	require_once (line 5)

13.88 ms
(26.74%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.locale = ? AND m0_.status = ?

Parameters:

[
  976
  981
  194
  974
  977
  973
  922
  900
  825
  132
  93
  562
  "es"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.legends AS legends_3,
  m0_.goals AS goals_4,
  m0_.more AS more_5,
  m0_.scenario AS scenario_6,
  m0_.features AS features_7,
  m0_.published_at AS published_at_8,
  m0_.status AS status_9,
  m0_.created_at AS created_at_10,
  m0_.updated_at AS updated_at_11,
  m0_.locale AS locale_12,
  m1_.id AS id_13,
  m1_.type AS type_14,
  m1_.is_wide AS is_wide_15,
  m1_.thumbnail_name AS thumbnail_name_16,
  m1_.thumbnail_background AS thumbnail_background_17,
  m1_.project_id AS project_id_18,
  m1_.is_expert AS is_expert_19,
  m1_.created_at AS created_at_20,
  m1_.updated_at AS updated_at_21,
  m0_.translatable_id AS translatable_id_22
FROM
  media_translation m0_
  INNER JOIN media m1_ ON m0_.translatable_id = m1_.id
WHERE
  m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND m0_.locale = ?
  AND m0_.status = ?

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m1_.id AS id_13, m1_.type AS type_14, m1_.is_wide AS is_wide_15, m1_.thumbnail_name AS thumbnail_name_16, m1_.thumbnail_background AS thumbnail_background_17, m1_.project_id AS project_id_18, m1_.is_expert AS is_expert_19, m1_.created_at AS created_at_20, m1_.updated_at AS updated_at_21, m0_.translatable_id AS translatable_id_22 FROM media_translation m0_ INNER JOIN media m1_ ON m0_.translatable_id = m1_.id WHERE m1_.id IN (976, 981, 194, 974, 977, 973, 922, 900, 825, 132, 93, 562) AND m0_.locale = 'es' AND m0_.status = 'published';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\MediaTranslationRepository->fromMediaIds (line 78)
9	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getIntroMedia():103} (line 116)
10	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
12	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
13	Symfony\Component\Cache\LockRegistry::compute (line 113)
14	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
15	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
16	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
17	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
18	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
19	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
20	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
21	App\Service\CacheService->getCached (line 71)
22	App\Service\CacheService->getData (line 31)
23	App\Service\ShowcaseService->getIntroMedia (line 97)
24	App\Controller\Localized\DefaultController->index (line 47)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

6.37 ms
(12.27%)

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.locale AS locale_2,
  n0_.translatable_id AS translatable_id_3
FROM
  node_translation n0_
WHERE
  n0_.translatable_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.locale AS locale_2, n0_.translatable_id AS translatable_id_3 FROM node_translation n0_ WHERE n0_.translatable_id IN (106, 112, 136, 409, 408, 407, 406, 405, 135, 413, 412, 411, 410, 111, 137, 134, 133, 140, 132, 110, 131, 130, 139, 129, 128, 138, 109, 127, 126, 125, 242, 123, 108, 122, 121, 107, 244, 120, 119, 118, 117, 115);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	App\Service\TranslatableService->cacheNodeTranslations (line 63)
8	App\Service\TreeService->addNodeTranslations (line 173)
9	App\Service\TreeService->hierarchyDataToCollection (line 74)
10	App\Service\TreeService->getHierarchy (line 45)
11	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getMediaWallData():66} (line 76)
12	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
14	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
15	Symfony\Component\Cache\LockRegistry::compute (line 113)
16	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
17	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
18	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
19	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
20	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
21	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
22	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
23	App\Service\CacheService->getCached (line 71)
24	App\Service\CacheService->getData (line 31)
25	App\Service\ShowcaseService->getMediaWallData (line 60)
26	App\Twig\Components\Store\Showcase->getMediaWallData (line 25)
27	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 53)
28	Twig\Extension\CoreExtension->getAttribute (line 1918)
29	__TwigTemplate_e17dfc38e750e204c65eddf3aa7b1b7e::doDisplay (line 53)
30	Twig\Template->yield (line 411)
31	Twig\Template->display (line 366)
32	Twig\Template->render (line 381)
33	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
34	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
35	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
36	__TwigTemplate_56857071deec32baa4e70571b59f5b08->block_body (line 229)
37	Twig\Template->yieldBlock (line 456)
38	__TwigTemplate_b6e9da5b7716a05720e7bd7de44aeed8->doDisplay (line 113)
39	Twig\Template->yield (line 411)
40	__TwigTemplate_56857071deec32baa4e70571b59f5b08->doDisplay (line 58)
41	Twig\Template->yield (line 411)
42	Twig\Template->display (line 366)
43	Twig\Template->render (line 381)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
49	App\Controller\Localized\DefaultController->index (line 46)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 193)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
54	require_once (line 32)
55	require_once (line 5)

4.45 ms
(8.57%)

SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.node_id AS node_id_2, n0_.media_id AS media_id_3 FROM node_media n0_ WHERE n0_.node_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.position AS position_1,
  n0_.node_id AS node_id_2,
  n0_.media_id AS media_id_3
FROM
  node_media n0_
WHERE
  n0_.node_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.node_id AS node_id_2, n0_.media_id AS media_id_3 FROM node_media n0_ WHERE n0_.node_id IN (106, 112, 136, 409, 408, 407, 406, 405, 135, 413, 412, 411, 410, 111, 137, 134, 133, 140, 132, 110, 131, 130, 139, 129, 128, 138, 109, 127, 126, 125, 242, 123, 108, 122, 121, 107, 244, 120, 119, 118, 117, 115);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	App\Repository\NodeMediaRepository->findByNodeIds (line 48)
8	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getMediaWallData():66} (line 78)
9	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
11	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
12	Symfony\Component\Cache\LockRegistry::compute (line 113)
13	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
14	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
15	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
16	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
17	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
18	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
19	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
20	App\Service\CacheService->getCached (line 71)
21	App\Service\CacheService->getData (line 31)
22	App\Service\ShowcaseService->getMediaWallData (line 60)
23	App\Twig\Components\Store\Showcase->getMediaWallData (line 25)
24	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 53)
25	Twig\Extension\CoreExtension->getAttribute (line 1918)
26	__TwigTemplate_e17dfc38e750e204c65eddf3aa7b1b7e::doDisplay (line 53)
27	Twig\Template->yield (line 411)
28	Twig\Template->display (line 366)
29	Twig\Template->render (line 381)
30	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
31	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
32	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
33	__TwigTemplate_56857071deec32baa4e70571b59f5b08->block_body (line 229)
34	Twig\Template->yieldBlock (line 456)
35	__TwigTemplate_b6e9da5b7716a05720e7bd7de44aeed8->doDisplay (line 113)
36	Twig\Template->yield (line 411)
37	__TwigTemplate_56857071deec32baa4e70571b59f5b08->doDisplay (line 58)
38	Twig\Template->yield (line 411)
39	Twig\Template->display (line 366)
40	Twig\Template->render (line 381)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
46	App\Controller\Localized\DefaultController->index (line 46)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 193)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
51	require_once (line 32)
52	require_once (line 5)

4.08 ms
(7.85%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.root AS root_5,
  t0.lvl AS lvl_6,
  t0.lft AS lft_7,
  t0.rgt AS rgt_8,
  t0.status AS status_9,
  t0.parent_id AS parent_id_10
FROM
  node t0
WHERE
  t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.parent_id IS NULL;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
5	Doctrine\ORM\EntityRepository->findBy (line 110)
6	App\Repository\NodeRepository->findRootNodes (line 39)
7	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getMediaWallData():66} (line 67)
8	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
10	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
11	Symfony\Component\Cache\LockRegistry::compute (line 113)
12	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
13	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
14	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
15	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
16	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
17	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
18	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
19	App\Service\CacheService->getCached (line 71)
20	App\Service\CacheService->getData (line 31)
21	App\Service\ShowcaseService->getMediaWallData (line 60)
22	App\Twig\Components\Store\Showcase->getMediaWallData (line 25)
23	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 53)
24	Twig\Extension\CoreExtension->getAttribute (line 1918)
25	__TwigTemplate_e17dfc38e750e204c65eddf3aa7b1b7e::doDisplay (line 53)
26	Twig\Template->yield (line 411)
27	Twig\Template->display (line 366)
28	Twig\Template->render (line 381)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
32	__TwigTemplate_56857071deec32baa4e70571b59f5b08->block_body (line 229)
33	Twig\Template->yieldBlock (line 456)
34	__TwigTemplate_b6e9da5b7716a05720e7bd7de44aeed8->doDisplay (line 113)
35	Twig\Template->yield (line 411)
36	__TwigTemplate_56857071deec32baa4e70571b59f5b08->doDisplay (line 58)
37	Twig\Template->yield (line 411)
38	Twig\Template->display (line 366)
39	Twig\Template->render (line 381)
40	Twig\TemplateWrapper->render (line 51)
41	Twig\Environment->render (line 333)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
45	App\Controller\Localized\DefaultController->index (line 46)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 193)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
50	require_once (line 32)
51	require_once (line 5)

1.86 ms
(3.58%)

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 84 AND n0_.lft > 1 AND n0_.root = ?) OR n0_.id = ? ORDER BY n0_.root ASC, n0_.lft ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.slug AS slug_1,
  n0_.created_at AS created_at_2,
  n0_.updated_at AS updated_at_3,
  n0_.root AS root_4,
  n0_.lvl AS lvl_5,
  n0_.lft AS lft_6,
  n0_.rgt AS rgt_7,
  n0_.status AS status_8
FROM
  node n0_
WHERE
  (
    n0_.rgt < 84
    AND n0_.lft > 1
    AND n0_.root = ?
  )
  OR n0_.id = ?
ORDER BY
  n0_.root ASC,
  n0_.lft ASC

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8 FROM node n0_ WHERE (n0_.rgt < 84 AND n0_.lft > 1 AND n0_.root = 106) OR n0_.id = 106 ORDER BY n0_.root ASC, n0_.lft ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
8	Gedmo\Tree\Entity\Repository\NestedTreeRepository->getNodesHierarchy (line 1085)
9	Gedmo\Tree\RepositoryUtils->childrenHierarchy (line 88)
10	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->childrenHierarchy (line 138)
11	App\Service\TreeService->getHierarchy (line 39)
12	App\Service\ShowcaseService->{closure:App\Service\ShowcaseService::getMediaWallData():66} (line 76)
13	App\Service\CacheService->{closure:App\Service\CacheService::getCached():71} (line 75)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
15	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace::{closure:Sentry\SentryBundle\Tracing\Cache\TraceableCacheAdapterTrait::traceGet():279} (line 282)
16	Symfony\Component\Cache\LockRegistry::compute (line 113)
17	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
18	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->contractsGet (line 67)
19	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->doGet (line 85)
20	Symfony\Component\Cache\Adapter\AbstractTagAwareAdapter->get (line 30)
21	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->traceGet (line 279)
22	Sentry\SentryBundle\Tracing\Cache\TraceableTagAwareCacheAdapterForV3WithNamespace->get (line 44)
23	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
24	App\Service\CacheService->getCached (line 71)
25	App\Service\CacheService->getData (line 31)
26	App\Service\ShowcaseService->getMediaWallData (line 60)
27	App\Twig\Components\Store\Showcase->getMediaWallData (line 25)
28	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 53)
29	Twig\Extension\CoreExtension->getAttribute (line 1918)
30	__TwigTemplate_e17dfc38e750e204c65eddf3aa7b1b7e::doDisplay (line 53)
31	Twig\Template->yield (line 411)
32	Twig\Template->display (line 366)
33	Twig\Template->render (line 381)
34	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
35	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
36	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 53)
37	__TwigTemplate_56857071deec32baa4e70571b59f5b08->block_body (line 229)
38	Twig\Template->yieldBlock (line 456)
39	__TwigTemplate_b6e9da5b7716a05720e7bd7de44aeed8->doDisplay (line 113)
40	Twig\Template->yield (line 411)
41	__TwigTemplate_56857071deec32baa4e70571b59f5b08->doDisplay (line 58)
42	Twig\Template->yield (line 411)
43	Twig\Template->display (line 366)
44	Twig\Template->render (line 381)
45	Twig\TemplateWrapper->render (line 51)
46	Twig\Environment->render (line 333)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
50	App\Controller\Localized\DefaultController->index (line 46)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
53	Symfony\Component\HttpKernel\Kernel->handle (line 193)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
55	require_once (line 32)
56	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\NodeMedia	482
App\Entity\NodeTranslation	440
App\Entity\Media	375
App\Entity\MediaTranslation	70
App\Entity\Node	43

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\NodeTranslation	No errors.
App\Entity\TranslationJob	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/es/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping