Query Metrics
17
Database Queries
3
Different statements
6.55 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.89 ms (44.13%) |
8 |
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:
[
1
]
|
2.31 ms (35.22%) |
8 |
SELECT t0.id AS id_1, t0.monthly AS monthly_2, t0.quarterly AS quarterly_3, t0.yearly AS yearly_4, t0.course_id AS course_id_5, t6.id AS id_7, t6.name AS name_8, t6.uuid AS uuid_9 FROM course_price t0 INNER JOIN course t6 ON t0.course_id = t6.id WHERE t0.course_id = ?
Parameters:
[
1
]
|
1.35 ms (20.65%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uuid AS uuid_2, c1_.id AS id_3, c1_.description AS description_4, c1_.lessons_in_course AS lessons_in_course_5, c1_.duration AS duration_6, c1_.photo AS photo_7, c1_.free_lesson AS free_lesson_8, c1_.video AS video_9, c1_.hidden AS hidden_10, c1_.course_id AS course_id_11 FROM course c0_ INNER JOIN course_detail c1_ ON c0_.id = c1_.course_id WHERE c1_.hidden = ?
Parameters:
[
0
]
|
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\CourseGroup | No errors. |