GET https://mouve-app.com/api/items/unseen

Query Metrics

4 Database Queries
4 Different statements
5.05 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.33 ms
(26.23%)
1
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 = ? AND t0.earned = ? AND t0.seen = ?
Parameters:
[
  139
  1
  0
]
1.30 ms
(25.68%)
1
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:
[
  "MathMauc"
]
1.23 ms
(24.41%)
1
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 = ? AND t0.earned = ? AND t0.seen = ?
Parameters:
[
  139
  1
  0
]
1.20 ms
(23.68%)
1
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 = ? AND t0.earned = ? AND t0.seen = ?
Parameters:
[
  139
  1
  0
]

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\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\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\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.