GET https://stuvent.mncr.nl/

Query Metrics

65 Database Queries
4 Different statements
43.31 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 3.56 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-03-13 11:56:22"
]
2 1.36 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:
[
  1127
  "de"
]
3 1.07 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:
[
  1128
  "de"
]
4 0.94 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:
[
  1129
  "de"
]
5 0.88 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:
[
  1149
  "de"
]
6 0.73 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:
[
  1150
  "de"
]
7 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:
[
  1151
  "de"
]
8 0.68 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:
[
  1152
  "de"
]
9 0.69 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:
[
  1017
  "de"
]
10 0.64 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:
[
  1140
  "de"
]
11 0.90 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:
[
  1154
  "de"
]
12 0.63 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:
[
  1155
  "de"
]
13 0.81 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:
[
  1130
  "de"
]
14 0.60 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:
[
  1072
  "de"
]
15 0.63 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:
[
  1133
  "de"
]
16 0.70 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:
[
  1079
  "de"
]
17 0.78 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:
[
  1146
  "de"
]
18 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:
[
  1018
  "de"
]
19 0.65 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:
[
  1019
  "de"
]
20 0.64 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:
[
  1132
  "de"
]
21 0.74 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:
[
  1060
  "de"
]
22 0.64 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:
[
  1020
  "de"
]
23 0.64 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"
]
24 0.60 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"
]
25 0.59 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"
]
26 0.72 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"
]
27 0.66 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"
]
28 0.62 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"
]
29 0.60 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"
]
30 0.66 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"
]
31 0.64 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"
]
32 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM opleiding t0 WHERE t0.id = ?
Parameters:
[
  6
]
33 0.93 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:
[
  1127
]
34 0.81 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:
[
  1128
]
35 0.60 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:
[
  1129
]
36 0.39 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
]
37 0.36 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:
[
  1149
]
38 0.42 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:
[
  1150
]
39 0.34 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:
[
  1151
]
40 0.44 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:
[
  1152
]
41 0.44 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
]
42 0.40 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:
[
  1017
]
43 0.36 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
]
44 0.51 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:
[
  1140
]
45 0.34 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:
[
  1154
]
46 0.35 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:
[
  1155
]
47 0.50 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:
[
  1130
]
48 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:
[
  1072
]
49 0.43 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:
[
  1133
]
50 0.50 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:
[
  1079
]
51 0.45 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:
[
  1146
]
52 0.40 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:
[
  1018
]
53 0.43 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:
[
  1019
]
54 0.40 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:
[
  1132
]
55 0.61 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:
[
  1060
]
56 0.64 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:
[
  1020
]
57 0.86 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
]
58 0.70 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
]
59 0.82 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
]
60 0.85 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
]
61 0.58 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
]
62 0.42 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
]
63 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:
[
  1082
]
64 0.48 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
]
65 0.54 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.

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.