Query Metrics
5
Database Queries
4
Different statements
3.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.64 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.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 3 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 4 | 0.78 ms |
SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = ? ORDER BY n0_.create_date DESC
Parameters:
[
1
]
|
| 5 | 0.83 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.icon AS icon_3, n0_.initiated_by AS initiated_by_4, n0_.is_read AS is_read_5, n0_.create_date AS create_date_6, n0_.modify_date AS modify_date_7, n0_.is_deleted AS is_deleted_8, n0_.url AS url_9, n0_.url_mobile AS url_mobile_10, n0_.to_user_id AS to_user_id_11, n0_.created_by_user_id AS created_by_user_id_12, n0_.modified_by_user_id AS modified_by_user_id_13 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = ? ORDER BY n0_.create_date DESC LIMIT 5
Parameters:
[
1
]
|
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\UserGroup | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\TaskTemplate | No errors. |
| App\Entity\TaskLog | No errors. |
| App\Entity\ManualProductMoveHistory | No errors. |
| App\Entity\OrderAction | No errors. |
| App\Entity\AppointmentTemplate | No errors. |
| App\Entity\AppointmentLog | No errors. |
| App\Entity\Proposal | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Shortcut | No errors. |
| App\Entity\UserTablePreference | No errors. |
| App\Entity\EnvironmentParameter | No errors. |