1 |
48.13 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":"8b6e9888767a4600bf90b1969d90f9c8"}}}},{"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": 5,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 11,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0f3574c23406405ebb8efc9f9191b73f",
"_score": null,
"_source": {
"id": "0f3574c23406405ebb8efc9f9191b73f",
"autoIncrement": 58158.0,
"ratingAverage": 5.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 6,
"productNumber": "TK90008A.3",
"ean": null,
"displayGroup": "224eb1d22b38d04be1d50262596cf068",
"sales": 0,
"stock": 6,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "TK90008B",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"8b6e9888767a4600bf90b1969d90f9c8"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "8b6e9888767a4600bf90b1969d90f9c8",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "b58a08789b6545c2b77f0949411bcd76",
"coverId": "e52dfafa036b4d6198286371a03891e6",
"childCount": 0,
"categories": [
{
"id": "8b6e9888767a4600bf90b1969d90f9c8",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Adhesivo de temperatura",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Temperaturaufkleber",
"5494b24b09d445ebace47112836b4458": "Autocollant de temp\u00e9rature",
"de44571ddc4e4d0095c01af6ee299351": "Temperature Sticker"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "110310037fb0457a9132296c84214558",
"_count": 1,
"groupId": "9be00f53963f4193881324acb6c1d010",
"group": {
"id": "9be00f53963f4193881324acb6c1d010",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "166-204 \u00b0C",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "166\u2013204 \u00b0C",
"de44571ddc4e4d0095c01af6ee299351": "166\u2013204 \u00b0C"
}
}
],
"categoryIds": [
"8b6e9888767a4600bf90b1969d90f9c8"
],
"optionIds": [
"110310037fb0457a9132296c84214558"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "temperaturstreifen-temperaturaufkleber",
"migration_Shopware5DB_product_dreisc_seo_title": "Temperatur-Messstreifen 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Temperatur-Messstreifen 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Temperatur-Messstreifen 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Temperatur-Messstreifen 10 Stk.",
"5494b24b09d445ebace47112836b4458": "Bandes de mesure de la temp\u00e9rature 10 pcs.",
"de44571ddc4e4d0095c01af6ee299351": "Temperature Measuring Strips 10 pieces"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vertikale 8-Punkt Temperaturmessstreifen in den Ma\u00dfen 51 x 18 mm. Diese \u00f6l- und wasserdichten Messstreifen zeigen an, ob die Oberfl\u00e4che auf denen sie angebracht sind, eine bestimmte Temperatur erreicht hat. Dabei besteht jedes einzelne Messfeld aus einer speziellen Mischung organischer Chemikalien, die bei unterschiedlichen Temperaturen schmelzen und so einen Farbwechsel vollziehen.Sobald die Nominaltemperatur eines einzelnen Elements erreicht ist, f\u00e4rbt sich dieses dauerhaft ein. Damit k\u00f6nnen Sie jederzeit feststellen, ob ein Motorenteil eine gewisse Hitzeschwelle \u00fcberschritten hat.Eignet sich f\u00fcr Maschinen und maschinelle Einrichtungen, f\u00fcr elektrische Ausr\u00fcstungen, f\u00fcr elektronische Montagen und Komponenten, f\u00fcr Garantie-Nachweise sowie f\u00fcr Motorsport- und Kraftfahrzeugtechnik. Im Motorsport finden diese selbstklebenden Temperaturstreifen ihre Verwendung auf Motoren und Motorkomponenten, K\u00fchlsystemen, Bremsen, Hydraulik-Systemen und Schaltgetrieben. Die Messgenauigkeit liegt bei +\/- 1%. Die Temperaturstreifen sind in einem Heft mit 10 Messstreifen des gleichen Typs zusammengefasst. Made in Germany.",
"5494b24b09d445ebace47112836b4458": "Bandes verticales de mesure de la temp\u00e9rature en 8 points, mesurant 51 x 18 mm. Ces bandes de mesure imperm\u00e9ables \u00e0 l'huile et \u00e0 l'eau indiquent si la surface sur laquelle elles sont appliqu\u00e9es a atteint une certaine temp\u00e9rature. Chaque champ de mesure individuel est constitu\u00e9 d'un m\u00e9lange sp\u00e9cial de produits chimiques organiques qui fondent \u00e0 diff\u00e9rentes temp\u00e9ratures et changent donc de couleur. Cela vous permet de d\u00e9terminer \u00e0 tout moment si une pi\u00e8ce de moteur a d\u00e9pass\u00e9 un certain seuil de chaleur.convient aux machines et aux \u00e9quipements m\u00e9caniques, aux \u00e9quipements \u00e9lectriques, aux ensembles et composants \u00e9lectroniques, aux preuves de garantie et aux sports automobiles et \u00e0 la technologie automobile. Dans le sport automobile, ces bandes de temp\u00e9rature autocollantes sont utilis\u00e9es sur les moteurs et leurs composants, les syst\u00e8mes de refroidissement, les freins, les syst\u00e8mes hydrauliques et les transmissions manuelles. La pr\u00e9cision de mesure est de +\/- 1%. Les bandes de temp\u00e9rature sont combin\u00e9es dans un livret avec 10 bandes de mesure du m\u00eame type. Fabriqu\u00e9 en Allemagne.",
"de44571ddc4e4d0095c01af6ee299351": "Vertical 8-point temperature measuring strips measuring 51 x 18 mm.\n\nThese oil- and waterproof measuring strips indicate whether the surface to which they are attached has reached a certain temperature.\n\nEach individual measuring field consists of a special mixture of organic chemicals which melt at different temperatures and thus change color. As soon as the nominal temperature of an individual element is reached, it turns a permanent color.\n\nThis allows you to determine at any time whether an engine part has exceeded a certain heat threshold.Suitable for machinery and mechanical equipment, for electrical equipment, for electronic assemblies and components, for warranty evidence, as well as for motor sports and automotive engineering.\n\nIn motorsports, these self-adhesive temperature strips find their use on engines and engine components, cooling systems, brakes, hydraulic systems and manual transmissions.\n\nThe measuring accuracy is +\/- 1%.\n\nThe temperature strips are combined in a booklet with 10 measuring strips of the same type.\n\nMade in Germany."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Temperatur-Messstreifen 10 Stk.",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Temperature measuring strips 10 pcs."
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.7731085,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.065,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.5,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.12,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.55,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.605042,
"shop-customer": "17.605042",
"a-dealer": "12.7731085",
"b-dealer": "13.5",
"c-dealer": "13.55"
},
"fields": {
"displayGroup": [
"224eb1d22b38d04be1d50262596cf068"
]
},
"sort": [
"true",
0,
"0f3574c23406405ebb8efc9f9191b73f"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "268ab1ec2c1549698706ce7cd399c74e",
"_score": null,
"_source": {
"id": "268ab1ec2c1549698706ce7cd399c74e",
"autoIncrement": 51337.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 3,
"productNumber": "TKR90003.4",
"ean": null,
"displayGroup": "7e7c85543160712cb64d98b95e97c10a",
"sales": 0,
"stock": 3,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "385705f0da5a4d21ad2289eb3c1d9fb9",
"manufacturerNumber": "TKR90003",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cbbb14c819094376b33f3700d8787ff7",
"8b6e9888767a4600bf90b1969d90f9c8"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cbbb14c819094376b33f3700d8787ff7",
"_count": 1
},
{
"id": "8b6e9888767a4600bf90b1969d90f9c8",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "06ffaa048f1140dcb506f18d1e1544f5",
"coverId": "25569ab5582e40d2ad2a13edc401aa08",
"childCount": 0,
"categories": [
{
"id": "8b6e9888767a4600bf90b1969d90f9c8",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Adhesivo de temperatura",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Temperaturaufkleber",
"5494b24b09d445ebace47112836b4458": "Autocollant de temp\u00e9rature",
"de44571ddc4e4d0095c01af6ee299351": "Temperature Sticker"
}
}
],
"manufacturer": {
"id": "385705f0da5a4d21ad2289eb3c1d9fb9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DEI",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "DEI"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "b9024a7e236440a9b9f4f849a717ea33",
"_count": 1,
"groupId": "9be00f53963f4193881324acb6c1d010",
"group": {
"id": "9be00f53963f4193881324acb6c1d010",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "143-166 \u00b0C",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "143\u2013166 \u00b0C",
"de44571ddc4e4d0095c01af6ee299351": "143\u2013166 \u00b0C"
}
}
],
"categoryIds": [
"8b6e9888767a4600bf90b1969d90f9c8"
],
"optionIds": [
"b9024a7e236440a9b9f4f849a717ea33"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "temperaturmessstreifen-temperaturaufkleber-hitzeaufkleber",
"migration_Shopware5DB_product_dreisc_seo_title": "5-Felder Temperatur-Messspunkte 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "5-Felder Temperatur-Messspunkte 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "5-Felder Temperatur-Messspunkte 10 Stk.",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Felder Temperatur-Messspunkte 10 Stk.",
"5494b24b09d445ebace47112836b4458": "Points de mesure de la temp\u00e9rature \u00e0 5 champs 10 pcs.",
"de44571ddc4e4d0095c01af6ee299351": "Temperature Measurement Points 10 pieces"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Felder Mehrbereichs-Temperatur-Messpunkte 14 mm Durchmesser. Diese \u00f6l- und wasserdichten Messspunkte zeigen an, ob die Oberfl\u00e4che auf denen sie angebracht sind, eine bestimmte Temperatur erreicht hat. Dabei besteht jedes einzelne Messfeld aus einer speziellen Mischung organischer Chemikalien, die bei unterschiedlichen Temperaturen schmelzen und so einen Farbwechsel vollziehen. Sobald die Nominaltemperatur eines einzelnen Elements erreicht ist, f\u00e4rbt sich dieses dauerhaft ein. Damit k\u00f6nnen Sie jederzeit feststellen, ob ein Motorenteil eine gewisse Hitzeschwelle \u00fcberschritten hat. Eignet sich f\u00fcr Maschinen und maschinelle Einrichtungen, f\u00fcr elektrische Ausr\u00fcstungen, f\u00fcr elektronische Montagen und Komponenten, f\u00fcr Garantie-Nachweise sowie f\u00fcr Motorsport- und Kraftfahrzeugtechnik. Im Motorsport finden diese selbstklebenden Temperaturpunkte ihre Verwendung auf Motoren und Motorkomponenten, K\u00fchlsystemen, Bremsen, Hydraulik-Systemen und Schaltgetrieben. Die Messgenauigkeit liegt bei +\/- 1%. Die Temperaturpunkte sind in einem Heft mit 10 Messspunkten des gleichen Typs zusammengefasst. Made in Germany.",
"5494b24b09d445ebace47112836b4458": "Points de mesure de la temp\u00e9rature \u00e0 5 champs \u00e0 plages multiples de 14 mm de diam\u00e8tre. Ces points de mesure \u00e9tanches \u00e0 l'huile et \u00e0 l'eau indiquent si la surface sur laquelle ils sont appliqu\u00e9s a atteint une certaine temp\u00e9rature. Chaque champ de mesure individuel est constitu\u00e9 d'un m\u00e9lange sp\u00e9cial de produits chimiques organiques qui fondent \u00e0 diff\u00e9rentes temp\u00e9ratures et changent donc de couleur. D\u00e8s que la temp\u00e9rature nominale d'un seul \u00e9l\u00e9ment est atteinte, celui-ci change de couleur de fa\u00e7on permanente. Cela vous permet de d\u00e9terminer \u00e0 tout moment si une pi\u00e8ce du moteur a d\u00e9pass\u00e9 un certain seuil de chaleur. Convient aux machines et aux \u00e9quipements m\u00e9caniques, aux \u00e9quipements \u00e9lectriques, aux ensembles et composants \u00e9lectroniques, aux certificats de garantie, ainsi qu'au sport automobile et \u00e0 la technologie automobile. Dans le sport automobile, ces points de temp\u00e9rature autocollants sont utilis\u00e9s sur les moteurs et leurs composants, les syst\u00e8mes de refroidissement, les freins, les syst\u00e8mes hydrauliques et les transmissions manuelles. La pr\u00e9cision de mesure est de +\/- 1%. Les points de temp\u00e9rature sont combin\u00e9s dans un livret avec 10 points de mesure du m\u00eame type. Fabriqu\u00e9 en Allemagne.",
"de44571ddc4e4d0095c01af6ee299351": "5-field multi-range temperature measuring points, 14 mm diameter.\n\nThese oil- and waterproof measuring points indicate whether the surface on which they are placed has reached a certain temperature.\n\nEach individual measuring spot consists of a special mixture of organic chemicals that melt at different temperatures, resulting in a color change. Once the nominal temperature of an individual element is reached, it turns a permanent color. This allows you to determine at any time whether an engine part has exceeded a certain heat threshold.\n\nSuitable for machinery and mechanical equipment, for electrical equipment, for electronic assemblies and components, for warranty evidence, as well as for motor sports and automotive engineering. In motor sports, these self-adhesive temperature points are used on engines and engine components, cooling systems, brakes, hydraulic systems and manual transmissions.\n\nThe measuring accuracy is +\/- 1%.\n\nThe temperature points are combined in a booklet with 10 measuring points of the same type.\n\nMade in Germany.\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Felder Temperatur-Messspunkte 10 Stk.",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Temperature Measurement Points 10 pieces"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.22,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.95,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.51,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.35,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.73,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.403361344538,
"shop-customer": "13.403361344538",
"c-dealer": "11.95",
"b-dealer": "11.35",
"a-dealer": "10.7"
},
"fields": {
"displayGroup": [
"7e7c85543160712cb64d98b95e97c10a"
]
},
"sort": [
"",
0,
"268ab1ec2c1549698706ce7cd399c74e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
4.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":"8b6e9888767a4600bf90b1969d90f9c8"}}}},{"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": "8b6e9888767a4600bf90b1969d90f9c8"
}
}
}
},
{
"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"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|