GET http://demo-sylius-elesto.antadis.net/en_US/taxons/categories/smart-agriculture/climate-sensors

Query Metrics

8 Database Queries
11.21 ms Execution Time
3.00 ms Query Time

Queries

# Execution Time Query Time Info
1 1.09 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["climate_sensors"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
2 3.16 ms 2.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["climate_sensors"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"protocol":{"terms":{"field":"attribute_protocol_en_US.keyword"}},"voltage":{"terms":{"field":"option_voltage.keyword"}},"module_type":{"terms":{"field":"attribute_module_type_en_US.keyword"}},"flight_time":{"terms":{"field":"attribute_flight_time_en_US.keyword"}},"camera_resolution":{"terms":{"field":"attribute_camera_resolution_en_US.keyword"}},"max_speed":{"terms":{"field":"attribute_max_speed_en_US.keyword"}},"weight":{"terms":{"field":"attribute_weight_en_US.keyword"}},"battery_type":{"terms":{"field":"attribute_battery_type_en_US.keyword"}},"control_range":{"terms":{"field":"attribute_control_range_en_US.keyword"}},"payload_capacity":{"terms":{"field":"attribute_payload_capacity_en_US.keyword"}},"dimensions":{"terms":{"field":"attribute_dimensions_en_US.keyword"}},"rayon-angle":{"terms":{"field":"attribute_rayon-angle_en_US.keyword"}},"revetement":{"terms":{"field":"attribute_revetement_en_US.keyword"}},"color_consolidated":{"terms":{"field":"option_color_consolidated.keyword"}},"power_consolidated":{"terms":{"field":"option_power_consolidated.keyword"}},"impedance_consolidated":{"terms":{"field":"option_impedance_consolidated.keyword"}},"single_board_computers_processor":{"terms":{"field":"option_single_board_computers_processor.keyword"}},"single_board_computers_ram":{"terms":{"field":"option_single_board_computers_ram.keyword"}},"antenna_consolidated":{"terms":{"field":"option_antenna_consolidated.keyword"}},"speed_consolidated":{"terms":{"field":"option_speed_consolidated.keyword"}},"efficiency_consolidated":{"terms":{"field":"option_efficiency_consolidated.keyword"}},"regulation_consolidated":{"terms":{"field":"option_regulation_consolidated.keyword"}},"capacity_consolidated":{"terms":{"field":"option_capacity_consolidated.keyword"}},"primary_consolidated":{"terms":{"field":"option_primary_consolidated.keyword"}},"secondary_consolidated":{"terms":{"field":"option_secondary_consolidated.keyword"}},"version_consolidated":{"terms":{"field":"option_version_consolidated.keyword"}},"data_consolidated":{"terms":{"field":"option_data_consolidated.keyword"}},"poles_consolidated":{"terms":{"field":"option_poles_consolidated.keyword"}},"mounting_consolidated":{"terms":{"field":"option_mounting_consolidated.keyword"}},"audio_xlr_pins":{"terms":{"field":"option_audio_xlr_pins.keyword"}},"audio_xlr_gender":{"terms":{"field":"option_audio_xlr_gender.keyword"}},"control_consolidated":{"terms":{"field":"option_control_consolidated.keyword"}},"contact_consolidated":{"terms":{"field":"option_contact_consolidated.keyword"}},"sensitivity_consolidated":{"terms":{"field":"option_sensitivity_consolidated.keyword"}},"wavelength_consolidated":{"terms":{"field":"option_wavelength_consolidated.keyword"}},"motion_sensor_pir_angle":{"terms":{"field":"option_motion_sensor_pir_angle.keyword"}},"finish_consolidated":{"terms":{"field":"option_finish_consolidated.keyword"}},"head_consolidated":{"terms":{"field":"option_head_consolidated.keyword"}},"features_consolidated":{"terms":{"field":"option_features_consolidated.keyword"}},"rpm_consolidated":{"terms":{"field":"option_rpm_consolidated.keyword"}},"diameter_consolidated":{"terms":{"field":"option_diameter_consolidated.keyword"}},"brand_consolidated":{"terms":{"field":"option_brand_consolidated.keyword"}},"iot_sensors_protocol":{"terms":{"field":"option_iot_sensors_protocol.keyword"}},"connectivity_consolidated":{"terms":{"field":"option_connectivity_consolidated.keyword"}},"accuracy_consolidated":{"terms":{"field":"option_accuracy_consolidated.keyword"}},"reach_consolidated":{"terms":{"field":"option_reach_consolidated.keyword"}},"payload_consolidated":{"terms":{"field":"option_payload_consolidated.keyword"}},"torque_consolidated":{"terms":{"field":"option_torque_consolidated.keyword"}},"nozzle_size_consolidated":{"terms":{"field":"option_nozzle_size_consolidated.keyword"}},"sensors_consolidated":{"terms":{"field":"option_sensors_consolidated.keyword"}},"components_consolidated":{"terms":{"field":"option_components_consolidated.keyword"}},"plc_basic_inputs":{"terms":{"field":"option_plc_basic_inputs.keyword"}},"plc_basic_outputs":{"terms":{"field":"option_plc_basic_outputs.keyword"}},"moisture_sensor_basic_output":{"terms":{"field":"option_moisture_sensor_basic_output.keyword"}},"calibration_consolidated":{"terms":{"field":"option_calibration_consolidated.keyword"}},"moisture_sensor_pro_interface":{"terms":{"field":"option_moisture_sensor_pro_interface.keyword"}},"temperature_consolidated":{"terms":{"field":"option_temperature_consolidated.keyword"}},"programs_consolidated":{"terms":{"field":"option_programs_consolidated.keyword"}},"controller_smart_valves":{"terms":{"field":"option_controller_smart_valves.keyword"}},"controller_weather_based_integration":{"terms":{"field":"option_controller_weather_based_integration.keyword"}},"flight_time_consolidated":{"terms":{"field":"option_flight_time_consolidated.keyword"}},"camera_consolidated":{"terms":{"field":"option_camera_consolidated.keyword"}},"fixed_wing_basic_wingspan":{"terms":{"field":"option_fixed_wing_basic_wingspan.keyword"}},"fixed_wing_pro_endurance":{"terms":{"field":"option_fixed_wing_pro_endurance.keyword"}},"fc_basic_gyro":{"terms":{"field":"option_fc_basic_gyro.keyword"}},"fc_basic_firmware":{"terms":{"field":"option_fc_basic_firmware.keyword"}},"fc_advanced_gnss":{"terms":{"field":"option_fc_advanced_gnss.keyword"}},"blades_consolidated":{"terms":{"field":"option_blades_consolidated.keyword"}},"quadcopter_cinematic_gimbal":{"terms":{"field":"option_quadcopter_cinematic_gimbal.keyword"}},"battery_consolidated":{"terms":{"field":"option_battery_consolidated.keyword"}},"robot_tank_terrain":{"terms":{"field":"option_robot_tank_terrain.keyword"}},"robot_explorer_autonomy":{"terms":{"field":"option_robot_explorer_autonomy.keyword"}},"thickness_consolidated":{"terms":{"field":"option_thickness_consolidated.keyword"}},"hardness_consolidated":{"terms":{"field":"option_hardness_consolidated.keyword"}},"level_consolidated":{"terms":{"field":"option_level_consolidated.keyword"}},"bore_consolidated":{"terms":{"field":"option_bore_consolidated.keyword"}},"stroke_consolidated":{"terms":{"field":"option_stroke_consolidated.keyword"}},"current":{"terms":{"field":"option_current.keyword"}},"resistance":{"terms":{"field":"option_resistance.keyword"}},"capacitance":{"terms":{"field":"option_capacitance.keyword"}},"frequency":{"terms":{"field":"option_frequency.keyword"}},"flash":{"terms":{"field":"option_flash.keyword"}},"tolerance":{"terms":{"field":"option_tolerance.keyword"}},"material":{"terms":{"field":"option_material.keyword"}},"type":{"terms":{"field":"option_type.keyword"}},"length":{"terms":{"field":"option_length.keyword"}},"isolation":{"terms":{"field":"option_isolation.keyword"}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
3 1.22 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["climate_sensors"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
4 1.19 ms 0.00 ms
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
5 0.93 ms 0.00 ms
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
6 0.84 ms 0.00 ms
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
7 1.04 ms 0.00 ms
{"query":{"match_all":{}},"size":1000}
Path: bitbag_taxon_tree_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 1
View formatted query   View cURL query   View query backtrace
8 1.73 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["COMM_MODULE_SHOP"]}},{"terms":{"product_taxons.keyword":["climate_sensors"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"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: 0
View formatted query   View cURL query   View query backtrace