Query Metrics
274
Database Queries
6
Different statements
45.88 ms
Query time
1
Invalid entities
547
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
38.96 ms (84.90%) |
259 |
SELECT t0.id AS id_1, t0.media AS media_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.tenant_id AS tenant_id_5 FROM tenant_media t0 WHERE t0.tenant_id = ?
Parameters:
[
5
]
|
|
3.93 ms (8.56%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.phone AS phone_5, t0.weekdays AS weekdays_6, t0.weekend AS weekend_7, t0.notice AS notice_8, t0.find AS find_9, t0.route AS route_10, t0.search_aliases AS search_aliases_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.floor_id AS floor_id_14, t0.area_id AS area_id_15, t0.node_id AS node_id_16 FROM tenant t0 INNER JOIN tenant_category ON t0.id = tenant_category.tenant_id WHERE tenant_category.category_id = ?
Parameters:
[
8
]
|
|
1.02 ms (2.23%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.search_aliases AS search_aliases_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id = ?
Parameters:
[
8
]
|
|
0.98 ms (2.14%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.search_aliases AS search_aliases_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.floor_id AS floor_id_7, t0.node_id AS node_id_8, t0.area_id AS area_id_9 FROM infrastructure t0 INNER JOIN infrastructure_category ON t0.id = infrastructure_category.infrastructure_id WHERE infrastructure_category.category_id = ?
Parameters:
[
8
]
|
|
0.57 ms (1.25%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.map_image AS map_image_3, t0.zoom_start AS zoom_start_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM floor t0 WHERE t0.id = ?
Parameters:
[
6
]
|
|
0.42 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.search_aliases AS search_aliases_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id IS NULL
Parameters:
[] |
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\Area | 266 |
| App\Entity\Tenant | 259 |
| App\Entity\Infrastructure | 8 |
| App\Entity\TenantMedia | 7 |
| App\Entity\Category | 4 |
| App\Entity\Floor | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Tenant | No errors. |
| App\Entity\Infrastructure | No errors. |
| App\Entity\Floor | No errors. |
| App\Entity\Area | No errors. |
| App\Entity\Node |
|
| App\Entity\TenantMedia | No errors. |
| App\Entity\Point | No errors. |
| App\Entity\Terminal | No errors. |