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

Query Metrics

632 Database Queries
2 Different statements
1636.68 ms Query time
1 Invalid entities
1268 Managed entities

Grouped Statements

Show all queries

Time Count Info
894.66 ms
(54.66%)
1
SELECT n0_.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, n3_.id AS id_10, n3_.type AS type_11, n0_.point_id AS point_id_12, p1_.floor_id AS floor_id_13 FROM node n0_ LEFT JOIN point p1_ ON n0_.point_id = p1_.id LEFT JOIN floor f2_ ON p1_.floor_id = f2_.id LEFT JOIN node_node_type n4_ ON n0_.id = n4_.node_id LEFT JOIN node_type n3_ ON n3_.id = n4_.node_type_id ORDER BY n0_.id ASC
Parameters:
[]
742.02 ms
(45.34%)
631
SELECT t0.id AS id_1, t0.point_id AS point_id_2 FROM node t0 INNER JOIN node_relations ON t0.id = node_relations.child_node_id WHERE node_relations.parent_node_id = ?
Parameters:
[
  65
]

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\Node 631
App\Entity\Point 631
App\Entity\Floor 4
App\Entity\NodeType 2

Entities Mapping

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