| 1 |
6.12 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":"0efcf6aedbb54d1287d9a1badffe78b3"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":24,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 26,
"relation": "eq"
},
"max_score": 0.0,
"hits": [
{
"_index": "sw64_product_1766773199",
"_id": "e64ad7c8a94742588cb9cf1543244d2b",
"_score": 0.0,
"_source": {
"id": "e64ad7c8a94742588cb9cf1543244d2b",
"autoIncrement": 88783.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 0,
"productNumber": [
"idea46659"
],
"ean": null,
"displayGroup": "ce9d20d715552431d41b83370337ca98",
"sales": 0,
"stock": 0,
"weight": 93.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "3594c9b766a0415bb4934d73f3318647",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2025-05-22T00:00:00+00:00",
"createdAt": "2025-07-06T15:34:59+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"0efcf6aedbb54d1287d9a1badffe78b3",
"6e3eff42952a4a2e82bcebe949be0d92",
"7c4a624a63984305b8b67a25b23500b8",
"871ff6be29d644769a48a80edf94caf3",
"a5c980155c184082a0df846741795aae",
"fce8cf8062c5453097c77b2b818a4102"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "0efcf6aedbb54d1287d9a1badffe78b3",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "7c4a624a63984305b8b67a25b23500b8",
"_count": 1
},
{
"id": "871ff6be29d644769a48a80edf94caf3",
"_count": 1
},
{
"id": "a5c980155c184082a0df846741795aae",
"_count": 1
},
{
"id": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "9dd65f9ca304415593688b9b675d1eff",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "7c4a624a63984305b8b67a25b23500b8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New"
}
},
{
"id": "a5c980155c184082a0df846741795aae",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Art"
}
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
}
},
{
"id": "0efcf6aedbb54d1287d9a1badffe78b3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Zines"
}
},
{
"id": "871ff6be29d644769a48a80edf94caf3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Photography"
}
},
{
"id": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Popular Culture"
}
}
],
"manufacturer": {
"id": "3594c9b766a0415bb4934d73f3318647",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Press",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"properties": [
{
"id": "548e1938d6c246b390d6705d6eb6da63",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"e48c5bbb925743738191576449c97a13": "New",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New edition"
}
},
{
"id": "61134b1440d745aab15d9df42b52cb8f",
"_count": 1,
"groupId": "a3320773e956483f955c7bcebf5d9a60",
"group": {
"id": "a3320773e956483f955c7bcebf5d9a60",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
}
},
{
"id": "6bd057dfceb74fdba50c6b780d0a79c6",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Photography"
}
},
{
"id": "b4cf7c34ec274e7db16071f158df3623",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Popular Culture"
}
},
{
"id": "cc75c58f6b354677bccff2ab202c3eae",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Art"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"0efcf6aedbb54d1287d9a1badffe78b3",
"6e3eff42952a4a2e82bcebe949be0d92",
"7c4a624a63984305b8b67a25b23500b8",
"871ff6be29d644769a48a80edf94caf3",
"a5c980155c184082a0df846741795aae",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"fce8cf8062c5453097c77b2b818a4102"
],
"optionIds": [],
"propertyIds": [
"548e1938d6c246b390d6705d6eb6da63",
"61134b1440d745aab15d9df42b52cb8f",
"6bd057dfceb74fdba50c6b780d0a79c6",
"b4cf7c34ec274e7db16071f158df3623",
"cc75c58f6b354677bccff2ab202c3eae",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"00657f53f1ba4a1a8029ebe10fcfb409",
"4b68809fee814c7aa6907b9fb102d7dc",
"9d5af39270144ad380af61892be1a0d3"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "250406-yuyi.mp4",
"custom_product_author": "John Yuyi",
"custom_product_isbn10": 1910239550.0,
"custom_product_isbn13": 9781910239551.0,
"custom_product_details": "22 p, ills colour, 20 x 28 cm, pb, English",
"custom_product_ideacode": "ideacode250406"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato zines 51 John Yuyi - POV",
"5ff02eab39254a219a0f0cbdf46d05bb": "Hato zines 51 John Yuyi - POV"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Taiwan-born artist John Yuyi grew up immersed in the post-Internet generation, and this experience deeply informed her artistic practice. Often seen as a leading interdisciplinary voice in art, fashion, and social media, Yuyi's work frequently delves into millennial depictions of the female body, alongside her keen ability to explore, harness, and reflect on the impact of social media. Since the summer of 2022, Yuyi's been living a nomadic lifestyle, constantly subletting different places. She thought it\u2019d be fun to document all the homes she stayed in, so she decided to take a POV photo every day last year \u2014 but gave up after a month. What remains is a fragmented yet intimate diary\u2014part travelogue, part self-portrait\u2014capturing glimpses of ceilings, microwaves, toilet bowls, and cats. POV is both a record of where Yuyi\u2019s body was, and a meditation on where her mind wandered. Yuyi frequently engages with mass media iconography, using her own body as a projection surface to explore themes of self-identity and the economics of identity.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato zines 51 John Yuyi - POV - ISBN 9781910239551 - Hato Press - John Yuyi",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.35,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.35,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.8,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.8,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.7,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.7,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.6,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.6,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.5,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 43.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 43.0,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.55,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.55,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.5,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.35,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.35,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"ce9d20d715552431d41b83370337ca98"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "f64543fda9c5441fb1fc9e8d90859142",
"_score": 0.0,
"_source": {
"id": "f64543fda9c5441fb1fc9e8d90859142",
"autoIncrement": 95535.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 2,
"productNumber": [
"idea42888"
],
"ean": null,
"displayGroup": "719db772a12009a8324cda9a9b6dc070",
"sales": 0,
"stock": 2,
"weight": 22.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "3594c9b766a0415bb4934d73f3318647",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2022-11-16T00:00:00+00:00",
"createdAt": "2025-07-06T15:36:01+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"0efcf6aedbb54d1287d9a1badffe78b3",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289",
"fce8cf8062c5453097c77b2b818a4102"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "0efcf6aedbb54d1287d9a1badffe78b3",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
},
{
"id": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "bdfdfde879a141eba7534f165d239f2c",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Backlist"
}
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
}
},
{
"id": "0efcf6aedbb54d1287d9a1badffe78b3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Zines"
}
},
{
"id": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Popular Culture"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "3594c9b766a0415bb4934d73f3318647",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Press",
"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": "b4cf7c34ec274e7db16071f158df3623",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Popular Culture"
}
},
{
"id": "c5f551d7a5384d2d914493773e4f38e6",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"e48c5bbb925743738191576449c97a13": "Backlist",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Published"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"0efcf6aedbb54d1287d9a1badffe78b3",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"fce8cf8062c5453097c77b2b818a4102"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"b4cf7c34ec274e7db16071f158df3623",
"c5f551d7a5384d2d914493773e4f38e6",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"00657f53f1ba4a1a8029ebe10fcfb409",
"4b68809fee814c7aa6907b9fb102d7dc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "22697-fungal.mp4",
"custom_product_author": "Rapha\u00ebl Bastide",
"custom_product_details": "16 p, ills colour & bw, 15 x 20 cm, pb, English",
"custom_product_ideacode": "ideacode22697"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Zines 31 - Fungal by Rapha\u00ebl Bastide",
"5ff02eab39254a219a0f0cbdf46d05bb": "Hato Zines 31 - Fungal by Rapha\u00ebl Bastide"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\"Fungal is a homage to Wikipedia, one of the greatest website of the World Wide Web. This collaborative encyclopedia is now 21 years old, and I am still fascinated how it changed our relationship to knowledge. It also represents a comforting example of what humanity can do: collaborating voluntarily on the largest knowledge project in our history. (...) My work quickly focused on how to create organic ornaments, affecting the encyclopedia\u2019s interface, its typography, the figures and the Wikipedia logo itself. I asked my friend J\u00e9r\u00e9my Landes to collaborate on the design of a libre font forked from DejaVu Sans, able to spread like mycelium thanks to the variable technology.\" \u2014 Rapha\u00ebl Bastide",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hato Zines 31 - Fungal by Rapha\u00ebl Bastide - Hato Press - Rapha\u00ebl Bastide",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.6,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.6,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.0,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.7,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.7,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.5,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.0,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.55,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.55,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.25,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.25,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.05,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.05,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.25,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.25,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"719db772a12009a8324cda9a9b6dc070"
]
}
}
]
},
"aggregations": {
"total-count": {
"value": 26
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.45 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":"0efcf6aedbb54d1287d9a1badffe78b3"}},{"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
|