{
"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 (4150,4151,4050,3930,4189,4037,4038,4039,4040,4025,4119,4126,4127,4072,4145,4146,4147,4060,3974,4041,4103,4148,4102,4366,4064,4062,4101,4063,4074,4075) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
3930 | 495.72000000 |
3974 | 162.18000000 |
4025 | 137.70000000 |
4037 | 430.44000000 |
4038 | 430.44000000 |
4039 | 430.44000000 |
4040 | 430.44000000 |
4041 | 1709.52000000 |
4050 | 648.72000000 |
4060 | 646.68000000 |
4062 | 939.42000000 |
4063 | 789.48000000 |
4064 | 1034.28000000 |
4072 | 118.32000000 |
4074 | 270.30000000 |
4075 | 270.30000000 |
4101 | 1573.86000000 |
4102 | 1089.36000000 |
4103 | 779.28000000 |
4119 | 302.94000000 |
4126 | 329.46000000 |
4127 | 329.46000000 |
4145 | 286.62000000 |
4146 | 191.76000000 |
4147 | 143.82000000 |
4148 | 835.38000000 |
4150 | 596.70000000 |
4151 | 596.70000000 |
4189 | 488.58000000 |
4366 | 1034.28000000 |