| 1 |
5.30 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["105590"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","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_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}},"order":"ASC"}}],"from":0,"size":24,"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": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1725967126",
"_id": "4ca303d4b03cd0e2ebb413941bbe3ead",
"_score": null,
"_source": {
"id": "4ca303d4b03cd0e2ebb413941bbe3ead",
"autoIncrement": 82885.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "105590",
"ean": "4063518253814",
"displayGroup": "3bcd4914ee8de27a29c4c1548b37e615",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "5f5166c1f13757c72e0ab605ca43a070",
"manufacturerNumber": "505-75728",
"releaseDate": null,
"createdAt": "2023-10-16T11:20:55+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"f033ab37c30201f73f142449d037028d",
"7eacb532570ff6858afd2723755ff790",
"e0c641195b27425bb056ac56f8953d24",
"33e75ff09dd601bbe69f351039152189",
"c0c7c76d30bd3dcaefc96f40275bdc0a",
"2838023a778dfaecdc212708f721b788",
"019d385eb67632a7e958e23f24bd07d7",
"d82c8d1619ad8176d665453cfb2e55f0"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "7eacb532570ff6858afd2723755ff790",
"_count": 1
},
{
"id": "e0c641195b27425bb056ac56f8953d24",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "c0c7c76d30bd3dcaefc96f40275bdc0a",
"_count": 1
},
{
"id": "2838023a778dfaecdc212708f721b788",
"_count": 1
},
{
"id": "019d385eb67632a7e958e23f24bd07d7",
"_count": 1
},
{
"id": "d82c8d1619ad8176d665453cfb2e55f0",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "4adac056b82344a96ea28bb1b28dd155",
"childCount": 0,
"categories": [
{
"id": "019d385eb67632a7e958e23f24bd07d7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jugendr\u00e4der und ATB"
}
},
{
"id": "2838023a778dfaecdc212708f721b788",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderfahrrad 20 Zoll"
}
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "7eacb532570ff6858afd2723755ff790",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "X-MAS Deals"
}
},
{
"id": "c0c7c76d30bd3dcaefc96f40275bdc0a",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderfahrrad 20 - 24 Zoll"
}
},
{
"id": "d82c8d1619ad8176d665453cfb2e55f0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jungen"
}
},
{
"id": "e0c641195b27425bb056ac56f8953d24",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad X-MAS Deals"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "5f5166c1f13757c72e0ab605ca43a070",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pegasus"
},
"_count": 1
},
"properties": [
{
"id": "103dd9c2a4e1e51101a50dd26cd61907",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "6061 Aluminium"
}
},
{
"id": "174d858c0abb5e9b268b53f031b4a7bf",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids Plattformpedale"
}
},
{
"id": "19cc328bdf679ba5019e3a35db4cccfe",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5"
}
},
{
"id": "1e2eee1032b9111be4ab622683cb0cec",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2024"
}
},
{
"id": "219ee48620758c36678f64df15b5d895",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoff"
}
},
{
"id": "228882e4c118013ded3586e543137d84",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DBM-2"
}
},
{
"id": "25db3c138d7d96b11a5ef9ee9254591e",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "2bc27b9e16de4a4f86821b8ae033acfa",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "PEGASUS, 50-406"
}
},
{
"id": "31b18cc0028c355db965ab14bfdf1d82",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28 cm"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "4238d0dc2eab2768559b9cf906a0a69c",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Quill"
}
},
{
"id": "4e5f623bc8bc45b727f6c5facaf419ea",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR SUNTOUR M-3010"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "5218a25e096aab34744cd56279b73a61",
"_count": 1,
"groupId": "7eb4ca27b65686333ee285cbf14f1768",
"group": {
"id": "7eb4ca27b65686333ee285cbf14f1768",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nexus 7-Gang, mit R\u00fccktritt"
}
},
{
"id": "5725225d8d211568332388ef2f46b9b9",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "7"
}
},
{
"id": "60025e489eb4b77d67fa433a3fdd2cec",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20\""
}
},
{
"id": "69996407f8198972c641d347dfd74d8b",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking Comfort"
}
},
{
"id": "7052790f352e0b66c5f5ceea1429da94",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "76cb0dd555576ce230b1b9aba5465faa",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mittelbaust\u00e4nder, zul\u00e4ssiges Gesamtgewicht 115 kg"
}
},
{
"id": "782338fe90af0d7a11195d22e991f6cf",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Y-Rahmen"
}
},
{
"id": "7c03ab1ae7980106bf3e79671f37ad56",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jungen"
}
},
{
"id": "91383745887c934774085ed175dcd012",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "wei\u00df"
}
},
{
"id": "9acc664466a84ba14ebd9f39e8f4698e",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "9d5151cd089e54409c4fa34223081233",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "a02f92ccbe2773615526e843bb5a61cb",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "11"
}
},
{
"id": "a521885a0aa19c283405ee805af17e78",
"_count": 1,
"groupId": "90172b5a229214a431a4352c66865e89",
"group": {
"id": "90172b5a229214a431a4352c66865e89",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nabendynamo"
}
},
{
"id": "ad9da94781af21832edc38439938115d",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoffschutzblech"
}
},
{
"id": "b23b2f8b7203314dff8e33b89a83aafc",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon R-20, LED mit Standlichtfunktion"
}
},
{
"id": "b2a6d2c74be3c9782cc83fb61fcba0fe",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nabenschaltung"
}
},
{
"id": "b36a5fe8ac3493ded80f39d28e54b74d",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Felgenbremse"
}
},
{
"id": "c56cf5188d368dbbdc85ac08941bfe32",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Nexus SL-C3000 Revoshift"
}
},
{
"id": "c9b4f7af880ada676f5fedc8be81aa4a",
"_count": 1,
"groupId": "a6422bb08b1146d1c55779ac81586ab3",
"group": {
"id": "a6422bb08b1146d1c55779ac81586ab3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl mit Federklappe"
}
},
{
"id": "d00511a605f9adf30bb5739c67d4d6dd",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon FS-30, 30 Lux LED mit Schalter"
}
},
{
"id": "daa242c4eb2fcfb79878405af169ef20",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "PROWHEEL 38T"
}
}
],
"options": [
{
"id": "31b18cc0028c355db965ab14bfdf1d82",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28 cm"
}
}
],
"categoryIds": [
"019d385eb67632a7e958e23f24bd07d7",
"2838023a778dfaecdc212708f721b788",
"33e75ff09dd601bbe69f351039152189",
"7eacb532570ff6858afd2723755ff790",
"c0c7c76d30bd3dcaefc96f40275bdc0a",
"d82c8d1619ad8176d665453cfb2e55f0",
"e0c641195b27425bb056ac56f8953d24",
"f033ab37c30201f73f142449d037028d"
],
"optionIds": [
"31b18cc0028c355db965ab14bfdf1d82"
],
"propertyIds": [
"103dd9c2a4e1e51101a50dd26cd61907",
"174d858c0abb5e9b268b53f031b4a7bf",
"19cc328bdf679ba5019e3a35db4cccfe",
"1e2eee1032b9111be4ab622683cb0cec",
"219ee48620758c36678f64df15b5d895",
"228882e4c118013ded3586e543137d84",
"25db3c138d7d96b11a5ef9ee9254591e",
"2bc27b9e16de4a4f86821b8ae033acfa",
"31b18cc0028c355db965ab14bfdf1d82",
"3a616a5305e06ccc883bda3ab63b10b5",
"4238d0dc2eab2768559b9cf906a0a69c",
"4e5f623bc8bc45b727f6c5facaf419ea",
"4ec969a032686f09de30ead2a801c018",
"5218a25e096aab34744cd56279b73a61",
"5725225d8d211568332388ef2f46b9b9",
"60025e489eb4b77d67fa433a3fdd2cec",
"69996407f8198972c641d347dfd74d8b",
"7052790f352e0b66c5f5ceea1429da94",
"76cb0dd555576ce230b1b9aba5465faa",
"782338fe90af0d7a11195d22e991f6cf",
"7c03ab1ae7980106bf3e79671f37ad56",
"91383745887c934774085ed175dcd012",
"9acc664466a84ba14ebd9f39e8f4698e",
"9d5151cd089e54409c4fa34223081233",
"a02f92ccbe2773615526e843bb5a61cb",
"a521885a0aa19c283405ee805af17e78",
"ad9da94781af21832edc38439938115d",
"b23b2f8b7203314dff8e33b89a83aafc",
"b2a6d2c74be3c9782cc83fb61fcba0fe",
"b36a5fe8ac3493ded80f39d28e54b74d",
"c56cf5188d368dbbdc85ac08941bfe32",
"c9b4f7af880ada676f5fedc8be81aa4a",
"d00511a605f9adf30bb5739c67d4d6dd",
"daa242c4eb2fcfb79878405af169ef20"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 3.0,
"product_slider_terrain": 3.0,
"product_slider_ausstattung": 3.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 105590.0,
"product_vk2_amazon": 549.0,
"product_vk3_ebay": 549.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pegasus Avanti 20'' 7-Gang Jungen wei\u00df 2024"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 529.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 444.54,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 18.61,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 18.61
},
"fields": {
"displayGroup": [
"3bcd4914ee8de27a29c4c1548b37e615"
]
},
"sort": [
529.0
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.76 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["3118","6924","7981","10688"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","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_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}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1725967126",
"_id": "7f2111cbef86a223862e0fdd2577705c",
"_score": null,
"_source": {
"id": "7f2111cbef86a223862e0fdd2577705c",
"autoIncrement": 86782.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 7,
"productNumber": "7981",
"ean": "4006942610945",
"displayGroup": "d3e1bf6643a6693d4eae3500c75be248",
"sales": 0,
"stock": 7,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "d28953dc583bdbc8ec803ad2394269bc",
"manufacturerNumber": "085-30221",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:48+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"1534b76d325a8f591b52d302e7181331"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "1534b76d325a8f591b52d302e7181331",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "58214790defcc0c62a3c1f4f7e1aa173",
"childCount": 0,
"categories": [
{
"id": "1534b76d325a8f591b52d302e7181331",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderartikel"
}
}
],
"manufacturer": {
"id": "d28953dc583bdbc8ec803ad2394269bc",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SMG"
},
"_count": 1
},
"properties": [
{
"id": "4eee70ed64219d5914eb3cf6d1c61506",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
}
],
"options": [],
"categoryIds": [
"1534b76d325a8f591b52d302e7181331",
"28dd2c7955ce926456240b2ff0100bde",
"854d6fae5ee42911677c739ee1734486"
],
"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": "Montage1",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 5.99,
"product_vk3_ebay": 5.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Speichen-Klicker-Perlen"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.03,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"d3e1bf6643a6693d4eae3500c75be248"
]
},
"sort": [
5.99
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "4e246a381baf2ce038b3b0f82c7d6fb4",
"_score": null,
"_source": {
"id": "4e246a381baf2ce038b3b0f82c7d6fb4",
"autoIncrement": 86467.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 971,
"productNumber": "6924",
"ean": "4003318112584",
"displayGroup": "683367759c4b6caa5c63b9617597ce17",
"sales": 0,
"stock": 971,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "496 LH NKR",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:08+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"31fefc0e570cb3860f2a6d4b38c6490d"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "233ea7fe02cd72a4cae3414108b59b1a",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rahmenschl\u00f6sser"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "4bbd9c23e810a10a299357ea4c2b94ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"31fefc0e570cb3860f2a6d4b38c6490d",
"9872ed9fc22fc182d371c3e9ed316094"
],
"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_vk2_amazon": 21.95,
"product_vk3_ebay": 21.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Rahmenschloss Tectic 496"
},
"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": [
"683367759c4b6caa5c63b9617597ce17"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1725967126",
"_id": "f0031c7a91d74015a9addfbc589f3fe5",
"_score": null,
"_source": {
"id": "f0031c7a91d74015a9addfbc589f3fe5",
"autoIncrement": 86456.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 42,
"productNumber": "3118",
"ean": "4016224071609",
"displayGroup": "4d976c91496e51a8b12c1c8e8ed9f246",
"sales": 0,
"stock": 42,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9a29c5277361e6bb969ec5dbbc61fba2",
"manufacturerNumber": "050-24701",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:05+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"d1f491a404d6854880943e5c3cd9ca25",
"1afa34a7f984eeabdbb0a7d494132ee5"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "d1f491a404d6854880943e5c3cd9ca25",
"_count": 1
},
{
"id": "1afa34a7f984eeabdbb0a7d494132ee5",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "3e51b135b16c6e3f936d4fa088ceb351",
"childCount": 0,
"categories": [
{
"id": "1afa34a7f984eeabdbb0a7d494132ee5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mit Kabel"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "d1f491a404d6854880943e5c3cd9ca25",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Computer & Navigation"
}
}
],
"manufacturer": {
"id": "9a29c5277361e6bb969ec5dbbc61fba2",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sigma"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"1afa34a7f984eeabdbb0a7d494132ee5",
"28dd2c7955ce926456240b2ff0100bde",
"d1f491a404d6854880943e5c3cd9ca25"
],
"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": "Montage1",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 18.95,
"product_vk3_ebay": 18.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sigma Computer BC 7.16"
},
"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,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
},
"fields": {
"displayGroup": [
"4d976c91496e51a8b12c1c8e8ed9f246"
]
},
"sort": [
24.95
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|