Query Metrics
13
Database Queries
5
Different statements
4.61 ms
Query time
0
Invalid entities
30
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.created_at AS created_at_6 FROM category t0 ORDER BY t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||
| 2 | 0.69 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? ORDER BY a0_.published_at DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||
| 3 | 0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.excerpt AS excerpt_5, t0.image AS image_6, t0.is_featured AS is_featured_7, t0.is_published AS is_published_8, t0.views AS views_9, t0.published_at AS published_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t0.author_id AS author_id_14 FROM article t0 WHERE t0.is_published = ? AND t0.is_featured = ? ORDER BY t0.published_at DESC LIMIT 1
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||
| 4 | 0.37 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 9 ]
|
||||||||||||||||||||||||||
| 5 | 0.46 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 8 ]
|
||||||||||||||||||||||||||
| 6 | 0.27 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 4 ]
|
||||||||||||||||||||||||||
| 7 | 0.44 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 2 ]
|
||||||||||||||||||||||||||
| 8 | 0.29 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||
| 9 | 0.25 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 5 ]
|
||||||||||||||||||||||||||
| 10 | 0.25 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 6 ]
|
||||||||||||||||||||||||||
| 11 | 0.24 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 3 ]
|
||||||||||||||||||||||||||
| 12 | 0.25 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.image AS image_5, a0_.is_featured AS is_featured_6, a0_.is_published AS is_published_7, a0_.views AS views_8, a0_.published_at AS published_at_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.category_id AS category_id_12, a0_.author_id AS author_id_13 FROM article a0_ WHERE a0_.is_published = ? AND a0_.category_id = ? ORDER BY a0_.published_at DESC
Parameters:
[ 1 7 ]
|
||||||||||||||||||||||||||
| 13 | 0.25 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.description AS description_5, t0.updated_at AS updated_at_6 FROM setting 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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Setting | 14 |
| App\Entity\Category | 9 |
| App\Entity\Article | 6 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Setting | No errors. |