Query Metrics

2 Database Queries
2 Different statements
1.43 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.74 ms
(52.03%)
1
SELECT count(u0_.id) AS sclr_0 FROM user_notification u0_ LEFT JOIN fos_user f1_ ON u0_.user_id = f1_.id WHERE f1_.id = ? AND u0_.viewed = ? ORDER BY u0_.createdDate DESC
Parameters:
[
  11891
  0
]
0.69 ms
(47.97%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.id AS id_10, t0.name AS name_11, t0.forced_folio AS forced_folio_12, t0.forced_roster AS forced_roster_13, t0.fcm_token AS fcm_token_14, t0.beta_check AS beta_check_15, t0.role_editor AS role_editor_16, t0.social AS social_17, t0.token_expiration_date AS token_expiration_date_18, t0.enabled_vaccination_member_search AS enabled_vaccination_member_search_19, t0.state AS state_20, t0.art_22 AS art_22_21, t0.google_authenticator_secret AS google_authenticator_secret_22, t0.email AS email_23, t0.email_canonical AS email_canonical_24, t0.member_id AS member_id_25 FROM fos_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  11891
]

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
FOS\UserBundle\Model\User No errors.
App\Entity\User
  • The mappings App\Entity\User#vaccinationUserPlaces and App\Entity\VaccinationUserPlace#user are inconsistent with each other.
App\Entity\Member
  • The mappings App\Entity\Member#benefitNoBurden and App\Entity\NoBurdenRequest#member are inconsistent with each other.
  • The mappings App\Entity\Member#benefitClaim and App\Entity\BenefitClaim#member are inconsistent with each other.
  • The association App\Entity\Member#agreement refers to the inverse side field App\Entity\Agreement#members which does not exist.
  • The mappings App\Entity\Member#benefitDentalBurden and App\Entity\DentalBurdenRequest#member are inconsistent with each other.
App\Entity\PermTreatmentItemLog No errors.
App\Entity\UserNotificationConfiguration No errors.
App\Entity\VaccinationUserPlace
  • The association App\Entity\VaccinationUserPlace#user refers to the inverse side field App\Entity\User#vaccinationsUserPlace which does not exist.
App\Entity\EnabledHour No errors.
App\Entity\UserNotification No errors.