Query Metrics
47
Database Queries
9
Different statements
18.71 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.43 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:
[
"webinar-3-analysis-and-visualisation-of-epc-data-and-development-of-innovative-energy-services"
]
|
2 | 1.05 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:
[ 11 "es" ] |
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:
[ 11 "en" ] |
4 | 0.70 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:
[
11
]
|
5 | 0.57 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:
[
11
]
|
6 | 0.54 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:
[
55
]
|
7 | 0.54 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:
[
55
]
|
8 | 0.40 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:
[
55
]
|
9 | 0.49 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:
[
55
]
|
10 | 0.40 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:
[
23
]
|
11 | 0.30 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:
[
63
]
|
12 | 0.28 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:
[
56
]
|
13 | 0.28 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:
[
56
]
|
14 | 0.46 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:
[
56
]
|
15 | 0.44 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:
[
56
]
|
16 | 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:
[
24
]
|
17 | 0.32 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:
[
64
]
|
18 | 0.30 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:
[
57
]
|
19 | 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:
[
57
]
|
20 | 0.40 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:
[
57
]
|
21 | 0.38 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:
[
57
]
|
22 | 0.51 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:
[
25
]
|
23 | 0.30 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:
[
65
]
|
24 | 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:
[
58
]
|
25 | 0.29 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:
[
58
]
|
26 | 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:
[
58
]
|
27 | 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:
[
58
]
|
28 | 0.32 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:
[
26
]
|
29 | 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:
[
66
]
|
30 | 0.26 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:
[
59
]
|
31 | 0.28 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:
[
59
]
|
32 | 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:
[
59
]
|
33 | 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:
[
59
]
|
34 | 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:
[
27
]
|
35 | 0.35 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:
[
67
]
|
36 | 0.26 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:
[
60
]
|
37 | 0.29 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:
[
60
]
|
38 | 0.35 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:
[
60
]
|
39 | 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:
[
60
]
|
40 | 0.35 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:
[
28
]
|
41 | 0.33 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:
[
68
]
|
42 | 0.27 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:
[
61
]
|
43 | 0.30 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:
[
61
]
|
44 | 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:
[
61
]
|
45 | 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:
[
61
]
|
46 | 0.30 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:
[
29
]
|
47 | 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:
[
69
]
|
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\Course | No errors. |
App\Entity\CourseTranslate | No errors. |
App\Entity\CourseLecture | No errors. |
App\Entity\Student | No errors. |
App\Entity\User | No errors. |
App\Entity\Language | No errors. |
App\Entity\Lecture | No errors. |
App\Entity\LectureTranslate | No errors. |
App\Entity\Lecturers | No errors. |
App\Entity\LectureMaterials | No errors. |
App\Entity\LecturersTranslate | No errors. |
App\Entity\LectureMaterialsTranslate | No errors. |