{
"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.783926964,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12709,12644,2801,15148,3217,2265,2509,13837,2512,2574,2565,15388,12935,2621,11119,2560,2664,2684,2665,2663,2279,2514,2511,2513) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2265 | 249.90000000 |
2279 | 201.00000000 |
2509 | 88.92000000 |
2511 | 257.03000000 |
2512 | 205.60000000 |
2513 | 257.03000000 |
2514 | 257.03000000 |
2560 | 207.03000000 |
2565 | 295.72000000 |
2574 | 430.79000000 |
2621 | 232.05000000 |
2663 | 95.68000000 |
2664 | 118.23000000 |
2665 | 104.39000000 |
2684 | 93.99000000 |
2801 | 110.70000000 |
3217 | 122.98000000 |
11119 | 212.68000000 |
12644 | 338.76000000 |
12709 | 75.37000000 |
12935 | 203.45000000 |
13837 | 86.07000000 |
15148 | 201.70000000 |
15388 | 0.00000000 |