Query Metrics
12
Database Queries
10
Different statements
402.39 ms
Query time
0
Invalid entities
6532
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
360.93 ms (89.70%) |
2 |
SELECT p0_.type AS type_0, p0_.warranty_years AS warranty_years_1, p0_.new AS new_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, s1_.sku AS sku_6, s1_.quantity AS quantity_7, s1_.quantity_unit AS quantity_unit_8, s1_.ean_code AS ean_code_9, s1_.availability AS availability_10, s1_.`condition` AS condition_11, s1_.importable AS importable_12, s1_.tax_transferable AS tax_transferable_13, s1_.sale_count AS sale_count_14, s1_.disabled_at AS disabled_at_15, s1_.id AS id_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, s1_.enabled AS enabled_19, v2_.id AS id_20, v2_.position AS position_21, v2_.created_at AS created_at_22, v2_.updated_at AS updated_at_23, s3_.amount AS amount_24, s3_.tax_amount AS tax_amount_25, s3_.previous_amount AS previous_amount_26, s3_.previous_tax_amount AS previous_tax_amount_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, t4_.rate AS rate_31, t4_.`precision` AS precision_32, t4_.id AS id_33, p5_.title AS title_34, p5_.h1 AS h1_35, p5_.perex AS perex_36, p5_.description AS description_37, p5_.text AS text_38, p5_.meta_title AS meta_title_39, p5_.meta_description AS meta_description_40, p5_.meta_keywords AS meta_keywords_41, p5_.slug AS slug_42, p5_.locale AS locale_43, p5_.id AS id_44, i6_.name AS name_45, i6_.original_name AS original_name_46, i6_.mime_type AS mime_type_47, i6_.size AS size_48, i6_.width AS width_49, i6_.height AS height_50, i6_.id AS id_51, i6_.created_at AS created_at_52, i6_.updated_at AS updated_at_53, i7_.title AS title_54, i7_.keywords AS keywords_55, i7_.locale AS locale_56, i7_.id AS id_57, p8_.value AS value_58, p8_.on_listing AS on_listing_59, p8_.configurable AS configurable_60, p8_.id AS id_61, p8_.position AS position_62, a9_.alias AS alias_63, a9_.class AS class_64, a9_.icon AS icon_65, a9_.on_detail AS on_detail_66, a9_.on_listing AS on_listing_67, a9_.expanded AS expanded_68, a9_.id AS id_69, a9_.position AS position_70, a9_.created_at AS created_at_71, a9_.updated_at AS updated_at_72, a10_.title AS title_73, a10_.description AS description_74, a10_.unit AS unit_75, a10_.locale AS locale_76, a10_.id AS id_77, a11_.id AS id_78, a11_.position AS position_79, a11_.created_at AS created_at_80, a11_.updated_at AS updated_at_81, a12_.title AS title_82, a12_.description AS description_83, a12_.slug AS slug_84, a12_.locale AS locale_85, a12_.id AS id_86, p0_.principal_category_id AS principal_category_id_87, p0_.principal_image_id AS principal_image_id_88, p0_.manufacturer_id AS manufacturer_id_89, p0_.product_class_id AS product_class_id_90, p0_.stock_id AS stock_id_91, s1_.group_id AS group_id_92, v2_.principal_image_id AS principal_image_id_93, v2_.product_id AS product_id_94, v2_.stock_id AS stock_id_95, s3_.stock_id AS stock_id_96, s3_.store_id AS store_id_97, s3_.user_id AS user_id_98, s3_.tax_rate_id AS tax_rate_id_99, s3_.previous_tax_rate_id AS previous_tax_rate_id_100, t4_.store_id AS store_id_101, p5_.translatable_id AS translatable_id_102, i7_.translatable_id AS translatable_id_103, p8_.product_id AS product_id_104, p8_.attribute_id AS attribute_id_105, p8_.attribute_option_id AS attribute_option_id_106, p8_.principal_image_id AS principal_image_id_107, a9_.group_id AS group_id_108, a10_.translatable_id AS translatable_id_109, a11_.attribute_id AS attribute_id_110, a11_.principal_image_id AS principal_image_id_111, a12_.translatable_id AS translatable_id_112 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?, ?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?, ?)) LEFT JOIN product_attribute p8_ ON p0_.id = p8_.product_id LEFT JOIN attribute a9_ ON p8_.attribute_id = a9_.id LEFT JOIN attribute_translation a10_ ON a9_.id = a10_.translatable_id AND (a10_.locale IN (?, ?)) LEFT JOIN attribute_option a11_ ON p8_.attribute_option_id = a11_.id LEFT JOIN attribute_option_translation a12_ ON a11_.id = a12_.translatable_id AND (a12_.locale IN (?, ?)) WHERE s1_.enabled = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p8_.position ASC
Parameters:
[ 3 "de_AT" "de" "de_AT" "de" "de_AT" "de" "de_AT" "de" "1036" "6129" "5739" "2667" "2449" "5987" "2807" "2975" "2503" "2412" "2530" "2483" ] |
||||||||||||||||||||||||||||||||
|
19.12 ms (4.75%) |
1 |
SELECT a0_.alias AS alias_0, a0_.class AS class_1, a0_.icon AS icon_2, a0_.on_detail AS on_detail_3, a0_.on_listing AS on_listing_4, a0_.expanded AS expanded_5, a0_.id AS id_6, a0_.position AS position_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a1_.title AS title_10, a1_.description AS description_11, a1_.unit AS unit_12, a1_.locale AS locale_13, a1_.id AS id_14, f2_.type AS type_15, f2_.widget AS widget_16, f2_.min_value AS min_value_17, f2_.max_value AS max_value_18, f2_.id AS id_19, f2_.created_at AS created_at_20, f2_.updated_at AS updated_at_21, a3_.id AS id_22, a3_.position AS position_23, a3_.created_at AS created_at_24, a3_.updated_at AS updated_at_25, a4_.title AS title_26, a4_.description AS description_27, a4_.slug AS slug_28, a4_.locale AS locale_29, a4_.id AS id_30, i5_.name AS name_31, i5_.original_name AS original_name_32, i5_.mime_type AS mime_type_33, i5_.size AS size_34, i5_.width AS width_35, i5_.height AS height_36, i5_.id AS id_37, i5_.created_at AS created_at_38, i5_.updated_at AS updated_at_39, i6_.title AS title_40, i6_.keywords AS keywords_41, i6_.locale AS locale_42, i6_.id AS id_43, a0_.group_id AS group_id_44, a1_.translatable_id AS translatable_id_45, f2_.attribute_id AS attribute_id_46, a3_.attribute_id AS attribute_id_47, a3_.principal_image_id AS principal_image_id_48, a4_.translatable_id AS translatable_id_49, i6_.translatable_id AS translatable_id_50 FROM attribute a0_ LEFT JOIN attribute_translation a1_ ON a0_.id = a1_.translatable_id AND (a1_.locale IN (?, ?)) INNER JOIN filter f2_ ON a0_.id = f2_.attribute_id INNER JOIN category_filter c7_ ON f2_.id = c7_.filter_id AND (c7_.category_id = ?) INNER JOIN product_attribute p8_ FORCE INDEX (unique_attribute) ON a0_.id = p8_.attribute_id LEFT JOIN product p9_ ON p8_.product_id = p9_.id INNER JOIN stock s10_ ON p9_.stock_id = s10_.id INNER JOIN product_category p11_ ON p9_.id = p11_.product_id AND (p11_.category_id = ?) LEFT JOIN attribute_option a3_ ON a0_.id = a3_.attribute_id LEFT JOIN attribute_option_translation a4_ ON a3_.id = a4_.translatable_id AND (a4_.locale IN (?, ?)) LEFT JOIN image i5_ ON a3_.principal_image_id = i5_.id LEFT JOIN image_translation i6_ ON i5_.id = i6_.translatable_id AND (i6_.locale IN (?, ?)) WHERE s10_.enabled = 1 AND (p8_.attribute_option_id IS NULL OR p8_.attribute_option_id = a3_.id) AND a3_.id IN (?, ?, ?) GROUP BY a0_.id, a3_.id ORDER BY a0_.group_id ASC, a0_.position ASC, a3_.position ASC
Parameters:
[ "de_AT" "de" 438 438 "de_AT" "de" "de_AT" "de" 369 367 368 ] |
||||||||||||||||||||||||||||||||
|
12.49 ms (3.10%) |
1 |
SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_de m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN (?, ?)) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?, ?)) ORDER BY m0_.lft ASC
Parameters:
[ "de_AT" "de" "de_AT" "de" ] |
||||||||||||||||||||||||||||||||
|
4.98 ms (1.24%) |
1 |
SELECT MAX(s0_.amount) AS sclr_0, p1_.type AS type_1, p1_.warranty_years AS warranty_years_2, p1_.new AS new_3, p1_.id AS id_4, p1_.created_at AS created_at_5, p1_.updated_at AS updated_at_6, s2_.sku AS sku_7, s2_.quantity AS quantity_8, s2_.quantity_unit AS quantity_unit_9, s2_.ean_code AS ean_code_10, s2_.availability AS availability_11, s2_.`condition` AS condition_12, s2_.importable AS importable_13, s2_.tax_transferable AS tax_transferable_14, s2_.sale_count AS sale_count_15, s2_.disabled_at AS disabled_at_16, s2_.id AS id_17, s2_.created_at AS created_at_18, s2_.updated_at AS updated_at_19, s2_.enabled AS enabled_20, s0_.amount AS amount_21, s0_.tax_amount AS tax_amount_22, s0_.previous_amount AS previous_amount_23, s0_.previous_tax_amount AS previous_tax_amount_24, s0_.id AS id_25, s0_.created_at AS created_at_26, s0_.updated_at AS updated_at_27, t3_.rate AS rate_28, t3_.`precision` AS precision_29, t3_.id AS id_30, p1_.principal_category_id AS principal_category_id_31, p1_.principal_image_id AS principal_image_id_32, p1_.manufacturer_id AS manufacturer_id_33, p1_.product_class_id AS product_class_id_34, p1_.stock_id AS stock_id_35, s2_.group_id AS group_id_36, s0_.stock_id AS stock_id_37, s0_.store_id AS store_id_38, s0_.user_id AS user_id_39, s0_.tax_rate_id AS tax_rate_id_40, s0_.previous_tax_rate_id AS previous_tax_rate_id_41, t3_.store_id AS store_id_42 FROM product p1_ INNER JOIN stock s2_ ON p1_.stock_id = s2_.id INNER JOIN stock_price s0_ ON s2_.id = s0_.stock_id AND (s0_.store_id = ?) INNER JOIN tax_rate t3_ ON s0_.tax_rate_id = t3_.id LEFT JOIN product_category p4_ ON p1_.id = p4_.product_id WHERE p4_.category_id = ? AND s2_.enabled = 1 GROUP BY s0_.stock_id ORDER BY sclr_0 DESC LIMIT 1
Parameters:
[ 3 438 ] |
||||||||||||||||||||||||||||||||
|
1.39 ms (0.35%) |
1 |
SELECT m0_.name AS name_0, m0_.slug AS slug_1, m0_.displayable AS displayable_2, m0_.id AS id_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.principal_image_id AS principal_image_id_6 FROM manufacturer m0_ LEFT JOIN product p1_ ON m0_.id = p1_.manufacturer_id INNER JOIN stock s2_ ON p1_.stock_id = s2_.id INNER JOIN product_category p3_ ON p1_.id = p3_.product_id AND (p3_.category_id = ?) WHERE s2_.enabled = 1 AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY m0_.id ORDER BY m0_.id ASC
Parameters:
[ 438 64 65 79 89 111 100 101 106 107 ] |
||||||||||||||||||||||||||||||||
|
1.36 ms (0.34%) |
1 |
SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
|
1.04 ms (0.26%) |
2 |
SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = ? AND s0_.locale IN (?, ?)
Parameters:
[ "zimmerheizkorper" "de_AT" "de" ] |
||||||||||||||||||||||||||||||||
|
0.43 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.stock_id = ?
Parameters:
[
9137
]
|
||||||||||||||||||||||||||||||||
|
0.39 ms (0.10%) |
1 |
SELECT t0.position AS position_1, t0.category_id AS category_id_2, t0.filter_id AS filter_id_3, t4.type AS type_5, t4.widget AS widget_6, t4.min_value AS min_value_7, t4.max_value AS max_value_8, t4.id AS id_9, t4.created_at AS created_at_10, t4.updated_at AS updated_at_11, t4.attribute_id AS attribute_id_12 FROM category_filter t0 INNER JOIN filter t4 ON t0.filter_id = t4.id WHERE t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
438
]
|
||||||||||||||||||||||||||||||||
|
0.25 ms (0.06%) |
1 |
SELECT t0.main_template AS main_template_1, t0.product_template AS product_template_2, t0.filterable AS filterable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_image_id AS principal_image_id_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
438
]
|
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\ProductAttribute | 3744 |
| App\Entity\Image | 727 |
| App\Entity\AttributeOptionTranslation | 643 |
| App\Entity\AttributeOption | 642 |
| App\Entity\CategoryTranslation | 205 |
| App\Entity\MenuDe | 203 |
| App\Entity\Category | 178 |
| App\Entity\ImageTranslation | 31 |
| App\Entity\Product | 24 |
| App\Entity\Stock | 24 |
| App\Entity\StockPrice | 24 |
| App\Entity\ProductTranslation | 24 |
| App\Entity\Attribute | 17 |
| App\Entity\AttributeTranslation | 17 |
| App\Entity\Manufacturer | 8 |
| App\Entity\Store | 6 |
| App\Search\Entity\CategoryFilter | 5 |
| App\Search\Entity\Filter | 5 |
| App\User\Entity\User | 2 |
| App\Entity\Slug | 1 |
| App\Entity\StockGroup | 1 |
| App\Entity\TaxRate | 1 |