Symfony Profiler

Query Metrics

106 Database Queries

19 Different statements

38.02 ms Query time

0 Invalid entities

120 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.92 ms
(44.49%)

SELECT COUNT(*) FROM training_exercise_images t WHERE t.exercise_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  training_exercise_images t
WHERE
  t.exercise_id = ?

SELECT COUNT(*) FROM training_exercise_images t WHERE t.exercise_id = 114;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->count (line 159)
3	Doctrine\ORM\PersistentCollection->count (line 388)
4	App\Entity\Training\Exercise->getPreviewImage (line 937)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_4c151c146ddc0d2167836965203c3af9::doDisplay (line 64)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
33	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 7)

5.10 ms
(13.41%)

SELECT t0.slug AS slug_1, t0.instructions AS instructions_2, t0.short_name AS short_name_3, t0.synonyms AS synonyms_4, t0.guidelines AS guidelines_5, t0.medical_restrictions AS medical_restrictions_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.name AS name_10, t0.description AS description_11, t0.locale AS locale_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.translatable_id AS translatable_id_15 FROM training_exercise_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.instructions AS instructions_2,
  t0.short_name AS short_name_3,
  t0.synonyms AS synonyms_4,
  t0.guidelines AS guidelines_5,
  t0.medical_restrictions AS medical_restrictions_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.name AS name_10,
  t0.description AS description_11,
  t0.locale AS locale_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.translatable_id AS translatable_id_15
FROM
  training_exercise_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.instructions AS instructions_2, t0.short_name AS short_name_3, t0.synonyms AS synonyms_4, t0.guidelines AS guidelines_5, t0.medical_restrictions AS medical_restrictions_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.name AS name_10, t0.description AS description_11, t0.locale AS locale_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.translatable_id AS translatable_id_15 FROM training_exercise_translation t0 WHERE t0.translatable_id = 114;

#	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\Exercise->getTranslatePropertyValue (line 30)
9	App\Entity\Training\Exercise->getName (line 374)
10	App\Twig\Components\Card\ExerciseCardH->getName (line 29)
11	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
12	iterator_to_array (line 50)
13	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
14	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
18	__TwigTemplate_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
37	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
38	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 32)
44	require_once (line 7)

2.82 ms
(7.41%)

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.duration AS duration_15, t0.format AS format_16, t0.start_time AS start_time_17, t0.end_time AS end_time_18, t0.youtube_id AS youtube_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.media FROM media t0 INNER JOIN training_exercise_videos ON t0.id = training_exercise_videos.video_id WHERE training_exercise_videos.exercise_id = ? AND t0.media IN ('video')

Parameters:

[
  572
]

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.duration AS duration_15,
  t0.format AS format_16,
  t0.start_time AS start_time_17,
  t0.end_time AS end_time_18,
  t0.youtube_id AS youtube_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21,
  t0.media
FROM
  media t0
  INNER JOIN training_exercise_videos ON t0.id = training_exercise_videos.video_id
WHERE
  training_exercise_videos.exercise_id = ?
  AND t0.media IN ('video')

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.duration AS duration_15, t0.format AS format_16, t0.start_time AS start_time_17, t0.end_time AS end_time_18, t0.youtube_id AS youtube_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.media FROM media t0 INNER JOIN training_exercise_videos ON t0.id = training_exercise_videos.video_id WHERE training_exercise_videos.exercise_id = 572 AND t0.media IN ('video');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\BusinessLogic\Training\Exercise\Manager\ExerciseMediaManager->getPreviewImageMedia (line 38)
8	App\BusinessLogic\Training\Exercise\Manager\ExerciseMediaManager->getPreviewImageUrl (line 23)
9	App\Twig\Components\Training\Exercise\ExerciseImage->getSrc (line 34)
10	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
11	iterator_to_array (line 50)
12	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
13	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
17	__TwigTemplate_4c151c146ddc0d2167836965203c3af9->doDisplay (line 63)
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_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
31	Twig\Template->yieldBlock (line 446)
32	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
43	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
44	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
47	Symfony\Component\HttpKernel\Kernel->handle (line 193)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
49	require_once (line 32)
50	require_once (line 7)

2.70 ms
(7.10%)

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 INNER JOIN training_exercise_muscle ON t0.id = training_exercise_muscle.muscle_id WHERE training_exercise_muscle.exercise_id = ?

Parameters:

[
  114
]

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
  INNER JOIN training_exercise_muscle ON t0.id = training_exercise_muscle.muscle_id
WHERE
  training_exercise_muscle.exercise_id = ?

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 INNER JOIN training_exercise_muscle ON t0.id = training_exercise_muscle.muscle_id WHERE training_exercise_muscle.exercise_id = 114;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	iterator_to_array (line 1050)
8	Twig\Extension\CoreExtension::sort (line 1050)
9	__TwigTemplate_4c151c146ddc0d2167836965203c3af9::block_firstLine (line 147)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4c151c146ddc0d2167836965203c3af9->doDisplay (line 73)
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_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
37	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
38	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 32)
44	require_once (line 7)

2.43 ms
(6.38%)

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.61 ms
(4.23%)

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:

[
  17
]

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

#	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.94 ms
(2.47%)

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.86 ms
(2.27%)

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.57 ms
(1.49%)

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.56 ms
(1.46%)

SELECT DISTINCT t0_.id AS id_0, t0_.token AS token_1, t0_.status AS status_2, t0_.status_internal AS status_internal_3, t0_.public_status AS public_status_4, t0_.difficulty AS difficulty_5, t0_.focus AS focus_6, t0_.execution_type AS execution_type_7, t0_.workout_parts AS workout_parts_8, t0_.tension_type AS tension_type_9, t0_.validate_at AS validate_at_10, t0_.is_avatar_default_back_view AS is_avatar_default_back_view_11, t0_.grips AS grips_12, t0_.is_suggestion AS is_suggestion_13, t0_.preferred_gender_view AS preferred_gender_view_14, t0_.default_unit AS default_unit_15, t0_.side AS side_16, t0_.created_at AS created_at_17, t0_.updated_at AS updated_at_18, t0_.deleted_at AS deleted_at_19, t0_.published AS published_20, t0_.published_at AS published_at_21, t0_.notes AS notes_22, t0_.view_counter AS view_counter_23, t0_.tiers_id AS tiers_id_24, t0_.tiers_name AS tiers_name_25, t0_.source AS source_26, t0_.source_model AS source_model_27, t0_.normalized_name AS normalized_name_28, t0_.metaphone_name AS metaphone_name_29, 0 AS sclr_30, 0 AS sclr_31, 0 AS sclr_32, t0_.main_exercise_id AS main_exercise_id_33, t0_.exercise_group_id AS exercise_group_id_34, t0_.suggest_by_id AS suggest_by_id_35, t0_.exercise_proposal_id AS exercise_proposal_id_36, t0_.created_by_id AS created_by_id_37, t0_.updated_by_id AS updated_by_id_38, t0_.publisher AS publisher_39 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_.id IN (?, ?, ?, ?, ?, ?, ?)) AND (t0_.deleted_at IS NULL)

Parameters:

[
  1
  "proposal"
  "abandoned"
  "duplicated"
  17
  114
  572
  662
  681
  683
  684
  1102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.token AS token_1,
  t0_.status AS status_2,
  t0_.status_internal AS status_internal_3,
  t0_.public_status AS public_status_4,
  t0_.difficulty AS difficulty_5,
  t0_.focus AS focus_6,
  t0_.execution_type AS execution_type_7,
  t0_.workout_parts AS workout_parts_8,
  t0_.tension_type AS tension_type_9,
  t0_.validate_at AS validate_at_10,
  t0_.is_avatar_default_back_view AS is_avatar_default_back_view_11,
  t0_.grips AS grips_12,
  t0_.is_suggestion AS is_suggestion_13,
  t0_.preferred_gender_view AS preferred_gender_view_14,
  t0_.default_unit AS default_unit_15,
  t0_.side AS side_16,
  t0_.created_at AS created_at_17,
  t0_.updated_at AS updated_at_18,
  t0_.deleted_at AS deleted_at_19,
  t0_.published AS published_20,
  t0_.published_at AS published_at_21,
  t0_.notes AS notes_22,
  t0_.view_counter AS view_counter_23,
  t0_.tiers_id AS tiers_id_24,
  t0_.tiers_name AS tiers_name_25,
  t0_.source AS source_26,
  t0_.source_model AS source_model_27,
  t0_.normalized_name AS normalized_name_28,
  t0_.metaphone_name AS metaphone_name_29,
  0 AS sclr_30,
  0 AS sclr_31,
  0 AS sclr_32,
  t0_.main_exercise_id AS main_exercise_id_33,
  t0_.exercise_group_id AS exercise_group_id_34,
  t0_.suggest_by_id AS suggest_by_id_35,
  t0_.exercise_proposal_id AS exercise_proposal_id_36,
  t0_.created_by_id AS created_by_id_37,
  t0_.updated_by_id AS updated_by_id_38,
  t0_.publisher AS publisher_39
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_.id IN (?, ?, ?, ?, ?, ?, ?)
  )
  AND (t0_.deleted_at IS NULL)

SELECT DISTINCT t0_.id AS id_0, t0_.token AS token_1, t0_.status AS status_2, t0_.status_internal AS status_internal_3, t0_.public_status AS public_status_4, t0_.difficulty AS difficulty_5, t0_.focus AS focus_6, t0_.execution_type AS execution_type_7, t0_.workout_parts AS workout_parts_8, t0_.tension_type AS tension_type_9, t0_.validate_at AS validate_at_10, t0_.is_avatar_default_back_view AS is_avatar_default_back_view_11, t0_.grips AS grips_12, t0_.is_suggestion AS is_suggestion_13, t0_.preferred_gender_view AS preferred_gender_view_14, t0_.default_unit AS default_unit_15, t0_.side AS side_16, t0_.created_at AS created_at_17, t0_.updated_at AS updated_at_18, t0_.deleted_at AS deleted_at_19, t0_.published AS published_20, t0_.published_at AS published_at_21, t0_.notes AS notes_22, t0_.view_counter AS view_counter_23, t0_.tiers_id AS tiers_id_24, t0_.tiers_name AS tiers_name_25, t0_.source AS source_26, t0_.source_model AS source_model_27, t0_.normalized_name AS normalized_name_28, t0_.metaphone_name AS metaphone_name_29, 0 AS sclr_30, 0 AS sclr_31, 0 AS sclr_32, t0_.main_exercise_id AS main_exercise_id_33, t0_.exercise_group_id AS exercise_group_id_34, t0_.suggest_by_id AS suggest_by_id_35, t0_.exercise_proposal_id AS exercise_proposal_id_36, t0_.created_by_id AS created_by_id_37, t0_.updated_by_id AS updated_by_id_38, t0_.publisher AS publisher_39 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 (17) AND t0_.id IN (114, 572, 662, 681, 683, 684, 1102)) 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->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
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.51 ms
(1.34%)

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"
  17
]

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 (17)) 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.44 ms
(1.16%)

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.40 ms
(1.05%)

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.39 ms
(1.03%)

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)

0.38 ms
(1.00%)

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:

[
  "17"
]

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 = '17' 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.37 ms
(0.98%)

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"
  17
]

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 (17)) 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.37 ms
(0.98%)

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 training_exercise_images ON t0.id = training_exercise_images.image_id WHERE training_exercise_images.exercise_id = ? AND t0.media IN ('image')

Parameters:

[
  114
]

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 training_exercise_images ON t0.id = training_exercise_images.image_id
WHERE
  training_exercise_images.exercise_id = ?
  AND t0.media IN ('image')

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 training_exercise_images ON t0.id = training_exercise_images.image_id WHERE training_exercise_images.exercise_id = 114 AND t0.media IN ('image');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Training\Exercise->getPreviewImage (line 944)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_4c151c146ddc0d2167836965203c3af9::doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
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_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
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\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
36	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 32)
42	require_once (line 7)

0.35 ms
(0.93%)

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.31 ms
(0.81%)

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:

[
  158
]

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

#	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_4c151c146ddc0d2167836965203c3af9::doDisplay (line 65)
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_e1402ccfadb14119b304de4adb2a3831->doDisplay (line 81)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->block_content_section (line 194)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_29ac9971bb610709a13e9f369a4cf584->doDisplay (line 55)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
37	App\Controller\Training\Exercise\AbstractExerciseControllerAbstract->renderExercisesList (line 50)
38	App\Controller\Training\Exercise\Collection\ExerciseGroupController->listing (line 131)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 193)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 32)
44	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\ExerciseTranslation	28
App\Entity\Training\Translation\CategoryTranslation	24
App\Entity\Training\Translation\ExerciseGroupTranslation	16
App\Entity\Training\Exercise	11
App\Entity\Anatomy\Translation\MuscleTranslation	8
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Media\Media	7
App\Entity\Training\Category	6
App\Entity\Training\ExerciseGroup	4
App\Entity\User	4
App\Entity\Anatomy\Muscle	2
App\Entity\Training\Material	2

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.
App\Entity\Training\ExerciseProposal	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\MediaImage	No errors.
App\Entity\Media\MediaVideo	No errors.
App\Entity\Training\Category	No errors.
App\Entity\Training\Material	No errors.
App\Entity\Sport\Discipline	No errors.
App\Entity\Training\ExerciseFavorite	No errors.
App\Entity\Training\Log\ExerciseLog	No errors.
App\Entity\Training\ExerciseAlias	No errors.
App\Entity\Faq	No errors.
App\Entity\Training\Translation\ExerciseTranslation	No errors.
App\Entity\Anatomy\Translation\MuscleTranslation	No errors.
App\Entity\Training\Translation\CategoryTranslation	No errors.
App\Entity\Training\Translation\MaterialTranslation	No errors.
App\Entity\Media\Translation\MediaTranslation	No errors.

Symfony Profiler

GET https://test.fitmetrics.ch/it/esercizi/gruppo/17-pressa-per-il-petto

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping