Query Metrics
2
Database Queries
2
Different statements
4.40 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.21 ms (73.12%) |
1 |
SELECT n0_.criticity AS criticity_0, n0_.content_text AS content_text_1, n0_.name AS name_2, n1_.created_at AS created_at_3, n1_.is_viewed AS is_viewed_4, n1_.id AS id_5, n1_.user_id AS sclr_6 FROM notification n1_ INNER JOIN notification_type n0_ ON n1_.notification_type_id = n0_.id WHERE n1_.user_id = ? AND n0_.is_app = 1 AND n0_.deleted_at IS NULL AND n1_.is_viewed = 0 ORDER BY n1_.created_at DESC LIMIT 10
Parameters:
[
40
]
|
1.18 ms (26.88%) |
1 |
SELECT t1.id AS id_2, t1.gender AS gender_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.last_logged_at AS last_logged_at_7, t1.firstname AS firstname_8, t1.lastname AS lastname_9, t1.active AS active_10, t1.phone AS phone_11, t1.deleted_at AS deleted_at_12, t1.created_at AS created_at_13, t1.updated_at AS updated_at_14, t0.is_visible AS is_visible_15, t1.image_id AS image_id_16, t1.address_id AS address_id_17, t0.cabinet_id AS cabinet_id_18, t1.type FROM user_broker t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
40
]
|
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 |
---|---|
App\Entity\User | No errors. |
App\Entity\User\Broker | No errors. |
App\Entity\Image | No errors. |
App\Entity\Address | No errors. |
App\Entity\Cabinet | No errors. |
App\Entity\Settings\Notification | No errors. |
App\Entity\Settings\NotificationType | No errors. |
App\Entity\Question\Question | No errors. |
App\Entity\Event\EventBroker | No errors. |