Query Metrics
2
Database Queries
2
Different statements
0.49 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.30 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.price AS price_2, e0_.active AS active_3, e0_.time_afternoon_from AS time_afternoon_from_4, e0_.time_afternoon_to AS time_afternoon_to_5, e0_.time_evening_from AS time_evening_from_6, e0_.time_evening_to AS time_evening_to_7, e0_.time_from AS time_from_8, e0_.date AS date_9, e0_.background_image_id AS background_image_id_10, e0_.type_id AS type_id_11, e0_.footer_id AS footer_id_12 FROM event e0_ WHERE e0_.active = ? AND e0_.date >= ? ORDER BY e0_.date ASC LIMIT 1
Parameters:
[ 1 "2026-04-19 11:04:57" ] |
||||||||||||||||||||||||||||
| 2 | 0.19 ms |
SELECT a0_.id AS id_0, a0_.active AS active_1, a0_.start_date AS start_date_2, a0_.end_date AS end_date_3, a1_.id AS id_4, a1_.name AS name_5, a1_.content AS content_6, a2_.id AS id_7, a2_.type AS type_8, a2_.html_tag AS html_tag_9, a2_.order_number AS order_number_10, a1_.type_id AS type_id_11, a1_.assignment_id AS assignment_id_12 FROM announcement_assignment a0_ LEFT JOIN announcement a1_ ON a0_.id = a1_.assignment_id LEFT JOIN announcement_type a2_ ON a1_.type_id = a2_.id WHERE a0_.active = 1 ORDER BY a2_.order_number 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\Announcement | 2 |
| App\Entity\AnnouncementType | 2 |
| App\Entity\AnnouncementAssignment | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\EventType | No errors. |
| App\Entity\Footer | No errors. |
| App\Entity\AnnouncementAssignment | No errors. |
| App\Entity\Announcement | No errors. |
| App\Entity\AnnouncementType | No errors. |