Query Metrics
155
Database Queries
5
Different statements
33.25 ms
Query time
1
Invalid entities
192
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
17.05 ms (51.28%) |
76 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.id = ?
Parameters:
[
158
]
|
||||||||||||||||||||||||||||||||
|
14.92 ms (44.87%) |
75 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
14
]
|
||||||||||||||||||||||||||||||||
|
0.51 ms (1.52%) |
2 |
SELECT f0_.id AS id_0, f0_.headline AS headline_1, f0_.position AS position_2, f0_.is_published AS is_published_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.position AS position_7, f1_.is_published AS is_published_8, f1_.column_id AS column_id_9, f1_.page_id AS page_id_10 FROM footer_column f0_ LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id WHERE f0_.is_published = ? AND (f1_.id IS NULL OR f1_.is_published = ?) ORDER BY f0_.position ASC, f0_.id ASC, f1_.position ASC, f1_.id ASC
Parameters:
[ 1 1 ] |
||||||||||||||||||||||||||||||||
|
0.46 ms (1.38%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.path = ? LIMIT 1
Parameters:
[
"wkdec.php"
]
|
||||||||||||||||||||||||||||||||
|
0.31 ms (0.95%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC
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\Page\Page | 78 |
| App\Entity\Page\NavigationItem | 75 |
| App\Entity\Shop\Product | 21 |
| App\Entity\Footer\FooterLink | 10 |
| App\Entity\User | 5 |
| App\Entity\Footer\FooterColumn | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page\Page | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Shop\Product | No errors. |
| App\Entity\Page\NavigationItem | No errors. |
| App\Entity\Page\Section | No errors. |
| App\Entity\Shop\Postage | No errors. |
| App\Entity\Shop\Voucher | No errors. |
| App\Entity\Shop\VariantGroupText | No errors. |
| App\Entity\Shop\Variant | No errors. |
| App\Entity\Shop\Category |
|
| App\Entity\Shop\VariantGroup | No errors. |
| App\Entity\Media\MediaObject | No errors. |
| App\Entity\Footer\FooterColumn | No errors. |
| App\Entity\Footer\FooterLink | No errors. |