{
"query_block": {
"select_id": 1,
"cost": 0.026837545,
"nested_loop": [
{
"table": {
"table_name": "tmall_status_data",
"access_type": "ALL",
"possible_keys": ["PRIMARY"],
"loops": 1,
"rows": 69,
"cost": 0.026837545,
"filtered": 85.50724792,
"attached_condition": "tmall_status_data.status_id in (1,2,3,4,5,6,7,19)"
}
}
]
}
}
| status_id | param | value |
|---|---|---|
| 6 | allow_return | N |
| 2 | allow_return | Y |
| 7 | allow_return | N |
| 5 | allow_return | N |
| 5 | inventory | I |
| 4 | allow_return | N |
| 7 | inventory | I |
| 3 | allow_return | N |
| 1 | allow_return | N |
| 6 | repay | Y |
| 2 | repay | N |
| 7 | repay | Y |
| 5 | repay | Y |
| 4 | repay | Y |
| 3 | repay | N |
| 1 | repay | N |
| 6 | gift_cert_status | C |
| 7 | gift_cert_status | C |
| 2 | gift_cert_status | A |
| 5 | gift_cert_status | C |
| 4 | gift_cert_status | C |
| 3 | gift_cert_status | P |
| 1 | gift_cert_status | P |
| 2 | inventory | D |
| 6 | inventory | I |
| 4 | inventory | I |
| 3 | inventory | D |
| 1 | inventory | D |
| 6 | color | #28abf6 |
| 2 | color | #97cf4d |
| 5 | color | #ff5215 |
| 4 | color | #ff5215 |
| 7 | color | #c2c2c2 |
| 3 | color | #ff9522 |
| 1 | color | #97cf4d |
| 6 | remove_cc_info | Y |
| 7 | remove_cc_info | Y |
| 2 | remove_cc_info | Y |
| 5 | remove_cc_info | Y |
| 4 | remove_cc_info | Y |
| 3 | remove_cc_info | Y |
| 1 | remove_cc_info | Y |
| 1 | payment_received | Y |
| 2 | payment_received | Y |
| 1 | is_editable_inventory | N |
| 3 | is_editable_inventory | N |
| 1 | inventory_info | default_decline_inventory_info |
| 3 | inventory_info | default_decline_inventory_info |
| 6 | calculate_for_payouts | N |
| 7 | calculate_for_payouts | N |
| 2 | calculate_for_payouts | Y |
| 5 | calculate_for_payouts | N |
| 4 | calculate_for_payouts | N |
| 3 | calculate_for_payouts | Y |
| 1 | calculate_for_payouts | Y |
| 2 | grant_reward_points | Y |
| 19 | color | #cc4125 |
| 19 | repay | Y |
| 19 | inventory | D |