Query Metrics
4
Database Queries
4
Different statements
1.66 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.58 ms (35.11%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t4.id AS id_5, t4.description AS description_6, t4.lessons_in_course AS lessons_in_course_7, t4.duration AS duration_8, t4.photo AS photo_9, t4.free_lesson AS free_lesson_10, t4.video AS video_11, t4.hidden AS hidden_12, t4.course_id AS course_id_13, t14.id AS id_15, t14.monthly AS monthly_16, t14.quarterly AS quarterly_17, t14.yearly AS yearly_18, t14.course_id AS course_id_19 FROM course t0 LEFT JOIN course_detail t4 ON t4.course_id = t0.id LEFT JOIN course_price t14 ON t14.course_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
0.45 ms (26.94%) |
1 |
SELECT t0.id AS id_1, t0.course_id AS course_id_2, t3.id AS id_4, t3.name AS name_5, t3.uuid AS uuid_6, t0.groups_id AS groups_id_7, t8.id AS id_9, t8.name AS name_10, t8.description AS description_11, t8.is_main AS is_main_12, t8.hidden AS hidden_13, t8.photo AS photo_14, t8.student_age AS student_age_15 FROM course_to_group t0 LEFT JOIN course t3 ON t0.course_id = t3.id LEFT JOIN course_group t8 ON t0.groups_id = t8.id WHERE t0.course_id = ?
Parameters:
[
7
]
|
0.32 ms (19.52%) |
1 |
SELECT t0.id AS id_1, t0.lesson_number AS lesson_number_2, t0.topic AS topic_3, t0.description AS description_4, t0.course_id AS course_id_5 FROM course_schedule t0 WHERE t0.course_id = ?
Parameters:
[
7
]
|
0.31 ms (18.44%) |
1 |
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.category AS category_3 FROM faq f0_
Parameters:
[] |
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\CourseDetail | No errors. |
App\Entity\CoursePrice | No errors. |
App\Entity\CourseToGroup | No errors. |
App\Entity\CourseSchedule | No errors. |
App\Entity\Group | No errors. |
App\Entity\PotentialClient | No errors. |
App\Entity\WaitingList | No errors. |
App\Entity\Faq | No errors. |
App\Entity\CourseGroup | No errors. |