{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "33.41"
},
"grouping_operation": {
"using_filesort": false,
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 16,
"rows_produced_per_join": 3,
"filtered": "19.54",
"index_condition": "(`atulecarter_atul_demo1`.`cscart_product_prices`.`product_id` in (15,31,38,80,102,28,280,282,278,287,27))",
"cost_info": {
"read_cost": "32.78",
"eval_cost": "0.63",
"prefix_cost": "33.41",
"data_read_per_join": "75"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`cscart_product_prices`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`cscart_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
15 | 150.00000000 |
27 | 55.00000000 |
28 | 100.00000000 |
31 | 32.00000000 |
38 | 16.97000000 |
80 | 55.00000000 |
102 | 295.00000000 |
278 | 75.00000000 |
280 | 50.00000000 |
282 | 75.00000000 |
287 | 65.00000000 |