Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.60 ms Query time

0 Invalid entities

9 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.74 ms

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

Parameters:

[
  "6522abac989eb"
]

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

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.token = '6522abac989eb' 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\Exercise\ExerciseController->findExerciseOrRedirect (line 375)
5	App\Controller\Training\Exercise\ExerciseController->detail (line 75)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 7)

0.87 ms

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:

[
  53
]

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

#	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\Controller\Training\Exercise\ExerciseController->findExerciseOrRedirect (line 401)
11	App\Controller\Training\Exercise\ExerciseController->detail (line 75)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 7)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Training\Translation\ExerciseTranslation	4
App\Entity\Training\Exercise	2
App\Entity\User	2
App\Entity\Training\ExerciseGroup	1

Entities Mapping

Class	Mapping errors
App\Entity\Training\Exercise	No errors.
App\Entity\Training\ExerciseGroup	No errors.
App\Entity\Model\TechnicalMetadata	No errors.
App\Entity\User	No errors.
App\Entity\Training\ExerciseProposal	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Media\MediaImage	No errors.
App\Entity\Media\MediaVideo	No errors.
App\Entity\Anatomy\Muscle	No errors.
App\Entity\Training\Category	No errors.
App\Entity\Training\Material	No errors.
App\Entity\Sport\Discipline	No errors.
App\Entity\Training\ExerciseFavorite	No errors.
App\Entity\Training\Log\ExerciseLog	No errors.
App\Entity\Training\ExerciseAlias	No errors.
App\Entity\Faq	No errors.
App\Entity\Training\Translation\ExerciseTranslation	No errors.

Symfony Profiler

GET https://test.fitmetrics.ch/de/ubung/6522abac989eb-traction-prise-supination

Configuration Settings

Theme

Page Width