Symfony Profiler

Query Metrics

100.00 ms Query Time

1 Node(s)

19 Indices

Queries

#▲	Execution Time	Info
1	45.91 ms	Request: {"index":"sw_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"dis_max":{"queries":[{"wildcard":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags":{"value":"2026"}}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"01916a8b94f873b8abf36daf28eb865c"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"bool":{"should":[{"bool":{"should":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":10000.0,"fuzziness":0}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":8000.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":6000.0,"fuzziness":"auto"}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":4000.0}}}]}},{"bool":{"should":[{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":1500.0,"fuzziness":"auto"}}},{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":1000.0}}}]}},{"bool":{"should":[{"match":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":4500.0,"fuzziness":0}}},{"match_phrase_prefix":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":3600.0,"slop":3,"max_expansions":10}}},{"match":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":2700.0,"fuzziness":1}}}]}}]}}]}},"sort":[{"_score":{"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: 0 View formatted request View formatted response View query backtrace POST http://localhost:9200/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": { "should": [ { "dis_max": { "queries": [ { "wildcard": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags": { "value": "2026" } } } ] } } ] } }, { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 20 } } }, { "term": { "visibilities.salesChannelId": "01916a8b94f873b8abf36daf28eb865c" } } ] } } } }, { "term": { "active": true } } ] } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ], "must": [ { "bool": { "should": [ { "bool": { "should": [ { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 10000.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 8000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 6000.0, "fuzziness": "auto" } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 4000.0 } } } ] } }, { "bool": { "should": [ { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 1500.0, "fuzziness": "auto" } } }, { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 1000.0 } } } ] } }, { "bool": { "should": [ { "match": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 4500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 3600.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 2700.0, "fuzziness": 1 } } } ] } } ] } } ] } }, "sort": [ { "_score": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } `{ "took": 22, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 0, "relation": "eq" }, "max_score": null, "hits": [] }, "aggregations": { "total-count": { "value": 0 } } }` `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	16.79 ms	Request: {"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"dis_max":{"queries":[{"wildcard":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags":{"value":"2026"}}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"01916a8b94f873b8abf36daf28eb865c"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}],"must":[{"bool":{"should":[{"bool":{"should":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":10000.0,"fuzziness":0}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":8000.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":6000.0,"fuzziness":"auto"}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":4000.0}}}]}},{"bool":{"should":[{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":1500.0,"fuzziness":"auto"}}},{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":1000.0}}}]}},{"bool":{"should":[{"match":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":4500.0,"fuzziness":0}}},{"match_phrase_prefix":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":3600.0,"slop":3,"max_expansions":10}}},{"match":{"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search":{"query":"2026","boost":2700.0,"fuzziness":1}}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule01916a872aa67073a439dac37fda65ce_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872b06731f944de6ce7d37a1ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a87582c7066ac933f518487bb58_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872bc671468a07d17a479d67ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01926bff81cd7a28a9bef5237df79775_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01936c370d0f77298568834e2375435b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01938c23a6677e1abf55445326ad0934_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872bcc7376bc9463a879514eff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":1000000,"round":false,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://localhost:9200/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": [ { "dis_max": { "queries": [ { "wildcard": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags": { "value": "2026" } } } ] } } ] } }, { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 20 } } }, { "term": { "visibilities.salesChannelId": "01916a8b94f873b8abf36daf28eb865c" } } ] } } } }, { "term": { "active": true } } ] } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ], "must": [ { "bool": { "should": [ { "bool": { "should": [ { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 10000.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 8000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 6000.0, "fuzziness": "auto" } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 4000.0 } } } ] } }, { "bool": { "should": [ { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 1500.0, "fuzziness": "auto" } } }, { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 1000.0 } } } ] } }, { "bool": { "should": [ { "match": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 4500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 3600.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.Tags.search": { "query": "2026", "boost": 2700.0, "fuzziness": 1 } } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule01916a872aa67073a439dac37fda65ce_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01916a872b06731f944de6ce7d37a1ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01916a87582c7066ac933f518487bb58_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01916a872bc671468a07d17a479d67ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01926bff81cd7a28a9bef5237df79775_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01936c370d0f77298568834e2375435b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01938c23a6677e1abf55445326ad0934_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_rule01916a872bcc7376bc9463a879514eff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net", "factor": 1 } ], "decimals": 1000000, "round": false, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 11, "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 } }, "rating-exists": { "doc_count": 0, "rating": { "value": null } }, "price": { "count": 0, "min": null, "max": null, "avg": null, "sum": 0.0 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`
3	6.64 ms	Request: {"index":"sw_product_manufacturer","track_total_hits":true,"body":{"query":{"bool":{"should":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":1500.0,"fuzziness":"auto"}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":1000.0}}}]}},"from":0,"size":30,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 0 View formatted request View formatted response View query backtrace POST http://localhost:9200/sw_product_manufacturer/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "should": [ { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 1500.0, "fuzziness": "auto" } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 1000.0 } } } ] } }, "from": 0, "size": 30, "timeout": "5s" } `{ "took": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 0, "relation": "eq" }, "max_score": null, "hits": [] } }` `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
4	31.42 ms	Request: {"index":"sw_category","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"active":true}},{"bool":{"should":[{"wildcard":{"path":{"value":"\|01919397d27f707fa87aee0385e95a41\|"}}},{"wildcard":{"path":{"value":"\|01919d29ac57705480e38b9e1e6bf816\|"}}},{"wildcard":{"path":{"value":"\|01919794523f795ca70419010c8c273f\|"}}}]}}]}}],"must":[{"bool":{"should":[{"bool":{"should":[{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":1500.0,"fuzziness":"auto"}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"2026","boost":1000.0}}}]}},{"bool":{"should":[{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"2026","boost":1500.0,"fuzziness":1}}}]}},{"nested":{"path":"tags","query":{"bool":{"should":[{"match":{"tags.name.search":{"query":"2026","boost":2500.0,"fuzziness":0}}},{"match_phrase_prefix":{"tags.name.search":{"query":"2026","boost":2000.0,"slop":3,"max_expansions":10}}},{"match":{"tags.name.search":{"query":"2026","boost":1500.0,"fuzziness":"auto"}}},{"match":{"tags.name.ngram":{"query":"2026","boost":1000.0}}}]}}}}]}}]}},"from":0,"size":30,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 0 View formatted request View formatted response View query backtrace POST http://localhost:9200/sw_category/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "term": { "active": true } }, { "bool": { "should": [ { "wildcard": { "path": { "value": "\|01919397d27f707fa87aee0385e95a41\|" } } }, { "wildcard": { "path": { "value": "\|01919d29ac57705480e38b9e1e6bf816\|" } } }, { "wildcard": { "path": { "value": "\|01919794523f795ca70419010c8c273f\|" } } } ] } } ] } } ], "must": [ { "bool": { "should": [ { "bool": { "should": [ { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 1500.0, "fuzziness": "auto" } } }, { "match": { "name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram": { "query": "2026", "boost": 1000.0 } } } ] } }, { "bool": { "should": [ { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "keywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search": { "query": "2026", "boost": 1500.0, "fuzziness": 1 } } } ] } }, { "nested": { "path": "tags", "query": { "bool": { "should": [ { "match": { "tags.name.search": { "query": "2026", "boost": 2500.0, "fuzziness": 0 } } }, { "match_phrase_prefix": { "tags.name.search": { "query": "2026", "boost": 2000.0, "slop": 3, "max_expansions": 10 } } }, { "match": { "tags.name.search": { "query": "2026", "boost": 1500.0, "fuzziness": "auto" } } }, { "match": { "tags.name.ngram": { "query": "2026", "boost": 1000.0 } } } ] } } } } ] } } ] } }, "from": 0, "size": 30, "timeout": "5s" } `{ "took": 28, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 0, "relation": "eq" }, "max_score": null, "hits": [] } }` `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "green",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 56,
    "active_shards": 56,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 0,
    "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": 100.0
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw_product_manufacturer_1734020675	open	3, 0	3
sw_category_1734093671	open	3, 0	95
sw_product_manufacturer_1734020216	open	3, 0	3
sw_product_manufacturer_1734022678	open	3, 0	3
sw_product_1734020216	open	3, 0	3092
sw_product_manufacturer_1734093671	open	3, 0	3
sw_product_1734503276	open	3, 0	3116
sw_product_1734020675	open	3, 0	3092
sw_category_1734503886	open	3, 0	108
.geoip_databases	open	1, 0	40
sw_product_manufacturer_1734503886	open	3, 0	25
sw_product_1734022678	open	3, 0	3097
sw_category_1734022678	open	3, 0	95
sw_product_1734093671	open	3, 0	3116
sw_category_1734020216	open	3, 0	95
sw_product_1734503886	open	3, 0	4820
sw_category_1734503276	open	3, 0	95
sw_product_manufacturer_1734503276	open	3, 0	3
sw_category_1734020675	open	3, 0	95

Symfony Profiler

GET https://aquarius-stage.toscom.at/search?search=2026

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices