| 1 |
5.14 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":"71f8f78aaa8440b5959b60db4ac1cd02"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": 0.0,
"hits": [
{
"_index": "sw64_product_1766773199",
"_id": "5b3234a95eef4916ad3f1aa52d427859",
"_score": 0.0,
"_source": {
"id": "5b3234a95eef4916ad3f1aa52d427859",
"autoIncrement": 35389.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 0,
"productNumber": [
"idea41144"
],
"ean": null,
"displayGroup": "66e7c27ef57b5c19b758d51bb3d343b9",
"sales": 0,
"stock": 0,
"weight": 760.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "12e306e17ba14e4293898f1ebd858f73",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2022-01-27T00:00:00+00:00",
"createdAt": "2025-07-06T15:26:21+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"cc2d7af391d5447399fddb95fa06ac8d"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "3ad565d349c04efa8956bb7b7b5cd86b",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
}
],
"manufacturer": {
"id": "12e306e17ba14e4293898f1ebd858f73",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"properties": [
{
"id": "0a301fad566c43a78b00ae55471a9991",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Out of print"
}
},
{
"id": "e856c479a89b4843b25d2592c766261a",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"cc2d7af391d5447399fddb95fa06ac8d"
],
"optionIds": [],
"propertyIds": [
"0a301fad566c43a78b00ae55471a9991",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"cd94a4cac79e4ee3929a6fe43e398c02"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "22564-tools.mp4",
"custom_product_author": "Cl\u00e9mentine Berry; Isabelle Moisy Cobti eds.",
"custom_product_isbn10": 2957876914.0,
"custom_product_isbn13": 9782957876914.0,
"custom_product_details": "248 p, ills colour & bw, 21 x 30 cm, pb, English",
"custom_product_ideacode": "ideacode22564"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #02 \u2013 To Weave",
"5ff02eab39254a219a0f0cbdf46d05bb": "Tools #02 \u2013 To Weave"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'Tools' magazine is the brainchild of Cl\u00e9mentine Berry, who also founded the Twice art direction studio in Paris. This annual publication aims to simultaneously promote and investigate the details of manufacturing techniques and expertise used in art, design, interior architecture, industry and trade. Each issue focuses on a particular technique (moulding, folding, etc.), and the theme is used to select feature subjects and pieces, as well as the persons interviewed. The second issue is dedicated to weaving.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #02 \u2013 To Weave - ISBN 9782957876914 - Tools Magazine - Cl\u00e9mentine Berry; Isabelle Moisy Cobti eds.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.95,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.65,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 23.65,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.0,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.6,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.6,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.5,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.5,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.7,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.7,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 28.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.1,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"66e7c27ef57b5c19b758d51bb3d343b9"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "7ef16eba71d54bb0aabc1c652f87b720",
"_score": 0.0,
"_source": {
"id": "7ef16eba71d54bb0aabc1c652f87b720",
"autoIncrement": 49220.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 14,
"productNumber": [
"idea44191"
],
"ean": null,
"displayGroup": "6ea4ca5edbd07ae3b7acd5658fc12e16",
"sales": 0,
"stock": 14,
"weight": 785.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "12e306e17ba14e4293898f1ebd858f73",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2024-09-16T00:00:00+00:00",
"createdAt": "2025-07-06T15:28:36+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "35c43cd6e22844bfa9a281330e5a5080",
"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": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
}
],
"manufacturer": {
"id": "12e306e17ba14e4293898f1ebd858f73",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine",
"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": "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": "e856c479a89b4843b25d2592c766261a",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"c5f551d7a5384d2d914493773e4f38e6",
"dcc27de28b734188b74c406cc16fe486",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"cd94a4cac79e4ee3929a6fe43e398c02"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "24608-tools.mp4",
"custom_product_author": "Cl\u00e9mentine Berry",
"custom_product_isbn10": 2957876930.0,
"custom_product_isbn13": 9782957876938.0,
"custom_product_details": "248 p, ills colour & bw, 21 x 30 cm, pb, French\/English",
"custom_product_ideacode": "ideacode24608"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #04 \u2013 To Cut",
"5ff02eab39254a219a0f0cbdf46d05bb": "Tools #04 \u2013 To Cut"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools magazine is the brainchild of Cl\u00e9mentine Berry, who also founded the Twice art direction studio in Paris. This annual publication aims to simultaneously promote and investigate the details of manufacturing techniques and expertise used in art, design, interior architecture, industry and trade. Each issue focuses on a particular technique (moulding, folding, etc.), and the theme is used to select feature subjects and pieces, as well as the persons interviewed. Tools is crafted as a comprehensive inventory of design techniques. Weaving together past and present, it draws on history to illustrate how techniques have been handed down through the ages, paying homage to the creators behind the cult objects we use in our everyday lives, and whose work embodies the stories that lie at the very genesis of our shared human ingenuity.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #04 \u2013 To Cut - ISBN 9782957876938 - Tools Magazine - Cl\u00e9mentine Berry",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.6,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.6,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 30.85,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.85,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 61.5,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 61.5,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 30.95,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.95,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.65,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.65,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.2,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.2,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 37.5,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 37.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.65,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.65,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"6ea4ca5edbd07ae3b7acd5658fc12e16"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "ab1c08a1e6974f4fb6e3eaf83b3cfd3b",
"_score": 0.0,
"_source": {
"id": "ab1c08a1e6974f4fb6e3eaf83b3cfd3b",
"autoIncrement": 66292.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": -5,
"productNumber": [
"idea43646"
],
"ean": null,
"displayGroup": "dd3b9f35f4b681de3b2f75ba9399f96d",
"sales": 0,
"stock": -5,
"weight": 755.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "12e306e17ba14e4293898f1ebd858f73",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2023-09-25T00:00:00+00:00",
"createdAt": "2025-07-06T15:31:20+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"cc2d7af391d5447399fddb95fa06ac8d"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "0dc041c9e9184f448c90e1f0819e4c7e",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
}
},
{
"id": "71f8f78aaa8440b5959b60db4ac1cd02",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
}
],
"manufacturer": {
"id": "12e306e17ba14e4293898f1ebd858f73",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools Magazine",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"_count": 1
},
"properties": [
{
"id": "0a301fad566c43a78b00ae55471a9991",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Out of print"
}
},
{
"id": "e856c479a89b4843b25d2592c766261a",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "fe011bcab5c04a66b2dac84ab9b52847",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
}
],
"options": [],
"categoryIds": [
"6e3eff42952a4a2e82bcebe949be0d92",
"71f8f78aaa8440b5959b60db4ac1cd02",
"cc2d7af391d5447399fddb95fa06ac8d",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"0a301fad566c43a78b00ae55471a9991",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"cd94a4cac79e4ee3929a6fe43e398c02"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_details": "248 p, ills colour & bw, 21 x 30 cm, pb, English\/French",
"custom_product_ideacode": "ideacode23298"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #03 - to Fold",
"5ff02eab39254a219a0f0cbdf46d05bb": "Tools #03 - to Fold"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "The third issue of the annual magazine that promotes know-how and technique in design, craft or industry, dedicated to folding. Tools magazine is the brainchild of Cl\u00e9mentine Berry. The magazine aims to simultaneously promote and investigate the details of manufacturing techniques and expertise used in art, design, interior architecture, industry and trade. Each issue focuses on a particular technique (moulding, folding, etc.), and the theme is used to select feature subjects and pieces, as well as the persons interviewed. Tools is crafted as a comprehensive inventory of design techniques. Weaving together past and present, it draws on history to illustrate how techniques have been handed down through the ages, paying homage to the creators behind the cult objects we use in our everyday lives, and whose work embodies the stories that lie at the very genesis of our shared human ingenuity.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tools #03 - to Fold - Tools Magazine",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.95,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.65,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.65,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.0,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.65,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 23.65,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 30.0,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 30.0,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.7,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.7,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.1,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.1,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"dd3b9f35f4b681de3b2f75ba9399f96d"
]
}
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.36 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":"71f8f78aaa8440b5959b60db4ac1cd02"}},{"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
|