{
"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.041940212,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12669,12975,2299,2297,2298,2203,2566,3215,3214,11118,12685,13990,2340,11888,2339,2338,2180,2181,13661,15141,2228,2226,2227,2336,12743,2185,14298,15154,13222,15155) and cscart_product_prices.usergroup_id in (0,1)"
}
}
}
}
}
product_id | price |
---|---|
2180 | 485.28000000 |
2181 | 292.00000000 |
2185 | 359.94000000 |
2203 | 304.08000000 |
2226 | 554.34000000 |
2227 | 622.11000000 |
2228 | 765.96000000 |
2297 | 714.72000000 |
2298 | 744.52000000 |
2299 | 714.72000000 |
2336 | 441.00000000 |
2338 | 419.94000000 |
2339 | 434.88000000 |
2340 | 414.54000000 |
2566 | 87.75000000 |
3214 | 137.14000000 |
3215 | 138.47000000 |
11118 | 105.17000000 |
11888 | 861.90000000 |
12669 | 368.32000000 |
12685 | 107.47000000 |
12743 | 615.24000000 |
12975 | 75.55000000 |
13222 | 112.78000000 |
13661 | 605.65000000 |
13990 | 134.15000000 |
14298 | 105.25000000 |
15141 | 557.85000000 |
15154 | 219.60000000 |
15155 | 514.50000000 |