SELECT 
  product_id, 
  amount 
FROM 
  cscart_warehouses_destination_products_amount 
WHERE 
  product_id IN (
    4068, 4087, 3931, 4118, 4116, 4054, 4117, 
    4115, 4135, 3946, 3960, 3962, 3959, 
    4362, 3967, 3963, 3966, 3950, 4007, 
    4008, 4009, 4012, 4081, 4082, 4083, 
    4084, 4085, 3980, 3984, 3979
  ) 
  AND destination_id = 12 
  AND storefront_id = 0

Query time 0.00217

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.01"
    },
    "table": {
      "table_name": "cscart_warehouses_destination_products_amount",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "idx_storefront_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "destination_id",
        "storefront_id"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "((`dev_yourmart_co_bw`.`cscart_warehouses_destination_products_amount`.`storefront_id` = 0) and (`dev_yourmart_co_bw`.`cscart_warehouses_destination_products_amount`.`destination_id` = 12) and (`dev_yourmart_co_bw`.`cscart_warehouses_destination_products_amount`.`product_id` in (4068,4087,3931,4118,4116,4054,4117,4115,4135,3946,3960,3962,3959,4362,3967,3963,3966,3950,4007,4008,4009,4012,4081,4082,4083,4084,4085,3980,3984,3979)))",
      "cost_info": {
        "read_cost": "18.01",
        "eval_cost": "3.00",
        "prefix_cost": "21.01",
        "data_read_per_join": "480"
      },
      "used_columns": [
        "destination_id",
        "storefront_id",
        "product_id",
        "amount"
      ]
    }
  }
}