{
"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.305534363,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12731,12725,12727,12724,10923,10920,10922,12730,10918,10916,10919,10833,10837,10835,10836,10834,10819,10827,10829,10830,10832,10828,12726,12732,12598,12599,12601,12603,12600,12602) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
10819 | 7798.93000000 |
10827 | 3988.47000000 |
10828 | 4469.32000000 |
10829 | 4040.46000000 |
10830 | 3598.60000000 |
10832 | 5275.08000000 |
10833 | 12624.43000000 |
10834 | 7278.00000000 |
10835 | 8018.27000000 |
10836 | 8169.07000000 |
10837 | 12007.53000000 |
10916 | 947.41000000 |
10918 | 1233.32000000 |
10919 | 869.43000000 |
10920 | 1430.00000000 |
10922 | 1857.13000000 |
10923 | 2247.01000000 |
12598 | 9934.80000000 |
12599 | 7702.02000000 |
12600 | 3687.30000000 |
12601 | 3519.00000000 |
12602 | 3600.60000000 |
12603 | 2779.50000000 |
12724 | 6652.65000000 |
12725 | 13449.56000000 |
12726 | 4755.24000000 |
12727 | 7822.29000000 |
12730 | 1698.51000000 |
12731 | 4729.25000000 |
12732 | 4820.22000000 |