Symfony Profiler

Query Metrics

3.00 ms Query Time

1 Node(s)

3 Indices

Queries

#▲ Execution Time Info

3.76 ms

#▲	Execution Time	Info
1	3.76 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":"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": [ "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": "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": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "sw_product_1721227718", "_id": "b4b32c5baf7f4d9ab8f774300f4fdb87", "_score": null, "_source": { "autoIncrement": 4540.0, "id": "b4b32c5baf7f4d9ab8f774300f4fdb87" }, "fields": { "displayGroup": [ "5ad4b59c98615a0e85d7e5dfdd661047" ] }, "sort": [ "fresh zahnpasta" ] }, { "_index": "sw_product_1721227718", "_id": "090ddd92c90e441383cd36e0153ac0b8", "_score": null, "_source": { "autoIncrement": 4565.0, "id": "090ddd92c90e441383cd36e0153ac0b8" }, "fields": { "displayGroup": [ "e5ac435310ba36fa7af8189d09645f5c" ] }, "sort": [ "kinder zahnpasta" ] }, { "_index": "sw_product_1721227718", "_id": "20408b03dc224b88969495c15a7c6290", "_score": null, "_source": { "autoIncrement": 4548.0, "id": "20408b03dc224b88969495c15a7c6290" }, "fields": { "displayGroup": [ "febef705d9ba4a280bc56aa5c477cb57" ] }, "sort": [ "nature calcium zahnpasta" ] }, { "_index": "sw_product_1721227718", "_id": "2caf4de28e9244fca01f768eb7b1c726", "_score": null, "_source": { "autoIncrement": 4546.0, "id": "2caf4de28e9244fca01f768eb7b1c726" }, "fields": { "displayGroup": [ "8fc31c3f49638b3fc01933bc81f3eff4" ] }, "sort": [ "nature zahnpasta" ] }, { "_index": "sw_product_1721227718", "_id": "b560ef746d4249b5abcb966f9cc1dc21", "_score": null, "_source": { "autoIncrement": 4563.0, "id": "b560ef746d4249b5abcb966f9cc1dc21" }, "fields": { "displayGroup": [ "faaab93f9782fc01c9235399d1d7a9db" ] }, "sort": [ "whitening zahnpasta" ] } ] } } `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":"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": [
                                                                "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": "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": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1721227718",
                "_id": "b4b32c5baf7f4d9ab8f774300f4fdb87",
                "_score": null,
                "_source": {
                    "autoIncrement": 4540.0,
                    "id": "b4b32c5baf7f4d9ab8f774300f4fdb87"
                },
                "fields": {
                    "displayGroup": [
                        "5ad4b59c98615a0e85d7e5dfdd661047"
                    ]
                },
                "sort": [
                    "fresh zahnpasta"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "090ddd92c90e441383cd36e0153ac0b8",
                "_score": null,
                "_source": {
                    "autoIncrement": 4565.0,
                    "id": "090ddd92c90e441383cd36e0153ac0b8"
                },
                "fields": {
                    "displayGroup": [
                        "e5ac435310ba36fa7af8189d09645f5c"
                    ]
                },
                "sort": [
                    "kinder zahnpasta"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "20408b03dc224b88969495c15a7c6290",
                "_score": null,
                "_source": {
                    "autoIncrement": 4548.0,
                    "id": "20408b03dc224b88969495c15a7c6290"
                },
                "fields": {
                    "displayGroup": [
                        "febef705d9ba4a280bc56aa5c477cb57"
                    ]
                },
                "sort": [
                    "nature calcium zahnpasta"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "2caf4de28e9244fca01f768eb7b1c726",
                "_score": null,
                "_source": {
                    "autoIncrement": 4546.0,
                    "id": "2caf4de28e9244fca01f768eb7b1c726"
                },
                "fields": {
                    "displayGroup": [
                        "8fc31c3f49638b3fc01933bc81f3eff4"
                    ]
                },
                "sort": [
                    "nature zahnpasta"
                ]
            },
            {
                "_index": "sw_product_1721227718",
                "_id": "b560ef746d4249b5abcb966f9cc1dc21",
                "_score": null,
                "_source": {
                    "autoIncrement": 4563.0,
                    "id": "b560ef746d4249b5abcb966f9cc1dc21"
                },
                "fields": {
                    "displayGroup": [
                        "faaab93f9782fc01c9235399d1d7a9db"
                    ]
                },
                "sort": [
                    "whitening zahnpasta"
                ]
            }
        ]
    }
}

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/965fc3ea7e75406fb8103dc920ebee25

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices