Query Metrics
9
Database Queries
6
Different statements
2.79 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.37 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:
[
"test-otsutstviya-zagolovka"
]
|
2 | 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:
[
11
]
|
3 | 0.35 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:
[ "кейсы" 11 ] |
4 | 0.31 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.40 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:
[
11
]
|
7 | 0.24 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.30 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:
[] |
9 | 0.25 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. |