{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.51"
},
"table": {
"table_name": "cscart_status_data",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 74,
"rows_produced_per_join": 63,
"filtered": "85.14",
"cost_info": {
"read_cost": "31.91",
"eval_cost": "12.60",
"prefix_cost": "44.51",
"data_read_per_join": "94K"
},
"used_columns": [
"status_id",
"param",
"value"
],
"attached_condition": "(`pankajecarter_hunters`.`cscart_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 |
| 1 | appearance_type | D |
| 1 | grant_reward_points | N |
| 4 | payment_received | N |
| 4 | appearance_type | D |
| 4 | grant_reward_points | N |