{
"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 (430799,430920,430946,431055,431234,431354,430671,430739,430786,431252,431424,431470,430679,431350,431368,430755,430793,431349,431186,431246,430683,430858,430877,431038,431406,430740,431411,430667,430882,430961,430867,430975,431149,431309,431360,430659,430764,430948,431010,431410,431457,431494,430642,430762,431340,431343,431376,431045,431211,431230,431405,431497,430792,431166,431182,431274,431284,430711,431341,431505,430735,430974,431047,431087,431279,431403,431495,430830,431152,431287,431290,431303,431381,430643,430814,430919,430965,431025,431231,431465,431474,430686,430734,430957,431324,430718,430934,431425,430754,430798,431004,431071,431329,431434,431015,431240,431260,431355,430765,431060)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
430642 | 11.50000000 |
430643 | 13.50000000 |
430659 | 31.50000000 |
430667 | 31.50000000 |
430671 | 31.50000000 |
430679 | 29.90000000 |
430683 | 29.90000000 |
430686 | 29.90000000 |
430711 | 29.90000000 |
430718 | 31.50000000 |
430734 | 31.50000000 |
430735 | 31.50000000 |
430739 | 31.50000000 |
430740 | 31.50000000 |
430754 | 31.50000000 |
430755 | 31.50000000 |
430762 | 34.50000000 |
430764 | 34.50000000 |
430765 | 34.50000000 |
430786 | 34.50000000 |
430792 | 34.50000000 |
430793 | 34.50000000 |
430798 | 34.50000000 |
430799 | 34.50000000 |
430814 | 34.50000000 |
430830 | 29.90000000 |
430858 | 29.90000000 |
430867 | 29.90000000 |
430877 | 29.90000000 |
430882 | 29.90000000 |
430919 | 26.90000000 |
430920 | 31.50000000 |
430934 | 31.50000000 |
430946 | 31.50000000 |
430948 | 31.50000000 |
430957 | 31.50000000 |
430961 | 31.50000000 |
430965 | 31.50000000 |
430974 | 31.50000000 |
430975 | 31.50000000 |
431004 | 31.50000000 |
431010 | 31.50000000 |
431015 | 31.50000000 |
431025 | 31.50000000 |
431038 | 29.90000000 |
431045 | 29.90000000 |
431047 | 29.90000000 |
431055 | 29.90000000 |
431060 | 29.90000000 |
431071 | 29.90000000 |
431087 | 28.50000000 |
431149 | 31.50000000 |
431152 | 31.50000000 |
431166 | 26.90000000 |
431182 | 26.90000000 |
431186 | 26.90000000 |
431211 | 29.90000000 |
431230 | 31.50000000 |
431231 | 31.50000000 |
431234 | 31.50000000 |
431240 | 31.50000000 |
431246 | 31.50000000 |
431252 | 36.50000000 |
431260 | 36.50000000 |
431274 | 36.50000000 |
431279 | 63.50000000 |
431284 | 36.50000000 |
431287 | 36.50000000 |
431290 | 36.50000000 |
431303 | 45.50000000 |
431309 | 45.50000000 |
431324 | 67.90000000 |
431329 | 67.90000000 |
431340 | 40.90000000 |
431341 | 40.90000000 |
431343 | 40.90000000 |
431349 | 40.90000000 |
431350 | 40.90000000 |
431354 | 40.90000000 |
431355 | 40.90000000 |
431360 | 49.90000000 |
431368 | 49.90000000 |
431376 | 45.50000000 |
431381 | 45.50000000 |
431403 | 49.90000000 |
431405 | 49.90000000 |
431406 | 49.90000000 |
431410 | 49.90000000 |
431411 | 49.90000000 |
431424 | 58.90000000 |
431425 | 58.90000000 |
431434 | 34.50000000 |
431457 | 29.90000000 |
431465 | 31.50000000 |
431470 | 31.50000000 |
431474 | 31.50000000 |
431494 | 34.50000000 |
431495 | 34.50000000 |
431497 | 34.50000000 |
431505 | 58.90000000 |