Symfony Profiler

Query Metrics

41 Database Queries

12 Different statements

19.67 ms Query time

0 Invalid entities

108 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.08 ms
(20.73%)

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, t17.uuid AS uuid_18, t17.email AS email_19, t17.roles AS roles_20, t17.password AS password_21, t17.firstname AS firstname_22, t17.lastname AS lastname_23, t17.username AS username_24, t17.birthday AS birthday_25, t17.lang AS lang_26, t17.last_login AS last_login_27, t17.stripe_customer_id AS stripe_customer_id_28, t17.last_change_username AS last_change_username_29, t17.last_change_password AS last_change_password_30, t17.description_editor AS description_editor_31, t17.special_mention AS special_mention_32, t17.prefer_username AS prefer_username_33, t17.settings AS settings_34, t17.preferences AS preferences_35, t17.signup_context AS signup_context_36, t17.last_login_ip AS last_login_ip_37, t17.signup_ip AS signup_ip_38, t17.country AS country_39, t17.can_delete_account AS can_delete_account_40, t17.last_used_os AS last_used_os_41, t17.invited_from AS invited_from_42, t17.google AS google_43, t17.apple AS apple_44, t17.last_login_context AS last_login_context_45, t17.show_as_contributor AS show_as_contributor_46, t17.id AS id_47, t17.created_at AS created_at_48, t17.updated_at AS updated_at_49, t17.deleted_at AS deleted_at_50, t17.active AS active_51, t17.technical_created_from_ip AS technical_created_from_ip_52, t17.technical_updated_from_ip AS technical_updated_from_ip_53, t17.technical_user_agent AS technical_user_agent_54, t17.technical_device_type AS technical_device_type_55, t17.technical_os_name AS technical_os_name_56, t17.technical_os_version AS technical_os_version_57, t17.technical_browser_name AS technical_browser_name_58, t17.technical_browser_version AS technical_browser_version_59, t17.technical_timezone AS technical_timezone_60, t17.technical_locale AS technical_locale_61, t17.technical_preferred_language AS technical_preferred_language_62, t17.technical_is_bot AS technical_is_bot_63, t17.technical_device_model AS technical_device_model_64, t17.technical_device_vendor AS technical_device_vendor_65, t17.technical_engine_name AS technical_engine_name_66, t17.technical_engine_version AS technical_engine_version_67, t17.technical_cpu_architecture AS technical_cpu_architecture_68, t17.technical_client_type AS technical_client_type_69, t17.technical_app_bundle_id AS technical_app_bundle_id_70, t17.technical_app_version AS technical_app_version_71, t17.technical_app_build_version AS technical_app_build_version_72, t17.technical_country AS technical_country_73, t17.invited_by_id AS invited_by_id_74, t17.profile_picture_id AS profile_picture_id_75, t17.profil_id AS profil_id_76, t17.training_preferences_id AS training_preferences_id_77, t17.fitness_profile_id AS fitness_profile_id_78, t17.created_by_id AS created_by_id_79, t17.updated_by_id AS updated_by_id_80, t0.media FROM media t0 LEFT JOIN user t17 ON t17.profile_picture_id = t0.id AND ((t17.deleted_at IS NULL)) WHERE t0.id = ? AND t0.media IN ('profile_picture')

Parameters:

[
  504
]

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,
  t17.uuid AS uuid_18,
  t17.email AS email_19,
  t17.roles AS roles_20,
  t17.password AS password_21,
  t17.firstname AS firstname_22,
  t17.lastname AS lastname_23,
  t17.username AS username_24,
  t17.birthday AS birthday_25,
  t17.lang AS lang_26,
  t17.last_login AS last_login_27,
  t17.stripe_customer_id AS stripe_customer_id_28,
  t17.last_change_username AS last_change_username_29,
  t17.last_change_password AS last_change_password_30,
  t17.description_editor AS description_editor_31,
  t17.special_mention AS special_mention_32,
  t17.prefer_username AS prefer_username_33,
  t17.settings AS settings_34,
  t17.preferences AS preferences_35,
  t17.signup_context AS signup_context_36,
  t17.last_login_ip AS last_login_ip_37,
  t17.signup_ip AS signup_ip_38,
  t17.country AS country_39,
  t17.can_delete_account AS can_delete_account_40,
  t17.last_used_os AS last_used_os_41,
  t17.invited_from AS invited_from_42,
  t17.google AS google_43,
  t17.apple AS apple_44,
  t17.last_login_context AS last_login_context_45,
  t17.show_as_contributor AS show_as_contributor_46,
  t17.id AS id_47,
  t17.created_at AS created_at_48,
  t17.updated_at AS updated_at_49,
  t17.deleted_at AS deleted_at_50,
  t17.active AS active_51,
  t17.technical_created_from_ip AS technical_created_from_ip_52,
  t17.technical_updated_from_ip AS technical_updated_from_ip_53,
  t17.technical_user_agent AS technical_user_agent_54,
  t17.technical_device_type AS technical_device_type_55,
  t17.technical_os_name AS technical_os_name_56,
  t17.technical_os_version AS technical_os_version_57,
  t17.technical_browser_name AS technical_browser_name_58,
  t17.technical_browser_version AS technical_browser_version_59,
  t17.technical_timezone AS technical_timezone_60,
  t17.technical_locale AS technical_locale_61,
  t17.technical_preferred_language AS technical_preferred_language_62,
  t17.technical_is_bot AS technical_is_bot_63,
  t17.technical_device_model AS technical_device_model_64,
  t17.technical_device_vendor AS technical_device_vendor_65,
  t17.technical_engine_name AS technical_engine_name_66,
  t17.technical_engine_version AS technical_engine_version_67,
  t17.technical_cpu_architecture AS technical_cpu_architecture_68,
  t17.technical_client_type AS technical_client_type_69,
  t17.technical_app_bundle_id AS technical_app_bundle_id_70,
  t17.technical_app_version AS technical_app_version_71,
  t17.technical_app_build_version AS technical_app_build_version_72,
  t17.technical_country AS technical_country_73,
  t17.invited_by_id AS invited_by_id_74,
  t17.profile_picture_id AS profile_picture_id_75,
  t17.profil_id AS profil_id_76,
  t17.training_preferences_id AS training_preferences_id_77,
  t17.fitness_profile_id AS fitness_profile_id_78,
  t17.created_by_id AS created_by_id_79,
  t17.updated_by_id AS updated_by_id_80,
  t0.media
FROM
  media t0
  LEFT JOIN user t17 ON t17.profile_picture_id = t0.id
  AND (
    (t17.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND t0.media IN ('profile_picture')

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, t17.uuid AS uuid_18, t17.email AS email_19, t17.roles AS roles_20, t17.password AS password_21, t17.firstname AS firstname_22, t17.lastname AS lastname_23, t17.username AS username_24, t17.birthday AS birthday_25, t17.lang AS lang_26, t17.last_login AS last_login_27, t17.stripe_customer_id AS stripe_customer_id_28, t17.last_change_username AS last_change_username_29, t17.last_change_password AS last_change_password_30, t17.description_editor AS description_editor_31, t17.special_mention AS special_mention_32, t17.prefer_username AS prefer_username_33, t17.settings AS settings_34, t17.preferences AS preferences_35, t17.signup_context AS signup_context_36, t17.last_login_ip AS last_login_ip_37, t17.signup_ip AS signup_ip_38, t17.country AS country_39, t17.can_delete_account AS can_delete_account_40, t17.last_used_os AS last_used_os_41, t17.invited_from AS invited_from_42, t17.google AS google_43, t17.apple AS apple_44, t17.last_login_context AS last_login_context_45, t17.show_as_contributor AS show_as_contributor_46, t17.id AS id_47, t17.created_at AS created_at_48, t17.updated_at AS updated_at_49, t17.deleted_at AS deleted_at_50, t17.active AS active_51, t17.technical_created_from_ip AS technical_created_from_ip_52, t17.technical_updated_from_ip AS technical_updated_from_ip_53, t17.technical_user_agent AS technical_user_agent_54, t17.technical_device_type AS technical_device_type_55, t17.technical_os_name AS technical_os_name_56, t17.technical_os_version AS technical_os_version_57, t17.technical_browser_name AS technical_browser_name_58, t17.technical_browser_version AS technical_browser_version_59, t17.technical_timezone AS technical_timezone_60, t17.technical_locale AS technical_locale_61, t17.technical_preferred_language AS technical_preferred_language_62, t17.technical_is_bot AS technical_is_bot_63, t17.technical_device_model AS technical_device_model_64, t17.technical_device_vendor AS technical_device_vendor_65, t17.technical_engine_name AS technical_engine_name_66, t17.technical_engine_version AS technical_engine_version_67, t17.technical_cpu_architecture AS technical_cpu_architecture_68, t17.technical_client_type AS technical_client_type_69, t17.technical_app_bundle_id AS technical_app_bundle_id_70, t17.technical_app_version AS technical_app_version_71, t17.technical_app_build_version AS technical_app_build_version_72, t17.technical_country AS technical_country_73, t17.invited_by_id AS invited_by_id_74, t17.profile_picture_id AS profile_picture_id_75, t17.profil_id AS profil_id_76, t17.training_preferences_id AS training_preferences_id_77, t17.fitness_profile_id AS fitness_profile_id_78, t17.created_by_id AS created_by_id_79, t17.updated_by_id AS updated_by_id_80, t0.media FROM media t0 LEFT JOIN user t17 ON t17.profile_picture_id = t0.id AND ((t17.deleted_at IS NULL)) WHERE t0.id = 504 AND t0.media IN ('profile_picture');

#	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\Media\Media::getUploadedFile (line 91)
5	App\BusinessLogic\Media\Manager\MediaManager->getPublicUrl (line 65)
6	App\Twig\Components\Media\Image->getSrc (line 38)
7	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 90)
8	iterator_to_array (line 50)
9	Symfony\UX\TwigComponent\ComponentProperties::getProperties (line 50)
10	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 114)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 63)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
14	__TwigTemplate_620d0114085c05c72e739e1c52c208cb->doDisplay (line 53)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
19	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
20	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
21	__TwigTemplate_e371b9805f88dfea58b65f9dc9b2e570->doDisplay (line 109)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_a755ca877bfed0accfc13669bae9e511->block_content_section (line 77)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
26	Twig\Template->yieldBlock (line 446)
27	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_body (line 449)
28	Twig\Template->yieldBlock (line 446)
29	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->doDisplay (line 135)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
32	Twig\Template->yield (line 402)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 373)
35	Twig\TemplateWrapper->render (line 51)
36	Twig\Environment->render (line 333)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
40	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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)

3.12 ms
(15.85%)

SELECT t0.contact_email AS contact_email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.language AS language_5, t0.birth_date AS birth_date_6, t0.morphotype AS morphotype_7, t0.height AS height_8, t0.weight AS weight_9, t0.measurement_system AS measurement_system_10, t0.special_mention AS special_mention_11, t0.description_editor AS description_editor_12, t0.instagram AS instagram_13, t0.threads AS threads_14, t0.youtube AS youtube_15, t0.snapchat AS snapchat_16, t0.tiktok AS tiktok_17, t0.id AS id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22 FROM contact_profile t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.contact_email AS contact_email_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.gender AS gender_4,
  t0.language AS language_5,
  t0.birth_date AS birth_date_6,
  t0.morphotype AS morphotype_7,
  t0.height AS height_8,
  t0.weight AS weight_9,
  t0.measurement_system AS measurement_system_10,
  t0.special_mention AS special_mention_11,
  t0.description_editor AS description_editor_12,
  t0.instagram AS instagram_13,
  t0.threads AS threads_14,
  t0.youtube AS youtube_15,
  t0.snapchat AS snapchat_16,
  t0.tiktok AS tiktok_17,
  t0.id AS id_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.created_by_id AS created_by_id_21,
  t0.updated_by_id AS updated_by_id_22
FROM
  contact_profile t0
WHERE
  t0.id = ?

SELECT t0.contact_email AS contact_email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.language AS language_5, t0.birth_date AS birth_date_6, t0.morphotype AS morphotype_7, t0.height AS height_8, t0.weight AS weight_9, t0.measurement_system AS measurement_system_10, t0.special_mention AS special_mention_11, t0.description_editor AS description_editor_12, t0.instagram AS instagram_13, t0.threads AS threads_14, t0.youtube AS youtube_15, t0.snapchat AS snapchat_16, t0.tiktok AS tiktok_17, t0.id AS id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22 FROM contact_profile t0 WHERE t0.id = 2;

#	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\User\ContactProfile::getSpecialMention (line 261)
5	App\Entity\User->getSpecialMention (line 921)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_620d0114085c05c72e739e1c52c208cb::doDisplay (line 67)
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_e371b9805f88dfea58b65f9dc9b2e570->doDisplay (line 109)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a755ca877bfed0accfc13669bae9e511->block_content_section (line 77)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_6fd613465a3eb0849fd8fa1a5a66e302->block_content (line 567)
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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
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\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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)

2.93 ms
(14.90%)

SELECT t0.stripe_customer_id AS stripe_customer_id_1, t0.billing_email AS billing_email_2, t0.currency AS currency_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7 FROM billing_customer t0 WHERE t0.user_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.stripe_customer_id AS stripe_customer_id_1,
  t0.billing_email AS billing_email_2,
  t0.currency AS currency_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.user_id AS user_id_7
FROM
  billing_customer t0
WHERE
  t0.user_id = ?

SELECT t0.stripe_customer_id AS stripe_customer_id_1, t0.billing_email AS billing_email_2, t0.currency AS currency_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7 FROM billing_customer t0 WHERE t0.user_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\User\UserRepository->getContributors (line 515)
12	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 68)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 7)

2.90 ms
(14.72%)

SELECT u0_.uuid AS uuid_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.username AS username_6, u0_.birthday AS birthday_7, u0_.lang AS lang_8, u0_.last_login AS last_login_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.last_change_username AS last_change_username_11, u0_.last_change_password AS last_change_password_12, u0_.description_editor AS description_editor_13, u0_.special_mention AS special_mention_14, u0_.prefer_username AS prefer_username_15, u0_.settings AS settings_16, u0_.preferences AS preferences_17, u0_.signup_context AS signup_context_18, u0_.last_login_ip AS last_login_ip_19, u0_.signup_ip AS signup_ip_20, u0_.country AS country_21, u0_.can_delete_account AS can_delete_account_22, u0_.last_used_os AS last_used_os_23, u0_.invited_from AS invited_from_24, u0_.google AS google_25, u0_.apple AS apple_26, u0_.last_login_context AS last_login_context_27, u0_.show_as_contributor AS show_as_contributor_28, u0_.id AS id_29, u0_.created_at AS created_at_30, u0_.updated_at AS updated_at_31, u0_.deleted_at AS deleted_at_32, u0_.active AS active_33, u0_.technical_created_from_ip AS technical_created_from_ip_34, u0_.technical_updated_from_ip AS technical_updated_from_ip_35, u0_.technical_user_agent AS technical_user_agent_36, u0_.technical_device_type AS technical_device_type_37, u0_.technical_os_name AS technical_os_name_38, u0_.technical_os_version AS technical_os_version_39, u0_.technical_browser_name AS technical_browser_name_40, u0_.technical_browser_version AS technical_browser_version_41, u0_.technical_timezone AS technical_timezone_42, u0_.technical_locale AS technical_locale_43, u0_.technical_preferred_language AS technical_preferred_language_44, u0_.technical_is_bot AS technical_is_bot_45, u0_.technical_device_model AS technical_device_model_46, u0_.technical_device_vendor AS technical_device_vendor_47, u0_.technical_engine_name AS technical_engine_name_48, u0_.technical_engine_version AS technical_engine_version_49, u0_.technical_cpu_architecture AS technical_cpu_architecture_50, u0_.technical_client_type AS technical_client_type_51, u0_.technical_app_bundle_id AS technical_app_bundle_id_52, u0_.technical_app_version AS technical_app_version_53, u0_.technical_app_build_version AS technical_app_build_version_54, u0_.technical_country AS technical_country_55, u0_.invited_by_id AS invited_by_id_56, u0_.profile_picture_id AS profile_picture_id_57, u0_.profil_id AS profil_id_58, u0_.training_preferences_id AS training_preferences_id_59, u0_.fitness_profile_id AS fitness_profile_id_60, u0_.created_by_id AS created_by_id_61, u0_.updated_by_id AS updated_by_id_62 FROM user u0_ WHERE (u0_.show_as_contributor = 1) AND (u0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.uuid AS uuid_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.firstname AS firstname_4,
  u0_.lastname AS lastname_5,
  u0_.username AS username_6,
  u0_.birthday AS birthday_7,
  u0_.lang AS lang_8,
  u0_.last_login AS last_login_9,
  u0_.stripe_customer_id AS stripe_customer_id_10,
  u0_.last_change_username AS last_change_username_11,
  u0_.last_change_password AS last_change_password_12,
  u0_.description_editor AS description_editor_13,
  u0_.special_mention AS special_mention_14,
  u0_.prefer_username AS prefer_username_15,
  u0_.settings AS settings_16,
  u0_.preferences AS preferences_17,
  u0_.signup_context AS signup_context_18,
  u0_.last_login_ip AS last_login_ip_19,
  u0_.signup_ip AS signup_ip_20,
  u0_.country AS country_21,
  u0_.can_delete_account AS can_delete_account_22,
  u0_.last_used_os AS last_used_os_23,
  u0_.invited_from AS invited_from_24,
  u0_.google AS google_25,
  u0_.apple AS apple_26,
  u0_.last_login_context AS last_login_context_27,
  u0_.show_as_contributor AS show_as_contributor_28,
  u0_.id AS id_29,
  u0_.created_at AS created_at_30,
  u0_.updated_at AS updated_at_31,
  u0_.deleted_at AS deleted_at_32,
  u0_.active AS active_33,
  u0_.technical_created_from_ip AS technical_created_from_ip_34,
  u0_.technical_updated_from_ip AS technical_updated_from_ip_35,
  u0_.technical_user_agent AS technical_user_agent_36,
  u0_.technical_device_type AS technical_device_type_37,
  u0_.technical_os_name AS technical_os_name_38,
  u0_.technical_os_version AS technical_os_version_39,
  u0_.technical_browser_name AS technical_browser_name_40,
  u0_.technical_browser_version AS technical_browser_version_41,
  u0_.technical_timezone AS technical_timezone_42,
  u0_.technical_locale AS technical_locale_43,
  u0_.technical_preferred_language AS technical_preferred_language_44,
  u0_.technical_is_bot AS technical_is_bot_45,
  u0_.technical_device_model AS technical_device_model_46,
  u0_.technical_device_vendor AS technical_device_vendor_47,
  u0_.technical_engine_name AS technical_engine_name_48,
  u0_.technical_engine_version AS technical_engine_version_49,
  u0_.technical_cpu_architecture AS technical_cpu_architecture_50,
  u0_.technical_client_type AS technical_client_type_51,
  u0_.technical_app_bundle_id AS technical_app_bundle_id_52,
  u0_.technical_app_version AS technical_app_version_53,
  u0_.technical_app_build_version AS technical_app_build_version_54,
  u0_.technical_country AS technical_country_55,
  u0_.invited_by_id AS invited_by_id_56,
  u0_.profile_picture_id AS profile_picture_id_57,
  u0_.profil_id AS profil_id_58,
  u0_.training_preferences_id AS training_preferences_id_59,
  u0_.fitness_profile_id AS fitness_profile_id_60,
  u0_.created_by_id AS created_by_id_61,
  u0_.updated_by_id AS updated_by_id_62
FROM
  user u0_
WHERE
  (u0_.show_as_contributor = 1)
  AND (u0_.deleted_at IS NULL)

SELECT u0_.uuid AS uuid_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.username AS username_6, u0_.birthday AS birthday_7, u0_.lang AS lang_8, u0_.last_login AS last_login_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.last_change_username AS last_change_username_11, u0_.last_change_password AS last_change_password_12, u0_.description_editor AS description_editor_13, u0_.special_mention AS special_mention_14, u0_.prefer_username AS prefer_username_15, u0_.settings AS settings_16, u0_.preferences AS preferences_17, u0_.signup_context AS signup_context_18, u0_.last_login_ip AS last_login_ip_19, u0_.signup_ip AS signup_ip_20, u0_.country AS country_21, u0_.can_delete_account AS can_delete_account_22, u0_.last_used_os AS last_used_os_23, u0_.invited_from AS invited_from_24, u0_.google AS google_25, u0_.apple AS apple_26, u0_.last_login_context AS last_login_context_27, u0_.show_as_contributor AS show_as_contributor_28, u0_.id AS id_29, u0_.created_at AS created_at_30, u0_.updated_at AS updated_at_31, u0_.deleted_at AS deleted_at_32, u0_.active AS active_33, u0_.technical_created_from_ip AS technical_created_from_ip_34, u0_.technical_updated_from_ip AS technical_updated_from_ip_35, u0_.technical_user_agent AS technical_user_agent_36, u0_.technical_device_type AS technical_device_type_37, u0_.technical_os_name AS technical_os_name_38, u0_.technical_os_version AS technical_os_version_39, u0_.technical_browser_name AS technical_browser_name_40, u0_.technical_browser_version AS technical_browser_version_41, u0_.technical_timezone AS technical_timezone_42, u0_.technical_locale AS technical_locale_43, u0_.technical_preferred_language AS technical_preferred_language_44, u0_.technical_is_bot AS technical_is_bot_45, u0_.technical_device_model AS technical_device_model_46, u0_.technical_device_vendor AS technical_device_vendor_47, u0_.technical_engine_name AS technical_engine_name_48, u0_.technical_engine_version AS technical_engine_version_49, u0_.technical_cpu_architecture AS technical_cpu_architecture_50, u0_.technical_client_type AS technical_client_type_51, u0_.technical_app_bundle_id AS technical_app_bundle_id_52, u0_.technical_app_version AS technical_app_version_53, u0_.technical_app_build_version AS technical_app_build_version_54, u0_.technical_country AS technical_country_55, u0_.invited_by_id AS invited_by_id_56, u0_.profile_picture_id AS profile_picture_id_57, u0_.profil_id AS profil_id_58, u0_.training_preferences_id AS training_preferences_id_59, u0_.fitness_profile_id AS fitness_profile_id_60, u0_.created_by_id AS created_by_id_61, u0_.updated_by_id AS updated_by_id_62 FROM user u0_ WHERE (u0_.show_as_contributor = 1) AND (u0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
3	Doctrine\ORM\Query->_doExecute (line 296)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
5	Doctrine\ORM\AbstractQuery->execute (line 886)
6	Doctrine\ORM\AbstractQuery->getResult (line 688)
7	App\Repository\User\UserRepository->getContributors (line 515)
8	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 68)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 7)

2.44 ms
(12.39%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
40	Twig\Template->yield (line 402)
41	Twig\Template->display (line 358)
42	Twig\Template->render (line 373)
43	Twig\TemplateWrapper->render (line 51)
44	Twig\Environment->render (line 333)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
48	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.27 ms
(6.48%)

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

0.75 ms
(3.82%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
46	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.48 ms
(2.45%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
38	Twig\Template->yield (line 402)
39	Twig\Template->display (line 358)
40	Twig\Template->render (line 373)
41	Twig\TemplateWrapper->render (line 51)
42	Twig\Environment->render (line 333)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
46	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.48 ms
(2.44%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.46 ms
(2.33%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.42 ms
(2.12%)

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_a755ca877bfed0accfc13669bae9e511->doDisplay (line 53)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\Training\Exercise\Collection\ExerciseParticipantController->participants (line 70)
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.35 ms
(1.77%)

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

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Training\Translation\CategoryTranslation	24
App\Entity\Training\Translation\ExerciseGroupTranslation	16
App\Entity\User	10
App\Entity\User\ContactProfile	8
App\Entity\Training\TrainingPreferences	8
App\Entity\FitnessProfile	8
App\Entity\Training\Translation\MaterialTranslation	8
App\Entity\Media\Media	7
App\Entity\Training\Category	6
App\Entity\Anatomy\Translation\MuscleTranslation	4
App\Entity\Training\ExerciseGroup	4
App\Entity\Billing\BillingCustomer	2
App\Entity\Training\Material	2
App\Entity\Anatomy\Muscle	1

Entities Mapping

Class	Mapping errors
App\Entity\Model\TechnicalMetadata	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\ProfilePictureMedia	No errors.
App\Entity\User\ContactProfile	No errors.
App\Entity\Training\TrainingPreferences	No errors.
App\Entity\FitnessProfile	No errors.
App\Entity\Training\Exercise	No errors.
App\Entity\Marketing\Lead	No errors.
App\Entity\Billing\BillingCustomer	No errors.
App\Entity\Billing\Payment	No errors.
App\Entity\Billing\Subscription	No errors.
App\Entity\Training\ExerciseFavorite	No errors.
App\Entity\Training\Program	No errors.
App\Entity\Training\ProgramUser	No errors.
App\Entity\Training\Log\WorkoutLog	No errors.
App\Entity\Coaching\CoachingRequest	No errors.
App\Entity\Coaching\CoachAssignment	No errors.
App\Entity\Billing\Purchase	No errors.
App\Entity\Anatomy\Muscle	No errors.
App\Entity\Media\MediaImage	No errors.
App\Entity\Anatomy\Translation\MuscleTranslation	No errors.
App\Entity\Training\Category	No errors.
App\Entity\Sport\Discipline	No errors.
App\Entity\Training\Translation\CategoryTranslation	No errors.
App\Entity\Training\ExerciseGroup	No errors.
App\Entity\Training\Translation\ExerciseGroupTranslation	No errors.
App\Entity\Training\Material	No errors.
App\Entity\Training\Translation\MaterialTranslation	No errors.
App\Entity\Media\Translation\MediaTranslation	No errors.

Symfony Profiler

GET https://test.fitmetrics.ch/en/exercises/participants

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping