GET https://mouve-app.com/api/user

Query Metrics

29 Database Queries
16 Different statements
41.75 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.37 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.total_completed_days AS total_completed_days_5, t0.creation_date AS creation_date_6, t0.starting_date AS starting_date_7, t0.week_completed_percents AS week_completed_percents_8, t0.notes AS notes_9, t0.max_completed_days AS max_completed_days_10 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "LeEnzo"
]
2 1.70 ms
SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ? AND t0.is_weekly = ? AND t0.completed = ? LIMIT 1
Parameters:
[
  144
  1
  0
]
3 1.25 ms
SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.avatar_id AS avatar_id_6 FROM user_avatar t0 WHERE t0.user_id = ?
Parameters:
[
  144
]
4 1.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.level AS level_5, t0.avatar_type_id AS avatar_type_id_6, t0.badge_id AS badge_id_7 FROM avatar t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 1.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.level AS level_5, t0.avatar_type_id AS avatar_type_id_6, t0.badge_id AS badge_id_7 FROM avatar t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 1.13 ms
SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.accessory_id AS accessory_id_5, t0.user_id AS user_id_6 FROM user_accessory t0 WHERE t0.user_id = ?
Parameters:
[
  144
]
7 1.19 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.unlock_how AS unlock_how_4, t0.avatar_id AS avatar_id_5, t0.badge_id AS badge_id_6 FROM accessory t0 WHERE t0.avatar_id = ?
Parameters:
[
  2
]
8 1.21 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.unlock_how AS unlock_how_4, t0.avatar_id AS avatar_id_5, t0.badge_id AS badge_id_6 FROM accessory t0 WHERE t0.id = ?
Parameters:
[
  7
]
9 1.13 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.unlock_how AS unlock_how_4, t0.avatar_id AS avatar_id_5, t0.badge_id AS badge_id_6 FROM accessory t0 WHERE t0.id = ?
Parameters:
[
  8
]
10 1.90 ms
SELECT sum(e0_.to_do_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = ? AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1)
Parameters:
[
  144
]
11 1.97 ms
SELECT sum(e0_.daily_completed_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = ? AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1)
Parameters:
[
  144
]
12 3.37 ms
SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ?
Parameters:
[
  144
]
13 4.19 ms
SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ? AND t0.completed = ?
Parameters:
[
  144
  1
]
14 1.46 ms
SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.badge_id AS badge_id_6 FROM user_badge t0 WHERE t0.user_id = ?
Parameters:
[
  144
]
15 1.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.raw_value AS raw_value_3 FROM avatar_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 1.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 1.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  7
]
18 1.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  8
]
19 1.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  9
]
20 1.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  10
]
21 1.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  14
]
22 1.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  15
]
23 1.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  18
]
24 1.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  19
]
25 1.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  23
]
26 1.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  24
]
27 1.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?
Parameters:
[
  25
]
28 1.37 ms
SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent_by_default AS is_permanent_by_default_13, t0.is_weekly_by_default AS is_weekly_by_default_14, t0.to_do_count AS to_do_count_15, t0.added_value AS added_value_16, t0.position AS position_17, t0.type_id AS type_id_18, t0.badge_type_id AS badge_type_id_19, t0.linked_badge_id AS linked_badge_id_20 FROM exercise_template t0 WHERE t0.id = ?
Parameters:
[
  21
]
29 1.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3 FROM exercise_type t0 WHERE t0.id = ?
Parameters:
[
  5
]

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.

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\User No errors.
App\Entity\Exercise No errors.
App\Entity\UserBadge No errors.
App\Entity\UserAccessory No errors.
App\Entity\UserAvatar No errors.
App\Entity\UserExerciseType No errors.
App\Entity\UserBadgeType No errors.
App\Entity\ExerciseTemplate No errors.
App\Entity\Avatar
  • The field App\Entity\Avatar#userAvatars is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserAvatar#avatar does not contain the required 'inversedBy="userAvatars"' attribute.
App\Entity\AvatarType No errors.
App\Entity\Badge
  • The field App\Entity\Badge#userBadges is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserBadge#badge does not contain the required 'inversedBy="userBadges"' attribute.
App\Entity\Accessory
  • The field App\Entity\Accessory#userAccessories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserAccessory#accessory does not contain the required 'inversedBy="userAccessories"' attribute.
App\Entity\BadgeType
  • The field App\Entity\BadgeType#userBadgeTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserBadgeType#badgeType does not contain the required 'inversedBy="userBadgeTypes"' attribute.
App\Entity\ExerciseType
  • The field App\Entity\ExerciseType#userExerciseTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserExerciseType#exerciseType does not contain the required 'inversedBy="userExerciseTypes"' attribute.