{
"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.525276184,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (2721,2202,2625,2678,2824,2776,2826,2775,2777,2823,13441,13762,11667,11666,11668,11665,13106,15112,13839,13838,13140,13828,12505,13829,13830,15426,2567,2557,2569,2556) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2202 | 728.43000000 |
2556 | 238.81000000 |
2557 | 190.71000000 |
2567 | 314.08000000 |
2569 | 166.20000000 |
2625 | 143.70000000 |
2678 | 93.18000000 |
2721 | 95.00000000 |
2775 | 106.28000000 |
2776 | 106.28000000 |
2777 | 107.45000000 |
2823 | 134.10000000 |
2824 | 116.15000000 |
2826 | 107.45000000 |
11665 | 239.96000000 |
11666 | 239.96000000 |
11667 | 239.96000000 |
11668 | 239.96000000 |
12505 | 239.96000000 |
13106 | 239.96000000 |
13140 | 239.96000000 |
13441 | 273.20000000 |
13762 | 239.96000000 |
13828 | 59.97000000 |
13829 | 59.97000000 |
13830 | 59.97000000 |
13838 | 59.97000000 |
13839 | 59.97000000 |
15112 | 160.86000000 |
15426 | 658.35000000 |