Symfony Profiler

Query Metrics

76 Database Queries

26 Different statements

35.98 ms Query time

0 Invalid entities

153 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.81 ms
(7.81%)

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:

[
  1188
]

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 = 1188 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->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_acd65a2f9bfb09ad3fc41e7fc353a28e::doDisplay (line 48)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 66)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
19	__TwigTemplate_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
26	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
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_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
34	Twig\Template->yieldBlock (line 446)
35	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
36	Twig\Template->yieldBlock (line 446)
37	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
38	Twig\Template->yieldBlock (line 446)
39	Twig\Template->yieldParentBlock (line 491)
40	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
41	Twig\Template->yieldBlock (line 446)
42	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
43	Twig\Template->yieldBlock (line 446)
44	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
45	Twig\Template->yield (line 402)
46	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
47	Twig\Template->yield (line 402)
48	Twig\Template->display (line 358)
49	Twig\Template->render (line 373)
50	Twig\TemplateWrapper->render (line 51)
51	Twig\Environment->render (line 333)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
55	App\Controller\Training\Workout\WorkoutController->view (line 185)
56	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
57	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
58	Symfony\Component\HttpKernel\Kernel->handle (line 193)
59	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
60	require_once (line 32)
61	require_once (line 7)

2.66 ms
(7.40%)

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:

[
  1188
]

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

#	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->getSlug (line 667)
10	App\BusinessLogic\Training\Exercise\Url\ExerciseRoutingManager->generateExerciseDetail (line 44)
11	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 54)
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_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
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_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
32	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
33	Twig\Template->yieldBlock (line 446)
34	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
37	Twig\Template->yieldBlock (line 446)
38	Twig\Template->yieldParentBlock (line 491)
39	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
40	Twig\Template->yieldBlock (line 446)
41	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
42	Twig\Template->yieldBlock (line 446)
43	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
54	App\Controller\Training\Workout\WorkoutController->view (line 185)
55	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
56	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
57	Symfony\Component\HttpKernel\Kernel->handle (line 193)
58	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
59	require_once (line 32)
60	require_once (line 7)

2.63 ms
(7.31%)

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

Parameters:

[
  1188
]

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

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 INNER JOIN training_exercise_material_rel ON t0.id = training_exercise_material_rel.material_id WHERE training_exercise_material_rel.exercise_id = 1188;

#	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	App\Entity\Training\Workout->getUsedEquipments (line 267)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 195)
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_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
21	Twig\Template->yieldBlock (line 446)
22	Twig\Template->yieldParentBlock (line 491)
23	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
26	Twig\Template->yieldBlock (line 446)
27	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	App\Controller\Training\Workout\WorkoutController->view (line 185)
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.56 ms
(7.10%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.status AS status_3, t0.status_internal AS status_internal_4, t0.public_status AS public_status_5, t0.difficulty AS difficulty_6, t0.focus AS focus_7, t0.execution_type AS execution_type_8, t0.workout_parts AS workout_parts_9, t0.tension_type AS tension_type_10, t0.validate_at AS validate_at_11, t0.is_avatar_default_back_view AS is_avatar_default_back_view_12, t0.grips AS grips_13, t0.is_suggestion AS is_suggestion_14, t0.preferred_gender_view AS preferred_gender_view_15, t0.default_unit AS default_unit_16, t0.side AS side_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.published AS published_21, t0.published_at AS published_at_22, t0.notes AS notes_23, t0.view_counter AS view_counter_24, t0.tiers_id AS tiers_id_25, t0.tiers_name AS tiers_name_26, t0.source AS source_27, t0.source_model AS source_model_28, t0.normalized_name AS normalized_name_29, t0.metaphone_name AS metaphone_name_30, t0.main_exercise_id AS main_exercise_id_31, t0.exercise_group_id AS exercise_group_id_32, t0.suggest_by_id AS suggest_by_id_33, t0.exercise_proposal_id AS exercise_proposal_id_34, t0.created_by_id AS created_by_id_35, t0.updated_by_id AS updated_by_id_36, t0.publisher AS publisher_37 FROM training_exercise t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1188
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.status AS status_3,
  t0.status_internal AS status_internal_4,
  t0.public_status AS public_status_5,
  t0.difficulty AS difficulty_6,
  t0.focus AS focus_7,
  t0.execution_type AS execution_type_8,
  t0.workout_parts AS workout_parts_9,
  t0.tension_type AS tension_type_10,
  t0.validate_at AS validate_at_11,
  t0.is_avatar_default_back_view AS is_avatar_default_back_view_12,
  t0.grips AS grips_13,
  t0.is_suggestion AS is_suggestion_14,
  t0.preferred_gender_view AS preferred_gender_view_15,
  t0.default_unit AS default_unit_16,
  t0.side AS side_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t0.published AS published_21,
  t0.published_at AS published_at_22,
  t0.notes AS notes_23,
  t0.view_counter AS view_counter_24,
  t0.tiers_id AS tiers_id_25,
  t0.tiers_name AS tiers_name_26,
  t0.source AS source_27,
  t0.source_model AS source_model_28,
  t0.normalized_name AS normalized_name_29,
  t0.metaphone_name AS metaphone_name_30,
  t0.main_exercise_id AS main_exercise_id_31,
  t0.exercise_group_id AS exercise_group_id_32,
  t0.suggest_by_id AS suggest_by_id_33,
  t0.exercise_proposal_id AS exercise_proposal_id_34,
  t0.created_by_id AS created_by_id_35,
  t0.updated_by_id AS updated_by_id_36,
  t0.publisher AS publisher_37
FROM
  training_exercise t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.token AS token_2, t0.status AS status_3, t0.status_internal AS status_internal_4, t0.public_status AS public_status_5, t0.difficulty AS difficulty_6, t0.focus AS focus_7, t0.execution_type AS execution_type_8, t0.workout_parts AS workout_parts_9, t0.tension_type AS tension_type_10, t0.validate_at AS validate_at_11, t0.is_avatar_default_back_view AS is_avatar_default_back_view_12, t0.grips AS grips_13, t0.is_suggestion AS is_suggestion_14, t0.preferred_gender_view AS preferred_gender_view_15, t0.default_unit AS default_unit_16, t0.side AS side_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.published AS published_21, t0.published_at AS published_at_22, t0.notes AS notes_23, t0.view_counter AS view_counter_24, t0.tiers_id AS tiers_id_25, t0.tiers_name AS tiers_name_26, t0.source AS source_27, t0.source_model AS source_model_28, t0.normalized_name AS normalized_name_29, t0.metaphone_name AS metaphone_name_30, t0.main_exercise_id AS main_exercise_id_31, t0.exercise_group_id AS exercise_group_id_32, t0.suggest_by_id AS suggest_by_id_33, t0.exercise_proposal_id AS exercise_proposal_id_34, t0.created_by_id AS created_by_id_35, t0.updated_by_id AS updated_by_id_36, t0.publisher AS publisher_37 FROM training_exercise t0 WHERE t0.id = 1188 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Training\Exercise::getMaterials (line 548)
5	App\Entity\Training\Workout->getUsedEquipments (line 267)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 195)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
19	Twig\Template->yieldBlock (line 446)
20	Twig\Template->yieldParentBlock (line 491)
21	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\Training\Workout\WorkoutController->view (line 185)
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)

2.47 ms
(6.87%)

SELECT t0.notes AS notes_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.translatable_id AS translatable_id_8 FROM exercise_config_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1541
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.notes AS notes_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.locale AS locale_5,
  t0.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7,
  t0.translatable_id AS translatable_id_8
FROM
  exercise_config_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.notes AS notes_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.translatable_id AS translatable_id_8 FROM exercise_config_translation t0 WHERE t0.translatable_id = 1541;

#	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\Config\ExerciseConfig->getTranslatePropertyValue (line 30)
9	App\Entity\Training\Config\ExerciseConfig->getNotes (line 144)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d::doDisplay (line 90)
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_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
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_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
32	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
33	Twig\Template->yieldBlock (line 446)
34	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
37	Twig\Template->yieldBlock (line 446)
38	Twig\Template->yieldParentBlock (line 491)
39	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
40	Twig\Template->yieldBlock (line 446)
41	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
42	Twig\Template->yieldBlock (line 446)
43	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
54	App\Controller\Training\Workout\WorkoutController->view (line 185)
55	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
56	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
57	Symfony\Component\HttpKernel\Kernel->handle (line 193)
58	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
59	require_once (line 32)
60	require_once (line 7)

2.26 ms
(6.29%)

SELECT t0.unit AS unit_1, t0.value_min AS value_min_2, t0.value_max AS value_max_3, t0.until_failure AS until_failure_4, t0.tempo AS tempo_5, t0.rest_time AS rest_time_6, t0.weight_min AS weight_min_7, t0.weight_max AS weight_max_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.exercise_config_id AS exercise_config_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM exercise_serie_config t0 WHERE t0.exercise_config_id = ?

Parameters:

[
  1541
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.unit AS unit_1,
  t0.value_min AS value_min_2,
  t0.value_max AS value_max_3,
  t0.until_failure AS until_failure_4,
  t0.tempo AS tempo_5,
  t0.rest_time AS rest_time_6,
  t0.weight_min AS weight_min_7,
  t0.weight_max AS weight_max_8,
  t0.id AS id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.exercise_config_id AS exercise_config_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14
FROM
  exercise_serie_config t0
WHERE
  t0.exercise_config_id = ?

SELECT t0.unit AS unit_1, t0.value_min AS value_min_2, t0.value_max AS value_max_3, t0.until_failure AS until_failure_4, t0.tempo AS tempo_5, t0.rest_time AS rest_time_6, t0.weight_min AS weight_min_7, t0.weight_max AS weight_max_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.exercise_config_id AS exercise_config_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM exercise_serie_config t0 WHERE t0.exercise_config_id = 1541;

#	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	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 119)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
22	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
27	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
28	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
29	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
30	Twig\Template->yieldBlock (line 446)
31	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
34	Twig\Template->yieldBlock (line 446)
35	Twig\Template->yieldParentBlock (line 491)
36	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
37	Twig\Template->yieldBlock (line 446)
38	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
39	Twig\Template->yieldBlock (line 446)
40	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
41	Twig\Template->yield (line 402)
42	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
43	Twig\Template->yield (line 402)
44	Twig\Template->display (line 358)
45	Twig\Template->render (line 373)
46	Twig\TemplateWrapper->render (line 51)
47	Twig\Environment->render (line 333)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
50	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
51	App\Controller\Training\Workout\WorkoutController->view (line 185)
52	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
53	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
54	Symfony\Component\HttpKernel\Kernel->handle (line 193)
55	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
56	require_once (line 32)
57	require_once (line 7)

2.10 ms
(5.83%)

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:

[
  1188
]

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

#	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	App\Entity\Training\Workout->getMuscles (line 296)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 253)
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_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
21	Twig\Template->yieldBlock (line 446)
22	Twig\Template->yieldParentBlock (line 491)
23	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
26	Twig\Template->yieldBlock (line 446)
27	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
38	App\Controller\Training\Workout\WorkoutController->view (line 185)
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)

1.81 ms
(5.03%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.76 ms
(4.90%)

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

Parameters:

[
  1188
]

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

#	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_acd65a2f9bfb09ad3fc41e7fc353a28e::doDisplay (line 54)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 66)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
15	__TwigTemplate_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
20	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
21	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
22	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
27	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
28	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
29	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
30	Twig\Template->yieldBlock (line 446)
31	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
32	Twig\Template->yieldBlock (line 446)
33	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
34	Twig\Template->yieldBlock (line 446)
35	Twig\Template->yieldParentBlock (line 491)
36	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
37	Twig\Template->yieldBlock (line 446)
38	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
39	Twig\Template->yieldBlock (line 446)
40	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
41	Twig\Template->yield (line 402)
42	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
43	Twig\Template->yield (line 402)
44	Twig\Template->display (line 358)
45	Twig\Template->render (line 373)
46	Twig\TemplateWrapper->render (line 51)
47	Twig\Environment->render (line 333)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
50	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
51	App\Controller\Training\Workout\WorkoutController->view (line 185)
52	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
53	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
54	Symfony\Component\HttpKernel\Kernel->handle (line 193)
55	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
56	require_once (line 32)
57	require_once (line 7)

1.63 ms
(4.53%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.duration_weeks AS duration_weeks_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.archived AS archived_6, t0.view_counter AS view_counter_7, t0.source AS source_8, t0.source_model AS source_model_9, t0.created_by_id AS created_by_id_10, t0.preferences_id AS preferences_id_11, t12.genders AS genders_13, t12.fitness_level AS fitness_level_14, t12.primary_goal AS primary_goal_15, t12.target_weight AS target_weight_16, t12.equipment_type AS equipment_type_17, t12.workout_days AS workout_days_18, t12.workout_duration AS workout_duration_19, t12.sedentary_level AS sedentary_level_20, t12.sleep_quality AS sleep_quality_21, t12.stress_level AS stress_level_22, t12.imbalances AS imbalances_23, t12.injuries AS injuries_24, t12.context AS context_25, t12.id AS id_26, t12.created_at AS created_at_27, t12.updated_at AS updated_at_28, t12.created_by_id AS created_by_id_29, t12.updated_by_id AS updated_by_id_30, t0.updated_by_id AS updated_by_id_31, t0.type, t0.visibility AS visibility_32, t0.start_at AS start_at_33, t0.end_at AS end_at_34, t0.assignee_id AS assignee_id_35, t0.free AS free_36, t0.pinned AS pinned_37, t0.published AS published_38, t0.published_at AS published_at_39, t0.publisher AS publisher_40 FROM program t0 LEFT JOIN training_preferences t12 ON t0.preferences_id = t12.id WHERE t0.id = ? AND t0.type IN ('user', 'template')

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.duration_weeks AS duration_weeks_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.archived AS archived_6,
  t0.view_counter AS view_counter_7,
  t0.source AS source_8,
  t0.source_model AS source_model_9,
  t0.created_by_id AS created_by_id_10,
  t0.preferences_id AS preferences_id_11,
  t12.genders AS genders_13,
  t12.fitness_level AS fitness_level_14,
  t12.primary_goal AS primary_goal_15,
  t12.target_weight AS target_weight_16,
  t12.equipment_type AS equipment_type_17,
  t12.workout_days AS workout_days_18,
  t12.workout_duration AS workout_duration_19,
  t12.sedentary_level AS sedentary_level_20,
  t12.sleep_quality AS sleep_quality_21,
  t12.stress_level AS stress_level_22,
  t12.imbalances AS imbalances_23,
  t12.injuries AS injuries_24,
  t12.context AS context_25,
  t12.id AS id_26,
  t12.created_at AS created_at_27,
  t12.updated_at AS updated_at_28,
  t12.created_by_id AS created_by_id_29,
  t12.updated_by_id AS updated_by_id_30,
  t0.updated_by_id AS updated_by_id_31,
  t0.type,
  t0.visibility AS visibility_32,
  t0.start_at AS start_at_33,
  t0.end_at AS end_at_34,
  t0.assignee_id AS assignee_id_35,
  t0.free AS free_36,
  t0.pinned AS pinned_37,
  t0.published AS published_38,
  t0.published_at AS published_at_39,
  t0.publisher AS publisher_40
FROM
  program t0
  LEFT JOIN training_preferences t12 ON t0.preferences_id = t12.id
WHERE
  t0.id = ?
  AND t0.type IN ('user', 'template')

SELECT t0.id AS id_1, t0.token AS token_2, t0.duration_weeks AS duration_weeks_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.archived AS archived_6, t0.view_counter AS view_counter_7, t0.source AS source_8, t0.source_model AS source_model_9, t0.created_by_id AS created_by_id_10, t0.preferences_id AS preferences_id_11, t12.genders AS genders_13, t12.fitness_level AS fitness_level_14, t12.primary_goal AS primary_goal_15, t12.target_weight AS target_weight_16, t12.equipment_type AS equipment_type_17, t12.workout_days AS workout_days_18, t12.workout_duration AS workout_duration_19, t12.sedentary_level AS sedentary_level_20, t12.sleep_quality AS sleep_quality_21, t12.stress_level AS stress_level_22, t12.imbalances AS imbalances_23, t12.injuries AS injuries_24, t12.context AS context_25, t12.id AS id_26, t12.created_at AS created_at_27, t12.updated_at AS updated_at_28, t12.created_by_id AS created_by_id_29, t12.updated_by_id AS updated_by_id_30, t0.updated_by_id AS updated_by_id_31, t0.type, t0.visibility AS visibility_32, t0.start_at AS start_at_33, t0.end_at AS end_at_34, t0.assignee_id AS assignee_id_35, t0.free AS free_36, t0.pinned AS pinned_37, t0.published AS published_38, t0.published_at AS published_at_39, t0.publisher AS publisher_40 FROM program t0 LEFT JOIN training_preferences t12 ON t0.preferences_id = t12.id WHERE t0.id = 163 AND t0.type IN ('user', 'template');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2531)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\EntityRepository->findOneBy (line 125)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
10	App\Controller\Training\Workout\WorkoutController->view (line 91)
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)

1.55 ms
(4.30%)

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:

[
  142
]

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 = 142 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_acd65a2f9bfb09ad3fc41e7fc353a28e::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 66)
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_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
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_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
32	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
33	Twig\Template->yieldBlock (line 446)
34	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
37	Twig\Template->yieldBlock (line 446)
38	Twig\Template->yieldParentBlock (line 491)
39	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
40	Twig\Template->yieldBlock (line 446)
41	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
42	Twig\Template->yieldBlock (line 446)
43	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
44	Twig\Template->yield (line 402)
45	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
46	Twig\Template->yield (line 402)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 373)
49	Twig\TemplateWrapper->render (line 51)
50	Twig\Environment->render (line 333)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
54	App\Controller\Training\Workout\WorkoutController->view (line 185)
55	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
56	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
57	Symfony\Component\HttpKernel\Kernel->handle (line 193)
58	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
59	require_once (line 32)
60	require_once (line 7)

1.38 ms
(3.83%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.32 ms
(3.67%)

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

Parameters:

[
  355
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Training\WorkoutTemplate->getTranslatePropertyValue (line 30)
9	App\Entity\Training\WorkoutTemplate->getSlug (line 56)
10	App\Controller\Training\Workout\WorkoutController->view (line 96)
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)

1.14 ms
(3.16%)

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:

[
  228
]

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

#	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_acd65a2f9bfb09ad3fc41e7fc353a28e::doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ca85b20ec4fc120f6688863533445c7d->doDisplay (line 66)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
18	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
19	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
20	__TwigTemplate_e1f28d0cf760dd53dd56553f201ae1a0->doDisplay (line 148)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
27	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985->doDisplay (line 360)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
32	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
33	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
34	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
37	Twig\Template->yieldBlock (line 446)
38	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
39	Twig\Template->yieldBlock (line 446)
40	Twig\Template->yieldParentBlock (line 491)
41	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
42	Twig\Template->yieldBlock (line 446)
43	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
44	Twig\Template->yieldBlock (line 446)
45	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
46	Twig\Template->yield (line 402)
47	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
48	Twig\Template->yield (line 402)
49	Twig\Template->display (line 358)
50	Twig\Template->render (line 373)
51	Twig\TemplateWrapper->render (line 51)
52	Twig\Environment->render (line 333)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
56	App\Controller\Training\Workout\WorkoutController->view (line 185)
57	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
58	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
59	Symfony\Component\HttpKernel\Kernel->handle (line 193)
60	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
61	require_once (line 32)
62	require_once (line 7)

1.09 ms
(3.04%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.exercise_id AS exercise_id_4, t0.workout_id AS workout_id_5, t0.workout_block_id AS workout_block_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM exercise_config t0 WHERE t0.workout_block_id = ?

Parameters:

[
  259
]

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.exercise_id AS exercise_id_4,
  t0.workout_id AS workout_id_5,
  t0.workout_block_id AS workout_block_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  exercise_config t0
WHERE
  t0.workout_block_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.exercise_id AS exercise_id_4, t0.workout_id AS workout_id_5, t0.workout_block_id AS workout_block_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM exercise_config t0 WHERE t0.workout_block_id = 259;

#	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\Workout->getTotalExercises (line 248)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 128)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
17	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
22	Twig\Template->yieldBlock (line 446)
23	Twig\Template->yieldParentBlock (line 491)
24	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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)

1.06 ms
(2.95%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.03 ms
(2.86%)

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

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Training\ProgramTemplate->getTranslatePropertyValue (line 30)
9	App\Entity\Training\ProgramTemplate->getName (line 66)
10	App\Controller\Training\Workout\WorkoutController->view (line 115)
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.87 ms
(2.41%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.day AS day_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.view_counter AS view_counter_6, t0.source AS source_7, t0.source_model AS source_model_8, t0.program_id AS program_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.type, t0.published AS published_12, t0.published_at AS published_at_13, t0.publisher AS publisher_14 FROM workout t0 WHERE t0.token = ? AND t0.type IN ('user', 'template') LIMIT 1

Parameters:

[
  "68629c85effc5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.day AS day_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.view_counter AS view_counter_6,
  t0.source AS source_7,
  t0.source_model AS source_model_8,
  t0.program_id AS program_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.type,
  t0.published AS published_12,
  t0.published_at AS published_at_13,
  t0.publisher AS publisher_14
FROM
  workout t0
WHERE
  t0.token = ?
  AND t0.type IN ('user', 'template')
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.day AS day_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.view_counter AS view_counter_6, t0.source AS source_7, t0.source_model AS source_model_8, t0.program_id AS program_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.type, t0.published AS published_12, t0.published_at AS published_at_13, t0.publisher AS publisher_14 FROM workout t0 WHERE t0.token = '68629c85effc5' AND t0.type IN ('user', 'template') 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	App\Controller\Training\Workout\WorkoutController->view (line 91)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 7)

0.78 ms
(2.17%)

SELECT t0.id AS id_1, t0.token AS token_2, t0.day AS day_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.view_counter AS view_counter_6, t0.source AS source_7, t0.source_model AS source_model_8, t0.program_id AS program_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.type, t0.published AS published_12, t0.published_at AS published_at_13, t0.publisher AS publisher_14 FROM workout t0 WHERE t0.program_id = ? AND t0.type IN ('user', 'template')

Parameters:

[
  163
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.day AS day_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.view_counter AS view_counter_6,
  t0.source AS source_7,
  t0.source_model AS source_model_8,
  t0.program_id AS program_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.type,
  t0.published AS published_12,
  t0.published_at AS published_at_13,
  t0.publisher AS publisher_14
FROM
  workout t0
WHERE
  t0.program_id = ?
  AND t0.type IN ('user', 'template')

SELECT t0.id AS id_1, t0.token AS token_2, t0.day AS day_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.view_counter AS view_counter_6, t0.source AS source_7, t0.source_model AS source_model_8, t0.program_id AS program_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.type, t0.published AS published_12, t0.published_at AS published_at_13, t0.publisher AS publisher_14 FROM workout t0 WHERE t0.program_id = 163 AND t0.type IN ('user', 'template');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_d8cd1d4a48c5b576ec34eb5d773fb7c4::doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 231)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
16	Twig\Template->yieldBlock (line 446)
17	Twig\Template->yieldParentBlock (line 491)
18	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\Training\Workout\WorkoutController->view (line 185)
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)

0.64 ms
(1.78%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.63 ms
(1.76%)

SELECT t0.section AS section_1, t0.type AS type_2, t0.metadata AS metadata_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.workout_id AS workout_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM workout_block t0 WHERE t0.workout_id = ?

Parameters:

[
  355
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.section AS section_1,
  t0.type AS type_2,
  t0.metadata AS metadata_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.workout_id AS workout_id_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  workout_block t0
WHERE
  t0.workout_id = ?

SELECT t0.section AS section_1, t0.type AS type_2, t0.metadata AS metadata_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.workout_id AS workout_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM workout_block t0 WHERE t0.workout_id = 355;

#	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	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Entity\Training\Workout->getBlocks (line 132)
10	App\Entity\Training\Workout->getTotalExercises (line 247)
11	Twig\Extension\CoreExtension->getAttribute (line 1919)
12	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 128)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
19	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
24	Twig\Template->yieldBlock (line 446)
25	Twig\Template->yieldParentBlock (line 491)
26	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
41	App\Controller\Training\Workout\WorkoutController->view (line 185)
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.48 ms
(1.34%)

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 workout_images ON t0.id = workout_images.image_id WHERE workout_images.workout_id = ? AND t0.media IN ('image') LIMIT 1

Parameters:

[
  355
]

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 workout_images ON t0.id = workout_images.image_id
WHERE
  workout_images.workout_id = ?
  AND t0.media IN ('image')
LIMIT
  1

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyCollection (line 982)
3	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->slice (line 170)
4	Doctrine\ORM\PersistentCollection->first (line 515)
5	App\Entity\Training\WorkoutTemplate->getPreviewImage (line 72)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_3e3d769eb019efecd341b3c1b8cfc985::doDisplay (line 153)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_detail (line 239)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content_section (line 203)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
19	Twig\Template->yieldBlock (line 446)
20	Twig\Template->yieldParentBlock (line 491)
21	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->block_content (line 102)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\Training\Workout\WorkoutController->view (line 185)
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.36 ms
(1.00%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	require_once (line 7)

0.34 ms
(0.93%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.32 ms
(0.90%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
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.30 ms
(0.83%)

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_afc5853107f5ff9a1352f22af8e28eec->doDisplay (line 56)
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\Workout\WorkoutController->view (line 185)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
45	require_once (line 32)
46	require_once (line 7)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Training\Translation\CategoryTranslation	24
App\Entity\Training\Translation\ExerciseTranslation	20
App\Entity\Training\Translation\ExerciseGroupTranslation	16
App\Entity\Anatomy\Translation\MuscleTranslation	12
App\Entity\Training\Exercise	10
App\Entity\Training\ExerciseGroup	9
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Media\Media	8
App\Entity\Training\Category	6
App\Entity\User	5
App\Entity\Training\Config\ExerciseConfig	5
App\Entity\Training\Config\Translation\ExerciseConfigTranslation	5
App\Entity\Training\Config\ExerciseSerieConfig	5
App\Entity\Training\Translation\ProgramTranslation	4
App\Entity\Training\Workout	3
App\Entity\Training\Translation\WorkoutTranslation	3
App\Entity\Anatomy\Muscle	3
App\Entity\Training\Material	3
App\Entity\Training\Config\WorkoutBlock	2
App\Entity\Training\Program	1
App\Entity\Training\TrainingPreferences	1

Entities Mapping

Class	Mapping errors
App\Entity\Training\Workout	No errors.
App\Entity\Training\Program	No errors.
App\Entity\Model\TechnicalMetadata	No errors.
App\Entity\User	No errors.
App\Entity\Training\WorkoutUser	No errors.
App\Entity\Training\WorkoutTemplate	No errors.
App\Entity\Training\TrainingPreferences	No errors.
App\Entity\Training\ProgramUser	No errors.
App\Entity\Training\ProgramTemplate	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\MediaImage	No errors.
App\Entity\Faq	No errors.
App\Entity\Training\Translation\ProgramTranslation	No errors.
App\Entity\Training\Translation\ProgramTemplateTranslation	No errors.
App\Entity\Training\Material	No errors.
App\Entity\Training\Config\WorkoutBlock	No errors.
App\Entity\Training\Config\ExerciseConfig	No errors.
App\Entity\Training\Translation\WorkoutTranslation	No errors.
App\Entity\Training\Translation\WorkoutTemplateTranslation	No errors.
App\Entity\Anatomy\Muscle	No errors.
App\Entity\Training\Exercise	No errors.
App\Entity\Anatomy\Translation\MuscleTranslation	No errors.
App\Entity\Training\Category	No errors.
App\Entity\Sport\Discipline	No errors.
App\Entity\Training\Translation\CategoryTranslation	No errors.
App\Entity\Training\ExerciseGroup	No errors.
App\Entity\Training\Translation\ExerciseGroupTranslation	No errors.
App\Entity\Training\Translation\MaterialTranslation	No errors.
App\Entity\Training\Config\ExerciseSerieConfig	No errors.
App\Entity\Training\Config\Translation\ExerciseConfigTranslation	No errors.
App\Entity\Training\ExerciseProposal	No errors.
App\Entity\Media\MediaVideo	No errors.
App\Entity\Training\ExerciseFavorite	No errors.
App\Entity\Training\Log\ExerciseLog	No errors.
App\Entity\Training\ExerciseAlias	No errors.
App\Entity\Training\Translation\ExerciseTranslation	No errors.
App\Entity\Media\Translation\MediaTranslation	No errors.

Symfony Profiler

GET http://test.fitmetrics.ch/fr/entrainements/68629c85effc5-seance-cardio-tonique-du-mercredi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping