https://dev.youdream.training/career-paths/view/technology-01

Query Metrics

23 Database Queries
11 Different statements
17.32 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.23 ms
(18.62%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.description AS description_5, t0.is_enabled AS is_enabled_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, t0.image_intro_id AS image_intro_id_11, t0.image_full_id AS image_full_id_12 FROM career_path t0 WHERE t0.slug = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  "technology-01"
  1
]
2.17 ms
(12.52%)
1
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.career_path_id AS career_path_id_3, t0.category_id AS category_id_4 FROM category_career_path_ordering t0 WHERE t0.career_path_id = ?
Parameters:
[
  3
]
2.10 ms
(12.12%)
1
SELECT t0.id AS id_1, t0.ordering AS ordering_2, t0.course_id AS course_id_3, t0.career_path_id AS career_path_id_4 FROM career_path_course_ordering t0 WHERE t0.career_path_id = ?
Parameters:
[
  3
]
1.56 ms
(8.98%)
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.50 ms
(8.66%)
3
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.id = ?
Parameters:
[
  7
]
1.37 ms
(7.92%)
3
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:
[
  49
]
1.31 ms
(7.57%)
1
SELECT t0.id AS id_1, t0.information AS information_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.career_path_id AS career_path_id_6 FROM user_career_path t0 WHERE t0.user_id IS NULL AND t0.career_path_id = ? LIMIT 1
Parameters:
[
  3
]
1.27 ms
(7.36%)
3
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
]
1.21 ms
(6.97%)
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.85 ms
(4.90%)
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 career_path_image t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.76 ms
(4.38%)
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
]

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