{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "35.01"
},
"grouping_operation": {
"using_filesort": false,
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 50,
"rows_produced_per_join": 9,
"filtered": "20.00",
"index_condition": "(`cscartdb`.`cscart_product_prices`.`product_id` in (9982,9923,21325,32298,10997,32872,21326,31794,32348,11084,11049,11073,32345,13201,32341,13255,13203,13218,13200,32333,33025,13229,33810,13195,33014,6615,13205,33157,18220,18205,18198,18197,18216,11080,18210,60881,18219,18222,18212,18196,18217,33000,18202,18206,18224,18208,18201,36477,18203,18213))",
"cost_info": {
"read_cost": "34.01",
"eval_cost": "1.00",
"prefix_cost": "35.01",
"data_read_per_join": "239"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`cscartdb`.`cscart_product_prices`.`lower_limit` = 1) and (`cscartdb`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
6615 | 6.00000000 |
9923 | 14.99000000 |
9982 | 99.99000000 |
10997 | 10.00000000 |
11049 | 1.00000000 |
11073 | 10.00000000 |
11080 | 10.00000000 |
11084 | 5.00000000 |
13195 | 39.95000000 |
13200 | 39.90000000 |
13201 | 53.00000000 |
13203 | 39.90000000 |
13205 | 33.90000000 |
13218 | 34.50000000 |
13229 | 33.90000000 |
13255 | 49.95000000 |
18196 | 9.99000000 |
18197 | 9.99000000 |
18198 | 9.99000000 |
18201 | 9.99000000 |
18202 | 9.99000000 |
18203 | 9.99000000 |
18205 | 9.99000000 |
18206 | 9.99000000 |
18208 | 9.99000000 |
18210 | 9.99000000 |
18212 | 9.99000000 |
18213 | 9.99000000 |
18216 | 9.99000000 |
18217 | 9.99000000 |
18219 | 9.99000000 |
18220 | 4.99000000 |
18222 | 9.99000000 |
18224 | 9.99000000 |
21325 | 139.00000000 |
21326 | 139.00000000 |
31794 | 44.95000000 |
32298 | 49.95000000 |
32333 | 49.95000000 |
32341 | 49.95000000 |
32345 | 49.95000000 |
32348 | 49.95000000 |
32872 | 49.95000000 |
33000 | 49.95000000 |
33014 | 49.95000000 |
33025 | 49.95000000 |
33157 | 49.95000000 |
33810 | 25.00000000 |
36477 | 9.95000000 |
60881 | 8.99000000 |