{
"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": 48,
"selectivity_pct": 1.779095626
},
"rows": 48,
"filtered": 100,
"index_condition": "cscart_product_prices.lower_limit = 1 and cscart_product_prices.product_id in (65300,65301,65770,65460,65302,65417,65463,65298,65461,65426,65299,65465,65418,65423,65455,65453,65466,65564,65459,65469,65468,65479,65456,65457) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
| product_id | price |
|---|---|
| 65298 | 249.000000 |
| 65299 | 269.000000 |
| 65300 | 220.000000 |
| 65301 | 225.000000 |
| 65302 | 280.000000 |
| 65417 | 260.000000 |
| 65418 | 259.000000 |
| 65423 | 230.000000 |
| 65426 | 249.000000 |
| 65453 | 275.000000 |
| 65455 | 265.000000 |
| 65456 | 289.000000 |
| 65457 | 250.000000 |
| 65459 | 367.000000 |
| 65460 | 365.000000 |
| 65461 | 285.000000 |
| 65463 | 355.000000 |
| 65465 | 295.000000 |
| 65466 | 285.000000 |
| 65468 | 305.000000 |
| 65469 | 305.000000 |
| 65479 | 525.000000 |
| 65564 | 275.000000 |
| 65770 | 333.000000 |