Query Metrics
5
Database Queries
3
Different statements
2.53 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surname AS surname_5, t0.one_time_code AS one_time_code_6, t0.expiration_one_time_code AS expiration_one_time_code_7, t0.is_active AS is_active_8, t0.is_admin_active AS is_admin_active_9, t0.role AS role_10, t0.is_ignore_permission AS is_ignore_permission_11, t0.credentials_sent AS credentials_sent_12, t0.api_token AS api_token_13 FROM cas_user t0 WHERE t0.api_token = ? LIMIT 1
Parameters:
[
"cf2ea7d208e29ed249610bdae5bda9c30e0251a59f6a5f60757cc71426e4c6e2"
]
|
| 2 | 0.87 ms |
SELECT c0_.id AS id_0, c0_.datetime AS datetime_1, c0_.latitude AS latitude_2, c0_.longitude AS longitude_3, c0_.address AS address_4, c0_.priority AS priority_5, c0_.details AS details_6, c0_.status AS status_7, c0_.admin_notes AS admin_notes_8, c0_.is_merged AS is_merged_9, c0_.merged_group_id AS merged_group_id_10, c0_.user_id AS user_id_11, c0_.type_id AS type_id_12 FROM cas_report c0_ WHERE c0_.user_id = ? ORDER BY c0_.datetime DESC, c0_.id DESC
Parameters:
[
1
]
|
| 3 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 4 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Report | 6 |
| App\Entity\ReportType | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\JTUserPermission | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\ReportType | No errors. |