Sandbox

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

Query time 0.00227

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "51.41"
    },
    "table": {
      "table_name": "cscart_status_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 86,
      "rows_produced_per_join": 74,
      "filtered": "87.21",
      "cost_info": {
        "read_cost": "36.41",
        "eval_cost": "15.00",
        "prefix_cost": "51.41",
        "data_read_per_join": "112K"
      },
      "used_columns": [
        "status_id",
        "param",
        "value"
      ],
      "attached_condition": "(`db_emaika1`.`cscart_status_data`.`status_id` in (1,2,3,4,5,6,7,19,20,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	N
2	repay	N
7	repay	N
5	repay	N
2	notify	Y
4	repay	N
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
2	grant_reward_points	Y
19	color	#cc4125
19	notify	Y
19	notify_department	Y
19	repay	N
19	inventory	D
20	color	#49afcd
20	notify	Y
20	notify_department	N
20	inventory	D
20	remove_cc_info	N
20	repay	N
20	appearance_type	D
21	color	#ea9999
21	notify	Y
21	notify_department	N
21	inventory	I
21	remove_cc_info	N
21	repay	N
21	appearance_type	D
22	notify	Y
22	notify_department	Y
22	inventory	D
22	remove_cc_info	Y
22	repay	N
22	appearance_type	D
22	allow_return	N