Symfony Profiler

Query Metrics

5.00 ms Query Time

1 Node(s)

3 Indices

Queries

#▲ Execution Time Info

5.25 ms

#▲	Execution Time	Info
1	5.25 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"should":[{"terms":{"id":["904ac22d7c2f4d1d97ff94e1593073c7","189a85ce051e48708a982e80565a80f9","faab787859b24d2b80c0f4d6708a7b6b","e27acd2ec66247d7925ab97426f00ce7"]}},{"terms":{"parentId":["904ac22d7c2f4d1d97ff94e1593073c7","189a85ce051e48708a982e80565a80f9","faab787859b24d2b80c0f4d6708a7b6b","e27acd2ec66247d7925ab97426f00ce7"]}}]}}]}},{"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":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"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": [ "904ac22d7c2f4d1d97ff94e1593073c7", "189a85ce051e48708a982e80565a80f9", "faab787859b24d2b80c0f4d6708a7b6b", "e27acd2ec66247d7925ab97426f00ce7" ] } }, { "terms": { "parentId": [ "904ac22d7c2f4d1d97ff94e1593073c7", "189a85ce051e48708a982e80565a80f9", "faab787859b24d2b80c0f4d6708a7b6b", "e27acd2ec66247d7925ab97426f00ce7" ] } } ] } } ] } }, { "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": "string", "script": { "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n", "lang": "painless", "params": { "field": "name", "languages": [ "2fbb5fe2e29a4d70aa5854ce7ce3e20b" ] } }, "order": "ASC" } } ], "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "sw_product_1721227718", "_id": "faab787859b24d2b80c0f4d6708a7b6b", "_score": null, "_source": { "autoIncrement": 5096.0, "id": "faab787859b24d2b80c0f4d6708a7b6b" }, "fields": { "displayGroup": [ "d729824217bb86794855828a011e6e7c" ] }, "sort": [ "biomyo - 150ml" ] }, { "_index": "sw_product_1721227718", "_id": "e27acd2ec66247d7925ab97426f00ce7", "_score": null, "_source": { "autoIncrement": 5100.0, "id": "e27acd2ec66247d7925ab97426f00ce7" }, "fields": { "displayGroup": [ "d0fb98b92d058029fe2c22f5cb352972" ] }, "sort": [ "intense und sport ultraschallaufsatz l aus metall" ] }, { "_index": "sw_product_1721227718", "_id": "904ac22d7c2f4d1d97ff94e1593073c7", "_score": null, "_source": { "autoIncrement": 5314.0, "id": "904ac22d7c2f4d1d97ff94e1593073c7" }, "fields": { "displayGroup": [ "8e731f779251b3a537622eb039efe728" ] }, "sort": [ "physio pad inkl. 2 bandagen (gro\u00df\/klein)" ] }, { "_index": "sw_product_1721227718", "_id": "189a85ce051e48708a982e80565a80f9", "_score": null, "_source": { "autoIncrement": 5119.0, "id": "189a85ce051e48708a982e80565a80f9" }, "fields": { "displayGroup": [ "a82439fadff9c771abc33994b17be05c" ] }, "sort": [ "thermoeffekt - 150ml" ] } ] } } `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":["904ac22d7c2f4d1d97ff94e1593073c7","189a85ce051e48708a982e80565a80f9","faab787859b24d2b80c0f4d6708a7b6b","e27acd2ec66247d7925ab97426f00ce7"]}},{"terms":{"parentId":["904ac22d7c2f4d1d97ff94e1593073c7","189a85ce051e48708a982e80565a80f9","faab787859b24d2b80c0f4d6708a7b6b","e27acd2ec66247d7925ab97426f00ce7"]}}]}}]}},{"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":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"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": [
                                                                "904ac22d7c2f4d1d97ff94e1593073c7",
                                                                "189a85ce051e48708a982e80565a80f9",
                                                                "faab787859b24d2b80c0f4d6708a7b6b",
                                                                "e27acd2ec66247d7925ab97426f00ce7"
                                                            ]
                                                        }
                                                    },
                                                    {
                                                        "terms": {
                                                            "parentId": [
                                                                "904ac22d7c2f4d1d97ff94e1593073c7",
                                                                "189a85ce051e48708a982e80565a80f9",
                                                                "faab787859b24d2b80c0f4d6708a7b6b",
                                                                "e27acd2ec66247d7925ab97426f00ce7"
                                                            ]
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "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": "string",
                "script": {
                    "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n",
                    "lang": "painless",
                    "params": {
                        "field": "name",
                        "languages": [
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
                        ]
                    }
                },
                "order": "ASC"
            }
        }
    ],
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1721227718",
                "_id": "faab787859b24d2b80c0f4d6708a7b6b",
                "_score": null,
                "_source": {
                    "autoIncrement": 5096.0,
                    "id": "faab787859b24d2b80c0f4d6708a7b6b"
                },
                "fields": {
                    "displayGroup": [
                        "d729824217bb86794855828a011e6e7c"
                    ]
                },
                "sort": [
                    "biomyo - 150ml"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "e27acd2ec66247d7925ab97426f00ce7",
                "_score": null,
                "_source": {
                    "autoIncrement": 5100.0,
                    "id": "e27acd2ec66247d7925ab97426f00ce7"
                },
                "fields": {
                    "displayGroup": [
                        "d0fb98b92d058029fe2c22f5cb352972"
                    ]
                },
                "sort": [
                    "intense und sport ultraschallaufsatz l aus metall"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "904ac22d7c2f4d1d97ff94e1593073c7",
                "_score": null,
                "_source": {
                    "autoIncrement": 5314.0,
                    "id": "904ac22d7c2f4d1d97ff94e1593073c7"
                },
                "fields": {
                    "displayGroup": [
                        "8e731f779251b3a537622eb039efe728"
                    ]
                },
                "sort": [
                    "physio pad inkl. 2 bandagen (gro\u00df\/klein)"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "189a85ce051e48708a982e80565a80f9",
                "_score": null,
                "_source": {
                    "autoIncrement": 5119.0,
                    "id": "189a85ce051e48708a982e80565a80f9"
                },
                "fields": {
                    "displayGroup": [
                        "a82439fadff9c771abc33994b17be05c"
                    ]
                },
                "sort": [
                    "thermoeffekt - 150ml"
                ]
            }
        ]
    }
}

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/018a8eee53967211993aade8dc302e81

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices