Query Metrics
4
Database Queries
4
Different statements
2.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.84 ms (34.29%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.content AS content_4, t0.image AS image_5, t0.category AS category_6, t0.publish_date AS publish_date_7, t0.is_visible AS is_visible_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM news t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.74 ms (30.25%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.short_description AS short_description_2, n0_.content AS content_3, n0_.image AS image_4, n0_.category AS category_5, n0_.publish_date AS publish_date_6, n0_.is_visible AS is_visible_7, n0_.position AS position_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10 FROM news n0_ WHERE n0_.id < ? AND n0_.is_visible = 1 ORDER BY n0_.id DESC LIMIT 1
Parameters:
[
2
]
|
|
0.44 ms (18.09%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.short_description AS short_description_2, n0_.content AS content_3, n0_.image AS image_4, n0_.category AS category_5, n0_.publish_date AS publish_date_6, n0_.is_visible AS is_visible_7, n0_.position AS position_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10 FROM news n0_ WHERE n0_.is_visible = ? AND n0_.id <> ? ORDER BY n0_.publish_date DESC LIMIT 3
Parameters:
[ 1 2 ] |
|
0.43 ms (17.37%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.short_description AS short_description_2, n0_.content AS content_3, n0_.image AS image_4, n0_.category AS category_5, n0_.publish_date AS publish_date_6, n0_.is_visible AS is_visible_7, n0_.position AS position_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10 FROM news n0_ WHERE n0_.id > ? AND n0_.is_visible = 1 ORDER BY n0_.id ASC LIMIT 1
Parameters:
[
2
]
|
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\News | No errors. |