Symfony Profiler

Query Metrics

7.00 ms Query Time

1 Node(s)

3 Indices

Queries

#▲ Execution Time Info

7.21 ms

#▲	Execution Time	Info
1	7.21 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"should":[{"terms":{"id":["43456381ee7c486ea916cb8504460582","5ba7a2ba55544299b6e36b728e6f995c","cb9380473c4748768e28d9051fd7da6a","37b08021f7c24554a7be6ad70e6616c7","6f31ab8636a94aac9e12b86724ed0bbf"]}},{"terms":{"parentId":["43456381ee7c486ea916cb8504460582","5ba7a2ba55544299b6e36b728e6f995c","cb9380473c4748768e28d9051fd7da6a","37b08021f7c24554a7be6ad70e6616c7","6f31ab8636a94aac9e12b86724ed0bbf"]}}]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule53cf7c1454154199ad90bfc28288f1ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule80f333d4c2674bdeb30388e593424fbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee006ad5b97e84242a09d4c84dec2396b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0193446c7a817e8586191b7ad85b3cf2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefee128cb11764a7f957c94ed650e086c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0192c3044a3f7eed9f3d141952e26e56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule282026da359141fd94182bd10ef24638_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6cef54106904c48b5efedd4016c9cf8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule03a71b7f01cb47ecace665cfc8762b48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule04f7c8862bdc47ec9724a7278092693f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule1009309a62c946a1a64ecd99fff8b2c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule27656e44eab74b5992adc91133e645b7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule2ed07e78e8704a05bc5973a89213b904_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34e21ad71e0f405b81d25e6de4298588_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule443a8639f33240aaaf21c1628b2fd148_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule506864af5e524722a5c6fed999caac1e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5982283518674aff9eb909103b721bef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5a401c955f014f00abc3d93e8293976a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5da0996ea5584a068aa6e9211e102d7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5df5f25a9b9f4e3587b45affcc728d0b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5ef562a81203488199b7d3778a047335_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6742efdc0ff341428938a1f6599ba80d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6af880993bab4e339606ccb06da0b117_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e81a60325604dd096fc9b4a7580f0ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule781e5aca1b9846a39a3bf00588dc049c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule82c4baebc4f14687a82d57e73f1ab20f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule83af03e250724165823d66f7a16995bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9008448ec30b4d4295b1d6aec8a9e0ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule984b7c687bdf46f9bc406c01f6436860_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea18d5b783e9c41c68e9fe01e1f01053b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulebe4bb7fae9dc41c8b57d9f185b2d932b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulebff59076aea542a4a6a615415aa2fece_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec40b7ef0f9de49489791e9b0081afb73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled41080572cd84726b117f82e0982237b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6aadf3a8547458fbcf6fccc15d1143f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefc475a06dce2402ab698ca5dd460b083_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefc6cf3aed4284ee5973e98900c088415_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://127.0.0.1:9501/sw_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "should": [ { "bool": { "should": [ { "terms": { "id": [ "43456381ee7c486ea916cb8504460582", "5ba7a2ba55544299b6e36b728e6f995c", "cb9380473c4748768e28d9051fd7da6a", "37b08021f7c24554a7be6ad70e6616c7", "6f31ab8636a94aac9e12b86724ed0bbf" ] } }, { "terms": { "parentId": [ "43456381ee7c486ea916cb8504460582", "5ba7a2ba55544299b6e36b728e6f995c", "cb9380473c4748768e28d9051fd7da6a", "37b08021f7c24554a7be6ad70e6616c7", "6f31ab8636a94aac9e12b86724ed0bbf" ] } } ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categoriesRo", "query": { "terms": { "categoriesRo.id": [ "018e9f02546e7c82a9b5bda06cc934e9", "01918ec9c5fa73c5a1574670671bee08" ] } } } } ] } } ] } }, { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 10 } } }, { "term": { "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e" } } ] } } } }, { "term": { "active": true } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "number", "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule53cf7c1454154199ad90bfc28288f1ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule80f333d4c2674bdeb30388e593424fbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee006ad5b97e84242a09d4c84dec2396b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0193446c7a817e8586191b7ad85b3cf2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulefee128cb11764a7f957c94ed650e086c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0192c3044a3f7eed9f3d141952e26e56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule282026da359141fd94182bd10ef24638_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruled6cef54106904c48b5efedd4016c9cf8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule03a71b7f01cb47ecace665cfc8762b48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule04f7c8862bdc47ec9724a7278092693f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule1009309a62c946a1a64ecd99fff8b2c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule27656e44eab74b5992adc91133e645b7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule2ed07e78e8704a05bc5973a89213b904_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule34e21ad71e0f405b81d25e6de4298588_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule443a8639f33240aaaf21c1628b2fd148_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule506864af5e524722a5c6fed999caac1e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule5982283518674aff9eb909103b721bef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule5a401c955f014f00abc3d93e8293976a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule5da0996ea5584a068aa6e9211e102d7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule5df5f25a9b9f4e3587b45affcc728d0b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule5ef562a81203488199b7d3778a047335_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule6742efdc0ff341428938a1f6599ba80d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule6af880993bab4e339606ccb06da0b117_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule6e81a60325604dd096fc9b4a7580f0ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule781e5aca1b9846a39a3bf00588dc049c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule82c4baebc4f14687a82d57e73f1ab20f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule83af03e250724165823d66f7a16995bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule9008448ec30b4d4295b1d6aec8a9e0ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule984b7c687bdf46f9bc406c01f6436860_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulea18d5b783e9c41c68e9fe01e1f01053b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulebe4bb7fae9dc41c8b57d9f185b2d932b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulebff59076aea542a4a6a615415aa2fece_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulec40b7ef0f9de49489791e9b0081afb73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruled41080572cd84726b117f82e0982237b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruled6aadf3a8547458fbcf6fccc15d1143f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulefc475a06dce2402ab698ca5dd460b083_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulefc6cf3aed4284ee5973e98900c088415_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } }, "order": "ASC" } } ], "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 5, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "sw_product_1721227718", "_id": "0f20ce9a009643f289ec33440ffbae38", "_score": null, "_source": { "autoIncrement": 4566.0, "id": "0f20ce9a009643f289ec33440ffbae38" }, "fields": { "displayGroup": [ "e5ac435310ba36fa7af8189d09645f5c" ] }, "sort": [ 2.99 ] }, { "_index": "sw_product_1721227718", "_id": "7ebbdec04b684bf89e81f589696b4024", "_score": null, "_source": { "autoIncrement": 4539.0, "id": "7ebbdec04b684bf89e81f589696b4024" }, "fields": { "displayGroup": [ "5ad4b59c98615a0e85d7e5dfdd661047" ] }, "sort": [ 4.99 ] }, { "_index": "sw_product_1721227718", "_id": "20408b03dc224b88969495c15a7c6290", "_score": null, "_source": { "autoIncrement": 4548.0, "id": "20408b03dc224b88969495c15a7c6290" }, "fields": { "displayGroup": [ "febef705d9ba4a280bc56aa5c477cb57" ] }, "sort": [ 5.49 ] }, { "_index": "sw_product_1721227718", "_id": "6e6d12912a514dd8b89b43c25e676b61", "_score": null, "_source": { "autoIncrement": 4544.0, "id": "6e6d12912a514dd8b89b43c25e676b61" }, "fields": { "displayGroup": [ "8fc31c3f49638b3fc01933bc81f3eff4" ] }, "sort": [ 5.49 ] }, { "_index": "sw_product_1721227718", "_id": "6b795681e7c449fc83460284ae35fa47", "_score": null, "_source": { "autoIncrement": 4560.0, "id": "6b795681e7c449fc83460284ae35fa47" }, "fields": { "displayGroup": [ "faaab93f9782fc01c9235399d1d7a9db" ] }, "sort": [ 5.99 ] } ] } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`

Request:

{"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"should":[{"terms":{"id":["43456381ee7c486ea916cb8504460582","5ba7a2ba55544299b6e36b728e6f995c","cb9380473c4748768e28d9051fd7da6a","37b08021f7c24554a7be6ad70e6616c7","6f31ab8636a94aac9e12b86724ed0bbf"]}},{"terms":{"parentId":["43456381ee7c486ea916cb8504460582","5ba7a2ba55544299b6e36b728e6f995c","cb9380473c4748768e28d9051fd7da6a","37b08021f7c24554a7be6ad70e6616c7","6f31ab8636a94aac9e12b86724ed0bbf"]}}]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule53cf7c1454154199ad90bfc28288f1ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule80f333d4c2674bdeb30388e593424fbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee006ad5b97e84242a09d4c84dec2396b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0193446c7a817e8586191b7ad85b3cf2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefee128cb11764a7f957c94ed650e086c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0192c3044a3f7eed9f3d141952e26e56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule282026da359141fd94182bd10ef24638_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6cef54106904c48b5efedd4016c9cf8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule03a71b7f01cb47ecace665cfc8762b48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule04f7c8862bdc47ec9724a7278092693f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule1009309a62c946a1a64ecd99fff8b2c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule27656e44eab74b5992adc91133e645b7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule2ed07e78e8704a05bc5973a89213b904_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34e21ad71e0f405b81d25e6de4298588_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule443a8639f33240aaaf21c1628b2fd148_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule506864af5e524722a5c6fed999caac1e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5982283518674aff9eb909103b721bef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5a401c955f014f00abc3d93e8293976a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5da0996ea5584a068aa6e9211e102d7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5df5f25a9b9f4e3587b45affcc728d0b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5ef562a81203488199b7d3778a047335_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6742efdc0ff341428938a1f6599ba80d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6af880993bab4e339606ccb06da0b117_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e81a60325604dd096fc9b4a7580f0ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule781e5aca1b9846a39a3bf00588dc049c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule82c4baebc4f14687a82d57e73f1ab20f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule83af03e250724165823d66f7a16995bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9008448ec30b4d4295b1d6aec8a9e0ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule984b7c687bdf46f9bc406c01f6436860_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea18d5b783e9c41c68e9fe01e1f01053b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulebe4bb7fae9dc41c8b57d9f185b2d932b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulebff59076aea542a4a6a615415aa2fece_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec40b7ef0f9de49489791e9b0081afb73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled41080572cd84726b117f82e0982237b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6aadf3a8547458fbcf6fccc15d1143f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefc475a06dce2402ab698ca5dd460b083_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefc6cf3aed4284ee5973e98900c088415_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST http://127.0.0.1:9501/sw_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "should": [
                                                    {
                                                        "terms": {
                                                            "id": [
                                                                "43456381ee7c486ea916cb8504460582",
                                                                "5ba7a2ba55544299b6e36b728e6f995c",
                                                                "cb9380473c4748768e28d9051fd7da6a",
                                                                "37b08021f7c24554a7be6ad70e6616c7",
                                                                "6f31ab8636a94aac9e12b86724ed0bbf"
                                                            ]
                                                        }
                                                    },
                                                    {
                                                        "terms": {
                                                            "parentId": [
                                                                "43456381ee7c486ea916cb8504460582",
                                                                "5ba7a2ba55544299b6e36b728e6f995c",
                                                                "cb9380473c4748768e28d9051fd7da6a",
                                                                "37b08021f7c24554a7be6ad70e6616c7",
                                                                "6f31ab8636a94aac9e12b86724ed0bbf"
                                                            ]
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categoriesRo",
                                                            "query": {
                                                                "terms": {
                                                                    "categoriesRo.id": [
                                                                        "018e9f02546e7c82a9b5bda06cc934e9",
                                                                        "01918ec9c5fa73c5a1574670671bee08"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 10
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "number",
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule53cf7c1454154199ad90bfc28288f1ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule80f333d4c2674bdeb30388e593424fbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee006ad5b97e84242a09d4c84dec2396b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0193446c7a817e8586191b7ad85b3cf2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulefee128cb11764a7f957c94ed650e086c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0192c3044a3f7eed9f3d141952e26e56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule282026da359141fd94182bd10ef24638_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruled6cef54106904c48b5efedd4016c9cf8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule03a71b7f01cb47ecace665cfc8762b48_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule04f7c8862bdc47ec9724a7278092693f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule1009309a62c946a1a64ecd99fff8b2c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule27656e44eab74b5992adc91133e645b7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule2ed07e78e8704a05bc5973a89213b904_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule34e21ad71e0f405b81d25e6de4298588_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule443a8639f33240aaaf21c1628b2fd148_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule506864af5e524722a5c6fed999caac1e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule5982283518674aff9eb909103b721bef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule5a401c955f014f00abc3d93e8293976a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule5da0996ea5584a068aa6e9211e102d7c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule5df5f25a9b9f4e3587b45affcc728d0b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule5ef562a81203488199b7d3778a047335_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule6742efdc0ff341428938a1f6599ba80d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule6af880993bab4e339606ccb06da0b117_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule6e81a60325604dd096fc9b4a7580f0ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule781e5aca1b9846a39a3bf00588dc049c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule82c4baebc4f14687a82d57e73f1ab20f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule83af03e250724165823d66f7a16995bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule9008448ec30b4d4295b1d6aec8a9e0ff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule984b7c687bdf46f9bc406c01f6436860_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulea18d5b783e9c41c68e9fe01e1f01053b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulebe4bb7fae9dc41c8b57d9f185b2d932b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulebff59076aea542a4a6a615415aa2fece_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulec40b7ef0f9de49489791e9b0081afb73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruled41080572cd84726b117f82e0982237b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruled6aadf3a8547458fbcf6fccc15d1143f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulefc475a06dce2402ab698ca5dd460b083_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulefc6cf3aed4284ee5973e98900c088415_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                },
                "order": "ASC"
            }
        }
    ],
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 5,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1721227718",
                "_id": "0f20ce9a009643f289ec33440ffbae38",
                "_score": null,
                "_source": {
                    "autoIncrement": 4566.0,
                    "id": "0f20ce9a009643f289ec33440ffbae38"
                },
                "fields": {
                    "displayGroup": [
                        "e5ac435310ba36fa7af8189d09645f5c"
                    ]
                },
                "sort": [
                    2.99
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "7ebbdec04b684bf89e81f589696b4024",
                "_score": null,
                "_source": {
                    "autoIncrement": 4539.0,
                    "id": "7ebbdec04b684bf89e81f589696b4024"
                },
                "fields": {
                    "displayGroup": [
                        "5ad4b59c98615a0e85d7e5dfdd661047"
                    ]
                },
                "sort": [
                    4.99
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "20408b03dc224b88969495c15a7c6290",
                "_score": null,
                "_source": {
                    "autoIncrement": 4548.0,
                    "id": "20408b03dc224b88969495c15a7c6290"
                },
                "fields": {
                    "displayGroup": [
                        "febef705d9ba4a280bc56aa5c477cb57"
                    ]
                },
                "sort": [
                    5.49
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "6e6d12912a514dd8b89b43c25e676b61",
                "_score": null,
                "_source": {
                    "autoIncrement": 4544.0,
                    "id": "6e6d12912a514dd8b89b43c25e676b61"
                },
                "fields": {
                    "displayGroup": [
                        "8fc31c3f49638b3fc01933bc81f3eff4"
                    ]
                },
                "sort": [
                    5.49
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "6b795681e7c449fc83460284ae35fa47",
                "_score": null,
                "_source": {
                    "autoIncrement": 4560.0,
                    "id": "6b795681e7c449fc83460284ae35fa47"
                },
                "fields": {
                    "displayGroup": [
                        "faaab93f9782fc01c9235399d1d7a9db"
                    ]
                },
                "sort": [
                    5.99
                ]
            }
        ]
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

Cluster Status

{
    "cluster_name": "opensearch_9501",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 6,
    "active_shards": 6,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 9,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 40.0
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
.opensearch-observability	open	1, 0	0
.plugins-ml-config	open	1, 0	1
sw_product_1721227718	open	3, 3	6351

Symfony Profiler

GET http://emmi-pet.bm.media/detail/89f672a3f05043edb0830e6fd2599f1e

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices