https://gmb-dev.ru/blog

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.84 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_ WHERE b0_.published = 1 ORDER BY b0_.updated_at DESC LIMIT 1
Parameters:
[]
2 0.49 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:
[]
3 0.48 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_ WHERE b0_.published = 1 ORDER BY b0_.created_at DESC LIMIT 100
Parameters:
[]
4 0.51 ms
SELECT count(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.published = 1 ORDER BY b0_.created_at DESC
Parameters:
[]
5 0.43 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.35 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:
[
  11
]
7 0.28 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.23 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
]
9 0.30 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:
[
  8
]
10 0.32 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
]
11 0.36 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:
[]
12 0.31 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.