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"
          ]
        }
      }
    ]
  }
}