Symfony Profiler

Query Metrics

18.00 ms Query Time

1 Node(s)

25 Indices

Queries

#▲ Execution Time Info

13.83 ms

#▲	Execution Time	Info
1	13.83 ms	Request: {"index":"stage2_product","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":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"dd5f5bfa75234389ab74337159e437c6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 9 View formatted request View formatted response View query backtrace POST http://localhost:9202/stage2_product/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "dd5f5bfa75234389ab74337159e437c6" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "string", "script": { "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n", "lang": "painless", "params": { "field": "name", "languages": [ "2fbb5fe2e29a4d70aa5854ce7ce3e20b" ] } }, "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 7, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 9, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "stage2_product_1726559133", "_id": "3ca9de6c3c074e45a6d9229109eb852c", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "3ca9de6c3c074e45a6d9229109eb852c", "autoIncrement": 75736.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 4, "productNumber": "10029898", "ean": null, "displayGroup": "f2076b6918b56dc03998616a562c00aa", "sales": 0, "stock": 4, "weight": 2.8, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "93262af0c45e4463bcaa9dc7c4c35888", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:37:49+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "93262af0c45e4463bcaa9dc7c4c35888", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FAG" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "2ceb0cba8e4e403e8a1b89287978bb8a", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "2ceb0cba8e4e403e8a1b89287978bb8a", "33f805fbdd81401d8058a5c3f10e05d1" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 4.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "543772", "25395a9610c74c1d88408f0cecb48e2a": "543772" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "543772", "FAG", "Deep groove ball bearings" ], "25395a9610c74c1d88408f0cecb48e2a": [ "543772", "FAG", "Deep groove ball bearings" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10029898", "543772" ] }, "fields": { "displayGroup": [ "f2076b6918b56dc03998616a562c00aa" ] }, "sort": [ "543772", "3ca9de6c3c074e45a6d9229109eb852c" ] }, { "_index": "stage2_product_1726559133", "_id": "b6815fec8f1a4a90b5ab17ba92519537", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "b6815fec8f1a4a90b5ab17ba92519537", "autoIncrement": 78307.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 1, "productNumber": "10038511", "ean": null, "displayGroup": "49fcef92bca7752ddf07f59cd075cb5c", "sales": 0, "stock": 1, "weight": 46.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "31ce1fa6506d4c2ea156ce69b79f3ce4", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:59:41+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "81c8cab55c744e33a8d3adf5d5e94d1e", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "31ce1fa6506d4c2ea156ce69b79f3ce4", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NTR" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "2ceb0cba8e4e403e8a1b89287978bb8a", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "2ceb0cba8e4e403e8a1b89287978bb8a" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 1.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CRB L11.20.0544.031.5112A", "25395a9610c74c1d88408f0cecb48e2a": "CRB L11.20.0544.031.5112A" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Drehverbindung", "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "CRB L11.20.0544.031.5112A", "CRB L112005440315112A", "CRB-L11.20.0544.031.5112A", "CRB.L11.20.0544.031.5112A", "CRB L11-20-0544-031-5112A", "CRB L11 20 0544 031 5112A", "CRBL11.20.0544.031.5112A", "CRBL112005440315112A", "CRB L 11.20.0544.031.5112A", "CRB L 112005440315112A", "CRB-L-11.20.0544.031.5112A", "CRB.L.11.20.0544.031.5112A", "CRB L 11-20-0544-031-5112A", "CRB L 11 20 0544 031 5112A", "Drehverbindung", "NEUTRAL", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "CRB L11.20.0544.031.5112A", "CRB L112005440315112A", "CRB-L11.20.0544.031.5112A", "CRB.L11.20.0544.031.5112A", "CRB L11-20-0544-031-5112A", "CRB L11 20 0544 031 5112A", "CRBL11.20.0544.031.5112A", "CRBL112005440315112A", "CRB L 11.20.0544.031.5112A", "CRB L 112005440315112A", "CRB-L-11.20.0544.031.5112A", "CRB.L.11.20.0544.031.5112A", "CRB L 11-20-0544-031-5112A", "CRB L 11 20 0544 031 5112A", "Drehverbindung", "NEUTRAL", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "swagDynamicAccessRules": [ { "id": null, "_count": 1 } ], "parent": { "swagDynamicAccessRules": [ { "id": null, "_count": 1 } ] }, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10038511", "crb", "l11.20.0544.031.5112a", "crb l11.20.0544.031.5112a" ] }, "fields": { "displayGroup": [ "49fcef92bca7752ddf07f59cd075cb5c" ] }, "sort": [ "crb l11.20.0544.031.5112a", "b6815fec8f1a4a90b5ab17ba92519537" ] }, { "_index": "stage2_product_1726559133", "_id": "a873d1fdc3254d738c35347aa04fda37", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "a873d1fdc3254d738c35347aa04fda37", "autoIncrement": 75792.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 2, "productNumber": "10030154", "ean": null, "displayGroup": "c2ff49af6e0f3bc192a7f5108fbfc1ca", "sales": 0, "stock": 2, "weight": 0.2, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "85162abcb8ca413fa62992603cb976be", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:38:17+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "85162abcb8ca413fa62992603cb976be", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } }, { "id": "880dd8a94ff749d7af52d78c700ccaa4", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "33f805fbdd81401d8058a5c3f10e05d1", "880dd8a94ff749d7af52d78c700ccaa4" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 2.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-202259\/299848", "25395a9610c74c1d88408f0cecb48e2a": "F-202259\/299848" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-Lager", "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "F-202259 299848", "F-202259-299848", "F-202259.299848", "F 202259 299848", "F.202259 299848", "F-202259299848", "F202259299848", "F- 202259 299848", "F--202259-299848", "F-.202259.299848", "F 202259 299848", "F. 202259 299848", "F-Lager", "INA", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "F-202259 299848", "F-202259-299848", "F-202259.299848", "F 202259 299848", "F.202259 299848", "F-202259299848", "F202259299848", "F- 202259 299848", "F--202259-299848", "F-.202259.299848", "F 202259 299848", "F. 202259 299848", "F-Lager", "INA", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10030154", "f-202259\/299848" ] }, "fields": { "displayGroup": [ "c2ff49af6e0f3bc192a7f5108fbfc1ca" ] }, "sort": [ "f-202259\/299848", "a873d1fdc3254d738c35347aa04fda37" ] }, { "_index": "stage2_product_1726559133", "_id": "f5cb179ec0a346c39e5b248ce5023373", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "f5cb179ec0a346c39e5b248ce5023373", "autoIncrement": 75793.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 1, "productNumber": "10030156", "ean": null, "displayGroup": "b2c9e39364861b7a24e06fa004bfc4c9", "sales": 0, "stock": 1, "weight": 0.2, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "85162abcb8ca413fa62992603cb976be", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:38:18+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "85162abcb8ca413fa62992603cb976be", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } }, { "id": "880dd8a94ff749d7af52d78c700ccaa4", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "33f805fbdd81401d8058a5c3f10e05d1", "880dd8a94ff749d7af52d78c700ccaa4" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 1.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-29368", "25395a9610c74c1d88408f0cecb48e2a": "F-29368" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "F-29368", "F 29368", "F.29368", "F29368", "F- 29368", "F--29368", "F-.29368", "F 29368", "F. 29368", "INA", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "F-29368", "F 29368", "F.29368", "F29368", "F- 29368", "F--29368", "F-.29368", "F 29368", "F. 29368", "INA", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10030156", "f-29368" ] }, "fields": { "displayGroup": [ "b2c9e39364861b7a24e06fa004bfc4c9" ] }, "sort": [ "f-29368", "f5cb179ec0a346c39e5b248ce5023373" ] }, { "_index": "stage2_product_1726559133", "_id": "9c34423940914df0bab3a90cfdcb4554", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "9c34423940914df0bab3a90cfdcb4554", "autoIncrement": 75794.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 11, "productNumber": "10030157", "ean": null, "displayGroup": "36d605c32e88f0bda4600683b1b6e4f3", "sales": 0, "stock": 11, "weight": 0.3, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "85162abcb8ca413fa62992603cb976be", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:38:18+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "85162abcb8ca413fa62992603cb976be", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } }, { "id": "880dd8a94ff749d7af52d78c700ccaa4", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "33f805fbdd81401d8058a5c3f10e05d1", "880dd8a94ff749d7af52d78c700ccaa4" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 11.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-35114", "25395a9610c74c1d88408f0cecb48e2a": "F-35114" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "F-35114", "F 35114", "F.35114", "F35114", "F- 35114", "F--35114", "F-.35114", "F 35114", "F. 35114", "INA", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "F-35114", "F 35114", "F.35114", "F35114", "F- 35114", "F--35114", "F-.35114", "F 35114", "F. 35114", "INA", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10030157", "f-35114" ] }, "fields": { "displayGroup": [ "36d605c32e88f0bda4600683b1b6e4f3" ] }, "sort": [ "f-35114", "9c34423940914df0bab3a90cfdcb4554" ] }, { "_index": "stage2_product_1726559133", "_id": "2af2eca726094dbd83958f88e5f0a033", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "2af2eca726094dbd83958f88e5f0a033", "autoIncrement": 75795.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 2, "productNumber": "10030158", "ean": null, "displayGroup": "dfb0a650a6759729e1a93e6219508a07", "sales": 0, "stock": 2, "weight": 0.3, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "85162abcb8ca413fa62992603cb976be", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:38:19+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "85162abcb8ca413fa62992603cb976be", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } }, { "id": "880dd8a94ff749d7af52d78c700ccaa4", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "33f805fbdd81401d8058a5c3f10e05d1", "880dd8a94ff749d7af52d78c700ccaa4" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 2.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-83161", "25395a9610c74c1d88408f0cecb48e2a": "F-83161" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "F-83161", "F 83161", "F.83161", "F83161", "F- 83161", "F--83161", "F-.83161", "F 83161", "F. 83161", "INA", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "F-83161", "F 83161", "F.83161", "F83161", "F- 83161", "F--83161", "F-.83161", "F 83161", "F. 83161", "INA", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10030158", "f-83161" ] }, "fields": { "displayGroup": [ "dfb0a650a6759729e1a93e6219508a07" ] }, "sort": [ "f-83161", "2af2eca726094dbd83958f88e5f0a033" ] }, { "_index": "stage2_product_1726559133", "_id": "3b2cc8ae029d47ca845b54b5d4f65b86", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "3b2cc8ae029d47ca845b54b5d4f65b86", "autoIncrement": 75796.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 10, "productNumber": "10030159", "ean": null, "displayGroup": "f95bb8a56be9841288ed01066407aad3", "sales": 0, "stock": 10, "weight": 0.3, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "85162abcb8ca413fa62992603cb976be", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2022-11-17T22:38:19+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "85162abcb8ca413fa62992603cb976be", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } }, { "id": "880dd8a94ff749d7af52d78c700ccaa4", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "33f805fbdd81401d8058a5c3f10e05d1", "880dd8a94ff749d7af52d78c700ccaa4" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84828000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 10.0 }, "25395a9610c74c1d88408f0cecb48e2a": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-95247", "25395a9610c74c1d88408f0cecb48e2a": "F-95247" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "F-95247", "F 95247", "F.95247", "F95247", "F- 95247", "F--95247", "F-.95247", "F 95247", "F. 95247", "INA", "Special drawing part" ], "25395a9610c74c1d88408f0cecb48e2a": [ "F-95247", "F 95247", "F.95247", "F95247", "F- 95247", "F--95247", "F-.95247", "F 95247", "F. 95247", "INA", "Special drawing part" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10030159", "f-95247" ] }, "fields": { "displayGroup": [ "f95bb8a56be9841288ed01066407aad3" ] }, "sort": [ "f-95247", "3b2cc8ae029d47ca845b54b5d4f65b86" ] }, { "_index": "stage2_product_1726559133", "_id": "97db7600ccd84edf997b69b9d47d5d1a", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "97db7600ccd84edf997b69b9d47d5d1a", "autoIncrement": 87176.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 3, "productNumber": "10066885", "ean": "7316570207194", "displayGroup": "ec579dca809107b217d68d398a6b62ec", "sales": 3, "stock": 3, "weight": 0.371, "width": 19.0, "length": 30.0, "height": 72.0, "manufacturerId": "53fbc2d059f4462d917dcf7e18f55ebe", "manufacturerNumber": "7316570207194", "releaseDate": null, "createdAt": "2023-09-03T21:53:37+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "53fbc2d059f4462d917dcf7e18f55ebe", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKF" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "2ceb0cba8e4e403e8a1b89287978bb8a", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "2ceb0cba8e4e403e8a1b89287978bb8a", "33f805fbdd81401d8058a5c3f10e05d1" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84825000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 13.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NJ 306 ECJ", "25395a9610c74c1d88408f0cecb48e2a": "NJ 306 ECJ" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Einreihiges Zylinderrollenlager", "25395a9610c74c1d88408f0cecb48e2a": "Cylindrical roller bearings" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "NJ 306 ECJ", "NJ-306-ECJ", "NJ.306.ECJ", "NJ306ECJ", "Einreihiges Zylinderrollenlager", "SKF", "Cylindrical roller bearings" ], "25395a9610c74c1d88408f0cecb48e2a": [ "NJ 306 ECJ", "NJ-306-ECJ", "NJ.306.ECJ", "NJ306ECJ", "Einreihiges Zylinderrollenlager", "SKF", "Cylindrical roller bearings" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 289.8483, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 243.57, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10066885", "7316570207194", "306", "ecj", "nj 306 ecj" ] }, "fields": { "displayGroup": [ "ec579dca809107b217d68d398a6b62ec" ] }, "sort": [ "nj 306 ecj", "97db7600ccd84edf997b69b9d47d5d1a" ] }, { "_index": "stage2_product_1726559133", "_id": "d6d62168cce44b2c8f31c77cbb595a89", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": "1.000", "purchaseUnit": "1.0000", "unit": { "id": "2e36b281cbe94d1ab3c5f1b9b6318512", "name": { "25395a9610c74c1d88408f0cecb48e2a": "A", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A" }, "shortCode": { "25395a9610c74c1d88408f0cecb48e2a": "Pro 1", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1" }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP", "25395a9610c74c1d88408f0cecb48e2a": null }, "id": "d6d62168cce44b2c8f31c77cbb595a89", "autoIncrement": 89477.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3" }, { "_count": 1, "visibility": 30, "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } ], "availableStock": 2, "productNumber": "10067533", "ean": "7316570531077", "displayGroup": "6a3c28e6ccf89e0eaf32a6d3dfc057e0", "sales": 0, "stock": 2, "weight": 4.673, "width": 41.0, "length": 85.0, "height": 180.0, "manufacturerId": "53fbc2d059f4462d917dcf7e18f55ebe", "manufacturerNumber": "7316570531077", "releaseDate": null, "createdAt": "2023-12-07T01:52:39+00:00", "categoryTree": [ "40e4ef9fa7fe4556bd78223ad7b7e6a5", "ea8e913e7da94c08981968ffd11cdef0", "8e91374233dd4e22944dc6ca7496853b", "dd5f5bfa75234389ab74337159e437c6" ], "categoriesRo": [ { "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "_count": 1 }, { "id": "ea8e913e7da94c08981968ffd11cdef0", "_count": 1 }, { "id": "8e91374233dd4e22944dc6ca7496853b", "_count": 1 }, { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1 } ], "taxId": "3c8ac16c569743c28b8c384211844ab1", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "dd5f5bfa75234389ab74337159e437c6", "_count": 1, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile" } } ], "manufacturer": { "id": "53fbc2d059f4462d917dcf7e18f55ebe", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKF" }, "_count": 1 }, "properties": [ { "id": "0a8d837c8fc0491d9da7e44fd3ec89a3", "_count": 1, "groupId": "0c919a63bc974f90812727e15b3d0882", "group": { "id": "0c919a63bc974f90812727e15b3d0882", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar" } }, { "id": "2ceb0cba8e4e403e8a1b89287978bb8a", "_count": 1, "groupId": "295824a0060c4413948cc507b2d4e541", "group": { "id": "295824a0060c4413948cc507b2d4e541", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP" } }, { "id": "33f805fbdd81401d8058a5c3f10e05d1", "_count": 1, "groupId": "93e24712eea04e0392222313893d4a10", "group": { "id": "93e24712eea04e0392222313893d4a10", "_count": 1 }, "name": { "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen" } } ], "options": [], "categoryIds": [ "dd5f5bfa75234389ab74337159e437c6" ], "optionIds": [], "propertyIds": [ "0a8d837c8fc0491d9da7e44fd3ec89a3", "2ceb0cba8e4e403e8a1b89287978bb8a", "33f805fbdd81401d8058a5c3f10e05d1" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_egate_hsCode": "84825000", "custom_egate_packCnt": 1.0, "custom_egate_stockCntMin": 2.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NJ 317 ECP\/C3", "25395a9610c74c1d88408f0cecb48e2a": "NJ 317 ECP\/C3" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Einreihiges Zylinderrollenlager", "25395a9610c74c1d88408f0cecb48e2a": "Cylindrical roller bearings" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "25395a9610c74c1d88408f0cecb48e2a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "NJ 317 ECP C3", "NJ-317-ECP-C3", "NJ.317.ECP.C3", "NJ317ECPC3", "Einreihiges Zylinderrollenlager", "SKF", "Cylindrical roller bearings" ], "25395a9610c74c1d88408f0cecb48e2a": [ "NJ 317 ECP C3", "NJ-317-ECP-C3", "NJ.317.ECP.C3", "NJ317ECPC3", "Einreihiges Zylinderrollenlager", "SKF", "Cylindrical roller bearings" ] }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 945.8477, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 794.83, "streamCategories": [ { "id": "2c864cff3f8b48d9bb524e8350bbeefb" } ], "swagDynamicAccessRules": [ { "id": null, "_count": 1 } ], "parent": { "swagDynamicAccessRules": [ { "id": null, "_count": 1 } ] }, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "10067533", "7316570531077", "317", "ecp\/c3", "nj 317 ecp\/c3" ] }, "fields": { "displayGroup": [ "6a3c28e6ccf89e0eaf32a6d3dfc057e0" ] }, "sort": [ "nj 317 ecp\/c3", "d6d62168cce44b2c8f31c77cbb595a89" ] } ] }, "aggregations": { "total-count": { "value": 9 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	4.52 ms	Request: {"index":"stage2_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"dd5f5bfa75234389ab74337159e437c6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule6b046b97e2c24135a7578de54954c286_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule97ee4ade75bd4b26808c00f4c861d1b9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulecf9863d210ef4c33b0b13ed3416d4682_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec2362338eaec42239815ae21a6b60183_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule18f6bab70131475a860ca2fa4284875f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule979a59207cd04303a88ac3b100249954_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruleb585c17a68fd492bbb0507497e5f9b32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"tdxcats":{"nested":{"path":"categoriesRo"},"aggregations":{"tdxcats":{"terms":{"field":"categoriesRo.id","size":10000}}}},"length":{"stats":{"field":"length"}},"width":{"stats":{"field":"width"}},"height":{"stats":{"field":"height"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://localhost:9202/stage2_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "dd5f5bfa75234389ab74337159e437c6" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule6b046b97e2c24135a7578de54954c286_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule97ee4ade75bd4b26808c00f4c861d1b9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulecf9863d210ef4c33b0b13ed3416d4682_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rulec2362338eaec42239815ae21a6b60183_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule18f6bab70131475a860ca2fa4284875f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule979a59207cd04303a88ac3b100249954_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruleb585c17a68fd492bbb0507497e5f9b32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } }, "tdxcats": { "nested": { "path": "categoriesRo" }, "aggregations": { "tdxcats": { "terms": { "field": "categoriesRo.id", "size": 10000 } } } }, "length": { "stats": { "field": "length" } }, "width": { "stats": { "field": "width" } }, "height": { "stats": { "field": "height" } } }, "size": 0, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "tdxcats": { "doc_count": 36, "tdxcats": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "40e4ef9fa7fe4556bd78223ad7b7e6a5", "doc_count": 9 }, { "key": "8e91374233dd4e22944dc6ca7496853b", "doc_count": 9 }, { "key": "dd5f5bfa75234389ab74337159e437c6", "doc_count": 9 }, { "key": "ea8e913e7da94c08981968ffd11cdef0", "doc_count": 9 } ] } }, "price": { "count": 9, "min": 0.0, "max": 794.83, "avg": 115.3777777777778, "sum": 1038.4 }, "width": { "count": 9, "min": 0.0, "max": 41.0, "avg": 6.666666666666667, "sum": 60.0 }, "length": { "count": 9, "min": 0.0, "max": 85.0, "avg": 12.777777777777779, "sum": 115.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 26, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0a8d837c8fc0491d9da7e44fd3ec89a3", "doc_count": 9 }, { "key": "33f805fbdd81401d8058a5c3f10e05d1", "doc_count": 8 }, { "key": "880dd8a94ff749d7af52d78c700ccaa4", "doc_count": 5 }, { "key": "2ceb0cba8e4e403e8a1b89287978bb8a", "doc_count": 4 } ] } }, "height": { "count": 9, "min": 0.0, "max": 180.0, "avg": 28.0, "sum": 252.0 }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "85162abcb8ca413fa62992603cb976be", "doc_count": 5 }, { "key": "53fbc2d059f4462d917dcf7e18f55ebe", "doc_count": 2 }, { "key": "31ce1fa6506d4c2ea156ce69b79f3ce4", "doc_count": 1 }, { "key": "93262af0c45e4463bcaa9dc7c4c35888", "doc_count": 1 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"stage2_product","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":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"dd5f5bfa75234389ab74337159e437c6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://localhost:9202/stage2_product/_search?track_total_hits=1&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "dd5f5bfa75234389ab74337159e437c6"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "string",
                "script": {
                    "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n",
                    "lang": "painless",
                    "params": {
                        "field": "name",
                        "languages": [
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
                        ]
                    }
                },
                "order": "ASC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 7,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 9,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "stage2_product_1726559133",
                "_id": "3ca9de6c3c074e45a6d9229109eb852c",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "3ca9de6c3c074e45a6d9229109eb852c",
                    "autoIncrement": 75736.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 4,
                    "productNumber": "10029898",
                    "ean": null,
                    "displayGroup": "f2076b6918b56dc03998616a562c00aa",
                    "sales": 0,
                    "stock": 4,
                    "weight": 2.8,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "93262af0c45e4463bcaa9dc7c4c35888",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:37:49+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "93262af0c45e4463bcaa9dc7c4c35888",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FAG"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "2ceb0cba8e4e403e8a1b89287978bb8a",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "2ceb0cba8e4e403e8a1b89287978bb8a",
                        "33f805fbdd81401d8058a5c3f10e05d1"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 4.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "543772",
                        "25395a9610c74c1d88408f0cecb48e2a": "543772"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "543772",
                            "FAG",
                            "Deep groove ball bearings"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "543772",
                            "FAG",
                            "Deep groove ball bearings"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10029898",
                        "543772"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "f2076b6918b56dc03998616a562c00aa"
                    ]
                },
                "sort": [
                    "543772",
                    "3ca9de6c3c074e45a6d9229109eb852c"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "b6815fec8f1a4a90b5ab17ba92519537",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "b6815fec8f1a4a90b5ab17ba92519537",
                    "autoIncrement": 78307.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 1,
                    "productNumber": "10038511",
                    "ean": null,
                    "displayGroup": "49fcef92bca7752ddf07f59cd075cb5c",
                    "sales": 0,
                    "stock": 1,
                    "weight": 46.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "31ce1fa6506d4c2ea156ce69b79f3ce4",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:59:41+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "81c8cab55c744e33a8d3adf5d5e94d1e",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "31ce1fa6506d4c2ea156ce69b79f3ce4",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NTR"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "2ceb0cba8e4e403e8a1b89287978bb8a",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "2ceb0cba8e4e403e8a1b89287978bb8a"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 1.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CRB L11.20.0544.031.5112A",
                        "25395a9610c74c1d88408f0cecb48e2a": "CRB L11.20.0544.031.5112A"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Drehverbindung",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "CRB L11.20.0544.031.5112A",
                            "CRB L112005440315112A",
                            "CRB-L11.20.0544.031.5112A",
                            "CRB.L11.20.0544.031.5112A",
                            "CRB L11-20-0544-031-5112A",
                            "CRB L11 20 0544 031 5112A",
                            "CRBL11.20.0544.031.5112A",
                            "CRBL112005440315112A",
                            "CRB L 11.20.0544.031.5112A",
                            "CRB L 112005440315112A",
                            "CRB-L-11.20.0544.031.5112A",
                            "CRB.L.11.20.0544.031.5112A",
                            "CRB L 11-20-0544-031-5112A",
                            "CRB L 11 20 0544 031 5112A",
                            "Drehverbindung",
                            "NEUTRAL",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "CRB L11.20.0544.031.5112A",
                            "CRB L112005440315112A",
                            "CRB-L11.20.0544.031.5112A",
                            "CRB.L11.20.0544.031.5112A",
                            "CRB L11-20-0544-031-5112A",
                            "CRB L11 20 0544 031 5112A",
                            "CRBL11.20.0544.031.5112A",
                            "CRBL112005440315112A",
                            "CRB L 11.20.0544.031.5112A",
                            "CRB L 112005440315112A",
                            "CRB-L-11.20.0544.031.5112A",
                            "CRB.L.11.20.0544.031.5112A",
                            "CRB L 11-20-0544-031-5112A",
                            "CRB L 11 20 0544 031 5112A",
                            "Drehverbindung",
                            "NEUTRAL",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "swagDynamicAccessRules": [
                        {
                            "id": null,
                            "_count": 1
                        }
                    ],
                    "parent": {
                        "swagDynamicAccessRules": [
                            {
                                "id": null,
                                "_count": 1
                            }
                        ]
                    },
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10038511",
                        "crb",
                        "l11.20.0544.031.5112a",
                        "crb l11.20.0544.031.5112a"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "49fcef92bca7752ddf07f59cd075cb5c"
                    ]
                },
                "sort": [
                    "crb l11.20.0544.031.5112a",
                    "b6815fec8f1a4a90b5ab17ba92519537"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "a873d1fdc3254d738c35347aa04fda37",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "a873d1fdc3254d738c35347aa04fda37",
                    "autoIncrement": 75792.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "10030154",
                    "ean": null,
                    "displayGroup": "c2ff49af6e0f3bc192a7f5108fbfc1ca",
                    "sales": 0,
                    "stock": 2,
                    "weight": 0.2,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "85162abcb8ca413fa62992603cb976be",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:38:17+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "85162abcb8ca413fa62992603cb976be",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        },
                        {
                            "id": "880dd8a94ff749d7af52d78c700ccaa4",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "33f805fbdd81401d8058a5c3f10e05d1",
                        "880dd8a94ff749d7af52d78c700ccaa4"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 2.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-202259\/299848",
                        "25395a9610c74c1d88408f0cecb48e2a": "F-202259\/299848"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-Lager",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "F-202259 299848",
                            "F-202259-299848",
                            "F-202259.299848",
                            "F 202259 299848",
                            "F.202259 299848",
                            "F-202259299848",
                            "F202259299848",
                            "F- 202259 299848",
                            "F--202259-299848",
                            "F-.202259.299848",
                            "F  202259 299848",
                            "F. 202259 299848",
                            "F-Lager",
                            "INA",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "F-202259 299848",
                            "F-202259-299848",
                            "F-202259.299848",
                            "F 202259 299848",
                            "F.202259 299848",
                            "F-202259299848",
                            "F202259299848",
                            "F- 202259 299848",
                            "F--202259-299848",
                            "F-.202259.299848",
                            "F  202259 299848",
                            "F. 202259 299848",
                            "F-Lager",
                            "INA",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10030154",
                        "f-202259\/299848"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c2ff49af6e0f3bc192a7f5108fbfc1ca"
                    ]
                },
                "sort": [
                    "f-202259\/299848",
                    "a873d1fdc3254d738c35347aa04fda37"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "f5cb179ec0a346c39e5b248ce5023373",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "f5cb179ec0a346c39e5b248ce5023373",
                    "autoIncrement": 75793.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 1,
                    "productNumber": "10030156",
                    "ean": null,
                    "displayGroup": "b2c9e39364861b7a24e06fa004bfc4c9",
                    "sales": 0,
                    "stock": 1,
                    "weight": 0.2,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "85162abcb8ca413fa62992603cb976be",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:38:18+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "85162abcb8ca413fa62992603cb976be",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        },
                        {
                            "id": "880dd8a94ff749d7af52d78c700ccaa4",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "33f805fbdd81401d8058a5c3f10e05d1",
                        "880dd8a94ff749d7af52d78c700ccaa4"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 1.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-29368",
                        "25395a9610c74c1d88408f0cecb48e2a": "F-29368"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "F-29368",
                            "F 29368",
                            "F.29368",
                            "F29368",
                            "F- 29368",
                            "F--29368",
                            "F-.29368",
                            "F  29368",
                            "F. 29368",
                            "INA",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "F-29368",
                            "F 29368",
                            "F.29368",
                            "F29368",
                            "F- 29368",
                            "F--29368",
                            "F-.29368",
                            "F  29368",
                            "F. 29368",
                            "INA",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10030156",
                        "f-29368"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b2c9e39364861b7a24e06fa004bfc4c9"
                    ]
                },
                "sort": [
                    "f-29368",
                    "f5cb179ec0a346c39e5b248ce5023373"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "9c34423940914df0bab3a90cfdcb4554",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "9c34423940914df0bab3a90cfdcb4554",
                    "autoIncrement": 75794.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 11,
                    "productNumber": "10030157",
                    "ean": null,
                    "displayGroup": "36d605c32e88f0bda4600683b1b6e4f3",
                    "sales": 0,
                    "stock": 11,
                    "weight": 0.3,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "85162abcb8ca413fa62992603cb976be",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:38:18+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "85162abcb8ca413fa62992603cb976be",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        },
                        {
                            "id": "880dd8a94ff749d7af52d78c700ccaa4",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "33f805fbdd81401d8058a5c3f10e05d1",
                        "880dd8a94ff749d7af52d78c700ccaa4"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 11.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-35114",
                        "25395a9610c74c1d88408f0cecb48e2a": "F-35114"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "F-35114",
                            "F 35114",
                            "F.35114",
                            "F35114",
                            "F- 35114",
                            "F--35114",
                            "F-.35114",
                            "F  35114",
                            "F. 35114",
                            "INA",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "F-35114",
                            "F 35114",
                            "F.35114",
                            "F35114",
                            "F- 35114",
                            "F--35114",
                            "F-.35114",
                            "F  35114",
                            "F. 35114",
                            "INA",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10030157",
                        "f-35114"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "36d605c32e88f0bda4600683b1b6e4f3"
                    ]
                },
                "sort": [
                    "f-35114",
                    "9c34423940914df0bab3a90cfdcb4554"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "2af2eca726094dbd83958f88e5f0a033",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "2af2eca726094dbd83958f88e5f0a033",
                    "autoIncrement": 75795.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "10030158",
                    "ean": null,
                    "displayGroup": "dfb0a650a6759729e1a93e6219508a07",
                    "sales": 0,
                    "stock": 2,
                    "weight": 0.3,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "85162abcb8ca413fa62992603cb976be",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:38:19+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "85162abcb8ca413fa62992603cb976be",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        },
                        {
                            "id": "880dd8a94ff749d7af52d78c700ccaa4",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "33f805fbdd81401d8058a5c3f10e05d1",
                        "880dd8a94ff749d7af52d78c700ccaa4"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 2.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-83161",
                        "25395a9610c74c1d88408f0cecb48e2a": "F-83161"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "F-83161",
                            "F 83161",
                            "F.83161",
                            "F83161",
                            "F- 83161",
                            "F--83161",
                            "F-.83161",
                            "F  83161",
                            "F. 83161",
                            "INA",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "F-83161",
                            "F 83161",
                            "F.83161",
                            "F83161",
                            "F- 83161",
                            "F--83161",
                            "F-.83161",
                            "F  83161",
                            "F. 83161",
                            "INA",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10030158",
                        "f-83161"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "dfb0a650a6759729e1a93e6219508a07"
                    ]
                },
                "sort": [
                    "f-83161",
                    "2af2eca726094dbd83958f88e5f0a033"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "3b2cc8ae029d47ca845b54b5d4f65b86",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "3b2cc8ae029d47ca845b54b5d4f65b86",
                    "autoIncrement": 75796.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "10030159",
                    "ean": null,
                    "displayGroup": "f95bb8a56be9841288ed01066407aad3",
                    "sales": 0,
                    "stock": 10,
                    "weight": 0.3,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "85162abcb8ca413fa62992603cb976be",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2022-11-17T22:38:19+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "85162abcb8ca413fa62992603cb976be",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "INA"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        },
                        {
                            "id": "880dd8a94ff749d7af52d78c700ccaa4",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IVP"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "33f805fbdd81401d8058a5c3f10e05d1",
                        "880dd8a94ff749d7af52d78c700ccaa4"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84828000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 10.0
                        },
                        "25395a9610c74c1d88408f0cecb48e2a": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F-95247",
                        "25395a9610c74c1d88408f0cecb48e2a": "F-95247"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "F-95247",
                            "F 95247",
                            "F.95247",
                            "F95247",
                            "F- 95247",
                            "F--95247",
                            "F-.95247",
                            "F  95247",
                            "F. 95247",
                            "INA",
                            "Special drawing part"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "F-95247",
                            "F 95247",
                            "F.95247",
                            "F95247",
                            "F- 95247",
                            "F--95247",
                            "F-.95247",
                            "F  95247",
                            "F. 95247",
                            "INA",
                            "Special drawing part"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10030159",
                        "f-95247"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "f95bb8a56be9841288ed01066407aad3"
                    ]
                },
                "sort": [
                    "f-95247",
                    "3b2cc8ae029d47ca845b54b5d4f65b86"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "97db7600ccd84edf997b69b9d47d5d1a",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "97db7600ccd84edf997b69b9d47d5d1a",
                    "autoIncrement": 87176.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 3,
                    "productNumber": "10066885",
                    "ean": "7316570207194",
                    "displayGroup": "ec579dca809107b217d68d398a6b62ec",
                    "sales": 3,
                    "stock": 3,
                    "weight": 0.371,
                    "width": 19.0,
                    "length": 30.0,
                    "height": 72.0,
                    "manufacturerId": "53fbc2d059f4462d917dcf7e18f55ebe",
                    "manufacturerNumber": "7316570207194",
                    "releaseDate": null,
                    "createdAt": "2023-09-03T21:53:37+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "53fbc2d059f4462d917dcf7e18f55ebe",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKF"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "2ceb0cba8e4e403e8a1b89287978bb8a",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "2ceb0cba8e4e403e8a1b89287978bb8a",
                        "33f805fbdd81401d8058a5c3f10e05d1"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84825000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 13.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NJ 306 ECJ",
                        "25395a9610c74c1d88408f0cecb48e2a": "NJ 306 ECJ"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Einreihiges Zylinderrollenlager",
                        "25395a9610c74c1d88408f0cecb48e2a": "Cylindrical roller bearings"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "NJ 306 ECJ",
                            "NJ-306-ECJ",
                            "NJ.306.ECJ",
                            "NJ306ECJ",
                            "Einreihiges Zylinderrollenlager",
                            "SKF",
                            "Cylindrical roller bearings"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "NJ 306 ECJ",
                            "NJ-306-ECJ",
                            "NJ.306.ECJ",
                            "NJ306ECJ",
                            "Einreihiges Zylinderrollenlager",
                            "SKF",
                            "Cylindrical roller bearings"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 289.8483,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 243.57,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10066885",
                        "7316570207194",
                        "306",
                        "ecj",
                        "nj 306 ecj"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "ec579dca809107b217d68d398a6b62ec"
                    ]
                },
                "sort": [
                    "nj 306 ecj",
                    "97db7600ccd84edf997b69b9d47d5d1a"
                ]
            },
            {
                "_index": "stage2_product_1726559133",
                "_id": "d6d62168cce44b2c8f31c77cbb595a89",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": "1.000",
                    "purchaseUnit": "1.0000",
                    "unit": {
                        "id": "2e36b281cbe94d1ab3c5f1b9b6318512",
                        "name": {
                            "25395a9610c74c1d88408f0cecb48e2a": "A",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A"
                        },
                        "shortCode": {
                            "25395a9610c74c1d88408f0cecb48e2a": "Pro 1",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pro 1"
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP",
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "id": "d6d62168cce44b2c8f31c77cbb595a89",
                    "autoIncrement": 89477.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "25c9dffc2e5647d6aac8414080bc75b3"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "10067533",
                    "ean": "7316570531077",
                    "displayGroup": "6a3c28e6ccf89e0eaf32a6d3dfc057e0",
                    "sales": 0,
                    "stock": 2,
                    "weight": 4.673,
                    "width": 41.0,
                    "length": 85.0,
                    "height": 180.0,
                    "manufacturerId": "53fbc2d059f4462d917dcf7e18f55ebe",
                    "manufacturerNumber": "7316570531077",
                    "releaseDate": null,
                    "createdAt": "2023-12-07T01:52:39+00:00",
                    "categoryTree": [
                        "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "ea8e913e7da94c08981968ffd11cdef0",
                        "8e91374233dd4e22944dc6ca7496853b",
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                            "_count": 1
                        },
                        {
                            "id": "ea8e913e7da94c08981968ffd11cdef0",
                            "_count": 1
                        },
                        {
                            "id": "8e91374233dd4e22944dc6ca7496853b",
                            "_count": 1
                        },
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1
                        }
                    ],
                    "taxId": "3c8ac16c569743c28b8c384211844ab1",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "dd5f5bfa75234389ab74337159e437c6",
                            "_count": 1,
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Special drawing parts",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zeichnungssonderteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "53fbc2d059f4462d917dcf7e18f55ebe",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKF"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                            "_count": 1,
                            "groupId": "0c919a63bc974f90812727e15b3d0882",
                            "group": {
                                "id": "0c919a63bc974f90812727e15b3d0882",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sofort verf\u00fcgbar"
                            }
                        },
                        {
                            "id": "2ceb0cba8e4e403e8a1b89287978bb8a",
                            "_count": 1,
                            "groupId": "295824a0060c4413948cc507b2d4e541",
                            "group": {
                                "id": "295824a0060c4413948cc507b2d4e541",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EVP"
                            }
                        },
                        {
                            "id": "33f805fbdd81401d8058a5c3f10e05d1",
                            "_count": 1,
                            "groupId": "93e24712eea04e0392222313893d4a10",
                            "group": {
                                "id": "93e24712eea04e0392222313893d4a10",
                                "_count": 1
                            },
                            "name": {
                                "25395a9610c74c1d88408f0cecb48e2a": "Show only Supreme products",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nur Supreme Produkte anzeigen"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "dd5f5bfa75234389ab74337159e437c6"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "2ceb0cba8e4e403e8a1b89287978bb8a",
                        "33f805fbdd81401d8058a5c3f10e05d1"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_egate_hsCode": "84825000",
                            "custom_egate_packCnt": 1.0,
                            "custom_egate_stockCntMin": 2.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NJ 317 ECP\/C3",
                        "25395a9610c74c1d88408f0cecb48e2a": "NJ 317 ECP\/C3"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Einreihiges Zylinderrollenlager",
                        "25395a9610c74c1d88408f0cecb48e2a": "Cylindrical roller bearings"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "25395a9610c74c1d88408f0cecb48e2a": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "NJ 317 ECP C3",
                            "NJ-317-ECP-C3",
                            "NJ.317.ECP.C3",
                            "NJ317ECPC3",
                            "Einreihiges Zylinderrollenlager",
                            "SKF",
                            "Cylindrical roller bearings"
                        ],
                        "25395a9610c74c1d88408f0cecb48e2a": [
                            "NJ 317 ECP C3",
                            "NJ-317-ECP-C3",
                            "NJ.317.ECP.C3",
                            "NJ317ECPC3",
                            "Einreihiges Zylinderrollenlager",
                            "SKF",
                            "Cylindrical roller bearings"
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 945.8477,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 794.83,
                    "streamCategories": [
                        {
                            "id": "2c864cff3f8b48d9bb524e8350bbeefb"
                        }
                    ],
                    "swagDynamicAccessRules": [
                        {
                            "id": null,
                            "_count": 1
                        }
                    ],
                    "parent": {
                        "swagDynamicAccessRules": [
                            {
                                "id": null,
                                "_count": 1
                            }
                        ]
                    },
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "10067533",
                        "7316570531077",
                        "317",
                        "ecp\/c3",
                        "nj 317 ecp\/c3"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "6a3c28e6ccf89e0eaf32a6d3dfc057e0"
                    ]
                },
                "sort": [
                    "nj 317 ecp\/c3",
                    "d6d62168cce44b2c8f31c77cbb595a89"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 9
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

4.52 ms

Request:

{"index":"stage2_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bfed4ac5fd564ff89843590cdf498c1c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"dd5f5bfa75234389ab74337159e437c6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule6b046b97e2c24135a7578de54954c286_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule97ee4ade75bd4b26808c00f4c861d1b9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulecf9863d210ef4c33b0b13ed3416d4682_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec2362338eaec42239815ae21a6b60183_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule18f6bab70131475a860ca2fa4284875f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule979a59207cd04303a88ac3b100249954_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruleb585c17a68fd492bbb0507497e5f9b32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"tdxcats":{"nested":{"path":"categoriesRo"},"aggregations":{"tdxcats":{"terms":{"field":"categoriesRo.id","size":10000}}}},"length":{"stats":{"field":"length"}},"width":{"stats":{"field":"width"}},"height":{"stats":{"field":"height"}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://localhost:9202/stage2_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "bfed4ac5fd564ff89843590cdf498c1c"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "dd5f5bfa75234389ab74337159e437c6"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule6b046b97e2c24135a7578de54954c286_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule97ee4ade75bd4b26808c00f4c861d1b9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulecf9863d210ef4c33b0b13ed3416d4682_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulec2362338eaec42239815ae21a6b60183_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule18f6bab70131475a860ca2fa4284875f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule979a59207cd04303a88ac3b100249954_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruleb585c17a68fd492bbb0507497e5f9b32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                }
            }
        },
        "properties": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    }
                }
            }
        },
        "tdxcats": {
            "nested": {
                "path": "categoriesRo"
            },
            "aggregations": {
                "tdxcats": {
                    "terms": {
                        "field": "categoriesRo.id",
                        "size": 10000
                    }
                }
            }
        },
        "length": {
            "stats": {
                "field": "length"
            }
        },
        "width": {
            "stats": {
                "field": "width"
            }
        },
        "height": {
            "stats": {
                "field": "height"
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "tdxcats": {
            "doc_count": 36,
            "tdxcats": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "40e4ef9fa7fe4556bd78223ad7b7e6a5",
                        "doc_count": 9
                    },
                    {
                        "key": "8e91374233dd4e22944dc6ca7496853b",
                        "doc_count": 9
                    },
                    {
                        "key": "dd5f5bfa75234389ab74337159e437c6",
                        "doc_count": 9
                    },
                    {
                        "key": "ea8e913e7da94c08981968ffd11cdef0",
                        "doc_count": 9
                    }
                ]
            }
        },
        "price": {
            "count": 9,
            "min": 0.0,
            "max": 794.83,
            "avg": 115.3777777777778,
            "sum": 1038.4
        },
        "width": {
            "count": 9,
            "min": 0.0,
            "max": 41.0,
            "avg": 6.666666666666667,
            "sum": 60.0
        },
        "length": {
            "count": 9,
            "min": 0.0,
            "max": 85.0,
            "avg": 12.777777777777779,
            "sum": 115.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 26,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "0a8d837c8fc0491d9da7e44fd3ec89a3",
                        "doc_count": 9
                    },
                    {
                        "key": "33f805fbdd81401d8058a5c3f10e05d1",
                        "doc_count": 8
                    },
                    {
                        "key": "880dd8a94ff749d7af52d78c700ccaa4",
                        "doc_count": 5
                    },
                    {
                        "key": "2ceb0cba8e4e403e8a1b89287978bb8a",
                        "doc_count": 4
                    }
                ]
            }
        },
        "height": {
            "count": 9,
            "min": 0.0,
            "max": 180.0,
            "avg": 28.0,
            "sum": 252.0
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "85162abcb8ca413fa62992603cb976be",
                    "doc_count": 5
                },
                {
                    "key": "53fbc2d059f4462d917dcf7e18f55ebe",
                    "doc_count": 2
                },
                {
                    "key": "31ce1fa6506d4c2ea156ce69b79f3ce4",
                    "doc_count": 1
                },
                {
                    "key": "93262af0c45e4463bcaa9dc7c4c35888",
                    "doc_count": 1
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "opensearch-cluster",
    "status": "green",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 68,
    "active_shards": 68,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_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": 100.0
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
.ql-datasources	open	1, 0	0
stage2_category_1723549257	open	3, 0	656
stage3_category_1738934394	open	3, 0	1232
stage2_category_1726559133	open	3, 0	643
stage3_product_manufacturer_1738934394	open	3, 0	247
stage3_product_manufacturer_1738934152	open	3, 0	231
.opensearch-observability	open	1, 0	0
stage3_product_1738934394	open	3, 0	553563
stage3_product_1738934152	open	3, 0	489632
stage3_category_1738934152	open	3, 0	656
walive_product_1738934814	open	3, 0	553464
stage2_category_1726562259	open	3, 0	656
stage2_category_1726562116	open	3, 0	656
.kibana_1	open	1, 0	4
stage2_product_manufacturer_1726562259	open	3, 0	220
stage2_product_manufacturer_1726562116	open	3, 0	220
walive_category_1738934814	open	3, 0	688
.plugins-ml-config	open	1, 0	1
stage2_product_manufacturer_1723549257	open	3, 0	220
stage2_product_manufacturer_1726559133	open	3, 0	241
stage2_product_1723549257	open	3, 0	440859
stage2_product_1726562259	open	3, 0	448601
stage2_product_1726562116	open	3, 0	448601
stage2_product_1726559133	open	3, 0	508306
walive_product_manufacturer_1738934814	open	3, 0	242

Symfony Profiler

GET https://wagmbh-test-stage2.revier-shopware.de/navigation/dd5f5bfa75234389ab74337159e437c6

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices