Query Metrics
32
Database Queries
7
Different statements
223.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
80.48 ms (35.96%) |
13 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
16
]
|
|
35.81 ms (16.00%) |
5 |
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = ? ORDER BY t0.sort ASC
Parameters:
[
14
]
|
|
35.18 ms (15.72%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"priceindex"
]
|
|
34.43 ms (15.38%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.remoteness AS remoteness_4, t0.square AS square_5, t0.content AS content_6, t0.infrastructure AS infrastructure_7, t0.location AS location_8, t0.created AS created_9, t0.updated AS updated_10, t0.logo AS logo_11, t0.image AS image_12 FROM price_index t0 WHERE t0.type = ? ORDER BY t0.id DESC
Parameters:
[
"home"
]
|
|
13.59 ms (6.07%) |
2 |
SELECT MONTH(p0_.date) AS sclr_0, AVG(p0_.price) AS sclr_1 FROM price_index_item p0_ LEFT JOIN price_index p1_ ON p0_.price_index_id = p1_.id WHERE p1_.type = ? GROUP BY sclr_0 ORDER BY p0_.date ASC LIMIT 6
Parameters:
[
"home"
]
|
|
12.85 ms (5.74%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.sort AS sort_5, t0.parent_id AS parent_id_6 FROM menu t0 WHERE t0.enabled = ? AND t0.parent_id IS NULL ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
11.48 ms (5.13%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.content AS content_4, t0.module AS module_5, t0.menu_title AS menu_title_6, t0.in_menu AS in_menu_7 FROM page_block 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\PageBlock | No errors. |
| App\Entity\PagePageBlock | No errors. |
| App\Entity\PriceIndex | No errors. |
| App\Entity\PriceIndexItem | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Menu | No errors. |