{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_product_prices.product_id",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "lower_limit",
"key_length": "3",
"used_key_parts": ["lower_limit"],
"ref": ["const"],
"rows": 11706,
"filtered": 11.0703001,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (21981,19965,21982,20033,21983,21057,21984,20398,22341,22345,22346,22347,22348,22349,20404,21593,20402,21594,20403,21595,20400,21596,20399,21597) and cscart_product_prices.usergroup_id in (0,1)"
}
}
]
}
}
}
}
| product_id | price |
|---|---|
| 19965 | 280.00000000 |
| 20033 | 280.00000000 |
| 20398 | 120.00000000 |
| 20399 | 275.00000000 |
| 20400 | 275.00000000 |
| 20402 | 275.00000000 |
| 20403 | 275.00000000 |
| 20404 | 275.00000000 |
| 21057 | 280.00000000 |
| 21593 | 450.00000000 |
| 21594 | 450.00000000 |
| 21595 | 450.00000000 |
| 21596 | 450.00000000 |
| 21597 | 450.00000000 |
| 21981 | 420.00000000 |
| 21982 | 420.00000000 |
| 21983 | 420.00000000 |
| 21984 | 420.00000000 |
| 22341 | 450.00000000 |
| 22345 | 450.00000000 |
| 22346 | 450.00000000 |
| 22347 | 450.00000000 |
| 22348 | 450.00000000 |
| 22349 | 450.00000000 |