1 |
2.97 ms |
Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"term":{"productNumber":{"boost":600,"value":"2024"}}}]}},"sort":[{"_score":{"order":"DESC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":50,"collapse":{"field":"displayGroup"}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
7.79 ms |
Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"bool":{"should":[{"match":{"fullTextBoosted":{"query":"2024","boost":10}}},{"match":{"fullText":{"query":"2024","boost":5}}},{"match":{"fullText":{"query":"2024","fuzziness":"auto","boost":3}}},{"match_phrase_prefix":{"fullText":{"query":"2024","boost":1,"slop":5}}},{"wildcard":{"fullText":{"value":"*2024*"}}},{"match":{"fullText.ngram":{"query":"2024"}}},{"wildcard":{"productNumber":{"value":"*2024*","boost":180}}},{"wildcard":{"name":{"value":"*2024*","boost":60}}},{"match":{"keywords":{"query":"2024","boost":20}}},{"wildcard":{"keywords":{"value":"*2024*","boost":8}}}],"minimum_should_match":1}}]}},"sort":[{"_score":{"order":"DESC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":50,"min_score":15,"collapse":{"field":"displayGroup"}}}
{"took":6,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":4,"relation":"eq"},"max_score":null,"hits":[{"_index":"live_product_1bf86c20e08d4ab6a9bc35004f282789_1675058506","_type":"_doc","_id":"d0d25e7a31a5454daed9a83ebbc076e6","_score":207.98796,"_source":{"fullText":"Calendrier mural Unimog 2024 Edition limit\u00e9e ! R\u00e9servez d\u00e8s maintenant l'un des l\u00e9gendaires calendriers muraux Unimog.L'Unimog \u00e0 t\u00eate de b\u0153uf symbolise la force et la robustesse et repr\u00e9sente encore aujourd'hui la b\u00eate de somme qu'est le Special Truck de Mercedes-Benz. Infatigable et fiable, il vient \u00e0 bout de missions difficiles dans les endroits les plus divers du monde - sur la route et en terrain difficile. L'ic\u00f4ne Unimog est une cat\u00e9gorie de v\u00e9hicules unique qui suscite partout enthousiasme et passion. L'Unimog dans toute sa diversit\u00e9 - c'est ce que vous propose le calendrier 2024. Nous vous souhaitons beaucoup de plaisir et une bonne route tout au long de cette nouvelle ann\u00e9e! ZQANXUNI0020\n ZQANXUNI0020","id":"d0d25e7a31a5454daed9a83ebbc076e6","fullTextBoosted":"Calendrier mural Unimog 2024 Edition limit\u00e9e ! R\u00e9servez d\u00e8s maintenant l'un des l\u00e9gendaires calendriers muraux Unimog.L'Unimog \u00e0 t\u00eate de b\u0153uf symbolise la force et la robustesse et repr\u00e9sente encore aujourd'hui la b\u00eate de somme qu'est le Special Truck de Mercedes-Benz. Infatigable et fiable, il vient \u00e0 bout de missions difficiles dans les endroits les plus divers du monde - sur la route et en terrain difficile. L'ic\u00f4ne Unimog est une cat\u00e9gorie de v\u00e9hicules unique qui suscite partout enthousiasme et passion. L'Unimog dans toute sa diversit\u00e9 - c'est ce que vous propose le calendrier 2024. Nous vous souhaitons beaucoup de plaisir et une bonne route tout au long de cette nouvelle ann\u00e9e! ZQANXUNI0020\n ZQANXUNI0020"},"fields":{"displayGroup":["92f7eaf3fd31103caa00bde54331d6a5"]}},{"_index":"live_product_1bf86c20e08d4ab6a9bc35004f282789_1675058506","_type":"_doc","_id":"7a8a7405790544d095eeac3641fdf16c","_score":16.774342,"_source":{"fullText":"Mercedes-Benz Kaffeebecher, 300ml Black and white: Das Set umfasst zwei Kaffeebecher, wobei einer in wei\u00dfem Design und einer in schwarzem Design gehalten ist. Goldene Akzente durch Lorbeerbl\u00e4tter sowie ein Mercedes-Benz Schriftzug runden die Optik ab. Die Becher bestehen aus hochwertigem Porzellan und sind vollkommen vegan, ohne Tierknochenasche, gefertigt. Beide Becher verf\u00fcgen \u00fcber ein Fassungsverm\u00f6gen von ca. 0,3 l und sind sp\u00fclmaschinengeeignet.Farbe: schwarz\/wei\u00dfMaterial: hochwertiges PorzellanFassungsverm\u00f6gen: ca. 0,3 lH\u00f6he: ca. 9,5 cmDurchmesser oben: ca. 9 cmDurchmesser unten: ca. 6,5 cm\n- vegan (ohne Tierknochenasche)sp\u00fclmaschinengeeignetmade for Mercedes-Benz by KAHLAmade in Germany MB6 6 04 2027\n MB6 6 04 2027","id":"7a8a7405790544d095eeac3641fdf16c","fullTextBoosted":"Mercedes-Benz Kaffeebecher, 300ml Black and white: Das Set umfasst zwei Kaffeebecher, wobei einer in wei\u00dfem Design und einer in schwarzem Design gehalten ist. Goldene Akzente durch Lorbeerbl\u00e4tter sowie ein Mercedes-Benz Schriftzug runden die Optik ab. Die Becher bestehen aus hochwertigem Porzellan und sind vollkommen vegan, ohne Tierknochenasche, gefertigt. Beide Becher verf\u00fcgen \u00fcber ein Fassungsverm\u00f6gen von ca. 0,3 l und sind sp\u00fclmaschinengeeignet.Farbe: schwarz\/wei\u00dfMaterial: hochwertiges PorzellanFassungsverm\u00f6gen: ca. 0,3 lH\u00f6he: ca. 9,5 cmDurchmesser oben: ca. 9 cmDurchmesser unten: ca. 6,5 cm\n- vegan (ohne Tierknochenasche)sp\u00fclmaschinengeeignetmade for Mercedes-Benz by KAHLAmade in Germany MB6 6 04 2027\n MB6 6 04 2027"},"fields":{"displayGroup":["c5b274efad37d04b1cc85e0fcc0b6518"]}},{"_index":"live_product_1bf86c20e08d4ab6a9bc35004f282789_1675058506","_type":"_doc","_id":"d3afac7c082d46df8e940b5284b66a76","_score":16.064987,"_source":{"fullText":"Mercedes-Benz Gobelet isolant, de emsa\u00ae, 0,5 litre, inox, classic-brun La tasse isolante en acier inoxydable \u00e0 double paroi fabriqu\u00e9e par emsa\u00ae pour Mercedes-Benz garde les boissons froides jusqu'\u00e0 douze heures ou chaudes pendant six heures. Le gobelet au design argent\u00e9 et noir pr\u00e9sente une surface bross\u00e9e et est orn\u00e9 d'une \u00e9toile Mercedes grav\u00e9e au laser. Le gobelet isotherme s'ouvre tr\u00e8s facilement par simple pression sur un bouton. Gr\u00e2ce \u00e0 l'ouverture \u00e0 360 degr\u00e9s, il est tr\u00e8s facile de boire du caf\u00e9, du th\u00e9, etc. Couleur : argent\u00e9\/brunMat\u00e9riau : acier inoxydableContenu : 500 mlVont au lave-vaisselleOuverture \u00e0 360 degr\u00e9smade for Mercedes Benz by emsa\u00ae MB6 6 04 2026\n MB6 6 04 2026","id":"d3afac7c082d46df8e940b5284b66a76","fullTextBoosted":"Mercedes-Benz Gobelet isolant, de emsa\u00ae, 0,5 litre, inox, classic-brun La tasse isolante en acier inoxydable \u00e0 double paroi fabriqu\u00e9e par emsa\u00ae pour Mercedes-Benz garde les boissons froides jusqu'\u00e0 douze heures ou chaudes pendant six heures. Le gobelet au design argent\u00e9 et noir pr\u00e9sente une surface bross\u00e9e et est orn\u00e9 d'une \u00e9toile Mercedes grav\u00e9e au laser. Le gobelet isotherme s'ouvre tr\u00e8s facilement par simple pression sur un bouton. Gr\u00e2ce \u00e0 l'ouverture \u00e0 360 degr\u00e9s, il est tr\u00e8s facile de boire du caf\u00e9, du th\u00e9, etc. Couleur : argent\u00e9\/brunMat\u00e9riau : acier inoxydableContenu : 500 mlVont au lave-vaisselleOuverture \u00e0 360 degr\u00e9smade for Mercedes Benz by emsa\u00ae MB6 6 04 2026\n MB6 6 04 2026"},"fields":{"displayGroup":["8f3b6c5dcef5dafab1a53f33c1065284"]}},{"_index":"live_product_1bf86c20e08d4ab6a9bc35004f282789_1675058506","_type":"_doc","_id":"8337a34d66154bc293aeb77fed565720","_score":15.623899,"_source":{"fullText":"Enjoliveurs de valve, AMG Les enjoliveurs de valve AMG sont les points forts des jantes en alliage l\u00e9ger de haute qualit\u00e9.\nEn utilisant de l'aluminium anodis\u00e9, ils sont tr\u00e8s l\u00e9gers et disponibles en deux couleurs. Gr\u00e2ce \u00e0 l'insert en plastique ABS, ils conviennent \u00e0 toutes les valves (m\u00eame RDK). Le joint en caoutchouc suppl\u00e9mentaire prot\u00e8ge la valve contre les impuret\u00e9s, la lentille PU avec filtre UV prot\u00e8ge contre la d\u00e9coloration.Livraison : 4 pi\u00e8ces MB6 6 47 2004\n MB6 6 47 2004","id":"8337a34d66154bc293aeb77fed565720","fullTextBoosted":"Enjoliveurs de valve, AMG Les enjoliveurs de valve AMG sont les points forts des jantes en alliage l\u00e9ger de haute qualit\u00e9.\nEn utilisant de l'aluminium anodis\u00e9, ils sont tr\u00e8s l\u00e9gers et disponibles en deux couleurs. Gr\u00e2ce \u00e0 l'insert en plastique ABS, ils conviennent \u00e0 toutes les valves (m\u00eame RDK). Le joint en caoutchouc suppl\u00e9mentaire prot\u00e8ge la valve contre les impuret\u00e9s, la lentille PU avec filtre UV prot\u00e8ge contre la d\u00e9coloration.Livraison : 4 pi\u00e8ces MB6 6 47 2004\n MB6 6 47 2004"},"fields":{"displayGroup":["082e086d5c6851af645abeba7480cd7f"]}}]},"aggregations":{"total-filtered-count":{"meta":[],"doc_count":4,"total-count":{"value":4}}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
3 |
6.12 ms |
Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"bool":{"should":[{"match":{"fullTextBoosted":{"query":"2024","boost":10}}},{"match":{"fullText":{"query":"2024","boost":5}}},{"match":{"fullText":{"query":"2024","fuzziness":"auto","boost":3}}},{"match_phrase_prefix":{"fullText":{"query":"2024","boost":1,"slop":5}}},{"wildcard":{"fullText":{"value":"*2024*"}}},{"match":{"fullText.ngram":{"query":"2024"}}},{"wildcard":{"productNumber":{"value":"*2024*","boost":180}}},{"wildcard":{"name":{"value":"*2024*","boost":60}}},{"match":{"keywords":{"query":"2024","boost":20}}},{"wildcard":{"keywords":{"value":"*2024*","boost":8}}}],"minimum_should_match":1}}]}},"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_1bf86c20e08d4ab6a9bc35004f282789","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"bool":{"should":[{"match":{"fullTextBoosted":{"query":"2024","boost":10}}},{"match":{"fullText":{"query":"2024","boost":5}}},{"match":{"fullText":{"query":"2024","fuzziness":"auto","boost":3}}},{"match_phrase_prefix":{"fullText":{"query":"2024","boost":1,"slop":5}}},{"wildcard":{"fullText":{"value":"*2024*"}}},{"match":{"fullText.ngram":{"query":"2024"}}},{"wildcard":{"productNumber":{"value":"*2024*","boost":180}}},{"wildcard":{"name":{"value":"*2024*","boost":60}}},{"match":{"keywords":{"query":"2024","boost":20}}},{"wildcard":{"keywords":{"value":"*2024*","boost":8}}}],"minimum_should_match":1}}]}},"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":4,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":9,"relation":"eq"},"max_score":null,"hits":[]},"aggregations":{"gbmed_labelling_tyres_decibel":{"meta":[],"doc_count":9,"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":9,"rating":{"value":0.0}},"price":{"count":9,"min":19.87,"max":386.0,"avg":102.04444444444444,"sum":918.4},"gbmed_labelling_tyres_noise":{"meta":[],"doc_count":9,"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":9,"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":1,"options":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"c97478e6d3c349d2bfb68519428f805b","doc_count":1}]}},"properties":{"doc_count":25,"properties":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"c97478e6d3c349d2bfb68519428f805b","doc_count":4},{"key":"e7bac0636648463eb41deefbcc956f10","doc_count":3},{"key":"e8787d167bb242a181ac1e402ed27592","doc_count":3},{"key":"a75304c31be547859893d57c78f23aed","doc_count":2},{"key":"ad735af1ebfb421e93e408b073c4a89a","doc_count":2},{"key":"05aa39f7ba844c4a9e862b70d5c08a6c","doc_count":1},{"key":"17d8c9b2211d45aca846402aebbad7ec","doc_count":1},{"key":"1ba7d13e01d4495ca4045661c05ceeff","doc_count":1},{"key":"2407ecb607b74f3c933c9d93c5ccacd4","doc_count":1},{"key":"36d009d13cc14ae880897bd0b14d7c66","doc_count":1},{"key":"7fd13cb8563b4ca1876898edba33b7a9","doc_count":1},{"key":"8c0da4bfec9545cda6da6548c6e5edf9","doc_count":1},{"key":"8ef30e56aa0048eb9b19ea389bdbf60c","doc_count":1},{"key":"a75f980563f445fd8e883f7e37846512","doc_count":1},{"key":"c9ef86b1069246ddb82a8813cb98cba1","doc_count":1},{"key":"ef8dbeb3c9ed45daac7ceb65de741056","doc_count":1}]}},"gbmed_labelling_tyres_grip":{"meta":[],"doc_count":9,"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":"b1984298f6f548bc8a5eb35cef6abf39","doc_count":3},{"key":"045c1d5daf40465aafd9a67bb45f8bd6","doc_count":2},{"key":"0aeab96e7d234669855b002e2c3ebb71","doc_count":2},{"key":"12fa8e89f2554aae874bd24b9e1eae89","doc_count":1},{"key":"b8cba811417747628e951a372c43250b","doc_count":1}]}}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|
4 |
2.39 ms |
Request:
{"index":"live_product_1bf86c20e08d4ab6a9bc35004f282789","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["d0d25e7a31a5454daed9a83ebbc076e6","7a8a7405790544d095eeac3641fdf16c","d3afac7c082d46df8e940b5284b66a76","8337a34d66154bc293aeb77fed565720"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"36178eefd276430d955267942b57fcda"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|