https://gmb-dev.ru/blog/post/7-nastroek-dlya-zapuska-programmy-loyalnosti

Query Metrics

10 Database Queries
6 Different statements
3.07 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.poster AS poster_6, t0.published AS published_7, t0.description AS description_8, t0.short_description AS short_description_9, t0.button_text AS button_text_10, t0.button_link AS button_link_11, t0.page_title AS page_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14 FROM blog_post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "7-nastroek-dlya-zapuska-programmy-loyalnosti"
]
2 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = ?
Parameters:
[
  9
]
3 0.38 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.poster AS poster_5, b0_.published AS published_6, b0_.description AS description_7, b0_.short_description AS short_description_8, b0_.button_text AS button_text_9, b0_.button_link AS button_link_10, b0_.page_title AS page_title_11, b0_.meta_description AS meta_description_12, b0_.meta_keywords AS meta_keywords_13 FROM blog_post b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b0_.published = 1 AND b1_.name IN (?) AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 2
Parameters:
[
  "маркетинг"
  9
]
4 0.29 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM blog_tag b0_ INNER JOIN blog_post_blog_tag b2_ ON b0_.id = b2_.blog_tag_id INNER JOIN blog_post b1_ ON b1_.id = b2_.blog_post_id AND (b1_.published = 1)
Parameters:
[]
5 0.38 ms
SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC
Parameters:
[]
6 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.video_link AS video_link_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.image_name AS image_name_7, t0.image_original_name AS image_original_name_8, t0.image_mime_type AS image_mime_type_9, t0.image_size AS image_size_10, t0.image_dimensions AS image_dimensions_11, t0.post_id AS post_id_12 FROM blog_content t0 WHERE t0.post_id = ?
Parameters:
[
  9
]
7 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = ?
Parameters:
[
  10
]
8 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_blog_tag ON t0.id = blog_post_blog_tag.blog_tag_id WHERE blog_post_blog_tag.blog_post_id = ?
Parameters:
[
  7
]
9 0.29 ms
SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC
Parameters:
[]
10 0.24 ms
SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.title AS title_2 FROM module_page m0_ WHERE m0_.active = 1 ORDER BY m0_.pos ASC, m0_.id ASC
Parameters:
[]

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\SeoEntity No errors.
App\Entity\ModulePage No errors.
App\Entity\BlogPost No errors.
App\Entity\BlogTag No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\BlogContent No errors.