Symfony Profiler

Query Metrics

27.00 ms Query Time

1 Node(s)

43 Indices

Queries

#▲ Execution Time Info

20.82 ms

#▲	Execution Time	Info
1	20.82 ms	Request: {"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","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":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cba0ec61fc7ca8c91a97a2eea6200974"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"should":[{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea07ad57e59841906b9dac1ae23"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea3242c77a3ad7aaa686586f79c"]}}}}]}},"boost":150.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018fe3229d5677949c032d1a4983f006"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["f4e67c126b4e4b4f8b4f4b8295613b5b"]}}}}]}},"boost":1000.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["15706c7290284128acdcdc0aa07bda52"]}}}}]}},"boost":400.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["a33aa3f47e2147c9be62a08216f92c1c"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["e3d0223b8cfd4edb8b5581ae7e9ab5cf"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["62000891305f4ae4837e16e336cf2868"]}}}}]}},"boost":200.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["9222eeebbd984a1fbba6521d6c03bc43"]}}}}]}},"boost":250.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["cb292e1aaf854891a0d4e2fca32dd02f"]}}}}]}},"boost":100.0}}]}},"sort":[{"customFields.acris_search_sorting_relevance":{"unmapped_type":"integer","missing":0,"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 5 View formatted request View formatted response View query backtrace POST http://localhost:9200/staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b/_search?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": "132e445c03814d67ac47c04afb6d5d99" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "cba0ec61fc7ca8c91a97a2eea6200974" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ], "should": [ { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "018f0ea07ad57e59841906b9dac1ae23" ] } } } } ] } }, "boost": 350.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "018f0ea3242c77a3ad7aaa686586f79c" ] } } } } ] } }, "boost": 150.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "018fe3229d5677949c032d1a4983f006" ] } } } } ] } }, "boost": 350.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "f4e67c126b4e4b4f8b4f4b8295613b5b" ] } } } } ] } }, "boost": 1000.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "15706c7290284128acdcdc0aa07bda52" ] } } } } ] } }, "boost": 400.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "a33aa3f47e2147c9be62a08216f92c1c" ] } } } } ] } }, "boost": 300.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "e3d0223b8cfd4edb8b5581ae7e9ab5cf" ] } } } } ] } }, "boost": 300.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "62000891305f4ae4837e16e336cf2868" ] } } } } ] } }, "boost": 200.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "9222eeebbd984a1fbba6521d6c03bc43" ] } } } } ] } }, "boost": 250.0 } }, { "constant_score": { "filter": { "bool": { "should": [ { "nested": { "path": "streams", "query": { "terms": { "streams.id": [ "cb292e1aaf854891a0d4e2fca32dd02f" ] } } } } ] } }, "boost": 100.0 } } ] } }, "sort": [ { "customFields.acris_search_sorting_relevance": { "unmapped_type": "integer", "missing": 0, "order": "DESC" } }, { "_score": { "order": "DESC" } }, { "markAsTopseller": { "order": "DESC" } }, { "autoIncrement": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 5, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038", "_id": "5bd52c32029808164d5d72640c70fc89", "_score": 100.0, "_source": { "id": "5bd52c32029808164d5d72640c70fc89", "name": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder, Kunststoff", "description": "Zubeh\u00f6r zur Befestigung Kunststoffwandhalterung f\u00fcr Parkplatzreservierungsschilder \u2219 Wandhalterung aus Kunststoff 110 x 520 mm Wandhalterung", "metaTitle": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder", "metaDescription": "Wandhalterung Kunststoff ", "customSearchKeywords": [ "" ], "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "customFields": { "custom_eis_skus_sku1": "E868175G", "custom_eis_skus_sku4": "E868175B", "custom_topartikel_position": 0.0, "custom_topartikel_kategorie": false, "acris_search_sorting_relevance": 0, "custom_customer_group_discount_exclude": false, "acris_price_on_request_additional_field": false }, "visibilities": [ { "visibility": "30", "salesChannelId": "132e445c03814d67ac47c04afb6d5d99", "_count": 1 } ], "availableStock": 0, "productNumber": "E868175-BS", "ean": null, "displayGroup": "cb05686f6196892490b36ab69fcdb641", "sales": 0, "stock": 0, "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301", "manufacturerNumber": "5049\/72", "manufacturer": { "id": "c3a426735eefdce4df6537fb4b7ae301", "name": "KLAR", "_count": 1 }, "releaseDate": null, "createdAt": "2024-08-08T18:44:11+00:00", "optionIds": [], "options": [], "categories": [ { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "name": "Zubeh\u00f6r Beschilderung" } ], "categoriesRo": [ { "id": "b283b270431e4a1285d331e63d0e6202", "_count": 1 }, { "id": "7902b8704c09ef8cd0c6964c3a1b247e", "_count": 1 }, { "id": "a37f3e4a8f5e19d03dfc78626b8312bf", "_count": 1 }, { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "_count": 1 } ], "categoryIds": [ "cba0ec61fc7ca8c91a97a2eea6200974" ], "categoryTree": [ "b283b270431e4a1285d331e63d0e6202", "7902b8704c09ef8cd0c6964c3a1b247e", "a37f3e4a8f5e19d03dfc78626b8312bf", "cba0ec61fc7ca8c91a97a2eea6200974" ], "properties": [], "propertyIds": [], "taxId": "937f7203705d4d7c8202d8e85be59232", "tags": [], "tagIds": [], "parentId": null, "coverId": "b5affa2076ba3c8434dbffa8140c803c", "childCount": 0, "states": [ "is-physical" ], "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.47, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0, "bergerDownloads": [], "bergerBadges": [], "attributes": { "lieferzeit": { "attributeId": "2286c50ec12650c51f8046b81d08fec9", "type": "IntField", "value": 2, "label": "Lieferzeit", "unit": "Tage" }, "eclass91": { "attributeId": "c7bd39282c5ff77e43704b92e387af62", "type": "StringField", "value": "40020290", "label": "eClass 9.1" }, "verpackungseinheit": { "attributeId": "b2228e0218bd8c44456c38fde3dbd13a", "type": "IntField", "value": 1, "label": "VPE", "unit": "Stk" }, "eclass120": { "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24", "type": "StringField", "value": "40020290", "label": "eClass 12.0" }, "eclass71": { "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b", "type": "StringField", "value": "40020202", "label": "eClass 7.1" }, "eclass51": { "attributeId": "3f3cb6552f77f3bd95539d730d199fd8", "type": "StringField", "value": "40020202", "label": "eClass 5.1" }, "artikelMargeProzent": { "attributeId": "38e4c7e297af9f3dc3db3a866da09604", "type": "FloatField", "value": 38.38, "label": "Artikel Marge", "unit": "%" }, "eclass111": { "attributeId": "df91f8757379fbf660a9a8a2d0c5862a", "type": "StringField", "value": "40020290", "label": "eClass 11.1" }, "googleShoppingStatus": { "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8", "type": "BoolField", "value": "true", "label": "Google Shopping Status" }, "herstellerOriginal": { "attributeId": "61bbdf2bca0073f4404f2740d00add2c", "type": "StringField", "value": "Klar", "label": "Hersteller Original" }, "nameShort": { "attributeId": "f8c2af32acdac443727a6dadc5917437", "type": "StringField", "value": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder", "label": "LABEL_MISSING" }, "bestEinheit": { "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a", "type": "StringField", "value": "St\u00fcck", "label": "Bestelleinheit" }, "nameBullet1": { "attributeId": "197477e550bad420764a27e99f7ff55b", "type": "StringField", "value": "Kunststoff", "label": "LABEL_MISSING" }, "artikelMargeEuroEUR": { "attributeId": "467fd043cc3272e0ef48046f37fefff7", "type": "FloatField", "value": 4.99, "label": "Artikel Marge", "unit": "\u20ac" }, "typModel": { "attributeId": "59c6c7d9678c652ba957d0e829c20200", "type": "StringField", "value": "Zubeh\u00f6r Hinweisschilder", "label": "Typ\/Modell" }, "eclass81": { "attributeId": "635cb161fc196c46a8d7104a3a101a02", "type": "StringField", "value": "40020290", "label": "eClass 8.1" }, "eclass140": { "attributeId": "249eaf721c50994e2b555d43e0aab090", "type": "StringField", "value": "40020290", "label": "eClass 14.0" }, "einstandspreisEis": { "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5", "type": "StringField", "value": "8.01", "label": "Einstandspreis EIS" }, "eisKatalogUrl": { "attributeId": "0581c0c06d61e1784605ae623dcf3938", "type": "StringField", "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "label": "Katalog Link" }, "eclass130": { "attributeId": "5d58ac61bcad814882bb94cafd70e261", "type": "StringField", "value": "40020290", "label": "eClass 13.0" }, "eclass101": { "attributeId": "707fa7400989ef43255668a095490309", "type": "StringField", "value": "40020290", "label": "eClass 10.1" } }, "attribute_lieferzeit": 2, "attribute_eclass91": "40020290", "attribute_verpackungseinheit": 1, "attribute_eclass120": "40020290", "attribute_eclass71": "40020202", "attribute_eclass51": "40020202", "attribute_artikelMargeProzent": 38.38, "attribute_eclass111": "40020290", "attribute_googleShoppingStatus": "true", "attribute_herstellerOriginal": "Klar", "attribute_nameShort": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder", "attribute_bestEinheit": "St\u00fcck", "attribute_nameBullet1": "Kunststoff", "attribute_artikelMargeEuroEUR": 4.99, "attribute_typModel": "Zubeh\u00f6r Hinweisschilder", "attribute_eclass81": "40020290", "attribute_eclass140": "40020290", "attribute_einstandspreisEis": "8.01", "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "attribute_eclass130": "40020290", "attribute_eclass101": "40020290", "streams": [ { "id": "019155b0ab717ff5aa7e62cd921b9c4f" }, { "id": "019715dd36eb7283ade18d2b416a06b3" }, { "id": "019a24914ff5722baf0286f49f888d6a" }, { "id": "99812552a73a423a88a4852c8dd44140" }, { "id": "af586506470e46f89c7f3f8dea7fb411" }, { "id": "b9d3b15fd1214916bf581223c54fdff8" }, { "id": "bad0539785be4dd9a32c976f5152881e" }, { "id": "cb292e1aaf854891a0d4e2fca32dd02f" }, { "id": "e55203ade881479cb68bf1433fda4c6c" }, { "id": "e7e9c4af806040279b50e96833d5aedb" } ] }, "fields": { "displayGroup": [ "cb05686f6196892490b36ab69fcdb641" ] }, "sort": [ 0, 100.0, 0, -9223372036854775808, "5bd52c32029808164d5d72640c70fc89" ] }, { "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038", "_id": "a305b01dc0c1271813f690022b582271", "_score": 100.0, "_source": { "id": "a305b01dc0c1271813f690022b582271", "name": "Parkplatzschilder-Einschlagpfosten, H\u00f6he 750 mm, verzinkter Stahl, mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "description": "Zubeh\u00f6r zur Befestigung Einschlagpfosten f\u00fcr Parkplatzkennzeichnungen \u2219 Erdspie\u00df H = 750 mm aus verzinktem Stahl\u2219 2 mm Aluminiumgrundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520 x 110 mm\u2219 Inkl. Schrauben und Muttern zur Befestigung Grundplatte am Einschlagpfosten Einschlagpfosten", "metaTitle": "Parkplatzschilder-Einschlagpfosten", "metaDescription": "Parkplatzschilder-Einschlagpfosten H\u00f6he 750 mm verzinkter Stahl mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm ", "customSearchKeywords": [ "" ], "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "customFields": { "custom_eis_skus_sku1": "E868172G", "custom_eis_skus_sku4": "E868172B", "custom_topartikel_position": 0.0, "custom_topartikel_kategorie": false, "acris_search_sorting_relevance": 0, "custom_customer_group_discount_exclude": false, "acris_price_on_request_additional_field": false }, "visibilities": [ { "visibility": "30", "salesChannelId": "132e445c03814d67ac47c04afb6d5d99", "_count": 1 } ], "availableStock": 0, "productNumber": "E868172-BS", "ean": "4250669493484", "displayGroup": "a0e99df70840f47f7344d7a0a8312b7c", "sales": 0, "stock": 0, "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301", "manufacturerNumber": "5040\/52", "manufacturer": { "id": "c3a426735eefdce4df6537fb4b7ae301", "name": "KLAR", "_count": 1 }, "releaseDate": null, "createdAt": "2024-08-08T18:44:11+00:00", "optionIds": [], "options": [], "categories": [ { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "name": "Zubeh\u00f6r Beschilderung" } ], "categoriesRo": [ { "id": "b283b270431e4a1285d331e63d0e6202", "_count": 1 }, { "id": "7902b8704c09ef8cd0c6964c3a1b247e", "_count": 1 }, { "id": "a37f3e4a8f5e19d03dfc78626b8312bf", "_count": 1 }, { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "_count": 1 } ], "categoryIds": [ "cba0ec61fc7ca8c91a97a2eea6200974" ], "categoryTree": [ "b283b270431e4a1285d331e63d0e6202", "7902b8704c09ef8cd0c6964c3a1b247e", "a37f3e4a8f5e19d03dfc78626b8312bf", "cba0ec61fc7ca8c91a97a2eea6200974" ], "properties": [], "propertyIds": [], "taxId": "937f7203705d4d7c8202d8e85be59232", "tags": [], "tagIds": [], "parentId": null, "coverId": "c7f948cd9016740f81528649e6eab7f7", "childCount": 0, "states": [ "is-physical" ], "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 61.88, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 52.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0, "bergerDownloads": [], "bergerBadges": [], "attributes": { "eclass120": { "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24", "type": "StringField", "value": "40020290", "label": "eClass 12.0" }, "bestEinheit": { "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a", "type": "StringField", "value": "St\u00fcck", "label": "Bestelleinheit" }, "googleShoppingStatus": { "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8", "type": "BoolField", "value": "true", "label": "Google Shopping Status" }, "eclass71": { "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b", "type": "StringField", "value": "40020202", "label": "eClass 7.1" }, "eclass81": { "attributeId": "635cb161fc196c46a8d7104a3a101a02", "type": "StringField", "value": "40020290", "label": "eClass 8.1" }, "artikelMargeEuroEUR": { "attributeId": "467fd043cc3272e0ef48046f37fefff7", "type": "FloatField", "value": 21.19, "label": "Artikel Marge", "unit": "\u20ac" }, "typModel": { "attributeId": "59c6c7d9678c652ba957d0e829c20200", "type": "StringField", "value": "Zubeh\u00f6r Hinweisschilder", "label": "Typ\/Modell" }, "nameShort": { "attributeId": "f8c2af32acdac443727a6dadc5917437", "type": "StringField", "value": "Parkplatzschilder-Einschlagpfosten", "label": "LABEL_MISSING" }, "nameBullet1": { "attributeId": "197477e550bad420764a27e99f7ff55b", "type": "StringField", "value": "H\u00f6he 750 mm", "label": "LABEL_MISSING" }, "artikelMargeProzent": { "attributeId": "38e4c7e297af9f3dc3db3a866da09604", "type": "FloatField", "value": 40.76, "label": "Artikel Marge", "unit": "%" }, "eclass101": { "attributeId": "707fa7400989ef43255668a095490309", "type": "StringField", "value": "40020290", "label": "eClass 10.1" }, "herstellerOriginal": { "attributeId": "61bbdf2bca0073f4404f2740d00add2c", "type": "StringField", "value": "Klar", "label": "Hersteller Original" }, "eisKatalogUrl": { "attributeId": "0581c0c06d61e1784605ae623dcf3938", "type": "StringField", "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "label": "Katalog Link" }, "eclass140": { "attributeId": "249eaf721c50994e2b555d43e0aab090", "type": "StringField", "value": "40020290", "label": "eClass 14.0" }, "eclass91": { "attributeId": "c7bd39282c5ff77e43704b92e387af62", "type": "StringField", "value": "40020290", "label": "eClass 9.1" }, "verpackungseinheit": { "attributeId": "b2228e0218bd8c44456c38fde3dbd13a", "type": "IntField", "value": 1, "label": "VPE", "unit": "Stk" }, "eclass111": { "attributeId": "df91f8757379fbf660a9a8a2d0c5862a", "type": "StringField", "value": "40020290", "label": "eClass 11.1" }, "nameBullet2": { "attributeId": "38160a50dcd4be0db5d1913984845ec1", "type": "StringField", "value": "verzinkter Stahl", "label": "LABEL_MISSING" }, "einstandspreisEis": { "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5", "type": "StringField", "value": "30.81", "label": "Einstandspreis EIS" }, "nameBullet3": { "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda", "type": "StringField", "value": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "label": "LABEL_MISSING" }, "eclass130": { "attributeId": "5d58ac61bcad814882bb94cafd70e261", "type": "StringField", "value": "40020290", "label": "eClass 13.0" }, "lieferzeit": { "attributeId": "2286c50ec12650c51f8046b81d08fec9", "type": "IntField", "value": 2, "label": "Lieferzeit", "unit": "Tage" }, "eclass51": { "attributeId": "3f3cb6552f77f3bd95539d730d199fd8", "type": "StringField", "value": "40020202", "label": "eClass 5.1" } }, "attribute_eclass120": "40020290", "attribute_bestEinheit": "St\u00fcck", "attribute_googleShoppingStatus": "true", "attribute_eclass71": "40020202", "attribute_eclass81": "40020290", "attribute_artikelMargeEuroEUR": 21.19, "attribute_typModel": "Zubeh\u00f6r Hinweisschilder", "attribute_nameShort": "Parkplatzschilder-Einschlagpfosten", "attribute_nameBullet1": "H\u00f6he 750 mm", "attribute_artikelMargeProzent": 40.76, "attribute_eclass101": "40020290", "attribute_herstellerOriginal": "Klar", "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "attribute_eclass140": "40020290", "attribute_eclass91": "40020290", "attribute_verpackungseinheit": 1, "attribute_eclass111": "40020290", "attribute_nameBullet2": "verzinkter Stahl", "attribute_einstandspreisEis": "30.81", "attribute_nameBullet3": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "attribute_eclass130": "40020290", "attribute_lieferzeit": 2, "attribute_eclass51": "40020202", "streams": [ { "id": "019155b0ab717ff5aa7e62cd921b9c4f" }, { "id": "019715dd36eb7283ade18d2b416a06b3" }, { "id": "019a24914ff5722baf0286f49f888d6a" }, { "id": "99812552a73a423a88a4852c8dd44140" }, { "id": "af586506470e46f89c7f3f8dea7fb411" }, { "id": "b9d3b15fd1214916bf581223c54fdff8" }, { "id": "bad0539785be4dd9a32c976f5152881e" }, { "id": "cb292e1aaf854891a0d4e2fca32dd02f" }, { "id": "e55203ade881479cb68bf1433fda4c6c" }, { "id": "e7e9c4af806040279b50e96833d5aedb" } ] }, "fields": { "displayGroup": [ "a0e99df70840f47f7344d7a0a8312b7c" ] }, "sort": [ 0, 100.0, 0, -9223372036854775808, "a305b01dc0c1271813f690022b582271" ] }, { "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038", "_id": "b8c944f627f9e0046c48a5790a19ba0d", "_score": 100.0, "_source": { "id": "b8c944f627f9e0046c48a5790a19ba0d", "name": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm, H\u00f6he 510 mm, verzinkter Stahl, mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "description": "Zubeh\u00f6r zur Befestigung Pfosten mit Bodenplatte f\u00fcr Parkplatzkennzeichnungen \u2219 Pfosten H = 510 mm mit Bodenplatte 8 x 8 cm, mit 4 Lochungen 10 mm \u00d8 zur Befestigung auf festen Untergr\u00fcnden \u2219 Verzinkter Stahl mit 2 mm Aluminiumgrundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520 x 110 mm\u2219 Inkl. Schrauben und Muttern zur Befestigung von Grundplatte und Pfosten Pfosten mit Bodenplatte", "metaTitle": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm", "metaDescription": "Parkplatzschilder-Pfosten H\u00f6he 510 mm verzinkter Stahl mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm ", "customSearchKeywords": [ "" ], "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "customFields": { "custom_eis_skus_sku1": "E868173G", "custom_eis_skus_sku4": "E868173B", "custom_topartikel_position": 0.0, "custom_topartikel_kategorie": false, "acris_search_sorting_relevance": 0, "custom_customer_group_discount_exclude": false, "acris_price_on_request_additional_field": false }, "visibilities": [ { "visibility": "30", "salesChannelId": "132e445c03814d67ac47c04afb6d5d99", "_count": 1 } ], "availableStock": 0, "productNumber": "E868173-BS", "ean": null, "displayGroup": "958b08a982fa19448c1912bffccde81d", "sales": 0, "stock": 0, "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301", "manufacturerNumber": "5042\/52", "manufacturer": { "id": "c3a426735eefdce4df6537fb4b7ae301", "name": "KLAR", "_count": 1 }, "releaseDate": null, "createdAt": "2023-12-20T17:14:43+00:00", "optionIds": [], "options": [], "categories": [ { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "name": "Zubeh\u00f6r Beschilderung" } ], "categoriesRo": [ { "id": "b283b270431e4a1285d331e63d0e6202", "_count": 1 }, { "id": "7902b8704c09ef8cd0c6964c3a1b247e", "_count": 1 }, { "id": "a37f3e4a8f5e19d03dfc78626b8312bf", "_count": 1 }, { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "_count": 1 } ], "categoryIds": [ "cba0ec61fc7ca8c91a97a2eea6200974" ], "categoryTree": [ "b283b270431e4a1285d331e63d0e6202", "7902b8704c09ef8cd0c6964c3a1b247e", "a37f3e4a8f5e19d03dfc78626b8312bf", "cba0ec61fc7ca8c91a97a2eea6200974" ], "properties": [], "propertyIds": [], "taxId": "937f7203705d4d7c8202d8e85be59232", "tags": [], "tagIds": [], "parentId": null, "coverId": "4c898c3f1c9367f95c05582afc69921b", "childCount": 0, "states": [ "is-physical" ], "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 85.68, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 72.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0, "bergerDownloads": [], "bergerBadges": [], "attributes": { "eclass140": { "attributeId": "249eaf721c50994e2b555d43e0aab090", "type": "StringField", "value": "40020290", "label": "eClass 14.0" }, "bestEinheit": { "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a", "type": "StringField", "value": "St\u00fcck", "label": "Bestelleinheit" }, "eclass91": { "attributeId": "c7bd39282c5ff77e43704b92e387af62", "type": "StringField", "value": "40020290", "label": "eClass 9.1" }, "eclass111": { "attributeId": "df91f8757379fbf660a9a8a2d0c5862a", "type": "StringField", "value": "40020290", "label": "eClass 11.1" }, "artikelMargeProzent": { "attributeId": "38e4c7e297af9f3dc3db3a866da09604", "type": "FloatField", "value": 40.68, "label": "Artikel Marge", "unit": "%" }, "eclass130": { "attributeId": "5d58ac61bcad814882bb94cafd70e261", "type": "StringField", "value": "40020290", "label": "eClass 13.0" }, "eclass51": { "attributeId": "3f3cb6552f77f3bd95539d730d199fd8", "type": "StringField", "value": "40020202", "label": "eClass 5.1" }, "eclass81": { "attributeId": "635cb161fc196c46a8d7104a3a101a02", "type": "StringField", "value": "40020290", "label": "eClass 8.1" }, "eclass120": { "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24", "type": "StringField", "value": "40020290", "label": "eClass 12.0" }, "eclass101": { "attributeId": "707fa7400989ef43255668a095490309", "type": "StringField", "value": "40020290", "label": "eClass 10.1" }, "typModel": { "attributeId": "59c6c7d9678c652ba957d0e829c20200", "type": "StringField", "value": "Zubeh\u00f6r Hinweisschilder", "label": "Typ\/Modell" }, "eclass71": { "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b", "type": "StringField", "value": "40020202", "label": "eClass 7.1" }, "lieferzeit": { "attributeId": "2286c50ec12650c51f8046b81d08fec9", "type": "IntField", "value": 2, "label": "Lieferzeit", "unit": "Tage" }, "nameBullet3": { "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda", "type": "StringField", "value": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "label": "LABEL_MISSING" }, "nameBullet2": { "attributeId": "38160a50dcd4be0db5d1913984845ec1", "type": "StringField", "value": "verzinkter Stahl", "label": "LABEL_MISSING" }, "nameShort": { "attributeId": "f8c2af32acdac443727a6dadc5917437", "type": "StringField", "value": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm", "label": "LABEL_MISSING" }, "einstandspreisEis": { "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5", "type": "StringField", "value": "42.71", "label": "Einstandspreis EIS" }, "verpackungseinheit": { "attributeId": "b2228e0218bd8c44456c38fde3dbd13a", "type": "IntField", "value": 1, "label": "VPE", "unit": "Stk" }, "herstellerOriginal": { "attributeId": "61bbdf2bca0073f4404f2740d00add2c", "type": "StringField", "value": "Klar", "label": "Hersteller Original" }, "googleAdsStatus": { "attributeId": "16a7d38026eeece4a10ccb253bd0fa55", "type": "BoolField", "value": "false", "label": "Google Ads Status" }, "artikelMargeEuroEUR": { "attributeId": "467fd043cc3272e0ef48046f37fefff7", "type": "FloatField", "value": 29.29, "label": "Artikel Marge", "unit": "\u20ac" }, "eisKatalogUrl": { "attributeId": "0581c0c06d61e1784605ae623dcf3938", "type": "StringField", "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "label": "Katalog Link" }, "googleShoppingStatus": { "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8", "type": "BoolField", "value": "true", "label": "Google Shopping Status" }, "nameBullet1": { "attributeId": "197477e550bad420764a27e99f7ff55b", "type": "StringField", "value": "H\u00f6he 510 mm", "label": "LABEL_MISSING" } }, "attribute_eclass140": "40020290", "attribute_bestEinheit": "St\u00fcck", "attribute_eclass91": "40020290", "attribute_eclass111": "40020290", "attribute_artikelMargeProzent": 40.68, "attribute_eclass130": "40020290", "attribute_eclass51": "40020202", "attribute_eclass81": "40020290", "attribute_eclass120": "40020290", "attribute_eclass101": "40020290", "attribute_typModel": "Zubeh\u00f6r Hinweisschilder", "attribute_eclass71": "40020202", "attribute_lieferzeit": 2, "attribute_nameBullet3": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm", "attribute_nameBullet2": "verzinkter Stahl", "attribute_nameShort": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm", "attribute_einstandspreisEis": "42.71", "attribute_verpackungseinheit": 1, "attribute_herstellerOriginal": "Klar", "attribute_googleAdsStatus": "false", "attribute_artikelMargeEuroEUR": 29.29, "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "attribute_googleShoppingStatus": "true", "attribute_nameBullet1": "H\u00f6he 510 mm", "streams": [ { "id": "019155b0ab717ff5aa7e62cd921b9c4f" }, { "id": "019715dd36eb7283ade18d2b416a06b3" }, { "id": "019a24914ff5722baf0286f49f888d6a" }, { "id": "99812552a73a423a88a4852c8dd44140" }, { "id": "af586506470e46f89c7f3f8dea7fb411" }, { "id": "b9d3b15fd1214916bf581223c54fdff8" }, { "id": "bad0539785be4dd9a32c976f5152881e" }, { "id": "cb292e1aaf854891a0d4e2fca32dd02f" }, { "id": "e55203ade881479cb68bf1433fda4c6c" }, { "id": "e7e9c4af806040279b50e96833d5aedb" } ] }, "fields": { "displayGroup": [ "958b08a982fa19448c1912bffccde81d" ] }, "sort": [ 0, 100.0, 0, -9223372036854775808, "b8c944f627f9e0046c48a5790a19ba0d" ] }, { "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038", "_id": "d5bc4c69eebffe569b225cf2e19d348e", "_score": 100.0, "_source": { "id": "d5bc4c69eebffe569b225cf2e19d348e", "name": "Befestigungsmaterial f\u00fcr Gangschilder, Stahlspiralfedern, 200 mm lang, 2 mm stark, zum Abh\u00e4ngen von Plakaten, Plakatrahmen, etc., VE 50 St\u00fcck", "description": "Stahlspiralfedern, 200 mm lang, 2 mm stark", "metaTitle": "Befestigungsmaterial f\u00fcr Gangschilder", "metaDescription": "Befestigungsmaterial Stahlspiralfedern 200 mm lang 2 mm stark zum Abh\u00e4ngen von Plakaten Plakatrahmen etc. VE 50 St\u00fcck ", "customSearchKeywords": [ "" ], "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "customFields": { "custom_eis_skus_sku1": "E6479738G", "custom_eis_skus_sku4": "E6479738B", "custom_topartikel_position": 0.0, "custom_topartikel_kategorie": false, "acris_search_sorting_relevance": 0, "custom_customer_group_discount_exclude": false, "acris_price_on_request_additional_field": false }, "visibilities": [ { "visibility": "30", "salesChannelId": "132e445c03814d67ac47c04afb6d5d99", "_count": 1 } ], "availableStock": 0, "productNumber": "E6479738-BS", "ean": "4250432911146", "displayGroup": "6ecde0e71ae4d36c364650999297d5e7", "sales": 0, "stock": 0, "manufacturerId": null, "manufacturerNumber": "BFM.ST.200.00", "manufacturer": { "id": null, "name": "", "_count": 1 }, "releaseDate": null, "createdAt": "2024-07-25T05:20:28+00:00", "optionIds": [], "options": [], "categories": [ { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "name": "Zubeh\u00f6r Beschilderung" } ], "categoriesRo": [ { "id": "b283b270431e4a1285d331e63d0e6202", "_count": 1 }, { "id": "7902b8704c09ef8cd0c6964c3a1b247e", "_count": 1 }, { "id": "a37f3e4a8f5e19d03dfc78626b8312bf", "_count": 1 }, { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "_count": 1 } ], "categoryIds": [ "cba0ec61fc7ca8c91a97a2eea6200974" ], "categoryTree": [ "b283b270431e4a1285d331e63d0e6202", "7902b8704c09ef8cd0c6964c3a1b247e", "a37f3e4a8f5e19d03dfc78626b8312bf", "cba0ec61fc7ca8c91a97a2eea6200974" ], "properties": [], "propertyIds": [], "taxId": "937f7203705d4d7c8202d8e85be59232", "tags": [], "tagIds": [], "parentId": null, "coverId": "e6d323e805f573d3499f38070854c01c", "childCount": 0, "states": [ "is-physical" ], "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.42, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0, "bergerDownloads": [], "bergerBadges": [ { "id": "a40a7ff3362f118278c6d5f91ec7d0ad", "sorting": 1, "active": false, "color": "", "label": "" } ], "attributes": { "eclass111": { "attributeId": "df91f8757379fbf660a9a8a2d0c5862a", "type": "StringField", "value": "24281490", "label": "eClass 11.1" }, "nameBullet6": { "attributeId": "6179ec8102510973ee43f8bcebbb14e5", "type": "StringField", "value": "etc.", "label": "LABEL_MISSING" }, "nameShort": { "attributeId": "f8c2af32acdac443727a6dadc5917437", "type": "StringField", "value": "Befestigungsmaterial f\u00fcr Gangschilder", "label": "LABEL_MISSING" }, "nameBullet7": { "attributeId": "b8301d8a5f47a1b1c8bd8ad33b81ad4d", "type": "StringField", "value": "VE 50 St\u00fcck", "label": "LABEL_MISSING" }, "herstellerOriginal": { "attributeId": "61bbdf2bca0073f4404f2740d00add2c", "type": "StringField", "value": "Onk", "label": "Hersteller Original" }, "nameBullet3": { "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda", "type": "StringField", "value": "2 mm stark", "label": "LABEL_MISSING" }, "eisKatalogUrl": { "attributeId": "0581c0c06d61e1784605ae623dcf3938", "type": "StringField", "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=124", "label": "Katalog Link" }, "lieferzeit": { "attributeId": "2286c50ec12650c51f8046b81d08fec9", "type": "IntField", "value": 5, "label": "Lieferzeit", "unit": "Tage" }, "eclass81": { "attributeId": "635cb161fc196c46a8d7104a3a101a02", "type": "StringField", "value": "24290490", "label": "eClass 8.1" }, "eclass71": { "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b", "type": "StringField", "value": "24290490", "label": "eClass 7.1" }, "artikelMargeEuroEUR": { "attributeId": "467fd043cc3272e0ef48046f37fefff7", "type": "FloatField", "value": 7.23, "label": "Artikel Marge", "unit": "\u20ac" }, "verpackungseinheit": { "attributeId": "b2228e0218bd8c44456c38fde3dbd13a", "type": "IntField", "value": 1, "label": "VPE", "unit": "Stk" }, "nameBullet1": { "attributeId": "197477e550bad420764a27e99f7ff55b", "type": "StringField", "value": "Stahlspiralfedern", "label": "LABEL_MISSING" }, "nameBullet4": { "attributeId": "0be25007df01a9d0afc79823441bdfa2", "type": "StringField", "value": "zum Abh\u00e4ngen von Plakaten", "label": "LABEL_MISSING" }, "eclass130": { "attributeId": "5d58ac61bcad814882bb94cafd70e261", "type": "StringField", "value": "24281490", "label": "eClass 13.0" }, "googleShoppingStatus": { "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8", "type": "BoolField", "value": "true", "label": "Google Shopping Status" }, "einstandspreisEis": { "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5", "type": "StringField", "value": "10.77", "label": "Einstandspreis EIS" }, "eclass120": { "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24", "type": "StringField", "value": "24281490", "label": "eClass 12.0" }, "artikelMargeProzent": { "attributeId": "38e4c7e297af9f3dc3db3a866da09604", "type": "FloatField", "value": 40.17, "label": "Artikel Marge", "unit": "%" }, "nameBullet2": { "attributeId": "38160a50dcd4be0db5d1913984845ec1", "type": "StringField", "value": "200 mm lang", "label": "LABEL_MISSING" }, "nameBullet5": { "attributeId": "9dd015d5e51ff73a0665faaf467410b3", "type": "StringField", "value": "Plakatrahmen", "label": "LABEL_MISSING" }, "eclass101": { "attributeId": "707fa7400989ef43255668a095490309", "type": "StringField", "value": "24281490", "label": "eClass 10.1" }, "typModel": { "attributeId": "59c6c7d9678c652ba957d0e829c20200", "type": "StringField", "value": "Zubeh\u00f6r Hinweisschilder", "label": "Typ\/Modell" }, "eclass91": { "attributeId": "c7bd39282c5ff77e43704b92e387af62", "type": "StringField", "value": "24290490", "label": "eClass 9.1" }, "bestEinheit": { "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a", "type": "StringField", "value": "Pack", "label": "Bestelleinheit" }, "eclass140": { "attributeId": "249eaf721c50994e2b555d43e0aab090", "type": "StringField", "value": "24281490", "label": "eClass 14.0" } }, "attribute_eclass111": "24281490", "attribute_nameBullet6": "etc.", "attribute_nameShort": "Befestigungsmaterial f\u00fcr Gangschilder", "attribute_nameBullet7": "VE 50 St\u00fcck", "attribute_herstellerOriginal": "Onk", "attribute_nameBullet3": "2 mm stark", "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=124", "attribute_lieferzeit": 5, "attribute_eclass81": "24290490", "attribute_eclass71": "24290490", "attribute_artikelMargeEuroEUR": 7.23, "attribute_verpackungseinheit": 1, "attribute_nameBullet1": "Stahlspiralfedern", "attribute_nameBullet4": "zum Abh\u00e4ngen von Plakaten", "attribute_eclass130": "24281490", "attribute_googleShoppingStatus": "true", "attribute_einstandspreisEis": "10.77", "attribute_eclass120": "24281490", "attribute_artikelMargeProzent": 40.17, "attribute_nameBullet2": "200 mm lang", "attribute_nameBullet5": "Plakatrahmen", "attribute_eclass101": "24281490", "attribute_typModel": "Zubeh\u00f6r Hinweisschilder", "attribute_eclass91": "24290490", "attribute_bestEinheit": "Pack", "attribute_eclass140": "24281490", "streams": [ { "id": "019155b0ab717ff5aa7e62cd921b9c4f" }, { "id": "019715dd36eb7283ade18d2b416a06b3" }, { "id": "019a24914ff5722baf0286f49f888d6a" }, { "id": "99812552a73a423a88a4852c8dd44140" }, { "id": "af586506470e46f89c7f3f8dea7fb411" }, { "id": "b9d3b15fd1214916bf581223c54fdff8" }, { "id": "bad0539785be4dd9a32c976f5152881e" }, { "id": "cb292e1aaf854891a0d4e2fca32dd02f" }, { "id": "e55203ade881479cb68bf1433fda4c6c" }, { "id": "e7e9c4af806040279b50e96833d5aedb" } ] }, "fields": { "displayGroup": [ "6ecde0e71ae4d36c364650999297d5e7" ] }, "sort": [ 0, 100.0, 0, -9223372036854775808, "d5bc4c69eebffe569b225cf2e19d348e" ] }, { "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038", "_id": "e775aa7303274ee248fc66d1579baf2e", "_score": 100.0, "_source": { "id": "e775aa7303274ee248fc66d1579baf2e", "name": "Schraubensatz, best. aus 4 schrauben, Muttern, Zahnscheibe, f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte", "description": "Zubeh\u00f6r zur Befestigung Schraubensatz f\u00fcr die Anbringung von Parkplatzreservierungsschild auf die Aluminiumgrundplatte \u2219 1 Satz = 4 Schrauben, Muttern und Zahnscheiben\u00a0 Schraubensatz", "metaTitle": "Schraubensatz", "metaDescription": "Schraubensatz best. aus 4 schrauben Muttern Zahnscheibe f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte ", "customSearchKeywords": [ "" ], "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "customFields": { "custom_eis_skus_sku1": "E868174G", "custom_eis_skus_sku4": "E868174B", "custom_topartikel_position": 0.0, "custom_topartikel_kategorie": false, "acris_search_sorting_relevance": 0, "custom_customer_group_discount_exclude": false, "acris_price_on_request_additional_field": false }, "visibilities": [ { "visibility": "30", "salesChannelId": "132e445c03814d67ac47c04afb6d5d99", "_count": 1 } ], "availableStock": 0, "productNumber": "E868174-BS", "ean": null, "displayGroup": "b9f823bdeb1a179192273b9b8b3e9771", "sales": 0, "stock": 0, "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301", "manufacturerNumber": "5040\/01", "manufacturer": { "id": "c3a426735eefdce4df6537fb4b7ae301", "name": "KLAR", "_count": 1 }, "releaseDate": null, "createdAt": "2023-12-20T17:14:43+00:00", "optionIds": [], "options": [], "categories": [ { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "name": "Zubeh\u00f6r Beschilderung" } ], "categoriesRo": [ { "id": "b283b270431e4a1285d331e63d0e6202", "_count": 1 }, { "id": "7902b8704c09ef8cd0c6964c3a1b247e", "_count": 1 }, { "id": "a37f3e4a8f5e19d03dfc78626b8312bf", "_count": 1 }, { "id": "cba0ec61fc7ca8c91a97a2eea6200974", "_count": 1 } ], "categoryIds": [ "cba0ec61fc7ca8c91a97a2eea6200974" ], "categoryTree": [ "b283b270431e4a1285d331e63d0e6202", "7902b8704c09ef8cd0c6964c3a1b247e", "a37f3e4a8f5e19d03dfc78626b8312bf", "cba0ec61fc7ca8c91a97a2eea6200974" ], "properties": [], "propertyIds": [], "taxId": "937f7203705d4d7c8202d8e85be59232", "tags": [], "tagIds": [], "parentId": null, "coverId": "cdd1eab8270127a0ebe0a8049c6ac45c", "childCount": 0, "states": [ "is-physical" ], "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.33, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.8, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0, "bergerDownloads": [], "bergerBadges": [], "attributes": { "nameBullet3": { "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda", "type": "StringField", "value": "Zahnscheibe", "label": "LABEL_MISSING" }, "eclass81": { "attributeId": "635cb161fc196c46a8d7104a3a101a02", "type": "StringField", "value": "40020290", "label": "eClass 8.1" }, "nameBullet4": { "attributeId": "0be25007df01a9d0afc79823441bdfa2", "type": "StringField", "value": "f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte", "label": "LABEL_MISSING" }, "eclass130": { "attributeId": "5d58ac61bcad814882bb94cafd70e261", "type": "StringField", "value": "40020290", "label": "eClass 13.0" }, "eclass51": { "attributeId": "3f3cb6552f77f3bd95539d730d199fd8", "type": "StringField", "value": "40020202", "label": "eClass 5.1" }, "bestEinheit": { "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a", "type": "StringField", "value": "Set", "label": "Bestelleinheit" }, "eclass91": { "attributeId": "c7bd39282c5ff77e43704b92e387af62", "type": "StringField", "value": "40020290", "label": "eClass 9.1" }, "einstandspreisEis": { "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5", "type": "StringField", "value": "1.56", "label": "Einstandspreis EIS" }, "googleShoppingStatus": { "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8", "type": "BoolField", "value": "true", "label": "Google Shopping Status" }, "verpackungseinheit": { "attributeId": "b2228e0218bd8c44456c38fde3dbd13a", "type": "IntField", "value": 1, "label": "VPE", "unit": "Stk" }, "nameShort": { "attributeId": "f8c2af32acdac443727a6dadc5917437", "type": "StringField", "value": "Schraubensatz", "label": "LABEL_MISSING" }, "herstellerOriginal": { "attributeId": "61bbdf2bca0073f4404f2740d00add2c", "type": "StringField", "value": "Klar", "label": "Hersteller Original" }, "eclass111": { "attributeId": "df91f8757379fbf660a9a8a2d0c5862a", "type": "StringField", "value": "40020290", "label": "eClass 11.1" }, "eisKatalogUrl": { "attributeId": "0581c0c06d61e1784605ae623dcf3938", "type": "StringField", "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "label": "Katalog Link" }, "eclass101": { "attributeId": "707fa7400989ef43255668a095490309", "type": "StringField", "value": "40020290", "label": "eClass 10.1" }, "artikelMargeProzent": { "attributeId": "38e4c7e297af9f3dc3db3a866da09604", "type": "FloatField", "value": 44.39, "label": "Artikel Marge", "unit": "%" }, "artikelMargeEuroEUR": { "attributeId": "467fd043cc3272e0ef48046f37fefff7", "type": "FloatField", "value": 1.24, "label": "Artikel Marge", "unit": "\u20ac" }, "nameBullet2": { "attributeId": "38160a50dcd4be0db5d1913984845ec1", "type": "StringField", "value": "Muttern", "label": "LABEL_MISSING" }, "typModel": { "attributeId": "59c6c7d9678c652ba957d0e829c20200", "type": "StringField", "value": "Zubeh\u00f6r Hinweisschilder", "label": "Typ\/Modell" }, "lieferzeit": { "attributeId": "2286c50ec12650c51f8046b81d08fec9", "type": "IntField", "value": 2, "label": "Lieferzeit", "unit": "Tage" }, "eclass120": { "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24", "type": "StringField", "value": "40020290", "label": "eClass 12.0" }, "eclass71": { "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b", "type": "StringField", "value": "40020202", "label": "eClass 7.1" }, "nameBullet1": { "attributeId": "197477e550bad420764a27e99f7ff55b", "type": "StringField", "value": "best. aus 4 schrauben", "label": "LABEL_MISSING" }, "eclass140": { "attributeId": "249eaf721c50994e2b555d43e0aab090", "type": "StringField", "value": "40020290", "label": "eClass 14.0" } }, "attribute_nameBullet3": "Zahnscheibe", "attribute_eclass81": "40020290", "attribute_nameBullet4": "f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte", "attribute_eclass130": "40020290", "attribute_eclass51": "40020202", "attribute_bestEinheit": "Set", "attribute_eclass91": "40020290", "attribute_einstandspreisEis": "1.56", "attribute_googleShoppingStatus": "true", "attribute_verpackungseinheit": 1, "attribute_nameShort": "Schraubensatz", "attribute_herstellerOriginal": "Klar", "attribute_eclass111": "40020290", "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147", "attribute_eclass101": "40020290", "attribute_artikelMargeProzent": 44.39, "attribute_artikelMargeEuroEUR": 1.24, "attribute_nameBullet2": "Muttern", "attribute_typModel": "Zubeh\u00f6r Hinweisschilder", "attribute_lieferzeit": 2, "attribute_eclass120": "40020290", "attribute_eclass71": "40020202", "attribute_nameBullet1": "best. aus 4 schrauben", "attribute_eclass140": "40020290", "streams": [ { "id": "019155b0ab717ff5aa7e62cd921b9c4f" }, { "id": "019715dd36eb7283ade18d2b416a06b3" }, { "id": "019a24914ff5722baf0286f49f888d6a" }, { "id": "99812552a73a423a88a4852c8dd44140" }, { "id": "af586506470e46f89c7f3f8dea7fb411" }, { "id": "b9d3b15fd1214916bf581223c54fdff8" }, { "id": "bad0539785be4dd9a32c976f5152881e" }, { "id": "cb292e1aaf854891a0d4e2fca32dd02f" }, { "id": "e55203ade881479cb68bf1433fda4c6c" }, { "id": "e7e9c4af806040279b50e96833d5aedb" } ] }, "fields": { "displayGroup": [ "b9f823bdeb1a179192273b9b8b3e9771" ] }, "sort": [ 0, 100.0, 0, -9223372036854775808, "e775aa7303274ee248fc66d1579baf2e" ] } ] }, "aggregations": { "total-count": { "value": 5 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	6.33 ms	Request: {"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cba0ec61fc7ca8c91a97a2eea6200974"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"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}}}},"manufacturer-count-filter":{"composite":{"sources":[{"manufacturer-count-filter.sorting":{"terms":{"field":"manufacturerId","order":"ASC"}}},{"manufacturer-count-filter.key":{"terms":{"field":"manufacturerId"}}}],"size":"99999"}},"bool-reduced":{"filter":{"script":{"script":{"id":"cheapest_price_percentage_filter","params":{"gt":1.0,"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1}]}}}},"aggregations":{"bool-reduced":{"value_count":{"field":"id"}}}},"width":{"stats":{"field":"width"}},"width-stats":{"filter":{"range":{"width":{"gt":0.0}}},"aggregations":{"width-stats":{"stats":{"field":"width"}}}},"height":{"stats":{"field":"height"}},"height-stats":{"filter":{"range":{"height":{"gt":0.0}}},"aggregations":{"height-stats":{"stats":{"field":"height"}}}},"tiefe":{"stats":{"field":"attribute_tiefe"}},"multi-material":{"composite":{"sources":[{"multi-material.sorting":{"terms":{"field":"attribute_material","order":"ASC"}}},{"multi-material.key":{"terms":{"field":"attribute_material"}}}],"size":"99999"}},"manufacturer-count":{"terms":{"field":"manufacturerId","size":10000}}},"size":0,"timeout":"5s"}} Item count: 5 View formatted request View formatted response View query backtrace POST http://localhost:9200/staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b/_search? 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": "132e445c03814d67ac47c04afb6d5d99" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "cba0ec61fc7ca8c91a97a2eea6200974" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 } ], "decimals": 100, "round": true, "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 } } } }, "manufacturer-count-filter": { "composite": { "sources": [ { "manufacturer-count-filter.sorting": { "terms": { "field": "manufacturerId", "order": "ASC" } } }, { "manufacturer-count-filter.key": { "terms": { "field": "manufacturerId" } } } ], "size": "99999" } }, "bool-reduced": { "filter": { "script": { "script": { "id": "cheapest_price_percentage_filter", "params": { "gt": 1.0, "accessors": [ { "key": "cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage", "factor": 1 } ] } } } }, "aggregations": { "bool-reduced": { "value_count": { "field": "id" } } } }, "width": { "stats": { "field": "width" } }, "width-stats": { "filter": { "range": { "width": { "gt": 0.0 } } }, "aggregations": { "width-stats": { "stats": { "field": "width" } } } }, "height": { "stats": { "field": "height" } }, "height-stats": { "filter": { "range": { "height": { "gt": 0.0 } } }, "aggregations": { "height-stats": { "stats": { "field": "height" } } } }, "tiefe": { "stats": { "field": "attribute_tiefe" } }, "multi-material": { "composite": { "sources": [ { "multi-material.sorting": { "terms": { "field": "attribute_material", "order": "ASC" } } }, { "multi-material.key": { "terms": { "field": "attribute_material" } } } ], "size": "99999" } }, "manufacturer-count": { "terms": { "field": "manufacturerId", "size": 10000 } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 5, "relation": "eq" }, "max_score": null, "hits": [] }, "aggregations": { "rating-exists": { "doc_count": 5, "rating": { "value": 0.0 } }, "multi-material": { "buckets": [] }, "manufacturer-count": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "c3a426735eefdce4df6537fb4b7ae301", "doc_count": 4 } ] }, "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "bool-reduced": { "doc_count": 0, "bool-reduced": { "value": 0 } }, "height-stats": { "doc_count": 0, "height-stats": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 } }, "price": { "count": 5, "min": 2.8, "max": 72.0, "avg": 31.560000000000002, "sum": 157.8 }, "width-stats": { "doc_count": 0, "width-stats": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 } }, "width": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 }, "manufacturer-count-filter": { "after_key": { "manufacturer-count-filter.sorting": "c3a426735eefdce4df6537fb4b7ae301", "manufacturer-count-filter.key": "c3a426735eefdce4df6537fb4b7ae301" }, "buckets": [ { "key": { "manufacturer-count-filter.sorting": "c3a426735eefdce4df6537fb4b7ae301", "manufacturer-count-filter.key": "c3a426735eefdce4df6537fb4b7ae301" }, "doc_count": 4 } ] }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "tiefe": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "height": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","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":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cba0ec61fc7ca8c91a97a2eea6200974"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"should":[{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea07ad57e59841906b9dac1ae23"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea3242c77a3ad7aaa686586f79c"]}}}}]}},"boost":150.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018fe3229d5677949c032d1a4983f006"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["f4e67c126b4e4b4f8b4f4b8295613b5b"]}}}}]}},"boost":1000.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["15706c7290284128acdcdc0aa07bda52"]}}}}]}},"boost":400.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["a33aa3f47e2147c9be62a08216f92c1c"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["e3d0223b8cfd4edb8b5581ae7e9ab5cf"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["62000891305f4ae4837e16e336cf2868"]}}}}]}},"boost":200.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["9222eeebbd984a1fbba6521d6c03bc43"]}}}}]}},"boost":250.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["cb292e1aaf854891a0d4e2fca32dd02f"]}}}}]}},"boost":100.0}}]}},"sort":[{"customFields.acris_search_sorting_relevance":{"unmapped_type":"integer","missing":0,"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Item count: 5
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9200/staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b/_search?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": "132e445c03814d67ac47c04afb6d5d99"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "cba0ec61fc7ca8c91a97a2eea6200974"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ],
            "should": [
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "018f0ea07ad57e59841906b9dac1ae23"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 350.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "018f0ea3242c77a3ad7aaa686586f79c"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 150.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "018fe3229d5677949c032d1a4983f006"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 350.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "f4e67c126b4e4b4f8b4f4b8295613b5b"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 1000.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "15706c7290284128acdcdc0aa07bda52"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 400.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "a33aa3f47e2147c9be62a08216f92c1c"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 300.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "e3d0223b8cfd4edb8b5581ae7e9ab5cf"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 300.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "62000891305f4ae4837e16e336cf2868"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 200.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "9222eeebbd984a1fbba6521d6c03bc43"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 250.0
                    }
                },
                {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "should": [
                                    {
                                        "nested": {
                                            "path": "streams",
                                            "query": {
                                                "terms": {
                                                    "streams.id": [
                                                        "cb292e1aaf854891a0d4e2fca32dd02f"
                                                    ]
                                                }
                                            }
                                        }
                                    }
                                ]
                            }
                        },
                        "boost": 100.0
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "customFields.acris_search_sorting_relevance": {
                "unmapped_type": "integer",
                "missing": 0,
                "order": "DESC"
            }
        },
        {
            "_score": {
                "order": "DESC"
            }
        },
        {
            "markAsTopseller": {
                "order": "DESC"
            }
        },
        {
            "autoIncrement": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 5,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
                "_id": "5bd52c32029808164d5d72640c70fc89",
                "_score": 100.0,
                "_source": {
                    "id": "5bd52c32029808164d5d72640c70fc89",
                    "name": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder, Kunststoff",
                    "description": "Zubeh\u00f6r zur Befestigung Kunststoffwandhalterung f\u00fcr Parkplatzreservierungsschilder \u2219 Wandhalterung aus Kunststoff 110 x 520 mm Wandhalterung",
                    "metaTitle": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder",
                    "metaDescription": "Wandhalterung Kunststoff        ",
                    "customSearchKeywords": [
                        ""
                    ],
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "customFields": {
                        "custom_eis_skus_sku1": "E868175G",
                        "custom_eis_skus_sku4": "E868175B",
                        "custom_topartikel_position": 0.0,
                        "custom_topartikel_kategorie": false,
                        "acris_search_sorting_relevance": 0,
                        "custom_customer_group_discount_exclude": false,
                        "acris_price_on_request_additional_field": false
                    },
                    "visibilities": [
                        {
                            "visibility": "30",
                            "salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
                            "_count": 1
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "E868175-BS",
                    "ean": null,
                    "displayGroup": "cb05686f6196892490b36ab69fcdb641",
                    "sales": 0,
                    "stock": 0,
                    "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301",
                    "manufacturerNumber": "5049\/72",
                    "manufacturer": {
                        "id": "c3a426735eefdce4df6537fb4b7ae301",
                        "name": "KLAR",
                        "_count": 1
                    },
                    "releaseDate": null,
                    "createdAt": "2024-08-08T18:44:11+00:00",
                    "optionIds": [],
                    "options": [],
                    "categories": [
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "name": "Zubeh\u00f6r Beschilderung"
                        }
                    ],
                    "categoriesRo": [
                        {
                            "id": "b283b270431e4a1285d331e63d0e6202",
                            "_count": 1
                        },
                        {
                            "id": "7902b8704c09ef8cd0c6964c3a1b247e",
                            "_count": 1
                        },
                        {
                            "id": "a37f3e4a8f5e19d03dfc78626b8312bf",
                            "_count": 1
                        },
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "_count": 1
                        }
                    ],
                    "categoryIds": [
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "categoryTree": [
                        "b283b270431e4a1285d331e63d0e6202",
                        "7902b8704c09ef8cd0c6964c3a1b247e",
                        "a37f3e4a8f5e19d03dfc78626b8312bf",
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "properties": [],
                    "propertyIds": [],
                    "taxId": "937f7203705d4d7c8202d8e85be59232",
                    "tags": [],
                    "tagIds": [],
                    "parentId": null,
                    "coverId": "b5affa2076ba3c8434dbffa8140c803c",
                    "childCount": 0,
                    "states": [
                        "is-physical"
                    ],
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.47,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
                    "bergerDownloads": [],
                    "bergerBadges": [],
                    "attributes": {
                        "lieferzeit": {
                            "attributeId": "2286c50ec12650c51f8046b81d08fec9",
                            "type": "IntField",
                            "value": 2,
                            "label": "Lieferzeit",
                            "unit": "Tage"
                        },
                        "eclass91": {
                            "attributeId": "c7bd39282c5ff77e43704b92e387af62",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 9.1"
                        },
                        "verpackungseinheit": {
                            "attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
                            "type": "IntField",
                            "value": 1,
                            "label": "VPE",
                            "unit": "Stk"
                        },
                        "eclass120": {
                            "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 12.0"
                        },
                        "eclass71": {
                            "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 7.1"
                        },
                        "eclass51": {
                            "attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 5.1"
                        },
                        "artikelMargeProzent": {
                            "attributeId": "38e4c7e297af9f3dc3db3a866da09604",
                            "type": "FloatField",
                            "value": 38.38,
                            "label": "Artikel Marge",
                            "unit": "%"
                        },
                        "eclass111": {
                            "attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 11.1"
                        },
                        "googleShoppingStatus": {
                            "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8",
                            "type": "BoolField",
                            "value": "true",
                            "label": "Google Shopping Status"
                        },
                        "herstellerOriginal": {
                            "attributeId": "61bbdf2bca0073f4404f2740d00add2c",
                            "type": "StringField",
                            "value": "Klar",
                            "label": "Hersteller Original"
                        },
                        "nameShort": {
                            "attributeId": "f8c2af32acdac443727a6dadc5917437",
                            "type": "StringField",
                            "value": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder",
                            "label": "LABEL_MISSING"
                        },
                        "bestEinheit": {
                            "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
                            "type": "StringField",
                            "value": "St\u00fcck",
                            "label": "Bestelleinheit"
                        },
                        "nameBullet1": {
                            "attributeId": "197477e550bad420764a27e99f7ff55b",
                            "type": "StringField",
                            "value": "Kunststoff",
                            "label": "LABEL_MISSING"
                        },
                        "artikelMargeEuroEUR": {
                            "attributeId": "467fd043cc3272e0ef48046f37fefff7",
                            "type": "FloatField",
                            "value": 4.99,
                            "label": "Artikel Marge",
                            "unit": "\u20ac"
                        },
                        "typModel": {
                            "attributeId": "59c6c7d9678c652ba957d0e829c20200",
                            "type": "StringField",
                            "value": "Zubeh\u00f6r Hinweisschilder",
                            "label": "Typ\/Modell"
                        },
                        "eclass81": {
                            "attributeId": "635cb161fc196c46a8d7104a3a101a02",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 8.1"
                        },
                        "eclass140": {
                            "attributeId": "249eaf721c50994e2b555d43e0aab090",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 14.0"
                        },
                        "einstandspreisEis": {
                            "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
                            "type": "StringField",
                            "value": "8.01",
                            "label": "Einstandspreis EIS"
                        },
                        "eisKatalogUrl": {
                            "attributeId": "0581c0c06d61e1784605ae623dcf3938",
                            "type": "StringField",
                            "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                            "label": "Katalog Link"
                        },
                        "eclass130": {
                            "attributeId": "5d58ac61bcad814882bb94cafd70e261",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 13.0"
                        },
                        "eclass101": {
                            "attributeId": "707fa7400989ef43255668a095490309",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 10.1"
                        }
                    },
                    "attribute_lieferzeit": 2,
                    "attribute_eclass91": "40020290",
                    "attribute_verpackungseinheit": 1,
                    "attribute_eclass120": "40020290",
                    "attribute_eclass71": "40020202",
                    "attribute_eclass51": "40020202",
                    "attribute_artikelMargeProzent": 38.38,
                    "attribute_eclass111": "40020290",
                    "attribute_googleShoppingStatus": "true",
                    "attribute_herstellerOriginal": "Klar",
                    "attribute_nameShort": "Wandhalterung f\u00fcr Parkplatzreservierungsschilder",
                    "attribute_bestEinheit": "St\u00fcck",
                    "attribute_nameBullet1": "Kunststoff",
                    "attribute_artikelMargeEuroEUR": 4.99,
                    "attribute_typModel": "Zubeh\u00f6r Hinweisschilder",
                    "attribute_eclass81": "40020290",
                    "attribute_eclass140": "40020290",
                    "attribute_einstandspreisEis": "8.01",
                    "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                    "attribute_eclass130": "40020290",
                    "attribute_eclass101": "40020290",
                    "streams": [
                        {
                            "id": "019155b0ab717ff5aa7e62cd921b9c4f"
                        },
                        {
                            "id": "019715dd36eb7283ade18d2b416a06b3"
                        },
                        {
                            "id": "019a24914ff5722baf0286f49f888d6a"
                        },
                        {
                            "id": "99812552a73a423a88a4852c8dd44140"
                        },
                        {
                            "id": "af586506470e46f89c7f3f8dea7fb411"
                        },
                        {
                            "id": "b9d3b15fd1214916bf581223c54fdff8"
                        },
                        {
                            "id": "bad0539785be4dd9a32c976f5152881e"
                        },
                        {
                            "id": "cb292e1aaf854891a0d4e2fca32dd02f"
                        },
                        {
                            "id": "e55203ade881479cb68bf1433fda4c6c"
                        },
                        {
                            "id": "e7e9c4af806040279b50e96833d5aedb"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "cb05686f6196892490b36ab69fcdb641"
                    ]
                },
                "sort": [
                    0,
                    100.0,
                    0,
                    -9223372036854775808,
                    "5bd52c32029808164d5d72640c70fc89"
                ]
            },
            {
                "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
                "_id": "a305b01dc0c1271813f690022b582271",
                "_score": 100.0,
                "_source": {
                    "id": "a305b01dc0c1271813f690022b582271",
                    "name": "Parkplatzschilder-Einschlagpfosten, H\u00f6he 750 mm, verzinkter Stahl, mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                    "description": "Zubeh\u00f6r zur Befestigung Einschlagpfosten f\u00fcr Parkplatzkennzeichnungen \u2219 Erdspie\u00df H = 750 mm aus verzinktem Stahl\u2219 2 mm Aluminiumgrundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520 x 110 mm\u2219 Inkl. Schrauben und Muttern zur Befestigung Grundplatte am Einschlagpfosten Einschlagpfosten",
                    "metaTitle": "Parkplatzschilder-Einschlagpfosten",
                    "metaDescription": "Parkplatzschilder-Einschlagpfosten H\u00f6he 750 mm verzinkter Stahl mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm      ",
                    "customSearchKeywords": [
                        ""
                    ],
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "customFields": {
                        "custom_eis_skus_sku1": "E868172G",
                        "custom_eis_skus_sku4": "E868172B",
                        "custom_topartikel_position": 0.0,
                        "custom_topartikel_kategorie": false,
                        "acris_search_sorting_relevance": 0,
                        "custom_customer_group_discount_exclude": false,
                        "acris_price_on_request_additional_field": false
                    },
                    "visibilities": [
                        {
                            "visibility": "30",
                            "salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
                            "_count": 1
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "E868172-BS",
                    "ean": "4250669493484",
                    "displayGroup": "a0e99df70840f47f7344d7a0a8312b7c",
                    "sales": 0,
                    "stock": 0,
                    "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301",
                    "manufacturerNumber": "5040\/52",
                    "manufacturer": {
                        "id": "c3a426735eefdce4df6537fb4b7ae301",
                        "name": "KLAR",
                        "_count": 1
                    },
                    "releaseDate": null,
                    "createdAt": "2024-08-08T18:44:11+00:00",
                    "optionIds": [],
                    "options": [],
                    "categories": [
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "name": "Zubeh\u00f6r Beschilderung"
                        }
                    ],
                    "categoriesRo": [
                        {
                            "id": "b283b270431e4a1285d331e63d0e6202",
                            "_count": 1
                        },
                        {
                            "id": "7902b8704c09ef8cd0c6964c3a1b247e",
                            "_count": 1
                        },
                        {
                            "id": "a37f3e4a8f5e19d03dfc78626b8312bf",
                            "_count": 1
                        },
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "_count": 1
                        }
                    ],
                    "categoryIds": [
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "categoryTree": [
                        "b283b270431e4a1285d331e63d0e6202",
                        "7902b8704c09ef8cd0c6964c3a1b247e",
                        "a37f3e4a8f5e19d03dfc78626b8312bf",
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "properties": [],
                    "propertyIds": [],
                    "taxId": "937f7203705d4d7c8202d8e85be59232",
                    "tags": [],
                    "tagIds": [],
                    "parentId": null,
                    "coverId": "c7f948cd9016740f81528649e6eab7f7",
                    "childCount": 0,
                    "states": [
                        "is-physical"
                    ],
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 61.88,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 52.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
                    "bergerDownloads": [],
                    "bergerBadges": [],
                    "attributes": {
                        "eclass120": {
                            "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 12.0"
                        },
                        "bestEinheit": {
                            "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
                            "type": "StringField",
                            "value": "St\u00fcck",
                            "label": "Bestelleinheit"
                        },
                        "googleShoppingStatus": {
                            "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8",
                            "type": "BoolField",
                            "value": "true",
                            "label": "Google Shopping Status"
                        },
                        "eclass71": {
                            "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 7.1"
                        },
                        "eclass81": {
                            "attributeId": "635cb161fc196c46a8d7104a3a101a02",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 8.1"
                        },
                        "artikelMargeEuroEUR": {
                            "attributeId": "467fd043cc3272e0ef48046f37fefff7",
                            "type": "FloatField",
                            "value": 21.19,
                            "label": "Artikel Marge",
                            "unit": "\u20ac"
                        },
                        "typModel": {
                            "attributeId": "59c6c7d9678c652ba957d0e829c20200",
                            "type": "StringField",
                            "value": "Zubeh\u00f6r Hinweisschilder",
                            "label": "Typ\/Modell"
                        },
                        "nameShort": {
                            "attributeId": "f8c2af32acdac443727a6dadc5917437",
                            "type": "StringField",
                            "value": "Parkplatzschilder-Einschlagpfosten",
                            "label": "LABEL_MISSING"
                        },
                        "nameBullet1": {
                            "attributeId": "197477e550bad420764a27e99f7ff55b",
                            "type": "StringField",
                            "value": "H\u00f6he 750 mm",
                            "label": "LABEL_MISSING"
                        },
                        "artikelMargeProzent": {
                            "attributeId": "38e4c7e297af9f3dc3db3a866da09604",
                            "type": "FloatField",
                            "value": 40.76,
                            "label": "Artikel Marge",
                            "unit": "%"
                        },
                        "eclass101": {
                            "attributeId": "707fa7400989ef43255668a095490309",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 10.1"
                        },
                        "herstellerOriginal": {
                            "attributeId": "61bbdf2bca0073f4404f2740d00add2c",
                            "type": "StringField",
                            "value": "Klar",
                            "label": "Hersteller Original"
                        },
                        "eisKatalogUrl": {
                            "attributeId": "0581c0c06d61e1784605ae623dcf3938",
                            "type": "StringField",
                            "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                            "label": "Katalog Link"
                        },
                        "eclass140": {
                            "attributeId": "249eaf721c50994e2b555d43e0aab090",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 14.0"
                        },
                        "eclass91": {
                            "attributeId": "c7bd39282c5ff77e43704b92e387af62",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 9.1"
                        },
                        "verpackungseinheit": {
                            "attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
                            "type": "IntField",
                            "value": 1,
                            "label": "VPE",
                            "unit": "Stk"
                        },
                        "eclass111": {
                            "attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 11.1"
                        },
                        "nameBullet2": {
                            "attributeId": "38160a50dcd4be0db5d1913984845ec1",
                            "type": "StringField",
                            "value": "verzinkter Stahl",
                            "label": "LABEL_MISSING"
                        },
                        "einstandspreisEis": {
                            "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
                            "type": "StringField",
                            "value": "30.81",
                            "label": "Einstandspreis EIS"
                        },
                        "nameBullet3": {
                            "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda",
                            "type": "StringField",
                            "value": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                            "label": "LABEL_MISSING"
                        },
                        "eclass130": {
                            "attributeId": "5d58ac61bcad814882bb94cafd70e261",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 13.0"
                        },
                        "lieferzeit": {
                            "attributeId": "2286c50ec12650c51f8046b81d08fec9",
                            "type": "IntField",
                            "value": 2,
                            "label": "Lieferzeit",
                            "unit": "Tage"
                        },
                        "eclass51": {
                            "attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 5.1"
                        }
                    },
                    "attribute_eclass120": "40020290",
                    "attribute_bestEinheit": "St\u00fcck",
                    "attribute_googleShoppingStatus": "true",
                    "attribute_eclass71": "40020202",
                    "attribute_eclass81": "40020290",
                    "attribute_artikelMargeEuroEUR": 21.19,
                    "attribute_typModel": "Zubeh\u00f6r Hinweisschilder",
                    "attribute_nameShort": "Parkplatzschilder-Einschlagpfosten",
                    "attribute_nameBullet1": "H\u00f6he 750 mm",
                    "attribute_artikelMargeProzent": 40.76,
                    "attribute_eclass101": "40020290",
                    "attribute_herstellerOriginal": "Klar",
                    "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                    "attribute_eclass140": "40020290",
                    "attribute_eclass91": "40020290",
                    "attribute_verpackungseinheit": 1,
                    "attribute_eclass111": "40020290",
                    "attribute_nameBullet2": "verzinkter Stahl",
                    "attribute_einstandspreisEis": "30.81",
                    "attribute_nameBullet3": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                    "attribute_eclass130": "40020290",
                    "attribute_lieferzeit": 2,
                    "attribute_eclass51": "40020202",
                    "streams": [
                        {
                            "id": "019155b0ab717ff5aa7e62cd921b9c4f"
                        },
                        {
                            "id": "019715dd36eb7283ade18d2b416a06b3"
                        },
                        {
                            "id": "019a24914ff5722baf0286f49f888d6a"
                        },
                        {
                            "id": "99812552a73a423a88a4852c8dd44140"
                        },
                        {
                            "id": "af586506470e46f89c7f3f8dea7fb411"
                        },
                        {
                            "id": "b9d3b15fd1214916bf581223c54fdff8"
                        },
                        {
                            "id": "bad0539785be4dd9a32c976f5152881e"
                        },
                        {
                            "id": "cb292e1aaf854891a0d4e2fca32dd02f"
                        },
                        {
                            "id": "e55203ade881479cb68bf1433fda4c6c"
                        },
                        {
                            "id": "e7e9c4af806040279b50e96833d5aedb"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "a0e99df70840f47f7344d7a0a8312b7c"
                    ]
                },
                "sort": [
                    0,
                    100.0,
                    0,
                    -9223372036854775808,
                    "a305b01dc0c1271813f690022b582271"
                ]
            },
            {
                "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
                "_id": "b8c944f627f9e0046c48a5790a19ba0d",
                "_score": 100.0,
                "_source": {
                    "id": "b8c944f627f9e0046c48a5790a19ba0d",
                    "name": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm, H\u00f6he 510 mm, verzinkter Stahl, mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                    "description": "Zubeh\u00f6r zur Befestigung Pfosten mit Bodenplatte f\u00fcr Parkplatzkennzeichnungen \u2219 Pfosten H = 510 mm mit Bodenplatte 8 x 8 cm, mit 4 Lochungen 10 mm \u00d8 zur Befestigung auf festen Untergr\u00fcnden \u2219 Verzinkter Stahl mit 2 mm Aluminiumgrundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520 x 110 mm\u2219 Inkl. Schrauben und Muttern zur Befestigung von Grundplatte und Pfosten Pfosten mit Bodenplatte",
                    "metaTitle": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm",
                    "metaDescription": "Parkplatzschilder-Pfosten H\u00f6he 510 mm verzinkter Stahl mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm      ",
                    "customSearchKeywords": [
                        ""
                    ],
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "customFields": {
                        "custom_eis_skus_sku1": "E868173G",
                        "custom_eis_skus_sku4": "E868173B",
                        "custom_topartikel_position": 0.0,
                        "custom_topartikel_kategorie": false,
                        "acris_search_sorting_relevance": 0,
                        "custom_customer_group_discount_exclude": false,
                        "acris_price_on_request_additional_field": false
                    },
                    "visibilities": [
                        {
                            "visibility": "30",
                            "salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
                            "_count": 1
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "E868173-BS",
                    "ean": null,
                    "displayGroup": "958b08a982fa19448c1912bffccde81d",
                    "sales": 0,
                    "stock": 0,
                    "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301",
                    "manufacturerNumber": "5042\/52",
                    "manufacturer": {
                        "id": "c3a426735eefdce4df6537fb4b7ae301",
                        "name": "KLAR",
                        "_count": 1
                    },
                    "releaseDate": null,
                    "createdAt": "2023-12-20T17:14:43+00:00",
                    "optionIds": [],
                    "options": [],
                    "categories": [
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "name": "Zubeh\u00f6r Beschilderung"
                        }
                    ],
                    "categoriesRo": [
                        {
                            "id": "b283b270431e4a1285d331e63d0e6202",
                            "_count": 1
                        },
                        {
                            "id": "7902b8704c09ef8cd0c6964c3a1b247e",
                            "_count": 1
                        },
                        {
                            "id": "a37f3e4a8f5e19d03dfc78626b8312bf",
                            "_count": 1
                        },
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "_count": 1
                        }
                    ],
                    "categoryIds": [
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "categoryTree": [
                        "b283b270431e4a1285d331e63d0e6202",
                        "7902b8704c09ef8cd0c6964c3a1b247e",
                        "a37f3e4a8f5e19d03dfc78626b8312bf",
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "properties": [],
                    "propertyIds": [],
                    "taxId": "937f7203705d4d7c8202d8e85be59232",
                    "tags": [],
                    "tagIds": [],
                    "parentId": null,
                    "coverId": "4c898c3f1c9367f95c05582afc69921b",
                    "childCount": 0,
                    "states": [
                        "is-physical"
                    ],
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 85.68,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 72.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
                    "bergerDownloads": [],
                    "bergerBadges": [],
                    "attributes": {
                        "eclass140": {
                            "attributeId": "249eaf721c50994e2b555d43e0aab090",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 14.0"
                        },
                        "bestEinheit": {
                            "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
                            "type": "StringField",
                            "value": "St\u00fcck",
                            "label": "Bestelleinheit"
                        },
                        "eclass91": {
                            "attributeId": "c7bd39282c5ff77e43704b92e387af62",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 9.1"
                        },
                        "eclass111": {
                            "attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 11.1"
                        },
                        "artikelMargeProzent": {
                            "attributeId": "38e4c7e297af9f3dc3db3a866da09604",
                            "type": "FloatField",
                            "value": 40.68,
                            "label": "Artikel Marge",
                            "unit": "%"
                        },
                        "eclass130": {
                            "attributeId": "5d58ac61bcad814882bb94cafd70e261",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 13.0"
                        },
                        "eclass51": {
                            "attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 5.1"
                        },
                        "eclass81": {
                            "attributeId": "635cb161fc196c46a8d7104a3a101a02",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 8.1"
                        },
                        "eclass120": {
                            "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 12.0"
                        },
                        "eclass101": {
                            "attributeId": "707fa7400989ef43255668a095490309",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 10.1"
                        },
                        "typModel": {
                            "attributeId": "59c6c7d9678c652ba957d0e829c20200",
                            "type": "StringField",
                            "value": "Zubeh\u00f6r Hinweisschilder",
                            "label": "Typ\/Modell"
                        },
                        "eclass71": {
                            "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 7.1"
                        },
                        "lieferzeit": {
                            "attributeId": "2286c50ec12650c51f8046b81d08fec9",
                            "type": "IntField",
                            "value": 2,
                            "label": "Lieferzeit",
                            "unit": "Tage"
                        },
                        "nameBullet3": {
                            "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda",
                            "type": "StringField",
                            "value": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                            "label": "LABEL_MISSING"
                        },
                        "nameBullet2": {
                            "attributeId": "38160a50dcd4be0db5d1913984845ec1",
                            "type": "StringField",
                            "value": "verzinkter Stahl",
                            "label": "LABEL_MISSING"
                        },
                        "nameShort": {
                            "attributeId": "f8c2af32acdac443727a6dadc5917437",
                            "type": "StringField",
                            "value": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm",
                            "label": "LABEL_MISSING"
                        },
                        "einstandspreisEis": {
                            "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
                            "type": "StringField",
                            "value": "42.71",
                            "label": "Einstandspreis EIS"
                        },
                        "verpackungseinheit": {
                            "attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
                            "type": "IntField",
                            "value": 1,
                            "label": "VPE",
                            "unit": "Stk"
                        },
                        "herstellerOriginal": {
                            "attributeId": "61bbdf2bca0073f4404f2740d00add2c",
                            "type": "StringField",
                            "value": "Klar",
                            "label": "Hersteller Original"
                        },
                        "googleAdsStatus": {
                            "attributeId": "16a7d38026eeece4a10ccb253bd0fa55",
                            "type": "BoolField",
                            "value": "false",
                            "label": "Google Ads Status"
                        },
                        "artikelMargeEuroEUR": {
                            "attributeId": "467fd043cc3272e0ef48046f37fefff7",
                            "type": "FloatField",
                            "value": 29.29,
                            "label": "Artikel Marge",
                            "unit": "\u20ac"
                        },
                        "eisKatalogUrl": {
                            "attributeId": "0581c0c06d61e1784605ae623dcf3938",
                            "type": "StringField",
                            "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                            "label": "Katalog Link"
                        },
                        "googleShoppingStatus": {
                            "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8",
                            "type": "BoolField",
                            "value": "true",
                            "label": "Google Shopping Status"
                        },
                        "nameBullet1": {
                            "attributeId": "197477e550bad420764a27e99f7ff55b",
                            "type": "StringField",
                            "value": "H\u00f6he 510 mm",
                            "label": "LABEL_MISSING"
                        }
                    },
                    "attribute_eclass140": "40020290",
                    "attribute_bestEinheit": "St\u00fcck",
                    "attribute_eclass91": "40020290",
                    "attribute_eclass111": "40020290",
                    "attribute_artikelMargeProzent": 40.68,
                    "attribute_eclass130": "40020290",
                    "attribute_eclass51": "40020202",
                    "attribute_eclass81": "40020290",
                    "attribute_eclass120": "40020290",
                    "attribute_eclass101": "40020290",
                    "attribute_typModel": "Zubeh\u00f6r Hinweisschilder",
                    "attribute_eclass71": "40020202",
                    "attribute_lieferzeit": 2,
                    "attribute_nameBullet3": "mit Alu-Grundplatte als Schildtr\u00e4ger f\u00fcr Gr\u00f6\u00dfe 520x110 mm",
                    "attribute_nameBullet2": "verzinkter Stahl",
                    "attribute_nameShort": "Parkplatzschilder-Pfosten mit Bodenplatte 80x80 mm",
                    "attribute_einstandspreisEis": "42.71",
                    "attribute_verpackungseinheit": 1,
                    "attribute_herstellerOriginal": "Klar",
                    "attribute_googleAdsStatus": "false",
                    "attribute_artikelMargeEuroEUR": 29.29,
                    "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                    "attribute_googleShoppingStatus": "true",
                    "attribute_nameBullet1": "H\u00f6he 510 mm",
                    "streams": [
                        {
                            "id": "019155b0ab717ff5aa7e62cd921b9c4f"
                        },
                        {
                            "id": "019715dd36eb7283ade18d2b416a06b3"
                        },
                        {
                            "id": "019a24914ff5722baf0286f49f888d6a"
                        },
                        {
                            "id": "99812552a73a423a88a4852c8dd44140"
                        },
                        {
                            "id": "af586506470e46f89c7f3f8dea7fb411"
                        },
                        {
                            "id": "b9d3b15fd1214916bf581223c54fdff8"
                        },
                        {
                            "id": "bad0539785be4dd9a32c976f5152881e"
                        },
                        {
                            "id": "cb292e1aaf854891a0d4e2fca32dd02f"
                        },
                        {
                            "id": "e55203ade881479cb68bf1433fda4c6c"
                        },
                        {
                            "id": "e7e9c4af806040279b50e96833d5aedb"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "958b08a982fa19448c1912bffccde81d"
                    ]
                },
                "sort": [
                    0,
                    100.0,
                    0,
                    -9223372036854775808,
                    "b8c944f627f9e0046c48a5790a19ba0d"
                ]
            },
            {
                "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
                "_id": "d5bc4c69eebffe569b225cf2e19d348e",
                "_score": 100.0,
                "_source": {
                    "id": "d5bc4c69eebffe569b225cf2e19d348e",
                    "name": "Befestigungsmaterial f\u00fcr Gangschilder, Stahlspiralfedern, 200 mm lang, 2 mm stark, zum Abh\u00e4ngen von Plakaten, Plakatrahmen, etc., VE 50 St\u00fcck",
                    "description": "Stahlspiralfedern, 200 mm lang, 2 mm stark",
                    "metaTitle": "Befestigungsmaterial f\u00fcr Gangschilder",
                    "metaDescription": "Befestigungsmaterial Stahlspiralfedern 200 mm lang 2 mm stark zum Abh\u00e4ngen von Plakaten Plakatrahmen etc. VE 50 St\u00fcck  ",
                    "customSearchKeywords": [
                        ""
                    ],
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "customFields": {
                        "custom_eis_skus_sku1": "E6479738G",
                        "custom_eis_skus_sku4": "E6479738B",
                        "custom_topartikel_position": 0.0,
                        "custom_topartikel_kategorie": false,
                        "acris_search_sorting_relevance": 0,
                        "custom_customer_group_discount_exclude": false,
                        "acris_price_on_request_additional_field": false
                    },
                    "visibilities": [
                        {
                            "visibility": "30",
                            "salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
                            "_count": 1
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "E6479738-BS",
                    "ean": "4250432911146",
                    "displayGroup": "6ecde0e71ae4d36c364650999297d5e7",
                    "sales": 0,
                    "stock": 0,
                    "manufacturerId": null,
                    "manufacturerNumber": "BFM.ST.200.00",
                    "manufacturer": {
                        "id": null,
                        "name": "",
                        "_count": 1
                    },
                    "releaseDate": null,
                    "createdAt": "2024-07-25T05:20:28+00:00",
                    "optionIds": [],
                    "options": [],
                    "categories": [
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "name": "Zubeh\u00f6r Beschilderung"
                        }
                    ],
                    "categoriesRo": [
                        {
                            "id": "b283b270431e4a1285d331e63d0e6202",
                            "_count": 1
                        },
                        {
                            "id": "7902b8704c09ef8cd0c6964c3a1b247e",
                            "_count": 1
                        },
                        {
                            "id": "a37f3e4a8f5e19d03dfc78626b8312bf",
                            "_count": 1
                        },
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "_count": 1
                        }
                    ],
                    "categoryIds": [
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "categoryTree": [
                        "b283b270431e4a1285d331e63d0e6202",
                        "7902b8704c09ef8cd0c6964c3a1b247e",
                        "a37f3e4a8f5e19d03dfc78626b8312bf",
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "properties": [],
                    "propertyIds": [],
                    "taxId": "937f7203705d4d7c8202d8e85be59232",
                    "tags": [],
                    "tagIds": [],
                    "parentId": null,
                    "coverId": "e6d323e805f573d3499f38070854c01c",
                    "childCount": 0,
                    "states": [
                        "is-physical"
                    ],
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.42,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
                    "bergerDownloads": [],
                    "bergerBadges": [
                        {
                            "id": "a40a7ff3362f118278c6d5f91ec7d0ad",
                            "sorting": 1,
                            "active": false,
                            "color": "",
                            "label": ""
                        }
                    ],
                    "attributes": {
                        "eclass111": {
                            "attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
                            "type": "StringField",
                            "value": "24281490",
                            "label": "eClass 11.1"
                        },
                        "nameBullet6": {
                            "attributeId": "6179ec8102510973ee43f8bcebbb14e5",
                            "type": "StringField",
                            "value": "etc.",
                            "label": "LABEL_MISSING"
                        },
                        "nameShort": {
                            "attributeId": "f8c2af32acdac443727a6dadc5917437",
                            "type": "StringField",
                            "value": "Befestigungsmaterial f\u00fcr Gangschilder",
                            "label": "LABEL_MISSING"
                        },
                        "nameBullet7": {
                            "attributeId": "b8301d8a5f47a1b1c8bd8ad33b81ad4d",
                            "type": "StringField",
                            "value": "VE 50 St\u00fcck",
                            "label": "LABEL_MISSING"
                        },
                        "herstellerOriginal": {
                            "attributeId": "61bbdf2bca0073f4404f2740d00add2c",
                            "type": "StringField",
                            "value": "Onk",
                            "label": "Hersteller Original"
                        },
                        "nameBullet3": {
                            "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda",
                            "type": "StringField",
                            "value": "2 mm stark",
                            "label": "LABEL_MISSING"
                        },
                        "eisKatalogUrl": {
                            "attributeId": "0581c0c06d61e1784605ae623dcf3938",
                            "type": "StringField",
                            "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=124",
                            "label": "Katalog Link"
                        },
                        "lieferzeit": {
                            "attributeId": "2286c50ec12650c51f8046b81d08fec9",
                            "type": "IntField",
                            "value": 5,
                            "label": "Lieferzeit",
                            "unit": "Tage"
                        },
                        "eclass81": {
                            "attributeId": "635cb161fc196c46a8d7104a3a101a02",
                            "type": "StringField",
                            "value": "24290490",
                            "label": "eClass 8.1"
                        },
                        "eclass71": {
                            "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
                            "type": "StringField",
                            "value": "24290490",
                            "label": "eClass 7.1"
                        },
                        "artikelMargeEuroEUR": {
                            "attributeId": "467fd043cc3272e0ef48046f37fefff7",
                            "type": "FloatField",
                            "value": 7.23,
                            "label": "Artikel Marge",
                            "unit": "\u20ac"
                        },
                        "verpackungseinheit": {
                            "attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
                            "type": "IntField",
                            "value": 1,
                            "label": "VPE",
                            "unit": "Stk"
                        },
                        "nameBullet1": {
                            "attributeId": "197477e550bad420764a27e99f7ff55b",
                            "type": "StringField",
                            "value": "Stahlspiralfedern",
                            "label": "LABEL_MISSING"
                        },
                        "nameBullet4": {
                            "attributeId": "0be25007df01a9d0afc79823441bdfa2",
                            "type": "StringField",
                            "value": "zum Abh\u00e4ngen von Plakaten",
                            "label": "LABEL_MISSING"
                        },
                        "eclass130": {
                            "attributeId": "5d58ac61bcad814882bb94cafd70e261",
                            "type": "StringField",
                            "value": "24281490",
                            "label": "eClass 13.0"
                        },
                        "googleShoppingStatus": {
                            "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8",
                            "type": "BoolField",
                            "value": "true",
                            "label": "Google Shopping Status"
                        },
                        "einstandspreisEis": {
                            "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
                            "type": "StringField",
                            "value": "10.77",
                            "label": "Einstandspreis EIS"
                        },
                        "eclass120": {
                            "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
                            "type": "StringField",
                            "value": "24281490",
                            "label": "eClass 12.0"
                        },
                        "artikelMargeProzent": {
                            "attributeId": "38e4c7e297af9f3dc3db3a866da09604",
                            "type": "FloatField",
                            "value": 40.17,
                            "label": "Artikel Marge",
                            "unit": "%"
                        },
                        "nameBullet2": {
                            "attributeId": "38160a50dcd4be0db5d1913984845ec1",
                            "type": "StringField",
                            "value": "200 mm lang",
                            "label": "LABEL_MISSING"
                        },
                        "nameBullet5": {
                            "attributeId": "9dd015d5e51ff73a0665faaf467410b3",
                            "type": "StringField",
                            "value": "Plakatrahmen",
                            "label": "LABEL_MISSING"
                        },
                        "eclass101": {
                            "attributeId": "707fa7400989ef43255668a095490309",
                            "type": "StringField",
                            "value": "24281490",
                            "label": "eClass 10.1"
                        },
                        "typModel": {
                            "attributeId": "59c6c7d9678c652ba957d0e829c20200",
                            "type": "StringField",
                            "value": "Zubeh\u00f6r Hinweisschilder",
                            "label": "Typ\/Modell"
                        },
                        "eclass91": {
                            "attributeId": "c7bd39282c5ff77e43704b92e387af62",
                            "type": "StringField",
                            "value": "24290490",
                            "label": "eClass 9.1"
                        },
                        "bestEinheit": {
                            "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
                            "type": "StringField",
                            "value": "Pack",
                            "label": "Bestelleinheit"
                        },
                        "eclass140": {
                            "attributeId": "249eaf721c50994e2b555d43e0aab090",
                            "type": "StringField",
                            "value": "24281490",
                            "label": "eClass 14.0"
                        }
                    },
                    "attribute_eclass111": "24281490",
                    "attribute_nameBullet6": "etc.",
                    "attribute_nameShort": "Befestigungsmaterial f\u00fcr Gangschilder",
                    "attribute_nameBullet7": "VE 50 St\u00fcck",
                    "attribute_herstellerOriginal": "Onk",
                    "attribute_nameBullet3": "2 mm stark",
                    "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=124",
                    "attribute_lieferzeit": 5,
                    "attribute_eclass81": "24290490",
                    "attribute_eclass71": "24290490",
                    "attribute_artikelMargeEuroEUR": 7.23,
                    "attribute_verpackungseinheit": 1,
                    "attribute_nameBullet1": "Stahlspiralfedern",
                    "attribute_nameBullet4": "zum Abh\u00e4ngen von Plakaten",
                    "attribute_eclass130": "24281490",
                    "attribute_googleShoppingStatus": "true",
                    "attribute_einstandspreisEis": "10.77",
                    "attribute_eclass120": "24281490",
                    "attribute_artikelMargeProzent": 40.17,
                    "attribute_nameBullet2": "200 mm lang",
                    "attribute_nameBullet5": "Plakatrahmen",
                    "attribute_eclass101": "24281490",
                    "attribute_typModel": "Zubeh\u00f6r Hinweisschilder",
                    "attribute_eclass91": "24290490",
                    "attribute_bestEinheit": "Pack",
                    "attribute_eclass140": "24281490",
                    "streams": [
                        {
                            "id": "019155b0ab717ff5aa7e62cd921b9c4f"
                        },
                        {
                            "id": "019715dd36eb7283ade18d2b416a06b3"
                        },
                        {
                            "id": "019a24914ff5722baf0286f49f888d6a"
                        },
                        {
                            "id": "99812552a73a423a88a4852c8dd44140"
                        },
                        {
                            "id": "af586506470e46f89c7f3f8dea7fb411"
                        },
                        {
                            "id": "b9d3b15fd1214916bf581223c54fdff8"
                        },
                        {
                            "id": "bad0539785be4dd9a32c976f5152881e"
                        },
                        {
                            "id": "cb292e1aaf854891a0d4e2fca32dd02f"
                        },
                        {
                            "id": "e55203ade881479cb68bf1433fda4c6c"
                        },
                        {
                            "id": "e7e9c4af806040279b50e96833d5aedb"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "6ecde0e71ae4d36c364650999297d5e7"
                    ]
                },
                "sort": [
                    0,
                    100.0,
                    0,
                    -9223372036854775808,
                    "d5bc4c69eebffe569b225cf2e19d348e"
                ]
            },
            {
                "_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
                "_id": "e775aa7303274ee248fc66d1579baf2e",
                "_score": 100.0,
                "_source": {
                    "id": "e775aa7303274ee248fc66d1579baf2e",
                    "name": "Schraubensatz, best. aus 4 schrauben, Muttern, Zahnscheibe, f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte",
                    "description": "Zubeh\u00f6r zur Befestigung Schraubensatz f\u00fcr die Anbringung von Parkplatzreservierungsschild auf die Aluminiumgrundplatte \u2219 1 Satz = 4 Schrauben, Muttern und Zahnscheiben\u00a0 Schraubensatz",
                    "metaTitle": "Schraubensatz",
                    "metaDescription": "Schraubensatz best. aus 4 schrauben Muttern Zahnscheibe f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte     ",
                    "customSearchKeywords": [
                        ""
                    ],
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "customFields": {
                        "custom_eis_skus_sku1": "E868174G",
                        "custom_eis_skus_sku4": "E868174B",
                        "custom_topartikel_position": 0.0,
                        "custom_topartikel_kategorie": false,
                        "acris_search_sorting_relevance": 0,
                        "custom_customer_group_discount_exclude": false,
                        "acris_price_on_request_additional_field": false
                    },
                    "visibilities": [
                        {
                            "visibility": "30",
                            "salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
                            "_count": 1
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "E868174-BS",
                    "ean": null,
                    "displayGroup": "b9f823bdeb1a179192273b9b8b3e9771",
                    "sales": 0,
                    "stock": 0,
                    "manufacturerId": "c3a426735eefdce4df6537fb4b7ae301",
                    "manufacturerNumber": "5040\/01",
                    "manufacturer": {
                        "id": "c3a426735eefdce4df6537fb4b7ae301",
                        "name": "KLAR",
                        "_count": 1
                    },
                    "releaseDate": null,
                    "createdAt": "2023-12-20T17:14:43+00:00",
                    "optionIds": [],
                    "options": [],
                    "categories": [
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "name": "Zubeh\u00f6r Beschilderung"
                        }
                    ],
                    "categoriesRo": [
                        {
                            "id": "b283b270431e4a1285d331e63d0e6202",
                            "_count": 1
                        },
                        {
                            "id": "7902b8704c09ef8cd0c6964c3a1b247e",
                            "_count": 1
                        },
                        {
                            "id": "a37f3e4a8f5e19d03dfc78626b8312bf",
                            "_count": 1
                        },
                        {
                            "id": "cba0ec61fc7ca8c91a97a2eea6200974",
                            "_count": 1
                        }
                    ],
                    "categoryIds": [
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "categoryTree": [
                        "b283b270431e4a1285d331e63d0e6202",
                        "7902b8704c09ef8cd0c6964c3a1b247e",
                        "a37f3e4a8f5e19d03dfc78626b8312bf",
                        "cba0ec61fc7ca8c91a97a2eea6200974"
                    ],
                    "properties": [],
                    "propertyIds": [],
                    "taxId": "937f7203705d4d7c8202d8e85be59232",
                    "tags": [],
                    "tagIds": [],
                    "parentId": null,
                    "coverId": "cdd1eab8270127a0ebe0a8049c6ac45c",
                    "childCount": 0,
                    "states": [
                        "is-physical"
                    ],
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.33,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.8,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
                    "bergerDownloads": [],
                    "bergerBadges": [],
                    "attributes": {
                        "nameBullet3": {
                            "attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda",
                            "type": "StringField",
                            "value": "Zahnscheibe",
                            "label": "LABEL_MISSING"
                        },
                        "eclass81": {
                            "attributeId": "635cb161fc196c46a8d7104a3a101a02",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 8.1"
                        },
                        "nameBullet4": {
                            "attributeId": "0be25007df01a9d0afc79823441bdfa2",
                            "type": "StringField",
                            "value": "f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte",
                            "label": "LABEL_MISSING"
                        },
                        "eclass130": {
                            "attributeId": "5d58ac61bcad814882bb94cafd70e261",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 13.0"
                        },
                        "eclass51": {
                            "attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 5.1"
                        },
                        "bestEinheit": {
                            "attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
                            "type": "StringField",
                            "value": "Set",
                            "label": "Bestelleinheit"
                        },
                        "eclass91": {
                            "attributeId": "c7bd39282c5ff77e43704b92e387af62",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 9.1"
                        },
                        "einstandspreisEis": {
                            "attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
                            "type": "StringField",
                            "value": "1.56",
                            "label": "Einstandspreis EIS"
                        },
                        "googleShoppingStatus": {
                            "attributeId": "e27bf01a6aa011f7ac717d143a5ef0c8",
                            "type": "BoolField",
                            "value": "true",
                            "label": "Google Shopping Status"
                        },
                        "verpackungseinheit": {
                            "attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
                            "type": "IntField",
                            "value": 1,
                            "label": "VPE",
                            "unit": "Stk"
                        },
                        "nameShort": {
                            "attributeId": "f8c2af32acdac443727a6dadc5917437",
                            "type": "StringField",
                            "value": "Schraubensatz",
                            "label": "LABEL_MISSING"
                        },
                        "herstellerOriginal": {
                            "attributeId": "61bbdf2bca0073f4404f2740d00add2c",
                            "type": "StringField",
                            "value": "Klar",
                            "label": "Hersteller Original"
                        },
                        "eclass111": {
                            "attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 11.1"
                        },
                        "eisKatalogUrl": {
                            "attributeId": "0581c0c06d61e1784605ae623dcf3938",
                            "type": "StringField",
                            "value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                            "label": "Katalog Link"
                        },
                        "eclass101": {
                            "attributeId": "707fa7400989ef43255668a095490309",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 10.1"
                        },
                        "artikelMargeProzent": {
                            "attributeId": "38e4c7e297af9f3dc3db3a866da09604",
                            "type": "FloatField",
                            "value": 44.39,
                            "label": "Artikel Marge",
                            "unit": "%"
                        },
                        "artikelMargeEuroEUR": {
                            "attributeId": "467fd043cc3272e0ef48046f37fefff7",
                            "type": "FloatField",
                            "value": 1.24,
                            "label": "Artikel Marge",
                            "unit": "\u20ac"
                        },
                        "nameBullet2": {
                            "attributeId": "38160a50dcd4be0db5d1913984845ec1",
                            "type": "StringField",
                            "value": "Muttern",
                            "label": "LABEL_MISSING"
                        },
                        "typModel": {
                            "attributeId": "59c6c7d9678c652ba957d0e829c20200",
                            "type": "StringField",
                            "value": "Zubeh\u00f6r Hinweisschilder",
                            "label": "Typ\/Modell"
                        },
                        "lieferzeit": {
                            "attributeId": "2286c50ec12650c51f8046b81d08fec9",
                            "type": "IntField",
                            "value": 2,
                            "label": "Lieferzeit",
                            "unit": "Tage"
                        },
                        "eclass120": {
                            "attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 12.0"
                        },
                        "eclass71": {
                            "attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
                            "type": "StringField",
                            "value": "40020202",
                            "label": "eClass 7.1"
                        },
                        "nameBullet1": {
                            "attributeId": "197477e550bad420764a27e99f7ff55b",
                            "type": "StringField",
                            "value": "best. aus 4 schrauben",
                            "label": "LABEL_MISSING"
                        },
                        "eclass140": {
                            "attributeId": "249eaf721c50994e2b555d43e0aab090",
                            "type": "StringField",
                            "value": "40020290",
                            "label": "eClass 14.0"
                        }
                    },
                    "attribute_nameBullet3": "Zahnscheibe",
                    "attribute_eclass81": "40020290",
                    "attribute_nameBullet4": "f\u00fcr die Anbringung des Parkplatzschildes an der Grundplatte",
                    "attribute_eclass130": "40020290",
                    "attribute_eclass51": "40020202",
                    "attribute_bestEinheit": "Set",
                    "attribute_eclass91": "40020290",
                    "attribute_einstandspreisEis": "1.56",
                    "attribute_googleShoppingStatus": "true",
                    "attribute_verpackungseinheit": 1,
                    "attribute_nameShort": "Schraubensatz",
                    "attribute_herstellerOriginal": "Klar",
                    "attribute_eclass111": "40020290",
                    "attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=147",
                    "attribute_eclass101": "40020290",
                    "attribute_artikelMargeProzent": 44.39,
                    "attribute_artikelMargeEuroEUR": 1.24,
                    "attribute_nameBullet2": "Muttern",
                    "attribute_typModel": "Zubeh\u00f6r Hinweisschilder",
                    "attribute_lieferzeit": 2,
                    "attribute_eclass120": "40020290",
                    "attribute_eclass71": "40020202",
                    "attribute_nameBullet1": "best. aus 4 schrauben",
                    "attribute_eclass140": "40020290",
                    "streams": [
                        {
                            "id": "019155b0ab717ff5aa7e62cd921b9c4f"
                        },
                        {
                            "id": "019715dd36eb7283ade18d2b416a06b3"
                        },
                        {
                            "id": "019a24914ff5722baf0286f49f888d6a"
                        },
                        {
                            "id": "99812552a73a423a88a4852c8dd44140"
                        },
                        {
                            "id": "af586506470e46f89c7f3f8dea7fb411"
                        },
                        {
                            "id": "b9d3b15fd1214916bf581223c54fdff8"
                        },
                        {
                            "id": "bad0539785be4dd9a32c976f5152881e"
                        },
                        {
                            "id": "cb292e1aaf854891a0d4e2fca32dd02f"
                        },
                        {
                            "id": "e55203ade881479cb68bf1433fda4c6c"
                        },
                        {
                            "id": "e7e9c4af806040279b50e96833d5aedb"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b9f823bdeb1a179192273b9b8b3e9771"
                    ]
                },
                "sort": [
                    0,
                    100.0,
                    0,
                    -9223372036854775808,
                    "e775aa7303274ee248fc66d1579baf2e"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 5
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

6.33 ms

Request:

{"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cba0ec61fc7ca8c91a97a2eea6200974"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"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}}}},"manufacturer-count-filter":{"composite":{"sources":[{"manufacturer-count-filter.sorting":{"terms":{"field":"manufacturerId","order":"ASC"}}},{"manufacturer-count-filter.key":{"terms":{"field":"manufacturerId"}}}],"size":"99999"}},"bool-reduced":{"filter":{"script":{"script":{"id":"cheapest_price_percentage_filter","params":{"gt":1.0,"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1}]}}}},"aggregations":{"bool-reduced":{"value_count":{"field":"id"}}}},"width":{"stats":{"field":"width"}},"width-stats":{"filter":{"range":{"width":{"gt":0.0}}},"aggregations":{"width-stats":{"stats":{"field":"width"}}}},"height":{"stats":{"field":"height"}},"height-stats":{"filter":{"range":{"height":{"gt":0.0}}},"aggregations":{"height-stats":{"stats":{"field":"height"}}}},"tiefe":{"stats":{"field":"attribute_tiefe"}},"multi-material":{"composite":{"sources":[{"multi-material.sorting":{"terms":{"field":"attribute_material","order":"ASC"}}},{"multi-material.key":{"terms":{"field":"attribute_material"}}}],"size":"99999"}},"manufacturer-count":{"terms":{"field":"manufacturerId","size":10000}}},"size":0,"timeout":"5s"}}

Item count: 5
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9200/staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b/_search?
    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": "132e445c03814d67ac47c04afb6d5d99"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "cba0ec61fc7ca8c91a97a2eea6200974"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "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
                    }
                }
            }
        },
        "manufacturer-count-filter": {
            "composite": {
                "sources": [
                    {
                        "manufacturer-count-filter.sorting": {
                            "terms": {
                                "field": "manufacturerId",
                                "order": "ASC"
                            }
                        }
                    },
                    {
                        "manufacturer-count-filter.key": {
                            "terms": {
                                "field": "manufacturerId"
                            }
                        }
                    }
                ],
                "size": "99999"
            }
        },
        "bool-reduced": {
            "filter": {
                "script": {
                    "script": {
                        "id": "cheapest_price_percentage_filter",
                        "params": {
                            "gt": 1.0,
                            "accessors": [
                                {
                                    "key": "cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                },
                                {
                                    "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage",
                                    "factor": 1
                                }
                            ]
                        }
                    }
                }
            },
            "aggregations": {
                "bool-reduced": {
                    "value_count": {
                        "field": "id"
                    }
                }
            }
        },
        "width": {
            "stats": {
                "field": "width"
            }
        },
        "width-stats": {
            "filter": {
                "range": {
                    "width": {
                        "gt": 0.0
                    }
                }
            },
            "aggregations": {
                "width-stats": {
                    "stats": {
                        "field": "width"
                    }
                }
            }
        },
        "height": {
            "stats": {
                "field": "height"
            }
        },
        "height-stats": {
            "filter": {
                "range": {
                    "height": {
                        "gt": 0.0
                    }
                }
            },
            "aggregations": {
                "height-stats": {
                    "stats": {
                        "field": "height"
                    }
                }
            }
        },
        "tiefe": {
            "stats": {
                "field": "attribute_tiefe"
            }
        },
        "multi-material": {
            "composite": {
                "sources": [
                    {
                        "multi-material.sorting": {
                            "terms": {
                                "field": "attribute_material",
                                "order": "ASC"
                            }
                        }
                    },
                    {
                        "multi-material.key": {
                            "terms": {
                                "field": "attribute_material"
                            }
                        }
                    }
                ],
                "size": "99999"
            }
        },
        "manufacturer-count": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 5,
            "relation": "eq"
        },
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "rating-exists": {
            "doc_count": 5,
            "rating": {
                "value": 0.0
            }
        },
        "multi-material": {
            "buckets": []
        },
        "manufacturer-count": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "c3a426735eefdce4df6537fb4b7ae301",
                    "doc_count": 4
                }
            ]
        },
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "bool-reduced": {
            "doc_count": 0,
            "bool-reduced": {
                "value": 0
            }
        },
        "height-stats": {
            "doc_count": 0,
            "height-stats": {
                "count": 0,
                "min": null,
                "max": null,
                "avg": null,
                "sum": 0.0
            }
        },
        "price": {
            "count": 5,
            "min": 2.8,
            "max": 72.0,
            "avg": 31.560000000000002,
            "sum": 157.8
        },
        "width-stats": {
            "doc_count": 0,
            "width-stats": {
                "count": 0,
                "min": null,
                "max": null,
                "avg": null,
                "sum": 0.0
            }
        },
        "width": {
            "count": 0,
            "min": null,
            "max": null,
            "avg": null,
            "sum": 0.0
        },
        "manufacturer-count-filter": {
            "after_key": {
                "manufacturer-count-filter.sorting": "c3a426735eefdce4df6537fb4b7ae301",
                "manufacturer-count-filter.key": "c3a426735eefdce4df6537fb4b7ae301"
            },
            "buckets": [
                {
                    "key": {
                        "manufacturer-count-filter.sorting": "c3a426735eefdce4df6537fb4b7ae301",
                        "manufacturer-count-filter.key": "c3a426735eefdce4df6537fb4b7ae301"
                    },
                    "doc_count": 4
                }
            ]
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "tiefe": {
            "count": 0,
            "min": null,
            "max": null,
            "avg": null,
            "sum": 0.0
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "height": {
            "count": 0,
            "min": null,
            "max": null,
            "avg": null,
            "sum": 0.0
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "staging-cluster",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 125,
    "active_shards": 125,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 363,
    "unassigned_primary_shards": 0,
    "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": 25.614754098360653
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1759745873	open	3, 3	670414
staging-67_product_1771834761	open	1, 1	741335
staging-67_product_1771836443	open	1, 1	981199
staging_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1759818738	open	3, 3	517302
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1764161339	open	3, 3	1116075
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1765265423	open	3, 3	1116802
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1760015097	open	3, 3	693655
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1759396554	open	3, 3	669749
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760598047	open	3, 3	692544
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1759396554	open	3, 3	669749
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1760598047	open	3, 3	692544
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1760362847	open	3, 3	688892
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761130554	open	3, 3	712444
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1760338719	open	3, 3	689893
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1761201038	open	3, 3	722395
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1760361213	open	3, 3	0
staging_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1755506711	open	3, 3	517395
staging_product_4915bcbca7d649fda8d6e0f9310aee08_1755506711	open	3, 3	517395
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1764161339	open	3, 3	1116075
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760362847	open	3, 3	688892
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1764139144	open	3, 3	1114281
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1761130554	open	3, 3	712444
staging_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1759223930	open	3, 3	517359
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1765979028	open	3, 3	1118186
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760361213	open	3, 3	51595
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1765265423	open	3, 3	1116802
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761131225	open	3, 3	8984
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761131247	open	3, 3	689012
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038	open	3, 3	722395
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760338719	open	3, 3	689893
staging-67_product_1771837646	open	1, 1	1177427
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1761131225	open	3, 3	0
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1759745873	open	3, 3	670414
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1761131247	open	3, 3	689012
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760015097	open	3, 3	693655
staging_product_4915bcbca7d649fda8d6e0f9310aee08_1759818738	open	3, 3	517302
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1765979028	open	3, 3	1118186
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760347316	open	3, 3	693498
prod_product_4915bcbca7d649fda8d6e0f9310aee08_1760347316	open	3, 3	693498
staging-65_product_4915bcbca7d649fda8d6e0f9310aee08_1760359473	open	3, 3	0
staging_product_4915bcbca7d649fda8d6e0f9310aee08_1759223930	open	3, 3	517359
staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1760359473	open	3, 3	214629
prod_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1764139144	open	3, 3	1114281

Symfony Profiler

GET https://staging-65.berger-shop.de/navigation/cba0ec61fc7ca8c91a97a2eea6200974

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices