{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "prices.lower_limit",
"table": {
"table_name": "prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"key_length": "9",
"used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
"rows": 2,
"filtered": 2.580079e-4,
"attached_condition": "prices.product_id = 219794 and prices.lower_limit > 1 and prices.usergroup_id in (0,0,1)"
}
}
}
}
}