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

Query Metrics

31 Database Queries
2 Different statements
7.61 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.22 ms
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-22 00:00:00"
]
2 0.44 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  749
]
3 0.28 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  746
]
4 0.22 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  801
]
5 0.25 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  785
]
6 0.25 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  752
]
7 0.31 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  712
]
8 0.20 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  753
]
9 0.22 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  754
]
10 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  757
]
11 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  802
]
12 0.20 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  803
]
13 0.20 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  762
]
14 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  788
]
15 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  764
]
16 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  760
]
17 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  765
]
18 0.18 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  761
]
19 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  768
]
20 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  769
]
21 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  770
]
22 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  771
]
23 0.20 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  772
]
24 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  790
]
25 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  773
]
26 0.22 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  776
]
27 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  778
]
28 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  792
]
29 0.20 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  797
]
30 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  780
]
31 0.19 ms
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.calendar_item_id = ? AND r0_.deleted_at IS NULL
Parameters:
[
  781
]

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.