{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
"key": "product_id",
"key_length": "9",
"used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
"rowid_filter": {
"range": {
"key": "lower_limit",
"used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
},
"rows": 20,
"selectivity_pct": 0.005160158
},
"rows": 20,
"filtered": 100,
"index_condition": "cscart_product_prices.lower_limit = 1 and cscart_product_prices.product_id in (551390,552905,552783,552926,551876,552881,552606,552882,551536,551904) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
product_id | price |
---|---|
551390 | 105.130000 |
551536 | 84.530000 |
551876 | 71.580000 |
551904 | 108.750000 |
552606 | 106.940000 |
552783 | 78.660000 |
552881 | 74.310000 |
552882 | 70.690000 |
552905 | 94.250000 |
552926 | 77.350000 |