Query Metrics
8
Database Queries
4
Different statements
3.68 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.90 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.56 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 3
Parameters:
[] |
3 | 0.47 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:
[] |
4 | 0.34 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
]
|
5 | 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:
[
10
]
|
6 | 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:
[
9
]
|
7 | 0.42 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:
[] |
8 | 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:
[] |
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. |