{
"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": 6.228672981,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (11917,11916,15106,15071,11664,2616,2615,2552,11121,2570,2617,2618,2703,2706,2708,2701,2329,12686,12687,11800,11801,2738,2739,2740,2737,2845,2643,12708,12707,2347) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2329 | 377.10000000 |
2347 | 375.54000000 |
2552 | 158.23000000 |
2570 | 96.58000000 |
2615 | 107.51000000 |
2616 | 96.72000000 |
2617 | 181.44000000 |
2618 | 96.72000000 |
2643 | 141.05000000 |
2701 | 121.20000000 |
2703 | 121.20000000 |
2706 | 101.33000000 |
2708 | 75.87000000 |
2737 | 102.90000000 |
2738 | 122.68000000 |
2739 | 109.92000000 |
2740 | 122.68000000 |
2845 | 82.62000000 |
11121 | 198.87000000 |
11664 | 175.39000000 |
11800 | 110.57000000 |
11801 | 122.68000000 |
11916 | 53.24000000 |
11917 | 207.28000000 |
12686 | 163.13000000 |
12687 | 197.53000000 |
12707 | 93.99000000 |
12708 | 93.99000000 |
15071 | 159.45000000 |
15106 | 39.86000000 |