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 (28608, 28612, 32915, 8862, 14430)

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.21"
    },
    "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": 11,
          "rows_produced_per_join": 11,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (28608,28612,32915,8862,14430))",
          "cost_info": {
            "read_cost": "5.11",
            "eval_cost": "1.10",
            "prefix_cost": "6.21",
            "data_read_per_join": "352"
          },
          "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": 11,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "6.90",
            "eval_cost": "1.10",
            "prefix_cost": "14.21",
            "data_read_per_join": "40K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/8862_614695edc7a3_%D0%91%D0%BE%D1%80%D1%82%D0%BE%D0%B2%D0%BE%D0%B9_JAC_90_%D1%81_%D0%9A%D0%9C%D0%A3__1_.webp 8862
https://s3.timeweb.cloud/482029f9-prod/products__images/14430_e0fafde55d71_1_zyih-ap_t289-ti_s2g0-53.webp 14430
https://s3.timeweb.cloud/482029f9-prod/products__images/28608_67e478cfe2f0_28770_d49344c096f0_28608_e199bc0d8aab_28609_2592f84522b1_Dayun%25252520HKTC%252525205014.webp 28608
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_c31ba573549d_32296_df5f0fb04fa5_28612_7eed05562e23_28768_efc05b60f87c_28612_79ef3cc3d74c_28686_97862b6ee760_28612_a09c221f400c_28613_c3298377c2a6_0_b0e96978d57e_Dayun%252525252525252520XCMG%252525252525252520125-4.webp 28612
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_89a1e6ebf29c_32296_6a80cc7de21b_28612_3c7042ad9bd8_Dayun%252520XCMG%252520125-4-1.webp 28612
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_78371ae0a57e_33326_e9358ee90b01_32915_25933e72faa8_32916_81542b7d10e6_0_f985ff4b44d2_WhatsApp252520Image252520202 32915
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_b6e690957c3d_33326_ecc342971696_32915_ab9bd3137f2b_32916_22a1cedce9a9_0_201407a9d3df_WhatsApp252520Image252520202 32915
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_41a55d2b9a75_33326_415c1db09f94_32915_12d072d04f61_32916_af5717153a9a_0_3e6878e1eabd_WhatsApp252520Image252520202 32915
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_0ac14a425472_33326_14540e8eb565_32915_45be20cbf373_32916_263dae995bf2_0_6d959686f3c7_WhatsApp252520Image252520202 32915
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_aa66c1ade04b_33326_d75174559ebf_32915_d7230b638226_32916_75545d888414_0_8a68dcec0950_WhatsApp252520Image252520202 32915
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_8b1664a89230_33326_664b9811db25_32915_60aca029dee5_32916_6492f861ccd2_0_65bfeb8b49a7_WhatsApp252520Image252520202 32915