{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "54.85"
},
"table": {
"table_name": "cscart_status_data",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 92,
"rows_produced_per_join": 80,
"filtered": "88.04",
"cost_info": {
"read_cost": "38.66",
"eval_cost": "16.20",
"prefix_cost": "54.86",
"data_read_per_join": "121K"
},
"used_columns": [
"status_id",
"param",
"value"
],
"attached_condition": "(`danishecarter_may_2024`.`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 |
2 | notify | Y |
4 | repay | Y |
6 | notify | 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 |
5 | notify | Y |
4 | gift_cert_status | C |
7 | notify | Y |
3 | gift_cert_status | P |
1 | gift_cert_status | P |
2 | inventory | D |
6 | inventory | I |
4 | notify | Y |
4 | inventory | I |
3 | notify | Y |
3 | inventory | D |
1 | notify | Y |
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 |
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 | notify | Y |
19 | notify_department | Y |
19 | repay | Y |
19 | inventory | D |
20 | color | #00ffff |
20 | inventory | I |
20 | payment_received | N |
20 | remove_cc_info | Y |
20 | repay | N |
20 | appearance_type | D |
20 | calculate_for_payouts | N |
20 | gift_cert_status | P |
20 | grant_reward_points | Y |
21 | color | #0000ff |
21 | inventory | I |
21 | payment_received | N |
21 | remove_cc_info | Y |
21 | repay | N |
21 | appearance_type | D |
21 | calculate_for_payouts | N |
21 | gift_cert_status | P |
21 | grant_reward_points | Y |