GET https://ostrova-admin.ru/api/categories

Query Metrics

274 Database Queries
6 Different statements
38.84 ms Query time
1 Invalid entities
547 Managed entities

Grouped Statements

Show all queries

Time Count Info
34.22 ms
(88.09%)
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
]
1.94 ms
(5.00%)
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
]
0.97 ms
(2.51%)
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.88 ms
(2.26%)
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.50 ms
(1.28%)
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:
[]
0.33 ms
(0.86%)
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
]

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
  • The field App\Entity\Node#nodes is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Node#nodes does not contain the required 'mappedBy: "nodes"' attribute.
App\Entity\TenantMedia No errors.
App\Entity\Point No errors.
App\Entity\Terminal No errors.