SELECT 
  `F`.`path`, 
  `PI`.`product_id`, 
  `PI`.`alt` 
FROM 
  `cscart_products__images` AS `PI` 
  LEFT JOIN `files` AS `F` ON `PI`.`watermark_small_file_id` = `F`.`id` 
WHERE 
  `PI`.`product_id` IN ('14714', '9184', '28163')

Query time 0.00039

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.18"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "PI",
          "access_type": "range",
          "possible_keys": [
            "product_id"
          ],
          "key": "product_id",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "rows_examined_per_scan": 8,
          "rows_produced_per_join": 8,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('14714','9184','28163'))",
          "cost_info": {
            "read_cost": "3.56",
            "eval_cost": "0.80",
            "prefix_cost": "4.36",
            "data_read_per_join": "256"
          },
          "used_columns": [
            "product_id",
            "watermark_small_file_id",
            "alt"
          ]
        }
      },
      {
        "table": {
          "table_name": "F",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "id"
          ],
          "key_length": "4",
          "ref": [
            "dev2.PI.watermark_small_file_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 8,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "5.02",
            "eval_cost": "0.80",
            "prefix_cost": "10.18",
            "data_read_per_join": "29K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/9184_0ec76b4d7173_%D0%B2%D0%B0%D1%85%D1%82%D0%BE%D0%B2%D1%8B%D0%B9_%D0%B0%D0%B2%D1%82%D0%BE%D0%B1%D1%83%D1%81_%D0%BD%D0%B5%D1%84%D0%B0%D0%B7_%D0%BA%D0%B0%D0%BC%D0%B0%D0%B7.webp 9184
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_f9245866ab27_22165-95629_ro85-af_ohvx-8z.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_a759449e56ec_12206-95640_70sq-bb.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_b111f79cb544_12206-95639_s4sv-qy.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_8f43fe307e53_28259_b98329b8398d_28163_a0f8ffeaa34d_28218_ac48cc128e2c_28163_3470eff326b6_28164_49f8ae147078_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B2%2525252525202.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_09044fb900fc_28259_e0f04ecb79b3_28163_da560cde9d77_28218_a63c34e96f9b_28163_25f53c172c13_28164_e7baefebc79e_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B2%2525252525203.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_46ecd6642381_28259_1dec18084450_28163_52dedac0abf0_28218_12c57c029b2b_28163_7e157c1f3b38_28164_9cc3a7557443_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B21.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_c0300afdd7e1_28259_3b24ea45cd7e_28163_781d2aef5cfc_28218_4f2d5c88b33f_28163_005d671d02aa_28164_c73937b01d91_%2525252525D0%25252525259A%2525252525D0%2525252525B0%2525252525D0%2525252525B1%2525252525D0%2525252525B8%2525252525D0%2525252525BD%2525252525D0%2525252525B0.webp 28163