Symfony Profiler

Query Metrics

7.00 ms Query Time

1 Node(s)

2 Indices

Queries

#▲	Execution Time	Info
1	2.96 ms	Request: {"index":"sw_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ea3936af0bac458492aab361c42a55bf"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"fac494ae6fe34da3acd1139c86c45271"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 0 View formatted request View formatted response View query backtrace POST http://basf_elasticsearch:9200/sw_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "ea3936af0bac458492aab361c42a55bf" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "fac494ae6fe34da3acd1139c86c45271" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "string", "script": { "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n", "lang": "painless", "params": { "field": "name", "languages": [ "2fbb5fe2e29a4d70aa5854ce7ce3e20b" ] } }, "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } `{ "took": 1, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 0, "relation": "eq" }, "max_score": null, "hits": [] }, "aggregations": { "total-count": { "value": 0 } } }` `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	1.58 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ea3936af0bac458492aab361c42a55bf"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"fac494ae6fe34da3acd1139c86c45271"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule0196b066e3877380a5ef98853a9f194a_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule0196b066e3877380a5ef98853a9f194a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule0196b068a36772e4b722b24bb90607fe_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule0196b068a36772e4b722b24bb90607fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule01961fdc207e71ba8b3a3b069a22fc97_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule01961fdc207e71ba8b3a3b069a22fc97_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule140c7c93c4fe400da1ce8152830f1ab4_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule140c7c93c4fe400da1ce8152830f1ab4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule3cd2f441ba7c4cddb1fc265c896cf575_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule3cd2f441ba7c4cddb1fc265c896cf575_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule6771e044fb56483eae6829116651fbf0_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule6771e044fb56483eae6829116651fbf0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule080c0e5f0c9348f38ef8182aea51219c_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule080c0e5f0c9348f38ef8182aea51219c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule09ffb1a48d314665a2d84a4f657c4de4_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule09ffb1a48d314665a2d84a4f657c4de4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_rule10bf831fbaac4acba5a6083b711cfced_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_rule10bf831fbaac4acba5a6083b711cfced_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0},{"key":"cheapest_price_ruledefault_currency993d0ad41c334ba2974e9ff40329dd85_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":30.0}],"decimals":1,"round":false,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://basf_elasticsearch:9200/sw_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "ea3936af0bac458492aab361c42a55bf" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "fac494ae6fe34da3acd1139c86c45271" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule0196b066e3877380a5ef98853a9f194a_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule0196b066e3877380a5ef98853a9f194a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule0196b068a36772e4b722b24bb90607fe_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule0196b068a36772e4b722b24bb90607fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule01961fdc207e71ba8b3a3b069a22fc97_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule01961fdc207e71ba8b3a3b069a22fc97_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule140c7c93c4fe400da1ce8152830f1ab4_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule140c7c93c4fe400da1ce8152830f1ab4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule3cd2f441ba7c4cddb1fc265c896cf575_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule3cd2f441ba7c4cddb1fc265c896cf575_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule6771e044fb56483eae6829116651fbf0_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule6771e044fb56483eae6829116651fbf0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule080c0e5f0c9348f38ef8182aea51219c_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule080c0e5f0c9348f38ef8182aea51219c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule09ffb1a48d314665a2d84a4f657c4de4_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule09ffb1a48d314665a2d84a4f657c4de4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_rule10bf831fbaac4acba5a6083b711cfced_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_rule10bf831fbaac4acba5a6083b711cfced_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 }, { "key": "cheapest_price_ruledefault_currency993d0ad41c334ba2974e9ff40329dd85_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 30.0 } ], "decimals": 1, "round": false, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 0, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 0, "rating": { "value": null } }, "price": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`
3	1.86 ms	Request: {"index":"sw_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ea3936af0bac458492aab361c42a55bf"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0c63909a3e4a42238876c72a3124fe66"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"from":0,"size":10000,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: View formatted request View formatted response View query backtrace POST http://basf_elasticsearch:9200/sw_product/_search?search_type=query_then_fetch&track_total_hits=0 Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "ea3936af0bac458492aab361c42a55bf" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "0c63909a3e4a42238876c72a3124fe66" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "from": 0, "size": 10000, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 0, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "sw_product_1753884706", "_type": "_doc", "_id": "0197d48c67b373e1b8a3e441ac851a75", "_score": 0.0, "_source": { "id": "0197d48c67b373e1b8a3e441ac851a75", "autoIncrement": 5731.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "ea3936af0bac458492aab361c42a55bf" } ], "availableStock": 9990, "productNumber": "1541", "ean": null, "displayGroup": "8a08418e809574fcace6f61820624401", "sales": 10, "stock": 9990, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2025-07-04T08:27:40+00:00", "categoryTree": [ "cb20e716b71043d094cfb83f8a20acce", "0c63909a3e4a42238876c72a3124fe66", "6cbdb49d940c44f6b2da729a0be74273", "7c1a8fc09f1d461b95801d6a145bad61" ], "categoriesRo": [ { "id": "cb20e716b71043d094cfb83f8a20acce", "_count": 1 }, { "id": "0c63909a3e4a42238876c72a3124fe66", "_count": 1 }, { "id": "6cbdb49d940c44f6b2da729a0be74273", "_count": 1 }, { "id": "7c1a8fc09f1d461b95801d6a145bad61", "_count": 1 } ], "taxId": "d0c125019b57436cace42575267e5343", "tags": [], "parentId": null, "coverId": "0197d48c6d99726d8d70379161802bba", "childCount": 0, "categories": [ { "id": "7c1a8fc09f1d461b95801d6a145bad61", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge" } } ], "manufacturer": { "id": null, "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "7c1a8fc09f1d461b95801d6a145bad61" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Neues BASF Test-System" }, "description": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test" }, "metaTitle": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.84033613445378 }, "fields": { "displayGroup": [ "8a08418e809574fcace6f61820624401" ] } }, { "_index": "sw_product_1753884706", "_type": "_doc", "_id": "01994d7aad8c73f69bcb9d44481d3dba", "_score": 0.0, "_source": { "id": "01994d7aad8c73f69bcb9d44481d3dba", "autoIncrement": 5736.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "ea3936af0bac458492aab361c42a55bf" } ], "availableStock": -3, "productNumber": "1382-Titan-Trolley-55cm-City-anthrazit", "ean": null, "displayGroup": "5465abd98b0a3343f882f45ccab0955d", "sales": 4, "stock": -3, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2025-09-15T13:05:09+00:00", "categoryTree": [ "cb20e716b71043d094cfb83f8a20acce", "0c63909a3e4a42238876c72a3124fe66", "6cbdb49d940c44f6b2da729a0be74273", "6d9f26d0fa394d72b89393f949ff6faf" ], "categoriesRo": [ { "id": "cb20e716b71043d094cfb83f8a20acce", "_count": 1 }, { "id": "0c63909a3e4a42238876c72a3124fe66", "_count": 1 }, { "id": "6cbdb49d940c44f6b2da729a0be74273", "_count": 1 }, { "id": "6d9f26d0fa394d72b89393f949ff6faf", "_count": 1 } ], "taxId": "d0c125019b57436cace42575267e5343", "tags": [], "parentId": "01994d7a9e0072cba87680d2fb63b75b", "coverId": "01994d7ab101705daf71f44c3bfbf093", "childCount": 0, "categories": [ { "id": "6d9f26d0fa394d72b89393f949ff6faf", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Familie & Erholung" } } ], "manufacturer": { "id": null, "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "properties": [], "options": [ { "id": "01994d7aa79472ef854d441e618eb22f", "_count": 1, "groupId": "bc42dc23f07e4fc381e463386c06cc59", "group": { "id": "bc42dc23f07e4fc381e463386c06cc59", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "anthrazit" } } ], "categoryIds": [ "6d9f26d0fa394d72b89393f949ff6faf" ], "optionIds": [ "01994d7aa79472ef854d441e618eb22f" ], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TRAVELITE 4-Rollen-Trolley City, 55cm, anthrazit" }, "description": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hartgep\u00e4ck aus leichtem, stabilem ABS in futuristischem Design4 laufruhige DoppelrollenZahlen-SicherheitsschlossBeidseitig zu bepackenInnentasche\/InneneinteilungInkl. W\u00e4schefachZuggriff mit ArretierknopfLeichtes, vollst\u00e4ndig versenkbares Leichtmetall-Teleskopgest\u00e4ngePackgurte innenIntegrierter BodengriffKabinengep\u00e4ck\u00a0Volumen: ca. 40 LiterMaterial: ABSMa\u00dfe: B40 x H55x T20 cmGewicht: 3,1 kg" }, "metaTitle": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 83.7641, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 70.39 }, "fields": { "displayGroup": [ "5465abd98b0a3343f882f45ccab0955d" ] } }, { "_index": "sw_product_1753884706", "_type": "_doc", "_id": "0199ec0fd8f371d6938b5b46d508b5b0", "_score": 0.0, "_source": { "id": "0199ec0fd8f371d6938b5b46d508b5b0", "autoIncrement": 5743.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "ea3936af0bac458492aab361c42a55bf" } ], "availableStock": 9998, "productNumber": "1579", "ean": null, "displayGroup": "eb4a0bb3ae624c8d643338c2d49e40e1", "sales": 2, "stock": 9998, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2025-10-16T08:08:05+00:00", "categoryTree": [ "cb20e716b71043d094cfb83f8a20acce", "0c63909a3e4a42238876c72a3124fe66", "6cbdb49d940c44f6b2da729a0be74273", "cedf12c1f19540938e11655a3d1b4d7b" ], "categoriesRo": [ { "id": "cb20e716b71043d094cfb83f8a20acce", "_count": 1 }, { "id": "0c63909a3e4a42238876c72a3124fe66", "_count": 1 }, { "id": "6cbdb49d940c44f6b2da729a0be74273", "_count": 1 }, { "id": "cedf12c1f19540938e11655a3d1b4d7b", "_count": 1 } ], "taxId": "d0c125019b57436cace42575267e5343", "tags": [], "parentId": null, "coverId": "0199ec4fb70d7087a580d21216ff86b3", "childCount": 0, "categories": [ { "id": "cedf12c1f19540938e11655a3d1b4d7b", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Arbeitskleidung & Schutz" } } ], "manufacturer": { "id": null, "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "cedf12c1f19540938e11655a3d1b4d7b" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mapa Ultranitril 493 Handschuhe (10 Paare)" }, "description": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Handschuh entspricht den Anforderungen der Richtlinie Pers\u00f6nliche Schutzausr\u00fcstung beim Umgang mit Pflanzenschutzmitteln des BVL (Bundesamt f\u00fcr Verbraucherschutz und Lebensmittelsicherheit).Silikonfrei, um Spuren, Defekte an Blech und Glas vor dem Lackieren zu vermeidenDie gepr\u00e4gte Struktur sorgt f\u00fcr guten Griff rutschiger Gegenst\u00e4ndeL\u00e4ngere Lebensdauer: hervorragende mechanische Best\u00e4ndigkeit (Abrieb, Durchstich)Hervorragender Schutz beim intensiven Umgang mit hochgef\u00e4hrlichen chemischen ProduktenGeeignet f\u00fcr:-Ausbringen und Verteilen von Pestiziden-Reinigung von Arbeitswerkzeugen-Zubereitung von Sprayl\u00f6sungen-Entsorgung von Pestiziden-Handhabung von Pestiziden-F\u00fcllung des TanksProduktdetails:-Material: Nitril-Farbe: Gr\u00fcn-Innenverarbeitung: velourisiert-Au\u00dfenverarbeitung: Handfl\u00e4che mit Profil-L\u00e4nge: 39 cm-St\u00e4rke: 0,55 mm-Silikonfrei-Gr\u00f6\u00dfe: 8 - 8 1\/2-Menge: 10 Paare" }, "metaTitle": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2a45cff913e341a19625397349660b9a": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 76.5765, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 64.35 }, "fields": { "displayGroup": [ "eb4a0bb3ae624c8d643338c2d49e40e1" ] } } ] } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
4	1.04 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ea3936af0bac458492aab361c42a55bf"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0c63909a3e4a42238876c72a3124fe66"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"max-price":{"max":{"field":"price.c_993d0ad41c334ba2974e9ff40329dd85.gross"}},"min-price":{"min":{"field":"price.c_993d0ad41c334ba2974e9ff40329dd85.gross"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://basf_elasticsearch:9200/sw_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "ea3936af0bac458492aab361c42a55bf" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "0c63909a3e4a42238876c72a3124fe66" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "max-price": { "max": { "field": "price.c_993d0ad41c334ba2974e9ff40329dd85.gross" } }, "min-price": { "min": { "field": "price.c_993d0ad41c334ba2974e9ff40329dd85.gross" } } }, "size": 0, "timeout": "5s" } `{ "took": 0, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "max-price": { "value": null }, "min-price": { "value": null } } }` `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Cluster Status

{
    "cluster_name": "docker-cluster",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 2,
    "active_shards": 2,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 2,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 50.0
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw_product_1753884706	open	1, 1	71
sw_product_1768901928	open	1, 1	71

Symfony Profiler

GET https://basf.test.prodata.de/navigation/fac494ae6fe34da3acd1139c86c45271

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices