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 (14737, 14739, 25261, 25264, 25266)

Query time 0.00080

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "23.55"
    },
    "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": 19,
          "rows_produced_per_join": 19,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (14737,14739,25261,25264,25266))",
          "cost_info": {
            "read_cost": "7.91",
            "eval_cost": "1.90",
            "prefix_cost": "9.81",
            "data_read_per_join": "608"
          },
          "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": 19,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "11.85",
            "eval_cost": "1.90",
            "prefix_cost": "23.56",
            "data_read_per_join": "70K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14737_3d3778bfb338_22148-95305_h3wh-m9_9nvr-dv.webp 14737
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_a008f0a9404a_22146-96196_ncs9-r9_u496-f4.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_c1e5e21d9a59_22146-96194_2fiq-wd_h529-e9.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_ee422e954946_22146-96193_qq23-fn_yfmi-bk.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdd16d637513_IMG-20240730-WA0032_2re7-99_wq5p-24.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_f6ac12f4b3c1_IMG-20240730-WA0028_5er0-bs_ggu2-ij.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ee52d4fbbf81_IMG-20240730-WA0029_cw65-se_trym-j0.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_9c79d34e8ef8_IMG-20240730-WA0030_m1bq-i6_pvc7-62.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ea1c58afee5c_IMG-20240730-WA0033_fw1g-0q_812t-z1.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_62d74536e8e1_IMG-20240730-WA0034_a4bq-yq_b8q9-un.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdaa21a18a0b_IMG-20240730-WA0035_zrri-3x_x8zl-e0.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25264_00fcf69d4c7b_2024-09-06_14-13-40_u33d-37_6f04-vb.webp 25264
https://s3.timeweb.cloud/482029f9-prod/products__images/25264_41781488288b_2024-09-06_14-12-35_e4mr-mv_h7z0-ty.webp 25264
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_0abf1f06b51a_WhatsApp_Image_2024-03-28_at_17.34.40_000w-1o_mxd7-6g.webp 25266
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_929895cfe16d_WhatsApp_Image_2024-03-28_at_17.34.40__1__nqw2-ra_f42x-47.webp 25266
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_51b9fa614c23_WhatsApp_Image_2024-03-28_at_17.34.41_cgr3-z0_30gi-9w.webp 25266
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_670faddd73dc_WhatsApp_Image_2024-03-28_at_17.34.42__1__2y7y-1l_5wq6-t2.webp 25266
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_f0a29bd0fe24_WhatsApp_Image_2024-03-28_at_17.34.42_opsg-vp_z69t-nk.webp 25266
https://s3.timeweb.cloud/482029f9-prod/products__images/25266_a5550e31c839_WhatsApp_Image_2024-03-28_at_17.34.44_o6uy-zr_g7wh-25.webp 25266