https://dev.youdream.training/blog/view/lemonslug

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.92 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.slug = ? AND t0.is_enabled = ? LIMIT 1
Parameters:
[
  "lemonslug"
  1
]
2 0.44 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
]
3 0.81 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"
]
4 0.52 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
]
5 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:
[
  2
]
6 0.36 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
]
7 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.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
]
8 0.43 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"
]
9 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.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
]
10 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.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
]
11 0.39 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
]
12 0.58 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
]

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\BlogImage No errors.
App\Entity\BlogCategory No errors.
App\Entity\Menu No errors.
App\Entity\Course No errors.
App\Entity\Voucher No errors.
App\Entity\OrderVoucher No errors.
App\Entity\User No errors.
App\Entity\CourseCategory No errors.
App\Entity\CareerPathCategory No errors.
App\Entity\CategoryCourseOrdering No errors.
App\Entity\CategoryCareerPathOrdering No errors.