Symfony Profiler

Query Metrics

9.00 ms Query Time

1 Node(s)

3 Indices

Queries

#▲ Execution Time Info

6.41 ms

#▲	Execution Time	Info
1	6.41 ms	Request: {"index":"sw_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"45a3f1b817684f608c52a3b0908f9a4e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 25 View formatted request View formatted response View query backtrace POST http://127.0.0.1:9501/sw_product/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "45a3f1b817684f608c52a3b0908f9a4e" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categoriesRo", "query": { "terms": { "categoriesRo.id": [ "018e9f02546e7c82a9b5bda06cc934e9", "01918ec9c5fa73c5a1574670671bee08" ] } } } } ] } } ] } } ] } } ] } }, "sort": [ { "sales": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 4, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 25, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1721227718", "_id": "018991541e2573ce868eb1fc79171e43", "_score": null, "_source": { "autoIncrement": 5357.0, "id": "018991541e2573ce868eb1fc79171e43" }, "fields": { "displayGroup": [ "38cd4a592c49fd2fb788a7f3226d73b0" ] }, "sort": [ 23, "018991541e2573ce868eb1fc79171e43" ] }, { "_index": "sw_product_1721227718", "_id": "8ecc55e1f53c4cfea23f225e69905b1d", "_score": null, "_source": { "autoIncrement": 5311.0, "id": "8ecc55e1f53c4cfea23f225e69905b1d" }, "fields": { "displayGroup": [ "0a5d399aeb54ec88adf39810f39201e6" ] }, "sort": [ 17, "8ecc55e1f53c4cfea23f225e69905b1d" ] }, { "_index": "sw_product_1721227718", "_id": "68db486a573d4a7089b90089c71c0c5c", "_score": null, "_source": { "autoIncrement": 5324.0, "id": "68db486a573d4a7089b90089c71c0c5c" }, "fields": { "displayGroup": [ "0fca0edb87cde4d28167c545d0edca44" ] }, "sort": [ 12, "68db486a573d4a7089b90089c71c0c5c" ] }, { "_index": "sw_product_1721227718", "_id": "17cb09d5ac194195baab7d593a25ea73", "_score": null, "_source": { "autoIncrement": 5310.0, "id": "17cb09d5ac194195baab7d593a25ea73" }, "fields": { "displayGroup": [ "cd56049ed60bc020eccaf2e6659116f9" ] }, "sort": [ 10, "17cb09d5ac194195baab7d593a25ea73" ] }, { "_index": "sw_product_1721227718", "_id": "0189917535dd70ea99655c46c2c55e17", "_score": null, "_source": { "autoIncrement": 5359.0, "id": "0189917535dd70ea99655c46c2c55e17" }, "fields": { "displayGroup": [ "8db136dfb3795fa4baaf43f4bd638358" ] }, "sort": [ 5, "0189917535dd70ea99655c46c2c55e17" ] }, { "_index": "sw_product_1721227718", "_id": "018991762d16700887b7fb60a141a249", "_score": null, "_source": { "autoIncrement": 5360.0, "id": "018991762d16700887b7fb60a141a249" }, "fields": { "displayGroup": [ "8472fe6c03a252c60fe711561a27eb53" ] }, "sort": [ 5, "018991762d16700887b7fb60a141a249" ] }, { "_index": "sw_product_1721227718", "_id": "3ff21c2650c042cbb517764dc200b364", "_score": null, "_source": { "autoIncrement": 5312.0, "id": "3ff21c2650c042cbb517764dc200b364" }, "fields": { "displayGroup": [ "14c0926fe0e620687ab22f9910fcaead" ] }, "sort": [ 5, "3ff21c2650c042cbb517764dc200b364" ] }, { "_index": "sw_product_1721227718", "_id": "9afaa78f037f4691b903192aeb4eb7aa", "_score": null, "_source": { "autoIncrement": 5313.0, "id": "9afaa78f037f4691b903192aeb4eb7aa" }, "fields": { "displayGroup": [ "9f9787b28032ee6f8444cdc3731611ec" ] }, "sort": [ 5, "9afaa78f037f4691b903192aeb4eb7aa" ] }, { "_index": "sw_product_1721227718", "_id": "f9496117d88a422baa994bee4e51a4f2", "_score": null, "_source": { "autoIncrement": 5318.0, "id": "f9496117d88a422baa994bee4e51a4f2" }, "fields": { "displayGroup": [ "cb324aef769543a8e3c4453ddd5d97c1" ] }, "sort": [ 4, "f9496117d88a422baa994bee4e51a4f2" ] }, { "_index": "sw_product_1721227718", "_id": "98c7fd89824b4daba266eda3d3e1b969", "_score": null, "_source": { "autoIncrement": 5323.0, "id": "98c7fd89824b4daba266eda3d3e1b969" }, "fields": { "displayGroup": [ "3951609af4927bb4599f56e1a9c1faae" ] }, "sort": [ 3, "98c7fd89824b4daba266eda3d3e1b969" ] }, { "_index": "sw_product_1721227718", "_id": "018991870f1a70cd8c14b08bf54e29fc", "_score": null, "_source": { "autoIncrement": 5367.0, "id": "018991870f1a70cd8c14b08bf54e29fc" }, "fields": { "displayGroup": [ "36ee2958c5c57e7e553a4ec32e017e52" ] }, "sort": [ 2, "018991870f1a70cd8c14b08bf54e29fc" ] }, { "_index": "sw_product_1721227718", "_id": "7b8945cc3b9f4bb8b96c9d486506e863", "_score": null, "_source": { "autoIncrement": 5134.0, "id": "7b8945cc3b9f4bb8b96c9d486506e863" }, "fields": { "displayGroup": [ "b9479f06ab5dac7e5686812067676c9e" ] }, "sort": [ 2, "7b8945cc3b9f4bb8b96c9d486506e863" ] }, { "_index": "sw_product_1721227718", "_id": "7d130f1860b744a9857f21e9f1d08ca9", "_score": null, "_source": { "autoIncrement": 5309.0, "id": "7d130f1860b744a9857f21e9f1d08ca9" }, "fields": { "displayGroup": [ "cd809cc58e60ec4d725084af17672e80" ] }, "sort": [ 2, "7d130f1860b744a9857f21e9f1d08ca9" ] }, { "_index": "sw_product_1721227718", "_id": "a72092577aef44c980fffd73d8f9df07", "_score": null, "_source": { "autoIncrement": 5321.0, "id": "a72092577aef44c980fffd73d8f9df07" }, "fields": { "displayGroup": [ "c52c5b5ec419fe9a0bcfd54496e5d980" ] }, "sort": [ 2, "a72092577aef44c980fffd73d8f9df07" ] }, { "_index": "sw_product_1721227718", "_id": "0189917415b0728fbec6da0ee7295b40", "_score": null, "_source": { "autoIncrement": 5358.0, "id": "0189917415b0728fbec6da0ee7295b40" }, "fields": { "displayGroup": [ "207bab89f1a6d763ce5087c7352fafe5" ] }, "sort": [ 1, "0189917415b0728fbec6da0ee7295b40" ] }, { "_index": "sw_product_1721227718", "_id": "01899177afd57156a476dfbf2c3983b0", "_score": null, "_source": { "autoIncrement": 5361.0, "id": "01899177afd57156a476dfbf2c3983b0" }, "fields": { "displayGroup": [ "42d2c09bc0a01590b5d8067ee8bccff2" ] }, "sort": [ 1, "01899177afd57156a476dfbf2c3983b0" ] }, { "_index": "sw_product_1721227718", "_id": "0189917cc031713a8b97ddff67418717", "_score": null, "_source": { "autoIncrement": 5365.0, "id": "0189917cc031713a8b97ddff67418717" }, "fields": { "displayGroup": [ "63f185655e918eb60e67f2153b5c2f6b" ] }, "sort": [ 1, "0189917cc031713a8b97ddff67418717" ] }, { "_index": "sw_product_1721227718", "_id": "0189917dcc69711191e7b4f238478e3b", "_score": null, "_source": { "autoIncrement": 5366.0, "id": "0189917dcc69711191e7b4f238478e3b" }, "fields": { "displayGroup": [ "3de9fde513bbdfdeb764040dc63bdcec" ] }, "sort": [ 1, "0189917dcc69711191e7b4f238478e3b" ] }, { "_index": "sw_product_1721227718", "_id": "5c17640b898f4dd2af43b94883f06fd7", "_score": null, "_source": { "autoIncrement": 5322.0, "id": "5c17640b898f4dd2af43b94883f06fd7" }, "fields": { "displayGroup": [ "b18f0e4ba092143e9e5863bfc9a8e0c7" ] }, "sort": [ 1, "5c17640b898f4dd2af43b94883f06fd7" ] }, { "_index": "sw_product_1721227718", "_id": "01899178ab217137a158b1956a8e3358", "_score": null, "_source": { "autoIncrement": 5362.0, "id": "01899178ab217137a158b1956a8e3358" }, "fields": { "displayGroup": [ "b872a72086a4fc8cb84b4f7f6e341db6" ] }, "sort": [ 0, "01899178ab217137a158b1956a8e3358" ] }, { "_index": "sw_product_1721227718", "_id": "018991793c0c7264a8cd0db796b58508", "_score": null, "_source": { "autoIncrement": 5363.0, "id": "018991793c0c7264a8cd0db796b58508" }, "fields": { "displayGroup": [ "1b604b299443de520ea7a2894280509f" ] }, "sort": [ 0, "018991793c0c7264a8cd0db796b58508" ] }, { "_index": "sw_product_1721227718", "_id": "0189917a655f720dbaaf879393edf779", "_score": null, "_source": { "autoIncrement": 5364.0, "id": "0189917a655f720dbaaf879393edf779" }, "fields": { "displayGroup": [ "21b0ca6ddf053b8c95d1ec55794e0b9b" ] }, "sort": [ 0, "0189917a655f720dbaaf879393edf779" ] }, { "_index": "sw_product_1721227718", "_id": "73365b613e194f96afbc1eefddb2fffc", "_score": null, "_source": { "autoIncrement": 5320.0, "id": "73365b613e194f96afbc1eefddb2fffc" }, "fields": { "displayGroup": [ "55c74be8dfbc1883264a5c51fb7edc6e" ] }, "sort": [ 0, "73365b613e194f96afbc1eefddb2fffc" ] }, { "_index": "sw_product_1721227718", "_id": "934150502824450a80200d9af0e46f7c", "_score": null, "_source": { "autoIncrement": 5316.0, "id": "934150502824450a80200d9af0e46f7c" }, "fields": { "displayGroup": [ "be37d4aad06ffc2d7a3e1b4bea503fb9" ] }, "sort": [ 0, "934150502824450a80200d9af0e46f7c" ] } ] }, "aggregations": { "total-count": { "value": 25 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	3.15 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"45a3f1b817684f608c52a3b0908f9a4e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}},"total-count":{"cardinality":{"field":"displayGroup"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}}},"size":0,"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": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "45a3f1b817684f608c52a3b0908f9a4e" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "should": [ { "bool": { "must_not": [ { "nested": { "path": "categoriesRo", "query": { "terms": { "categoriesRo.id": [ "018e9f02546e7c82a9b5bda06cc934e9", "01918ec9c5fa73c5a1574670671bee08" ] } } } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 }, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } }, "total-count": { "cardinality": { "field": "displayGroup" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 }, "aggregations": { "products": { "reverse_nested": {}, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } } } } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 }, "aggregations": { "products": { "reverse_nested": {}, "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } } } } } } } }, "size": 0, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null }, "total-count": { "value": 0 } }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 25, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "e1d9ffd4e76c4828979cb847415de90b", "doc_count": 13, "products": { "doc_count": 13, "total-count": { "value": 13 } } }, { "key": "33552cc436624878b13e60b3462097d0", "doc_count": 12, "products": { "doc_count": 12, "total-count": { "value": 12 } } } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "37ab974b3dda435bb3d91c643509e5dd", "doc_count": 25, "total-count": { "value": 25 } } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"45a3f1b817684f608c52a3b0908f9a4e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


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

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "45a3f1b817684f608c52a3b0908f9a4e"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categoriesRo",
                                                            "query": {
                                                                "terms": {
                                                                    "categoriesRo.id": [
                                                                        "018e9f02546e7c82a9b5bda06cc934e9",
                                                                        "01918ec9c5fa73c5a1574670671bee08"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "sales": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 4,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 25,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1721227718",
                "_id": "018991541e2573ce868eb1fc79171e43",
                "_score": null,
                "_source": {
                    "autoIncrement": 5357.0,
                    "id": "018991541e2573ce868eb1fc79171e43"
                },
                "fields": {
                    "displayGroup": [
                        "38cd4a592c49fd2fb788a7f3226d73b0"
                    ]
                },
                "sort": [
                    23,
                    "018991541e2573ce868eb1fc79171e43"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "8ecc55e1f53c4cfea23f225e69905b1d",
                "_score": null,
                "_source": {
                    "autoIncrement": 5311.0,
                    "id": "8ecc55e1f53c4cfea23f225e69905b1d"
                },
                "fields": {
                    "displayGroup": [
                        "0a5d399aeb54ec88adf39810f39201e6"
                    ]
                },
                "sort": [
                    17,
                    "8ecc55e1f53c4cfea23f225e69905b1d"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "68db486a573d4a7089b90089c71c0c5c",
                "_score": null,
                "_source": {
                    "autoIncrement": 5324.0,
                    "id": "68db486a573d4a7089b90089c71c0c5c"
                },
                "fields": {
                    "displayGroup": [
                        "0fca0edb87cde4d28167c545d0edca44"
                    ]
                },
                "sort": [
                    12,
                    "68db486a573d4a7089b90089c71c0c5c"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "17cb09d5ac194195baab7d593a25ea73",
                "_score": null,
                "_source": {
                    "autoIncrement": 5310.0,
                    "id": "17cb09d5ac194195baab7d593a25ea73"
                },
                "fields": {
                    "displayGroup": [
                        "cd56049ed60bc020eccaf2e6659116f9"
                    ]
                },
                "sort": [
                    10,
                    "17cb09d5ac194195baab7d593a25ea73"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "0189917535dd70ea99655c46c2c55e17",
                "_score": null,
                "_source": {
                    "autoIncrement": 5359.0,
                    "id": "0189917535dd70ea99655c46c2c55e17"
                },
                "fields": {
                    "displayGroup": [
                        "8db136dfb3795fa4baaf43f4bd638358"
                    ]
                },
                "sort": [
                    5,
                    "0189917535dd70ea99655c46c2c55e17"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "018991762d16700887b7fb60a141a249",
                "_score": null,
                "_source": {
                    "autoIncrement": 5360.0,
                    "id": "018991762d16700887b7fb60a141a249"
                },
                "fields": {
                    "displayGroup": [
                        "8472fe6c03a252c60fe711561a27eb53"
                    ]
                },
                "sort": [
                    5,
                    "018991762d16700887b7fb60a141a249"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "3ff21c2650c042cbb517764dc200b364",
                "_score": null,
                "_source": {
                    "autoIncrement": 5312.0,
                    "id": "3ff21c2650c042cbb517764dc200b364"
                },
                "fields": {
                    "displayGroup": [
                        "14c0926fe0e620687ab22f9910fcaead"
                    ]
                },
                "sort": [
                    5,
                    "3ff21c2650c042cbb517764dc200b364"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "9afaa78f037f4691b903192aeb4eb7aa",
                "_score": null,
                "_source": {
                    "autoIncrement": 5313.0,
                    "id": "9afaa78f037f4691b903192aeb4eb7aa"
                },
                "fields": {
                    "displayGroup": [
                        "9f9787b28032ee6f8444cdc3731611ec"
                    ]
                },
                "sort": [
                    5,
                    "9afaa78f037f4691b903192aeb4eb7aa"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "f9496117d88a422baa994bee4e51a4f2",
                "_score": null,
                "_source": {
                    "autoIncrement": 5318.0,
                    "id": "f9496117d88a422baa994bee4e51a4f2"
                },
                "fields": {
                    "displayGroup": [
                        "cb324aef769543a8e3c4453ddd5d97c1"
                    ]
                },
                "sort": [
                    4,
                    "f9496117d88a422baa994bee4e51a4f2"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "98c7fd89824b4daba266eda3d3e1b969",
                "_score": null,
                "_source": {
                    "autoIncrement": 5323.0,
                    "id": "98c7fd89824b4daba266eda3d3e1b969"
                },
                "fields": {
                    "displayGroup": [
                        "3951609af4927bb4599f56e1a9c1faae"
                    ]
                },
                "sort": [
                    3,
                    "98c7fd89824b4daba266eda3d3e1b969"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "018991870f1a70cd8c14b08bf54e29fc",
                "_score": null,
                "_source": {
                    "autoIncrement": 5367.0,
                    "id": "018991870f1a70cd8c14b08bf54e29fc"
                },
                "fields": {
                    "displayGroup": [
                        "36ee2958c5c57e7e553a4ec32e017e52"
                    ]
                },
                "sort": [
                    2,
                    "018991870f1a70cd8c14b08bf54e29fc"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "7b8945cc3b9f4bb8b96c9d486506e863",
                "_score": null,
                "_source": {
                    "autoIncrement": 5134.0,
                    "id": "7b8945cc3b9f4bb8b96c9d486506e863"
                },
                "fields": {
                    "displayGroup": [
                        "b9479f06ab5dac7e5686812067676c9e"
                    ]
                },
                "sort": [
                    2,
                    "7b8945cc3b9f4bb8b96c9d486506e863"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "7d130f1860b744a9857f21e9f1d08ca9",
                "_score": null,
                "_source": {
                    "autoIncrement": 5309.0,
                    "id": "7d130f1860b744a9857f21e9f1d08ca9"
                },
                "fields": {
                    "displayGroup": [
                        "cd809cc58e60ec4d725084af17672e80"
                    ]
                },
                "sort": [
                    2,
                    "7d130f1860b744a9857f21e9f1d08ca9"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "a72092577aef44c980fffd73d8f9df07",
                "_score": null,
                "_source": {
                    "autoIncrement": 5321.0,
                    "id": "a72092577aef44c980fffd73d8f9df07"
                },
                "fields": {
                    "displayGroup": [
                        "c52c5b5ec419fe9a0bcfd54496e5d980"
                    ]
                },
                "sort": [
                    2,
                    "a72092577aef44c980fffd73d8f9df07"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "0189917415b0728fbec6da0ee7295b40",
                "_score": null,
                "_source": {
                    "autoIncrement": 5358.0,
                    "id": "0189917415b0728fbec6da0ee7295b40"
                },
                "fields": {
                    "displayGroup": [
                        "207bab89f1a6d763ce5087c7352fafe5"
                    ]
                },
                "sort": [
                    1,
                    "0189917415b0728fbec6da0ee7295b40"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "01899177afd57156a476dfbf2c3983b0",
                "_score": null,
                "_source": {
                    "autoIncrement": 5361.0,
                    "id": "01899177afd57156a476dfbf2c3983b0"
                },
                "fields": {
                    "displayGroup": [
                        "42d2c09bc0a01590b5d8067ee8bccff2"
                    ]
                },
                "sort": [
                    1,
                    "01899177afd57156a476dfbf2c3983b0"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "0189917cc031713a8b97ddff67418717",
                "_score": null,
                "_source": {
                    "autoIncrement": 5365.0,
                    "id": "0189917cc031713a8b97ddff67418717"
                },
                "fields": {
                    "displayGroup": [
                        "63f185655e918eb60e67f2153b5c2f6b"
                    ]
                },
                "sort": [
                    1,
                    "0189917cc031713a8b97ddff67418717"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "0189917dcc69711191e7b4f238478e3b",
                "_score": null,
                "_source": {
                    "autoIncrement": 5366.0,
                    "id": "0189917dcc69711191e7b4f238478e3b"
                },
                "fields": {
                    "displayGroup": [
                        "3de9fde513bbdfdeb764040dc63bdcec"
                    ]
                },
                "sort": [
                    1,
                    "0189917dcc69711191e7b4f238478e3b"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "5c17640b898f4dd2af43b94883f06fd7",
                "_score": null,
                "_source": {
                    "autoIncrement": 5322.0,
                    "id": "5c17640b898f4dd2af43b94883f06fd7"
                },
                "fields": {
                    "displayGroup": [
                        "b18f0e4ba092143e9e5863bfc9a8e0c7"
                    ]
                },
                "sort": [
                    1,
                    "5c17640b898f4dd2af43b94883f06fd7"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "01899178ab217137a158b1956a8e3358",
                "_score": null,
                "_source": {
                    "autoIncrement": 5362.0,
                    "id": "01899178ab217137a158b1956a8e3358"
                },
                "fields": {
                    "displayGroup": [
                        "b872a72086a4fc8cb84b4f7f6e341db6"
                    ]
                },
                "sort": [
                    0,
                    "01899178ab217137a158b1956a8e3358"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "018991793c0c7264a8cd0db796b58508",
                "_score": null,
                "_source": {
                    "autoIncrement": 5363.0,
                    "id": "018991793c0c7264a8cd0db796b58508"
                },
                "fields": {
                    "displayGroup": [
                        "1b604b299443de520ea7a2894280509f"
                    ]
                },
                "sort": [
                    0,
                    "018991793c0c7264a8cd0db796b58508"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "0189917a655f720dbaaf879393edf779",
                "_score": null,
                "_source": {
                    "autoIncrement": 5364.0,
                    "id": "0189917a655f720dbaaf879393edf779"
                },
                "fields": {
                    "displayGroup": [
                        "21b0ca6ddf053b8c95d1ec55794e0b9b"
                    ]
                },
                "sort": [
                    0,
                    "0189917a655f720dbaaf879393edf779"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "73365b613e194f96afbc1eefddb2fffc",
                "_score": null,
                "_source": {
                    "autoIncrement": 5320.0,
                    "id": "73365b613e194f96afbc1eefddb2fffc"
                },
                "fields": {
                    "displayGroup": [
                        "55c74be8dfbc1883264a5c51fb7edc6e"
                    ]
                },
                "sort": [
                    0,
                    "73365b613e194f96afbc1eefddb2fffc"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "934150502824450a80200d9af0e46f7c",
                "_score": null,
                "_source": {
                    "autoIncrement": 5316.0,
                    "id": "934150502824450a80200d9af0e46f7c"
                },
                "fields": {
                    "displayGroup": [
                        "be37d4aad06ffc2d7a3e1b4bea503fb9"
                    ]
                },
                "sort": [
                    0,
                    "934150502824450a80200d9af0e46f7c"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 25
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

3.15 ms

Request:

{"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"23c98bbe2a9749cb9001245287edcc2e"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"45a3f1b817684f608c52a3b0908f9a4e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["018e9f02546e7c82a9b5bda06cc934e9","01918ec9c5fa73c5a1574670671bee08"]}}}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}},"total-count":{"cardinality":{"field":"displayGroup"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000},"aggregations":{"products":{"reverse_nested":{},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}}}}}},"size":0,"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": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "23c98bbe2a9749cb9001245287edcc2e"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "45a3f1b817684f608c52a3b0908f9a4e"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "nested": {
                                                            "path": "categoriesRo",
                                                            "query": {
                                                                "terms": {
                                                                    "categoriesRo.id": [
                                                                        "018e9f02546e7c82a9b5bda06cc934e9",
                                                                        "01918ec9c5fa73c5a1574670671bee08"
                                                                    ]
                                                                }
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            },
            "aggregations": {
                "total-count": {
                    "cardinality": {
                        "field": "displayGroup"
                    }
                }
            }
        },
        "shipping-free-filter": {
            "filter": {
                "term": {
                    "shippingFree": true
                }
            },
            "aggregations": {
                "shipping-free": {
                    "max": {
                        "field": "shippingFree"
                    }
                },
                "total-count": {
                    "cardinality": {
                        "field": "displayGroup"
                    }
                }
            }
        },
        "properties": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    },
                    "aggregations": {
                        "products": {
                            "reverse_nested": {},
                            "aggregations": {
                                "total-count": {
                                    "cardinality": {
                                        "field": "displayGroup"
                                    }
                                }
                            }
                        }
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    },
                    "aggregations": {
                        "products": {
                            "reverse_nested": {},
                            "aggregations": {
                                "total-count": {
                                    "cardinality": {
                                        "field": "displayGroup"
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            },
            "total-count": {
                "value": 0
            }
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 25,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "e1d9ffd4e76c4828979cb847415de90b",
                        "doc_count": 13,
                        "products": {
                            "doc_count": 13,
                            "total-count": {
                                "value": 13
                            }
                        }
                    },
                    {
                        "key": "33552cc436624878b13e60b3462097d0",
                        "doc_count": 12,
                        "products": {
                            "doc_count": 12,
                            "total-count": {
                                "value": 12
                            }
                        }
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "37ab974b3dda435bb3d91c643509e5dd",
                    "doc_count": 25,
                    "total-count": {
                        "value": 25
                    }
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

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/navigation/45a3f1b817684f608c52a3b0908f9a4e

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices