| 1 |
11.88 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":"cc2d7af391d5447399fddb95fa06ac8d"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":192,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 6,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 197,
"relation": "eq"
},
"max_score": 0.0,
"hits": [
{
"_index": "sw64_product_1766773199",
"_id": "72a71a8cb9104a1dab7bcf36c59f800f",
"_score": 0.0,
"_source": {
"id": "72a71a8cb9104a1dab7bcf36c59f800f",
"autoIncrement": 175620.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 46,
"productNumber": [
"idea31065"
],
"ean": null,
"displayGroup": "189b89cac4552ad2a203391af14a4328",
"sales": 0,
"stock": 46,
"weight": 95.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9b4aac95e66e4d1db46821667ba50f14",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2014-05-20T00:00:00+00:00",
"createdAt": "2025-07-22T17:37:43+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "7967d98382804d669b09707dafde4e9e",
"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": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "9b4aac95e66e4d1db46821667ba50f14",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Atelier Hoko",
"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": "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",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"c5f551d7a5384d2d914493773e4f38e6",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"5a9a1411b7324c3c8e88c5032af10ac7"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "14331.sciencecup.mp4",
"custom_product_author": "Alvin Ho ; Clara Koh",
"custom_product_isbn10": 9810798768.0,
"custom_product_isbn13": 9789810798765.0,
"custom_product_details": "52 p, ills colour & bw, 18 x 25 cm, pb, English",
"custom_product_ideacode": "ideacode14331"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 2: Cup",
"5ff02eab39254a219a0f0cbdf46d05bb": "Science of the Secondary 2: Cup"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Conceived by Atelier HOKO, this booklet is an inquisitive approach towards uncovering implicit conditions that exist in our experience of the everyday. The term \u201csecondary\u201d refers to material and immaterial conditions and sensations that humans are not conscious of in their interaction with things and the immediate surroundings. In so doing, the independent research lab hopes to draw upon a renewed sensibility towards living. This instalment analyses the act of drinking from a cup in exceeding detail, through photos, diagrams and texts. Atelier HOKO developed this programme in response to questions on how design today can move beyond its perceived perimeters.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 2: Cup - ISBN 9789810798765 - Atelier Hoko - Alvin Ho ; Clara Koh",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"189b89cac4552ad2a203391af14a4328"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "a2f6001e97ea4d8c88b775abcd4013a3",
"_score": 0.0,
"_source": {
"id": "a2f6001e97ea4d8c88b775abcd4013a3",
"autoIncrement": 175622.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 24,
"productNumber": [
"idea32357"
],
"ean": null,
"displayGroup": "b79ea83492f73d6abc89d8ed27ed9a1e",
"sales": 0,
"stock": 24,
"weight": 82.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9b4aac95e66e4d1db46821667ba50f14",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2015-03-23T00:00:00+00:00",
"createdAt": "2025-07-22T17:38:55+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "1e9aa8376b324c09a16917616930a662",
"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": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "9b4aac95e66e4d1db46821667ba50f14",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Atelier Hoko",
"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": "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",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"c5f551d7a5384d2d914493773e4f38e6",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"5a9a1411b7324c3c8e88c5032af10ac7"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "15171-scienceclocks.mp4",
"custom_product_author": "Atelier Hoko",
"custom_product_isbn10": 9810935471.0,
"custom_product_isbn13": 9789810935474.0,
"custom_product_details": "46 p, ills colour, 18 x 25 cm, pb, English",
"custom_product_ideacode": "ideacode15171"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 3: Clock",
"5ff02eab39254a219a0f0cbdf46d05bb": "Science of the Secondary 3: Clock"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "In general, there are two different kinds of clocks. The first tells time in the form of a common factor that most of us can relate to, a concept of \u2018time\u2019 that is shared in order for a social and ordered life to be lived with one another. Then, there is another \u2018clock\u2019 that is neither time nor instrument but a continuous stream of rhythm that flows through each and everyone of us. Between these two, which clock have you been using daily? Uncovering the implicit conditions that describes our interactions and encounters with the \u2018Clock', the authors translated these findings through images, diagrams and texts.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 3: Clock - ISBN 9789810935474 - Atelier Hoko - Atelier Hoko",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"b79ea83492f73d6abc89d8ed27ed9a1e"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "e0ae7e5c9615479a9b9e595a3df9c886",
"_score": 0.0,
"_source": {
"id": "e0ae7e5c9615479a9b9e595a3df9c886",
"autoIncrement": 175625.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 32,
"productNumber": [
"idea33699"
],
"ean": null,
"displayGroup": "8f7be8a4cf0021424fba124bb69b8d75",
"sales": 0,
"stock": 32,
"weight": 90.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9b4aac95e66e4d1db46821667ba50f14",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2016-04-04T00:00:00+00:00",
"createdAt": "2025-07-22T17:39:41+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289",
"fce8cf8062c5453097c77b2b818a4102"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
},
{
"id": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "9ef6423c1e5d425b88ed375f0957a8bb",
"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": "fce8cf8062c5453097c77b2b818a4102",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Popular Culture"
}
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "9b4aac95e66e4d1db46821667ba50f14",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Atelier Hoko",
"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": "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",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"fce8cf8062c5453097c77b2b818a4102"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"b4cf7c34ec274e7db16071f158df3623",
"c5f551d7a5384d2d914493773e4f38e6",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"5a9a1411b7324c3c8e88c5032af10ac7"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "16256-scienceegg.mp4",
"custom_product_author": "Atelier Hoko",
"custom_product_isbn10": 9810984588.0,
"custom_product_isbn13": 9789810984588.0,
"custom_product_details": "52 p, ills colour & bw, 17 x 25 cm, hb, English",
"custom_product_ideacode": "ideacode16256"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 7: Egg",
"5ff02eab39254a219a0f0cbdf46d05bb": "Science of the Secondary 7: Egg"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\"Ever since the egg has been perverted as a rich and readily available source of food for human beings, we have not thought much of it beyond its role in our diet. An altogether loathsome person was once overheard commenting (with complete disregard for the minuscule strength of a chick) that the brittleness of eggshells is meant for the convenience of the human hand. To allow a faint glimmer in the gloom of ignorance, we must begin to become conscious of the subtleties within each egg\u2026\" 'Science of the Secondary: Egg\u2019 is the seventh edition in the series of ongoing research conceived and developed by Atelier HOKO.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 7: Egg - ISBN 9789810984588 - Atelier Hoko - Atelier Hoko",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"8f7be8a4cf0021424fba124bb69b8d75"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "e61226e0315b4c1a85322372a68c3871",
"_score": 0.0,
"_source": {
"id": "e61226e0315b4c1a85322372a68c3871",
"autoIncrement": 175624.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 25,
"productNumber": [
"idea33049"
],
"ean": null,
"displayGroup": "e6ea3ccef253a9d8427420db470a23da",
"sales": 0,
"stock": 25,
"weight": 105.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9b4aac95e66e4d1db46821667ba50f14",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2015-09-22T00:00:00+00:00",
"createdAt": "2025-07-22T17:39:26+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"ed86f1986f3b4d3f900bc1f1aab3f2c2",
"6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
"_count": 1
},
{
"id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "3e2e727dba6d4c2c908786f7f400069c",
"tags": [],
"parentId": null,
"coverId": "28c8b49bde2c4a40abb6a62dd94f6c08",
"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": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
}
},
{
"id": "d16693951bac41629e8d72052c1eb6fc",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "9b4aac95e66e4d1db46821667ba50f14",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Atelier Hoko",
"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": "8f3379b6df5549d9a9e258062ba21111",
"_count": 1,
"groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"group": {
"id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
}
},
{
"id": "c5f551d7a5384d2d914493773e4f38e6",
"_count": 1,
"groupId": "e7decbf369a24379aefbb1a6a2298afd",
"group": {
"id": "e7decbf369a24379aefbb1a6a2298afd",
"_count": 1
},
"name": {
"e48c5bbb925743738191576449c97a13": "Backlist",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Published"
}
},
{
"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": [
"6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d16693951bac41629e8d72052c1eb6fc",
"d2f9c33b932d4927978194b9023cb289",
"ed86f1986f3b4d3f900bc1f1aab3f2c2"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"8f3379b6df5549d9a9e258062ba21111",
"c5f551d7a5384d2d914493773e4f38e6",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"5a9a1411b7324c3c8e88c5032af10ac7"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_author": "Atelier Hoko",
"custom_product_isbn10": 9810961839.0,
"custom_product_isbn13": 9789810961831.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 5: Door",
"5ff02eab39254a219a0f0cbdf46d05bb": "Science of the Secondary 5: Door"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "For the first instalment of a building-centric research initiative under the Science of the Secondary series, the common Door, Window and Pipe were chosen as starting points towards an inquiry into the openings of a dwelling. Drawing from the findings of this study, Atelier HOKO developed another mad afternoon at home; an activity piece that contains sixty instructional postcards to be performed by individuals in the comfort of their own home. Using the familiarity of everyday actions and materials to investigate and experience the different openings, this project attempts to draw a closer and more intimate relationship between people and buildings. The three issues are also sold individually.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Science of the Secondary 5: Door - ISBN 9789810961831 - Atelier Hoko - Atelier Hoko",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"e6ea3ccef253a9d8427420db470a23da"
]
}
},
{
"_index": "sw64_product_1766773199",
"_id": "fed90b819abd43ffaa38354fcca3dc20",
"_score": 0.0,
"_source": {
"id": "fed90b819abd43ffaa38354fcca3dc20",
"autoIncrement": 98755.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
}
],
"availableStock": 2,
"productNumber": [
"idea45119"
],
"ean": null,
"displayGroup": "3368c411895740828bc082287c892384",
"sales": 0,
"stock": 2,
"weight": 210.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "76c6f3cb1fe54fa58ee032433acdfb9f",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": "2024-06-03T00:00:00+00:00",
"createdAt": "2025-07-06T15:36:34+00:00",
"categoryTree": [
"a59628ec24ec4fbb992d74f4e5eb48e0",
"6e3eff42952a4a2e82bcebe949be0d92",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d2f9c33b932d4927978194b9023cb289"
],
"categoriesRo": [
{
"id": "a59628ec24ec4fbb992d74f4e5eb48e0",
"_count": 1
},
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1
}
],
"taxId": "72d8db7c623c444c92bd9e394492b9b5",
"tags": [],
"parentId": null,
"coverId": "9f18950f550d42cd98d4454954fc2844",
"childCount": 0,
"categories": [
{
"id": "6e3eff42952a4a2e82bcebe949be0d92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
}
},
{
"id": "ad2072cac991465a86f3fc4892d43a17",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Backlist"
}
},
{
"id": "cc2d7af391d5447399fddb95fa06ac8d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Furniture & Product Design"
}
},
{
"id": "d2f9c33b932d4927978194b9023cb289",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Graphic Design & Typography"
}
}
],
"manufacturer": {
"id": "76c6f3cb1fe54fa58ee032433acdfb9f",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Onomatopee",
"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": "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",
"ad2072cac991465a86f3fc4892d43a17",
"cc2d7af391d5447399fddb95fa06ac8d",
"d2f9c33b932d4927978194b9023cb289"
],
"optionIds": [],
"propertyIds": [
"20b459452a4d4bb094212595f9aacebe",
"3ee7068fe9564e41bfc26ad188d97bb3",
"c5f551d7a5384d2d914493773e4f38e6",
"e856c479a89b4843b25d2592c766261a",
"fe011bcab5c04a66b2dac84ab9b52847"
],
"tagIds": [],
"streamIds": [
"4b68809fee814c7aa6907b9fb102d7dc",
"b4451bc0c5df41008b27ecd004970c41"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_video": "24510-visions.mp4",
"custom_product_isbn10": 9493382001.0,
"custom_product_isbn13": 9789493382008.0,
"custom_product_details": "72 p, ills colour & bw, 21 x 30 cm, pb, English",
"custom_product_ideacode": "ideacode24510"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Visions By 5: People about Material Cultures",
"5ff02eab39254a219a0f0cbdf46d05bb": "Visions By 5: People about Material Cultures"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "The biannual magazine \u2018Visions By\u2019 addresses the different perspectives on materiality and material cultures from a critical and speculative research focus. It aims to generate awareness through materials beyond their physical properties and consider materials as a new, entitled discipline emerging from a design context. With a curated and eclectic mix of articles, photo essays, interviews, and case studies, it examines different forms of understanding and exercising material in a design context. In this fifth issue, visit the coal miners of Donbas, understand why water gives and takes life, relive the killing of Pablo Escobar and (later) Pepe the hippo, the Cuban \u2018rikimbili\u2019, and more.",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Visions By 5: People about Material Cultures - ISBN 9789493382008 - Onomatopee",
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5ff02eab39254a219a0f0cbdf46d05bb": null
},
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.7,
"cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.7,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
"cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.0,
"cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.0,
"cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.0,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.0,
"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.0,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.55,
"cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.55,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.0,
"cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.0,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.7,
"cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.0,
"visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
},
"fields": {
"displayGroup": [
"3368c411895740828bc082287c892384"
]
}
}
]
},
"aggregations": {
"total-count": {
"value": 197
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.29 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":"cc2d7af391d5447399fddb95fa06ac8d"}},{"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"}
{
"took": 2,
"timed_out": false,
"terminated_early": true,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 197,
"rating": {
"value": 0.0
}
},
"price": {
"count": 197,
"min": 0.0,
"max": 165.5,
"avg": 41.60406091370558,
"sum": 8196.0
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 895,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "e856c479a89b4843b25d2592c766261a",
"doc_count": 197
},
{
"key": "fe011bcab5c04a66b2dac84ab9b52847",
"doc_count": 197
},
{
"key": "c5f551d7a5384d2d914493773e4f38e6",
"doc_count": 141
},
{
"key": "20b459452a4d4bb094212595f9aacebe",
"doc_count": 132
},
{
"key": "3ee7068fe9564e41bfc26ad188d97bb3",
"doc_count": 36
},
{
"key": "dcc27de28b734188b74c406cc16fe486",
"doc_count": 29
},
{
"key": "61134b1440d745aab15d9df42b52cb8f",
"doc_count": 26
},
{
"key": "0a301fad566c43a78b00ae55471a9991",
"doc_count": 25
},
{
"key": "8f3379b6df5549d9a9e258062ba21111",
"doc_count": 21
},
{
"key": "548e1938d6c246b390d6705d6eb6da63",
"doc_count": 20
},
{
"key": "b4cf7c34ec274e7db16071f158df3623",
"doc_count": 18
},
{
"key": "cc75c58f6b354677bccff2ab202c3eae",
"doc_count": 11
},
{
"key": "a6a16a6ed3834ae79d76e1c8b0275ae3",
"doc_count": 9
},
{
"key": "c70e82b924504940af1e2b227f162e7b",
"doc_count": 8
},
{
"key": "6fe80a8802b142179113e5ee40976380",
"doc_count": 7
},
{
"key": "757ac9f4f920431c8edb00685b2d640d",
"doc_count": 7
},
{
"key": "d98dd5435c8d4c8ba377e01e520fe134",
"doc_count": 4
},
{
"key": "6bd057dfceb74fdba50c6b780d0a79c6",
"doc_count": 3
},
{
"key": "97e23f4b87b24849af566a03e0f5dcce",
"doc_count": 3
},
{
"key": "7a7c5c61d55d419788bc188423137d51",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "765ac679bb2a42c6b93f26ea05fdc122",
"doc_count": 25
},
{
"key": "3437f31ecab743f3ba6dda2f82cdcf75",
"doc_count": 12
},
{
"key": "9b4aac95e66e4d1db46821667ba50f14",
"doc_count": 12
},
{
"key": "1b960813f1dc405c9d9f331b980fd267",
"doc_count": 11
},
{
"key": "76c6f3cb1fe54fa58ee032433acdfb9f",
"doc_count": 10
},
{
"key": "ab94f99dfa3547a3830de8aea890b20b",
"doc_count": 8
},
{
"key": "666899b798ad4fcf831795a431695c02",
"doc_count": 6
},
{
"key": "07be237df4d246dda0502e53d43b9bc0",
"doc_count": 5
},
{
"key": "d783e85490fb4b369d097c555c00308e",
"doc_count": 5
},
{
"key": "1d81b30780e9463bb4a0a4e55b9f288c",
"doc_count": 4
},
{
"key": "29c7de882dd04855a2b198e986ab33c0",
"doc_count": 4
},
{
"key": "12e306e17ba14e4293898f1ebd858f73",
"doc_count": 3
},
{
"key": "1ad99fff16f04b4cb26759837cb9d8e1",
"doc_count": 3
},
{
"key": "3cb68c7c64814b30913ab54b9cb853e2",
"doc_count": 3
},
{
"key": "7633765743c84b8b8eca0a403bad65f6",
"doc_count": 3
},
{
"key": "96d928197c4c48bbab7c18c88698999a",
"doc_count": 3
},
{
"key": "0d31107aff034b399329fec8a2de06c3",
"doc_count": 2
},
{
"key": "1283f423f4c7460689961f255f647b42",
"doc_count": 2
},
{
"key": "16955c6d9696474091144689f7ab0437",
"doc_count": 2
},
{
"key": "1a2e5fe40f5a4af0a966ccb020f39f05",
"doc_count": 2
},
{
"key": "2fea302a24cc40a0bf7af3ef86808429",
"doc_count": 2
},
{
"key": "338bf0b2e91f47ca8a8928606c6c5fe3",
"doc_count": 2
},
{
"key": "5aa153ebaab1401e86f25759c3ce4446",
"doc_count": 2
},
{
"key": "66f2c49feed8470e8a9ce807129a383c",
"doc_count": 2
},
{
"key": "7389728fd7af4216acb88ae6567d7267",
"doc_count": 2
},
{
"key": "b094995986634949aeb52fd3645e76c8",
"doc_count": 2
},
{
"key": "b0ae35a77e4a47dba4c92eb98ad012a3",
"doc_count": 2
},
{
"key": "b0c62754f73e46efb819fb90dbc1ba56",
"doc_count": 2
},
{
"key": "b45a3837f19d4aac906d0a67dcef0fea",
"doc_count": 2
},
{
"key": "cbcb1b397c51491abf969c43d4bca1ad",
"doc_count": 2
},
{
"key": "d0ae082198454c1c92aad188a1249747",
"doc_count": 2
},
{
"key": "d7216261e56847358f07065074e65ea5",
"doc_count": 2
},
{
"key": "fc8e853419e74a9d8ef4bd4bf6dca443",
"doc_count": 2
},
{
"key": "066d2a86d7124dacb47c6d2cafa069e2",
"doc_count": 1
},
{
"key": "0ffb8f152ee741fd9ca8bf39a13b4eff",
"doc_count": 1
},
{
"key": "10cf0a3324874c1aacf4b0d00dfd162b",
"doc_count": 1
},
{
"key": "15a54de9deda4793ac6b846dbc8df8ce",
"doc_count": 1
},
{
"key": "1e272f0bb9f849b0b8228b5d86d1fa18",
"doc_count": 1
},
{
"key": "204b2a2b2fba4c7dbab1c425cb0cb1f3",
"doc_count": 1
},
{
"key": "2d92a9aa552e452eafa6f1e36fdb9e03",
"doc_count": 1
},
{
"key": "398bc279ae044cbd936329d2828a17dd",
"doc_count": 1
},
{
"key": "482334540eba4b46a8663910c0e462c7",
"doc_count": 1
},
{
"key": "49377541775344c18da0107e77962297",
"doc_count": 1
},
{
"key": "49fb987c5ad247fb90431a3579969946",
"doc_count": 1
},
{
"key": "4bc3ef6234c948f098d2309dfcef22a2",
"doc_count": 1
},
{
"key": "4df07f10cfba4590828b8835a62b0900",
"doc_count": 1
},
{
"key": "5b79f1ae42504001a0c5eb629fb5ffb3",
"doc_count": 1
},
{
"key": "5e2d58f975f04fe9a202bfbe17f23e33",
"doc_count": 1
},
{
"key": "62a08dd3df584d7d92e242581c0407a3",
"doc_count": 1
},
{
"key": "62f293945c87447aac8d94b829ff6607",
"doc_count": 1
},
{
"key": "669fa9e7b39a49abaa0ccfc1c4b39f78",
"doc_count": 1
},
{
"key": "66cb2ef9a6ce401892c93aae89c82449",
"doc_count": 1
},
{
"key": "6df01fc7b44c49deb2cdfde2b72268e3",
"doc_count": 1
},
{
"key": "7fd2368e359f4a5fb6a17f1b72b5283b",
"doc_count": 1
},
{
"key": "82fae077c4034e538a82b1bf47631d43",
"doc_count": 1
},
{
"key": "85a824da51944a0fbf1761db80717c41",
"doc_count": 1
},
{
"key": "88a57b252d7a44419e19b96e8386a571",
"doc_count": 1
},
{
"key": "897b31bbcb734be186aa5f0bbe933ca4",
"doc_count": 1
},
{
"key": "8da8fc01885f4a01953d9947d3d95440",
"doc_count": 1
},
{
"key": "93ecceedbecc4656b70af18e726f3cbb",
"doc_count": 1
},
{
"key": "943c264d847d47d5ba560cf50db2e90c",
"doc_count": 1
},
{
"key": "a15995e7105f4eb58a941caca93de689",
"doc_count": 1
},
{
"key": "a18b447af31e4d62877df526dc13232e",
"doc_count": 1
},
{
"key": "a309903908f24e22abfbe89db2de09ff",
"doc_count": 1
},
{
"key": "a423eeb8a8fd4b4ba9ac1cb3f3f45533",
"doc_count": 1
},
{
"key": "b29f4f19ee10444bbd9e224d757b1ad6",
"doc_count": 1
},
{
"key": "b3c48394b86b44feb558d07b68d2585e",
"doc_count": 1
},
{
"key": "b86ce5f78d3d4048a0ba97fc28b44d7d",
"doc_count": 1
},
{
"key": "b9a11960935b49a4b65c3db2b05ca5e7",
"doc_count": 1
},
{
"key": "b9ab7afa8a0c4c649135db29b0c0fb38",
"doc_count": 1
},
{
"key": "c98d158eb64a4a6aae3038b40e17a33a",
"doc_count": 1
},
{
"key": "cb00888ee0f7423484e8a1b33c0f600b",
"doc_count": 1
},
{
"key": "ce0714320c1f48648eb0ef94e4bf0dd9",
"doc_count": 1
},
{
"key": "d425ddb1d7bf40228434c648eef3f71d",
"doc_count": 1
},
{
"key": "e02d14b97c09415eb81be95e7166e81b",
"doc_count": 1
},
{
"key": "e8581d0788c64effb3088d0158ed4b6d",
"doc_count": 1
},
{
"key": "e92511fbd91e436685a1de27a14e349e",
"doc_count": 1
},
{
"key": "ee83e70485a447c4b63c1b8af94bdfab",
"doc_count": 1
},
{
"key": "fcbc04c45dca4974b2e6373e1b227c47",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|