https://hyfindrdev.com/es/store/EPowerlans

Query Metrics

3 Database Queries
24.65 ms Execution Time
11.00 ms Query Time

Queries

# Execution Time Query Time Info
1 17.90 ms 9.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["epowerlabs"]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword","size":1000}},"vendor":{"terms":{"field":"vendor.keyword","size":1000}},"tag":{"terms":{"field":"tags_es.keyword","size":1000}},"pa_accuracy":{"terms":{"field":"attribute_pa_accuracy_es.keyword","size":1000}},"pa_cell-count":{"terms":{"field":"attribute_pa_cell-count_es","size":1000}},"pa_channel-count":{"terms":{"field":"attribute_pa_channel-count_es","size":1000}},"pa_channel-voltage-range":{"terms":{"field":"attribute_pa_channel-voltage-range_es","size":1000}},"pa_compliant-with":{"terms":{"field":"attribute_pa_compliant-with_es.keyword","size":1000}},"pa_compressor-type":{"terms":{"field":"attribute_pa_compressor-type_es.keyword","size":1000}},"pa_connectorthreading":{"terms":{"field":"attribute_pa_connectorthreading_es.keyword","size":1000}},"pa_control-interface":{"terms":{"field":"attribute_pa_control-interface_es.keyword","size":1000}},"pa_converter-topology":{"terms":{"field":"attribute_pa_converter-topology_es.keyword","size":1000}},"pa_countries-sold-to":{"terms":{"field":"attribute_pa_countries-sold-to_es.keyword","size":1000}},"pa_current-at-max-load-in-a":{"terms":{"field":"attribute_pa_current-at-max-load-in-a_es","size":1000}},"pa_current-density-in-a-cm2":{"terms":{"field":"attribute_pa_current-density-in-a-cm2_es","size":1000}},"pa_cut-off-particle-size-μm":{"terms":{"field":"attribute_pa_cut-off-particle-size-μm_es.keyword","size":1000}},"pa_diameter-in-mm":{"terms":{"field":"attribute_pa_diameter-in-mm_es","size":1000}},"pa_dynamic-radial-load-rating":{"terms":{"field":"attribute_pa_dynamic-radial-load-rating_es","size":1000}},"pa_efficiency-incl-chp-in":{"terms":{"field":"attribute_pa_efficiency-incl-chp-in_es","size":1000}},"pa_eis-frequency":{"terms":{"field":"attribute_pa_eis-frequency_es","size":1000}},"pa_elec-conductivity":{"terms":{"field":"attribute_pa_elec-conductivity_es","size":1000}},"pa_electrical-efficiency":{"terms":{"field":"attribute_pa_electrical-efficiency_es","size":1000}},"pa_exchange-capacity":{"terms":{"field":"attribute_pa_exchange-capacity_es","size":1000}},"pa_flow-configuration":{"terms":{"field":"attribute_pa_flow-configuration_es.keyword","size":1000}},"pa_fluid-connector-type":{"terms":{"field":"attribute_pa_fluid-connector-type_es.keyword","size":1000}},"pa_fuel":{"terms":{"field":"attribute_pa_fuel_es.keyword","size":1000}},"pa_fuel-cell-type":{"terms":{"field":"attribute_pa_fuel-cell-type_es.keyword","size":1000}},"pa_fuel-quality-grade":{"terms":{"field":"attribute_pa_fuel-quality-grade_es.keyword","size":1000}},"pa_geometrical-volume-in-l":{"terms":{"field":"attribute_pa_geometrical-volume-in-l_es","size":1000}},"pa_h2-output":{"terms":{"field":"attribute_pa_h2-output_es","size":1000}},"pa_h2-production-rate-in-nl-h":{"terms":{"field":"attribute_pa_h2-production-rate-in-nl-h_es","size":1000}},"pa_h2-production-rate-in-nm3-h":{"terms":{"field":"attribute_pa_h2-production-rate-in-nm3-h_es","size":1000}},"pa_h2-production-rate-kg-day":{"terms":{"field":"attribute_pa_h2-production-rate-kg-day_es","size":1000}},"pa_h2-production-rate-ncm3-min":{"terms":{"field":"attribute_pa_h2-production-rate-ncm3-min_es","size":1000}},"pa_highest-measurable-temp":{"terms":{"field":"attribute_pa_highest-measurable-temp_es","size":1000}},"pa_hydrogen-flow-kg-day":{"terms":{"field":"attribute_pa_hydrogen-flow-kg-day_es","size":1000}},"pa_hydrogen-supply-pressure":{"terms":{"field":"attribute_pa_hydrogen-supply-pressure_es","size":1000}},"pa_ingress-protection-rating":{"terms":{"field":"attribute_pa_ingress-protection-rating_es.keyword","size":1000}},"pa_lowest-measurable-temp":{"terms":{"field":"attribute_pa_lowest-measurable-temp_es","size":1000}},"pa_manufacturing-readiness-mrl":{"terms":{"field":"attribute_pa_manufacturing-readiness-mrl_es","size":1000}},"pa_material-feed":{"terms":{"field":"attribute_pa_material-feed_es.keyword","size":1000}},"pa_max-ambient-humidity-in-r-h":{"terms":{"field":"attribute_pa_max-ambient-humidity-in-r-h_es","size":1000}},"pa_max-bridging-time":{"terms":{"field":"attribute_pa_max-bridging-time_es","size":1000}},"pa_max-capacity-in-kw":{"terms":{"field":"attribute_pa_max-capacity-in-kw_es","size":1000}},"pa_max-compression-ratio":{"terms":{"field":"attribute_pa_max-compression-ratio_es","size":1000}},"pa_max-cooling-capacity-in-kw":{"terms":{"field":"attribute_pa_max-cooling-capacity-in-kw_es","size":1000}},"pa_max-current":{"terms":{"field":"attribute_pa_max-current_es","size":1000}},"pa_max-fuel-consumption-kg-h":{"terms":{"field":"attribute_pa_max-fuel-consumption-kg-h_es","size":1000}},"pa_max-inlet-pressure-bar":{"terms":{"field":"attribute_pa_max-inlet-pressure-bar_es","size":1000}},"pa_max-inlet-temp-in-oc":{"terms":{"field":"attribute_pa_max-inlet-temp-in-oc_es","size":1000}},"pa_max-inner-diameter":{"terms":{"field":"attribute_pa_max-inner-diameter_es","size":1000}},"pa_max-input-voltage-in-v":{"terms":{"field":"attribute_pa_max-input-voltage-in-v_es","size":1000}},"pa_max-mass-flow-in-g-s":{"terms":{"field":"attribute_pa_max-mass-flow-in-g-s_es","size":1000}},"pa_max-medium-temperature-in-c":{"terms":{"field":"attribute_pa_max-medium-temperature-in-c_es","size":1000}},"pa_max-number-of-fins-per-inch":{"terms":{"field":"attribute_pa_max-number-of-fins-per-inch_es","size":1000}},"pa_max-number-of-plates":{"terms":{"field":"attribute_pa_max-number-of-plates_es","size":1000}},"pa_max-operating-altitude":{"terms":{"field":"attribute_pa_max-operating-altitude_es","size":1000}},"pa_max-outer-diameter":{"terms":{"field":"attribute_pa_max-outer-diameter_es","size":1000}},"pa_max-outlet-pressure-bar":{"terms":{"field":"attribute_pa_max-outlet-pressure-bar_es","size":1000}},"pa_max-output-voltage-in-v":{"terms":{"field":"attribute_pa_max-output-voltage-in-v_es","size":1000}},"pa_max-plates-p-a":{"terms":{"field":"attribute_pa_max-plates-p-a_es","size":1000}},"pa_max-power-output-in-kw":{"terms":{"field":"attribute_pa_max-power-output-in-kw_es","size":1000}},"pa_max-pressure-in-bar":{"terms":{"field":"attribute_pa_max-pressure-in-bar_es","size":1000}},"pa_max-relative-pressure-bar":{"terms":{"field":"attribute_pa_max-relative-pressure-bar_es","size":1000}},"pa_max-rotational-speed":{"terms":{"field":"attribute_pa_max-rotational-speed_es","size":1000}},"pa_max-stator-frequency-in-hz":{"terms":{"field":"attribute_pa_max-stator-frequency-in-hz_es","size":1000}},"pa_max-storage-in-kg-h2":{"terms":{"field":"attribute_pa_max-storage-in-kg-h2_es","size":1000}},"pa_max-stroke-rate-1-min":{"terms":{"field":"attribute_pa_max-stroke-rate-1-min_es","size":1000}},"pa_max-switching-frequency-hz":{"terms":{"field":"attribute_pa_max-switching-frequency-hz_es","size":1000}},"pa_max-system-capacity-l-h":{"terms":{"field":"attribute_pa_max-system-capacity-l-h_es","size":1000}},"pa_max-system-capacity-m³-h":{"terms":{"field":"attribute_pa_max-system-capacity-m³-h_es","size":1000}},"pa_max-t90-response-time-ms":{"terms":{"field":"attribute_pa_max-t90-response-time-ms_es","size":1000}},"pa_max-temperatur-in-c":{"terms":{"field":"attribute_pa_max-temperatur-in-c_es","size":1000}},"pa_max-volume-flow-in-lpm":{"terms":{"field":"attribute_pa_max-volume-flow-in-lpm_es","size":1000}},"pa_maximum-width":{"terms":{"field":"attribute_pa_maximum-width_es","size":1000}},"pa_mechanical-connectors":{"terms":{"field":"attribute_pa_mechanical-connectors_es.keyword","size":1000}},"pa_min-current-in-a":{"terms":{"field":"attribute_pa_min-current-in-a_es","size":1000}},"pa_min-dynamic-radial-load":{"terms":{"field":"attribute_pa_min-dynamic-radial-load_es","size":1000}},"pa_min-inlet-pressure-bar":{"terms":{"field":"attribute_pa_min-inlet-pressure-bar_es","size":1000}},"pa_min-inlet-temp-in-c":{"terms":{"field":"attribute_pa_min-inlet-temp-in-c_es","size":1000}},"pa_min-inner-diameter":{"terms":{"field":"attribute_pa_min-inner-diameter_es","size":1000}},"pa_min-input-voltage-in-v":{"terms":{"field":"attribute_pa_min-input-voltage-in-v_es","size":1000}},"pa_min-medium-temperature-in-c":{"terms":{"field":"attribute_pa_min-medium-temperature-in-c_es","size":1000}},"pa_min-number-of-fins-per-inch":{"terms":{"field":"attribute_pa_min-number-of-fins-per-inch_es","size":1000}},"pa_min-number-of-plates":{"terms":{"field":"attribute_pa_min-number-of-plates_es","size":1000}},"pa_min-outer-diameter":{"terms":{"field":"attribute_pa_min-outer-diameter_es","size":1000}},"pa_min-output-voltage-in-v":{"terms":{"field":"attribute_pa_min-output-voltage-in-v_es","size":1000}},"pa_min-power-in-kw":{"terms":{"field":"attribute_pa_min-power-in-kw_es","size":1000}},"pa_min-pressure-in-bar":{"terms":{"field":"attribute_pa_min-pressure-in-bar_es","size":1000}},"pa_min-static-radial-load":{"terms":{"field":"attribute_pa_min-static-radial-load_es","size":1000}},"pa_min-temperature-in-c":{"terms":{"field":"attribute_pa_min-temperature-in-c_es","size":1000}},"pa_min-volume-flow-in-lpm":{"terms":{"field":"attribute_pa_min-volume-flow-in-lpm_es","size":1000}},"pa_minimum-width":{"terms":{"field":"attribute_pa_minimum-width_es","size":1000}},"pa_nom-oper-pressure-in-bar":{"terms":{"field":"attribute_pa_nom-oper-pressure-in-bar_es","size":1000}},"pa_nom-operating-voltage-in-v":{"terms":{"field":"attribute_pa_nom-operating-voltage-in-v_es","size":1000}},"pa_nom-output-voltage-in-v":{"terms":{"field":"attribute_pa_nom-output-voltage-in-v_es","size":1000}},"pa_nom-power-kw":{"terms":{"field":"attribute_pa_nom-power-kw_es","size":1000}},"pa_nom-pressure-in-bar":{"terms":{"field":"attribute_pa_nom-pressure-in-bar_es","size":1000}},"pa_nom-sound-level-in-dba":{"terms":{"field":"attribute_pa_nom-sound-level-in-dba_es","size":1000}},"pa_nom-tank-pressure-in-bar":{"terms":{"field":"attribute_pa_nom-tank-pressure-in-bar_es","size":1000}},"pa_number-of-balls":{"terms":{"field":"attribute_pa_number-of-balls_es","size":1000}},"pa_number-of-fins-per-inch":{"terms":{"field":"attribute_pa_number-of-fins-per-inch_es","size":1000}},"pa_number-of-rollers":{"terms":{"field":"attribute_pa_number-of-rollers_es","size":1000}},"pa_on-tank-valve-included":{"terms":{"field":"attribute_pa_on-tank-valve-included_es.keyword","size":1000}},"pa_operating-efficiency-in":{"terms":{"field":"attribute_pa_operating-efficiency-in_es","size":1000}},"pa_power-at-max-load-in-kw":{"terms":{"field":"attribute_pa_power-at-max-load-in-kw_es","size":1000}},"pa_press-force-kn":{"terms":{"field":"attribute_pa_press-force-kn_es","size":1000}},"pa_pressure-drop-in-bar":{"terms":{"field":"attribute_pa_pressure-drop-in-bar_es","size":1000}},"pa_resistance-class":{"terms":{"field":"attribute_pa_resistance-class_es.keyword","size":1000}},"pa_static-radial-load-rating":{"terms":{"field":"attribute_pa_static-radial-load-rating_es","size":1000}},"pa_substances-detected":{"terms":{"field":"attribute_pa_substances-detected_es.keyword","size":1000}},"pa_tank-mount-type":{"terms":{"field":"attribute_pa_tank-mount-type_es.keyword","size":1000}},"pa_technology-readiness-trl":{"terms":{"field":"attribute_pa_technology-readiness-trl_es","size":1000}},"pa_thermal-efficiency":{"terms":{"field":"attribute_pa_thermal-efficiency_es","size":1000}},"pa_type-of-bearing":{"terms":{"field":"attribute_pa_type-of-bearing_es.keyword","size":1000}},"pa_type-of-cooling":{"terms":{"field":"attribute_pa_type-of-cooling_es.keyword","size":1000}},"pa_type-of-electrolyser":{"terms":{"field":"attribute_pa_type-of-electrolyser_es.keyword","size":1000}},"pa_type-of-heat-exchanger":{"terms":{"field":"attribute_pa_type-of-heat-exchanger_es.keyword","size":1000}},"pa_type-of-input-current":{"terms":{"field":"attribute_pa_type-of-input-current_es.keyword","size":1000}},"pa_type-of-press":{"terms":{"field":"attribute_pa_type-of-press_es.keyword","size":1000}},"pa_type-of-tank":{"terms":{"field":"attribute_pa_type-of-tank_es.keyword","size":1000}},"pa_volume-water-equival-in-l":{"terms":{"field":"attribute_pa_volume-water-equival-in-l_es","size":1000}},"pa_brand":{"terms":{"field":"attribute_pa_brand_es.keyword","size":1000}},"pa_weight":{"terms":{"field":"attribute_pa_weight_es","size":1000}},"pa_length":{"terms":{"field":"attribute_pa_length_es","size":1000}},"pa_width":{"terms":{"field":"attribute_pa_width_es","size":1000}},"pa_height":{"terms":{"field":"attribute_pa_height_es","size":1000}},"pa_max-pressure-drop-in-bar":{"terms":{"field":"attribute_pa_max-pressure-drop-in-bar_es","size":1000}},"pa_min-pressure-drop-in-bar":{"terms":{"field":"attribute_pa_min-pressure-drop-in-bar_es","size":1000}},"pa_h2-production-rate-in-ml-min":{"terms":{"field":"attribute_pa_h2-production-rate-in-ml-min_es","size":1000}},"pa_type-of-connection":{"terms":{"field":"attribute_pa_type-of-connection_es.keyword","size":1000}},"pa_thickness":{"terms":{"field":"attribute_pa_thickness_es","size":1000}},"pa-type-of-isolation":{"terms":{"field":"attribute_pa-type-of-isolation_es.keyword","size":1000}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 5
View formatted query   View cURL query   View query backtrace
2 3.10 ms 1.00 ms
{"query":{"function_score":{"score_mode":"max","boost_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["epowerlabs"]}}]}},"functions":[{"weight":0,"filter":{"bool":{"must":[{"match":{"has_price":1}}]}}},{"weight":110000,"filter":{"bool":{"must":[{"match":{"featured":1}},{"match":{"is_paying_vendor":1}},{"match":{"has_full_product_info":1}}]}}},{"weight":105000,"filter":{"bool":{"must":[{"match":{"is_paying_vendor":1}},{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"featured":1}}]}}},{"weight":102500,"filter":{"bool":{"must":[{"match":{"has_owner":1}},{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"is_paying_vendor":1}}]}}},{"weight":100000,"filter":{"bool":{"must":[{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"has_owner":1}},{"match":{"is_paying_vendor":1}}]}}},{"weight":10500,"filter":{"bool":{"must":[{"match":{"is_paying_vendor":1}}],"must_not":[{"match":{"has_full_product_info":1}},{"match":{"featured":1}}]}}},{"weight":10250,"filter":{"bool":{"must":[{"match":{"has_owner":1}}],"must_not":[{"match":{"has_full_product_info":1}},{"match":{"is_paying_vendor":1}}]}}},{"weight":10000,"filter":{"bool":{"must_not":[{"match":{"has_full_product_info":1}},{"match":{"has_owner":1}},{"match":{"is_paying_vendor":1}}]}}}]}},"size":0,"track_total_hits":true}
Path: bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 5
View formatted query   View cURL query   View query backtrace
3 3.65 ms 1.00 ms
{"query":{"function_score":{"score_mode":"max","boost_mode":"sum","query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["open_marketplace"]}},{"terms":{"vendor.keyword":["epowerlabs"]}}]}},"functions":[{"weight":0,"filter":{"bool":{"must":[{"match":{"has_price":1}}]}}},{"weight":110000,"filter":{"bool":{"must":[{"match":{"featured":1}},{"match":{"is_paying_vendor":1}},{"match":{"has_full_product_info":1}}]}}},{"weight":105000,"filter":{"bool":{"must":[{"match":{"is_paying_vendor":1}},{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"featured":1}}]}}},{"weight":102500,"filter":{"bool":{"must":[{"match":{"has_owner":1}},{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"is_paying_vendor":1}}]}}},{"weight":100000,"filter":{"bool":{"must":[{"match":{"has_full_product_info":1}}],"must_not":[{"match":{"has_owner":1}},{"match":{"is_paying_vendor":1}}]}}},{"weight":10500,"filter":{"bool":{"must":[{"match":{"is_paying_vendor":1}}],"must_not":[{"match":{"has_full_product_info":1}},{"match":{"featured":1}}]}}},{"weight":10250,"filter":{"bool":{"must":[{"match":{"has_owner":1}}],"must_not":[{"match":{"has_full_product_info":1}},{"match":{"is_paying_vendor":1}}]}}},{"weight":10000,"filter":{"bool":{"must_not":[{"match":{"has_full_product_info":1}},{"match":{"has_owner":1}},{"match":{"is_paying_vendor":1}}]}}}]}},"from":0,"size":24}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 5
View formatted query   View cURL query   View query backtrace