Query Metrics

172 Database Queries
13 Different statements
22.27 ms Query time
1 Invalid entities
211 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.23 ms
(41.47%)
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
]
6.77 ms
(30.39%)
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
]
1.32 ms
(5.92%)
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:
[
  "fotokalender/familienkalender-6-spalten"
]
1.23 ms
(5.52%)
5
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.uploaded_at AS uploaded_at_4, t0.block_id AS block_id_5 FROM block_asset t0 WHERE t0.block_id = ?
Parameters:
[
  3238
]
1.16 ms
(5.20%)
4
SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  1484
]
0.92 ms
(4.15%)
3
SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = ? AND t0.is_draft = ?
Parameters:
[
  1485
  0
]
0.44 ms
(2.00%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  308
]
0.44 ms
(1.98%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = ? AND t0.is_draft = ?
Parameters:
[
  308
  0
]
0.32 ms
(1.43%)
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.13 ms
(0.57%)
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 1=0 AND t0.is_published = ? AND t0.is_deleted = ?
Parameters:
[
  1
  0
]
0.11 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 WHERE 1=0 AND t0.is_published = ?
Parameters:
[
  1
]
0.11 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 WHERE 1=0
Parameters:
[]
0.09 ms
(0.42%)
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 79
App\Entity\Page\NavigationItem 75
App\Entity\Shop\Product 21
App\Entity\Footer\FooterLink 10
App\Entity\Page\Block 7
App\Entity\User 6
App\Entity\Media\BlockAsset 6
App\Entity\Page\Section 4
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\Section No errors.
App\Entity\Page\Block No errors.
App\Entity\Media\BlockAsset No errors.
App\Entity\Shop\Category
  • The field App\Entity\Shop\Category#children is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Shop\Category#parent does not contain the required 'inversedBy: "children"' attribute.
App\Entity\Page\NavigationItem 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\VariantGroup No errors.
App\Entity\Media\MediaObject No errors.
App\Entity\Footer\FooterColumn No errors.
App\Entity\Footer\FooterLink No errors.