1 |
7.08 ms |
Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cd381f78cbec4869a23ae2b8d8f18bf8"}}}},{"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_rule20af0824a454454e9990d95b444fa21d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleebd6d5cf8ded4a0c8d2c9d6f3e07a632_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01fe82e0af2f44088220280fa0620a21_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled4618787540a424daa04e260988afd3b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6c64ee35e8c44f6caced8d2ec8edae92_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fed02ebe194464094b2eb785108f7dd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulececdc5ee788c4554b7a812d4fea46b1b_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}}},"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}}}},"gbmed_labelling_tyres_fuel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.fuel"}}]}},{"term":{"gbmedLabellingTyres.fuel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_fuel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_fuel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_fuel":{"terms":{"field":"gbmedLabellingTyres.fuel","size":10000}}}}}}}},"gbmed_labelling_tyres_grip":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.grip"}}]}},{"term":{"gbmedLabellingTyres.grip":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_grip":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_grip":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_grip":{"terms":{"field":"gbmedLabellingTyres.grip","size":10000}}}}}}}},"gbmed_labelling_tyres_noise":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.noise"}}]}},{"term":{"gbmedLabellingTyres.noise":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_noise":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_noise":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_noise":{"terms":{"field":"gbmedLabellingTyres.noise","size":10000}}}}}}}},"gbmed_labelling_tyres_decibel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.decibel"}}]}},{"term":{"gbmedLabellingTyres.decibel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_decibel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_decibel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_decibel":{"stats":{"field":"gbmedLabellingTyres.decibel"}}}}}}}}},"size":0}}
{"index":"live_product_d5cccd27ea6445358587252a326c85df","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"cd381f78cbec4869a23ae2b8d8f18bf8"}}}},{"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_rule20af0824a454454e9990d95b444fa21d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleebd6d5cf8ded4a0c8d2c9d6f3e07a632_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01fe82e0af2f44088220280fa0620a21_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled4618787540a424daa04e260988afd3b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6c64ee35e8c44f6caced8d2ec8edae92_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fed02ebe194464094b2eb785108f7dd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulececdc5ee788c4554b7a812d4fea46b1b_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}}},"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}}}},"gbmed_labelling_tyres_fuel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.fuel"}}]}},{"term":{"gbmedLabellingTyres.fuel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_fuel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_fuel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_fuel":{"terms":{"field":"gbmedLabellingTyres.fuel","size":10000}}}}}}}},"gbmed_labelling_tyres_grip":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.grip"}}]}},{"term":{"gbmedLabellingTyres.grip":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_grip":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_grip":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_grip":{"terms":{"field":"gbmedLabellingTyres.grip","size":10000}}}}}}}},"gbmed_labelling_tyres_noise":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.noise"}}]}},{"term":{"gbmedLabellingTyres.noise":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_noise":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_noise":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_noise":{"terms":{"field":"gbmedLabellingTyres.noise","size":10000}}}}}}}},"gbmed_labelling_tyres_decibel":{"filter":{"bool":{"must_not":[{"nested":{"path":"gbmedLabellingTyres","query":{"bool":{"must":[{"bool":{"must_not":[{"exists":{"field":"gbmedLabellingTyres.decibel"}}]}},{"term":{"gbmedLabellingTyres.decibel":""}}]}}}}]}},"aggregations":{"gbmed_labelling_tyres_decibel":{"nested":{"path":"gbmedLabellingTyres"},"aggregations":{"gbmed_labelling_tyres_decibel":{"filter":{"term":{"gbmedLabellingTyres.active":true}},"aggregations":{"gbmed_labelling_tyres_decibel":{"stats":{"field":"gbmedLabellingTyres.decibel"}}}}}}}}},"size":0}}
{"took":5,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":5,"relation":"eq"},"max_score":null,"hits":[]},"aggregations":{"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":5,"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_decibel":{"count":0,"min":null,"max":null,"avg":null,"sum":0.0}}}},"shipping-free-filter":{"doc_count":0,"shipping-free":{"value":null}},"rating-exists":{"doc_count":5,"rating":{"value":0.0}},"price":{"count":5,"min":10.5,"max":138.5,"avg":55.67999999999999,"sum":278.4},"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":5,"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_noise":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}}}},"gbmed_labelling_tyres_fuel":{"meta":[],"doc_count":5,"gbmed_labelling_tyres_fuel":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_fuel":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_fuel":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}}}},"options":{"doc_count":0,"options":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}},"properties":{"doc_count":10,"properties":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"c97478e6d3c349d2bfb68519428f805b","doc_count":2},{"key":"2407ecb607b74f3c933c9d93c5ccacd4","doc_count":1},{"key":"36d009d13cc14ae880897bd0b14d7c66","doc_count":1},{"key":"7fd13cb8563b4ca1876898edba33b7a9","doc_count":1},{"key":"8c0da4bfec9545cda6da6548c6e5edf9","doc_count":1},{"key":"c9ef86b1069246ddb82a8813cb98cba1","doc_count":1},{"key":"dc6f98beeca44852beb078a9e8e21e7d","doc_count":1},{"key":"e7bac0636648463eb41deefbcc956f10","doc_count":1},{"key":"f2f18a9c2c2e4d93885a74eb2710c70c","doc_count":1}]}},"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":5,"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":0,"gbmed_labelling_tyres_grip":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}}}},"manufacturer":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"602d56693a5c4391a526772243aed941","doc_count":4},{"key":"045c1d5daf40465aafd9a67bb45f8bd6","doc_count":1}]}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|
2 |
3.51 ms |
Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["3ecca4c8f3c74b9584ced3d28aa6fc2e","97e4909ead4a41aba6c0dc94c5a37712","5c013392df4d4ac4a5fb00140c561c31","52b326b357ff4b1ab262e4e1e06fe954","37384ca8107c4d71a1261306b771306e"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["3ecca4c8f3c74b9584ced3d28aa6fc2e","97e4909ead4a41aba6c0dc94c5a37712","5c013392df4d4ac4a5fb00140c561c31","52b326b357ff4b1ab262e4e1e06fe954","37384ca8107c4d71a1261306b771306e"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}
{"took":2,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":5,"relation":"eq"},"max_score":0.0,"hits":[{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"52b326b357ff4b1ab262e4e1e06fe954","_score":0.0,"_source":{"fullText":"BRUNNER Sweeping set, Tidy, grey Modern mini sweeping set consisting of hand brush and dustpan. Stow away to save space Material: plasticColor: gray ZQANCB0203020N\n ZQANCB0203020N","id":"52b326b357ff4b1ab262e4e1e06fe954","fullTextBoosted":"BRUNNER Sweeping set, Tidy, grey Modern mini sweeping set consisting of hand brush and dustpan. Stow away to save space Material: plasticColor: gray ZQANCB0203020N\n ZQANCB0203020N"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"5c013392df4d4ac4a5fb00140c561c31","_score":0.0,"_source":{"fullText":"Side table Kadre Compact side table with sturdy rolling top in painted aluminum. Foldable steel frameMultiple usesWith packing bag. ZQANCB0406041N\n ZQANCB0406041N","id":"5c013392df4d4ac4a5fb00140c561c31","fullTextBoosted":"Side table Kadre Compact side table with sturdy rolling top in painted aluminum. Foldable steel frameMultiple usesWith packing bag. ZQANCB0406041N\n ZQANCB0406041N"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"97e4909ead4a41aba6c0dc94c5a37712","_score":0.0,"_source":{"fullText":"BRUNNER telescopic ladder, LADDY ALCOVE Telescopic aluminium alcove ladder. Allows easy access to alcove beds. With 2 fixing hooks. Easy to carry and height adjustable. Equipped with non-slip rubber pads for increased safety. Compact storage.Adjustable to optimal height:Max. ladder length: 210 x 36 x 6 cmFolded: 67 x 36 x 6 cmMax. load: 150 kg ZQANCB7225121N\n ZQANCB7225121N","id":"97e4909ead4a41aba6c0dc94c5a37712","fullTextBoosted":"BRUNNER telescopic ladder, LADDY ALCOVE Telescopic aluminium alcove ladder. Allows easy access to alcove beds. With 2 fixing hooks. Easy to carry and height adjustable. Equipped with non-slip rubber pads for increased safety. Compact storage.Adjustable to optimal height:Max. ladder length: 210 x 36 x 6 cmFolded: 67 x 36 x 6 cmMax. load: 150 kg ZQANCB7225121N\n ZQANCB7225121N"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"3ecca4c8f3c74b9584ced3d28aa6fc2e","_score":0.0,"_source":{"fullText":"Mercedes-Benz Collapsible chair, black This black folding chair is ideally suited to the resting of tired legs. It is made up of a stable steel tube frame and is enhanced with a durable cover made from polyester. This folding chair also has comfortable armrests and has an integral cup holder on both sides, in which bottles or mugs can be safely stowed. The chair can hold up to 160 kg and, thanks to a matching transport bag, can be easily carried everywhere. An embroidered Mercedes star on the front of the backrest as well as also embroidered Mercedes-Benz lettering on the back of the backrest nicely round off the unobtrusive design of this folding chair.Colour: black\nMaterial: steel\nDimensions when packed: Approx. 17 x 97 cm\nDimensions when erected: Approx. 90 x 60 x 50\/90 cm\nIncludes transport bag\nmade for Mercedes-Benz by BRUNNER MB6 6 95 8979\n MB6 6 95 8979","id":"3ecca4c8f3c74b9584ced3d28aa6fc2e","fullTextBoosted":"Mercedes-Benz Collapsible chair, black This black folding chair is ideally suited to the resting of tired legs. It is made up of a stable steel tube frame and is enhanced with a durable cover made from polyester. This folding chair also has comfortable armrests and has an integral cup holder on both sides, in which bottles or mugs can be safely stowed. The chair can hold up to 160 kg and, thanks to a matching transport bag, can be easily carried everywhere. An embroidered Mercedes star on the front of the backrest as well as also embroidered Mercedes-Benz lettering on the back of the backrest nicely round off the unobtrusive design of this folding chair.Colour: black\nMaterial: steel\nDimensions when packed: Approx. 17 x 97 cm\nDimensions when erected: Approx. 90 x 60 x 50\/90 cm\nIncludes transport bag\nmade for Mercedes-Benz by BRUNNER MB6 6 95 8979\n MB6 6 95 8979"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"37384ca8107c4d71a1261306b771306e","_score":0.0,"_source":{"fullText":"BRUNNER Clothesline \"Drywheel\" Clothesline made of PP in practical roll-up box. With fastening hookLength: 5.5 m ZQANCB7202802N\n ZQANCB7202802N","id":"37384ca8107c4d71a1261306b771306e","fullTextBoosted":"BRUNNER Clothesline \"Drywheel\" Clothesline made of PP in practical roll-up box. With fastening hookLength: 5.5 m ZQANCB7202802N\n ZQANCB7202802N"}}]}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|