Query Metrics
6
Database Queries
5
Different statements
2.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.03 ms (35.02%) |
2 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.date_publication AS date_publication_2, b0_.content AS content_3, b0_.file AS file_4, b0_.published AS published_5, b0_.intro AS intro_6, b0_.picture AS picture_7, b0_.picture_alt AS picture_alt_8, b0_.meta_description AS meta_description_9, b0_.frontpage AS frontpage_10, b0_.text_file AS text_file_11, b0_.category_id AS category_id_12 FROM blog_article b0_ WHERE b0_.published = 1 AND b0_.date_publication <= CURRENT_DATE
Parameters:
[] |
|
0.81 ms (27.68%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.date_publication AS date_publication_2, b0_.content AS content_3, b0_.file AS file_4, b0_.published AS published_5, b0_.intro AS intro_6, b0_.picture AS picture_7, b0_.picture_alt AS picture_alt_8, b0_.meta_description AS meta_description_9, b0_.frontpage AS frontpage_10, b0_.text_file AS text_file_11, b0_.category_id AS category_id_12 FROM blog_article b0_ WHERE b0_.published = 1 AND b0_.date_publication <= CURRENT_DATE ORDER BY b0_.date_publication DESC LIMIT 10
Parameters:
[] |
|
0.48 ms (16.31%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.date_publication AS date_publication_2, b0_.content AS content_3, b0_.file AS file_4, b0_.published AS published_5, b0_.intro AS intro_6, b0_.picture AS picture_7, b0_.picture_alt AS picture_alt_8, b0_.meta_description AS meta_description_9, b0_.frontpage AS frontpage_10, b0_.text_file AS text_file_11, b0_.category_id AS category_id_12 FROM blog_article b0_ WHERE b0_.frontpage = 1 AND b0_.published = 1 AND b0_.date_publication <= CURRENT_DATE
Parameters:
[] |
|
0.36 ms (12.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published AS published_4, t0.date_publication AS date_publication_5 FROM notification t0 WHERE t0.published = ? ORDER BY t0.date_publication DESC
Parameters:
[
1
]
|
|
0.26 ms (8.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3 FROM blog_category t0
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\Notification | No errors. |
| App\Entity\User | No errors. |
| App\Entity\BlogArticle | No errors. |
| App\Entity\BlogCategory | No errors. |