Query Metrics

60 Database Queries
9 Different statements
28.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.20 ms
SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.mode AS mode_4, t0.experts AS experts_5, t0.slug AS slug_6, t0.organizer AS organizer_7, t0.open AS open_8, t0.time_start AS time_start_9, t0.time_end AS time_end_10, t0.link_course AS link_course_11, t0.link_youtube AS link_youtube_12, t0.venue AS venue_13, t0.language AS language_14 FROM course t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "operational-optimisation-of-building-energy-performance-based-on-activities-during-epc-generation-cy"
]
2 0.87 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.target_group AS target_group_4, t0.place AS place_5, t0.fk_course_id AS fk_course_id_6, t0.fk_language_id AS fk_language_id_7 FROM course_translate t0 WHERE t0.fk_course_id = ? AND t0.fk_language_id = ? LIMIT 1
Parameters:
[
  20
  "ca"
]
3 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.target_group AS target_group_4, t0.place AS place_5, t0.fk_course_id AS fk_course_id_6, t0.fk_language_id AS fk_language_id_7 FROM course_translate t0 WHERE t0.fk_course_id = ? AND t0.fk_language_id = ? LIMIT 1
Parameters:
[
  20
  "en"
]
4 0.89 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.target_group AS target_group_4, t0.place AS place_5, t0.fk_course_id AS fk_course_id_6, t0.fk_language_id AS fk_language_id_7 FROM course_translate t0 WHERE t0.fk_course_id = ?
Parameters:
[
  20
]
5 0.72 ms
SELECT t0.id AS id_1, t0.language AS language_2, t0.fk_course_id AS fk_course_id_3, t0.fk_lecture_id AS fk_lecture_id_4 FROM course_lecture t0 WHERE t0.fk_course_id = ?
Parameters:
[
  20
]
6 0.75 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  88
]
7 0.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  88
]
8 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  88
]
9 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  88
]
10 0.48 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  144
]
11 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  144
]
12 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  144
]
13 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  144
]
14 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  159
]
15 0.35 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  145
]
16 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  145
]
17 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  145
]
18 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  145
]
19 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  160
]
20 0.31 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  146
]
21 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  146
]
22 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  146
]
23 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  146
]
24 1.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  161
]
25 0.83 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  162
]
26 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  163
]
27 0.32 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  78
]
28 0.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  78
]
29 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  78
]
30 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  78
]
31 0.32 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  148
]
32 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  148
]
33 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  148
]
34 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  148
]
35 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  164
]
36 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  165
]
37 0.37 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  149
]
38 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  149
]
39 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  149
]
40 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  149
]
41 0.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  166
]
42 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  167
]
43 0.29 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  150
]
44 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  150
]
45 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  150
]
46 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  150
]
47 0.25 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  109
]
48 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  109
]
49 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  109
]
50 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  109
]
51 0.37 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  151
]
52 0.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  151
]
53 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  151
]
54 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  151
]
55 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  168
]
56 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_materials_id AS fk_lecture_materials_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_materials_translate t0 WHERE t0.fk_lecture_materials_id = ?
Parameters:
[
  169
]
57 0.31 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.slug AS slug_3 FROM lecture t0 WHERE t0.id = ?
Parameters:
[
  152
]
58 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.fk_lecture_id AS fk_lecture_id_4, t0.fk_language_id AS fk_language_id_5 FROM lecture_translate t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  152
]
59 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.picture AS picture_5, t0.partner AS partner_6, t0.slug AS slug_7, t0.type AS type_8, t0.order_list AS order_list_9 FROM lecturers t0 INNER JOIN lecture_lecturers ON t0.id = lecture_lecturers.lecturers_id WHERE lecture_lecturers.lecture_id = ?
Parameters:
[
  152
]
60 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.language AS language_6, t0.fk_lecture_id AS fk_lecture_id_7 FROM lecture_materials t0 WHERE t0.fk_lecture_id = ?
Parameters:
[
  152
]

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.