https://dev.youdream.training/

Query Metrics

26 Database Queries
10 Different statements
12.69 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro_text AS intro_text_4, t0.content AS content_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 blog_article t0 WHERE t0.is_enabled = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  1
]
2 0.74 ms
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.is_enabled = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  1
]
3 0.47 ms
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.is_enabled = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  1
]
4 0.72 ms
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"
]
5 0.46 ms
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
]
6 0.38 ms
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:
[
  2
]
7 0.35 ms
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:
[
  3
]
8 0.37 ms
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:
[
  5
]
9 0.58 ms
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"
  "CP"
]
10 0.48 ms
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
]
11 0.34 ms
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:
[
  3
]
12 0.42 ms
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:
[
  10
]
13 0.36 ms
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:
[
  5
]
14 0.34 ms
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:
[
  3
]
15 0.36 ms
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:
[
  81
]
16 0.35 ms
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:
[
  79
]
17 0.33 ms
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:
[
  71
]
18 0.38 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  11
]
19 0.33 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  12
]
20 0.56 ms
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 blog_category t0 INNER JOIN blog_category_blog_article ON t0.id = blog_category_blog_article.blog_category_id WHERE blog_category_blog_article.blog_article_id = ?
Parameters:
[
  6
]
21 0.42 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  7
]
22 0.35 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  8
]
23 0.42 ms
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 blog_category t0 INNER JOIN blog_category_blog_article ON t0.id = blog_category_blog_article.blog_category_id WHERE blog_category_blog_article.blog_article_id = ?
Parameters:
[
  4
]
24 0.33 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  5
]
25 0.33 ms
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 blog_image t0 WHERE t0.id = ?
Parameters:
[
  6
]
26 0.42 ms
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 blog_category t0 INNER JOIN blog_category_blog_article ON t0.id = blog_category_blog_article.blog_category_id WHERE blog_category_blog_article.blog_article_id = ?
Parameters:
[
  3
]

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\BlogArticle No errors.
App\Entity\Course No errors.
App\Entity\CareerPath No errors.
App\Entity\BlogImage No errors.
App\Entity\BlogCategory 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\CareerPathImage No errors.
App\Entity\CategoryCareerPathOrdering 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.