| 1 |
18.48 ms |
Request:
{"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"5670e5c42654de8411142cc18d3fb5cf"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"should":[{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea07ad57e59841906b9dac1ae23"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018f0ea3242c77a3ad7aaa686586f79c"]}}}}]}},"boost":150.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["018fe3229d5677949c032d1a4983f006"]}}}}]}},"boost":350.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["f4e67c126b4e4b4f8b4f4b8295613b5b"]}}}}]}},"boost":1000.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["15706c7290284128acdcdc0aa07bda52"]}}}}]}},"boost":400.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["a33aa3f47e2147c9be62a08216f92c1c"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["e3d0223b8cfd4edb8b5581ae7e9ab5cf"]}}}}]}},"boost":300.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["62000891305f4ae4837e16e336cf2868"]}}}}]}},"boost":200.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["9222eeebbd984a1fbba6521d6c03bc43"]}}}}]}},"boost":250.0}},{"constant_score":{"filter":{"bool":{"should":[{"nested":{"path":"streams","query":{"terms":{"streams.id":["cb292e1aaf854891a0d4e2fca32dd02f"]}}}}]}},"boost":100.0}}]}},"sort":[{"customFields.acris_search_sorting_relevance":{"unmapped_type":"integer","missing":0,"order":"DESC"}},{"_score":{"order":"DESC"}},{"markAsTopseller":{"order":"DESC"}},{"autoIncrement":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
"_id": "dd32268ba8bc0cfdfe24b3603776842d",
"_score": 1100.0,
"_source": {
"id": "dd32268ba8bc0cfdfe24b3603776842d",
"name": "Klemmbalken - Durchm. 38 mm - Verstellbereich 2350-2720 mm - mit 450 mm langer Zahnstange",
"description": "Klemmbalken \u2219 Zum Sichern des Ladegutes durch horziontale oder vertikale Anbringung \u2219 Ausziehbares, hochfestes Aluminiumrohr \u2219 Nut-Zahnstange \u2219 Beidseitig mit rutschfesten Gummif\u00fc\u00dfen",
"metaTitle": "Klemmbalken",
"metaDescription": "Klemmbalken Durchm. 38 mm Verstellbereich 2350-2720 mm mit 450 mm langer Zahnstange ",
"customSearchKeywords": [
""
],
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"customFields": {
"custom_eis_skus_sku1": "E837932G",
"custom_eis_skus_sku4": "E837932B",
"custom_topartikel_position": 0.0,
"custom_topartikel_kategorie": false,
"acris_search_sorting_relevance": 0,
"custom_customer_group_discount_exclude": false,
"acris_price_on_request_additional_field": false
},
"visibilities": [
{
"visibility": "30",
"salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
"_count": 1
}
],
"availableStock": 0,
"productNumber": "E837932-BS",
"ean": "4031639154822",
"displayGroup": "8520256196cd08cc43b31f51dfb230d4",
"sales": 0,
"stock": 0,
"manufacturerId": "8c03414628006e25df4a86ac5e61b9ba",
"manufacturerNumber": "72503-BASIC",
"manufacturer": {
"id": "8c03414628006e25df4a86ac5e61b9ba",
"name": "BRAUn",
"_count": 1
},
"releaseDate": null,
"createdAt": "2024-07-24T11:55:17+00:00",
"optionIds": [],
"options": [],
"categories": [
{
"id": "5670e5c42654de8411142cc18d3fb5cf",
"name": "Klemmbretter\/Klemmbalken"
}
],
"categoriesRo": [
{
"id": "b283b270431e4a1285d331e63d0e6202",
"_count": 1
},
{
"id": "ed73dec91e641fe53ece1391575c6d00",
"_count": 1
},
{
"id": "82d3136deee0a87fed0699f93a60dd54",
"_count": 1
},
{
"id": "5670e5c42654de8411142cc18d3fb5cf",
"_count": 1
}
],
"categoryIds": [
"5670e5c42654de8411142cc18d3fb5cf"
],
"categoryTree": [
"b283b270431e4a1285d331e63d0e6202",
"ed73dec91e641fe53ece1391575c6d00",
"82d3136deee0a87fed0699f93a60dd54",
"5670e5c42654de8411142cc18d3fb5cf"
],
"properties": [],
"propertyIds": [],
"taxId": "937f7203705d4d7c8202d8e85be59232",
"tags": [],
"tagIds": [],
"parentId": null,
"coverId": "a3fdbf633c28ec66553007e0b9923915",
"childCount": 0,
"states": [
"is-physical"
],
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 148.75,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 125.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
"bergerDownloads": [],
"bergerBadges": [],
"attributes": {
"eclass120": {
"attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
"type": "StringField",
"value": "20420290",
"label": "eClass 12.0"
},
"artikelMargeProzent": {
"attributeId": "38e4c7e297af9f3dc3db3a866da09604",
"type": "FloatField",
"value": 43.93,
"label": "Artikel Marge",
"unit": "%"
},
"herstellerOriginal": {
"attributeId": "61bbdf2bca0073f4404f2740d00add2c",
"type": "StringField",
"value": "Braun Seile",
"label": "Hersteller Original"
},
"eclass51": {
"attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
"type": "StringField",
"value": "20420290",
"label": "eClass 5.1"
},
"einstandspreisEis": {
"attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
"type": "StringField",
"value": "70.09",
"label": "Einstandspreis EIS"
},
"nameBullet3": {
"attributeId": "f99486ad04f7a1dbe4e6057eb7f1efda",
"type": "StringField",
"value": "mit 450 mm langer Zahnstange",
"label": "LABEL_MISSING"
},
"typModel": {
"attributeId": "59c6c7d9678c652ba957d0e829c20200",
"type": "StringField",
"value": "Klemmbretter",
"label": "Typ\/Modell"
},
"eisKatalogUrl": {
"attributeId": "0581c0c06d61e1784605ae623dcf3938",
"type": "StringField",
"value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=596",
"label": "Katalog Link"
},
"eclass101": {
"attributeId": "707fa7400989ef43255668a095490309",
"type": "StringField",
"value": "20420290",
"label": "eClass 10.1"
},
"artikelMargeEuroEUR": {
"attributeId": "467fd043cc3272e0ef48046f37fefff7",
"type": "FloatField",
"value": 54.91,
"label": "Artikel Marge",
"unit": "\u20ac"
},
"eclass81": {
"attributeId": "635cb161fc196c46a8d7104a3a101a02",
"type": "StringField",
"value": "20420290",
"label": "eClass 8.1"
},
"eclass111": {
"attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
"type": "StringField",
"value": "20420290",
"label": "eClass 11.1"
},
"nameBullet2": {
"attributeId": "38160a50dcd4be0db5d1913984845ec1",
"type": "StringField",
"value": "Verstellbereich 2350-2720 mm",
"label": "LABEL_MISSING"
},
"bestEinheit": {
"attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
"type": "StringField",
"value": "St\u00fcck",
"label": "Bestelleinheit"
},
"lieferzeit": {
"attributeId": "2286c50ec12650c51f8046b81d08fec9",
"type": "IntField",
"value": 5,
"label": "Lieferzeit",
"unit": "Tage"
},
"verstellbereich": {
"attributeId": "ab2afaf358e9a29e2e126215b8cc64d0",
"type": "StringField",
"value": "2360-2740 mm",
"label": "Verstellbereich"
},
"eclass130": {
"attributeId": "5d58ac61bcad814882bb94cafd70e261",
"type": "StringField",
"value": "20420290",
"label": "eClass 13.0"
},
"eclass71": {
"attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
"type": "StringField",
"value": "20420290",
"label": "eClass 7.1"
},
"eclass140": {
"attributeId": "249eaf721c50994e2b555d43e0aab090",
"type": "StringField",
"value": "20420290",
"label": "eClass 14.0"
},
"nameShort": {
"attributeId": "f8c2af32acdac443727a6dadc5917437",
"type": "StringField",
"value": "Klemmbalken",
"label": "LABEL_MISSING"
},
"verpackungseinheit": {
"attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
"type": "IntField",
"value": 1,
"label": "VPE",
"unit": "Stk"
},
"nameBullet1": {
"attributeId": "197477e550bad420764a27e99f7ff55b",
"type": "StringField",
"value": "Durchm. 38 mm",
"label": "LABEL_MISSING"
},
"eclass91": {
"attributeId": "c7bd39282c5ff77e43704b92e387af62",
"type": "StringField",
"value": "20420290",
"label": "eClass 9.1"
}
},
"attribute_eclass120": "20420290",
"attribute_artikelMargeProzent": 43.93,
"attribute_herstellerOriginal": "Braun Seile",
"attribute_eclass51": "20420290",
"attribute_einstandspreisEis": "70.09",
"attribute_nameBullet3": "mit 450 mm langer Zahnstange",
"attribute_typModel": "Klemmbretter",
"attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=596",
"attribute_eclass101": "20420290",
"attribute_artikelMargeEuroEUR": 54.91,
"attribute_eclass81": "20420290",
"attribute_eclass111": "20420290",
"attribute_nameBullet2": "Verstellbereich 2350-2720 mm",
"attribute_bestEinheit": "St\u00fcck",
"attribute_lieferzeit": 5,
"attribute_verstellbereich": "2360-2740 mm",
"attribute_eclass130": "20420290",
"attribute_eclass71": "20420290",
"attribute_eclass140": "20420290",
"attribute_nameShort": "Klemmbalken",
"attribute_verpackungseinheit": 1,
"attribute_nameBullet1": "Durchm. 38 mm",
"attribute_eclass91": "20420290",
"streams": [
{
"id": "019155b0ab717ff5aa7e62cd921b9c4f"
},
{
"id": "019715dd36eb7283ade18d2b416a06b3"
},
{
"id": "019a24914ff5722baf0286f49f888d6a"
},
{
"id": "99812552a73a423a88a4852c8dd44140"
},
{
"id": "af586506470e46f89c7f3f8dea7fb411"
},
{
"id": "b9d3b15fd1214916bf581223c54fdff8"
},
{
"id": "bad0539785be4dd9a32c976f5152881e"
},
{
"id": "cb292e1aaf854891a0d4e2fca32dd02f"
},
{
"id": "e55203ade881479cb68bf1433fda4c6c"
},
{
"id": "e7e9c4af806040279b50e96833d5aedb"
},
{
"id": "f4e67c126b4e4b4f8b4f4b8295613b5b"
}
]
},
"fields": {
"displayGroup": [
"8520256196cd08cc43b31f51dfb230d4"
]
},
"sort": [
0,
1100.0,
0,
-9223372036854775808,
"dd32268ba8bc0cfdfe24b3603776842d"
]
},
{
"_index": "staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1761201038",
"_id": "ec594178a6c1cc6fbf4ef25634d61e8a",
"_score": 1100.0,
"_source": {
"id": "ec594178a6c1cc6fbf4ef25634d61e8a",
"name": "Klemmbrett - Zwischenwandverschluss aus Stahl - Verstellbereich 2400-2700 mm - Klemmbereich 21-36 mm",
"description": "Klemmbrett \/ Zwischenwandverschluss \u2219 Zum Aufstecken und Spannen auf der Bordwand oder dem Planengestell \u2219 Durch den Einsatz mehrerer Zwischenwandverschl\u00fcsse kann die Ladefl\u00e4che in verschiedene Zonen unterteilt werden \u2219 Fixiertes Mittelteil aus Stahl \u2219 Ausziehbare Aluminiumplatten mit 2 Klemmen (Klemmbereich 21-36 mm) Profilh\u00f6he: 121,5 mmProfilbreite: 30 mm",
"metaTitle": "Zwischenwandverschluss aus Stahl",
"metaDescription": "Zwischenwandverschluss Verstellbereich 2400-2700 mm Klemmbereich 21-36 mm ",
"customSearchKeywords": [
""
],
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"customFields": {
"custom_eis_skus_sku1": "E837931G",
"custom_eis_skus_sku4": "E837931B",
"custom_topartikel_position": 0.0,
"custom_topartikel_kategorie": false,
"acris_search_sorting_relevance": 0,
"custom_customer_group_discount_exclude": false,
"acris_price_on_request_additional_field": false
},
"visibilities": [
{
"visibility": "30",
"salesChannelId": "132e445c03814d67ac47c04afb6d5d99",
"_count": 1
}
],
"availableStock": 0,
"productNumber": "E837931-BS",
"ean": "4031639097655",
"displayGroup": "d8588f6b2c420b8f4372adda843d0493",
"sales": 0,
"stock": 0,
"manufacturerId": "8c03414628006e25df4a86ac5e61b9ba",
"manufacturerNumber": "72562-240\/270-BASIC",
"manufacturer": {
"id": "8c03414628006e25df4a86ac5e61b9ba",
"name": "BRAUn",
"_count": 1
},
"releaseDate": null,
"createdAt": "2024-07-24T11:55:17+00:00",
"optionIds": [],
"options": [],
"categories": [
{
"id": "5670e5c42654de8411142cc18d3fb5cf",
"name": "Klemmbretter\/Klemmbalken"
}
],
"categoriesRo": [
{
"id": "b283b270431e4a1285d331e63d0e6202",
"_count": 1
},
{
"id": "ed73dec91e641fe53ece1391575c6d00",
"_count": 1
},
{
"id": "82d3136deee0a87fed0699f93a60dd54",
"_count": 1
},
{
"id": "5670e5c42654de8411142cc18d3fb5cf",
"_count": 1
}
],
"categoryIds": [
"5670e5c42654de8411142cc18d3fb5cf"
],
"categoryTree": [
"b283b270431e4a1285d331e63d0e6202",
"ed73dec91e641fe53ece1391575c6d00",
"82d3136deee0a87fed0699f93a60dd54",
"5670e5c42654de8411142cc18d3fb5cf"
],
"properties": [],
"propertyIds": [],
"taxId": "937f7203705d4d7c8202d8e85be59232",
"tags": [],
"tagIds": [],
"parentId": null,
"coverId": "d76db28913691a04c9db2941945497e9",
"childCount": 0,
"states": [
"is-physical"
],
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 215.39,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 181.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0,
"bergerDownloads": [],
"bergerBadges": [],
"attributes": {
"einstandspreisEis": {
"attributeId": "a5d9a645c6f18b3fffb32b423d4b6fa5",
"type": "StringField",
"value": "90.51",
"label": "Einstandspreis EIS"
},
"verstellbereich": {
"attributeId": "ab2afaf358e9a29e2e126215b8cc64d0",
"type": "StringField",
"value": "2400-2700 mm",
"label": "Verstellbereich"
},
"eclass91": {
"attributeId": "c7bd39282c5ff77e43704b92e387af62",
"type": "StringField",
"value": "20420290",
"label": "eClass 9.1"
},
"nameShort": {
"attributeId": "f8c2af32acdac443727a6dadc5917437",
"type": "StringField",
"value": "Klemmbrett - Zwischenwandverschluss aus Stahl",
"label": "LABEL_MISSING"
},
"typModel": {
"attributeId": "59c6c7d9678c652ba957d0e829c20200",
"type": "StringField",
"value": "Klemmbretter",
"label": "Typ\/Modell"
},
"artikelMargeEuroEUR": {
"attributeId": "467fd043cc3272e0ef48046f37fefff7",
"type": "FloatField",
"value": 90.49,
"label": "Artikel Marge",
"unit": "\u20ac"
},
"eclass51": {
"attributeId": "3f3cb6552f77f3bd95539d730d199fd8",
"type": "StringField",
"value": "20420290",
"label": "eClass 5.1"
},
"eclass130": {
"attributeId": "5d58ac61bcad814882bb94cafd70e261",
"type": "StringField",
"value": "20420290",
"label": "eClass 13.0"
},
"lieferzeit": {
"attributeId": "2286c50ec12650c51f8046b81d08fec9",
"type": "IntField",
"value": 5,
"label": "Lieferzeit",
"unit": "Tage"
},
"verpackungseinheit": {
"attributeId": "b2228e0218bd8c44456c38fde3dbd13a",
"type": "IntField",
"value": 1,
"label": "VPE",
"unit": "Stk"
},
"nameBullet1": {
"attributeId": "197477e550bad420764a27e99f7ff55b",
"type": "StringField",
"value": "Verstellbereich 2400-2700 mm",
"label": "LABEL_MISSING"
},
"eclass111": {
"attributeId": "df91f8757379fbf660a9a8a2d0c5862a",
"type": "StringField",
"value": "20420290",
"label": "eClass 11.1"
},
"eclass101": {
"attributeId": "707fa7400989ef43255668a095490309",
"type": "StringField",
"value": "20420290",
"label": "eClass 10.1"
},
"nameBullet2": {
"attributeId": "38160a50dcd4be0db5d1913984845ec1",
"type": "StringField",
"value": "Klemmbereich 21-36 mm",
"label": "LABEL_MISSING"
},
"herstellerOriginal": {
"attributeId": "61bbdf2bca0073f4404f2740d00add2c",
"type": "StringField",
"value": "Braun Seile",
"label": "Hersteller Original"
},
"eclass71": {
"attributeId": "aff2996b4b06ea4c2b6fc00720b0f78b",
"type": "StringField",
"value": "20420290",
"label": "eClass 7.1"
},
"bestEinheit": {
"attributeId": "e3cc4aee752f7fd82b5a8f2a7a952f0a",
"type": "StringField",
"value": "St\u00fcck",
"label": "Bestelleinheit"
},
"eclass140": {
"attributeId": "249eaf721c50994e2b555d43e0aab090",
"type": "StringField",
"value": "20420290",
"label": "eClass 14.0"
},
"artikelMargeProzent": {
"attributeId": "38e4c7e297af9f3dc3db3a866da09604",
"type": "FloatField",
"value": 49.99,
"label": "Artikel Marge",
"unit": "%"
},
"eisKatalogUrl": {
"attributeId": "0581c0c06d61e1784605ae623dcf3938",
"type": "StringField",
"value": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=596",
"label": "Katalog Link"
},
"eclass81": {
"attributeId": "635cb161fc196c46a8d7104a3a101a02",
"type": "StringField",
"value": "20420290",
"label": "eClass 8.1"
},
"eclass120": {
"attributeId": "59016d5bcca8ec5e1a80ca2d22f40f24",
"type": "StringField",
"value": "20420290",
"label": "eClass 12.0"
}
},
"attribute_einstandspreisEis": "90.51",
"attribute_verstellbereich": "2400-2700 mm",
"attribute_eclass91": "20420290",
"attribute_nameShort": "Klemmbrett - Zwischenwandverschluss aus Stahl",
"attribute_typModel": "Klemmbretter",
"attribute_artikelMargeEuroEUR": 90.49,
"attribute_eclass51": "20420290",
"attribute_eclass130": "20420290",
"attribute_lieferzeit": 5,
"attribute_verpackungseinheit": 1,
"attribute_nameBullet1": "Verstellbereich 2400-2700 mm",
"attribute_eclass111": "20420290",
"attribute_eclass101": "20420290",
"attribute_nameBullet2": "Klemmbereich 21-36 mm",
"attribute_herstellerOriginal": "Braun Seile",
"attribute_eclass71": "20420290",
"attribute_bestEinheit": "St\u00fcck",
"attribute_eclass140": "20420290",
"attribute_artikelMargeProzent": 49.99,
"attribute_eisKatalogUrl": "https:\/\/oxomi.com\/p\/1534781\/catalog\/10642456?page=596",
"attribute_eclass81": "20420290",
"attribute_eclass120": "20420290",
"streams": [
{
"id": "019155b0ab717ff5aa7e62cd921b9c4f"
},
{
"id": "019715dd36eb7283ade18d2b416a06b3"
},
{
"id": "019a24914ff5722baf0286f49f888d6a"
},
{
"id": "99812552a73a423a88a4852c8dd44140"
},
{
"id": "af586506470e46f89c7f3f8dea7fb411"
},
{
"id": "b9d3b15fd1214916bf581223c54fdff8"
},
{
"id": "bad0539785be4dd9a32c976f5152881e"
},
{
"id": "cb292e1aaf854891a0d4e2fca32dd02f"
},
{
"id": "e55203ade881479cb68bf1433fda4c6c"
},
{
"id": "e7e9c4af806040279b50e96833d5aedb"
},
{
"id": "f4e67c126b4e4b4f8b4f4b8295613b5b"
}
]
},
"fields": {
"displayGroup": [
"d8588f6b2c420b8f4372adda843d0493"
]
},
"sort": [
0,
1100.0,
0,
-9223372036854775808,
"ec594178a6c1cc6fbf4ef25634d61e8a"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.48 ms |
Request:
{"index":"staging-65_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"132e445c03814d67ac47c04afb6d5d99"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"5670e5c42654de8411142cc18d3fb5cf"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"manufacturer-count-filter":{"composite":{"sources":[{"manufacturer-count-filter.sorting":{"terms":{"field":"manufacturerId","order":"ASC"}}},{"manufacturer-count-filter.key":{"terms":{"field":"manufacturerId"}}}],"size":"99999"}},"bool-reduced":{"filter":{"script":{"script":{"id":"cheapest_price_percentage_filter","params":{"gt":1.0,"accessors":[{"key":"cheapest_price_rule019a24914f307230b93bb6efb923d8e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule07f438d06a8a4951a3023a5e7810f884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule2772e1f3cc52436593ed4c7b229426fe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulec019dd2f47394d68874602781a1eb06a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulef43239e32e16483181a57e49cae1db77_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rule643070c6755c43f3ad58eba50f4d0b17_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_rulea755c64836d24743b295845250c45862_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage","factor":1}]}}}},"aggregations":{"bool-reduced":{"value_count":{"field":"id"}}}},"width":{"stats":{"field":"width"}},"width-stats":{"filter":{"range":{"width":{"gt":0.0}}},"aggregations":{"width-stats":{"stats":{"field":"width"}}}},"height":{"stats":{"field":"height"}},"height-stats":{"filter":{"range":{"height":{"gt":0.0}}},"aggregations":{"height-stats":{"stats":{"field":"height"}}}},"tiefe":{"stats":{"field":"attribute_tiefe"}},"multi-farbe":{"composite":{"sources":[{"multi-farbe.sorting":{"terms":{"field":"attribute_farbe","order":"ASC"}}},{"multi-farbe.key":{"terms":{"field":"attribute_farbe"}}}],"size":"99999"}},"manufacturer-count":{"terms":{"field":"manufacturerId","size":10000}}},"size":0,"timeout":"5s"}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|