SELECT 
  status_id, 
  param, 
  value 
FROM 
  cscart_status_data 
WHERE 
  status_id IN (
    20, 6, 2, 5, 21, 4, 22, 26, 7, 24, 27, 28, 
    29, 3, 34, 30, 31, 32, 33, 19
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.04750489,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_status_data",
          "access_type": "index",
          "possible_keys": ["PRIMARY"],
          "key": "inventory",
          "key_length": "765",
          "used_key_parts": ["value"],
          "loops": 1,
          "rows": 162,
          "cost": 0.04750489,
          "filtered": 93.20987701,
          "attached_condition": "cscart_status_data.status_id in (20,6,2,5,21,4,22,26,7,24,27,28,29,3,34,30,31,32,33,19)",
          "using_index": true
        }
      }
    ]
  }
}

Result

status_id param value
21 color #000000
28 color #000000
29 color #00ff00
22 color #274e13
6 color #28abf6
24 color #38761d
31 color #4c1130
34 color #6aa84f
33 color #7f6000
32 color #85200c
26 color #93c47d
2 color #97cf4d
27 color #c27ba0
7 color #c2c2c2
19 color #cc4125
30 color #d9ead3
4 color #ff5215
5 color #ff5215
3 color #ff9522
2 gift_cert_status A
4 gift_cert_status C
5 gift_cert_status C
6 gift_cert_status C
7 gift_cert_status C
2 inventory D
3 inventory D
19 inventory D
20 appearance_type D
20 inventory D
21 appearance_type D
22 appearance_type D
24 appearance_type D
24 inventory D
26 appearance_type D
27 appearance_type D
28 appearance_type D
29 appearance_type D
30 appearance_type D
31 appearance_type D
32 appearance_type D
33 appearance_type D
34 inventory D
3 inventory_info default_decline_inventory_info
4 inventory I
5 inventory I
6 inventory I
7 inventory I
21 inventory I
22 inventory I
26 inventory I
27 inventory I
28 inventory I
29 inventory I
30 inventory I
31 inventory I
32 inventory I
33 inventory I
34 appearance_type I
2 repay N
3 allow_return N
3 is_editable_inventory N
3 repay N
4 allow_return N
4 calculate_for_payouts N
5 allow_return N
5 calculate_for_payouts N
6 allow_return N
6 calculate_for_payouts N
7 allow_return N
7 calculate_for_payouts N
20 allow_return N
20 repay N
21 calculate_for_payouts N
21 repay N
22 calculate_for_payouts N
22 repay N
24 calculate_for_payouts N
24 payment_received N
24 repay N
26 calculate_for_payouts N
26 payment_received N
26 repay N
27 calculate_for_payouts N
27 payment_received N
27 repay N
28 calculate_for_payouts N
28 payment_received N
28 repay N
29 calculate_for_payouts N
29 payment_received N
29 repay N
30 calculate_for_payouts N
30 payment_received N
30 repay N
31 calculate_for_payouts N
31 payment_received N
31 repay N
32 calculate_for_payouts N
32 payment_received N
32 repay N
33 calculate_for_payouts N
33 payment_received N
33 repay N
34 grant_reward_points N
34 repay N
3 gift_cert_status P
21 gift_cert_status P
22 gift_cert_status P
24 gift_cert_status P
26 gift_cert_status P
27 gift_cert_status P
28 gift_cert_status P
29 gift_cert_status P
30 gift_cert_status P
31 gift_cert_status P
32 gift_cert_status P
33 gift_cert_status P
34 gift_cert_status P
2 allow_return Y
2 calculate_for_payouts Y
2 grant_reward_points Y
2 payment_received Y
2 remove_cc_info Y
3 calculate_for_payouts Y
3 remove_cc_info Y
4 remove_cc_info Y
4 repay Y
5 remove_cc_info Y
5 repay Y
6 remove_cc_info Y
6 repay Y
7 remove_cc_info Y
7 repay Y
19 repay Y
20 remove_cc_info Y
21 payment_received Y
21 remove_cc_info Y
22 payment_received Y
22 remove_cc_info Y
24 remove_cc_info Y
26 remove_cc_info Y
27 remove_cc_info Y
28 remove_cc_info Y
29 remove_cc_info Y
30 remove_cc_info Y
31 remove_cc_info Y
32 remove_cc_info Y
33 remove_cc_info Y
34 calculate_for_payouts Y
34 payment_received Y
34 remove_cc_info Y