Query Metrics
5
Database Queries
5
Different statements
130.56 ms
Query time
1
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 26.54 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.work_schedule AS work_schedule_11, t0.telegram AS telegram_12, t0.viber AS viber_13, t0.hash_date AS hash_date_14, t0.device_id AS device_id_15, t0.active_code AS active_code_16, t0.deleted AS deleted_17, t0.debug AS debug_18, t0.dev AS dev_19, t0.date_entered AS date_entered_20, t0.notification_status AS notification_status_21, t0.email_status AS email_status_22, t0.os_type AS os_type_23, t0.manager_id AS manager_id_24 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"+380975868117"
]
|
| 2 | 25.83 ms |
SELECT t0.id AS id_1, t0.users_id AS users_id_2, t0.role_id AS role_id_3 FROM user_role t0 WHERE t0.users_id = ?
Parameters:
[
39
]
|
| 3 | 25.78 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.description AS description_4, t0.login_admin_panel AS login_admin_panel_5 FROM role t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 4 | 26.42 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.phone AS phone_6, u0_.address AS address_7, u0_.status AS status_8, u0_.email AS email_9, u0_.work_schedule AS work_schedule_10, u0_.telegram AS telegram_11, u0_.viber AS viber_12, u0_.hash_date AS hash_date_13, u0_.device_id AS device_id_14, u0_.active_code AS active_code_15, u0_.deleted AS deleted_16, u0_.debug AS debug_17, u0_.dev AS dev_18, u0_.date_entered AS date_entered_19, u0_.notification_status AS notification_status_20, u0_.email_status AS email_status_21, u0_.os_type AS os_type_22, m1_.id AS id_23, m1_.file_path AS file_path_24, m1_.type AS type_25, m1_.name AS name_26, m1_.upload_timestamp AS upload_timestamp_27, u2_.id AS id_28, u0_.manager_id AS manager_id_29, m1_.users_id AS users_id_30, u2_.users_id AS users_id_31, u2_.role_id AS role_id_32 FROM users u0_ LEFT JOIN media_object m1_ ON u0_.id = m1_.users_id LEFT JOIN user_role u2_ ON u0_.id = u2_.users_id WHERE u0_.id = ?
Parameters:
[
39
]
|
| 5 | 26.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM menu t0 INNER JOIN menu_role ON t0.id = menu_role.menu_id WHERE menu_role.role_id = ?
Parameters:
[
5
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| loe | doctrine.dbal.loe_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| loe | doctrine.orm.loe_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User |
|
| App\Entity\MediaObject | No errors. |
| App\Entity\UserToken | No errors. |
| App\Entity\AppPersonalAccount | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\MassiveNotification | No errors. |
| App\Entity\UserRole | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuItems | No errors. |
loe entity manager
No loaded entities.