GET https://stuvent.mncr.nl/

Query Metrics

22 Database Queries
4 Different statements
18.36 ms Query time
2 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 2.60 ms
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.company AS company_3, e0_.date AS date_4, e0_.image AS image_5, e0_.aantal_uur AS aantal_uur_6, e0_.niveau AS niveau_7, e0_.attendees AS attendees_8, e0_.end_date AS end_date_9, e0_.concomitance AS concomitance_10, e0_.students_informed AS students_informed_11, e0_.client_informed AS client_informed_12, e0_.assessment_forms_received AS assessment_forms_received_13, e0_.evaluation AS evaluation_14, e0_.absenteeism_department_informed AS absenteeism_department_informed_15, e0_.opleiding_id AS opleiding_id_16 FROM event e0_ WHERE e0_.end_date > ? ORDER BY e0_.date ASC
Parameters:
[
  "2026-04-20 08:25:28"
]
2 5.35 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1073
  "de"
]
3 0.79 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1080
  "de"
]
4 0.67 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1074
  "de"
]
5 0.49 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1081
  "de"
]
6 0.54 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  921
  "de"
]
7 0.39 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1075
  "de"
]
8 0.35 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1082
  "de"
]
9 0.34 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1091
  "de"
]
10 0.37 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ INNER JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND u1_.code <> ?
Parameters:
[
  1147
  "de"
]
11 2.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM opleiding t0 WHERE t0.id = ?
Parameters:
[
  7
]
12 0.74 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1073
]
13 0.38 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1080
]
14 0.26 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1074
]
15 0.33 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1081
]
16 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM opleiding t0 WHERE t0.id = ?
Parameters:
[
  5
]
17 0.26 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  921
]
18 0.30 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1075
]
19 0.26 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1082
]
20 0.25 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1091
]
21 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM opleiding t0 WHERE t0.id = ?
Parameters:
[
  11
]
22 0.32 ms
SELECT t0.id AS id_1, t0.attendees AS attendees_2, t0.event_id AS event_id_3, t0.opleiding_id AS opleiding_id_4 FROM event_opleiding t0 WHERE t0.event_id = ?
Parameters:
[
  1147
]

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\Event 9
App\Entity\Opleiding 3

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Opleiding
  • The association App\Entity\Opleiding#eventOpleidings refers to the owning side field App\Entity\EventOpleiding#Opleiding which does not exist.
App\Entity\UserEvents No errors.
App\Entity\Mededeling No errors.
App\Entity\EventOpleiding
  • The mappings App\Entity\EventOpleiding#opleiding and App\Entity\Opleiding#eventOpleidings are inconsistent with each other.
App\Entity\UserEventStatus No errors.
App\Entity\User No errors.