{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "190.61"
},
"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": 136,
"rows_produced_per_join": 136,
"filtered": "100.00",
"cost_info": {
"read_cost": "163.42",
"eval_cost": "27.20",
"prefix_cost": "190.62",
"data_read_per_join": "8K"
},
"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 (269934,269946,269972,269928,269932,269930,269960,269961,269945,270059,269950,269937,269935,269933,269943,269941,270093,269981,269982,269962,269939,270136,270014,269926,270012,270097,269979,269980,269824,269936,270064,270065,270022,269927,269944,270016,269963,270021,270013,269942,269966,270088,270018,269925,269948,269929,269938,270137,270138,270020,269947,269958,269940,269931,269959,269978,269964,270132,270133,269983,270131,269965,270023,270134,270015,270087,270017,270057)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
269824 | 0.00000000 |
269925 | 190.00000000 |
269926 | 290.00000000 |
269927 | 220.00000000 |
269928 | 200.00000000 |
269929 | 190.00000000 |
269930 | 195.00000000 |
269931 | 200.00000000 |
269932 | 240.00000000 |
269933 | 205.00000000 |
269934 | 215.00000000 |
269935 | 430.00000000 |
269936 | 225.00000000 |
269937 | 220.00000000 |
269938 | 200.00000000 |
269939 | 200.00000000 |
269940 | 190.00000000 |
269941 | 200.00000000 |
269942 | 200.00000000 |
269943 | 220.00000000 |
269944 | 225.00000000 |
269945 | 220.00000000 |
269946 | 220.00000000 |
269947 | 230.00000000 |
269948 | 270.00000000 |
269950 | 260.00000000 |
269958 | 270.00000000 |
269959 | 240.00000000 |
269960 | 260.00000000 |
269961 | 340.00000000 |
269962 | 260.00000000 |
269963 | 260.00000000 |
269964 | 320.00000000 |
269965 | 270.00000000 |
269966 | 230.00000000 |
269972 | 360.00000000 |
269978 | 240.00000000 |
269979 | 250.00000000 |
269980 | 250.00000000 |
269981 | 240.00000000 |
269982 | 320.00000000 |
269983 | 320.00000000 |
270012 | 360.00000000 |
270013 | 270.00000000 |
270014 | 270.00000000 |
270015 | 350.00000000 |
270016 | 360.00000000 |
270017 | 320.00000000 |
270018 | 270.00000000 |
270020 | 210.00000000 |
270021 | 210.00000000 |
270022 | 160.00000000 |
270023 | 220.00000000 |
270057 | 210.00000000 |
270059 | 200.00000000 |
270064 | 250.00000000 |
270065 | 250.00000000 |
270087 | 180.00000000 |
270088 | 180.00000000 |
270093 | 200.00000000 |
270097 | 200.00000000 |
270131 | 210.00000000 |
270132 | 210.00000000 |
270133 | 180.00000000 |
270134 | 210.00000000 |
270136 | 180.00000000 |
270137 | 220.00000000 |
270138 | 200.00000000 |