| 1 |
3.50 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"4811bfc2905d4eb980b8d78a12b1236b"}}}},{"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":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 24,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "138ba11d3d4c4d38be530529a4cdc046",
"_score": null,
"_source": {
"id": "138ba11d3d4c4d38be530529a4cdc046",
"autoIncrement": 56174.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "2100541.1",
"ean": null,
"displayGroup": "a70db845daca47d2ba271f2bcb90e26b",
"sales": 0,
"stock": 1000,
"weight": 0.2,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "200681",
"releaseDate": null,
"createdAt": "2021-11-04T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"4811bfc2905d4eb980b8d78a12b1236b"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "1d335441640d4ecebf05197d683568b0",
"coverId": "241e8c192adb4b5fbdd7891526597166",
"childCount": 0,
"categories": [
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos reductores",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierrohre",
"5494b24b09d445ebace47112836b4458": "Tubes de r\u00e9duction",
"de44571ddc4e4d0095c01af6ee299351": "Reducing Pipes"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "70efdf6ab0304979b4f3441bc1b05efd",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 mm - 45 mm",
"5494b24b09d445ebace47112836b4458": "51 mm - 45 mm",
"de44571ddc4e4d0095c01af6ee299351": "51 mm - 45 mm"
}
}
],
"categoryIds": [
"4811bfc2905d4eb980b8d78a12b1236b"
],
"optionIds": [
"70efdf6ab0304979b4f3441bc1b05efd"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-edelstahl-reduzierrohr",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierrohr BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierrohr BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-stainless-steel-flex-pipe-compensator",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierrohr BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Edelstahl Reduzierrohr BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Tuyau r\u00e9ducteur d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Stainless Steel Reducing Pipe BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierrohr aus hochwertigem Edelstahl zum adaptieren von unterschiedlichen Rohrdurchmessern.\nFeatures:\n\nuniversell zum Einschwei\u00dfen\nkomplett aus Edelstahl\nbestens geeignet f\u00fcr jede Leistung\n",
"5494b24b09d445ebace47112836b4458": "Tube r\u00e9ducteur en acier inoxydable de haute qualit\u00e9 permettant d'adapter diff\u00e9rents diam\u00e8tres de tubes.\nCaract\u00e9ristiques :\n\nuniversel pour le soudage en\nenti\u00e8rement en acier inoxydable\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\n",
"de44571ddc4e4d0095c01af6ee299351": "Reducing tube made of high quality stainless steel for adapting different tube diameters.\nFeatures:\n\nuniversal for welding in\ncompletely made of stainless steel\nbest suitable for any performance\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "\u2063Exhaust Stainless Steel Reducing Pipe BAR-TEK\u00ae"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierrohr aus Edelstahl f\u00fcr optimale Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel reducer tube for optimum durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.25,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.4142857142857,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.3550005,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.5,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.15,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.327731,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.3,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.134454,
"shop-customer": "6.134454",
"c-dealer": "4.4142857142857",
"b-dealer": "4.5",
"a-dealer": "4.327731"
},
"fields": {
"displayGroup": [
"a70db845daca47d2ba271f2bcb90e26b"
]
},
"sort": [
"true",
0,
"138ba11d3d4c4d38be530529a4cdc046"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "2212a3ee195942c4a645f73ee7171c84",
"_score": null,
"_source": {
"id": "2212a3ee195942c4a645f73ee7171c84",
"autoIncrement": 56188.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "2100542.4",
"ean": null,
"displayGroup": "70f9f7870fa938a9a81019363f67ad7b",
"sales": 0,
"stock": 1000,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "402923",
"releaseDate": null,
"createdAt": "2021-11-04T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"4811bfc2905d4eb980b8d78a12b1236b"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "898ecd89c0204f2f9f3e0879b2f18809",
"coverId": "ba26303ddb2d4f35ad96d12135de8d04",
"childCount": 0,
"categories": [
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos reductores",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierrohre",
"5494b24b09d445ebace47112836b4458": "Tubes de r\u00e9duction",
"de44571ddc4e4d0095c01af6ee299351": "Reducing Pipes"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "7d332ce2294d4e16b62e7ef7171ad241",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "101 mm - 76 mm",
"5494b24b09d445ebace47112836b4458": "101 mm - 76 mm",
"de44571ddc4e4d0095c01af6ee299351": "101 mm - 76 mm"
}
}
],
"categoryIds": [
"4811bfc2905d4eb980b8d78a12b1236b"
],
"optionIds": [
"7d332ce2294d4e16b62e7ef7171ad241"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-edelstahl-reduzierkonus",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierkonus BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierkonus BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-stainless-steel-flex-pipe-compensator",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Reduzierkonus BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Edelstahl Reduzierkonus BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "C\u00f4ne r\u00e9ducteur d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Stainless Steel Reducing Cone BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierkonus aus hochwertigem Edelstahl zum adaptieren von unterschiedlichen Rohrdurchmessern.\nFeatures:\n\nuniversell zum Einschwei\u00dfen\nkomplett aus Edelstahl\nbestens geeignet f\u00fcr jede Leistung\n",
"5494b24b09d445ebace47112836b4458": "C\u00f4ne r\u00e9ducteur en acier inoxydable de haute qualit\u00e9 permettant d'adapter diff\u00e9rents diam\u00e8tres de tuyaux.\nCaract\u00e9ristiques :\n\nuniversel pour le soudage en\nenti\u00e8rement en acier inoxydable\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\n",
"de44571ddc4e4d0095c01af6ee299351": "Reducing cone made of high-quality stainless steel for adapting different pipe diameters.\nFeatures:\n\nuniversal for welding in\ncompletely made of stainless steel\nbest suitable for any performance\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "\u2063Exhaust Stainless Steel Reducing Cone BAR-TEK\u00ae"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierkonus aus Edelstahl f\u00fcr optimale Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel reducer cone for optimum durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 72.35,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 60.8,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 71.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 59.83193,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 73.542,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 61.8,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 83.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 70.54621,
"shop-customer": "70.54621",
"c-dealer": "60.8",
"a-dealer": "59.83193",
"b-dealer": "61.8"
},
"fields": {
"displayGroup": [
"70f9f7870fa938a9a81019363f67ad7b"
]
},
"sort": [
"true",
0,
"2212a3ee195942c4a645f73ee7171c84"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "3f31b505b7604ab78da84c52eeecb2d5",
"_score": null,
"_source": {
"id": "3f31b505b7604ab78da84c52eeecb2d5",
"autoIncrement": 56191.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "2100543.3",
"ean": null,
"displayGroup": "dd5727005eef6a9be3d42fcfb575a632",
"sales": 0,
"stock": 1000,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "434280",
"releaseDate": null,
"createdAt": "2021-11-04T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"4811bfc2905d4eb980b8d78a12b1236b"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "e898d612de4d40f9a60dedb64acbab0a",
"coverId": "2601e77567b24a51a91d158583d0b40a",
"childCount": 0,
"categories": [
{
"id": "4811bfc2905d4eb980b8d78a12b1236b",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos reductores",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Reduzierrohre",
"5494b24b09d445ebace47112836b4458": "Tubes de r\u00e9duction",
"de44571ddc4e4d0095c01af6ee299351": "Reducing Pipes"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "eacc53194a914ecba3d72934e4d4515f",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "70 - 60 - 55 mm",
"5494b24b09d445ebace47112836b4458": "70 - 60 - 55 mm",
"de44571ddc4e4d0095c01af6ee299351": "70 - 60 - 55 mm"
}
}
],
"categoryIds": [
"4811bfc2905d4eb980b8d78a12b1236b"
],
"optionIds": [
"eacc53194a914ecba3d72934e4d4515f"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-edelstahl-stufenrohrreduzierung",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Stufenrohrreduzierung BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Stufenrohrreduzierung BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-stainless-steel-reducing-cone",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Stufenrohrreduzierung BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Edelstahl Stufenrohrreduzierung BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "C\u00f4ne r\u00e9ducteur d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Stainless Steel Reducing Cone BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stufenrohrverbinder aus hochwertigem Edelstahl zum adaptieren von unterschiedlichen Rohrdurchmessern.\nFeatures:\n\nuniversell zum Einschwei\u00dfen\nkomplett aus Edelstahl\nbestens geeignet f\u00fcr jede Leistung\n",
"5494b24b09d445ebace47112836b4458": "C\u00f4ne r\u00e9ducteur en acier inoxydable de haute qualit\u00e9 permettant d'adapter diff\u00e9rents diam\u00e8tres de tuyaux.\nCaract\u00e9ristiques :\n\nuniversel pour le soudage en\nenti\u00e8rement en acier inoxydable\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\n",
"de44571ddc4e4d0095c01af6ee299351": "Reducing cone made of high-quality stainless steel for adapting different pipe diameters.\nFeatures:\n\nuniversal for welding in\ncompletely made of stainless steel\nbest suitable for any performance\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Exhaust stainless steel step pipe reducer BAR-TEK\u00ae."
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stufenrohrreduzierung aus Edelstahl f\u00fcr optimale Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel reducer cone for optimum durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.85,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.20168,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.562,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.8,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.2,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.493333333333,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.35,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.663864,
"shop-customer": "24.663864",
"a-dealer": "19.20168",
"b-dealer": "19.8",
"c-dealer": "19.493333333333"
},
"fields": {
"displayGroup": [
"dd5727005eef6a9be3d42fcfb575a632"
]
},
"sort": [
"true",
0,
"3f31b505b7604ab78da84c52eeecb2d5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.76 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"4811bfc2905d4eb980b8d78a12b1236b"}}}},{"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_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "4811bfc2905d4eb980b8d78a12b1236b"
}
}
}
},
{
"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_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties-filter": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties-filter": {
"filter": {
"terms": {
"properties.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
}
}
},
"options-filter": {
"nested": {
"path": "options"
},
"aggregations": {
"options-filter": {
"filter": {
"terms": {
"options.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"isAvailable-filter": {
"doc_count": 24,
"isAvailable": {
"value": 1010.0
}
},
"customPrice-1300": {
"doc_count": 0,
"customPrice-1300": {
"value": 0
}
},
"customPrice-500-700": {
"doc_count": 0,
"customPrice-500-700": {
"value": 0
}
},
"customPrice-900-1300": {
"doc_count": 0,
"customPrice-900-1300": {
"value": 0
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e8c1a2f622aa4c319cb4b82536ef0dca",
"doc_count": 24
}
]
},
"customPrice-100-300": {
"doc_count": 0,
"customPrice-100-300": {
"value": 0
}
},
"properties-filter": {
"doc_count": 0,
"properties-filter": {
"doc_count": 0,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
},
"isUniversal-filter": {
"doc_count": 24,
"isUniversal": {
"value": 1.0,
"value_as_string": "true"
}
},
"customPrice-700-900": {
"doc_count": 0,
"customPrice-700-900": {
"value": 0
}
},
"customPrice-3-100": {
"doc_count": 24,
"customPrice-3-100": {
"value": 24
}
},
"options-filter": {
"doc_count": 24,
"options-filter": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
},
"price": {
"count": 24,
"min": 5.9,
"max": 83.95,
"avg": 22.820833333333336,
"sum": 547.7
},
"options": {
"doc_count": 24,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "797606cdf11f416995508416a45515bd",
"doc_count": 2
},
{
"key": "ed521724064841778559216599ff624d",
"doc_count": 2
},
{
"key": "02b92fefa86b4e348842c7b116dbda34",
"doc_count": 1
},
{
"key": "037f6d91294b4fe5bff54b365bae61cf",
"doc_count": 1
},
{
"key": "0c2d51296344451b86e152c07ece08a8",
"doc_count": 1
},
{
"key": "2f8f24ea1af44cb5b1a33db3f5f142fc",
"doc_count": 1
},
{
"key": "48510f22f21047bf909be9dc07fc561b",
"doc_count": 1
},
{
"key": "5a1a93f660a146d0b5af9d171419e198",
"doc_count": 1
},
{
"key": "5e8fcbd365a54e02bc413d80462b8492",
"doc_count": 1
},
{
"key": "6bc7e6d322ae48f5ac342a321ded3e82",
"doc_count": 1
},
{
"key": "6f45fbbdb656417db2a9e551b9d8c853",
"doc_count": 1
},
{
"key": "70efdf6ab0304979b4f3441bc1b05efd",
"doc_count": 1
},
{
"key": "7d332ce2294d4e16b62e7ef7171ad241",
"doc_count": 1
},
{
"key": "8ad14ffffaba41eab1525011f4772620",
"doc_count": 1
},
{
"key": "a04b48c3ddca4bd784532b9e5c09c0f0",
"doc_count": 1
},
{
"key": "ab80996c511e49c993104e3fd3528ba1",
"doc_count": 1
},
{
"key": "c5fb8363e5c84bf180767142d0b2ebb9",
"doc_count": 1
},
{
"key": "c9ab85b129d04cc983e407c8492672fa",
"doc_count": 1
},
{
"key": "e7645e3cde94404c82a795b401393b8a",
"doc_count": 1
},
{
"key": "eacc53194a914ecba3d72934e4d4515f",
"doc_count": 1
},
{
"key": "ee97befdd08b4095a7f5d028a5245372",
"doc_count": 1
},
{
"key": "f3ef4a0da88345d0b88d2c3a2c3df50e",
"doc_count": 1
}
]
}
},
"customPrice-300-500": {
"doc_count": 0,
"customPrice-300-500": {
"value": 0
}
},
"properties": {
"doc_count": 0,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|