| 1 |
6.17 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","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":"184695505b9b47a0b883153457491a15"}}}},{"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":["de44571ddc4e4d0095c01af6ee299351","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": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 8,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "12be666c90654a8e9033ddee9c28bcc2",
"_score": null,
"_source": {
"id": "12be666c90654a8e9033ddee9c28bcc2",
"autoIncrement": 48579.0,
"ratingAverage": 4.66667,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 18,
"productNumber": "2100207",
"ean": "4260630970692",
"displayGroup": "5f17a7757cc5b1607cf72088fcbc9be0",
"sales": 0,
"stock": 18,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"67b6e45172bc46a19d8354fe2258e02b",
"18e5d0372de74ee59757aedc38a10a58",
"184695505b9b47a0b883153457491a15",
"26b15bb504984bc2832f14340e5adeab",
"2919e4964b10408a991a6393c525d8b8",
"435e789f5fa14f5a828e390d940d4cdc",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "67b6e45172bc46a19d8354fe2258e02b",
"_count": 1
},
{
"id": "18e5d0372de74ee59757aedc38a10a58",
"_count": 1
},
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1
},
{
"id": "26b15bb504984bc2832f14340e5adeab",
"_count": 1
},
{
"id": "2919e4964b10408a991a6393c525d8b8",
"_count": 1
},
{
"id": "435e789f5fa14f5a828e390d940d4cdc",
"_count": 1
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "3b31b503b4c147b18e7ff6701c0368d8",
"coverId": "73c0ee8451d04f2f9800fe5123cbb3f8",
"childCount": 0,
"categories": [
{
"id": "435e789f5fa14f5a828e390d940d4cdc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
},
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Material de fijaci\u00f3n",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Befestigungsmaterial",
"5494b24b09d445ebace47112836b4458": "Mat\u00e9riel de fixation",
"de44571ddc4e4d0095c01af6ee299351": "Fastening Material"
}
},
{
"id": "2919e4964b10408a991a6393c525d8b8",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Refrigeraci\u00f3n de los frenos",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bremsenk\u00fchlung",
"5494b24b09d445ebace47112836b4458": "Refroidissement des freins",
"de44571ddc4e4d0095c01af6ee299351": "Brake Cooling"
}
},
{
"id": "26b15bb504984bc2832f14340e5adeab",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Cinta de protecci\u00f3n t\u00e9rmica",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hitzeschutzband",
"5494b24b09d445ebace47112836b4458": "Ruban de protection contre la chaleur",
"de44571ddc4e4d0095c01af6ee299351": "Wraps"
}
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios de protecci\u00f3n contra el calor",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hitzeschutz-Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": "Protection contre la chaleur- accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Heat Protection Accessories"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "65dd0e0c9a9745789212e4e05627175f",
"_count": 1,
"groupId": "7b846261d30c4e268d7e8c7321242bfd",
"group": {
"id": "7b846261d30c4e268d7e8c7321242bfd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10 Stk. mit 20 cm L\u00e4nge",
"de44571ddc4e4d0095c01af6ee299351": "10 pcs. with 20 cm length",
"5494b24b09d445ebace47112836b4458": "10 pi\u00e8ces de 20 cm de long",
"1b6fa06ba44f40c4889b056e1feca812": "10 pezzi con 20 cm di lunghezza"
}
}
],
"categoryIds": [
"184695505b9b47a0b883153457491a15",
"26b15bb504984bc2832f14340e5adeab",
"2919e4964b10408a991a6393c525d8b8",
"435e789f5fa14f5a828e390d940d4cdc",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"optionIds": [
"65dd0e0c9a9745789212e4e05627175f"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "PS: 20cm - Damesa (Mikalor) bestellen\nReference: 03002002\nSerie: 17\/56358-11\n4,5 x 50 L200\n22 Euro\/100 Stk.\n\n50cm: 03002005 34 euro netto\/100Stk.\n\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Edelstahl Kabelbinder",
"migration_Shopware5DB_product_bullet1": "H\u00f6chste Qualit\u00e4t",
"migration_Shopware5DB_product_bullet2": "Hitzeresistent bis zu 700\u00b0C",
"migration_Shopware5DB_product_bullet3": "Zugfestigkeit von 50 kg",
"migration_Shopware5DB_product_bullet4": "Hergestellt aus 304 Edelstahl",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "faecherkruemmerbinder-metallkabelbinder-hitzeschutz-hitzetapehalter",
"migration_Shopware5DB_product_dreisc_seo_title": "Edelstahl Kabelbinder",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "PS: 20cm - Damesa (Mikalor) bestellen\nReference: 03002002\nSerie: 17\/56358-11\n4,5 x 50 L200\n22 Euro\/100 Stk.\n\n50cm: 03002005 34 euro netto\/100Stk.\n\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Edelstahl Kabelbinder",
"migration_Shopware5DB_product_bullet1": "H\u00f6chste Qualit\u00e4t",
"migration_Shopware5DB_product_bullet2": "Hitzeresistent bis zu 700\u00b0C",
"migration_Shopware5DB_product_bullet3": "Zugfestigkeit von 50 kg",
"migration_Shopware5DB_product_bullet4": "Hergestellt aus 304 Edelstahl",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Edelstahl Kabelbinder",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "PS: 20cm - Damesa (Mikalor) bestellen\nReference: 03002002\nSerie: 17\/56358-11\n4,5 x 50 L200\n22 Euro\/100 Stk.\n\n50cm: 03002005 34 euro netto\/100Stk.\n\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Stainless steel cable ties",
"migration_Shopware5DB_product_bullet1": "Highest quality",
"migration_Shopware5DB_product_bullet2": "Heat resistant up to 700\u00b0C",
"migration_Shopware5DB_product_bullet3": "Tensile strength of 50 kg",
"migration_Shopware5DB_product_bullet4": "Made of 304 stainless steel",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Edelstahl Kabelbinder",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Kabelbinder",
"5494b24b09d445ebace47112836b4458": "Colliers de serrage en acier inoxydable",
"de44571ddc4e4d0095c01af6ee299351": "Header Wrap Ties"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F\u00fcr die Befestigung von Hitzeschutzband empfehlen wir diese speziellen Edelstahl Kabelbinder. Ideal geeignet f\u00fcr F\u00e4chergr\u00fcmmer, Downpipes und Abgasanlagen. Um kapitale Sch\u00e4den zu vermeiden, umwickelt man hei\u00dfe Bauteile am Fahrzeug mit Hitzeschutzband, das wiederum mit den Kabelbindern befestigt wird. Auch in der Industrie finden die Edelstahl Kabelbinder Verwendung. Produktinformation:\n\nH\u00f6chste Qualit\u00e4t\nHitzeresistent bis zu 700\u00b0C\nZugfestigkeit von 50 kg\nHergestellt aus 304 Edelstahl\nAbgerundete Kanten\nEinfache Handhabung\n",
"5494b24b09d445ebace47112836b4458": "Nous recommandons ces colliers de serrage sp\u00e9ciaux en acier inoxydable pour fixer le ruban de protection thermique. Id\u00e9al pour les collecteurs de ventilateurs, les tuyaux de descente et les syst\u00e8mes d'\u00e9vacuation. Afin d'\u00e9viter des dommages capitaux, les composants chauds du v\u00e9hicule sont envelopp\u00e9s d'un ruban de protection thermique, qui est \u00e0 son tour fix\u00e9 avec les attaches de c\u00e2ble. Les colliers de serrage en acier inoxydable sont \u00e9galement utilis\u00e9s dans l'industrie. des informations sur les produits :\n\nLa plus haute qualit\u00e9\nR\u00e9sistant \u00e0 la chaleur jusqu'\u00e0 700\u00b0C\nune r\u00e9sistance \u00e0 la traction de 50 kg\nFabriqu\u00e9 en acier inoxydable 304\nBords arrondis\nManipulation ais\u00e9e\n",
"de44571ddc4e4d0095c01af6ee299351": "We recommend these special stainless steel cable ties for attaching heat protection tape.\nIdeally suited for fan manifolds, downpipes and exhaust systems.In order to avoid major damage, hot components are wrapped around the vehicle with heat protection tape, which in turn is fastened with the cable ties.\nStainless steel cable ties are also used in industry.\nProduct information:\n\nHighest quality\nHeat resistant up to 700 \u00b0C\nTensile strength of 50 kg\nMade of 304 stainless steel\nRounded edges\nEasy to use\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Kabelbinder",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.48,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.7666666666667,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.05,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.4033613,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.3435,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.65,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.25,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.4117646,
"shop-customer": "4.4117646",
"c-dealer": "3.7666666666667",
"a-dealer": "3.4033613",
"b-dealer": "3.65"
},
"fields": {
"displayGroup": [
"5f17a7757cc5b1607cf72088fcbc9be0"
]
},
"sort": [
"true",
0,
"12be666c90654a8e9033ddee9c28bcc2"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "46aafb1d12424a33a5140cccb5236c38",
"_score": null,
"_source": {
"id": "46aafb1d12424a33a5140cccb5236c38",
"autoIncrement": 46623.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "H020601003",
"ean": "4026947014807",
"displayGroup": "c2657e08326b03c3faf637656a96da47",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 22598.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "BGS 1480",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"184695505b9b47a0b883153457491a15",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "e4b47bdc7de64359b88cbccdb0cc1ce2",
"childCount": 0,
"categories": [
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Material de fijaci\u00f3n",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Befestigungsmaterial",
"5494b24b09d445ebace47112836b4458": "Mat\u00e9riel de fixation",
"de44571ddc4e4d0095c01af6ee299351": "Fastening Material"
}
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios de protecci\u00f3n contra el calor",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hitzeschutz-Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": "Protection contre la chaleur- accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Heat Protection Accessories"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"184695505b9b47a0b883153457491a15",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "02 = Longacre\r\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"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": "sicherheitsdrahtzange-roedeldraht-roedeldrahtzange-zwirbelzange",
"migration_Shopware5DB_product_dreisc_seo_title": "Sicherheits Drahtzange f\u00fcr R\u00f6deldraht",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "02 = Longacre\r\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Sicherheits Drahtzange f\u00fcr R\u00f6deldraht",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "02 = Longacre\r\n",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Safety wire pliers for wire rods",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sicherheits Drahtzange f\u00fcr R\u00f6deldraht",
"5494b24b09d445ebace47112836b4458": "Pince de s\u00e9curit\u00e9 pour fil de bobinage",
"de44571ddc4e4d0095c01af6ee299351": "Safety Wire Pliers for tie wire"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R\u00f6deldrahtzange oder auch genannt Zwirbelzange zum sicheren Umgang mit R\u00f6deldraht. Biegt ihren Draht schnell und ordentlich in passende Windungen nach Luftfahrtnorm. R\u00f6deldraht findet besonders bei Hitzeschutzprodukten und Sicherheitsrelevanten Schrauben Anwendung, die gegen ein ungewolltes L\u00f6sen gesichert werden m\u00fcssen. Der Sicherungsdraht kann auch zum Verplomben benutzt werden wie z.B. in der \u00d6lwanne oder um den Turbolader. Wir empfehlen dazu unseren Sicherungsdraht aus Edelstahl.",
"5494b24b09d445ebace47112836b4458": "Pince R\u00f6deldraht ou aussi appel\u00e9e pince Zwirbel pour une manipulation s\u00fbre du R\u00f6deldraht. Cintrez votre fil rapidement et proprement en bobines appropri\u00e9es selon les normes de l'aviation. Le R\u00f6deldraht est surtout utilis\u00e9 pour les produits de protection thermique et les vis de s\u00e9curit\u00e9, qui doivent \u00eatre s\u00e9curis\u00e9es contre tout desserrage involontaire. Le fil de s\u00e9curit\u00e9 peut \u00e9galement \u00eatre utilis\u00e9 pour l'\u00e9tanch\u00e9it\u00e9, par exemple dans le carter d'huile ou autour du turbocompresseur. Nous vous recommandons notre fil de s\u00e9curit\u00e9 en acier inoxydable.",
"de44571ddc4e4d0095c01af6ee299351": "Wire twisting pliers or also called twisting pliers for safe handling of wire twisting wire.\n\nBends your wire quickly and neatly into suitable coils according to aviation standards.\n\nWires are used especially for heat protection products and safety-relevant screws, which must be secured against unintentional loosening. The safety wire can also be used for sealing, e.g. in the oil pan or around the turbocharger.\n\nWe recommend our stainless steel safety wire for this purpose.\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sicherheits Drahtzange f\u00fcr R\u00f6deldraht",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Safety wire pliers for wire rods"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.7,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.07563,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.4545,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.55,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.21,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.183333333333,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.428572,
"shop-customer": "26.428572",
"a-dealer": "19.07563",
"b-dealer": "20.55",
"c-dealer": "21.183333333333"
},
"fields": {
"displayGroup": [
"c2657e08326b03c3faf637656a96da47"
]
},
"sort": [
"true",
0,
"46aafb1d12424a33a5140cccb5236c38"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "0b285bee7a044d9a90840321a2e8f9fc",
"_score": null,
"_source": {
"id": "0b285bee7a044d9a90840321a2e8f9fc",
"autoIncrement": 57347.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 2,
"productNumber": "LWD59.1",
"ean": null,
"displayGroup": "80fa31b739f67b9d400a343f9c31c928",
"sales": 0,
"stock": 2,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6a2b1e977d064ef692976607cd6c094a",
"manufacturerNumber": "LWD595",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"184695505b9b47a0b883153457491a15",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "4dd36411f446442380afae3902ae2b96",
"coverId": "662630878ec9433ca2b3630175fd7c66",
"childCount": 0,
"categories": [
{
"id": "184695505b9b47a0b883153457491a15",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Material de fijaci\u00f3n",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Befestigungsmaterial",
"5494b24b09d445ebace47112836b4458": "Mat\u00e9riel de fixation",
"de44571ddc4e4d0095c01af6ee299351": "Fastening Material"
}
},
{
"id": "fd1c0181ed444be6a5899e6e8fb89318",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios de protecci\u00f3n contra el calor",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hitzeschutz-Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": "Protection contre la chaleur- accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Heat Protection Accessories"
}
}
],
"manufacturer": {
"id": "6a2b1e977d064ef692976607cd6c094a",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Goodridge",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Goodridge"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "4858f2c14b534b0eb7f8f09236fa8828",
"_count": 1,
"groupId": "51c3c358523e46819535c289de01d92a",
"group": {
"id": "51c3c358523e46819535c289de01d92a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "0,51 mm",
"5494b24b09d445ebace47112836b4458": "0,51 mm",
"de44571ddc4e4d0095c01af6ee299351": "0.51 mm"
}
}
],
"categoryIds": [
"184695505b9b47a0b883153457491a15",
"fd1c0181ed444be6a5899e6e8fb89318"
],
"optionIds": [
"4858f2c14b534b0eb7f8f09236fa8828"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "sicherheitsdraht-edelstahl-roedeldraht",
"migration_Shopware5DB_product_dreisc_seo_title": "Sicherheitsdraht Edelstahl",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"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_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Sicherheitsdraht Edelstahl",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Sicherheitsdraht Edelstahl",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sicherheitsdraht Edelstahl R\u00f6deldraht",
"5494b24b09d445ebace47112836b4458": "Fil de s\u00e9curit\u00e9 en acier inoxydable",
"de44571ddc4e4d0095c01af6ee299351": "Safety Wire (Lock wire)"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sicherheitsdraht extrem flexibel und hitzeresist nach Luftfahrtnorm. R\u00f6deldraht findet besonders bei Hitzeschutzprodukten und Sicherheitsrelevanten Schrauben Anwendung, die gegen ein ungewolltes L\u00f6sen gesichert werden m\u00fcssen wie z.B. in der \u00d6lwanne oder um den Turbolader. Der aus hochwertigem Edelstahl gefertigte Draht ist extrem Temperatur best\u00e4ndig und in verschiedenen St\u00e4rken verf\u00fcgbar. Sicherungsdraht kann auch zum Verplomben benutzt werden. Lieferung in Dose a 0,5kg. mit ca. 200 Meter L\u00e4nge. Folgende St\u00e4rken ausw\u00e4hlbar: 0,45mm \/ 0,51mm \/ 0,62mm \/ 0,81mm \/ 1,01mm Wir empfehlen dazu unsere Sicherungsdrahtzange.",
"5494b24b09d445ebace47112836b4458": "Fil de s\u00e9curit\u00e9 extr\u00eamement souple et r\u00e9sistant \u00e0 la chaleur selon les normes de l'aviation. Le R\u00f6deldraht est surtout utilis\u00e9 pour les produits de protection thermique et les vis de s\u00e9curit\u00e9 qui doivent \u00eatre prot\u00e9g\u00e9es contre tout desserrage involontaire, par exemple dans le carter d'huile ou autour du turbocompresseur. Le fil est fabriqu\u00e9 en acier inoxydable de haute qualit\u00e9, est extr\u00eamement r\u00e9sistant \u00e0 la temp\u00e9rature et est disponible en diff\u00e9rentes \u00e9paisseurs. Le fil de s\u00e9curit\u00e9 peut \u00e9galement \u00eatre utilis\u00e9 pour le scellement. Livraison en bo\u00eete de conserve de 0,5kg. avec une longueur d'environ 200 m\u00e8tres. Les \u00e9paisseurs suivantes peuvent \u00eatre s\u00e9lectionn\u00e9es : 0,45 mm \/ 0,51 mm \/ 0,62 mm \/ 0,81 mm \/ 1,01 mm Nous vous recommandons notre pince \u00e0 fil de s\u00e9curit\u00e9.",
"de44571ddc4e4d0095c01af6ee299351": "Lock wire in stainless steel quailty. Turn your wire quickly and proper into suitable threads. Lock wire should be used around heat suffering parts and where vibration can loose bolts or nuts. Please choose your needed diameter."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sicherheitsdraht Edelstahl",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Safety wire stainless steel"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 43.2,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 36.3,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 40.76,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 34.25,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 45.58,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 38.3,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 41.974789915966,
"shop-customer": "41.974789915966",
"b-dealer": "36.3",
"a-dealer": "34.25",
"c-dealer": "38.3"
},
"fields": {
"displayGroup": [
"80fa31b739f67b9d400a343f9c31c928"
]
},
"sort": [
"",
0,
"0b285bee7a044d9a90840321a2e8f9fc"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.93 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","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":"184695505b9b47a0b883153457491a15"}}}},{"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":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"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"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.de44571ddc4e4d0095c01af6ee299351.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.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"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": "184695505b9b47a0b883153457491a15"
}
}
}
},
{
"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": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"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"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|