| 1 |
4.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":"735b90b4568125ed6c3f678819b6e058"}}}},{"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": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "1c1a5c79d95fb07f55d2a6d3f73651f5",
"_score": null,
"_source": {
"id": "1c1a5c79d95fb07f55d2a6d3f73651f5",
"autoIncrement": 83916.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": true,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 1,
"productNumber": "106587",
"ean": "4063518286850",
"displayGroup": "ff88293f17a56c96566d6b0a081be062",
"sales": 0,
"stock": 1,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6462331a69cdc7b76dc81136ca2713dd",
"manufacturerNumber": "837-74955",
"releaseDate": null,
"createdAt": "2023-10-16T11:25:03+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"fc490ca45c00b1249bbe3554a4fdf6fb",
"3fe94a002317b5f9259f82690aeea4cd",
"735b90b4568125ed6c3f678819b6e058",
"4f4adcbf8c6f66dcfc8a3282ac2bf10a",
"ad13a2a07ca4b7642959dc0c4c740ab6"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "fc490ca45c00b1249bbe3554a4fdf6fb",
"_count": 1
},
{
"id": "3fe94a002317b5f9259f82690aeea4cd",
"_count": 1
},
{
"id": "735b90b4568125ed6c3f678819b6e058",
"_count": 1
},
{
"id": "4f4adcbf8c6f66dcfc8a3282ac2bf10a",
"_count": 1
},
{
"id": "ad13a2a07ca4b7642959dc0c4c740ab6",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "333dd45fd8da06da7ff5eaa089768380",
"coverId": "a67bd13dcc7482c1f67ee52de840f1b6",
"childCount": 0,
"categories": [
{
"id": "3fe94a002317b5f9259f82690aeea4cd",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking E-Bike"
}
},
{
"id": "4f4adcbf8c6f66dcfc8a3282ac2bf10a",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike Trekking Herren"
}
},
{
"id": "735b90b4568125ed6c3f678819b6e058",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Crossbikes"
}
},
{
"id": "ad13a2a07ca4b7642959dc0c4c740ab6",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Crossbike Street"
}
},
{
"id": "fc490ca45c00b1249bbe3554a4fdf6fb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bikes"
}
}
],
"manufacturer": {
"id": "6462331a69cdc7b76dc81136ca2713dd",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls"
},
"_count": 1
},
"properties": [
{
"id": "0622c5290bcc24edde88c19018975298",
"_count": 1,
"groupId": "ecc93cb4118559ffc538281ac056e6b0",
"group": {
"id": "ecc93cb4118559ffc538281ac056e6b0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "integriert"
}
},
{
"id": "08b193a826b04fc8ad11cbbc8d96691d",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "silber"
}
},
{
"id": "091b1881da6ada5d701d830652b826ed",
"_count": 1,
"groupId": "c4b89253123017ee3fbb833485a18a6c",
"group": {
"id": "c4b89253123017ee3fbb833485a18a6c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "750 Wh"
}
},
{
"id": "1e2eee1032b9111be4ab622683cb0cec",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2024"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "1ffcdd41a434dd9609377cdc8aa2a962",
"_count": 1,
"groupId": "a6422bb08b1146d1c55779ac81586ab3",
"group": {
"id": "a6422bb08b1146d1c55779ac81586ab3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLoad Systemgep\u00e4cktr\u00e4ger"
}
},
{
"id": "21cd52c4e14aac7a7087bf626dfdbf1d",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DDM-2"
}
},
{
"id": "392e6f01c2b6febda2120ee3215f87e4",
"_count": 1,
"groupId": "a1beca20c312f61bd82db0d0e523cefc",
"group": {
"id": "a1beca20c312f61bd82db0d0e523cefc",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "85 Nm"
}
},
{
"id": "397315c888154c00af3ddd4b408e452b",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR SUNTOUR NCX-32-D LO"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "47c6e8d507bbd38e8bf67a2a0e6f0b28",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "55 cm"
}
},
{
"id": "4b41626df1e86955aaa9426b871baded",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "zul\u00e4ssiges Gesamtgewicht: 150 kg"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "511f6ca5e8e4fd304dc2328351e0fc3c",
"_count": 1,
"groupId": "3f89663f0ab68bdf364a590c8f133f4b",
"group": {
"id": "3f89663f0ab68bdf364a590c8f133f4b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bosch Performance Line CX smart System"
}
},
{
"id": "5160fcc9ee2e7be23ebee69c6bff1fc0",
"_count": 1,
"groupId": "b33538179f5661a86cbe327a1793e199",
"group": {
"id": "b33538179f5661a86cbe327a1793e199",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bosch Performance Line CX Smart System"
}
},
{
"id": "52896ee90105dfb98b5b274dbdc0d216",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Aluminium"
}
},
{
"id": "56f0914098066909111fbdc71d8a725b",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "5b65ebfa39dd96a05a188a99c1413e51",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Alivio RD-M3100 shadow"
}
},
{
"id": "67f2af956e501e394284a28890e86261",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA"
}
},
{
"id": "6a2769d67b9d89e8bf2b576102336c4f",
"_count": 1,
"groupId": "a9afe3dfd367b52569af60a0af3d19c1",
"group": {
"id": "a9afe3dfd367b52569af60a0af3d19c1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano"
}
},
{
"id": "6f89d193ef35c764823c0bf027eb088a",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SUPERO Optima Safe Anti-Puncture, 55-622"
}
},
{
"id": "791e0a8c37ddc177fda60f15b87417bc",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon R-232 EB, mit COB Technologie"
}
},
{
"id": "7c5810fa9eb432a1a1eae36e311adc32",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
},
{
"id": "7ce0ad7fc950edf06f4d5f10c4777692",
"_count": 1,
"groupId": "e3b5b81abbd12ca8f2f34d6740e8e31e",
"group": {
"id": "e3b5b81abbd12ca8f2f34d6740e8e31e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "750 Wh"
}
},
{
"id": "8bac97b539149eca0b1176bca591d30e",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SUV-S, CCS Slot Mount ready"
}
},
{
"id": "93200dcdc342f4049c4c4045ec399ab9",
"_count": 1,
"groupId": "d7cd942099e8fa42173503c86c8880ce",
"group": {
"id": "d7cd942099e8fa42173503c86c8880ce",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA No.57SC"
}
},
{
"id": "9a1ca59e44df3249ff127d311b8b53bb",
"_count": 1,
"groupId": "6afa18974577c7533cbea98c14c8a294",
"group": {
"id": "6afa18974577c7533cbea98c14c8a294",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cross"
}
},
{
"id": "ba9bbefdbf00b9adbe4146fa25a173cf",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKS PET A65"
}
},
{
"id": "c4f281b0811ad71205e01e6a2d197f50",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking Pedale mit Aluminiumk\u00f6rper mit 2K Kunststoffk\u00e4fig"
}
},
{
"id": "c6bf8113c8c1e0f04708ea890652cb71",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Alivio SL-M3100"
}
},
{
"id": "c8bb250ce4ae8f1cb3003218719fbfd5",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
}
},
{
"id": "ccb258c3687098253558c6400e307994",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon FS-50 EB, 50 Lux LED"
}
},
{
"id": "ce395d6c9752eb0348d69bc6c3701369",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR Essenza Plus"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "d85e79361de5b6fbc59470bee091ded0",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 22,95 kg (ohne Akku)"
}
},
{
"id": "d8c0575cd801118eb1338fb26bf6d936",
"_count": 1,
"groupId": "57d10a42e9e995a36d6bdafd88387f18",
"group": {
"id": "57d10a42e9e995a36d6bdafd88387f18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bosch"
}
},
{
"id": "da52c09b7fca19fc140ef84efab6cafb",
"_count": 1,
"groupId": "d9c530b6b501df9943bed7514c2b54d7",
"group": {
"id": "d9c530b6b501df9943bed7514c2b54d7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lithium-Ionen"
}
},
{
"id": "e011df406b574b97a281253e895a75ab",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB Riserbar"
}
},
{
"id": "ebe2946d388e152e4e37f0829ff81e54",
"_count": 1,
"groupId": "e445d5074a7f9c03ce70dcd85141cdb4",
"group": {
"id": "e445d5074a7f9c03ce70dcd85141cdb4",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "bis 25 km\/h"
}
},
{
"id": "ee7d6769a415bdd0a017907426fee20b",
"_count": 1,
"groupId": "b9987a246a537f4fe86f1f2e3d10dbdb",
"group": {
"id": "b9987a246a537f4fe86f1f2e3d10dbdb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bosch Intuvia 100"
}
},
{
"id": "f884042b2cfc30d754fcc18c405e2e9b",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "9"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
},
{
"id": "fd55a5a0843b99e6164c11734c6cd5a0",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
}
},
{
"id": "feacb384a797917192e078310178f4a0",
"_count": 1,
"groupId": "7524dd23d046d6b6828caeb359c3bdec",
"group": {
"id": "7524dd23d046d6b6828caeb359c3bdec",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "36 V"
}
},
{
"id": "ff38ae8d2e4e2225204122517de8b410",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
}
],
"options": [
{
"id": "47c6e8d507bbd38e8bf67a2a0e6f0b28",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "55 cm"
}
}
],
"categoryIds": [
"3fe94a002317b5f9259f82690aeea4cd",
"4f4adcbf8c6f66dcfc8a3282ac2bf10a",
"735b90b4568125ed6c3f678819b6e058",
"ad13a2a07ca4b7642959dc0c4c740ab6",
"fc490ca45c00b1249bbe3554a4fdf6fb"
],
"optionIds": [
"47c6e8d507bbd38e8bf67a2a0e6f0b28"
],
"propertyIds": [
"0622c5290bcc24edde88c19018975298",
"08b193a826b04fc8ad11cbbc8d96691d",
"091b1881da6ada5d701d830652b826ed",
"1e2eee1032b9111be4ab622683cb0cec",
"1ed920c9e27592593e21a6ddaba1a979",
"1ffcdd41a434dd9609377cdc8aa2a962",
"21cd52c4e14aac7a7087bf626dfdbf1d",
"392e6f01c2b6febda2120ee3215f87e4",
"397315c888154c00af3ddd4b408e452b",
"3a616a5305e06ccc883bda3ab63b10b5",
"47c6e8d507bbd38e8bf67a2a0e6f0b28",
"4b41626df1e86955aaa9426b871baded",
"4ec969a032686f09de30ead2a801c018",
"511f6ca5e8e4fd304dc2328351e0fc3c",
"5160fcc9ee2e7be23ebee69c6bff1fc0",
"52896ee90105dfb98b5b274dbdc0d216",
"56f0914098066909111fbdc71d8a725b",
"57ea44f19b74405f40baa45fc561493a",
"5b65ebfa39dd96a05a188a99c1413e51",
"67f2af956e501e394284a28890e86261",
"6a2769d67b9d89e8bf2b576102336c4f",
"6f89d193ef35c764823c0bf027eb088a",
"791e0a8c37ddc177fda60f15b87417bc",
"7c5810fa9eb432a1a1eae36e311adc32",
"7ce0ad7fc950edf06f4d5f10c4777692",
"8bac97b539149eca0b1176bca591d30e",
"93200dcdc342f4049c4c4045ec399ab9",
"9a1ca59e44df3249ff127d311b8b53bb",
"ba9bbefdbf00b9adbe4146fa25a173cf",
"c4f281b0811ad71205e01e6a2d197f50",
"c6bf8113c8c1e0f04708ea890652cb71",
"c8bb250ce4ae8f1cb3003218719fbfd5",
"ccb258c3687098253558c6400e307994",
"ce395d6c9752eb0348d69bc6c3701369",
"d215aedab5221382a37a177485268129",
"d85e79361de5b6fbc59470bee091ded0",
"d8c0575cd801118eb1338fb26bf6d936",
"da52c09b7fca19fc140ef84efab6cafb",
"e011df406b574b97a281253e895a75ab",
"ebe2946d388e152e4e37f0829ff81e54",
"ee7d6769a415bdd0a017907426fee20b",
"f884042b2cfc30d754fcc18c405e2e9b",
"fc7c95e8a0c10edfec779479917546ca",
"fd55a5a0843b99e6164c11734c6cd5a0",
"feacb384a797917192e078310178f4a0",
"ff38ae8d2e4e2225204122517de8b410"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 4.0,
"product_slider_terrain": 4.0,
"product_slider_ausstattung": 6.0,
"product_slider_e_bike": 8.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 106585.1,
"product_vk2_amazon": 4199.0,
"product_vk3_ebay": 4199.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Cross Lite EVO 1 750 Wh Herren silber 2024"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4199.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3528.57,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 8.7,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 8.7
},
"fields": {
"displayGroup": [
"ff88293f17a56c96566d6b0a081be062"
]
},
"sort": [
0,
"1c1a5c79d95fb07f55d2a6d3f73651f5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.14 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":"735b90b4568125ed6c3f678819b6e058"}}}},{"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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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"}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 3,
"shipping-free": {
"value": 1.0,
"value_as_string": "true"
}
},
"rating-exists": {
"doc_count": 3,
"rating": {
"value": 0.0
}
},
"price": {
"count": 3,
"min": 2888.0,
"max": 4199.0,
"avg": 3762.0,
"sum": 11286.0
},
"options": {
"doc_count": 3,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "47c6e8d507bbd38e8bf67a2a0e6f0b28",
"doc_count": 1
},
{
"key": "e330a259b38a4839bae4f1295c5a8a98",
"doc_count": 1
},
{
"key": "f1f1d3efdfd24e76deecaaafb78e5b91",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 138,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0622c5290bcc24edde88c19018975298",
"doc_count": 3
},
{
"key": "08b193a826b04fc8ad11cbbc8d96691d",
"doc_count": 3
},
{
"key": "091b1881da6ada5d701d830652b826ed",
"doc_count": 3
},
{
"key": "1e2eee1032b9111be4ab622683cb0cec",
"doc_count": 3
},
{
"key": "1ed920c9e27592593e21a6ddaba1a979",
"doc_count": 3
},
{
"key": "1ffcdd41a434dd9609377cdc8aa2a962",
"doc_count": 3
},
{
"key": "21cd52c4e14aac7a7087bf626dfdbf1d",
"doc_count": 3
},
{
"key": "392e6f01c2b6febda2120ee3215f87e4",
"doc_count": 3
},
{
"key": "397315c888154c00af3ddd4b408e452b",
"doc_count": 3
},
{
"key": "3a616a5305e06ccc883bda3ab63b10b5",
"doc_count": 3
},
{
"key": "4b41626df1e86955aaa9426b871baded",
"doc_count": 3
},
{
"key": "4ec969a032686f09de30ead2a801c018",
"doc_count": 3
},
{
"key": "511f6ca5e8e4fd304dc2328351e0fc3c",
"doc_count": 3
},
{
"key": "5160fcc9ee2e7be23ebee69c6bff1fc0",
"doc_count": 3
},
{
"key": "52896ee90105dfb98b5b274dbdc0d216",
"doc_count": 3
},
{
"key": "56f0914098066909111fbdc71d8a725b",
"doc_count": 3
},
{
"key": "57ea44f19b74405f40baa45fc561493a",
"doc_count": 3
},
{
"key": "5b65ebfa39dd96a05a188a99c1413e51",
"doc_count": 3
},
{
"key": "67f2af956e501e394284a28890e86261",
"doc_count": 3
},
{
"key": "6a2769d67b9d89e8bf2b576102336c4f",
"doc_count": 3
},
{
"key": "6f89d193ef35c764823c0bf027eb088a",
"doc_count": 3
},
{
"key": "791e0a8c37ddc177fda60f15b87417bc",
"doc_count": 3
},
{
"key": "7c5810fa9eb432a1a1eae36e311adc32",
"doc_count": 3
},
{
"key": "7ce0ad7fc950edf06f4d5f10c4777692",
"doc_count": 3
},
{
"key": "8bac97b539149eca0b1176bca591d30e",
"doc_count": 3
},
{
"key": "93200dcdc342f4049c4c4045ec399ab9",
"doc_count": 3
},
{
"key": "9a1ca59e44df3249ff127d311b8b53bb",
"doc_count": 3
},
{
"key": "ba9bbefdbf00b9adbe4146fa25a173cf",
"doc_count": 3
},
{
"key": "c4f281b0811ad71205e01e6a2d197f50",
"doc_count": 3
},
{
"key": "c6bf8113c8c1e0f04708ea890652cb71",
"doc_count": 3
},
{
"key": "c8bb250ce4ae8f1cb3003218719fbfd5",
"doc_count": 3
},
{
"key": "ccb258c3687098253558c6400e307994",
"doc_count": 3
},
{
"key": "ce395d6c9752eb0348d69bc6c3701369",
"doc_count": 3
},
{
"key": "d215aedab5221382a37a177485268129",
"doc_count": 3
},
{
"key": "d85e79361de5b6fbc59470bee091ded0",
"doc_count": 3
},
{
"key": "d8c0575cd801118eb1338fb26bf6d936",
"doc_count": 3
},
{
"key": "da52c09b7fca19fc140ef84efab6cafb",
"doc_count": 3
},
{
"key": "e011df406b574b97a281253e895a75ab",
"doc_count": 3
},
{
"key": "ebe2946d388e152e4e37f0829ff81e54",
"doc_count": 3
},
{
"key": "ee7d6769a415bdd0a017907426fee20b",
"doc_count": 3
},
{
"key": "f884042b2cfc30d754fcc18c405e2e9b",
"doc_count": 3
},
{
"key": "fc7c95e8a0c10edfec779479917546ca",
"doc_count": 3
},
{
"key": "fd55a5a0843b99e6164c11734c6cd5a0",
"doc_count": 3
},
{
"key": "feacb384a797917192e078310178f4a0",
"doc_count": 3
},
{
"key": "ff38ae8d2e4e2225204122517de8b410",
"doc_count": 3
},
{
"key": "47c6e8d507bbd38e8bf67a2a0e6f0b28",
"doc_count": 1
},
{
"key": "e330a259b38a4839bae4f1295c5a8a98",
"doc_count": 1
},
{
"key": "f1f1d3efdfd24e76deecaaafb78e5b91",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6462331a69cdc7b76dc81136ca2713dd",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|