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 (
    127, 2, 361, 156, 177, 197, 155, 196, 158, 
    360, 157, 117, 195, 193, 359, 178, 118, 
    194, 154, 176, 191, 186, 192, 120, 133, 
    179, 187, 185, 189, 168, 188, 123, 166, 
    125, 167, 126, 171, 172, 162, 122, 134, 
    163, 130, 164, 129, 174, 165, 121, 181, 
    159, 160, 170, 161, 148, 149, 135, 138, 
    137, 150, 151, 152, 139, 141, 140, 144, 
    145, 146, 147, 180, 142
  )

Query time 0.00109

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "27.29"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_ult_objects_sharing",
          "access_type": "index",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "key_length": "159",
          "rows_examined_per_scan": 252,
          "rows_produced_per_join": 2,
          "filtered": "1.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "26.16",
            "eval_cost": "0.25",
            "prefix_cost": "26.41",
            "data_read_per_join": "403"
          },
          "used_columns": [
            "share_company_id",
            "share_object_id",
            "share_object_type"
          ],
          "attached_condition": "((`unicomps`.`cscart_ult_objects_sharing`.`share_company_id` = 1) and (`unicomps`.`cscart_ult_objects_sharing`.`share_object_type` = 'product_features'))"
        }
      },
      {
        "table": {
          "table_name": "cscart_product_features",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id"
          ],
          "key_length": "3",
          "ref": [
            "unicomps.cscart_ult_objects_sharing.share_object_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 2,
          "filtered": "100.00",
          "index_condition": "((`unicomps`.`cscart_product_features`.`feature_id` in (127,2,361,156,177,197,155,196,158,360,157,117,195,193,359,178,118,194,154,176,191,186,192,120,133,179,187,185,189,168,188,123,166,125,167,126,171,172,162,122,134,163,130,164,129,174,165,121,181,159,160,170,161,148,149,135,138,137,150,151,152,139,141,140,144,145,146,147,180,142)) and (`unicomps`.`cscart_ult_objects_sharing`.`share_object_id` = `unicomps`.`cscart_product_features`.`feature_id`))",
          "cost_info": {
            "read_cost": "0.63",
            "eval_cost": "0.25",
            "prefix_cost": "27.29",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "feature_id",
            "feature_type"
          ]
        }
      }
    ]
  }
}

Result

feature_id feature_type
2 T
117 S
118 S
120 S
121 S
122 S
123 S
125 N
126 N
127 S
129 N
130 S
133 S
134 S
135 S
137 S
138 S
139 S
140 S
141 S
142 S
144 S
145 S
146 S
147 S
148 S
149 S
150 S
151 S
152 S
154 S
155 S
156 S
157 S
158 S
159 S
160 S
161 S
162 S
163 S
164 S
165 S
166 S
167 S
168 S
170 S
171 S
172 S
174 S
176 S
177 S
178 S
179 S
180 S
181 S
185 S
186 S
187 S
188 S
189 S
191 S
192 S
193 S
194 S
195 S
196 N
197 S
359 S
360 S
361 N