Query Metrics
8
Database Queries
7
Different statements
2.24 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.67 ms (29.78%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_top AS is_top_3, t0.slug AS slug_4 FROM category t0 WHERE t0.is_top = ?
Parameters:
[
1
]
|
|
0.36 ms (16.19%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.body AS body_2, s0_.created_on AS created_on_3, s0_.insta AS insta_4, s0_.twitter AS twitter_5, s0_.tags AS tags_6, s0_.hits AS hits_7, s0_.status AS status_8, s0_.is_approved AS is_approved_9, s0_.is_saved AS is_saved_10, s0_.instagram_title AS instagram_title_11, s0_.slug AS slug_12, s0_.description AS description_13, s0_.publish_date AS publish_date_14, s0_.code AS code_15, s0_.category_id AS category_id_16, s0_.user_id AS user_id_17 FROM story s0_ ORDER BY s0_.id DESC LIMIT 4
Parameters:
[] |
|
0.32 ms (14.09%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.body AS body_2, s0_.created_on AS created_on_3, s0_.insta AS insta_4, s0_.twitter AS twitter_5, s0_.tags AS tags_6, s0_.hits AS hits_7, s0_.status AS status_8, s0_.is_approved AS is_approved_9, s0_.is_saved AS is_saved_10, s0_.instagram_title AS instagram_title_11, s0_.slug AS slug_12, s0_.description AS description_13, s0_.publish_date AS publish_date_14, s0_.code AS code_15, s0_.category_id AS category_id_16, s0_.user_id AS user_id_17 FROM story s0_ WHERE s0_.category_id = ? ORDER BY s0_.id DESC LIMIT 4
Parameters:
[
1
]
|
|
0.27 ms (12.13%) |
1 |
SELECT * FROM category LIMIT 0,7
Parameters:
[] |
|
0.23 ms (10.34%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_top AS is_top_3, t0.slug AS slug_4 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Most Popular"
]
|
|
0.21 ms (9.45%) |
1 |
SELECT * FROM category LIMIT 5,100
Parameters:
[] |
|
0.18 ms (8.02%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM tag 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\Category | No errors. |
| App\Entity\Story | No errors. |
| App\Entity\User |
|
| App\Entity\Tag | No errors. |