GET http://symfony-test.rumps-bistro.de/

Query Metrics

8 Database Queries
6 Different statements
0.93 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.27 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-10-24 11:55:23"
]
2 0.12 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:
[]
3 0.12 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.title AS title_3, t0.uploaded_at AS uploaded_at_4, t0.type AS type_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  33
]
4 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_description AS full_description_3, t0.price AS price_4, t0.category_id AS category_id_5, t0.event_id AS event_id_6, t0.type_id AS type_id_7 FROM food t0 WHERE t0.event_id = ?
Parameters:
[
  10
]
5 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.sort_order AS sort_order_4 FROM menu_part t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.sort_order AS sort_order_4 FROM menu_part t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.sort_order AS sort_order_4 FROM menu_part t0 WHERE t0.id = ?
Parameters:
[
  4
]
8 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3 FROM footer t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\Food 3
App\Entity\MenuPart 3
App\Entity\Announcement 2
App\Entity\AnnouncementType 2
App\Entity\Event 1
App\Entity\Image 1
App\Entity\EventType 1
App\Entity\Footer 1
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\Food No errors.
App\Entity\AnnouncementAssignment No errors.
App\Entity\Announcement No errors.
App\Entity\AnnouncementType No errors.
App\Entity\Category No errors.
App\Entity\MenuPart No errors.