Symfony Profiler

Query Metrics

38 Database Queries

14 Different statements

14.04 ms Query time

0 Invalid entities

83 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.58 ms
(32.59%)

SELECT t0.source AS source_1, t0.zone AS zone_2, t0.url_external AS url_external_3, t0.id AS id_4, t0.notes AS notes_5, t0.tiers_id AS tiers_id_6, t0.tiers_name AS tiers_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.file_name AS file_name_10, t0.file_original_name AS file_original_name_11, t0.file_mime_type AS file_mime_type_12, t0.file_size AS file_size_13, t0.file_dimensions AS file_dimensions_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.media FROM media t0 INNER JOIN program_images ON t0.id = program_images.image_id WHERE program_images.program_id = ? AND t0.media IN ('image') LIMIT 1

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.source AS source_1,
  t0.zone AS zone_2,
  t0.url_external AS url_external_3,
  t0.id AS id_4,
  t0.notes AS notes_5,
  t0.tiers_id AS tiers_id_6,
  t0.tiers_name AS tiers_name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.file_name AS file_name_10,
  t0.file_original_name AS file_original_name_11,
  t0.file_mime_type AS file_mime_type_12,
  t0.file_size AS file_size_13,
  t0.file_dimensions AS file_dimensions_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.media
FROM
  media t0
  INNER JOIN program_images ON t0.id = program_images.image_id
WHERE
  program_images.program_id = ?
  AND t0.media IN ('image')
LIMIT
  1

SELECT t0.source AS source_1, t0.zone AS zone_2, t0.url_external AS url_external_3, t0.id AS id_4, t0.notes AS notes_5, t0.tiers_id AS tiers_id_6, t0.tiers_name AS tiers_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.file_name AS file_name_10, t0.file_original_name AS file_original_name_11, t0.file_mime_type AS file_mime_type_12, t0.file_size AS file_size_13, t0.file_dimensions AS file_dimensions_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.media FROM media t0 INNER JOIN program_images ON t0.id = program_images.image_id WHERE program_images.program_id = 163 AND t0.media IN ('image') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyCollection (line 982)
3	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->slice (line 170)
4	Doctrine\ORM\PersistentCollection->first (line 515)
5	App\Entity\Training\ProgramTemplate->getPreviewImage (line 87)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_851faadcb3a8303f96b35ed9742f95c9::doDisplay (line 62)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->block_content_section (line 141)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Controller\Training\Program\ProgramController->index (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 7)

1.88 ms
(13.38%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.body AS body_6, t0.description AS description_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11, t0.type FROM program_translation t0 WHERE t0.translatable_id = ? AND t0.type IN ('template')

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.body AS body_6,
  t0.description AS description_7,
  t0.locale AS locale_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.translatable_id AS translatable_id_11,
  t0.type
FROM
  program_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.type IN ('template')

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.body AS body_6, t0.description AS description_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11, t0.type FROM program_translation t0 WHERE t0.translatable_id = 163 AND t0.type IN ('template');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Training\ProgramTemplate->getTranslatePropertyValue (line 30)
9	App\Entity\Training\ProgramTemplate->getSlug (line 71)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_851faadcb3a8303f96b35ed9742f95c9::doDisplay (line 48)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->block_content_section (line 141)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
35	App\Controller\Training\Program\ProgramController->index (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 7)

1.83 ms
(13.04%)

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_category_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  56
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_category_translation t0 WHERE t0.translatable_id = 56;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\Training\Category->findTranslationByLocale (line 190)
9	App\Entity\Training\Category->doTranslate (line 138)
10	App\Entity\Training\Category->translate (line 75)
11	App\Entity\Training\Category->getName (line 140)
12	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 80)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
14	Symfony\Component\Cache\LockRegistry->compute (line 113)
15	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
18	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
19	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
20	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
21	Twig\Extension\CoreExtension->getAttribute (line 1919)
22	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
23	Twig\Extension\CoreExtension->captureOutput (line 2116)
24	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
31	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
32	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
36	Twig\Template->yieldBlock (line 446)
37	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
38	Twig\Template->yield (line 402)
39	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
40	Twig\Template->yield (line 402)
41	Twig\Template->display (line 358)
42	Twig\Template->render (line 373)
43	Twig\TemplateWrapper->render (line 51)
44	Twig\Environment->render (line 333)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
48	App\Controller\Training\Program\ProgramController->index (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
51	Symfony\Component\HttpKernel\Kernel->handle (line 193)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
53	require_once (line 32)
54	require_once (line 7)

1.03 ms
(7.35%)

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.locale AS locale_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.translatable_id AS translatable_id_9 FROM training_exercise_group_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.locale AS locale_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8,
  t0.translatable_id AS translatable_id_9
FROM
  training_exercise_group_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.locale AS locale_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.translatable_id AS translatable_id_9 FROM training_exercise_group_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Training\ExerciseGroup->getTranslatePropertyValue (line 30)
9	App\Entity\Training\ExerciseGroup->getName (line 57)
10	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 96)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
12	Symfony\Component\Cache\LockRegistry->compute (line 113)
13	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
18	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
19	Twig\Extension\CoreExtension->getAttribute (line 1919)
20	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
21	Twig\Extension\CoreExtension->captureOutput (line 2116)
22	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
29	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
30	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
31	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
36	Twig\Template->yield (line 402)
37	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
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\Training\Program\ProgramController->index (line 76)
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 7)

0.75 ms
(5.31%)

SELECT t0.name AS name_1, t0.caption AS caption_2, t0.alt AS alt_3, t0.copyright AS copyright_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11 FROM media_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  2589
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.caption AS caption_2,
  t0.alt AS alt_3,
  t0.copyright AS copyright_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.locale AS locale_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.translatable_id AS translatable_id_11
FROM
  media_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.caption AS caption_2, t0.alt AS alt_3, t0.copyright AS copyright_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11 FROM media_translation t0 WHERE t0.translatable_id = 2589;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Media\Media->getTranslatePropertyValue (line 30)
9	App\Entity\Media\Media->getName (line 149)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_851faadcb3a8303f96b35ed9742f95c9::doDisplay (line 71)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->block_content_section (line 141)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
27	Twig\Template->yield (line 402)
28	Twig\Template->display (line 358)
29	Twig\Template->render (line 373)
30	Twig\TemplateWrapper->render (line 51)
31	Twig\Environment->render (line 333)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
35	App\Controller\Training\Program\ProgramController->index (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	require_once (line 7)

0.69 ms
(4.92%)

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ WHERE (p0_.published = ?) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.token AS token_1,
  p0_.duration_weeks AS duration_weeks_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.archived AS archived_5,
  p0_.view_counter AS view_counter_6,
  p0_.source AS source_7,
  p0_.source_model AS source_model_8,
  p0_.free AS free_9,
  p0_.pinned AS pinned_10,
  p0_.published AS published_11,
  p0_.published_at AS published_at_12,
  p0_.type AS type_13,
  p0_.created_by_id AS created_by_id_14,
  p0_.preferences_id AS preferences_id_15,
  p0_.updated_by_id AS updated_by_id_16,
  p0_.publisher AS publisher_17
FROM
  program p0_
WHERE
  (p0_.published = ?)
  AND p0_.type IN ('template')
ORDER BY
  p0_.published_at DESC

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ WHERE (p0_.published = 1) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC;

#	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->getResult (line 688)
6	App\Repository\Training\ProgramTemplateRepository->findLatest (line 113)
7	App\Controller\Training\Program\ProgramController->index (line 62)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

0.64 ms
(4.55%)

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_material_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_material_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_material_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Training\Material->getTranslatePropertyValue (line 30)
9	App\Entity\Training\Material->getName (line 214)
10	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 110)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
12	Symfony\Component\Cache\LockRegistry->compute (line 113)
13	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
18	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
19	Twig\Extension\CoreExtension->getAttribute (line 1919)
20	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
21	Twig\Extension\CoreExtension->captureOutput (line 2116)
22	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
29	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
30	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
31	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
36	Twig\Template->yield (line 402)
37	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
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\Training\Program\ProgramController->index (line 76)
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 7)

0.49 ms
(3.50%)

SELECT t0.genders AS genders_1, t0.fitness_level AS fitness_level_2, t0.primary_goal AS primary_goal_3, t0.target_weight AS target_weight_4, t0.equipment_type AS equipment_type_5, t0.workout_days AS workout_days_6, t0.workout_duration AS workout_duration_7, t0.sedentary_level AS sedentary_level_8, t0.sleep_quality AS sleep_quality_9, t0.stress_level AS stress_level_10, t0.imbalances AS imbalances_11, t0.injuries AS injuries_12, t0.context AS context_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18 FROM training_preferences t0 WHERE t0.id IN (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.genders AS genders_1,
  t0.fitness_level AS fitness_level_2,
  t0.primary_goal AS primary_goal_3,
  t0.target_weight AS target_weight_4,
  t0.equipment_type AS equipment_type_5,
  t0.workout_days AS workout_days_6,
  t0.workout_duration AS workout_duration_7,
  t0.sedentary_level AS sedentary_level_8,
  t0.sleep_quality AS sleep_quality_9,
  t0.stress_level AS stress_level_10,
  t0.imbalances AS imbalances_11,
  t0.injuries AS injuries_12,
  t0.context AS context_13,
  t0.id AS id_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18
FROM
  training_preferences t0
WHERE
  t0.id IN (?, ?, ?)

SELECT t0.genders AS genders_1, t0.fitness_level AS fitness_level_2, t0.primary_goal AS primary_goal_3, t0.target_weight AS target_weight_4, t0.equipment_type AS equipment_type_5, t0.workout_days AS workout_days_6, t0.workout_duration AS workout_duration_7, t0.sedentary_level AS sedentary_level_8, t0.sleep_quality AS sleep_quality_9, t0.stress_level AS stress_level_10, t0.imbalances AS imbalances_11, t0.injuries AS injuries_12, t0.context AS context_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18 FROM training_preferences t0 WHERE t0.id IN (535, 529, 518);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2643)
3	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
4	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\Training\ProgramTemplateRepository->findLatest (line 113)
9	App\Controller\Training\Program\ProgramController->index (line 62)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 7)

0.44 ms
(3.12%)

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ WHERE (p0_.published = ? AND p0_.pinned = 1) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.token AS token_1,
  p0_.duration_weeks AS duration_weeks_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.archived AS archived_5,
  p0_.view_counter AS view_counter_6,
  p0_.source AS source_7,
  p0_.source_model AS source_model_8,
  p0_.free AS free_9,
  p0_.pinned AS pinned_10,
  p0_.published AS published_11,
  p0_.published_at AS published_at_12,
  p0_.type AS type_13,
  p0_.created_by_id AS created_by_id_14,
  p0_.preferences_id AS preferences_id_15,
  p0_.updated_by_id AS updated_by_id_16,
  p0_.publisher AS publisher_17
FROM
  program p0_
WHERE
  (
    p0_.published = ?
    AND p0_.pinned = 1
  )
  AND p0_.type IN ('template')
ORDER BY
  p0_.published_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ WHERE (p0_.published = 1 AND p0_.pinned = 1) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC LIMIT 3;

#	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->getResult (line 688)
6	App\Repository\Training\ProgramTemplateRepository->findPinned (line 97)
7	App\Controller\Training\Program\ProgramController->index (line 63)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

0.39 ms
(2.77%)

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM muscle_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  muscle_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM muscle_translation t0 WHERE t0.translatable_id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Anatomy\Muscle->getTranslatePropertyValue (line 30)
9	App\Entity\Anatomy\Muscle->getName (line 157)
10	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 62)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
12	Symfony\Component\Cache\LockRegistry->compute (line 113)
13	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
18	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
19	Twig\Extension\CoreExtension->getAttribute (line 1919)
20	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
21	Twig\Extension\CoreExtension->captureOutput (line 2116)
22	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
29	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
30	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
31	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
36	Twig\Template->yield (line 402)
37	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
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\Training\Program\ProgramController->index (line 76)
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 7)

0.37 ms
(2.64%)

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.sections AS sections_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published AS published_8, t0.published_at AS published_at_9, t0.notes AS notes_10, t0.reference AS reference_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.publisher AS publisher_16 FROM training_category t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lft AS lft_1,
  t0.lvl AS lvl_2,
  t0.rgt AS rgt_3,
  t0.sections AS sections_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.published AS published_8,
  t0.published_at AS published_at_9,
  t0.notes AS notes_10,
  t0.reference AS reference_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.publisher AS publisher_16
FROM
  training_category t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.sections AS sections_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published AS published_8, t0.published_at AS published_at_9, t0.notes AS notes_10, t0.reference AS reference_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.publisher AS publisher_16 FROM training_category t0 WHERE t0.id IN (67, 68, 57, 56, 62, 60);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 67)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
5	Symfony\Component\Cache\LockRegistry->compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
12	Twig\Extension\CoreExtension->getAttribute (line 1919)
13	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
14	Twig\Extension\CoreExtension->captureOutput (line 2116)
15	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Program\ProgramController->index (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.34 ms
(2.43%)

SELECT t0.body_parts AS body_parts_1, t0.is_on_avatar AS is_on_avatar_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.notes AS notes_11, t0.reference AS reference_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.publisher AS publisher_17 FROM muscle t0 WHERE t0.id IN (?)

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.body_parts AS body_parts_1,
  t0.is_on_avatar AS is_on_avatar_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.published_at AS published_at_10,
  t0.notes AS notes_11,
  t0.reference AS reference_12,
  t0.tree_root AS tree_root_13,
  t0.parent_id AS parent_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.publisher AS publisher_17
FROM
  muscle t0
WHERE
  t0.id IN (?)

SELECT t0.body_parts AS body_parts_1, t0.is_on_avatar AS is_on_avatar_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.notes AS notes_11, t0.reference AS reference_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.publisher AS publisher_17 FROM muscle t0 WHERE t0.id IN (6);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 54)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
5	Symfony\Component\Cache\LockRegistry->compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
12	Twig\Extension\CoreExtension->getAttribute (line 1919)
13	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
14	Twig\Extension\CoreExtension->captureOutput (line 2116)
15	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Program\ProgramController->index (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.33 ms
(2.36%)

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.categories AS categories_4, t0.equipment AS equipment_5, t0.exclude_from_equipments AS exclude_from_equipments_6, t0.group_item AS group_item_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.published AS published_11, t0.published_at AS published_at_12, t0.notes AS notes_13, t0.reference AS reference_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.publisher AS publisher_19 FROM training_material t0 WHERE t0.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lft AS lft_1,
  t0.lvl AS lvl_2,
  t0.rgt AS rgt_3,
  t0.categories AS categories_4,
  t0.equipment AS equipment_5,
  t0.exclude_from_equipments AS exclude_from_equipments_6,
  t0.group_item AS group_item_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.published AS published_11,
  t0.published_at AS published_at_12,
  t0.notes AS notes_13,
  t0.reference AS reference_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.publisher AS publisher_19
FROM
  training_material t0
WHERE
  t0.id IN (?, ?)

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.categories AS categories_4, t0.equipment AS equipment_5, t0.exclude_from_equipments AS exclude_from_equipments_6, t0.group_item AS group_item_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.published AS published_11, t0.published_at AS published_at_12, t0.notes AS notes_13, t0.reference AS reference_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.publisher AS publisher_19 FROM training_material t0 WHERE t0.id IN (29, 1);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 101)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
5	Symfony\Component\Cache\LockRegistry->compute (line 113)
6	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
11	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
12	Twig\Extension\CoreExtension->getAttribute (line 1919)
13	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
14	Twig\Extension\CoreExtension->captureOutput (line 2116)
15	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
23	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Program\ProgramController->index (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.29 ms
(2.05%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.published AS published_4, t0.published_at AS published_at_5, t0.normalized_name AS normalized_name_6, t0.metaphone_name AS metaphone_name_7, t0.token AS token_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.publisher AS publisher_11 FROM training_exercise_group t0 WHERE t0.id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.published AS published_4,
  t0.published_at AS published_at_5,
  t0.normalized_name AS normalized_name_6,
  t0.metaphone_name AS metaphone_name_7,
  t0.token AS token_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.publisher AS publisher_11
FROM
  training_exercise_group t0
WHERE
  t0.id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.published AS published_4, t0.published_at AS published_at_5, t0.normalized_name AS normalized_name_6, t0.metaphone_name AS metaphone_name_7, t0.token AS token_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.publisher AS publisher_11 FROM training_exercise_group t0 WHERE t0.id IN (2, 4, 17, 1);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Twig\Components\Menu\MainMenu->{closure:App\Twig\Components\Menu\MainMenu::getSearchTrends():49} (line 85)
5	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
6	Symfony\Component\Cache\LockRegistry->compute (line 113)
7	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
12	App\Twig\Components\Menu\MainMenu->getSearchTrends (line 49)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::{closure:__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay():190} (line 429)
15	Twig\Extension\CoreExtension->captureOutput (line 2116)
16	__TwigTemplate_0c1a7c3827808428fad9f4ed37668098::doDisplay (line 190)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_271a26219b97e162a55bada6f3473296->doDisplay (line 59)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
23	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
24	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_header (line 523)
26	Twig\Template->yieldBlock (line 446)
27	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 443)
28	Twig\Template->yieldBlock (line 446)
29	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_14baebd2f299a5bab685ab3d1d5b6b1f->doDisplay (line 53)
32	Twig\Template->yield (line 402)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 373)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\Training\Program\ProgramController->index (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 32)
46	require_once (line 7)

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\Training\Translation\CategoryTranslation	24
App\Entity\Training\Translation\ExerciseGroupTranslation	16
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Training\Category	6
App\Entity\Training\Translation\ProgramTranslation	6
App\Entity\Anatomy\Translation\MuscleTranslation	4
App\Entity\Training\ExerciseGroup	4
App\Entity\Training\Program	3
App\Entity\User	3
App\Entity\Training\TrainingPreferences	3
App\Entity\Media\Media	3
App\Entity\Training\Material	2
App\Entity\Anatomy\Muscle	1

Entities Mapping

Class	Mapping errors
App\Entity\Training\Program	No errors.
App\Entity\Training\ProgramTemplate	No errors.
App\Entity\Model\TechnicalMetadata	No errors.
App\Entity\User	No errors.
App\Entity\Training\TrainingPreferences	No errors.
App\Entity\Training\Workout	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\MediaImage	No errors.
App\Entity\Faq	No errors.
App\Entity\Training\Translation\ProgramTranslation	No errors.
App\Entity\Training\Translation\ProgramTemplateTranslation	No errors.
App\Entity\Training\Material	No errors.
App\Entity\Anatomy\Muscle	No errors.
App\Entity\Training\Exercise	No errors.
App\Entity\Anatomy\Translation\MuscleTranslation	No errors.
App\Entity\Training\Category	No errors.
App\Entity\Sport\Discipline	No errors.
App\Entity\Training\Translation\CategoryTranslation	No errors.
App\Entity\Training\ExerciseGroup	No errors.
App\Entity\Training\Translation\ExerciseGroupTranslation	No errors.
App\Entity\Training\Translation\MaterialTranslation	No errors.
App\Entity\Media\Translation\MediaTranslation	No errors.

Symfony Profiler

GET http://test.fitmetrics.ch/en/workout-programs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping