Sandbox

SELECT 
  status_id, 
  param, 
  value 
FROM 
  ushop_status_data 
WHERE 
  status_id IN (
    2, 22, 32, 1, 19, 3, 6, 4, 5, 7, 38, 37, 35, 
    36, 34, 33
  )

Query time 0.00127

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.51"
    },
    "table": {
      "table_name": "ushop_status_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 155,
      "rows_produced_per_join": 144,
      "filtered": "92.90",
      "cost_info": {
        "read_cost": "16.11",
        "eval_cost": "14.40",
        "prefix_cost": "30.51",
        "data_read_per_join": "216K"
      },
      "used_columns": [
        "status_id",
        "param",
        "value"
      ],
      "attached_condition": "(`marketplace`.`ushop_status_data`.`status_id` in (2,22,32,1,19,3,6,4,5,7,38,37,35,36,34,33))"
    }
  }
}

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	#6aa84f
5	color	#ff5215
4	color	#ff5215
7	color	#c2c2c2
3	color	#ff9522
1	color	#6aa84f
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
34	color	#000000
33	appearance_type	D
33	repay	N
33	calculate_for_payouts	N
33	inventory	I
33	payment_received	N
33	allow_return	N
2	appearance_type	D
33	remove_cc_info	Y
33	color	#000000
34	payment_received	N
34	inventory	I
33	gift_cert_status	P
34	remove_cc_info	Y
7	payment_received	N
7	appearance_type	D
6	payment_received	N
6	appearance_type	D
5	payment_received	N
5	appearance_type	D
4	payment_received	N
4	appearance_type	D
3	payment_received	N
3	appearance_type	D
1	appearance_type	D
22	color	#000000
22	inventory	I
22	payment_received	N
22	remove_cc_info	Y
22	repay	Y
22	appearance_type	D
22	calculate_for_payouts	N
22	gift_cert_status	P
22	grant_reward_points	Y
22	allow_return	N
35	color	#000000
34	gift_cert_status	P
34	calculate_for_payouts	N
34	appearance_type	D
34	repay	N
35	payment_received	N
35	inventory	I
34	allow_return	N
35	remove_cc_info	Y
32	gift_cert_status	C
32	inventory	I
32	payment_received	N
32	remove_cc_info	Y
32	appearance_type	D
32	repay	Y
32	calculate_for_payouts	N
32	color	#ff0000
32	allow_return	N
37	color	#000000
36	gift_cert_status	P
36	calculate_for_payouts	N
36	appearance_type	D
36	repay	N
37	payment_received	N
37	inventory	I
36	allow_return	N
37	remove_cc_info	Y
36	color	#000000
35	gift_cert_status	P
35	calculate_for_payouts	N
35	appearance_type	D
35	repay	N
36	payment_received	N
36	inventory	I
35	allow_return	N
36	remove_cc_info	Y
37	repay	N
37	appearance_type	D
37	calculate_for_payouts	N
37	gift_cert_status	P
37	allow_return	N
38	color	#000000
38	inventory	I
38	payment_received	N
38	remove_cc_info	Y
38	repay	N
38	appearance_type	D
38	calculate_for_payouts	N
38	gift_cert_status	P
38	allow_return	N