{
"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": 9.840266228,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (18727,18750,18728,18729,18731,18733,18734,18735,18737,18736,18738,18739,20047,17986,17976,19106,19107,11456,11172,7613,7522,11230,10378,13102) and cscart_product_prices.usergroup_id in (0,1)"
}
}
]
}
}
}
}
| product_id | price |
|---|---|
| 7522 | 175.00000000 |
| 7613 | 175.00000000 |
| 10378 | 175.00000000 |
| 11172 | 175.00000000 |
| 11230 | 175.00000000 |
| 11456 | 135.00000000 |
| 13102 | 169.00000000 |
| 17976 | 175.00000000 |
| 17986 | 175.00000000 |
| 18727 | 130.00000000 |
| 18728 | 130.00000000 |
| 18729 | 130.00000000 |
| 18731 | 130.00000000 |
| 18733 | 130.00000000 |
| 18734 | 130.00000000 |
| 18735 | 130.00000000 |
| 18736 | 130.00000000 |
| 18737 | 130.00000000 |
| 18738 | 130.00000000 |
| 18739 | 130.00000000 |
| 18750 | 130.00000000 |
| 19106 | 169.00000000 |
| 19107 | 169.00000000 |
| 20047 | 130.00000000 |