Query Metrics
17
Database Queries
3
Different statements
6.55 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.35 ms |
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
]
|
| 2 | 0.35 ms |
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
]
|
| 3 | 0.30 ms |
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:
[
2
]
|
| 4 | 0.27 ms |
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:
[
3
]
|
| 5 | 0.27 ms |
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:
[
4
]
|
| 6 | 0.28 ms |
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:
[
5
]
|
| 7 | 0.29 ms |
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:
[
6
]
|
| 8 | 0.27 ms |
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:
[
7
]
|
| 9 | 0.28 ms |
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:
[
15
]
|
| 10 | 0.40 ms |
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
]
|
| 11 | 0.36 ms |
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:
[
2
]
|
| 12 | 0.36 ms |
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:
[
3
]
|
| 13 | 0.37 ms |
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:
[
4
]
|
| 14 | 0.33 ms |
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:
[
5
]
|
| 15 | 0.37 ms |
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:
[
6
]
|
| 16 | 0.35 ms |
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
]
|
| 17 | 0.35 ms |
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:
[
15
]
|
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. |