| 1 |
7.33 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":"ec8ce6abb3e952a85b8551ba726a1227"}}}},{"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": 3,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 10,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1747130459",
"_id": "148d411aeffed8a6f6ad4ecd77d1f904",
"_score": null,
"_source": {
"id": "148d411aeffed8a6f6ad4ecd77d1f904",
"autoIncrement": 81739.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 54,
"productNumber": "4291",
"ean": "4016538093311",
"displayGroup": "ee2ad33f7e2e94580f2bae85dabccf01",
"sales": 0,
"stock": 54,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "27361101a74f1edf8824f150d03b569e",
"manufacturerNumber": "061-72048",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:15+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "e34e4e6a6673e78ac22bbdc979b982c3",
"coverId": "d0edcfccb8d3775b41db28a51954500f",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "27361101a74f1edf8824f150d03b569e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "c97b987d3c9816e3d840f461511ce41d",
"_count": 1,
"groupId": "100604c624f87c3d0dbba4db48bcbe02",
"group": {
"id": "100604c624f87c3d0dbba4db48bcbe02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "110 mm"
}
}
],
"options": [
{
"id": "c97b987d3c9816e3d840f461511ce41d",
"_count": 1,
"groupId": "100604c624f87c3d0dbba4db48bcbe02",
"group": {
"id": "100604c624f87c3d0dbba4db48bcbe02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "110 mm"
}
}
],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"optionIds": [
"c97b987d3c9816e3d840f461511ce41d"
],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5",
"c97b987d3c9816e3d840f461511ce41d"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 7416.1,
"product_vk2_amazon": 39.99,
"product_vk3_ebay": 39.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Ahead Vorbau Octopus 50"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 45.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 38.57
},
"fields": {
"displayGroup": [
"ee2ad33f7e2e94580f2bae85dabccf01"
]
},
"sort": [
0,
"148d411aeffed8a6f6ad4ecd77d1f904"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "32b991e5d77ad140559ffb95522992d0",
"_score": null,
"_source": {
"id": "32b991e5d77ad140559ffb95522992d0",
"autoIncrement": 86618.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 103,
"productNumber": "2600",
"ean": "4016538106318",
"displayGroup": "867fd2c985d5c502ac2e6e9d7d433d07",
"sales": 0,
"stock": 103,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "27361101a74f1edf8824f150d03b569e",
"manufacturerNumber": "061-71930",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:55+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "9946d707bc719896a4224c6dc3dfd541",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "27361101a74f1edf8824f150d03b569e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 24.95,
"product_vk3_ebay": 24.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Vorbau AS 820"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.53
},
"fields": {
"displayGroup": [
"867fd2c985d5c502ac2e6e9d7d433d07"
]
},
"sort": [
0,
"32b991e5d77ad140559ffb95522992d0"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "45f31d16b1058d586fc3be7207b58053",
"_score": null,
"_source": {
"id": "45f31d16b1058d586fc3be7207b58053",
"autoIncrement": 81539.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 4,
"productNumber": "1152",
"ean": "4260086858117",
"displayGroup": "59d65ba5ae445a8d0be69f7e4905dacc",
"sales": 0,
"stock": 4,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "17d9cff2aca14b5651adfe6c71194bee",
"manufacturerNumber": "1548",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:08+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "ae2557d7c8f833f05f323997ff4a1e1f",
"coverId": "93feb5a3d81cb83143fb0135b7005c59",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "17d9cff2aca14b5651adfe6c71194bee",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SQlab"
},
"_count": 1
},
"properties": [
{
"id": "0c7ed4291930b330ac53a89e2ed44c1a",
"_count": 1,
"groupId": "4b68b6e2929ea7c3511a5f9c3a63c346",
"group": {
"id": "4b68b6e2929ea7c3511a5f9c3a63c346",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "70 mm"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [
{
"id": "0c7ed4291930b330ac53a89e2ed44c1a",
"_count": 1,
"groupId": "4b68b6e2929ea7c3511a5f9c3a63c346",
"group": {
"id": "4b68b6e2929ea7c3511a5f9c3a63c346",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "70 mm"
}
}
],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"optionIds": [
"0c7ed4291930b330ac53a89e2ed44c1a"
],
"propertyIds": [
"0c7ed4291930b330ac53a89e2ed44c1a",
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 1152.1,
"product_vk2_amazon": 24.99,
"product_vk3_ebay": 24.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SQlab Vorbau 802"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.57,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"59d65ba5ae445a8d0be69f7e4905dacc"
]
},
"sort": [
0,
"45f31d16b1058d586fc3be7207b58053"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "59d9b46aa00c70238bb89056cfeb96c0",
"_score": null,
"_source": {
"id": "59d9b46aa00c70238bb89056cfeb96c0",
"autoIncrement": 86621.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "9234",
"ean": "4030701043903",
"displayGroup": "28f12c3827d2a5efbcf368af9b405709",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "34baca408d2a10d268a5905ba3266147",
"manufacturerNumber": "061-72384",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:57+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "9fa0ad68b68d9ab12574687526844530",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "34baca408d2a10d268a5905ba3266147",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
},
"_count": 1
},
"properties": [
{
"id": "4eee70ed64219d5914eb3cf6d1c61506",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"optionIds": [],
"propertyIds": [
"4eee70ed64219d5914eb3cf6d1c61506"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 24.99,
"product_vk3_ebay": 24.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Vorbau 100\/180 22,4 mm schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.17
},
"fields": {
"displayGroup": [
"28f12c3827d2a5efbcf368af9b405709"
]
},
"sort": [
0,
"59d9b46aa00c70238bb89056cfeb96c0"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "5ca359ab1e9e3b9c478459944a2d9ca5",
"_score": null,
"_source": {
"id": "5ca359ab1e9e3b9c478459944a2d9ca5",
"autoIncrement": 86584.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 7,
"productNumber": "5283",
"ean": "4016538021550",
"displayGroup": "502b95ba4e6febfb1d364b2bdfc43b47",
"sales": 0,
"stock": 7,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "27361101a74f1edf8824f150d03b569e",
"manufacturerNumber": "060-72074",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:45+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "03b38ab0b0b4a91217394a21246989a9",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "27361101a74f1edf8824f150d03b569e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
},
"_count": 1
},
"properties": [
{
"id": "4eee70ed64219d5914eb3cf6d1c61506",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"optionIds": [],
"propertyIds": [
"4eee70ed64219d5914eb3cf6d1c61506"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_vk2_amazon": 14.99,
"product_vk3_ebay": 14.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ergotec Vorbau Cat Tube"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.08,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"502b95ba4e6febfb1d364b2bdfc43b47"
]
},
"sort": [
0,
"5ca359ab1e9e3b9c478459944a2d9ca5"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "de3c1a733c9c51de130bc7ae775fd930",
"_score": null,
"_source": {
"id": "de3c1a733c9c51de130bc7ae775fd930",
"autoIncrement": 86583.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 74,
"productNumber": "4118",
"ean": "4016538080816",
"displayGroup": "5d2c261c27788b635a0b84c6a996cb85",
"sales": 0,
"stock": 74,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "27361101a74f1edf8824f150d03b569e",
"manufacturerNumber": "061-71931",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:45+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "3871155c8e1c6ac704b5a5d657f13ed7",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "27361101a74f1edf8824f150d03b569e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 24.99,
"product_vk3_ebay": 24.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Octopus 2 A-head Vorbau"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.53
},
"fields": {
"displayGroup": [
"5d2c261c27788b635a0b84c6a996cb85"
]
},
"sort": [
0,
"de3c1a733c9c51de130bc7ae775fd930"
]
},
{
"_index": "shopware6-stage_product_1747130459",
"_id": "ea20aed6df7caa746052d227d194a395",
"_score": null,
"_source": {
"id": "ea20aed6df7caa746052d227d194a395",
"autoIncrement": 86623.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 10,
"productNumber": "8375",
"ean": "4030701047406",
"displayGroup": "1cceb1aee5a798eca2fdc507121ca601",
"sales": 0,
"stock": 10,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "34baca408d2a10d268a5905ba3266147",
"manufacturerNumber": "061-72390",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:57+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "397405a1bc59c81370f83f71ecec0e9f",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "e96ed478dab8595a7dbda4cbcbee168f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
}
},
{
"id": "ec8ce6abb3e952a85b8551ba726a1227",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vorbauten"
}
}
],
"manufacturer": {
"id": "34baca408d2a10d268a5905ba3266147",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"e96ed478dab8595a7dbda4cbcbee168f",
"ec8ce6abb3e952a85b8551ba726a1227"
],
"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": "Montage2",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 24.99,
"product_vk3_ebay": 24.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Vorbau 100\/180 25,4 mm schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.17,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"1cceb1aee5a798eca2fdc507121ca601"
]
},
"sort": [
0,
"ea20aed6df7caa746052d227d194a395"
]
}
]
},
"aggregations": {
"total-count": {
"value": 7
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.22 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":"ec8ce6abb3e952a85b8551ba726a1227"}}}},{"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
|