{
"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": 12.30033302,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (21739,21740,21741,21742,21743,21744,21745,21746,23514,23894,23895,23896,23897,23898,23899,23900,23901,23902,19916,19918,22996,22039,22040,23285) and cscart_product_prices.usergroup_id in (0,1)"
}
}
]
}
}
}
}
| product_id | price |
|---|---|
| 19916 | 250.00000000 |
| 19918 | 250.00000000 |
| 21739 | 235.00000000 |
| 21740 | 235.00000000 |
| 21741 | 235.00000000 |
| 21742 | 235.00000000 |
| 21743 | 235.00000000 |
| 21744 | 235.00000000 |
| 21745 | 235.00000000 |
| 21746 | 235.00000000 |
| 22039 | 350.00000000 |
| 22040 | 350.00000000 |
| 22996 | 250.00000000 |
| 23285 | 150.00000000 |
| 23514 | 150.00000000 |
| 23894 | 320.00000000 |
| 23895 | 320.00000000 |
| 23896 | 320.00000000 |
| 23897 | 320.00000000 |
| 23898 | 320.00000000 |
| 23899 | 320.00000000 |
| 23900 | 320.00000000 |
| 23901 | 320.00000000 |
| 23902 | 320.00000000 |