SELECT 
  status_id, 
  param, 
  value 
FROM 
  cscart_status_data 
WHERE 
  status_id IN (
    20, 6, 2, 5, 25, 4, 26, 27, 7, 28, 29, 30, 
    31, 3, 1, 32, 19
  )

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.09"
    },
    "table": {
      "table_name": "cscart_status_data",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "status_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 169,
      "rows_produced_per_join": 169,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "21.19",
        "eval_cost": "16.90",
        "prefix_cost": "38.09",
        "data_read_per_join": "253K"
      },
      "used_columns": [
        "status_id",
        "param",
        "value"
      ],
      "attached_condition": "(`shoptheindependents_com`.`cscart_status_data`.`status_id` in (20,6,2,5,25,4,26,27,7,28,29,30,31,3,1,32,19))"
    }
  }
}

Result

status_id param value
1 allow_return Y
1 appearance_type D
1 avatax_transaction_status Committed
1 calculate_for_payouts Y
1 color #97cf4d
1 gift_cert_status A
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 avatax_transaction_status Committed
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 payment_received Y
2 remove_cc_info Y
2 repay N
3 allow_return N
3 avatax_transaction_status Uncommitted
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 appearance_type D
4 avatax_transaction_status Voided
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 avatax_transaction_status Voided
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 avatax_transaction_status Uncommitted
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 avatax_transaction_status Voided
7 calculate_for_payouts N
7 color #c2c2c2
7 gift_cert_status C
7 inventory I
7 notify Y
7 remove_cc_info Y
7 repay Y
19 avatax_transaction_status Uncommitted
19 color #cc4125
19 inventory D
19 notify Y
19 notify_department Y
19 repay Y
20 allow_return N
20 appearance_type C
20 avatax_transaction_status Committed
20 calculate_for_payouts N
20 color #9900ff
20 gift_cert_status C
20 grant_reward_points N
20 inventory I
20 payment_received N
20 remove_cc_info Y
20 repay N
25 allow_return Y
25 appearance_type D
25 avatax_transaction_status Committed
25 calculate_for_payouts Y
25 color #3c78d8
25 gift_cert_status A
25 inventory D
25 payment_received Y
25 remove_cc_info Y
25 repay N
26 allow_return Y
26 appearance_type D
26 avatax_transaction_status Committed
26 calculate_for_payouts Y
26 color #6aa84f
26 gift_cert_status A
26 inventory D
26 payment_received Y
26 remove_cc_info Y
26 repay N
27 allow_return Y
27 appearance_type D
27 avatax_transaction_status Committed
27 calculate_for_payouts Y
27 color #6aa84f
27 gift_cert_status A
27 grant_reward_points N
27 inventory D
27 payment_received Y
27 remove_cc_info Y
27 repay N
28 allow_return N
28 appearance_type D
28 avatax_transaction_status Uncommitted
28 calculate_for_payouts Y
28 color #a64d79
28 gift_cert_status P
28 inventory D
28 payment_received Y
28 remove_cc_info Y
28 repay N
29 allow_return N
29 appearance_type D
29 avatax_transaction_status Uncommitted
29 calculate_for_payouts N
29 color #6aa84f
29 gift_cert_status A
29 inventory I
29 payment_received Y
29 remove_cc_info Y
29 repay N
30 allow_return Y
30 appearance_type D
30 avatax_transaction_status Committed
30 calculate_for_payouts Y
30 color #3d85c6
30 gift_cert_status A
30 inventory I
30 payment_received Y
30 remove_cc_info Y
30 repay N
31 allow_return Y
31 appearance_type D
31 calculate_for_payouts Y
31 color #8e7cc3
31 gift_cert_status A
31 inventory D
31 payment_received Y
31 remove_cc_info Y
31 repay N
32 allow_return Y
32 appearance_type D
32 calculate_for_payouts Y
32 color #6aa84f
32 gift_cert_status A
32 inventory D
32 payment_received Y
32 remove_cc_info Y
32 repay N