GET https://test.fitmetrics.ch/it/

Query Metrics

17 Database Queries
8 Different statements
7.62 ms Query time
0 Invalid entities
67 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.31 ms
(30.32%)
6
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
]
1.74 ms
(22.91%)
4
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
]
0.99 ms
(12.94%)
2
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
]
0.59 ms
(7.77%)
1
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:
[
  29
  1
]
0.56 ms
(7.39%)
1
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
]
0.53 ms
(6.96%)
1
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:
[
  67
  68
  57
  56
  62
  60
]
0.52 ms
(6.77%)
1
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:
[
  2
  4
  17
  1
]
0.38 ms
(4.92%)
1
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
]

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\Training\Translation\MaterialTranslation 8
App\Entity\Training\Category 6
App\Entity\Anatomy\Translation\MuscleTranslation 4
App\Entity\Training\ExerciseGroup 4
App\Entity\Training\Material 2
App\Entity\User 2
App\Entity\Anatomy\Muscle 1

Entities Mapping

Class Mapping errors
App\Entity\Anatomy\Muscle No errors.
App\Entity\Model\TechnicalMetadata No errors.
App\Entity\User No errors.
App\Entity\Training\Exercise No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Media\Media No errors.
App\Entity\Media\MediaImage No errors.
App\Entity\Anatomy\Translation\MuscleTranslation No errors.
App\Entity\Training\Category No errors.
App\Entity\Sport\Discipline No errors.
App\Entity\Training\Translation\CategoryTranslation No errors.
App\Entity\Training\ExerciseGroup No errors.
App\Entity\Training\Translation\ExerciseGroupTranslation No errors.
App\Entity\Training\Material No errors.
App\Entity\Training\Translation\MaterialTranslation No errors.
App\Entity\Marketing\Lead No errors.
App\Entity\Billing\BillingCustomer 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\Media\ProfilePictureMedia No errors.
App\Entity\User\ContactProfile No errors.
App\Entity\Training\TrainingPreferences No errors.
App\Entity\FitnessProfile No errors.
App\Entity\Billing\Payment No errors.
App\Entity\Media\MediaVideo No errors.
App\Entity\Training\ExerciseProposal 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\Media\Translation\MediaTranslation No errors.
App\Entity\Sport\Translation\DisciplineTranslation No errors.
App\Entity\Media\MediaDocument No errors.
App\Entity\Billing\Subscription No errors.
App\Entity\Training\ProgramTemplate No errors.
App\Entity\Training\Workout No errors.
App\Entity\Training\Translation\ProgramTranslation No errors.
App\Entity\Training\Translation\ProgramUserTranslation No errors.
App\Entity\Training\WorkoutUser No errors.
App\Entity\Training\Log\ExerciseSerieLog No errors.
App\Entity\Blog\News No errors.
App\Entity\Translation\FaqTranslation No errors.
App\Entity\App\AppVersion No errors.
App\Entity\App\Translation\AppVersionTranslation No errors.
App\Entity\Blog\Translation\NewsTranslation No errors.
App\Entity\Blog\Tag No errors.
App\Entity\Blog\Translation\TagTranslation No errors.
App\Entity\Marketing\Newsletter\Newsletter No errors.
App\Entity\Marketing\Newsletter\NewsletterSubscriber No errors.
App\Entity\Shop\Product No errors.
App\Entity\Shop\Translation\ProductTranslation No errors.
App\Entity\Support\Contact No errors.
App\Entity\Training\Config\ExerciseConfig No errors.
App\Entity\Training\Config\Translation\ExerciseConfigTranslation No errors.
App\Entity\Training\Config\ExerciseSerieConfig No errors.
App\Entity\Training\Config\WorkoutBlock No errors.
App\Entity\Training\Program\ProgramTransfer No errors.
App\Entity\Training\Translation\ProgramTemplateTranslation No errors.
App\Entity\Training\Translation\WorkoutTranslation No errors.
App\Entity\Training\WorkoutTemplate No errors.
App\Entity\Training\Translation\WorkoutTemplateTranslation No errors.
App\Entity\Training\Translation\WorkoutUserTranslation No errors.
App\Entity\Training\ExercisePreFilter No errors.
App\Entity\Training\Translation\ExercisePreFilterTranslation No errors.
App\Entity\Training\ExerciseSearchQuery No errors.
App\Entity\Training\ProgramRequest No errors.
App\Entity\Training\ExerciseProposalVideo No errors.
App\Entity\User\UserSettings No errors.
App\Entity\User\MagicToken No errors.
App\Entity\User\ResetPasswordRequest No errors.
App\Entity\ShortUrl No errors.
App\Entity\Billing\StripeWebhook No errors.
App\Entity\Email\EmailLog No errors.
App\Entity\Email\EmailUnsubscription No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Reminder\ReminderFlow No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.