{
"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 (431037,431056,431262,431012,431186,431392,430793,430799,431034,431334,430683,431289,431301,431354,430877,430879,431166,431244,431344,430920,430926,430946,431000,430659,430706,430997,431020,431218,431291,431406,430741,430864,431021,431248,431309,431322,431368,431487,339481,431349,430761,430792,430858,430882,430949,431038,431101,431252,431280,431469,430830,431230,431376,431420,431429,430740,430919,430975,431295,431303,431360,431464,430642,430671,431410,431424,431470,431047,431055,431350,431474,430643,430739,430867,430957,430982,431060,431279,430679,430814,431211,431237,431341,430735,430948,431149,431246,392168,430798,430667,430734,430764,431234,431287,430934,431010,431273,431324,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 |
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 |
431037 | 29.90000000 |
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 |
431262 | 54.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 |