Sandbox

SELECT 
  status_id, 
  param, 
  value 
FROM 
  netting_status_data 
WHERE 
  status_id IN (20, 1, 3, 4, 5, 6, 7, 19, 2, 21, 22)

Query time 0.00059

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "netting_status_data",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 102,
          "filtered": 90.19607544,
          "attached_condition": "netting_status_data.status_id in (20,1,3,4,5,6,7,19,2,21,22)"
        }
      }
    ]
  }
}

Result

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	inventory	D
20	remove_cc_info	Y
20	repay	N
20	appearance_type	D
20	allow_return	N
21	is_rf_rent	Y
21	color	#000000
21	inventory	I
21	payment_received	Y
21	remove_cc_info	N
21	repay	N
21	appearance_type	D
21	calculate_for_payouts	N
21	gift_cert_status	P
21	grant_reward_points	Y
22	is_rf_rent	Y
22	color	#000000
22	inventory	I
22	payment_received	N
22	remove_cc_info	N
22	repay	N
22	appearance_type	D
22	calculate_for_payouts	N
22	gift_cert_status	P
22	grant_reward_points	Y
1	avatax_transaction_status	Uncommitted
2	avatax_transaction_status	Committed
3	avatax_transaction_status	Uncommitted
4	avatax_transaction_status	Voided
5	avatax_transaction_status	Voided
6	avatax_transaction_status	Uncommitted
7	avatax_transaction_status	Voided
19	avatax_transaction_status	Uncommitted