{
"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 (391789,265231,81619,285940,81632,271489,81662,339530,265039,265034,285937,271497,387095,81615,392212,285942,339446,271493,81639,271504,265258,81706,265031,339514,264987,265041,265261,265263,339551,271500,339521,286476,81649,264988,285945,271506,265244,265256,271496,271492,339501,151897,339499,285939,339495,339721,366887,392150,81622,392214,392215,265038,81652,271498,81697,339494,265242,339503,339531,224456,81693,339516,285938,81660,271510,359818,285943,271503,339539,285941,339447,339509,81669,271494,264989,285946,264990,271502,265232,265254,339636,285966,285970,114755,339637,339492,285968,339538,369244,271490,339506,265250,265001,265237,271505,339724,392179,339635,81628,339502)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
81615 | 0.00000000 |
81619 | 0.00000000 |
81622 | 0.00000000 |
81628 | 0.00000000 |
81632 | 0.00000000 |
81639 | 0.00000000 |
81649 | 0.00000000 |
81652 | 0.00000000 |
81660 | 0.00000000 |
81662 | 0.00000000 |
81669 | 0.00000000 |
81693 | 0.00000000 |
81697 | 0.00000000 |
81706 | 0.00000000 |
114755 | 0.00000000 |
151897 | 0.00000000 |
224456 | 0.00000000 |
264987 | 0.00000000 |
264988 | 0.00000000 |
264989 | 0.00000000 |
264990 | 0.00000000 |
265001 | 0.00000000 |
265031 | 0.00000000 |
265034 | 0.00000000 |
265038 | 0.00000000 |
265039 | 0.00000000 |
265041 | 0.00000000 |
265231 | 100.00000000 |
265232 | 100.00000000 |
265237 | 110.00000000 |
265242 | 120.00000000 |
265244 | 120.00000000 |
265250 | 70.00000000 |
265254 | 70.00000000 |
265256 | 70.00000000 |
265258 | 80.00000000 |
265261 | 80.00000000 |
265263 | 80.00000000 |
271489 | 0.00000000 |
271490 | 0.00000000 |
271492 | 0.00000000 |
271493 | 0.00000000 |
271494 | 0.00000000 |
271496 | 0.00000000 |
271497 | 0.00000000 |
271498 | 0.00000000 |
271500 | 0.00000000 |
271502 | 0.00000000 |
271503 | 0.00000000 |
271504 | 0.00000000 |
271505 | 0.00000000 |
271506 | 0.00000000 |
271510 | 0.00000000 |
285937 | 0.00000000 |
285938 | 0.00000000 |
285939 | 0.00000000 |
285940 | 0.00000000 |
285941 | 0.00000000 |
285942 | 0.00000000 |
285943 | 0.00000000 |
285945 | 0.00000000 |
285946 | 0.00000000 |
285966 | 0.00000000 |
285968 | 0.00000000 |
285970 | 0.00000000 |
286476 | 0.00000000 |
339446 | 36.00000000 |
339447 | 44.00000000 |
339492 | 85.00000000 |
339494 | 100.00000000 |
339495 | 65.00000000 |
339499 | 115.00000000 |
339501 | 85.00000000 |
339502 | 240.00000000 |
339503 | 75.00000000 |
339506 | 55.00000000 |
339509 | 60.00000000 |
339514 | 200.00000000 |
339516 | 295.00000000 |
339521 | 120.00000000 |
339530 | 65.00000000 |
339531 | 65.00000000 |
339538 | 55.00000000 |
339539 | 70.00000000 |
339551 | 110.00000000 |
339635 | 140.00000000 |
339636 | 235.00000000 |
339637 | 195.00000000 |
339721 | 170.00000000 |
339724 | 115.00000000 |
359818 | 0.00000000 |
366887 | 0.00000000 |
369244 | 19.90000000 |
387095 | 0.00000000 |
391789 | 0.00000000 |
392150 | 0.00000000 |
392179 | 239.00000000 |
392212 | 0.00000000 |
392214 | 0.00000000 |
392215 | 0.00000000 |