| 1 |
6.57 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"979d472a84804b9f647bc185a877a8b5"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 7,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1725967126",
"_id": "048e2f1447691907b18b2a37e7ed2322",
"_score": null,
"_source": {
"id": "048e2f1447691907b18b2a37e7ed2322",
"autoIncrement": 86900.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 8,
"productNumber": "8786",
"ean": "4044494138142",
"displayGroup": "352d19f2c8e8d38cff18186d2664d3db",
"sales": 0,
"stock": 8,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "122000715",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:26+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "e7d7dc6cd870ce255e8fe990f3be24c6",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Achsmutteradapter M10x1"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.01,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"352d19f2c8e8d38cff18186d2664d3db"
]
},
"sort": [
0,
"048e2f1447691907b18b2a37e7ed2322"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "0f0ee3310223fe38a989b2c818709393",
"_score": null,
"_source": {
"id": "0f0ee3310223fe38a989b2c818709393",
"autoIncrement": 86557.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 16,
"productNumber": "6418",
"ean": "4044494119530",
"displayGroup": "692096855048289d744f75b4708ee574",
"sales": 0,
"stock": 16,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "520-00126",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:36+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "d30ef43ff0ac84f7f62a72625a127b4e",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Ersatzkupplung Kid + Kid plus"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.97
},
"fields": {
"displayGroup": [
"692096855048289d744f75b4708ee574"
]
},
"sort": [
0,
"0f0ee3310223fe38a989b2c818709393"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "125af4d20f1ece003e7e5645cb909f2f",
"_score": null,
"_source": {
"id": "125af4d20f1ece003e7e5645cb909f2f",
"autoIncrement": 86561.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 9,
"productNumber": "13378",
"ean": "4044494147212",
"displayGroup": "930895694944bda8190916a7c347f1df",
"sales": 0,
"stock": 9,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "122530818",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:38+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "624b28924286b222f88c48a08b94b02e",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Steckachs-Adapter A 12-180-1.75"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 70.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 58.82
},
"fields": {
"displayGroup": [
"930895694944bda8190916a7c347f1df"
]
},
"sort": [
0,
"125af4d20f1ece003e7e5645cb909f2f"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "49562478de4c54fafd4ec46fdb297de5",
"_score": null,
"_source": {
"id": "49562478de4c54fafd4ec46fdb297de5",
"autoIncrement": 86558.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 93,
"productNumber": "6420",
"ean": "4044494135646",
"displayGroup": "ea0c566f37f6f912e9725279b01c6a28",
"sales": 0,
"stock": 93,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "112003214",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:37+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "a9b9358f398b8d54890a885ff5d152a2",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 21.95,
"product_vk3_ebay": 21.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Schnellspanner lang"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.8
},
"fields": {
"displayGroup": [
"ea0c566f37f6f912e9725279b01c6a28"
]
},
"sort": [
0,
"49562478de4c54fafd4ec46fdb297de5"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "4c32296316cec19d27f62e4e8db15430",
"_score": null,
"_source": {
"id": "4c32296316cec19d27f62e4e8db15430",
"autoIncrement": 86559.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 9,
"productNumber": "13360",
"ean": "4044494146956",
"displayGroup": "4ae298dd53909e5b14800b1d8f36d54b",
"sales": 0,
"stock": 9,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "122500418",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:37+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "7dff126927a582d16542325691c3a6c3",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Steckachskupplung N 12-178-1.50"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 65.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 54.62
},
"fields": {
"displayGroup": [
"4ae298dd53909e5b14800b1d8f36d54b"
]
},
"sort": [
0,
"4c32296316cec19d27f62e4e8db15430"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "c8dfece5cc68249206e4690fc4737a8d",
"_score": null,
"_source": {
"id": "c8dfece5cc68249206e4690fc4737a8d",
"autoIncrement": 86560.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 15,
"productNumber": "2341",
"ean": "4044494146857",
"displayGroup": "27f69b15d63852a4fe928686913cc89a",
"sales": 0,
"stock": 15,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b5de24948366ad3138b88f5390a8a648",
"manufacturerNumber": "122520018",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:38+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "b0d7ea9ede4e0c1d64f0d4ace85b7158",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "b5de24948366ad3138b88f5390a8a648",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Croozer Schnellspannachskupplung 148 - 158 mm"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.37
},
"fields": {
"displayGroup": [
"27f69b15d63852a4fe928686913cc89a"
]
},
"sort": [
0,
"c8dfece5cc68249206e4690fc4737a8d"
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "dca5672ff3444c7e997aa9a2c4eb2094",
"_score": null,
"_source": {
"id": "dca5672ff3444c7e997aa9a2c4eb2094",
"autoIncrement": 86553.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 8,
"productNumber": "1589",
"ean": "4052406201822",
"displayGroup": "f6050b8d0ab8fffd1147dfa03c30180c",
"sales": 0,
"stock": 8,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "41592216ffce5d7658deda1b7ea149a9",
"manufacturerNumber": "520-00123",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:35+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"63dc7ed1010d3c3b8269faf0ba7491d4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "aa9783f5970cf6cca1a035323b8d80ed",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "63dc7ed1010d3c3b8269faf0ba7491d4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "41592216ffce5d7658deda1b7ea149a9",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Centano"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"63dc7ed1010d3c3b8269faf0ba7491d4",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.95,
"product_vk3_ebay": 19.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Centano Zweitst\u00fcck f\u00fcr Achskupplung"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.24
},
"fields": {
"displayGroup": [
"f6050b8d0ab8fffd1147dfa03c30180c"
]
},
"sort": [
0,
"dca5672ff3444c7e997aa9a2c4eb2094"
]
}
]
},
"aggregations": {
"total-count": {
"value": 7
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.30 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"979d472a84804b9f647bc185a877a8b5"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|