https://dev.youdream.training/courses/view/dfh-gdfhgdfhg

Query Metrics

12 Database Queries
6 Different statements
6.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.02 ms
(29.68%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.slug AS slug_4, t0.type AS type_5, t0.owner AS owner_6, t0.can_expire AS can_expire_7, t0.expiration_days AS expiration_days_8, t0.language AS language_9, t0.has_affiliation AS has_affiliation_10, t0.affiliation_amount AS affiliation_amount_11, t0.show_public_price AS show_public_price_12, t0.price_cost AS price_cost_13, t0.price_final AS price_final_14, t0.intro AS intro_15, t0.description AS description_16, t0.view_times AS view_times_17, t0.view_days AS view_days_18, t0.chapter_topics AS chapter_topics_19, t0.registration_limit AS registration_limit_20, t0.meta_keywords AS meta_keywords_21, t0.meta_description AS meta_description_22, t0.is_enabled AS is_enabled_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.image_intro_id AS image_intro_id_26, t0.image_full_id AS image_full_id_27, t0.attachment_id AS attachment_id_28, t0.certification_id AS certification_id_29, t0.user_id AS user_id_30, t0.trainer_id AS trainer_id_31 FROM course t0 WHERE t0.slug = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  "dfh-gdfhgdfhg"
  1
]
1.52 ms
(22.38%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.content AS content_5, t0.show_content AS show_content_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM course_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.07 ms
(15.72%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.type AS type_4, t0.is_enabled AS is_enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.course_category_id AS course_category_id_8, t0.career_path_category_id AS career_path_category_id_9 FROM menu t0 WHERE t0.is_enabled = ? AND t0.type = ? ORDER BY t0.position ASC
Parameters:
[
  "true"
  "CR"
]
0.92 ms
(13.51%)
2
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM course_image t0 WHERE t0.id = ?
Parameters:
[
  50
]
0.70 ms
(10.23%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM career_path_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(8.47%)
1
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.course_id AS course_id_3, t0.category_id AS category_id_4 FROM category_course_ordering t0 WHERE t0.course_id = ?
Parameters:
[
  7
]

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\CourseImage No errors.
App\Entity\CourseAttachment No errors.
App\Entity\Certification No errors.
App\Entity\User No errors.
App\Entity\CareerPathCourseOrdering No errors.
App\Entity\CategoryCourseOrdering No errors.
App\Entity\CourseSession No errors.
App\Entity\CoursePresentation No errors.
App\Entity\Menu No errors.
App\Entity\Voucher No errors.
App\Entity\OrderVoucher No errors.
App\Entity\CourseCategory No errors.
App\Entity\CareerPathCategory No errors.
App\Entity\CategoryCareerPathOrdering No errors.