POST https://shopware6.eps-dev.com/store-api/search

Query Metrics

27.00 ms Query Time
1 Node(s)
58 Indices

Queries

# Execution Time Info
1 17.52 ms Request:
{"index":"sw_dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"post_filter":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}}]}},"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"function_score":{"query":{"bool":{"should":[{"wildcard":{"custom_numbers.5784003edde544828c33685f34e240a3":{"value":"*no*","boost":6000}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}},"functions":[{"field_value_factor":{"field":"sales","factor":0.0001,"modifier":"sqrt"}}]}},{"bool":{"should":[{"wildcard":{"custom_numbers.5784003edde544828c33685f34e240a3":{"value":"*no*","boost":6000}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}}]}},"sort":[{"_score":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-filtered-count":{"filter":{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}}}},"from":0,"size":10,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
2 4.90 ms Request:
{"index":"sw_dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":20}}},{"term":{"visibilities.salesChannelId":"0189b5bd293f71c6a5e92e9980f13639"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}],"must":[{"function_score":{"query":{"bool":{"should":[{"wildcard":{"custom_numbers.5784003edde544828c33685f34e240a3":{"value":"*no*","boost":6000}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}},"functions":[{"field_value_factor":{"field":"sales","factor":0.0001,"modifier":"sqrt"}}]}},{"bool":{"should":[{"wildcard":{"custom_numbers.5784003edde544828c33685f34e240a3":{"value":"*no*","boost":6000}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"no*","boost":800}}},{"wildcard":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"value":"*no*","boost":400}}},{"match_phrase_prefix":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":240,"slop":1}}},{"match":{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":100,"fuzziness":"auto"}}},{"match":{"productNumber.ngram":{"query":"no","boost":150,"fuzziness":"auto"}}},{"match":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.search":{"query":"no","boost":40,"fuzziness":"auto"}}},{"match_phrase_prefix":{"customSearchKeywords.2fbb5fe2e29a4d70aa5854ce7ce3e20b.ngram":{"query":"no","boost":40,"slop":1}}},{"match":{"ean.search":{"query":"no","boost":100,"fuzziness":0}}},{"match":{"manufacturerNumber.ngram":{"query":"no","boost":100,"fuzziness":0}}}],"minimum_should_match":"1"}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule0189fd8d21be719c8a927c776213ad61_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule019348d84b7f7073880013b27b0a8154_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rulebc145323ade940ba94e1431217d21eb6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757970f38af8d735ac2bef24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5bc757d738cb8f62b8ca13162fd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9aba570cdb1eb3cecd2cd9c14_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abd6705194a82ba278ac3818_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abda7332b863147ce447ce56_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9abdf7322bfe0eae808e536f0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c87910bd371d393228503b3bfacba_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule018c878c44ec7319843d27a0a5c7e9fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5c9ab9b73b8b6ca8da792e44880_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb7d71a3937f90ce846b78ad_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb8870c3a0d7916756166232_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb987107b20becc38a90e410_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9b731b9ef2ca9a3c0e2e19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebb9e7245a64ccd2ca462bba7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cebba27154ba4b3557620fbed5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec73f71a8ba659d9cb213157a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec743726f9e900fe942743ec9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec74670539b2bed35e48007ed_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79573ce87a699e82c77ca99_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec79e72c0a0cc7f7518e1c7a0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a17342a94f499b908eb3c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7a67189aed96e522a050f7f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7ad732ba4fca7f80c74c02c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7b17013af6e99af52d09228_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7d670be81a63be615cff357_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec7fa715eb3c904adfa6d2214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec81c709aa4a0eb7f072bffef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec83e73ceb6955e47bc5234ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec860709abfd7eac6765915c9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec88370108c594aac8328aab9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8ab704bb164800ad4f9d598_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec8d270769eae865bca59328f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec930710b8cdfad050e36f664_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5cec95373fea9fe590044a03214_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule0189b5ced52f71c4b4142914b338345a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":100,"round":true,"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":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"properties":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"propertiesCount":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"propertiesCount":{"terms":{"field":"propertyIds","size":10000}}}}}},"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["89ee44dcf85c46718ba0744360e5fcc1"]}}}}]}}]}},"aggregations":{"brands":{"filter":{"bool":{"should":[{"bool":{"must_not":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["a2e3ce1f6e7241a783db0a98b0003a84"]}}}}]}}]}},"aggregations":{"brands":{"terms":{"field":"manufacturerId","size":10000}}}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
3 2.68 ms Request:
{"index":"sw_dev_product_manufacturer","search_type":"query_then_fetch","track_total_hits":true,"body":{"from":0,"size":9,"timeout":"5s"}}
4 2.20 ms Request:
{"index":"sw_dev_category","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"active":true}},{"bool":{"should":[{"wildcard":{"path":{"value":"*|d7b7b163000841a1876dbff5548c039f|*"}}},{"wildcard":{"path":{"value":"*|85198047d8e44d18b38cc9080624d1df|*"}}},{"wildcard":{"path":{"value":"*|85198047d8e44d18b38cc9080624d1df|*"}}}]}}]}}]}},"from":0,"size":9,"timeout":"5s"}}

Cluster Status

{
    "cluster_name": "showpare",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 65,
    "active_shards": 65,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 76,
    "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": 46.09929078014184
}

Indices

Name Status Replication (pri, rep) Doc Count
.ql-datasources open 1, 0 0
security-auditlog-2025.01.20 open 1, 1 125
top_queries-2025.02.20-91901 open 1, 1 263
security-auditlog-2025.01.22 open 1, 1 300
security-auditlog-2025.01.21 open 1, 1 396
security-auditlog-2025.01.24 open 1, 1 235
security-auditlog-2025.01.23 open 1, 1 1641
security-auditlog-2025.01.26 open 1, 1 91
security-auditlog-2025.01.25 open 1, 1 83
security-auditlog-2025.01.28 open 1, 1 98
.opendistro_security open 1, 0 10
security-auditlog-2025.01.27 open 1, 1 164
security-auditlog-2025.01.29 open 1, 1 98
.opensearch-observability open 1, 0 0
top_queries-2025.02.24-91905 open 1, 1 243
top_queries-2025.02.18-91878 open 1, 1 139
sw_dev_category_1737186629 open 3, 3 0
security-auditlog-2025.01.31 open 1, 1 209
security-auditlog-2025.01.30 open 1, 1 118
security-auditlog-2025.02.01 open 1, 1 697
.kibana_92668751_admin_1 open 1, 0 1
security-auditlog-2025.02.03 open 1, 1 489
top_queries-2025.02.21-91902 open 1, 1 276
security-auditlog-2025.02.02 open 1, 1 326
security-auditlog-2025.02.05 open 1, 1 200
security-auditlog-2025.02.04 open 1, 1 69
security-auditlog-2025.02.07 open 1, 1 95
sw_dev_product_manufacturer_1737186629 open 3, 3 0
security-auditlog-2025.02.06 open 1, 1 113
security-auditlog-2025.02.09 open 1, 1 91
security-auditlog-2025.02.08 open 1, 1 142
top_queries-2025.02.19-91879 open 1, 1 344
security-auditlog-2025.02.10 open 1, 1 213
security-auditlog-2025.02.12 open 1, 1 158
security-auditlog-2025.02.11 open 1, 1 193
security-auditlog-2025.02.14 open 1, 1 231
security-auditlog-2025.02.13 open 1, 1 135
security-auditlog-2025.02.16 open 1, 1 78
security-auditlog-2025.02.15 open 1, 1 57
security-auditlog-2025.02.18 open 1, 1 74
security-auditlog-2025.02.17 open 1, 1 205
security-auditlog-2025.02.19 open 1, 1 186
top_queries-2025.02.22-91903 open 1, 1 258
sw_dev_product_1737186629 open 3, 3 61963
security-auditlog-2025.02.21 open 1, 1 208
security-auditlog-2025.02.20 open 1, 1 251
security-auditlog-2025.02.23 open 1, 1 96
security-auditlog-2025.02.22 open 1, 1 611
security-auditlog-2025.02.24 open 1, 1 261
security-auditlog-2025.01.15 open 1, 1 187
security-auditlog-2025.01.14 open 1, 1 122
security-auditlog-2025.01.17 open 1, 1 77
security-auditlog-2025.01.16 open 1, 1 356
.kibana_1 open 1, 0 0
security-auditlog-2025.01.19 open 1, 1 49
security-auditlog-2025.01.18 open 1, 1 248
top_queries-2025.02.23-91904 open 1, 1 99
.plugins-ml-config open 1, 0 1