{
"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 (430726,431012,431056,431186,430793,430799,431392,430683,431034,431301,431354,431504,430877,430879,431166,431289,431334,430926,430946,431344,430659,430920,430997,431000,431020,431218,431244,431406,430706,430741,430864,431021,431291,431309,431322,431368,431487,430792,430858,430882,431248,431252,431280,339481,430761,430830,431230,431349,431429,431469,430919,430949,430975,431038,431101,431295,431303,431360,431376,431420,431464,430642,430740,431410,431424,430671,431470,430739,430867,430957,431047,431055,431060,431279,431474,430643,430679,431211,431341,431350,430735,430814,430948,431237,392168,431246,430734,430764,430798,431234,431287,430934,430982,431010,431149,431273,431324,430667,430718,430754)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
339481 | 7.00000000 |
392168 | 15.00000000 |
430642 | 11.50000000 |
430643 | 13.50000000 |
430659 | 31.50000000 |
430667 | 31.50000000 |
430671 | 31.50000000 |
430679 | 29.90000000 |
430683 | 29.90000000 |
430706 | 29.90000000 |
430718 | 31.50000000 |
430726 | 31.50000000 |
430734 | 31.50000000 |
430735 | 31.50000000 |
430739 | 31.50000000 |
430740 | 31.50000000 |
430741 | 31.50000000 |
430754 | 31.50000000 |
430761 | 34.50000000 |
430764 | 34.50000000 |
430792 | 34.50000000 |
430793 | 34.50000000 |
430798 | 34.50000000 |
430799 | 34.50000000 |
430814 | 34.50000000 |
430830 | 29.90000000 |
430858 | 29.90000000 |
430864 | 29.90000000 |
430867 | 29.90000000 |
430877 | 29.90000000 |
430879 | 29.90000000 |
430882 | 29.90000000 |
430919 | 26.90000000 |
430920 | 31.50000000 |
430926 | 31.50000000 |
430934 | 31.50000000 |
430946 | 31.50000000 |
430948 | 31.50000000 |
430949 | 31.50000000 |
430957 | 31.50000000 |
430975 | 31.50000000 |
430982 | 31.50000000 |
430997 | 31.50000000 |
431000 | 31.50000000 |
431010 | 31.50000000 |
431012 | 31.50000000 |
431020 | 31.50000000 |
431021 | 31.50000000 |
431034 | 31.50000000 |
431038 | 29.90000000 |
431047 | 29.90000000 |
431055 | 29.90000000 |
431056 | 29.90000000 |
431060 | 29.90000000 |
431101 | 31.50000000 |
431149 | 31.50000000 |
431166 | 26.90000000 |
431186 | 26.90000000 |
431211 | 29.90000000 |
431218 | 29.90000000 |
431230 | 31.50000000 |
431234 | 31.50000000 |
431237 | 31.50000000 |
431244 | 31.50000000 |
431246 | 31.50000000 |
431248 | 31.50000000 |
431252 | 36.50000000 |
431273 | 36.50000000 |
431279 | 63.50000000 |
431280 | 63.50000000 |
431287 | 36.50000000 |
431289 | 36.50000000 |
431291 | 36.50000000 |
431295 | 45.50000000 |
431301 | 45.50000000 |
431303 | 45.50000000 |
431309 | 45.50000000 |
431322 | 49.90000000 |
431324 | 67.90000000 |
431334 | 67.90000000 |
431341 | 40.90000000 |
431344 | 40.90000000 |
431349 | 40.90000000 |
431350 | 40.90000000 |
431354 | 40.90000000 |
431360 | 49.90000000 |
431368 | 49.90000000 |
431376 | 45.50000000 |
431392 | 49.90000000 |
431406 | 49.90000000 |
431410 | 49.90000000 |
431420 | 58.90000000 |
431424 | 58.90000000 |
431429 | 58.90000000 |
431464 | 31.50000000 |
431469 | 31.50000000 |
431470 | 31.50000000 |
431474 | 31.50000000 |
431487 | 34.50000000 |
431504 | 63.50000000 |