Sandbox

SELECT 
  status_id, 
  param, 
  value 
FROM 
  cscart_status_data 
WHERE 
  status_id IN (
    20, 6, 2, 5, 21, 4, 28, 32, 7, 34, 3, 1, 19
  )

Query time 0.00017

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_status_data",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["status_id"],
      "rows": 113,
      "filtered": 100,
      "attached_condition": "cscart_status_data.status_id in (20,6,2,5,21,4,28,32,7,34,3,1,19)"
    }
  }
}

Result

status_id	param	value
1	allow_return	N
1	calculate_for_payouts	Y
1	color	#97cf4d
1	gift_cert_status	P
1	inventory	D
1	inventory_info	default_decline_inventory_info
1	is_editable_inventory	N
1	notify	Y
1	payment_received	Y
1	remove_cc_info	Y
1	repay	N
2	allow_return	Y
2	appearance_type	D
2	calculate_for_payouts	Y
2	color	#97cf4d
2	gift_cert_status	A
2	grant_reward_points	Y
2	inventory	D
2	notify	Y
2	notify_supplier	N
2	payment_received	Y
2	remove_cc_info	Y
2	repay	N
3	allow_return	N
3	calculate_for_payouts	Y
3	color	#ff9522
3	gift_cert_status	P
3	inventory	D
3	inventory_info	default_decline_inventory_info
3	is_editable_inventory	N
3	notify	Y
3	remove_cc_info	Y
3	repay	N
4	allow_return	N
4	calculate_for_payouts	N
4	color	#ff5215
4	gift_cert_status	C
4	inventory	I
4	notify	Y
4	remove_cc_info	Y
4	repay	Y
5	allow_return	N
5	calculate_for_payouts	N
5	color	#ff5215
5	gift_cert_status	C
5	inventory	I
5	notify	Y
5	remove_cc_info	Y
5	repay	Y
6	allow_return	N
6	calculate_for_payouts	N
6	color	#28abf6
6	gift_cert_status	C
6	inventory	I
6	notify	Y
6	remove_cc_info	Y
6	repay	Y
7	allow_return	N
7	appearance_type	D
7	calculate_for_payouts	N
7	color	#c2c2c2
7	gift_cert_status	C
7	grant_reward_points	N
7	inventory	I
7	notify	Y
7	payment_received	N
7	remove_cc_info	Y
7	repay	Y
19	color	#cc4125
19	inventory	D
19	notify	Y
19	notify_department	Y
19	repay	Y
20	allow_return	N
20	appearance_type	D
20	inventory	D
20	notify	Y
20	notify_department	Y
20	remove_cc_info	Y
20	repay	N
21	allow_return	N
21	appearance_type	D
21	calculate_for_payouts	N
21	color	#f6b26b
21	grant_reward_points	Y
21	inventory	D
21	payment_received	N
21	remove_cc_info	Y
21	repay	N
28	allow_return	N
28	appearance_type	D
28	calculate_for_payouts	N
28	color	#000000
28	inventory	I
28	payment_received	N
28	remove_cc_info	Y
28	repay	N
32	allow_return	N
32	appearance_type	D
32	calculate_for_payouts	N
32	color	#000000
32	inventory	I
32	payment_received	N
32	remove_cc_info	Y
32	repay	N
34	allow_return	N
34	appearance_type	D
34	calculate_for_payouts	N
34	color	#38761d
34	inventory	D
34	payment_received	N
34	remove_cc_info	Y
34	repay	N