GET https://stuvent.mncr.nl/more-info/1138

Query Metrics

12 Database Queries
8 Different statements
16.69 ms Query time
0 Invalid entities
14 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activities AS activities_4, t0.location AS location_5, t0.company AS company_6, t0.date AS date_7, t0.image AS image_8, t0.aantal_uur AS aantal_uur_9, t0.niveau AS niveau_10, t0.is_18_plus AS is_18_plus_11, t0.attendees AS attendees_12, t0.end_date AS end_date_13, t0.concomitance AS concomitance_14, t0.students_informed AS students_informed_15, t0.client_informed AS client_informed_16, t0.assessment_forms_received AS assessment_forms_received_17, t0.evaluation AS evaluation_18, t0.absenteeism_department_informed AS absenteeism_department_informed_19, t0.opleiding_id AS opleiding_id_20 FROM event t0 WHERE t0.id = ?
Parameters:
[
  1138
]
2 0.79 ms
SELECT t0.id AS id_1, t0.accepted AS accepted_2, t0.presence AS presence_3, t0.rating AS rating_4, t0.hours AS hours_5, t0.notification AS notification_6, t0.user_id AS user_id_7, t0.event_id AS event_id_8, t0.user_event_status_id AS user_event_status_id_9 FROM user_events t0 WHERE t0.event_id = ?
Parameters:
[
  1138
]
3 1.20 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_events u0_ LEFT JOIN user_event_status u1_ ON u0_.user_event_status_id = u1_.id WHERE u0_.event_id = ? AND (u1_.code IS NULL OR u1_.code <> ?)
Parameters:
[
  1138
  "de"
]
4 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM user_event_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 1.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.student_number AS student_number_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.image AS image_8, t0.telefoonnummer AS telefoonnummer_9, t0.opleiding_id AS opleiding_id_10, t0.klas_id AS klas_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  486
]
6 1.47 ms
SELECT t0.id AS id_1, t0.naam AS naam_2 FROM klas t0 WHERE t0.id = ?
Parameters:
[
  13
]
7 1.70 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.student_number AS student_number_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.image AS image_8, t0.telefoonnummer AS telefoonnummer_9, t0.opleiding_id AS opleiding_id_10, t0.klas_id AS klas_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  487
]
8 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.student_number AS student_number_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.image AS image_8, t0.telefoonnummer AS telefoonnummer_9, t0.opleiding_id AS opleiding_id_10, t0.klas_id AS klas_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  470
]
9 1.96 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.student_number AS student_number_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.image AS image_8, t0.telefoonnummer AS telefoonnummer_9, t0.opleiding_id AS opleiding_id_10, t0.klas_id AS klas_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  475
]
10 0.43 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.student_number AS student_number_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.image AS image_8, t0.telefoonnummer AS telefoonnummer_9, t0.opleiding_id AS opleiding_id_10, t0.klas_id AS klas_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  488
]
11 1.59 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
]
12 4.42 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.title AS title_3, t0.date AS date_4, t0.file AS file_5, t0.event_id AS event_id_6 FROM mededeling t0 WHERE t0.event_id = ?
Parameters:
[
  1138
]

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\UserEvents 5
App\Entity\User 5
App\Entity\Event 1
App\Entity\Opleiding 1
App\Entity\UserEventStatus 1
App\Entity\Klas 1

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Opleiding No errors.
App\Entity\UserEvents No errors.
App\Entity\Mededeling No errors.
App\Entity\EventOpleiding No errors.
App\Entity\User No errors.
App\Entity\UserEventStatus No errors.
App\Entity\Klas No errors.
App\Entity\Message No errors.