| 1 |
3.20 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":"9f8de81d240f4b5b9c87b3c6b174f6d6"}}}},{"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}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|
| 2 |
2.84 ms |
Request:
{"index":"live_product_d5cccd27ea6445358587252a326c85df","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["df32cf165b754dd383f1b0c61f7405f4","dce4dab2622e4b518d8b8f196975eda6","c1e5ab0fce1c4e84a7ed6c7113f2f399","ba9aa1fc24a1438b9551eaeb246a9156","6f967bbf4e214808952050b8a7d9a0d3","5e53ca0302d54e69b5ba75e33e335fff","4ab73284985b44349ac90be9c90da00b"]}},{"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":7,"relation":"eq"},"max_score":0.0,"hits":[{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"dce4dab2622e4b518d8b8f196975eda6","_score":0.0,"_source":{"fullText":"Mercedes-Benz Trucks - Travellite cabin suitcase Stylish, durable and practical for on the go\n\nThe Travelite cabin suitcase combines timeless, sleek design with impressive durability to make your travels more enjoyable and worry-free. Carefully designed to meet your needs, this suitcase is the ideal choice for modern travelers.Rugged ABS hard shell:.\nThe outer shell of the suitcase is made of high quality ABS hard shell material, which ensures impact resistance and durability. Whether you are traveling on business or exploring the world, this cabin suitcase will stand up to the rigors of travel and protect your prized possessions.Perfect cabin size:.\nWith dimensions of 39cm x 55cm x 20cm, this suitcase is specifically designed to meet the carry-on requirements of most airlines. This means you can easily stow your suitcase in the airplane cabins without having to pay additional checked baggage fees. Its compact size also allows it to fit comfortably in the overhead bins above your seat.Lightweight and Maneuverable:\nWeighing only 2.7 kg, this cabin suitcase is easy to maneuver, even when you need to move through busy airports or narrow aisles. The four multi-directional wheels allow 360-degree freedom of movement, so you can pull or push your suitcase with ease. ZQANXMBT0091\n ZQANXMBT0091","id":"dce4dab2622e4b518d8b8f196975eda6","fullTextBoosted":"Mercedes-Benz Trucks - Travellite cabin suitcase Stylish, durable and practical for on the go\n\nThe Travelite cabin suitcase combines timeless, sleek design with impressive durability to make your travels more enjoyable and worry-free. Carefully designed to meet your needs, this suitcase is the ideal choice for modern travelers.Rugged ABS hard shell:.\nThe outer shell of the suitcase is made of high quality ABS hard shell material, which ensures impact resistance and durability. Whether you are traveling on business or exploring the world, this cabin suitcase will stand up to the rigors of travel and protect your prized possessions.Perfect cabin size:.\nWith dimensions of 39cm x 55cm x 20cm, this suitcase is specifically designed to meet the carry-on requirements of most airlines. This means you can easily stow your suitcase in the airplane cabins without having to pay additional checked baggage fees. Its compact size also allows it to fit comfortably in the overhead bins above your seat.Lightweight and Maneuverable:\nWeighing only 2.7 kg, this cabin suitcase is easy to maneuver, even when you need to move through busy airports or narrow aisles. The four multi-directional wheels allow 360-degree freedom of movement, so you can pull or push your suitcase with ease. ZQANXMBT0091\n ZQANXMBT0091"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"df32cf165b754dd383f1b0c61f7405f4","_score":0.0,"_source":{"fullText":"Mercedes-Benz Trucks - Toilet bag, black Discover the exclusive Mercedes-Benz Trucks Toiletry Bag - your perfect solution for keeping your hygiene items stylish and organized. With our high-quality toiletry bag, you'll always keep track of all your grooming products, whether you're at home or on the go.Superior Quality:Made of durable nylon, plastic and fabric, this toiletry bag is designed for long-term use. It withstands the rigors of everyday life and travel effortlessly.Perfect Size: With dimensions of 22cm x 27cm, our toiletry bag has enough space for all your personal care products without being too bulky. It fits perfectly in your travel bag or bathroom shelf.Easy organization:You can easily sort and find your items thanks to its smart interior partitioning. No more spills or lost items.Practical hanging hook: The plastic hook allows you to conveniently hang the bag on the wall. This way, you always have your grooming products at hand without taking up valuable space.Stylish design: The toiletry bag is adorned with the distinctive Mercedes-Benz Trucks logo, giving it a touch of luxury and exclusivity. Show your passion for quality and design wherever you go. ZQANXMBT0087\n ZQANXMBT0087","id":"df32cf165b754dd383f1b0c61f7405f4","fullTextBoosted":"Mercedes-Benz Trucks - Toilet bag, black Discover the exclusive Mercedes-Benz Trucks Toiletry Bag - your perfect solution for keeping your hygiene items stylish and organized. With our high-quality toiletry bag, you'll always keep track of all your grooming products, whether you're at home or on the go.Superior Quality:Made of durable nylon, plastic and fabric, this toiletry bag is designed for long-term use. It withstands the rigors of everyday life and travel effortlessly.Perfect Size: With dimensions of 22cm x 27cm, our toiletry bag has enough space for all your personal care products without being too bulky. It fits perfectly in your travel bag or bathroom shelf.Easy organization:You can easily sort and find your items thanks to its smart interior partitioning. No more spills or lost items.Practical hanging hook: The plastic hook allows you to conveniently hang the bag on the wall. This way, you always have your grooming products at hand without taking up valuable space.Stylish design: The toiletry bag is adorned with the distinctive Mercedes-Benz Trucks logo, giving it a touch of luxury and exclusivity. Show your passion for quality and design wherever you go. ZQANXMBT0087\n ZQANXMBT0087"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"6f967bbf4e214808952050b8a7d9a0d3","_score":0.0,"_source":{"fullText":" RPET backpack \"AWARE This sleek laptop backpack \"AWARE\" is environmentally friendly and made of recycled materials. Its laptop compartment in the main compartment holds laptops up to 15.6 inches. It also has a separate zippered pocket to store all your small essentials for daily use. With Mercedes Benz logo embossing.\n\nFits laptop and tablets up to 15.6 inchesMaterial: Recycled polyethylene terephthalateColor: Gray. ZQANXMBT0013\n ZQANXMBT0013","id":"6f967bbf4e214808952050b8a7d9a0d3","fullTextBoosted":" RPET backpack \"AWARE This sleek laptop backpack \"AWARE\" is environmentally friendly and made of recycled materials. Its laptop compartment in the main compartment holds laptops up to 15.6 inches. It also has a separate zippered pocket to store all your small essentials for daily use. With Mercedes Benz logo embossing.\n\nFits laptop and tablets up to 15.6 inchesMaterial: Recycled polyethylene terephthalateColor: Gray. ZQANXMBT0013\n ZQANXMBT0013"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"ba9aa1fc24a1438b9551eaeb246a9156","_score":0.0,"_source":{"fullText":"RPET toilet bag This trendy toiletry bag \/ zipper bag comes with a sturdy metal hoop around the opening so that it can be safely stood upright or hung. This practical bag is also padded and made of recycled materials. ZQANXMBT0018\n ZQANXMBT0018","id":"ba9aa1fc24a1438b9551eaeb246a9156","fullTextBoosted":"RPET toilet bag This trendy toiletry bag \/ zipper bag comes with a sturdy metal hoop around the opening so that it can be safely stood upright or hung. This practical bag is also padded and made of recycled materials. ZQANXMBT0018\n ZQANXMBT0018"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"c1e5ab0fce1c4e84a7ed6c7113f2f399","_score":0.0,"_source":{"fullText":"Persenning shoulder bag Made from a glossy black tarpaulin material, this bag offers ample storage for all your needs. A spacious main compartment with organizer features and a flat interior pocket offer a variety of organization options. A wide shoulder strap provides comfort on the go. Features embossed Mercedes-Benz Trucks logo and \"Trucks you can trust\" slogan. ZQANXMBT0017\n ZQANXMBT0017","id":"c1e5ab0fce1c4e84a7ed6c7113f2f399","fullTextBoosted":"Persenning shoulder bag Made from a glossy black tarpaulin material, this bag offers ample storage for all your needs. A spacious main compartment with organizer features and a flat interior pocket offer a variety of organization options. A wide shoulder strap provides comfort on the go. Features embossed Mercedes-Benz Trucks logo and \"Trucks you can trust\" slogan. ZQANXMBT0017\n ZQANXMBT0017"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"4ab73284985b44349ac90be9c90da00b","_score":0.0,"_source":{"fullText":"Mercedes-Benz Trucks felt shopper, gray This makes shopping fun! The gray felt shopping bag with embroidered white logo has room for all your purchases and is securely stored thanks to the zipper. A practical snap hook completes the look and allows you to attach your keys, for example. To ensure not only order but also the best possible carrying comfort, the shopping bag is equipped with carrying handles made of strap material. \n\nColor: greyMaterial: recycled PES feltDimensions: approx. 40 x 44 x 14 cmBelt handlesInside pocket with zipper and snap hook ZQANXMBT0131\n ZQANXMBT0131","id":"4ab73284985b44349ac90be9c90da00b","fullTextBoosted":"Mercedes-Benz Trucks felt shopper, gray This makes shopping fun! The gray felt shopping bag with embroidered white logo has room for all your purchases and is securely stored thanks to the zipper. A practical snap hook completes the look and allows you to attach your keys, for example. To ensure not only order but also the best possible carrying comfort, the shopping bag is equipped with carrying handles made of strap material. \n\nColor: greyMaterial: recycled PES feltDimensions: approx. 40 x 44 x 14 cmBelt handlesInside pocket with zipper and snap hook ZQANXMBT0131\n ZQANXMBT0131"}},{"_index":"live_product_d5cccd27ea6445358587252a326c85df_1675058506","_type":"_doc","_id":"5e53ca0302d54e69b5ba75e33e335fff","_score":0.0,"_source":{"fullText":"Mercedes-Benz Trucks backpack \n\nThe Mercedes-Benz Trucks backpack in stylish khaki is the perfect combination of functionality, comfort and the unmistakable Mercedes-Benz design. This backpack has been specially developed to meet the needs of modern commuters and adventurers and offers plenty of space for your most important items.\n\nHigh-quality materials and first-class workmanship guarantee longevity and durability. The hard-wearing khaki-colored fabric gives the backpack a timeless yet modern look that works well both in the office and at leisure.\n\nThe backpack has a spacious main compartment that offers plenty of room for books, documents, clothing or other important items.\n\nThe carrying comfort is excellent thanks to the padded shoulder straps and the padded back section. This means you can carry the backpack for hours without feeling uncomfortable. The backpack also has a practical carrying handle, which makes it easier to carry by hand.\n\nThe Mercedes-Benz Trucks logo and Mercedes-Benz star on the front of the backpack is a sign of quality and style.Color: khakiDimensions: 42 x 28 x 12 cm ZQANXMBT0132\n ZQANXMBT0132","id":"5e53ca0302d54e69b5ba75e33e335fff","fullTextBoosted":"Mercedes-Benz Trucks backpack \n\nThe Mercedes-Benz Trucks backpack in stylish khaki is the perfect combination of functionality, comfort and the unmistakable Mercedes-Benz design. This backpack has been specially developed to meet the needs of modern commuters and adventurers and offers plenty of space for your most important items.\n\nHigh-quality materials and first-class workmanship guarantee longevity and durability. The hard-wearing khaki-colored fabric gives the backpack a timeless yet modern look that works well both in the office and at leisure.\n\nThe backpack has a spacious main compartment that offers plenty of room for books, documents, clothing or other important items.\n\nThe carrying comfort is excellent thanks to the padded shoulder straps and the padded back section. This means you can carry the backpack for hours without feeling uncomfortable. The backpack also has a practical carrying handle, which makes it easier to carry by hand.\n\nThe Mercedes-Benz Trucks logo and Mercedes-Benz star on the front of the backpack is a sign of quality and style.Color: khakiDimensions: 42 x 28 x 12 cm ZQANXMBT0132\n ZQANXMBT0132"}}]}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|