GET https://petrovskiy-tc.itlabs.top/api/areas

Query Metrics

1 Database Queries
1 Different statements
369.03 ms Query time
1 Invalid entities
3210 Managed entities

Queries

Group similar statements

# Time Info
1 369.03 ms
SELECT a0_.id AS id_0, p1_.id AS id_1, p1_.x AS x_2, p1_.y AS y_3, f2_.id AS id_4, f2_.name AS name_5, f2_.map_image AS map_image_6, f2_.zoom_start AS zoom_start_7, f2_.created_at AS created_at_8, f2_.updated_at AS updated_at_9, f3_.id AS id_10, f3_.name AS name_11, f3_.map_image AS map_image_12, f3_.zoom_start AS zoom_start_13, f3_.created_at AS created_at_14, f3_.updated_at AS updated_at_15, a0_.floor_id AS floor_id_16, p1_.floor_id AS floor_id_17 FROM area a0_ LEFT JOIN area_point a4_ ON a0_.id = a4_.area_id LEFT JOIN point p1_ ON p1_.id = a4_.point_id LEFT JOIN floor f2_ ON p1_.floor_id = f2_.id LEFT JOIN floor f3_ ON a0_.floor_id = f3_.id ORDER BY a0_.id ASC
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\Point 2970
App\Entity\Area 236
App\Entity\Floor 4

Entities Mapping

Class Mapping errors
App\Entity\Area No errors.
App\Entity\Point No errors.
App\Entity\Floor No errors.
App\Entity\Tenant No errors.
App\Entity\Terminal No errors.
App\Entity\Infrastructure 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.