{
"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.805454731,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12693,11795,2629,11122,2633,2655,11124,2653,2654,11123,2219,2572,2614,2613,15131,2786,2789,2790,11133,11809,2787,2784,2791,2785) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2219 | 580.74000000 |
2572 | 171.83000000 |
2613 | 68.37000000 |
2614 | 237.32000000 |
2629 | 79.56000000 |
2633 | 62.67000000 |
2653 | 97.05000000 |
2654 | 94.25000000 |
2655 | 86.38000000 |
2784 | 84.31000000 |
2785 | 76.64000000 |
2786 | 76.64000000 |
2787 | 98.28000000 |
2789 | 131.75000000 |
2790 | 76.64000000 |
2791 | 98.28000000 |
11122 | 94.25000000 |
11123 | 90.10000000 |
11124 | 94.00000000 |
11133 | 76.64000000 |
11795 | 87.23000000 |
11809 | 84.31000000 |
12693 | 98.73000000 |
15131 | 79.25000000 |