Query Metrics

47 Database Queries
9 Different statements
17.24 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.22 ms
(18.69%)
9
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:
[
  124
]
2.73 ms
(15.83%)
9
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:
[
  124
]
2.72 ms
(15.79%)
9
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:
[
  124
]
2.48 ms
(14.37%)
9
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:
[
  124
]
1.89 ms
(10.95%)
6
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:
[
  146
]
1.36 ms
(7.90%)
2
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:
[
  18
  "ca"
]
1.29 ms
(7.48%)
1
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:
[
  "analysis-and-visualization-of-epc-data-and-development-of-innovative-energy-service"
]
0.90 ms
(5.22%)
1
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:
[
  18
]
0.65 ms
(3.77%)
1
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:
[
  18
]

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.