{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "cscart_product_prices.product_id",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "lower_limit",
"key_length": "3",
"used_key_parts": ["lower_limit"],
"ref": ["const"],
"rows": 11706,
"filtered": 9.840266228,
"attached_condition": "cscart_product_prices.lower_limit <=> 1 and cscart_product_prices.product_id in (12797,12811,11568,11491,11061,12798,12812,12813,12814,12815,11221,11569,11570,11565,11571,11564,11573,11575,11576,11572,11566,11574,11567,9546) and cscart_product_prices.usergroup_id in (0,1)"
}
}
]
}
}
}
}
| product_id | price |
|---|---|
| 9546 | 95.00000000 |
| 11061 | 95.00000000 |
| 11221 | 95.00000000 |
| 11491 | 95.00000000 |
| 11564 | 95.00000000 |
| 11565 | 95.00000000 |
| 11566 | 95.00000000 |
| 11567 | 95.00000000 |
| 11568 | 95.00000000 |
| 11569 | 95.00000000 |
| 11570 | 95.00000000 |
| 11571 | 95.00000000 |
| 11572 | 95.00000000 |
| 11573 | 95.00000000 |
| 11574 | 95.00000000 |
| 11575 | 95.00000000 |
| 11576 | 95.00000000 |
| 12797 | 95.00000000 |
| 12798 | 95.00000000 |
| 12811 | 95.00000000 |
| 12812 | 95.00000000 |
| 12813 | 95.00000000 |
| 12814 | 95.00000000 |
| 12815 | 95.00000000 |