{
"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 (431132,339796,391798,339457,265042,339477,339541,431162,339700,339811,431202,339489,392172,431099,431128,339458,339623,339469,431155,430639,339453,339797,339798,339606,392167,431141,339699,339643,431130,431168,339482,339685,431153,431154,339730,431096,431137,339731,392175,339463,381703,339709,430637,431125,431124,339478,381725,339460,430911,339468,431094,431146,430640,431134,339467,430745,431048,431187,339753,431033,339810,339808,339696,430767,339805,431067,339757,339787,339701,339806,430697,431191,339794,431090,431117,339464,431065,431104,431107,431157,431116,381701,392166,381687,431204,339452,431196,431084,339752,339750,339695,339814,430655,430744,430850,431203,431160,431176,431100,339707)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
265042 | 0.00000000 |
339452 | 18.00000000 |
339453 | 23.00000000 |
339457 | 100.00000000 |
339458 | 100.00000000 |
339460 | 75.00000000 |
339463 | 95.00000000 |
339464 | 10.00000000 |
339467 | 95.00000000 |
339468 | 110.00000000 |
339469 | 85.00000000 |
339477 | 10.00000000 |
339478 | 48.00000000 |
339482 | 15.00000000 |
339489 | 22.00000000 |
339541 | 42.00000000 |
339606 | 6.00000000 |
339623 | 4.00000000 |
339643 | 19.00000000 |
339685 | 280.00000000 |
339695 | 22.00000000 |
339696 | 19.00000000 |
339699 | 70.00000000 |
339700 | 110.00000000 |
339701 | 85.00000000 |
339707 | 34.00000000 |
339709 | 50.00000000 |
339730 | 165.00000000 |
339731 | 200.00000000 |
339750 | 40.00000000 |
339752 | 36.00000000 |
339753 | 85.00000000 |
339757 | 140.00000000 |
339787 | 38.00000000 |
339794 | 70.00000000 |
339796 | 70.00000000 |
339797 | 72.00000000 |
339798 | 80.00000000 |
339805 | 40.00000000 |
339806 | 58.00000000 |
339808 | 59.00000000 |
339810 | 795.00000000 |
339811 | 75.00000000 |
339814 | 58.00000000 |
381687 | 0.00000000 |
381701 | 0.00000000 |
381703 | 0.00000000 |
381725 | 20.00000000 |
391798 | 0.00000000 |
392166 | 12.00000000 |
392167 | 7.00000000 |
392172 | 89.00000000 |
392175 | 109.00000000 |
430637 | 11.50000000 |
430639 | 11.50000000 |
430640 | 11.50000000 |
430655 | 31.50000000 |
430697 | 29.90000000 |
430744 | 31.50000000 |
430745 | 31.50000000 |
430767 | 34.50000000 |
430850 | 29.90000000 |
430911 | 45.50000000 |
431033 | 31.50000000 |
431048 | 29.90000000 |
431065 | 29.90000000 |
431067 | 29.90000000 |
431084 | 26.90000000 |
431090 | 31.50000000 |
431094 | 31.50000000 |
431096 | 31.50000000 |
431099 | 31.50000000 |
431100 | 31.50000000 |
431104 | 31.50000000 |
431107 | 31.50000000 |
431116 | 31.50000000 |
431117 | 31.50000000 |
431124 | 17.90000000 |
431125 | 17.90000000 |
431128 | 17.90000000 |
431130 | 17.90000000 |
431132 | 17.90000000 |
431134 | 29.90000000 |
431137 | 29.90000000 |
431141 | 29.90000000 |
431146 | 29.90000000 |
431153 | 31.50000000 |
431154 | 31.50000000 |
431155 | 31.50000000 |
431157 | 31.50000000 |
431160 | 31.50000000 |
431162 | 31.50000000 |
431168 | 26.90000000 |
431176 | 26.90000000 |
431187 | 26.90000000 |
431191 | 26.90000000 |
431196 | 29.90000000 |
431202 | 29.90000000 |
431203 | 29.90000000 |
431204 | 29.90000000 |