Query Metrics
1
Database Queries
1
Different statements
2.19 ms
Query time
1
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.19 ms |
SELECT c0_.code AS code_0, c0_.text AS text_1, c0_.trailer AS trailer_2, c1_.id AS id_3, c1_.display_order AS display_order_4, c1_.code AS code_5, c1_.slug AS slug_6, c1_.category AS category_7, c1_.title AS title_8, c1_.teacher AS teacher_9, c1_.description AS description_10, c1_.description_additional AS description_additional_11, c1_.description_mycourses AS description_mycourses_12, c1_.alert AS alert_13, c1_.thumbnail AS thumbnail_14, c1_.course_slides_id AS course_slides_id_15, c1_.price AS price_16, c1_.price_discounted AS price_discounted_17, c1_.media_source AS media_source_18, c1_.enabled AS enabled_19, c1_.hidden AS hidden_20 FROM course_slides c0_ LEFT JOIN courses c1_ ON (c1_.course_slides_id = c0_.id) LEFT JOIN course_types c2_ ON c1_.course_type_id = c2_.id WHERE c0_.enabled = 1 AND c2_.name = ? ORDER BY c0_.order_by ASC
Parameters:
[
"public"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Course |
|
| App\Entity\CourseSlide | No errors. |
| App\Entity\CourseType | No errors. |