Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 31
• Events
• Routing
• Cache
• Translation 18
• Twig
• HTTP Client
• Debug
• Doctrine
• Messages
• Scripts
• Elasticsearch
• Active Rules
• Cache tags
• Cart 0
• Emails
• Serializer
• Vite
• Feature flags
• Configuration

Query Metrics

Queries

{"index":"sw64_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"term":{"manufacturerId":"a860880b8bf54f07a107f7c98c147fb1"}}]}},{"bool":{"must_not":[{"term":{"id":"2f24e5d3b0be4fc987fb8cd7f7536870"}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"coverId"}}]}}]}},{"exists":{"field":"displayGroup"}},{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_0a197278a7514b78a06ea27ef27e9ef8":{"gte":10}}}]}}]}}]}},"sort":[{"releaseDate":{"order":"DESC"}}],"from":0,"size":10,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

POST http://localhost:9200/sw64_product/_search?search_type=query_then_fetch&track_total_hits=0
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "term": {
                                                "manufacturerId": "a860880b8bf54f07a107f7c98c147fb1"
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "term": {
                                                "id": "2f24e5d3b0be4fc987fb8cd7f7536870"
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "coverId"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "exists": {
                                    "field": "displayGroup"
                                }
                            },
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        },
                                        {
                                            "range": {
                                                "visibility_0a197278a7514b78a06ea27ef27e9ef8": {
                                                    "gte": 10
                                                }
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "releaseDate": {
                "order": "DESC"
            }
        }
    ],
    "from": 0,
    "size": 10,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}
                                        

{
    "took": 6,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

Cluster Status

{
    "cluster_name": "albertvanderveen",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 45,
    "active_shards": 45,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 2,
    "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": 95.74468085106383
}

Indices