{
"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 (394196,114756,81595,265003,149755,264991,262367,286468,387085,265175,80451,262401,387100,387101,277549,286472,277552,265004,262376,265174,277550,286478,277548,387099,149820,81523,286465,277547,387097,387102,149750,286467,339527,264986,286475,391790,387103,286479,359819,286473,286469,391787,391791,31800,286466,435216,286470,391792,286471,277551,391739,286474,286,391740,262374,381645,359629,264695,262391,535,359628,381653,391793,381646,381643,391795,392213,225059,387091,391794,387043,264694,262397,264699,381647,391788,391797,381644,339513,391796,282476,151903,381642,81654,387038,339519,81637,282477,264697,264700,339510,339508,265002,339518,339713,339505,265235,339525,81590,262396)) and (`webmarco`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
286 | 0.00000000 |
535 | 0.00000000 |
31800 | 0.00000000 |
80451 | 0.00000000 |
81523 | 0.00000000 |
81590 | 0.00000000 |
81595 | 0.00000000 |
81637 | 0.00000000 |
81654 | 0.00000000 |
114756 | 0.00000000 |
149750 | 0.00000000 |
149755 | 0.00000000 |
149820 | 0.00000000 |
151903 | 0.00000000 |
225059 | 0.00000000 |
262367 | 0.00000000 |
262374 | 0.00000000 |
262376 | 0.00000000 |
262391 | 100.00000000 |
262396 | 0.00000000 |
262397 | 0.00000000 |
262401 | 0.00000000 |
264694 | 0.00000000 |
264695 | 0.00000000 |
264697 | 0.00000000 |
264699 | 0.00000000 |
264700 | 0.00000000 |
264986 | 0.00000000 |
264991 | 0.00000000 |
265002 | 0.00000000 |
265003 | 0.00000000 |
265004 | 0.00000000 |
265174 | 0.00000000 |
265175 | 0.00000000 |
265235 | 100.00000000 |
277547 | 0.00000000 |
277548 | 0.00000000 |
277549 | 0.00000000 |
277550 | 0.00000000 |
277551 | 0.00000000 |
277552 | 0.00000000 |
282476 | 0.00000000 |
282477 | 0.00000000 |
286465 | 0.00000000 |
286466 | 0.00000000 |
286467 | 0.00000000 |
286468 | 0.00000000 |
286469 | 0.00000000 |
286470 | 0.00000000 |
286471 | 0.00000000 |
286472 | 0.00000000 |
286473 | 0.00000000 |
286474 | 0.00000000 |
286475 | 0.00000000 |
286478 | 0.00000000 |
286479 | 0.00000000 |
339505 | 115.00000000 |
339508 | 150.00000000 |
339510 | 115.00000000 |
339513 | 190.00000000 |
339518 | 70.00000000 |
339519 | 85.00000000 |
339525 | 260.00000000 |
339527 | 145.00000000 |
339713 | 260.00000000 |
359628 | 0.00000000 |
359629 | 0.00000000 |
359819 | 0.00000000 |
381642 | 0.00000000 |
381643 | 0.00000000 |
381644 | 0.00000000 |
381645 | 0.00000000 |
381646 | 0.00000000 |
381647 | 0.00000000 |
381653 | 0.00000000 |
387038 | 0.00000000 |
387043 | 0.00000000 |
387085 | 0.00000000 |
387091 | 0.00000000 |
387097 | 0.00000000 |
387099 | 0.00000000 |
387100 | 0.00000000 |
387101 | 0.00000000 |
387102 | 0.00000000 |
387103 | 0.00000000 |
391739 | 0.00000000 |
391740 | 0.00000000 |
391787 | 0.00000000 |
391788 | 0.00000000 |
391790 | 0.00000000 |
391791 | 0.00000000 |
391792 | 0.00000000 |
391793 | 0.00000000 |
391794 | 0.00000000 |
391795 | 0.00000000 |
391796 | 0.00000000 |
391797 | 0.00000000 |
392213 | 0.00000000 |
394196 | 0.00000000 |
435216 | 149.00000000 |