https://gmb-dev.ru/business/restaurants

Query Metrics

7 Database Queries
4 Different statements
2.94 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.92 ms
SELECT r0_.id AS id_0, r0_.position AS position_1, r0_.name AS name_2, r0_.num AS num_3, r0_.title AS title_4, r0_.description AS description_5, r0_.image AS image_6, r0_.created_at AS created_at_7, r0_.updated_at AS updated_at_8 FROM review r0_ ORDER BY r0_.num ASC, r0_.id ASC
Parameters:
[]
2 0.44 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 (?, ?) ORDER BY b0_.created_at DESC LIMIT 10000
Parameters:
[
  "кейсы"
  "horeca"
]
3 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:
[
  11
]
4 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
]
5 0.41 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.33 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:
[]
7 0.26 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\Review No errors.
App\Entity\BlogPost No errors.
App\Entity\BlogTag No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\BlogContent No errors.