Symfony Profiler

Query Metrics

321 Database Queries

10 Different statements

441.02 ms Query time

0 Invalid entities

194 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

415.34 ms
(94.18%)

278

SELECT m0_.body_parts AS body_parts_0, m0_.is_on_avatar AS is_on_avatar_1, m0_.lft AS lft_2, m0_.lvl AS lvl_3, m0_.rgt AS rgt_4, m0_.id AS id_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.published AS published_8, m0_.published_at AS published_at_9, m0_.notes AS notes_10, m0_.reference AS reference_11, (SELECT COUNT(*) FROM training_exercise_muscle t1_ WHERE t1_.muscle_id = m0_.id) AS sclr_12, m0_.tree_root AS tree_root_13, m0_.parent_id AS parent_id_14, m0_.created_by_id AS created_by_id_15, m0_.updated_by_id AS updated_by_id_16, m0_.publisher AS publisher_17 FROM muscle m0_ WHERE m0_.published = ? AND m0_.reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_12 DESC

Parameters:

[
  1
  "chest"
  "quadriceps"
  "calves"
  "abdominals"
  "oblique-abdominals"
  "biceps"
  "biceps-longus-supinator"
  "biceps-brachii"
  "forearm"
  "shoulders"
  "anterior-deltoid"
  "lateral-deltoid"
  "posterior-deltoid"
  "adductors"
  "trapezius"
  "gluteus"
  "back"
  "large-dorsal"
  "dentele-anterior"
  "ramboids"
  "hamstrings"
  "triceps"
  "triceps-chief-longus"
  "triceps-medial-head"
  "triceps-chief-lateral"
  "lower-back"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.body_parts AS body_parts_0,
  m0_.is_on_avatar AS is_on_avatar_1,
  m0_.lft AS lft_2,
  m0_.lvl AS lvl_3,
  m0_.rgt AS rgt_4,
  m0_.id AS id_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.published AS published_8,
  m0_.published_at AS published_at_9,
  m0_.notes AS notes_10,
  m0_.reference AS reference_11,
  (
    SELECT
      COUNT(*)
    FROM
      training_exercise_muscle t1_
    WHERE
      t1_.muscle_id = m0_.id
  ) AS sclr_12,
  m0_.tree_root AS tree_root_13,
  m0_.parent_id AS parent_id_14,
  m0_.created_by_id AS created_by_id_15,
  m0_.updated_by_id AS updated_by_id_16,
  m0_.publisher AS publisher_17
FROM
  muscle m0_
WHERE
  m0_.published = ?
  AND m0_.reference IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  sclr_12 DESC

SELECT m0_.body_parts AS body_parts_0, m0_.is_on_avatar AS is_on_avatar_1, m0_.lft AS lft_2, m0_.lvl AS lvl_3, m0_.rgt AS rgt_4, m0_.id AS id_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.published AS published_8, m0_.published_at AS published_at_9, m0_.notes AS notes_10, m0_.reference AS reference_11, (SELECT COUNT(*) FROM training_exercise_muscle t1_ WHERE t1_.muscle_id = m0_.id) AS sclr_12, m0_.tree_root AS tree_root_13, m0_.parent_id AS parent_id_14, m0_.created_by_id AS created_by_id_15, m0_.updated_by_id AS updated_by_id_16, m0_.publisher AS publisher_17 FROM muscle m0_ WHERE m0_.published = 1 AND m0_.reference IN ('chest', 'quadriceps', 'calves', 'abdominals', 'oblique-abdominals', 'biceps', 'biceps-longus-supinator', 'biceps-brachii', 'forearm', 'shoulders', 'anterior-deltoid', 'lateral-deltoid', 'posterior-deltoid', 'adductors', 'trapezius', 'gluteus', 'back', 'large-dorsal', 'dentele-anterior', 'ramboids', 'hamstrings', 'triceps', 'triceps-chief-longus', 'triceps-medial-head', 'triceps-chief-lateral', 'lower-back') ORDER BY sclr_12 DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Anatomy\MuscleRepository->findFromReferences (line 93)
7	App\Twig\Components\Anatomy\Avatar->getMuscles (line 70)
8	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
9	iterator_to_array (line 50)
10	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_78a177673d6ac8006313d13dacc41c81->block_content_section (line 93)
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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
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\Collection\ExerciseMuscleController->index (line 58)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 7)

16.93 ms
(3.84%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
46	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 193)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
51	require_once (line 32)
52	require_once (line 7)

2.77 ms
(0.63%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
40	Twig\Template->yield (line 402)
41	Twig\Template->display (line 358)
42	Twig\Template->render (line 373)
43	Twig\TemplateWrapper->render (line 51)
44	Twig\Environment->render (line 333)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
48	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
51	Symfony\Component\HttpKernel\Kernel->handle (line 193)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
53	require_once (line 32)
54	require_once (line 7)

1.59 ms
(0.36%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

1.25 ms
(0.28%)

SELECT m0_.body_parts AS body_parts_0, m0_.is_on_avatar AS is_on_avatar_1, m0_.lft AS lft_2, m0_.lvl AS lvl_3, m0_.rgt AS rgt_4, m0_.id AS id_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.published AS published_8, m0_.published_at AS published_at_9, m0_.notes AS notes_10, m0_.reference AS reference_11, (SELECT COUNT(*) FROM training_exercise_muscle t1_ WHERE t1_.muscle_id = m0_.id) AS sclr_12, m0_.tree_root AS tree_root_13, m0_.parent_id AS parent_id_14, m0_.created_by_id AS created_by_id_15, m0_.updated_by_id AS updated_by_id_16, m0_.publisher AS publisher_17 FROM muscle m0_ WHERE m0_.published = ? AND m0_.parent_id IS NULL HAVING sclr_12 >= ? ORDER BY sclr_12 DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.body_parts AS body_parts_0,
  m0_.is_on_avatar AS is_on_avatar_1,
  m0_.lft AS lft_2,
  m0_.lvl AS lvl_3,
  m0_.rgt AS rgt_4,
  m0_.id AS id_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.published AS published_8,
  m0_.published_at AS published_at_9,
  m0_.notes AS notes_10,
  m0_.reference AS reference_11,
  (
    SELECT
      COUNT(*)
    FROM
      training_exercise_muscle t1_
    WHERE
      t1_.muscle_id = m0_.id
  ) AS sclr_12,
  m0_.tree_root AS tree_root_13,
  m0_.parent_id AS parent_id_14,
  m0_.created_by_id AS created_by_id_15,
  m0_.updated_by_id AS updated_by_id_16,
  m0_.publisher AS publisher_17
FROM
  muscle m0_
WHERE
  m0_.published = ?
  AND m0_.parent_id IS NULL
HAVING
  sclr_12 >= ?
ORDER BY
  sclr_12 DESC

SELECT m0_.body_parts AS body_parts_0, m0_.is_on_avatar AS is_on_avatar_1, m0_.lft AS lft_2, m0_.lvl AS lvl_3, m0_.rgt AS rgt_4, m0_.id AS id_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.published AS published_8, m0_.published_at AS published_at_9, m0_.notes AS notes_10, m0_.reference AS reference_11, (SELECT COUNT(*) FROM training_exercise_muscle t1_ WHERE t1_.muscle_id = m0_.id) AS sclr_12, m0_.tree_root AS tree_root_13, m0_.parent_id AS parent_id_14, m0_.created_by_id AS created_by_id_15, m0_.updated_by_id AS updated_by_id_16, m0_.publisher AS publisher_17 FROM muscle m0_ WHERE m0_.published = 1 AND m0_.parent_id IS NULL HAVING sclr_12 >= 1 ORDER BY sclr_12 DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Anatomy\MuscleRepository->findCollection (line 74)
7	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 50)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

0.94 ms
(0.21%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
46	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
49	Symfony\Component\HttpKernel\Kernel->handle (line 193)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
51	require_once (line 32)
52	require_once (line 7)

0.64 ms
(0.14%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.62 ms
(0.14%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.54 ms
(0.12%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
32	Twig\Template->yield (line 402)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 373)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
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
(0.09%)

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_78a177673d6ac8006313d13dacc41c81->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseMuscleController->index (line 58)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

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\Anatomy\Translation\MuscleTranslation	104
App\Entity\Anatomy\Muscle	28
App\Entity\Training\Translation\CategoryTranslation	24
App\Entity\Training\Translation\ExerciseGroupTranslation	16
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Training\Category	6
App\Entity\Training\ExerciseGroup	4
App\Entity\User	2
App\Entity\Training\Material	2

Entities Mapping

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

Symfony Profiler

GET https://test.fitmetrics.ch/de/ubungen/muskel

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping