http://84.23.52.87:8000/v1/user/notifications Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
2.10 ms Query time
10 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.middlename AS middlename_3, t0.email AS email_4, t0.password AS password_5, t0.login AS login_6, t0.phone_number AS phone_number_7, t0.step AS step_8, t0.view_phone AS view_phone_9, t0.verify_phone AS verify_phone_10, t0.view_email AS view_email_11, t0.roles AS roles_12, t0.avatar AS avatar_13, t0.is_confirmed_status AS is_confirmed_status_14, t0.notification_token AS notification_token_15, t0.onboarding_finished AS onboarding_finished_16, t0.is_blocked AS is_blocked_17, t0.id AS id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "done.agncy@gmail.com"
]
2 0.92 ms
SELECT count(DISTINCT n0_.id) AS sclr_0 FROM notifications n0_ LEFT JOIN projects p1_ ON n0_.project_id = p1_.id WHERE n0_.user_id = ? AND n0_.posted_at IS NOT NULL AND n0_.is_viewed = ?
Parameters:
[
  283
  0
]
3 0.36 ms
SELECT n0_.title AS title_0, n0_.description AS description_1, n0_.link AS link_2, n0_.type AS type_3, n0_.additional_data AS additional_data_4, n0_.created_at AS created_at_5, n0_.slug AS slug_6, n0_.activity AS activity_7, n0_.send_at AS send_at_8, n0_.posted_at AS posted_at_9, n0_.is_viewed AS is_viewed_10, n0_.id AS id_11, p1_.name AS name_12, p1_.color AS color_13, p1_.id AS id_14, p1_.slug AS slug_15 FROM notifications n0_ LEFT JOIN projects p1_ ON n0_.project_id = p1_.id WHERE n0_.user_id = ? AND n0_.posted_at IS NOT NULL AND n0_.is_viewed = ? ORDER BY n0_.created_at DESC, n0_.created_at DESC LIMIT 3
Parameters:
[
  283
  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\AbstractRefreshToken No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\User\User
  • The mappings App\Entity\User\User#ranks and App\Entity\User\UserRank#user are inconsistent with each other.
  • The mappings App\Entity\User\User#education and App\Entity\User\UserEducation#user are inconsistent with each other.
  • The mappings App\Entity\User\User#answers and App\Entity\Room\Voting\UserAnswer#user are inconsistent with each other.
  • The mappings App\Entity\User\User#device and App\Entity\User\Device#user are inconsistent with each other.
App\Entity\User\UserRank
  • The association App\Entity\User\UserRank#user refers to the inverse side field App\Entity\User\User#rank which does not exist.
App\Entity\User\UserOrganization No errors.
App\Entity\User\UserSocialNetwork No errors.
App\Entity\Room\Managers
  • The association App\Entity\Room\Managers#federal refers to the inverse side field App\Entity\Room\Project\Federal#managers which does not exist.
App\Entity\User\Activity No errors.
App\Entity\Room\Discussion\DiscussionPost
  • The association App\Entity\Room\Discussion\DiscussionPost#event refers to the inverse side field App\Entity\Room\Event#posts which does not exist.
App\Entity\Room\Experts No errors.
App\Entity\Room\Project\UserCompetence
  • The association App\Entity\Room\Project\UserCompetence#project refers to the inverse side field App\Entity\Room\Project\Project#userCompetences which does not exist.
  • The association App\Entity\Room\Project\UserCompetence#federal refers to the inverse side field App\Entity\Room\Project\Federal#userCompetences which does not exist.
App\Entity\User\Notes No errors.
App\Entity\Room\Discussion\Banned
  • The association App\Entity\Room\Discussion\Banned#event refers to the inverse side field App\Entity\Room\Event#banned which does not exist.
App\Entity\User\UserEducation No errors.
App\Entity\Room\Voting\UserAnswer
  • The association App\Entity\Room\Voting\UserAnswer#voting refers to the inverse side field App\Entity\Room\Voting\Voting#questions which does not exist.
  • The association App\Entity\Room\Voting\UserAnswer#user refers to the inverse side field App\Entity\User\User#asnwers which does not exist.
App\Entity\User\Invitation No errors.
App\Entity\User\Device
  • The association App\Entity\User\Device#user refers to the inverse side field App\Entity\User\User#devices which does not exist.
  • The association App\Entity\User\Device#verifySMS refers to the owning side field App\Entity\User\VerifySMS#Device which does not exist.
App\Entity\User\VerifySMS
  • The mappings App\Entity\User\VerifySMS#device and App\Entity\User\Device#verifySMS are inconsistent with each other.
App\Entity\Notification
  • The association App\Entity\Notification#user refers to the inverse side field App\Entity\User\User#notifications which does not exist.
  • The association App\Entity\Notification#project refers to the inverse side field App\Entity\Room\Project\Project#notifications which does not exist.
App\Entity\Room\Project\Project No errors.