GET https://app.undernimme.nl/api/calendar/open-items

Query Metrics

32 Database Queries
2 Different statements
7.35 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.98 ms
(81.34%)
31
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  743
]
1.37 ms
(18.66%)
1
SELECT c0_.id AS id_0, c0_.deleted_at AS deleted_at_1, c0_.title AS title_2, c0_.description AS description_3, c0_.date AS date_4, c0_.time_from AS time_from_5, c0_.time_till AS time_till_6, c0_.address AS address_7, c0_.postal_code AS postal_code_8, c0_.city AS city_9, c0_.open AS open_10, c0_.max_seats_available AS max_seats_available_11, c0_.seats_taken AS seats_taken_12 FROM calendar_item c0_ WHERE c0_.date >= ? AND c0_.open = 1 ORDER BY c0_.date ASC
Parameters:
[
  "2024-11-21 00:00:00"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Modules\Custom\GrootInBhv\CalendarItem
  • The field App\Entity\Modules\Custom\GrootInBhv\CalendarItem#registrations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Modules\Custom\GrootInBhv\Registration#calendarItem does not contain the required 'inversedBy="registrations"' attribute.
App\Entity\Modules\Custom\GrootInBhv\Registration No errors.
App\Entity\Modules\Custom\GrootInBhv\Option No errors.