Symfony Profiler

Query Metrics

26.00 ms Query Time

1 Node(s)

44 Indices

Queries

#▲ Execution Time Info

20.09 ms

#▲	Execution Time	Info
1	20.09 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":"5aeade7c7c9b45938b33e2597dfc73ab"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":24,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 30 View formatted request View formatted response View query backtrace POST http://localhost:9200/sw64_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "term": { "active": true } }, { "range": { "visibility_0a197278a7514b78a06ea27ef27e9ef8": { "gte": 30 } } } ] } }, { "term": { "categoryTree": "5aeade7c7c9b45938b33e2597dfc73ab" } }, { "exists": { "field": "displayGroup" } } ] } } ] } }, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 24, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 16, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 30, "relation": "eq" }, "max_score": 0.0, "hits": [ { "_index": "sw64_product_1766773199", "_id": "e5c3b63529554309afc1b87d32c3e04f", "_score": 0.0, "_source": { "id": "e5c3b63529554309afc1b87d32c3e04f", "autoIncrement": 88703.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": -1, "productNumber": [ "idea46304" ], "ean": null, "displayGroup": "47fec501922e2e5afec4f3996c931154", "sales": 0, "stock": -1, "weight": 422.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2025-03-06T00:00:00+00:00", "createdAt": "2025-07-06T15:34:57+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "7c4a624a63984305b8b67a25b23500b8" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 }, { "id": "7c4a624a63984305b8b67a25b23500b8", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "888a9772f54f4777b7ba1a9801c1f454", "childCount": 0, "categories": [ { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } }, { "id": "7c4a624a63984305b8b67a25b23500b8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New" } }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines" } }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "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": "8f3379b6df5549d9a9e258062ba21111", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } }, { "id": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "7c4a624a63984305b8b67a25b23500b8", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "548e1938d6c246b390d6705d6eb6da63", "61134b1440d745aab15d9df42b52cb8f", "8f3379b6df5549d9a9e258062ba21111", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "250156-avproye127.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English", "custom_product_ideacode": "ideacode250156" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 127: Tierra Cruda", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 127: Tierra Cruda" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos 127' explores earthen construction, a technique recovered in projects like those of Boltshauser Architekten, Studio Mumbai, Assemble, or Peris+Toral, among other studios included in this dossier that shows how tradition and innovation can intertwine to explore different types, scales, and ways of dwelling. This approach is broadened with the perspectives of architect Anna Heringer and rammed earth expert Martin Rauch. Furthermore, the Barcelona-based studio TAKK works on new forms of domesticity to address the different natural and seasonal rhythms from an economy of means. Aside from the usual news and products sections, the issue features a piece on the Shanghai Opera House by the Norwegian office Sn\u00f8hetta.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 127: Tierra Cruda - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.0, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.55, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.55, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.7, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.7, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.5, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.0, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.0, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.7, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.7, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.5, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "47fec501922e2e5afec4f3996c931154" ] } }, { "_index": "sw64_product_1766773199", "_id": "ee09e9f20e8c4652a9746cef2eb4c9fe", "_score": 0.0, "_source": { "id": "ee09e9f20e8c4652a9746cef2eb4c9fe", "autoIncrement": 92361.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": 7, "productNumber": [ "idea43780" ], "ean": null, "displayGroup": "4d7f00660bae429e76c1dcc80f61db78", "sales": 0, "stock": 7, "weight": 400.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2023-06-23T00:00:00+00:00", "createdAt": "2025-07-06T15:35:31+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "e141645f9e2546e488a61fe729d60446", "childCount": 0, "categories": [ { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines" } }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "_count": 1 }, "deliveryTime": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "_count": 1 }, "properties": [ { "id": "61134b1440d745aab15d9df42b52cb8f", "_count": 1, "groupId": "a3320773e956483f955c7bcebf5d9a60", "group": { "id": "a3320773e956483f955c7bcebf5d9a60", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes" } }, { "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": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "61134b1440d745aab15d9df42b52cb8f", "8f3379b6df5549d9a9e258062ba21111", "c5f551d7a5384d2d914493773e4f38e6", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "23418-avproyectos117.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English", "custom_product_ideacode": "ideacode23418" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 117: O\u2019Donnell +Tuomey", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 117: O\u2019Donnell +Tuomey" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos 117' dedicates its \u2018dossier\u2019 to O\u2019Donnell + Tuomey, the Irish studio led by Sheila O\u2019Donnell and John Tuomey. With studios based in Dublin, Cork, and London, the practice conveys its ability to create timeless architecture through the use of traditional materials combined with contemporary strategies. The four works published in the section following this reflect on the possibilities offered by metal enclosures, inviting to explore new aesthetic horizons and building systems. The \u2018detail\u2019 section covers the development of the new Google campus in Mountain View (California), commissioned to BIG and Heatherwick Studio.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 117: O\u2019Donnell +Tuomey - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "4d7f00660bae429e76c1dcc80f61db78" ] } }, { "_index": "sw64_product_1766773199", "_id": "f5fce6d10667431b821be2187c5967c1", "_score": 0.0, "_source": { "id": "f5fce6d10667431b821be2187c5967c1", "autoIncrement": 95498.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": 3, "productNumber": [ "idea40919" ], "ean": null, "displayGroup": "f627033fffc377dbac0250cff5c442e8", "sales": 0, "stock": 3, "weight": 425.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2021-11-19T00:00:00+00:00", "createdAt": "2025-07-06T15:36:01+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 }, { "id": "ad2072cac991465a86f3fc4892d43a17", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "ae2949b9967e4c189a8179ea98bab76c", "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": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "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": "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": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "20b459452a4d4bb094212595f9aacebe", "8f3379b6df5549d9a9e258062ba21111", "c5f551d7a5384d2d914493773e4f38e6", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "21652-av107kuma.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 24 x 30 cm, pb, Spanish\/English", "custom_product_ideacode": "ideacode21652" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107: Kengo Kuma", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 107: Kengo Kuma" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107 devotes its dossier to a selection of Kengo Kuma\u2019s latest projects, ranging from subtle interventions on heritage to large cultural complexes, always paying special attention to the materials and applying local building methods. The chapter after this presents the winning project by Jos\u00e9 Mar\u00eda S\u00e1nchez in the competition for the refurbishment of the historic Castello Visconteo in the Swiss town of Locarno, as well as three shortlisted proposals. The issue also features six examples of pavilions that prove the potential for research and innovation of this building type. The detail section covers the station designed by Benedetta Tagliabue for the new metropolitan line of Naples.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107: Kengo Kuma - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.1, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.1, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.5, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.5, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.5, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.5, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.65, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.65, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.9, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.45, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.45, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.0, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.1, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.1, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "f627033fffc377dbac0250cff5c442e8" ] } }, { "_index": "sw64_product_1766773199", "_id": "fb34496c935048e0af6d6772b6e17766", "_score": 0.0, "_source": { "id": "fb34496c935048e0af6d6772b6e17766", "autoIncrement": 97545.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": 11, "productNumber": [ "idea46044" ], "ean": null, "displayGroup": "d4c9f513ecb4635c703f6c0c92a70d94", "sales": 0, "stock": 11, "weight": 420.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2025-01-08T00:00:00+00:00", "createdAt": "2025-07-06T15:36:21+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "7c4a624a63984305b8b67a25b23500b8" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 }, { "id": "7c4a624a63984305b8b67a25b23500b8", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "6360d9fd6214440bb5a6175ff222cbae", "childCount": 0, "categories": [ { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } }, { "id": "7c4a624a63984305b8b67a25b23500b8", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New" } }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines" } }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "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": "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": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "7c4a624a63984305b8b67a25b23500b8", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "548e1938d6c246b390d6705d6eb6da63", "61134b1440d745aab15d9df42b52cb8f", "8f3379b6df5549d9a9e258062ba21111", "c5f551d7a5384d2d914493773e4f38e6", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "250012-avproyectos126.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English", "custom_product_ideacode": "ideacode250012" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 126: Ultima Abstraccion", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 126: Ultima Abstraccion" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "The magazine returns to the terrain of architectural language in this issue, presenting projects associated with abstraction. In the field of architecture, figuration and abstraction have been opposite poles of a debate highlighting the tension between tradition and modernity. And while the divide between expressive and geometric abstraction is obvious, in architecture the distinction is more complex. This issue examines several exemplary works, including a house in Portugal by Aires Mateus, NEAC Visitor Centre in the Netherlands by KAAN Architecten, and the control building for a solar plant in Turkey. Also in this issue, a visual essay by I\u00f1aki Bergera on bunkers in the Pyrenees.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 126: Ultima Abstraccion - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "d4c9f513ecb4635c703f6c0c92a70d94" ] } }, { "_index": "sw64_product_1766773199", "_id": "fc8e967028144c259ae0dbd7deb21ead", "_score": 0.0, "_source": { "id": "fc8e967028144c259ae0dbd7deb21ead", "autoIncrement": 97794.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": 3, "productNumber": [ "idea44913" ], "ean": null, "displayGroup": "ae7c3abee4c83d06d28da55fa75d90a7", "sales": 0, "stock": 3, "weight": 420.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2024-04-16T00:00:00+00:00", "createdAt": "2025-07-06T15:36:24+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 }, { "id": "ad2072cac991465a86f3fc4892d43a17", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "506649cc54f340eb970e6dbe9a43e9f8", "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": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "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": "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": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "20b459452a4d4bb094212595f9aacebe", "8f3379b6df5549d9a9e258062ba21111", "c5f551d7a5384d2d914493773e4f38e6", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "24216-robotic.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English", "custom_product_ideacode": "ideacode24216" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 121: Robotic Construction", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 121: Robotic Construction" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos' joined the AV\/Arquitectura Viva family twenty years ago. To mark the occasion, it is presented now with updated graphics and an approach adapted to the reality of architects, with more articles and works and a greater emphasis on construction. Issue 121 carries in \u2018Portfolio\u2019 a cover feature on robotics and an interview with two experts in prefabrication: Ant\u00f3n Garc\u00eda-Abril and D\u00e9bora Mesa from Ensamble Studio; and its two new sections, \u2018Pieces\u2019 and \u2018Products\u2019, give an overview of the technical scene. The old \u2018Competition\u2019 and \u2018Construction\u2019 sections are revamped under the headings \u2018Proposals\u2019 and \u2018Process,\u2019 collecting the proposals for the future Madruelo Museum in C\u00e1ceres, all commented by Jos\u00e9 Mar\u00eda S\u00e1nchez, and the development process of four parkings by Christian Kerez in Bahrain.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 121: Robotic Construction - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "ae7c3abee4c83d06d28da55fa75d90a7" ] } }, { "_index": "sw64_product_1766773199", "_id": "ff935598a0174fd1afbf470e9417a70a", "_score": 0.0, "_source": { "id": "ff935598a0174fd1afbf470e9417a70a", "autoIncrement": 98986.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8" } ], "availableStock": 1, "productNumber": [ "idea41046" ], "ean": null, "displayGroup": "5c5d1fcdee10d17b668f4d848003b53a", "sales": 0, "stock": 1, "weight": 423.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35", "manufacturerNumber": null, "deliveryTimeId": null, "releaseDate": "2021-12-21T00:00:00+00:00", "createdAt": "2025-07-06T15:36:37+00:00", "categoryTree": [ "a59628ec24ec4fbb992d74f4e5eb48e0", "ed86f1986f3b4d3f900bc1f1aab3f2c2", "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17" ], "categoriesRo": [ { "id": "a59628ec24ec4fbb992d74f4e5eb48e0", "_count": 1 }, { "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2", "_count": 1 }, { "id": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1 }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1 }, { "id": "6e3eff42952a4a2e82bcebe949be0d92", "_count": 1 }, { "id": "ad2072cac991465a86f3fc4892d43a17", "_count": 1 } ], "taxId": "72d8db7c623c444c92bd9e394492b9b5", "tags": [], "parentId": null, "coverId": "ea943debb2054171887e98f1ec6f7e41", "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": "5aeade7c7c9b45938b33e2597dfc73ab", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos" } }, { "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape" } } ], "manufacturer": { "id": "1d31e1b0242f44d1bfb67f4db8754d35", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa", "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": "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": "fe011bcab5c04a66b2dac84ab9b52847", "_count": 1, "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "group": { "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All" } } ], "options": [], "categoryIds": [ "5aeade7c7c9b45938b33e2597dfc73ab", "6b87b3ea4fc8431d9c0f9d1c5e3d9c21", "6e3eff42952a4a2e82bcebe949be0d92", "ad2072cac991465a86f3fc4892d43a17", "ed86f1986f3b4d3f900bc1f1aab3f2c2" ], "optionIds": [], "propertyIds": [ "20b459452a4d4bb094212595f9aacebe", "8f3379b6df5549d9a9e258062ba21111", "c5f551d7a5384d2d914493773e4f38e6", "fe011bcab5c04a66b2dac84ab9b52847" ], "tagIds": [], "streamIds": [ "4b68809fee814c7aa6907b9fb102d7dc", "be0a858546434cc99166c0584d8aafa6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_product_video": "21741-av108flores.mp4", "custom_product_isbn13": 1697493.0, "custom_product_details": "80 p, ills colour & bw, 24 x 30 cm, pb, Spansih\/English", "custom_product_ideacode": "ideacode21741" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 108: Dossier Flores & Prats", "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 108: Dossier Flores & Prats" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "After cutting their teeth at the office of Enic Miralles, Ricardo Flores and Eva Prats started their own practice in Barcelona in 1998. Their systematic, disciplined manner of thinking and analysis is inseparable from their work as architects, which is in turn represented by the selection of projects here. Featured are the New Arnau Theatre, La Favorita Refurbishment, and Cal Maiol School, all in Barcelona; new projects in London, Belgium, and Sweden; and Liquid Light, for the Biennale in Venice. Also in this edition, an overview of playgrounds as colourful landscapes, with examples by SLAS architects, Tomas Ghisellini, Crossboundaries, De Villar Chac\u00f3n Arquitectos, and more.", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 108: Dossier Flores & Prats - ISBN 1697493X - Avisa", "5ff02eab39254a219a0f0cbdf46d05bb": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "5ff02eab39254a219a0f0cbdf46d05bb": null }, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.0, "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.0, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.7, "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.7, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.2, "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.2, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.1, "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.1, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.5, "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.05, "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.05, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.55, "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.55, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.0, "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.7, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.7, "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30 }, "fields": { "displayGroup": [ "5c5d1fcdee10d17b668f4d848003b53a" ] } } ] }, "aggregations": { "total-count": { "value": 30 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	6.17 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":"5aeade7c7c9b45938b33e2597dfc73ab"}},{"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"} Item count: View formatted request View formatted response View query backtrace POST http://localhost:9200/sw64_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "term": { "active": true } }, { "range": { "visibility_0a197278a7514b78a06ea27ef27e9ef8": { "gte": 30 } } } ] } }, { "term": { "categoryTree": "5aeade7c7c9b45938b33e2597dfc73ab" } }, { "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" } { "took": 3, "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": 30, "rating": { "value": 0.0 } }, "price": { "count": 30, "min": 16.0, "max": 24.0, "avg": 18.683333333333334, "sum": 560.5 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 120, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "8f3379b6df5549d9a9e258062ba21111", "doc_count": 30 }, { "key": "fe011bcab5c04a66b2dac84ab9b52847", "doc_count": 30 }, { "key": "c5f551d7a5384d2d914493773e4f38e6", "doc_count": 26 }, { "key": "20b459452a4d4bb094212595f9aacebe", "doc_count": 23 }, { "key": "61134b1440d745aab15d9df42b52cb8f", "doc_count": 6 }, { "key": "548e1938d6c246b390d6705d6eb6da63", "doc_count": 4 }, { "key": "0a301fad566c43a78b00ae55471a9991", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "1d31e1b0242f44d1bfb67f4db8754d35", "doc_count": 30 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

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":"5aeade7c7c9b45938b33e2597dfc73ab"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":24,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Item count: 30
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9200/sw64_product/_search?search_type=query_then_fetch&track_total_hits=1
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        },
                                        {
                                            "range": {
                                                "visibility_0a197278a7514b78a06ea27ef27e9ef8": {
                                                    "gte": 30
                                                }
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "term": {
                                    "categoryTree": "5aeade7c7c9b45938b33e2597dfc73ab"
                                }
                            },
                            {
                                "exists": {
                                    "field": "displayGroup"
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 24,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 16,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 30,
            "relation": "eq"
        },
        "max_score": 0.0,
        "hits": [
            {
                "_index": "sw64_product_1766773199",
                "_id": "e5c3b63529554309afc1b87d32c3e04f",
                "_score": 0.0,
                "_source": {
                    "id": "e5c3b63529554309afc1b87d32c3e04f",
                    "autoIncrement": 88703.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": -1,
                    "productNumber": [
                        "idea46304"
                    ],
                    "ean": null,
                    "displayGroup": "47fec501922e2e5afec4f3996c931154",
                    "sales": 0,
                    "stock": -1,
                    "weight": 422.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2025-03-06T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:34:57+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "7c4a624a63984305b8b67a25b23500b8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        },
                        {
                            "id": "7c4a624a63984305b8b67a25b23500b8",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "888a9772f54f4777b7ba1a9801c1f454",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        },
                        {
                            "id": "7c4a624a63984305b8b67a25b23500b8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New"
                            }
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
                            }
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "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": "8f3379b6df5549d9a9e258062ba21111",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        },
                        {
                            "id": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "7c4a624a63984305b8b67a25b23500b8",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "548e1938d6c246b390d6705d6eb6da63",
                        "61134b1440d745aab15d9df42b52cb8f",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "250156-avproye127.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English",
                            "custom_product_ideacode": "ideacode250156"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 127: Tierra Cruda",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 127: Tierra Cruda"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos 127' explores earthen construction, a technique recovered in projects like those of Boltshauser Architekten, Studio Mumbai, Assemble, or Peris+Toral, among other studios included in this dossier that shows how tradition and innovation can intertwine to explore different types, scales, and ways of dwelling. This approach is broadened with the perspectives of architect Anna Heringer and rammed earth expert Martin Rauch. Furthermore, the Barcelona-based studio TAKK works on new forms of domesticity to address the different natural and seasonal rhythms from an economy of means. Aside from the usual news and products sections, the issue features a piece on the Shanghai Opera House by the Norwegian office Sn\u00f8hetta.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 127: Tierra Cruda - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.0,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.55,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.55,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.5,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.5,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.7,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.7,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.5,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.0,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.0,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.7,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.7,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.5,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.5,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "47fec501922e2e5afec4f3996c931154"
                    ]
                }
            },
            {
                "_index": "sw64_product_1766773199",
                "_id": "ee09e9f20e8c4652a9746cef2eb4c9fe",
                "_score": 0.0,
                "_source": {
                    "id": "ee09e9f20e8c4652a9746cef2eb4c9fe",
                    "autoIncrement": 92361.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": 7,
                    "productNumber": [
                        "idea43780"
                    ],
                    "ean": null,
                    "displayGroup": "4d7f00660bae429e76c1dcc80f61db78",
                    "sales": 0,
                    "stock": 7,
                    "weight": 400.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2023-06-23T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:35:31+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "e141645f9e2546e488a61fe729d60446",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
                            }
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "5ff02eab39254a219a0f0cbdf46d05bb": null
                        },
                        "_count": 1
                    },
                    "deliveryTime": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "5ff02eab39254a219a0f0cbdf46d05bb": null
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "61134b1440d745aab15d9df42b52cb8f",
                            "_count": 1,
                            "groupId": "a3320773e956483f955c7bcebf5d9a60",
                            "group": {
                                "id": "a3320773e956483f955c7bcebf5d9a60",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yes"
                            }
                        },
                        {
                            "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": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "61134b1440d745aab15d9df42b52cb8f",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "c5f551d7a5384d2d914493773e4f38e6",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "23418-avproyectos117.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English",
                            "custom_product_ideacode": "ideacode23418"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 117: O\u2019Donnell +Tuomey",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 117: O\u2019Donnell +Tuomey"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos 117' dedicates its \u2018dossier\u2019 to O\u2019Donnell + Tuomey, the Irish studio led by Sheila O\u2019Donnell and John Tuomey. With studios based in Dublin, Cork, and London, the practice conveys its ability to create timeless architecture through the use of traditional materials combined with contemporary strategies. The four works published in the section following this reflect on the possibilities offered by metal enclosures, inviting to explore new aesthetic horizons and building systems. The \u2018detail\u2019 section covers the development of the new Google campus in Mountain View (California), commissioned to BIG and Heatherwick Studio.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 117: O\u2019Donnell +Tuomey - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "4d7f00660bae429e76c1dcc80f61db78"
                    ]
                }
            },
            {
                "_index": "sw64_product_1766773199",
                "_id": "f5fce6d10667431b821be2187c5967c1",
                "_score": 0.0,
                "_source": {
                    "id": "f5fce6d10667431b821be2187c5967c1",
                    "autoIncrement": 95498.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": 3,
                    "productNumber": [
                        "idea40919"
                    ],
                    "ean": null,
                    "displayGroup": "f627033fffc377dbac0250cff5c442e8",
                    "sales": 0,
                    "stock": 3,
                    "weight": 425.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2021-11-19T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:36:01+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        },
                        {
                            "id": "ad2072cac991465a86f3fc4892d43a17",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "ae2949b9967e4c189a8179ea98bab76c",
                    "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": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "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": "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": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "20b459452a4d4bb094212595f9aacebe",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "c5f551d7a5384d2d914493773e4f38e6",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "21652-av107kuma.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 24 x 30 cm, pb, Spanish\/English",
                            "custom_product_ideacode": "ideacode21652"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107: Kengo Kuma",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 107: Kengo Kuma"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107 devotes its dossier to a selection of Kengo Kuma\u2019s latest projects, ranging from subtle interventions on heritage to large cultural complexes, always paying special attention to the materials and applying local building methods. The chapter after this presents the winning project by Jos\u00e9 Mar\u00eda S\u00e1nchez in the competition for the refurbishment of the historic Castello Visconteo in the Swiss town of Locarno, as well as three shortlisted proposals. The issue also features six examples of pavilions that prove the potential for research and innovation of this building type. The detail section covers the station designed by Benedetta Tagliabue for the new metropolitan line of Naples.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 107: Kengo Kuma - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.1,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.1,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.5,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.5,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.5,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.5,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.65,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.65,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.9,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.45,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.45,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.0,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.1,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.1,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "f627033fffc377dbac0250cff5c442e8"
                    ]
                }
            },
            {
                "_index": "sw64_product_1766773199",
                "_id": "fb34496c935048e0af6d6772b6e17766",
                "_score": 0.0,
                "_source": {
                    "id": "fb34496c935048e0af6d6772b6e17766",
                    "autoIncrement": 97545.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": 11,
                    "productNumber": [
                        "idea46044"
                    ],
                    "ean": null,
                    "displayGroup": "d4c9f513ecb4635c703f6c0c92a70d94",
                    "sales": 0,
                    "stock": 11,
                    "weight": 420.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2025-01-08T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:36:21+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "7c4a624a63984305b8b67a25b23500b8"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        },
                        {
                            "id": "7c4a624a63984305b8b67a25b23500b8",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "6360d9fd6214440bb5a6175ff222cbae",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        },
                        {
                            "id": "7c4a624a63984305b8b67a25b23500b8",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "New"
                            }
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Magazines"
                            }
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "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": "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": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "7c4a624a63984305b8b67a25b23500b8",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "548e1938d6c246b390d6705d6eb6da63",
                        "61134b1440d745aab15d9df42b52cb8f",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "c5f551d7a5384d2d914493773e4f38e6",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "250012-avproyectos126.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English",
                            "custom_product_ideacode": "ideacode250012"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 126: Ultima Abstraccion",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 126: Ultima Abstraccion"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "The magazine returns to the terrain of architectural language in this issue, presenting projects associated with abstraction. In the field of architecture, figuration and abstraction have been opposite poles of a debate highlighting the tension between tradition and modernity. And while the divide between expressive and geometric abstraction is obvious, in architecture the distinction is more complex. This issue examines several exemplary works, including a house in Portugal by Aires Mateus, NEAC Visitor Centre in the Netherlands by KAAN Architecten, and the control building for a solar plant in Turkey. Also in this issue, a visual essay by I\u00f1aki Bergera on bunkers in the Pyrenees.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 126: Ultima Abstraccion - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "d4c9f513ecb4635c703f6c0c92a70d94"
                    ]
                }
            },
            {
                "_index": "sw64_product_1766773199",
                "_id": "fc8e967028144c259ae0dbd7deb21ead",
                "_score": 0.0,
                "_source": {
                    "id": "fc8e967028144c259ae0dbd7deb21ead",
                    "autoIncrement": 97794.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": 3,
                    "productNumber": [
                        "idea44913"
                    ],
                    "ean": null,
                    "displayGroup": "ae7c3abee4c83d06d28da55fa75d90a7",
                    "sales": 0,
                    "stock": 3,
                    "weight": 420.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2024-04-16T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:36:24+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        },
                        {
                            "id": "ad2072cac991465a86f3fc4892d43a17",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "506649cc54f340eb970e6dbe9a43e9f8",
                    "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": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "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": "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": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "20b459452a4d4bb094212595f9aacebe",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "c5f551d7a5384d2d914493773e4f38e6",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "24216-robotic.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 21 x 30 cm, pb, Spanish\/English",
                            "custom_product_ideacode": "ideacode24216"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 121: Robotic Construction",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 121: Robotic Construction"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "'AV Proyectos' joined the AV\/Arquitectura Viva family twenty years ago. To mark the occasion, it is presented now with updated graphics and an approach adapted to the reality of architects, with more articles and works and a greater emphasis on construction. Issue 121 carries in \u2018Portfolio\u2019 a cover feature on robotics and an interview with two experts in prefabrication: Ant\u00f3n Garc\u00eda-Abril and D\u00e9bora Mesa from Ensamble Studio; and its two new sections, \u2018Pieces\u2019 and \u2018Products\u2019, give an overview of the technical scene.  The old \u2018Competition\u2019 and \u2018Construction\u2019 sections are revamped under the headings \u2018Proposals\u2019 and \u2018Process,\u2019 collecting the proposals for the future Madruelo Museum in C\u00e1ceres, all commented by Jos\u00e9 Mar\u00eda S\u00e1nchez, and the development process of four parkings by Christian Kerez in Bahrain.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 121: Robotic Construction - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.0,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.85,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.65,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.65,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 31.0,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.5,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.7,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.7,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.0,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "ae7c3abee4c83d06d28da55fa75d90a7"
                    ]
                }
            },
            {
                "_index": "sw64_product_1766773199",
                "_id": "ff935598a0174fd1afbf470e9417a70a",
                "_score": 0.0,
                "_source": {
                    "id": "ff935598a0174fd1afbf470e9417a70a",
                    "autoIncrement": 98986.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0a197278a7514b78a06ea27ef27e9ef8"
                        }
                    ],
                    "availableStock": 1,
                    "productNumber": [
                        "idea41046"
                    ],
                    "ean": null,
                    "displayGroup": "5c5d1fcdee10d17b668f4d848003b53a",
                    "sales": 0,
                    "stock": 1,
                    "weight": 423.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "manufacturerNumber": null,
                    "deliveryTimeId": null,
                    "releaseDate": "2021-12-21T00:00:00+00:00",
                    "createdAt": "2025-07-06T15:36:37+00:00",
                    "categoryTree": [
                        "a59628ec24ec4fbb992d74f4e5eb48e0",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17"
                    ],
                    "categoriesRo": [
                        {
                            "id": "a59628ec24ec4fbb992d74f4e5eb48e0",
                            "_count": 1
                        },
                        {
                            "id": "ed86f1986f3b4d3f900bc1f1aab3f2c2",
                            "_count": 1
                        },
                        {
                            "id": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1
                        },
                        {
                            "id": "6e3eff42952a4a2e82bcebe949be0d92",
                            "_count": 1
                        },
                        {
                            "id": "ad2072cac991465a86f3fc4892d43a17",
                            "_count": 1
                        }
                    ],
                    "taxId": "72d8db7c623c444c92bd9e394492b9b5",
                    "tags": [],
                    "parentId": null,
                    "coverId": "ea943debb2054171887e98f1ec6f7e41",
                    "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": "5aeade7c7c9b45938b33e2597dfc73ab",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos"
                            }
                        },
                        {
                            "id": "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Architecture & Landscape"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "1d31e1b0242f44d1bfb67f4db8754d35",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Avisa",
                            "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": "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": "fe011bcab5c04a66b2dac84ab9b52847",
                            "_count": 1,
                            "groupId": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                            "group": {
                                "id": "0e7f3bbb687f45b0bc0e1b8e9e66f936",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "All"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "5aeade7c7c9b45938b33e2597dfc73ab",
                        "6b87b3ea4fc8431d9c0f9d1c5e3d9c21",
                        "6e3eff42952a4a2e82bcebe949be0d92",
                        "ad2072cac991465a86f3fc4892d43a17",
                        "ed86f1986f3b4d3f900bc1f1aab3f2c2"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "20b459452a4d4bb094212595f9aacebe",
                        "8f3379b6df5549d9a9e258062ba21111",
                        "c5f551d7a5384d2d914493773e4f38e6",
                        "fe011bcab5c04a66b2dac84ab9b52847"
                    ],
                    "tagIds": [],
                    "streamIds": [
                        "4b68809fee814c7aa6907b9fb102d7dc",
                        "be0a858546434cc99166c0584d8aafa6"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_product_video": "21741-av108flores.mp4",
                            "custom_product_isbn13": 1697493.0,
                            "custom_product_details": "80 p, ills colour & bw, 24 x 30 cm, pb, Spansih\/English",
                            "custom_product_ideacode": "ideacode21741"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 108: Dossier Flores & Prats",
                        "5ff02eab39254a219a0f0cbdf46d05bb": "AV Proyectos 108: Dossier Flores & Prats"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "After cutting their teeth at the office of Enic Miralles, Ricardo Flores and Eva Prats started their own practice in Barcelona in 1998. Their systematic, disciplined manner of thinking and analysis is inseparable from their work as architects, which is in turn represented by the selection of projects here. Featured are the New Arnau Theatre, La Favorita Refurbishment, and Cal Maiol School, all in Barcelona; new projects in London, Belgium, and Sweden; and Liquid Light, for the Biennale in Venice. Also in this edition, an overview of playgrounds as colourful landscapes, with examples by SLAS architects, Tomas Ghisellini, Crossboundaries, De Villar Chac\u00f3n Arquitectos, and more.",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AV Proyectos 108: Dossier Flores & Prats - ISBN 1697493X - Avisa",
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "5ff02eab39254a219a0f0cbdf46d05bb": null
                    },
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.0,
                    "cheapest_price_rule7354fabf79834336b908fabcc76eb324_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.0,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.7,
                    "cheapest_price_ruledb8cc80f74744edbaabed2053073cd78_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.7,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.2,
                    "cheapest_price_rule0a911bcb73a140c6be0d4bb710443552_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.2,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.1,
                    "cheapest_price_ruled77e4dc83b884058a0e2590060b483f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.1,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.5,
                    "cheapest_price_ruled599db803cb04ef0ac923955cbe7ea71_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.5,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.05,
                    "cheapest_price_ruled5baf7177aea43cbbe3a2e6a538d803a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.05,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.55,
                    "cheapest_price_rulec8d52bd48f29415f8204f3fecc13d7f4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.55,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.0,
                    "cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.7,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.7,
                    "visibility_0a197278a7514b78a06ea27ef27e9ef8": 30
                },
                "fields": {
                    "displayGroup": [
                        "5c5d1fcdee10d17b668f4d848003b53a"
                    ]
                }
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 30
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

6.17 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":"5aeade7c7c9b45938b33e2597dfc73ab"}},{"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"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST http://localhost:9200/sw64_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        },
                                        {
                                            "range": {
                                                "visibility_0a197278a7514b78a06ea27ef27e9ef8": {
                                                    "gte": 30
                                                }
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "term": {
                                    "categoryTree": "5aeade7c7c9b45938b33e2597dfc73ab"
                                }
                            },
                            {
                                "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"
}


                                    {
    "took": 3,
    "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": 30,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 30,
            "min": 16.0,
            "max": 24.0,
            "avg": 18.683333333333334,
            "sum": 560.5
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 120,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "8f3379b6df5549d9a9e258062ba21111",
                        "doc_count": 30
                    },
                    {
                        "key": "fe011bcab5c04a66b2dac84ab9b52847",
                        "doc_count": 30
                    },
                    {
                        "key": "c5f551d7a5384d2d914493773e4f38e6",
                        "doc_count": 26
                    },
                    {
                        "key": "20b459452a4d4bb094212595f9aacebe",
                        "doc_count": 23
                    },
                    {
                        "key": "61134b1440d745aab15d9df42b52cb8f",
                        "doc_count": 6
                    },
                    {
                        "key": "548e1938d6c246b390d6705d6eb6da63",
                        "doc_count": 4
                    },
                    {
                        "key": "0a301fad566c43a78b00ae55471a9991",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "1d31e1b0242f44d1bfb67f4db8754d35",
                    "doc_count": 30
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "albertvanderveen",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 45,
    "active_shards": 45,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 2,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 95.74468085106383
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
security-auditlog-2026.01.10	open	1, 0	138036
.ql-datasources	open	1, 0	0
top_queries-2026.01.17-65767	open	1, 0	19
top_queries-2026.01.19-65769	open	1, 0	15
security-auditlog-2026.01.18	open	1, 0	138024
security-auditlog-2026.01.17	open	1, 0	138040
security-auditlog-2026.01.16	open	1, 0	138032
security-auditlog-2025.12.31	open	1, 0	138032
security-auditlog-2026.01.15	open	1, 0	138028
security-auditlog-2025.12.30	open	1, 0	138032
security-auditlog-2026.01.14	open	1, 0	100525
security-auditlog-2026.01.13	open	1, 0	138044
.opendistro_security	open	1, 0	9
security-auditlog-2026.01.12	open	1, 0	138032
security-auditlog-2026.01.11	open	1, 0	138036
.opensearch-observability	open	1, 0	0
top_queries-2026.01.13-65763	open	1, 0	22
security-auditlog-2026.01.09	open	1, 0	138040
security-auditlog-2026.01.08	open	1, 0	138036
top_queries-2026.01.16-65766	open	1, 0	31
sw64_product_1766774037	open	1, 1	145101
security-auditlog-2026.01.20	open	1, 0	131768
security-auditlog-2025.12.29	open	1, 0	138032
security-auditlog-2025.12.28	open	1, 0	138032
security-auditlog-2025.12.27	open	1, 0	138016
security-auditlog-2025.12.26	open	1, 0	134811
top_queries-2026.01.20-65791	open	1, 0	1418
security-auditlog-2025.12.25	open	1, 0	36655
.kibana_92668751_admin_1	open	1, 0	1
security-auditlog-2026.01.07	open	1, 0	138044
security-auditlog-2026.01.06	open	1, 0	138032
security-auditlog-2026.01.05	open	1, 0	138032
security-auditlog-2026.01.04	open	1, 0	138036
security-auditlog-2026.01.03	open	1, 0	138040
security-auditlog-2026.01.02	open	1, 0	138036
.kibana_1	open	1, 0	1
security-auditlog-2026.01.01	open	1, 0	138032
top_queries-2026.01.18-65768	open	1, 0	29
.tasks	open	1, 0	1
top_queries-2026.01.14-65764	open	1, 0	39
.plugins-ml-config	open	1, 0	1
top_queries-2026.01.15-65765	open	1, 0	24
security-auditlog-2026.01.19	open	1, 0	138032
sw64_product_1766773199	open	1, 1	145101

Symfony Profiler

GET https://shopware64.ideabooks.albertvanderveen.nl/navigation/5aeade7c7c9b45938b33e2597dfc73ab?p=2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices