{
"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 (309474,309478,206988,391625,309476,391630,309469,391627,391629,262380,309470,252156,206990,206986,309475,309431,391628,206991,309472,252154,391631,339432,265269,206468,339433,262428,308644,206965,13481,13466,339434,339438,262429,206983,308657,206950,262440,262370,262437,206929,308646,339439,230172,259698,13488,206977,339445,13474,262430,252155,262436,262434,262432,13486,339440,206993,262441,173883,13468,262400,230173,339511,339515,206933,339441,13469,254299,13485,252159,13484,254297,252157,427782,253161,262359,225088,262438,253198,262435,253157,262439,81573,81586,225081,225074,35390,254305,159862,38238,13487,225053,262399,262394,252161,225066,262442,252162,287,81610,286682)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
287 | 0.00000000 |
13466 | 0.00000000 |
13468 | 0.00000000 |
13469 | 0.00000000 |
13474 | 0.00000000 |
13481 | 0.00000000 |
13484 | 0.00000000 |
13485 | 0.00000000 |
13486 | 0.00000000 |
13487 | 0.00000000 |
13488 | 0.00000000 |
35390 | 0.00000000 |
38238 | 0.00000000 |
81573 | 0.00000000 |
81586 | 0.00000000 |
81610 | 0.00000000 |
159862 | 0.00000000 |
173883 | 0.00000000 |
206468 | 0.00000000 |
206929 | 0.00000000 |
206933 | 20.00000000 |
206950 | 0.00000000 |
206965 | 0.00000000 |
206977 | 0.00000000 |
206983 | 0.00000000 |
206986 | 0.00000000 |
206988 | 0.00000000 |
206990 | 0.00000000 |
206991 | 0.00000000 |
206993 | 0.00000000 |
225053 | 0.00000000 |
225066 | 0.00000000 |
225074 | 0.00000000 |
225081 | 0.00000000 |
225088 | 0.00000000 |
230172 | 37.08000000 |
230173 | 53.55000000 |
252154 | 0.00000000 |
252155 | 0.00000000 |
252156 | 0.00000000 |
252157 | 0.00000000 |
252159 | 0.00000000 |
252161 | 0.00000000 |
252162 | 0.00000000 |
253157 | 0.00000000 |
253161 | 0.00000000 |
253198 | 0.00000000 |
254297 | 0.00000000 |
254299 | 0.00000000 |
254305 | 0.00000000 |
259698 | 16.57000000 |
262359 | 0.00000000 |
262370 | 0.00000000 |
262380 | 0.00000000 |
262394 | 0.00000000 |
262399 | 0.00000000 |
262400 | 0.00000000 |
262428 | 0.00000000 |
262429 | 0.00000000 |
262430 | 0.00000000 |
262432 | 0.00000000 |
262434 | 0.00000000 |
262435 | 0.00000000 |
262436 | 0.00000000 |
262437 | 0.00000000 |
262438 | 0.00000000 |
262439 | 0.00000000 |
262440 | 0.00000000 |
262441 | 0.00000000 |
262442 | 0.00000000 |
265269 | 0.00000000 |
286682 | 0.00000000 |
308644 | 15.00000000 |
308646 | 75.00000000 |
308657 | 55.00000000 |
309431 | 49.00000000 |
309469 | 0.00000000 |
309470 | 0.00000000 |
309472 | 0.00000000 |
309474 | 0.00000000 |
309475 | 0.00000000 |
309476 | 0.00000000 |
309478 | 0.00000000 |
339432 | 7.00000000 |
339433 | 26.00000000 |
339434 | 32.00000000 |
339438 | 46.00000000 |
339439 | 90.00000000 |
339440 | 95.00000000 |
339441 | 27.00000000 |
339445 | 10.00000000 |
339511 | 85.00000000 |
339515 | 230.00000000 |
391625 | 0.00000000 |
391627 | 0.00000000 |
391628 | 0.00000000 |
391629 | 0.00000000 |
391630 | 0.00000000 |
391631 | 0.00000000 |
427782 | 24.27000000 |