Query Metrics
4
Database Queries
4
Different statements
12.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.68 ms (67.60%) |
1 |
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3, t0.slug AS slug_4, t0.text AS text_5, t0.date AS date_6, t0.shortText AS shortText_7, t0.sended AS sended_8, t0.metaTitle AS metaTitle_9, t0.metaDescription AS metaDescription_10, t0.metaKeywords AS metaKeywords_11 FROM News t0 WHERE t0.id = ?
Parameters:
[
"118"
]
|
|
2.15 ms (16.75%) |
1 |
SELECT count(DISTINCT n0_.id) AS sclr_0 FROM News n0_
Parameters:
[] |
|
1.34 ms (10.39%) |
1 |
SELECT n0_.id AS id_0, n0_.bid AS bid_1, n0_.name AS name_2, n0_.slug AS slug_3, n0_.text AS text_4, n0_.date AS date_5, n0_.shortText AS shortText_6, n0_.sended AS sended_7, n0_.metaTitle AS metaTitle_8, n0_.metaDescription AS metaDescription_9, n0_.metaKeywords AS metaKeywords_10 FROM News n0_ WHERE n0_.id IN (?) ORDER BY n0_.date DESC
Parameters:
[
[
185
184
182
181
179
178
]
]
|
|
0.67 ms (5.25%) |
1 |
SELECT DISTINCT n0_.id AS id_0, n0_.date AS date_1 FROM News n0_ ORDER BY n0_.date DESC LIMIT 6
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 |
|---|---|
| Troika\MainBundle\Entity\News | No errors. |
| Troika\MainBundle\Entity\NewsPhotos | No errors. |