Query Metrics
2
Database Queries
2
Different statements
1.43 ms
Query time
3
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\Member |
|
| App\Entity\PermTreatmentItemLog | No errors. |
| App\Entity\UserNotificationConfiguration | No errors. |
| App\Entity\VaccinationUserPlace |
|
| App\Entity\EnabledHour | No errors. |
| App\Entity\UserNotification | No errors. |