{
"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": 7.156754494,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12748,15130,2282,2723,15152,15153,2725,2728,2732,2729,2722,15126,2828,2714,2715,2716,2717,2713,2623,2622,15128,2724,2726,2727,2730,15151,15150,15423,3216,2718) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2282 | 104.41000000 |
2622 | 145.73000000 |
2623 | 177.93000000 |
2713 | 83.61000000 |
2714 | 84.16000000 |
2715 | 94.86000000 |
2716 | 75.34000000 |
2717 | 94.78000000 |
2718 | 154.63000000 |
2722 | 129.22000000 |
2723 | 86.38000000 |
2724 | 97.63000000 |
2725 | 125.65000000 |
2726 | 132.34000000 |
2727 | 97.63000000 |
2728 | 118.82000000 |
2729 | 125.65000000 |
2730 | 132.34000000 |
2732 | 98.02000000 |
2828 | 180.19000000 |
3216 | 123.43000000 |
12748 | 280.41000000 |
15126 | 87.80000000 |
15128 | 74.85000000 |
15130 | 75.80000000 |
15150 | 115.10000000 |
15151 | 115.10000000 |
15152 | 108.25000000 |
15153 | 155.50000000 |
15423 | 120.10000000 |