{
"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 (339707,392169,339656,430908,339769,339807,431115,431133,339829,339758,339677,339809,431050,339729,381702,431150,430747,431026,339648,431158,430681,339851,431195,339479,430748,339847,381696,431122,339654,339712,339746,430907,431102,430924,430998,387047,339704,339735,430648,339664,430696,431201,430771,339760,430916,339485,339817,430824,430915,339720,430636,430638,430823,431139,339812,430743,430857,430646,430813,430935,430803,431120,430821,339714,339835,430831,431145,431151,430665,339668,381698,339715,339761,430649,430751,387049,339671,339820,381699,430647,430848,431127,431109,430766,339694,339650,430903,339593,431114,430660,430817,431097,431163,431194,339849,431103,430902,430912,339755,430807)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
339479 | 10.50000000 |
339485 | 115.00000000 |
339593 | 8.00000000 |
339648 | 5.50000000 |
339650 | 35.00000000 |
339654 | 6.00000000 |
339656 | 22.00000000 |
339664 | 12.00000000 |
339668 | 28.00000000 |
339671 | 24.00000000 |
339677 | 27.00000000 |
339694 | 5.00000000 |
339704 | 46.00000000 |
339707 | 34.00000000 |
339712 | 7.00000000 |
339714 | 3.50000000 |
339715 | 6.50000000 |
339720 | 18.00000000 |
339729 | 35.00000000 |
339735 | 45.00000000 |
339746 | 98.00000000 |
339755 | 9.00000000 |
339758 | 80.00000000 |
339760 | 34.00000000 |
339761 | 70.00000000 |
339769 | 40.00000000 |
339807 | 34.00000000 |
339809 | 34.00000000 |
339812 | 100.00000000 |
339817 | 47.00000000 |
339820 | 245.00000000 |
339829 | 42.00000000 |
339835 | 42.00000000 |
339847 | 7.00000000 |
339849 | 40.00000000 |
339851 | 19.00000000 |
381696 | 0.00000000 |
381698 | 0.00000000 |
381699 | 0.00000000 |
381702 | 0.00000000 |
387047 | 0.00000000 |
387049 | 0.00000000 |
392169 | 129.00000000 |
430636 | 11.50000000 |
430638 | 11.50000000 |
430646 | 13.50000000 |
430647 | 13.50000000 |
430648 | 13.50000000 |
430649 | 13.50000000 |
430660 | 31.50000000 |
430665 | 31.50000000 |
430681 | 29.90000000 |
430696 | 29.90000000 |
430743 | 31.50000000 |
430747 | 31.50000000 |
430748 | 31.50000000 |
430751 | 31.50000000 |
430766 | 34.50000000 |
430771 | 34.50000000 |
430803 | 34.50000000 |
430807 | 34.50000000 |
430813 | 34.50000000 |
430817 | 29.90000000 |
430821 | 29.90000000 |
430823 | 29.90000000 |
430824 | 29.90000000 |
430831 | 29.90000000 |
430848 | 29.90000000 |
430857 | 29.90000000 |
430902 | 45.50000000 |
430903 | 45.50000000 |
430907 | 45.50000000 |
430908 | 45.50000000 |
430912 | 45.50000000 |
430915 | 45.50000000 |
430916 | 45.50000000 |
430924 | 31.50000000 |
430935 | 31.50000000 |
430998 | 31.50000000 |
431026 | 31.50000000 |
431050 | 29.90000000 |
431097 | 31.50000000 |
431102 | 31.50000000 |
431103 | 31.50000000 |
431109 | 31.50000000 |
431114 | 31.50000000 |
431115 | 31.50000000 |
431120 | 17.90000000 |
431122 | 17.90000000 |
431127 | 17.90000000 |
431133 | 17.90000000 |
431139 | 29.90000000 |
431145 | 29.90000000 |
431150 | 31.50000000 |
431151 | 31.50000000 |
431158 | 31.50000000 |
431163 | 31.50000000 |
431194 | 29.90000000 |
431195 | 29.90000000 |
431201 | 29.90000000 |