{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "81.70"
},
"grouping_operation": {
"using_filesort": false,
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"rows_examined_per_scan": 72,
"rows_produced_per_join": 72,
"filtered": "100.00",
"cost_info": {
"read_cost": "74.50",
"eval_cost": "7.20",
"prefix_cost": "81.70",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`maniamall_cscart`.`cscart_product_prices`.`lower_limit` = 1) and (`maniamall_cscart`.`cscart_product_prices`.`product_id` in (1732000,1661266,1731933,1658668,1658805,2539827,1661450,1658400,1661340,2072334,1659066,1163013,1663387,2253671,1659620,1658630,1659207,1658657,1657931,1661143,1732317,1664148,1732319,1657915,1659840,1658338,1658635,1658606,1658866,1658169,1660818,1659802,1659293,1660499,1658645,1661096)) and (`maniamall_cscart`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
| product_id | price |
|---|---|
| 1163013 | 25.790000 |
| 1657915 | 43.200000 |
| 1657931 | 125.090000 |
| 1658169 | 44.890000 |
| 1658338 | 36.140000 |
| 1658400 | 9.640000 |
| 1658606 | 6.640000 |
| 1658630 | 13.250000 |
| 1658635 | 35.940000 |
| 1658645 | 100.000000 |
| 1658657 | 83.080000 |
| 1658668 | 29.390000 |
| 1658805 | 78.200000 |
| 1658866 | 87.460000 |
| 1659066 | 42.560000 |
| 1659207 | 25.650000 |
| 1659293 | 96.310000 |
| 1659620 | 20.700000 |
| 1659802 | 17.110000 |
| 1659840 | 45.810000 |
| 1660499 | 113.560000 |
| 1660818 | 175.310000 |
| 1661096 | 1154.680000 |
| 1661143 | 61.800000 |
| 1661266 | 37.440000 |
| 1661340 | 76.980000 |
| 1661450 | 181.930000 |
| 1663387 | 17.980000 |
| 1664148 | 213.810000 |
| 1731933 | 316.250000 |
| 1732000 | 308.130000 |
| 1732317 | 201.250000 |
| 1732319 | 201.250000 |
| 2072334 | 24.990000 |
| 2253671 | 174.990000 |
| 2539827 | 18.740000 |