| 1 |
5.86 ms |
Request:
{"index":"sw64_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_0a197278a7514b78a06ea27ef27e9ef8":{"gte":30}}}]}},{"term":{"categoryTree":"87f7a9fb04fc4fa58d8e634c43f591e5"}},{"exists":{"field":"displayGroup"}}]}}]}},"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": 2,
"relation": "eq"
},
"max_score": 0.0,
"hits": [
{
"_index": "sw64_product_1766773199",
"_id": "72f2f4130d204d1c9d4c9567d83b9200",
"_score": 0.0,
"_source": {
"id": "72f2f4130d204d1c9d4c9567d83b9200",
"autoIncrement": 44581.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 19,
"productNumber": [
"idea44210"
],
"ean": null,
"displayGroup": "b5cbc3d9bd6420a52360b7f24c84ac7a",
"sales": 0,
"stock": 19,
"weight": 810.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "a74e7f000a4c4076b2ead286fed72b59",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2023-10-05T00:00:00+00:00",
"createdAt": "2025-07-06T15:27:53+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"87f7a9fb04fc4fa58d8e634c43f591e5",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "87f7a9fb04fc4fa58d8e634c43f591e5",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "409d14005e1c488ea95b55120d57ecfb",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "87f7a9fb04fc4fa58d8e634c43f591e5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic"
}
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Backlist"
}
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "a74e7f000a4c4076b2ead286fed72b59",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Propaganda",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"properties": [
{
"id": "20b459452a4d4bb094212595f9aacebe",
"_count": 1,
"groupId": "7fae9fcca1ca4dd380d752b0bd986bdf",
"group": {
"id": "7fae9fcca1ca4dd380d752b0bd986bdf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
}
},
{
"id": "3ee7068fe9564e41bfc26ad188d97bb3",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typograpy"
}
},
{
"id": "c5f551d7a5384d2d914493773e4f38e6",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"e48c5bbb925743738191576449c97a13": "Backlist",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Published"
}
},
{
"id": "dcc27de28b734188b74c406cc16fe486",
"_count": 1,
"groupId": "dc5c641ae4c3464c8cc461b68e268293",
"group": {
"id": "dc5c641ae4c3464c8cc461b68e268293",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"6e3eff42952a4a2e82bcebe949be0d92",
"87f7a9fb04fc4fa58d8e634c43f591e5",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"c5f551d7a5384d2d914493773e4f38e6",
"dcc27de28b734188b74c406cc16fe486",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"3f8787ef579f43648bd6b95816148def",
"4b68809fee814c7aa6907b9fb102d7dc",
"a819207cf9b64fe2997a42d413d845d4"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "23656-graphic50.mp4",
"custom_product_author": "various",
"custom_product_details": "264 p, ills bw, 23 x 30 cm, pb, Korean\/English",
"custom_product_ideacode": "ideacode23656"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic 50: Voice, Notes from Typojanchi 2023",
"5ff02eab39254a219a0f0cbdf46d05bb": "Graphic 50: Voice, Notes from Typojanchi 2023"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "The 50th issue of \u2018Graphic\u2019 is published as a collaborative project with the 2023 Typojanchi International Typography Biennale, \u201cOpen Quotation Marks, Close Quotation Marks\u201d. Its theme is typography and sound. Featuring works and writings that inspired the Typojanchi exhibition team and works and notes by participating artists, the magazine presents this content in a fragmentary manner. Much of this, however, is neither displayed in the exhibition nor put in the exhibition catalogue. The contents overlap, but are also misaligned. The structure is therefore similar Typojanchi 2023, which, rather than establishing formal ways to represent material, follows an internal rhythm or necessity.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic 50: Voice, Notes from Typojanchi 2023 - Propaganda - various",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.3,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.3,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.5,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.5,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 64.5,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 64.5,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.65,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.65,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.5,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 30.95,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.95,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.35,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.35,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.95,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 28.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 28.95,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"b5cbc3d9bd6420a52360b7f24c84ac7a"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "f1115947762246d5aaf13aa09205915b",
"_score": 0.0,
"_source": {
"id": "f1115947762246d5aaf13aa09205915b",
"autoIncrement": 93503.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": -1,
"productNumber": [
"idea40247"
],
"ean": null,
"displayGroup": "5968cf0bfd4901305ad5370cf3ca8514",
"sales": 0,
"stock": -1,
"weight": 1277.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "a74e7f000a4c4076b2ead286fed72b59",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2021-06-17T00:00:00+00:00",
"createdAt": "2025-07-06T15:35:42+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"87f7a9fb04fc4fa58d8e634c43f591e5",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "87f7a9fb04fc4fa58d8e634c43f591e5",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "aa0e234546bb4f2fbf737ff5dd518151",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "87f7a9fb04fc4fa58d8e634c43f591e5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic"
}
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Backlist"
}
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "a74e7f000a4c4076b2ead286fed72b59",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Propaganda",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"properties": [
{
"id": "20b459452a4d4bb094212595f9aacebe",
"_count": 1,
"groupId": "7fae9fcca1ca4dd380d752b0bd986bdf",
"group": {
"id": "7fae9fcca1ca4dd380d752b0bd986bdf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
}
},
{
"id": "3ee7068fe9564e41bfc26ad188d97bb3",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typograpy"
}
},
{
"id": "c5f551d7a5384d2d914493773e4f38e6",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"e48c5bbb925743738191576449c97a13": "Backlist",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Published"
}
},
{
"id": "dcc27de28b734188b74c406cc16fe486",
"_count": 1,
"groupId": "dc5c641ae4c3464c8cc461b68e268293",
"group": {
"id": "dc5c641ae4c3464c8cc461b68e268293",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"6e3eff42952a4a2e82bcebe949be0d92",
"87f7a9fb04fc4fa58d8e634c43f591e5",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"c5f551d7a5384d2d914493773e4f38e6",
"dcc27de28b734188b74c406cc16fe486",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"3f8787ef579f43648bd6b95816148def",
"4b68809fee814c7aa6907b9fb102d7dc",
"a819207cf9b64fe2997a42d413d845d4"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "21325-graphic47currentissue.mp4",
"custom_product_isbn10": 0.0,
"custom_product_isbn13": 0.0,
"custom_product_details": "200 , ills colour & bw, 23 x 30 cm, box, Korean\/English",
"custom_product_ideacode": "ideacode21325"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic 47: Current Issue",
"5ff02eab39254a219a0f0cbdf46d05bb": "Graphic 47: Current Issue"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u2018Graphic\u2019 invited ten teams that approach topical social issues from various angles, providing them with sixteen pages to convey their areas of research. For some, this is a report, chronology, or journal, while others choose talks, interviews, or colouring books to reinforce their arguments. The teams all share the same kind of critical mind in their search for appropriate means of expression. Three short essays which expand upon the topics raised are also included. Emerging from different backgrounds and thematic concerns, they nevertheless give rise to constructive discussion. Rather than appearing as a single volume, the contributions are bound separately like brochures or flyers.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic 47: Current Issue - Propaganda",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 35.2,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 35.2,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 36.8,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 36.8,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 73.5,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 73.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 45.0,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 45.0,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 36.7,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 36.7,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 37.1,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 37.1,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 30.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.0,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.9,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 32.9,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"5968cf0bfd4901305ad5370cf3ca8514"
]
}
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.82 ms |
Request:
{"index":"sw64_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_0a197278a7514b78a06ea27ef27e9ef8":{"gte":30}}}]}},{"term":{"categoryTree":"87f7a9fb04fc4fa58d8e634c43f591e5"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule11c3ef6d5d97449d9b62e33e38f6d372_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule46c2cfb0bf07427a86929107eea988db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec21b551eb6014165bac73b68f2030e9c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec5e4d29334d147fda9b28cc58bff0604_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee43d962ef8364182bb743202cdb17c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef205ab57b6e343ca8d4614231ef10ef1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee0cf15b6d9364300942b4e1af482796d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|