{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_product_prices.product_id",
"temporary_table": {
"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": 6449,
"filtered": 4.425132275,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (11912,11913,11904,11905,11915,11914,11917,11916,15106,15071,11664,2616,2615,2552,11121,2570,2617,2618,2703,2706,2708,2701,2329,12686) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2329 | 377.10000000 |
2552 | 158.23000000 |
2570 | 96.58000000 |
2615 | 107.51000000 |
2616 | 96.72000000 |
2617 | 181.44000000 |
2618 | 96.72000000 |
2701 | 121.20000000 |
2703 | 121.20000000 |
2706 | 101.33000000 |
2708 | 75.87000000 |
11121 | 198.87000000 |
11664 | 175.39000000 |
11904 | 207.28000000 |
11905 | 51.94000000 |
11912 | 207.28000000 |
11913 | 27.37000000 |
11914 | 52.65000000 |
11915 | 207.28000000 |
11916 | 53.24000000 |
11917 | 207.28000000 |
12686 | 163.13000000 |
15071 | 159.45000000 |
15106 | 39.86000000 |