{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.01"
},
"grouping_operation": {
"using_filesort": false,
"table": {
"table_name": "q_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": 30,
"rows_produced_per_join": 5,
"filtered": "19.99",
"index_condition": "(`portal`.`q_product_prices`.`product_id` in (3570,3571,3572,3579,3586,3590,3591,3592,3593,3594,3595,3596,3597,3598,3599,3602,3603,3604,3605,3606,3607,3608,3610,3611,3612,3613,3614,3615,3616,3617))",
"cost_info": {
"read_cost": "70.81",
"eval_cost": "1.20",
"prefix_cost": "72.01",
"data_read_per_join": "143"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`portal`.`q_product_prices`.`lower_limit` = 1) and (`portal`.`q_product_prices`.`usergroup_id` in (0,1)))"
}
}
}
}
product_id | price |
---|---|
3570 | 16.000000 |
3571 | 19.000000 |
3572 | 15.000000 |
3579 | 19.000000 |
3586 | 14.000000 |
3590 | 14.000000 |
3591 | 22.000000 |
3592 | 21.000000 |
3593 | 34.000000 |
3594 | 12.000000 |
3595 | 26.000000 |
3596 | 11.000000 |
3597 | 16.000000 |
3598 | 11.000000 |
3599 | 14.000000 |
3602 | 49.000000 |
3603 | 49.000000 |
3604 | 49.000000 |
3605 | 49.000000 |
3606 | 49.000000 |
3607 | 99.000000 |
3608 | 99.000000 |
3610 | 19.000000 |
3611 | 26.000000 |
3612 | 39.000000 |
3613 | 44.000000 |
3614 | 19.000000 |
3615 | 24.000000 |
3616 | 26.000000 |
3617 | 19.000000 |