{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "56.00"
},
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": true,
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "lower_limit",
"used_key_parts": [
"lower_limit"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 235,
"rows_produced_per_join": 4,
"filtered": "1.89",
"index_condition": "(`satishecarter_march_003`.`cscart_product_prices`.`lower_limit` <=> 1)",
"cost_info": {
"read_cost": "9.00",
"eval_cost": "0.89",
"prefix_cost": "56.00",
"data_read_per_join": "106"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`satishecarter_march_003`.`cscart_product_prices`.`product_id` in (189,190,191,1,5,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,23,24,25,26)) and (`satishecarter_march_003`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
1 | 5399.99000000 |
5 | 899.99000000 |
7 | 55.00000000 |
8 | 849.99000000 |
9 | 999.99000000 |
10 | 1199.99000000 |
11 | 30.00000000 |
12 | 30.00000000 |
13 | 11.96000000 |
14 | 499.99000000 |
16 | 349.99000000 |
17 | 11.16000000 |
18 | 299.99000000 |
19 | 79.99000000 |
20 | 19.95000000 |
21 | 29.99000000 |
22 | 799.99000000 |
23 | 599.99000000 |
24 | 449.99000000 |
25 | 599.99000000 |
26 | 34.99000000 |
189 | 1.00000000 |
190 | 899.95000000 |
191 | 11.98000000 |