Query Metrics
6
Database Queries
5
Different statements
4.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.61 ms (37.67%) |
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.95 ms (22.13%) |
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.79 ms (18.59%) |
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.52 ms (12.17%) |
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.40 ms (9.43%) |
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. |