{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"table": {
"table_name": "cscart_status_data",
"access_type": "ALL",
"possible_keys": ["PRIMARY"],
"rows": 81,
"filtered": 87.65431976,
"attached_condition": "cscart_status_data.status_id in (1,2,3,4,5,6,7,19,20,21)"
}
}
]
}
}
| 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 |
| 20 | color | #49afcd |
| 20 | inventory | D |
| 20 | remove_cc_info | N |
| 20 | repay | N |
| 20 | appearance_type | D |
| 21 | color | #ea9999 |
| 21 | inventory | I |
| 21 | remove_cc_info | N |
| 21 | repay | N |
| 21 | appearance_type | D |
| 1 | appearance_type | I |
| 1 | grant_reward_points | N |