1 |
5.56 ms |
Request:
{"index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","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":"4ca9cc5fabd34a8d9d2e011b2c6f167c"}}}},{"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_2fbb5fe2e29a4d70aa5854ce7ce3e20b","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":"4ca9cc5fabd34a8d9d2e011b2c6f167c"}}}},{"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":3,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":4,"relation":"eq"},"max_score":null,"hits":[]},"aggregations":{"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":4,"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":4,"rating":{"value":0.0}},"price":{"count":4,"min":15.51,"max":189.0,"avg":77.365,"sum":309.46},"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":4,"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":4,"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":26,"properties":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"c9ef86b1069246ddb82a8813cb98cba1","doc_count":4},{"key":"e7bac0636648463eb41deefbcc956f10","doc_count":4},{"key":"a75304c31be547859893d57c78f23aed","doc_count":3},{"key":"ef8dbeb3c9ed45daac7ceb65de741056","doc_count":3},{"key":"17d8c9b2211d45aca846402aebbad7ec","doc_count":2},{"key":"1ba7d13e01d4495ca4045661c05ceeff","doc_count":2},{"key":"2407ecb607b74f3c933c9d93c5ccacd4","doc_count":2},{"key":"878c5e9da4b542098e2bf1f37b79765e","doc_count":2},{"key":"7704573ecbf54363a815f8bafd877e6e","doc_count":1},{"key":"8c0da4bfec9545cda6da6548c6e5edf9","doc_count":1},{"key":"8ef30e56aa0048eb9b19ea389bdbf60c","doc_count":1},{"key":"bdb80fc6db394f60b1886fec7baaeadc","doc_count":1}]}},"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":4,"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":"3d51ccbcecca498aa7599e680d49a434","doc_count":2},{"key":"12fa8e89f2554aae874bd24b9e1eae89","doc_count":1},{"key":"9663644abf2d4a99adfc02d79955b17c","doc_count":1}]}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|
2 |
3.68 ms |
Request:
{"index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["96d70ea9960b4578a6583aec05a9bee6","5c30b4fd20644e08ad5ed8f82a10ecc1","ac62e7909989408986c001ccd7056d4f","2487c7a0bb4a4b9a97853bc6e087a11f"]}},{"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_2fbb5fe2e29a4d70aa5854ce7ce3e20b","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["96d70ea9960b4578a6583aec05a9bee6","5c30b4fd20644e08ad5ed8f82a10ecc1","ac62e7909989408986c001ccd7056d4f","2487c7a0bb4a4b9a97853bc6e087a11f"]}},{"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":4,"relation":"eq"},"max_score":0.0,"hits":[{"_index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506","_type":"_doc","_id":"ac62e7909989408986c001ccd7056d4f","_score":0.0,"_source":{"fullText":"Westfalia Verl\u00e4ngerungskabel Verl\u00e4ngerungskabel mit Schukostecker und -kupplungL\u00e4nge: 25 m ZQANZW50702000\n ZQANZW50702000","id":"ac62e7909989408986c001ccd7056d4f","fullTextBoosted":"Westfalia Verl\u00e4ngerungskabel Verl\u00e4ngerungskabel mit Schukostecker und -kupplungL\u00e4nge: 25 m ZQANZW50702000\n ZQANZW50702000"}},{"_index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506","_type":"_doc","_id":"5c30b4fd20644e08ad5ed8f82a10ecc1","_score":0.0,"_source":{"fullText":"CEE-Adapterkabel (Anschluss Campingplatz) Schutzkontakt-Kupplung und CEE-Stecker 3-polig.230V\/16A mit Klappdeckelspritzwassergesch\u00fctztGummileitungH07RN-F3G 2,5 mm2L\u00e4nge: 1,5 Meter ZQCP80560\n ZQCP80560","id":"5c30b4fd20644e08ad5ed8f82a10ecc1","fullTextBoosted":"CEE-Adapterkabel (Anschluss Campingplatz) Schutzkontakt-Kupplung und CEE-Stecker 3-polig.230V\/16A mit Klappdeckelspritzwassergesch\u00fctztGummileitungH07RN-F3G 2,5 mm2L\u00e4nge: 1,5 Meter ZQCP80560\n ZQCP80560"}},{"_index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506","_type":"_doc","_id":"96d70ea9960b4578a6583aec05a9bee6","_score":0.0,"_source":{"fullText":"CEE-Adapterkabel (Anschluss Fahrzeug) Schutzkontakt-Kupplung und CEE-Stecker 3-polig.230V\/16A mit Klappdeckelspritzwassergesch\u00fctztGummileitungH07RN-F3G 2,5 mm2L\u00e4nge: 1,5 Meter ZQANZCP80565\n ZQANZCP80565","id":"96d70ea9960b4578a6583aec05a9bee6","fullTextBoosted":"CEE-Adapterkabel (Anschluss Fahrzeug) Schutzkontakt-Kupplung und CEE-Stecker 3-polig.230V\/16A mit Klappdeckelspritzwassergesch\u00fctztGummileitungH07RN-F3G 2,5 mm2L\u00e4nge: 1,5 Meter ZQANZCP80565\n ZQANZCP80565"}},{"_index":"live_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1675058506","_type":"_doc","_id":"2487c7a0bb4a4b9a97853bc6e087a11f","_score":0.0,"_source":{"fullText":"Thetford Porta Potti Qube 335 Porta Potti Qube 335Wassertank ca. 10 LiterAbwassertank ca. 10 LiterKolbenpumpeLeichter, hochwertiger KunststoffPraktische Entl\u00fcftungstaste f\u00fcr spritzfreie Entleerung ZQANZW52331500\n ZQANZW52331500","id":"2487c7a0bb4a4b9a97853bc6e087a11f","fullTextBoosted":"Thetford Porta Potti Qube 335 Porta Potti Qube 335Wassertank ca. 10 LiterAbwassertank ca. 10 LiterKolbenpumpeLeichter, hochwertiger KunststoffPraktische Entl\u00fcftungstaste f\u00fcr spritzfreie Entleerung ZQANZW52331500\n ZQANZW52331500"}}]}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|