| 1 |
4.09 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":"966242f552464b86b7fd1928ef2a1d2b"}}}},{"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": 18,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "018ff45795b6482ba3fa74a2472b7f38",
"_score": null,
"_source": {
"id": "018ff45795b6482ba3fa74a2472b7f38",
"autoIncrement": 45386.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ma002",
"ean": null,
"displayGroup": "d57e0d8e439b24a88e6cac21fb8c9721",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1ac4e5de8df54c318331a27442a1a52d",
"manufacturerNumber": "WC4568-027",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"305cc59fcd2445438f6b263eb3c59613",
"47e1b3a06fd54c6b85a2353e2bf052e9",
"966242f552464b86b7fd1928ef2a1d2b"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "305cc59fcd2445438f6b263eb3c59613",
"_count": 1
},
{
"id": "47e1b3a06fd54c6b85a2353e2bf052e9",
"_count": 1
},
{
"id": "966242f552464b86b7fd1928ef2a1d2b",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "956d383e7ed0430ebfcc15120125126b",
"coverId": "4e15e9a0150146d9a7098a487b37a1af",
"childCount": 0,
"categories": [
{
"id": "966242f552464b86b7fd1928ef2a1d2b",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Mazda",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mazda",
"5494b24b09d445ebace47112836b4458": "Mazda"
}
}
],
"manufacturer": {
"id": "1ac4e5de8df54c318331a27442a1a52d",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "cometic",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "cometic"
},
"_count": 1
},
"properties": [
{
"id": "24d57c459d95420bb5c9bf27908f0a06",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BPT | 180 PS (132 kW)",
"5494b24b09d445ebace47112836b4458": "BPT | 180 ch (132 kW)",
"de44571ddc4e4d0095c01af6ee299351": "BPT | 180 hp (132 kW)"
}
},
{
"id": "7335faca01a3445d9e810cec2e432689",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mazda",
"5494b24b09d445ebace47112836b4458": "Mazda",
"de44571ddc4e4d0095c01af6ee299351": "Mazda"
}
},
{
"id": "81a5f9719b00448e804c0fdde1fa0f1c",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8 DOHC 16V R4 (MZR)",
"5494b24b09d445ebace47112836b4458": "1.8 DOHC 16V R4 (MZR)",
"de44571ddc4e4d0095c01af6ee299351": "1.8 DOHC 16V R4 (MZR)"
}
},
{
"id": "84b8d4cb9294484abf50e58b460bbaf2",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "323",
"5494b24b09d445ebace47112836b4458": "323",
"de44571ddc4e4d0095c01af6ee299351": "323"
}
},
{
"id": "91e295aa751249dd821abdc023e4b5c2",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8 T 16V R4 (BPT)",
"5494b24b09d445ebace47112836b4458": "1.8 T 16V R4 (BPT)",
"de44571ddc4e4d0095c01af6ee299351": "1.8 T 16V R4 (BPT)"
}
},
{
"id": "d18daf5d3683433186f4238f49479401",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "Type NC | BJ 2005-2015",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Typ NC | BJ 2005\u20132015",
"de44571ddc4e4d0095c01af6ee299351": "Type NC | Year built 2005\u20132015"
}
},
{
"id": "d8cf8dc3e1f9457e924de3929219b1e4",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Typ BG | BJ 1989-1994",
"5494b24b09d445ebace47112836b4458": "Type BG | BJ 1989-1994",
"de44571ddc4e4d0095c01af6ee299351": "Type BG | Year built 1989-1994"
}
},
{
"id": "e946c3106c7745868fc4244a4bbc2c05",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MX-5",
"5494b24b09d445ebace47112836b4458": "MX-5",
"de44571ddc4e4d0095c01af6ee299351": "MX-5"
}
},
{
"id": "f0d3c21139db4f6887d1afd739af8d0e",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L8-DE | 126 PS (93 kW)",
"de44571ddc4e4d0095c01af6ee299351": "L8-DE | 126 hp (93 kW)",
"5494b24b09d445ebace47112836b4458": "L8-FR | 126 ch (93 kW)"
}
}
],
"options": [
{
"id": "537578164f114100b76f72ef73f4794d",
"_count": 1,
"groupId": "51c3c358523e46819535c289de01d92a",
"group": {
"id": "51c3c358523e46819535c289de01d92a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "0,69 mm",
"5494b24b09d445ebace47112836b4458": "0,69 mm",
"de44571ddc4e4d0095c01af6ee299351": "0.69 mm"
}
}
],
"categoryIds": [
"966242f552464b86b7fd1928ef2a1d2b"
],
"optionIds": [
"537578164f114100b76f72ef73f4794d"
],
"propertyIds": [
"24d57c459d95420bb5c9bf27908f0a06",
"7335faca01a3445d9e810cec2e432689",
"81a5f9719b00448e804c0fdde1fa0f1c",
"84b8d4cb9294484abf50e58b460bbaf2",
"91e295aa751249dd821abdc023e4b5c2",
"d18daf5d3683433186f4238f49479401",
"d8cf8dc3e1f9457e924de3929219b1e4",
"e946c3106c7745868fc4244a4bbc2c05",
"f0d3c21139db4f6887d1afd739af8d0e"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Zylinderkopfdichtung",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "hohe Druckstabilit\u00e4t",
"migration_Shopware5DB_product_bullet3": "optimale Verdichtung",
"migration_Shopware5DB_product_bullet4": "bessere W\u00e4rmeleitf\u00e4higkeit",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "mazda-bp-1-8l-dohc-zylinderkopfdichtung",
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Zylinderkopfdichtung f\u00fcr deinen Mazda 1.8L DOHC",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Zylinderkopfdichtung",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "hohe Druckstabilit\u00e4t",
"migration_Shopware5DB_product_bullet3": "optimale Verdichtung",
"migration_Shopware5DB_product_bullet4": "bessere W\u00e4rmeleitf\u00e4higkeit",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Zylinderkopfdichtung f\u00fcr deinen Mazda 1.8L DOHC",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "cylinder head gasket",
"migration_Shopware5DB_product_bullet1": "high boost",
"migration_Shopware5DB_product_bullet2": "high pressure stability",
"migration_Shopware5DB_product_bullet3": "optimal compaction",
"migration_Shopware5DB_product_bullet4": "better thermal conductivity",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "renault-clio-williams-race-cylinderhead-gasket-83mm",
"migration_Shopware5DB_product_dreisc_seo_title": "Cometic Zylinderkopfdichtung f\u00fcr deinen Mazda 1.8L DOHC",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mazda BP 1.8L DOHC Zylinderkopfdichtung",
"5494b24b09d445ebace47112836b4458": "Joint de culasse pour Mazda BP 1,8L DHC",
"de44571ddc4e4d0095c01af6ee299351": "Mazda BP 1.8L DOHC Cylinder Head Gasket"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zylinderkopfdichtung f\u00fcr Mazda 1.8L DOHC (Baujahr 1994 bis 1997) mit den Motorcodes BP, BPT, BP-4W und BP-Z3.\n\n84,00mm Bohrung\n0,69mm bis 3,56mm St\u00e4rke\n\nDiese Kopfdichtungen kommen besonders bei Hochleistungsmotoren im Formel und Rally Sport zum Einsatz. Durch die spezielle Zusammensetzung aus verschiedenen Metall Mehrlagen wird nicht nur eine weit aus bessere W\u00e4rmeleitf\u00e4higkeit erreicht, sondern auch die Druckstabilit\u00e4t wird enorm erh\u00f6ht! Es sollten auf jeden Fall neue Kopfschrauben mitverwendet werden! Oder noch besser ARP Stehbolzen.",
"5494b24b09d445ebace47112836b4458": "Joint de culasse pour Mazda 1,8L DACT (construit de 1994 \u00e0 1997) avec les codes moteur BP, BPT, BP-4W et BP-Z3.\n\n84,00mm d'al\u00e9sage\n\u00c9paisseur de 0,69 mm \u00e0 3,56 mm\n\nCes joints de culasse sont surtout utilis\u00e9s pour les moteurs de haute performance en Formule et Rallye sportif. Gr\u00e2ce \u00e0 la composition sp\u00e9ciale des diff\u00e9rentes couches m\u00e9talliques, on obtient non seulement une bien meilleure conductivit\u00e9 thermique, mais aussi une stabilit\u00e9 de la pression consid\u00e9rablement accrue ! De nouvelles vis \u00e0 t\u00eate creuse devraient \u00eatre utilis\u00e9es dans tous les cas !Ou encore mieux, des goujons ARP. ",
"de44571ddc4e4d0095c01af6ee299351": "Cylinder head gasket for Mazda 1.8L DOHC (year 1994 to 1997) with engine codes BP, BPT, BP-4W and BP-Z3.84.00mm bore0,69mmto 3,56mm thicknessThese head gaskets are used especially for high performance engines in formula and rally sports. Due to the special composition of different metal multilayers, not only a far better thermal conductivity is achieved, but also the pressure stability is increased enormously!In any case, new head screws should be used!\nOr even better ARP stud bolts."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BMW 2.0L 8V M10B20 Race Metall Zylinderkopfdichtung",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Renault Clio Williams Race Cylinderhead Gasket MLS 83.00mm"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mehrschichtig gepr\u00e4gte Edelstahldichtung mit Kautschuk-Deckschicht. \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Multilayered stainless steel seal with rubber cover layer. \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae approved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 121.26,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 101.9,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 138.58,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 116.45714285714,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 129.35,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 108.69333333333,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 194.02,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 163.04201680672,
"shop-customer": "163.04201680672",
"a-dealer": "101.9",
"c-dealer": "116.45714285714",
"b-dealer": "108.69333333333"
},
"fields": {
"displayGroup": [
"d57e0d8e439b24a88e6cac21fb8c9721"
]
},
"sort": [
"",
0,
"018ff45795b6482ba3fa74a2472b7f38"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.64 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":"966242f552464b86b7fd1928ef2a1d2b"}}}},{"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": "966242f552464b86b7fd1928ef2a1d2b"
}
}
}
},
{
"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": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"isAvailable-filter": {
"doc_count": 18,
"isAvailable": {
"value": 0.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": "1ac4e5de8df54c318331a27442a1a52d",
"doc_count": 18
}
]
},
"customPrice-100-300": {
"doc_count": 16,
"customPrice-100-300": {
"value": 16
}
},
"properties-filter": {
"doc_count": 162,
"properties-filter": {
"doc_count": 0,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
},
"isUniversal-filter": {
"doc_count": 0,
"isUniversal": {
"value": null
}
},
"customPrice-700-900": {
"doc_count": 0,
"customPrice-700-900": {
"value": 0
}
},
"customPrice-3-100": {
"doc_count": 0,
"customPrice-3-100": {
"value": 0
}
},
"options-filter": {
"doc_count": 18,
"options-filter": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
}
},
"price": {
"count": 18,
"min": 194.02,
"max": 401.17,
"avg": 250.39500000000004,
"sum": 4507.110000000001
},
"options": {
"doc_count": 18,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "05ea320d70ef4873837be2d509fc94e2",
"doc_count": 1
},
{
"key": "065ed8f56b4a4addb1897cab31943336",
"doc_count": 1
},
{
"key": "29f3cd89c814491cb2172fb1306e498f",
"doc_count": 1
},
{
"key": "37fd24ff57ca44dc87e0fedaa2a86676",
"doc_count": 1
},
{
"key": "537578164f114100b76f72ef73f4794d",
"doc_count": 1
},
{
"key": "60e3b2bc51b64ad181160018072a5afe",
"doc_count": 1
},
{
"key": "663981d8103e4b888a34fc04efc33e04",
"doc_count": 1
},
{
"key": "737a782e019f4e96ab2468ba6d0bf3c0",
"doc_count": 1
},
{
"key": "7acb824da4264dbf84a4a3034b4a8efb",
"doc_count": 1
},
{
"key": "7be6e078ce314b24a5fd63a8231f61c0",
"doc_count": 1
},
{
"key": "83827429fd5140ddadc44e08a5dd22f9",
"doc_count": 1
},
{
"key": "acef0c3b08884e9fac7ab97f268fa2f5",
"doc_count": 1
},
{
"key": "b58696eaf17b451e914a1eda9df3477c",
"doc_count": 1
},
{
"key": "bb2773d9e81541d4aa05df5b49e46ba6",
"doc_count": 1
},
{
"key": "c999577d501b4f08805b24fdfa7966dc",
"doc_count": 1
},
{
"key": "e8e4cfc30d0b4bddb88f48da4b393b83",
"doc_count": 1
},
{
"key": "f1b4121f20a14e98b4ddbcc1f389b4d8",
"doc_count": 1
},
{
"key": "fc8a4c8409804696b61e2b8804feca02",
"doc_count": 1
}
]
}
},
"customPrice-300-500": {
"doc_count": 2,
"customPrice-300-500": {
"value": 2
}
},
"properties": {
"doc_count": 162,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "24d57c459d95420bb5c9bf27908f0a06",
"doc_count": 18
},
{
"key": "7335faca01a3445d9e810cec2e432689",
"doc_count": 18
},
{
"key": "81a5f9719b00448e804c0fdde1fa0f1c",
"doc_count": 18
},
{
"key": "84b8d4cb9294484abf50e58b460bbaf2",
"doc_count": 18
},
{
"key": "91e295aa751249dd821abdc023e4b5c2",
"doc_count": 18
},
{
"key": "d18daf5d3683433186f4238f49479401",
"doc_count": 18
},
{
"key": "d8cf8dc3e1f9457e924de3929219b1e4",
"doc_count": 18
},
{
"key": "e946c3106c7745868fc4244a4bbc2c05",
"doc_count": 18
},
{
"key": "f0d3c21139db4f6887d1afd739af8d0e",
"doc_count": 18
}
]
}
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|