{
"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 (21145,21146,21147,21149,21150,21151,21152,21153,21154,21155,21156,21157,21158,21159,21160,21161,21162,21163,21164,21165,21166,21167,21168,21169) and cscart_product_prices.usergroup_id in (0,1)"
}
}
]
}
}
}
}
| product_id | price |
|---|---|
| 21145 | 170.00000000 |
| 21146 | 170.00000000 |
| 21147 | 170.00000000 |
| 21149 | 170.00000000 |
| 21150 | 170.00000000 |
| 21151 | 170.00000000 |
| 21152 | 170.00000000 |
| 21153 | 170.00000000 |
| 21154 | 170.00000000 |
| 21155 | 170.00000000 |
| 21156 | 170.00000000 |
| 21157 | 170.00000000 |
| 21158 | 170.00000000 |
| 21159 | 170.00000000 |
| 21160 | 170.00000000 |
| 21161 | 170.00000000 |
| 21162 | 170.00000000 |
| 21163 | 170.00000000 |
| 21164 | 170.00000000 |
| 21165 | 170.00000000 |
| 21166 | 170.00000000 |
| 21167 | 170.00000000 |
| 21168 | 170.00000000 |
| 21169 | 170.00000000 |