{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "27.76"
},
"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": 40,
"rows_produced_per_join": 7,
"filtered": "20.00",
"index_condition": "(`cscartdb`.`cscart_product_prices`.`product_id` in (32019,9933,12034,12033,9918,27758,69929,38318,35227,34334,38426,31951,34347,34575,7471,32137,35450,32240,38330,38352,39033,35352,7523,37523,35334,7476,7420,35966,32011,32218,35691,32200,35735,70305,71343,71347,71884,72167,72174))",
"cost_info": {
"read_cost": "26.96",
"eval_cost": "0.80",
"prefix_cost": "27.76",
"data_read_per_join": "191"
},
"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 |
---|---|
7420 | 18.00000000 |
7471 | 16.50000000 |
7476 | 16.00000000 |
7523 | 15.50000000 |
9918 | 64.99000000 |
9933 | 59.99000000 |
12033 | 59.99000000 |
12034 | 59.99000000 |
27758 | 64.99000000 |
31951 | 85.00000000 |
32011 | 34.00000000 |
32019 | 22.00000000 |
32137 | 17.00000000 |
32200 | 36.00000000 |
32218 | 25.00000000 |
32240 | 85.00000000 |
34334 | 45.00000000 |
34347 | 45.00000000 |
34575 | 45.00000000 |
35227 | 17.95000000 |
35334 | 39.95000000 |
35352 | 13.95000000 |
35450 | 22.95000000 |
35691 | 23.95000000 |
35735 | 19.95000000 |
35966 | 13.95000000 |
37523 | 145.00000000 |
38318 | 80.00000000 |
38330 | 586.00000000 |
38352 | 100.00000000 |
38426 | 190.00000000 |
39033 | 145.00000000 |
69929 | 29.50000000 |
70305 | 15.00000000 |
71343 | 90.00000000 |
71347 | 28.00000000 |
71884 | 34.00000000 |
72167 | 55.00000000 |
72174 | 32.00000000 |