SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_features'
  ) 
WHERE 
  feature_id IN (
    178, 155, 177, 69, 84, 4, 28, 32, 12, 13, 
    20, 18, 45, 43, 17, 59, 58, 67, 92, 26, 
    90, 22, 19, 16, 50, 66, 126, 64, 65, 52, 
    34, 47, 75, 42, 56, 15, 3, 83, 38, 76, 49, 
    81, 44, 51, 70, 33, 61, 30, 54, 31, 14, 
    46, 29, 63, 60, 25, 136, 24, 9, 129, 36, 
    6, 135, 72, 1, 130, 78
  )

Query time 0.00073

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_features",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 93,
          "filtered": 72.04301453,
          "attached_condition": "cscart_product_features.feature_id in (178,155,177,69,84,4,28,32,12,13,20,18,45,43,17,59,58,67,92,26,90,22,19,16,50,66,126,64,65,52,34,47,75,42,56,15,3,83,38,76,49,81,44,51,70,33,61,30,54,31,14,46,29,63,60,25,136,24,9,129,36,6,135,72,1,130,78)"
        }
      },
      {
        "table": {
          "table_name": "cscart_ult_objects_sharing",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "159",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "ref": [
            "lillyshop_lillyshop.cscart_product_features.feature_id",
            "const",
            "const"
          ],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "cscart_ult_objects_sharing.share_object_id = cscart_product_features.feature_id and cscart_ult_objects_sharing.share_object_type = 'product_features'",
          "using_index": true
        }
      }
    ]
  }
}

Result

feature_id feature_type
1 M
3 M
4 M
6 S
9 M
12 M
13 M
14 M
15 M
16 M
17 M
18 S
19 S
20 S
22 M
24 M
25 M
26 M
28 S
29 S
30 S
31 S
32 S
33 S
34 S
36 S
38 S
42 S
43 M
44 S
45 M
46 S
47 M
49 M
50 S
51 S
52 M
54 M
56 M
58 M
59 M
60 M
61 M
63 M
64 M
65 M
66 M
67 M
69 E
70 M
177 S
72 M
75 S
76 M
78 M
178 S
81 S
83 M
84 S
90 S
92 S
126 M
129 M
130 M
135 S
136 M
155 M