Symfony Profiler

Query Metrics

22 Database Queries

12 Different statements

9.35 ms Query time

0 Invalid entities

72 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.49 ms
(26.62%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
49	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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 7)

1.86 ms
(19.85%)

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:

[
  28
]

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 = 28;

#	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->getSlug (line 97)
10	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 88)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 7)

0.83 ms
(8.89%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
47	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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 7)

0.56 ms
(5.98%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
47	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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 7)

0.54 ms
(5.78%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
40	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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)

0.52 ms
(5.60%)

SELECT DISTINCT count(DISTINCT t0_.id) AS sclr_0 FROM training_exercise t0_ LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id WHERE (t0_.published = ? AND (t0_.status NOT IN (?, ?, ?) OR t0_.status IS NULL) AND t1_.id IN (?)) AND (t0_.deleted_at IS NULL)

Parameters:

[
  1
  "proposal"
  "abandoned"
  "duplicated"
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT count(DISTINCT t0_.id) AS sclr_0
FROM
  training_exercise t0_
  LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id
WHERE
  (
    t0_.published = ?
    AND (
      t0_.status NOT IN (?, ?, ?)
      OR t0_.status IS NULL
    )
    AND t1_.id IN (?)
  )
  AND (t0_.deleted_at IS NULL)

SELECT DISTINCT count(DISTINCT t0_.id) AS sclr_0 FROM training_exercise t0_ LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id WHERE (t0_.published = 1 AND (t0_.status NOT IN ('proposal', 'abandoned', 'duplicated') OR t0_.status IS NULL) AND t1_.id IN (28)) AND (t0_.deleted_at IS NULL);

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerOcoLsNa\PaginatorProxyBa079e5->paginate (line 20)
15	App\BusinessLogic\Training\Exercise\Manager\ExerciseCollectionListingManager->createListTemplateParameters (line 63)
16	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 39)
17	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 7)

0.52 ms
(5.52%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
40	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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)

0.46 ms
(4.88%)

SELECT DISTINCT t0_.id AS id_0 FROM training_exercise t0_ LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id WHERE (t0_.published = ? AND (t0_.status NOT IN (?, ?, ?) OR t0_.status IS NULL) AND t1_.id IN (?)) AND (t0_.deleted_at IS NULL) LIMIT 10

Parameters:

[
  1
  "proposal"
  "abandoned"
  "duplicated"
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0
FROM
  training_exercise t0_
  LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id
WHERE
  (
    t0_.published = ?
    AND (
      t0_.status NOT IN (?, ?, ?)
      OR t0_.status IS NULL
    )
    AND t1_.id IN (?)
  )
  AND (t0_.deleted_at IS NULL)
LIMIT
  10

SELECT DISTINCT t0_.id AS id_0 FROM training_exercise t0_ LEFT JOIN training_exercise_group t1_ ON t0_.exercise_group_id = t1_.id WHERE (t0_.published = 1 AND (t0_.status NOT IN ('proposal', 'abandoned', 'duplicated') OR t0_.status IS NULL) AND t1_.id IN (28)) AND (t0_.deleted_at IS NULL) LIMIT 10;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerOcoLsNa\PaginatorProxyBa079e5->paginate (line 20)
15	App\BusinessLogic\Training\Exercise\Manager\ExerciseCollectionListingManager->createListTemplateParameters (line 63)
16	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 39)
17	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 7)

0.45 ms
(4.82%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
40	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
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)

0.38 ms
(4.08%)

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 = ? LIMIT 1

Parameters:

[
  "28"
]

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 = ?
LIMIT
  1

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 = '28' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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.38 ms
(4.01%)

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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
41	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 193)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
46	require_once (line 32)
47	require_once (line 7)

0.37 ms
(3.96%)

SELECT m0_.id AS id_0 FROM muscle m0_ WHERE m0_.parent_id IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0
FROM
  muscle m0_
WHERE
  m0_.parent_id IN (NULL)

SELECT m0_.id AS id_0 FROM muscle m0_ WHERE m0_.parent_id IN (NULL);

#	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\Anatomy\MuscleRepository->findChildrenMuscles (line 119)
7	App\Repository\Training\ExerciseRepository->getSearchQueryBuilder (line 40)
8	App\BusinessLogic\Training\Exercise\Manager\ExerciseCollectionListingManager->createListTemplateParameters (line 64)
9	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 39)
10	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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	20
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Training\Category	6
App\Entity\Training\ExerciseGroup	5
App\Entity\Anatomy\Translation\MuscleTranslation	4
App\Entity\Training\Material	2
App\Entity\User	2
App\Entity\Anatomy\Muscle	1

Entities Mapping

Class	Mapping errors
App\Entity\Training\ExerciseGroup	No errors.
App\Entity\Model\TechnicalMetadata	No errors.
App\Entity\User	No errors.
App\Entity\Training\Exercise	No errors.
App\Entity\Training\Translation\ExerciseGroupTranslation	No errors.
App\Entity\Anatomy\Muscle	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\MediaImage	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\Material	No errors.
App\Entity\Training\Translation\MaterialTranslation	No errors.

Symfony Profiler

GET http://test.fitmetrics.ch/en/exercises/group/28-abdominal-crunch?open-account-panel-popup=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping