{
"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 (430818,339755,430807,339483,339484,431068,431359,339697,430825,431053,431041,431085,339828,430868,430925,431013,431148,431156,431164,430654,430820,431049,381705,430658,430819,431144,339596,430691,430901,430989,430629,430746,430808,339774,430680,430812,430834,430843,431136,339765,431110,339728,339836,339843,431161,339725,339734,339816,431080,339655,339845,430673,430906,431118,339839,339599,430890,339466,430789,431082,339802,430657,430678,430737,430859,430922,431111,339702,339582,339723,430822,431126,430860,430921,339674,431044,430689,430795,430832,430892,339754,381704,430635,430838,430854,430914,339821,430663,431174,431456,430650,339486,430815,430959,430664,431169,339727,381697,430950,430672)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
339466 | 90.00000000 |
339483 | 8.00000000 |
339484 | 115.00000000 |
339486 | 23.00000000 |
339582 | 6.50000000 |
339596 | 10.00000000 |
339599 | 20.00000000 |
339655 | 18.00000000 |
339674 | 70.00000000 |
339697 | 15.00000000 |
339702 | 16.00000000 |
339723 | 9.00000000 |
339725 | 13.00000000 |
339727 | 11.00000000 |
339728 | 240.00000000 |
339734 | 35.00000000 |
339754 | 9.00000000 |
339755 | 9.00000000 |
339765 | 75.00000000 |
339774 | 8.00000000 |
339802 | 40.00000000 |
339816 | 75.00000000 |
339821 | 120.00000000 |
339828 | 16.00000000 |
339836 | 21.00000000 |
339839 | 39.00000000 |
339843 | 49.00000000 |
339845 | 112.00000000 |
381697 | 0.00000000 |
381704 | 0.00000000 |
381705 | 0.00000000 |
430629 | 25.50000000 |
430635 | 11.50000000 |
430650 | 13.50000000 |
430654 | 31.50000000 |
430657 | 31.50000000 |
430658 | 31.50000000 |
430663 | 31.50000000 |
430664 | 31.50000000 |
430672 | 31.50000000 |
430673 | 31.50000000 |
430678 | 29.90000000 |
430680 | 29.90000000 |
430689 | 29.90000000 |
430691 | 29.90000000 |
430737 | 31.50000000 |
430746 | 31.50000000 |
430789 | 34.50000000 |
430795 | 34.50000000 |
430807 | 34.50000000 |
430808 | 34.50000000 |
430812 | 34.50000000 |
430815 | 29.90000000 |
430818 | 29.90000000 |
430819 | 29.90000000 |
430820 | 29.90000000 |
430822 | 29.90000000 |
430825 | 29.90000000 |
430832 | 29.90000000 |
430834 | 29.90000000 |
430838 | 29.90000000 |
430843 | 29.90000000 |
430854 | 29.90000000 |
430859 | 29.90000000 |
430860 | 29.90000000 |
430868 | 29.90000000 |
430890 | 31.50000000 |
430892 | 31.50000000 |
430901 | 45.50000000 |
430906 | 45.50000000 |
430914 | 45.50000000 |
430921 | 31.50000000 |
430922 | 31.50000000 |
430925 | 31.50000000 |
430950 | 31.50000000 |
430959 | 31.50000000 |
430989 | 31.50000000 |
431013 | 31.50000000 |
431041 | 29.90000000 |
431044 | 29.90000000 |
431049 | 29.90000000 |
431053 | 29.90000000 |
431068 | 29.90000000 |
431080 | 26.50000000 |
431082 | 28.50000000 |
431085 | 28.50000000 |
431110 | 31.50000000 |
431111 | 31.50000000 |
431118 | 17.90000000 |
431126 | 17.90000000 |
431136 | 29.90000000 |
431144 | 29.90000000 |
431148 | 29.90000000 |
431156 | 31.50000000 |
431161 | 31.50000000 |
431164 | 26.90000000 |
431169 | 26.90000000 |
431174 | 26.90000000 |
431359 | 49.90000000 |
431456 | 29.90000000 |