Query Metrics
1
Database Queries
1
Different statements
369.03 ms
Query time
1
Invalid entities
3210
Managed entities
Queries
| #▲ | 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 |
|