Query Metrics
3
Database Queries
3
Different statements
2.37 ms
Query time
10
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.98 ms (0.00%) |
1 |
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 ] |
0.97 ms (0.00%) |
1 |
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"
]
|
0.42 ms (0.00%) |
1 |
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 |
|
App\Entity\User\UserRank |
|
App\Entity\User\UserOrganization | No errors. |
App\Entity\User\UserSocialNetwork | No errors. |
App\Entity\Room\Managers |
|
App\Entity\User\Activity | No errors. |
App\Entity\Room\Discussion\DiscussionPost |
|
App\Entity\Room\Experts | No errors. |
App\Entity\Room\Project\UserCompetence |
|
App\Entity\User\Notes | No errors. |
App\Entity\Room\Discussion\Banned |
|
App\Entity\User\UserEducation | No errors. |
App\Entity\Room\Voting\UserAnswer |
|
App\Entity\User\Invitation | No errors. |
App\Entity\User\Device |
|
App\Entity\User\VerifySMS |
|
App\Entity\Notification |
|
App\Entity\Room\Project\Project | No errors. |