Query Metrics
632
Database Queries
2
Different statements
557.88 ms
Query time
1
Invalid entities
1268
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
481.09 ms (86.24%) |
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
]
|
|
76.79 ms (13.76%) |
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:
[] |
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 |
|
| 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. |