Query Metrics
2
Database Queries
2
Different statements
5.30 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.21 ms (79.53%) |
1 |
SELECT d0_.id AS id_0, d0_.type AS type_1, d0_.identifier AS identifier_2, d0_.data AS data_3, d0_.data_calculated AS data_calculated_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.counter_id AS counter_id_7 FROM data_cache d0_ WHERE d0_.id IN (SELECT d1_.id FROM data_cache d1_ INNER JOIN counter c2_ ON d1_.counter_id = c2_.id INNER JOIN facility f3_ ON c2_.facility_id = f3_.id WHERE c2_.counter_type_id = ? AND d1_.type = ? AND (d1_.identifier BETWEEN ? AND ?))
Parameters:
[ null "day" "20260921" "20260922" ] |
|
1.08 ms (20.47%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.entry_page AS entry_page_6, t0.token AS token_7, t0.notify_on AS notify_on_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_enabled AS is_enabled_11, t0.is_deleted AS is_deleted_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM user 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\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\DataCache | No errors. |
| App\Entity\Counter | No errors. |
| App\Entity\Facility | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |