Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.25 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.88 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 = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "6733d73478833"
]

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 = ?
  AND (
    (t0.deleted_at IS NULL)
  )
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 = '6733d73478833' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

1.37 ms

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ LEFT JOIN workout w1_ ON p0_.id = w1_.program_id AND w1_.type IN ('user', 'template') LEFT JOIN workout_block w2_ ON w1_.id = w2_.workout_id LEFT JOIN exercise_config e3_ ON w2_.id = e3_.workout_block_id WHERE (p0_.published = ? AND e3_.exercise_id = ?) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.token AS token_1,
  p0_.duration_weeks AS duration_weeks_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.archived AS archived_5,
  p0_.view_counter AS view_counter_6,
  p0_.source AS source_7,
  p0_.source_model AS source_model_8,
  p0_.free AS free_9,
  p0_.pinned AS pinned_10,
  p0_.published AS published_11,
  p0_.published_at AS published_at_12,
  p0_.type AS type_13,
  p0_.created_by_id AS created_by_id_14,
  p0_.preferences_id AS preferences_id_15,
  p0_.updated_by_id AS updated_by_id_16,
  p0_.publisher AS publisher_17
FROM
  program p0_
  LEFT JOIN workout w1_ ON p0_.id = w1_.program_id
  AND w1_.type IN ('user', 'template')
  LEFT JOIN workout_block w2_ ON w1_.id = w2_.workout_id
  LEFT JOIN exercise_config e3_ ON w2_.id = e3_.workout_block_id
WHERE
  (
    p0_.published = ?
    AND e3_.exercise_id = ?
  )
  AND p0_.type IN ('template')
ORDER BY
  p0_.published_at DESC

SELECT p0_.id AS id_0, p0_.token AS token_1, p0_.duration_weeks AS duration_weeks_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.archived AS archived_5, p0_.view_counter AS view_counter_6, p0_.source AS source_7, p0_.source_model AS source_model_8, p0_.free AS free_9, p0_.pinned AS pinned_10, p0_.published AS published_11, p0_.published_at AS published_at_12, p0_.type AS type_13, p0_.created_by_id AS created_by_id_14, p0_.preferences_id AS preferences_id_15, p0_.updated_by_id AS updated_by_id_16, p0_.publisher AS publisher_17 FROM program p0_ LEFT JOIN workout w1_ ON p0_.id = w1_.program_id AND w1_.type IN ('user', 'template') LEFT JOIN workout_block w2_ ON w1_.id = w2_.workout_id LEFT JOIN exercise_config e3_ ON w2_.id = e3_.workout_block_id WHERE (p0_.published = 1 AND e3_.exercise_id = 1130) AND p0_.type IN ('template') ORDER BY p0_.published_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Training\ProgramTemplateRepository->findFromExercise (line 63)
7	App\Controller\Training\Exercise\ExerciseController->{closure:App\Controller\Training\Exercise\ExerciseController::exercisePrograms():308} (line 311)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 113)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Controller\Training\Exercise\ExerciseController->exercisePrograms (line 308)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	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\Exercise	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.
App\Entity\Training\Program	No errors.
App\Entity\Training\ProgramTemplate	No errors.
App\Entity\Training\Workout	No errors.
App\Entity\Training\Config\WorkoutBlock	No errors.
App\Entity\Training\Config\ExerciseConfig	No errors.
App\Entity\Training\TrainingPreferences	No errors.
App\Entity\Training\WorkoutUser	No errors.
App\Entity\Training\WorkoutTemplate	No errors.

Symfony Profiler

GET https://test.fitmetrics.ch/it/esercizi/_programs/6733d73478833

Configuration Settings

Theme

Page Width