| 1 |
5.06 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":"2d551f747e8747098563247916366e3c"}}}},{"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":6,"relation":"eq"},"max_score":null,"hits":[]},"aggregations":{"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":6,"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":6,"rating":{"value":0.0}},"price":{"count":6,"min":60.79,"max":82.0,"avg":68.51333333333334,"sum":411.08000000000004},"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":6,"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":6,"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":2,"options":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"5d67392234f640bc8a4b41f6e03ea3ef","doc_count":1},{"key":"f4efff77d8a44ec1b902b602e4f31e55","doc_count":1}]}},"properties":{"doc_count":38,"properties":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"8c0da4bfec9545cda6da6548c6e5edf9","doc_count":5},{"key":"c9ef86b1069246ddb82a8813cb98cba1","doc_count":5},{"key":"ef8dbeb3c9ed45daac7ceb65de741056","doc_count":5},{"key":"a75304c31be547859893d57c78f23aed","doc_count":4},{"key":"e7bac0636648463eb41deefbcc956f10","doc_count":4},{"key":"1ba7d13e01d4495ca4045661c05ceeff","doc_count":3},{"key":"878c5e9da4b542098e2bf1f37b79765e","doc_count":3},{"key":"8ef30e56aa0048eb9b19ea389bdbf60c","doc_count":3},{"key":"e8787d167bb242a181ac1e402ed27592","doc_count":3},{"key":"c97478e6d3c349d2bfb68519428f805b","doc_count":2},{"key":"bdb80fc6db394f60b1886fec7baaeadc","doc_count":1}]}},"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":6,"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":"045c1d5daf40465aafd9a67bb45f8bd6","doc_count":3},{"key":"b1984298f6f548bc8a5eb35cef6abf39","doc_count":3}]}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|
| 2 |
3.02 ms |
Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["35d389ed624c4562916f6f366cef78ce","b00e390ed5174a01aecc2309fd07308f","12f5044e8e6848a89b895a3829429c34","fcf295985e7440568014b47e0910d018","a7b51d84ec1c4f65b3e7031646983247"]}},{"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":1,"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":"35d389ed624c4562916f6f366cef78ce","_score":0.0,"_source":{"fullText":"Mercedes-Benz V-Class, side window wind deflector, 2-piece Retrofit side window wind deflector: Protects against wind and water when the window is slightly open. Acrylic glass, tinted Set for driver and passenger sideAcrylic glasstintedSet for driver and passenger sideNote: Assembly without drilling, by bracing in the sealing lip of the window guide. MA447 766 25 00\n MA447 766 25 00","id":"35d389ed624c4562916f6f366cef78ce","fullTextBoosted":"Mercedes-Benz V-Class, side window wind deflector, 2-piece Retrofit side window wind deflector: Protects against wind and water when the window is slightly open. Acrylic glass, tinted Set for driver and passenger sideAcrylic glasstintedSet for driver and passenger sideNote: Assembly without drilling, by bracing in the sealing lip of the window guide. MA447 766 25 00\n MA447 766 25 00"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"12f5044e8e6848a89b895a3829429c34","_score":0.0,"_source":{"fullText":"Brandrup AIRSCREEN\u00ae for the hinged window, ACTIVITY & HORIZON Suitable for ACTIVITY & HORIZONThe AIRSCREEN\u00ae allows the hinged window to be opened without restriction in the rain.\n\neasy attachment by suction cups on the hinged windownot suitable for vehicles with awning. ZQANZB102702501\n ZQANZB102702501","id":"12f5044e8e6848a89b895a3829429c34","fullTextBoosted":"Brandrup AIRSCREEN\u00ae for the hinged window, ACTIVITY & HORIZON Suitable for ACTIVITY & HORIZONThe AIRSCREEN\u00ae allows the hinged window to be opened without restriction in the rain.\n\neasy attachment by suction cups on the hinged windownot suitable for vehicles with awning. ZQANZB102702501\n ZQANZB102702501"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"a7b51d84ec1c4f65b3e7031646983247","_score":0.0,"_source":{"fullText":"Mercedes-Benz mud flap set, V-Class, front axle The mud flaps protect your vehicle from road dirt, stone chips, scratches and stone chips in the area of the side flanks, the rear and in the underbody area. They protect following traffic from stone chips, splashing water and pollution. The shape of the mud flaps is precisely adapted to the vehicle contour. Their look is dynamic. This preserves the overall appearance of the vehicle. The high-quality material is extremely durable, long-lasting and UV-resistant.Scope of delivery: 2x mud flaps, mounting hardwarePlease note:\nNot for vehicles with AMG line (code PS2). Not in conjunction with code CN1 - sill trim.\n\n\n\n\n ZQ4478900000SET_\n ZQ4478900000SET_","id":"a7b51d84ec1c4f65b3e7031646983247","fullTextBoosted":"Mercedes-Benz mud flap set, V-Class, front axle The mud flaps protect your vehicle from road dirt, stone chips, scratches and stone chips in the area of the side flanks, the rear and in the underbody area. They protect following traffic from stone chips, splashing water and pollution. The shape of the mud flaps is precisely adapted to the vehicle contour. Their look is dynamic. This preserves the overall appearance of the vehicle. The high-quality material is extremely durable, long-lasting and UV-resistant.Scope of delivery: 2x mud flaps, mounting hardwarePlease note:\nNot for vehicles with AMG line (code PS2). Not in conjunction with code CN1 - sill trim.\n\n\n\n\n ZQ4478900000SET_\n ZQ4478900000SET_"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"b00e390ed5174a01aecc2309fd07308f","_score":0.0,"_source":{"fullText":"Brandrup AIRSCREEN\u00ae, Mercedes-Benz Marco-Polo Transparent and elegant rainwater protection for the left sliding window, including adjustable ventilation position.Airscreen\u00ae is pulled into the standard aluminum rail of the Marco Polo or in all other vehicles into the TOP-RAIL.Note: The protection must be removed while driving!\n ZQANZB100702502\n ZQANZB100702502","id":"b00e390ed5174a01aecc2309fd07308f","fullTextBoosted":"Brandrup AIRSCREEN\u00ae, Mercedes-Benz Marco-Polo Transparent and elegant rainwater protection for the left sliding window, including adjustable ventilation position.Airscreen\u00ae is pulled into the standard aluminum rail of the Marco Polo or in all other vehicles into the TOP-RAIL.Note: The protection must be removed while driving!\n ZQANZB100702502\n ZQANZB100702502"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"fcf295985e7440568014b47e0910d018","_score":0.0,"_source":{"fullText":"Mercedes-Benz mud flap set, V-Class, rear axle, black The mud flaps protect your vehicle from road dirt, stone chips, scratches and stone chips in the area of the side flanks, the rear and in the underbody area. They protect following traffic from stone chips, splashing water and pollution. The shape of the mud flaps is precisely adapted to the vehicle contour. Their look is dynamic. This preserves the overall appearance of the vehicle. The high-quality material is extremely durable, long-lasting and UV-resistant.Scope of delivery: 2x mud flaps, mounting hardwareFor installation, the rear wheels must be off \/ on.Note: Not for vehicles with AMG Line (code PS2) & not for vehicles with code A1 body length A1, wheelbase 3200mm ZQ4478900100SET.\n ZQ4478900100SET.","id":"fcf295985e7440568014b47e0910d018","fullTextBoosted":"Mercedes-Benz mud flap set, V-Class, rear axle, black The mud flaps protect your vehicle from road dirt, stone chips, scratches and stone chips in the area of the side flanks, the rear and in the underbody area. They protect following traffic from stone chips, splashing water and pollution. The shape of the mud flaps is precisely adapted to the vehicle contour. Their look is dynamic. This preserves the overall appearance of the vehicle. The high-quality material is extremely durable, long-lasting and UV-resistant.Scope of delivery: 2x mud flaps, mounting hardwareFor installation, the rear wheels must be off \/ on.Note: Not for vehicles with AMG Line (code PS2) & not for vehicles with code A1 body length A1, wheelbase 3200mm ZQ4478900100SET.\n ZQ4478900100SET."}}]}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|