{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "280.31"
},
"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": 200,
"rows_produced_per_join": 200,
"filtered": "100.00",
"cost_info": {
"read_cost": "240.31",
"eval_cost": "40.00",
"prefix_cost": "280.31",
"data_read_per_join": "12K"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` in (265000,40404,262379,265262,392209,339537,114747,271509,339493,265255,339524,339540,339536,339491,265241,114761,265230,339517,339522,339526,339520,285971,81644,265236,81606,81700,271508,265251,271499,224457,271501,339490,392218,265238,265240,392216,265253,392217,81601,366896,339741,381654,265243,265264,81687,339498,271507,339449,265233,32880,339528,224454,381657,81703,391799,265234,265257,381658,339497,339689,224455,265259,285967,81679,339448,265249,265252,339450,265260,359820,339435,392151,265239,285969,381656,339622,339442,381655,81666,339616,339443,152086,339436,170242,339574,259708,339523,339507,205875,339437,339504,339451,339512,265035,81683,139611,339740,339609,339500,339532)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
32880 | 0.00000000 |
40404 | 0.00000000 |
81601 | 0.00000000 |
81606 | 0.00000000 |
81644 | 0.00000000 |
81666 | 0.00000000 |
81679 | 0.00000000 |
81683 | 0.00000000 |
81687 | 0.00000000 |
81700 | 0.00000000 |
81703 | 0.00000000 |
114747 | 0.00000000 |
114761 | 0.00000000 |
139611 | 0.00000000 |
152086 | 0.00000000 |
170242 | 0.00000000 |
205875 | 0.00000000 |
224454 | 0.00000000 |
224455 | 0.00000000 |
224457 | 0.00000000 |
259708 | 24.85000000 |
262379 | 0.00000000 |
265000 | 0.00000000 |
265035 | 0.00000000 |
265230 | 80.00000000 |
265233 | 100.00000000 |
265234 | 100.00000000 |
265236 | 110.00000000 |
265238 | 100.00000000 |
265239 | 100.00000000 |
265240 | 100.00000000 |
265241 | 100.00000000 |
265243 | 120.00000000 |
265249 | 60.00000000 |
265251 | 70.00000000 |
265252 | 70.00000000 |
265253 | 70.00000000 |
265255 | 70.00000000 |
265257 | 80.00000000 |
265259 | 80.00000000 |
265260 | 80.00000000 |
265262 | 80.00000000 |
265264 | 80.00000000 |
271499 | 0.00000000 |
271501 | 0.00000000 |
271507 | 0.00000000 |
271508 | 0.00000000 |
271509 | 0.00000000 |
285967 | 0.00000000 |
285969 | 0.00000000 |
285971 | 0.00000000 |
339435 | 9.00000000 |
339436 | 47.00000000 |
339437 | 12.00000000 |
339442 | 26.00000000 |
339443 | 30.00000000 |
339448 | 6.00000000 |
339449 | 20.00000000 |
339450 | 26.00000000 |
339451 | 5.00000000 |
339490 | 70.00000000 |
339491 | 70.00000000 |
339493 | 140.00000000 |
339497 | 140.00000000 |
339498 | 175.00000000 |
339500 | 110.00000000 |
339504 | 85.00000000 |
339507 | 60.00000000 |
339512 | 180.00000000 |
339517 | 170.00000000 |
339520 | 90.00000000 |
339522 | 95.00000000 |
339523 | 110.00000000 |
339524 | 145.00000000 |
339526 | 130.00000000 |
339528 | 70.00000000 |
339532 | 65.00000000 |
339536 | 59.00000000 |
339537 | 70.00000000 |
339540 | 95.00000000 |
339574 | 45.00000000 |
339609 | 12.00000000 |
339616 | 45.00000000 |
339622 | 60.00000000 |
339689 | 25.00000000 |
339740 | 94.00000000 |
339741 | 27.50000000 |
359820 | 0.00000000 |
366896 | 0.00000000 |
381654 | 0.00000000 |
381655 | 0.00000000 |
381656 | 0.00000000 |
381657 | 0.00000000 |
381658 | 0.00000000 |
391799 | 0.00000000 |
392151 | 0.00000000 |
392209 | 0.00000000 |
392216 | 0.00000000 |
392217 | 0.00000000 |
392218 | 0.00000000 |