GET https://www.rosland.bayern/navigation/3f033e83634840b0aff5478d4073c800?p=-39

Query Metrics

13.00 ms Query Time
1 Node(s)
26 Indices

Queries

# Execution Time Info
1 6.75 ms Request:
{"index":"sw_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"terms":{"categoryTree":["3f033e83634840b0aff5478d4073c800","019874f87a397a62bd5b12789bcbe597","0198887a01607037ab4229d35125d682","0198a7fb361e4792a4b01fd8c69802e5","0948ffb90dcc4adb8a1b0c49ef1d822c","396c14457dbe45c1a341ad6eccb58372","51f13fa77c9a47a0a480da5d628267cf","07bba04cf68d4b65aa04198af6514b55","1861993eac744021aa6ff42ca6ad7172","820ffa045f22487a91897759c15ca172","c1fa6f52e57544d881014ca5d9e26228","ed47c5a4f97046d09de17f8f78a40ba4","019874f8906f72fe8019a0d2eb30e889","0198887fec6d7df99a8f9f1fb40f6a93","002f736fe8854dfeb05e6ec8bc1d4675","cb710c67da94415a8895b55fd1b29caa","461b21abdbb44d27b500c876ed79a698","b0de198b4a1f4506a8aba9b9113a1e88","019874f89d9571db9035db899697328a","0191afb6e06c74edae17d67a448ee977","0191ff9ba2be7bc2a26a101d549f4df0","0566b040627f4452aa02a25f654b34e0","4c23231e83604c82af33562141b609b4","82c106727dc940c98aef47eced57bfa7","a87456995c0e4bf38c8fc0284760ddcc","fe5b649f6d1e45bdafc7479136a90d6b","0191ffda20017097ab3f158fd9c62217","02bbbdc51bba42a5a58240e945f1f538","1d3bdd0d0b194fe9b01d426b61503447","33072838c6704f86a0c9cb64ab2d4f31","3e87def1d0804859b572320140bf817e","b209438040e34cca88c56ed9599e880e","e4c971329a4b46b588e8cc3f6d32fda9","0198887a679d721dab734d8dfa53e0e4","0f47f62244114dcda5d0fafee3fb7517","17319468f0174bb9bf691db9fddadbad","4c343c54a6d4462786df6c53e9fffb1c","57279104de774d0b8132c1f3171946a8","6ea664abc17141e6a0efa6d2ee317c7b","77c37e8bc53949418b7f852c6e5560ac","7c65fe5148494ae6919927757c54fd43","7fae1502177046acadac4fdde5e160f2","952c84237fc34474b2106b85759a8bc6","9c4cd8b5bfe543078bd52781514ef7ed","a51f1078d60e41c3ba11303adf68e815","be12db1a617a4fe598723040991a9765","c3db32b96aae440b9ab6b94560ae1c45","d6b7ffc0b4254444a7a7f78731bfc470","ea24afbd95e94b6cb1752119d6c39bf8","fb48ebaf64664901bc1c496a78b87334","1209539cb11a4ba98ea0e3a93016af4a","15bd872c02064309996352c227ebaec7","55897c962e554647a08c3a3b97c6b415","579876ee3eb54f59a5a53cb2497bbb2a","019874f8a8a8709089b0269b81f24673","0198887a81547b4eaa3383a3008489f1","018b58fc4ecb7dfab7440a4f7fc149d4","019198cabdb47335af12feb95d5908fb","445a1bb64a4048e5a5101bc84a5df467","6b6517bfaf9d491bb19655f1edf6b4af","e0cbb91865274128a0b44245c25af705","674e2c94602d4206b42a2f445550b54b","69606d4711c840d9ad6f83c04aa8fa3f","7bc3abe7bae5407f9d1d73a7186b9b4e","9c886ae4805247fc871bc860b4527457","0198750a5fbc7575a18fa8f6403da123","1ef4ef5f5b67444aa7b9d9179df92343","3f1931430aec4d65a6660187f977a5d9","7cc6c1f06d6b48389367a440a31431b0","874f3150aed64f279dba382eef07ebfe","bae6b34d47314270b989de9bc13a20a4","bee52f2b0200409b9327fdf64f9af5f5","00287fe188cc4880beb307cb331d8760","0c14d04cc33e402a921fbefb20ccaaab","15e9230ff6304b6eb4a8b6cc4a72af22","25e7ed25d6214252b7c549d3861fab7b","575617d66523484faec66ad162985f60","a54f28caa4d547c690400808af201c70","e06d01a5fe97400794916e0266b2ad32","e1994d6003c94cf280d796135b398b9f","e87e43183bff4e44b04bed0e3a5f5b68"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["3f033e83634840b0aff5478d4073c800"]}}}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","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;\n    }\n}\n\nif (params['order'] == 'asc') {\n    return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_product_rosland_set_year","order":"desc"}},"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":86,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
2 6.76 ms Request:
{"index":"sw_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"terms":{"categoryTree":["3f033e83634840b0aff5478d4073c800","019874f87a397a62bd5b12789bcbe597","0198887a01607037ab4229d35125d682","0198a7fb361e4792a4b01fd8c69802e5","0948ffb90dcc4adb8a1b0c49ef1d822c","396c14457dbe45c1a341ad6eccb58372","51f13fa77c9a47a0a480da5d628267cf","07bba04cf68d4b65aa04198af6514b55","1861993eac744021aa6ff42ca6ad7172","820ffa045f22487a91897759c15ca172","c1fa6f52e57544d881014ca5d9e26228","ed47c5a4f97046d09de17f8f78a40ba4","019874f8906f72fe8019a0d2eb30e889","0198887fec6d7df99a8f9f1fb40f6a93","002f736fe8854dfeb05e6ec8bc1d4675","cb710c67da94415a8895b55fd1b29caa","461b21abdbb44d27b500c876ed79a698","b0de198b4a1f4506a8aba9b9113a1e88","019874f89d9571db9035db899697328a","0191afb6e06c74edae17d67a448ee977","0191ff9ba2be7bc2a26a101d549f4df0","0566b040627f4452aa02a25f654b34e0","4c23231e83604c82af33562141b609b4","82c106727dc940c98aef47eced57bfa7","a87456995c0e4bf38c8fc0284760ddcc","fe5b649f6d1e45bdafc7479136a90d6b","0191ffda20017097ab3f158fd9c62217","02bbbdc51bba42a5a58240e945f1f538","1d3bdd0d0b194fe9b01d426b61503447","33072838c6704f86a0c9cb64ab2d4f31","3e87def1d0804859b572320140bf817e","b209438040e34cca88c56ed9599e880e","e4c971329a4b46b588e8cc3f6d32fda9","0198887a679d721dab734d8dfa53e0e4","0f47f62244114dcda5d0fafee3fb7517","17319468f0174bb9bf691db9fddadbad","4c343c54a6d4462786df6c53e9fffb1c","57279104de774d0b8132c1f3171946a8","6ea664abc17141e6a0efa6d2ee317c7b","77c37e8bc53949418b7f852c6e5560ac","7c65fe5148494ae6919927757c54fd43","7fae1502177046acadac4fdde5e160f2","952c84237fc34474b2106b85759a8bc6","9c4cd8b5bfe543078bd52781514ef7ed","a51f1078d60e41c3ba11303adf68e815","be12db1a617a4fe598723040991a9765","c3db32b96aae440b9ab6b94560ae1c45","d6b7ffc0b4254444a7a7f78731bfc470","ea24afbd95e94b6cb1752119d6c39bf8","fb48ebaf64664901bc1c496a78b87334","1209539cb11a4ba98ea0e3a93016af4a","15bd872c02064309996352c227ebaec7","55897c962e554647a08c3a3b97c6b415","579876ee3eb54f59a5a53cb2497bbb2a","019874f8a8a8709089b0269b81f24673","0198887a81547b4eaa3383a3008489f1","018b58fc4ecb7dfab7440a4f7fc149d4","019198cabdb47335af12feb95d5908fb","445a1bb64a4048e5a5101bc84a5df467","6b6517bfaf9d491bb19655f1edf6b4af","e0cbb91865274128a0b44245c25af705","674e2c94602d4206b42a2f445550b54b","69606d4711c840d9ad6f83c04aa8fa3f","7bc3abe7bae5407f9d1d73a7186b9b4e","9c886ae4805247fc871bc860b4527457","0198750a5fbc7575a18fa8f6403da123","1ef4ef5f5b67444aa7b9d9179df92343","3f1931430aec4d65a6660187f977a5d9","7cc6c1f06d6b48389367a440a31431b0","874f3150aed64f279dba382eef07ebfe","bae6b34d47314270b989de9bc13a20a4","bee52f2b0200409b9327fdf64f9af5f5","00287fe188cc4880beb307cb331d8760","0c14d04cc33e402a921fbefb20ccaaab","15e9230ff6304b6eb4a8b6cc4a72af22","25e7ed25d6214252b7c549d3861fab7b","575617d66523484faec66ad162985f60","a54f28caa4d547c690400808af201c70","e06d01a5fe97400794916e0266b2ad32","e1994d6003c94cf280d796135b398b9f","e87e43183bff4e44b04bed0e3a5f5b68"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"categoriesRo","query":{"terms":{"categoriesRo.id":["3f033e83634840b0aff5478d4073c800"]}}}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"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"}

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 128,
    "active_shards": 128,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 279,
    "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": 31.44963144963145
}

Indices

Name Status Replication (pri, rep) Doc Count
roslandn_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1685973755 open 3, 3 0
roslandn_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1685973732 open 3, 3 0
rosland_product_1712914068 open 3, 3 228333
sw-admin-sales-channel-listing_1696198995 open 3, 3 4
sw_product_1717666766 open 3, 3 0
sw-admin-product-stream-listing_1696198998 open 3, 3 45
sw-admin-category-listing_1696198945 open 3, 3 0
sw-admin-shipping-method-listing_1696198996 open 3, 3 6
rosland_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1696198942 open 3, 3 17524
sw-admin-landing-page-listing_1696198989 open 3, 3 0
sw-admin-newsletter-recipient-listing_1696198998 open 3, 3 173
sw-admin-customer-listing_1696198987 open 3, 3 2918
sw-admin-product-listing_1696198993 open 3, 3 4963
sw-admin-cms-page-listing_1696198986 open 3, 3 194
sw-admin-payment-method-listing_1696198992 open 3, 3 68
sw-admin-order-listing_1696198991 open 3, 3 3477
sw-admin-customer-group-listing_1696198988 open 3, 3 4
rosland_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1696198953 open 3, 3 158814
sw-admin-category-listing_1696198997 open 3, 3 425
sw-admin-manufacturer-listing_1696198990 open 3, 3 37
sw-admin-shipping-method-listing_1696198944 open 3, 3 0
sw_product_1717666750 open 3, 3 247600
sw_product_1717666794 open 3, 3 0
sw-admin-media-listing_1696198991 open 3, 3 22533
sw-admin-promotion-listing_1696198994 open 3, 3 25
sw-admin-property-group-listing_1696198994 open 3, 3 20