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 (14693, 27392, 27394, 32429, 32436)

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "35.32"
    },
    "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": 29,
          "rows_produced_per_join": 29,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (14693,27392,27394,32429,32436))",
          "cost_info": {
            "read_cost": "11.41",
            "eval_cost": "2.90",
            "prefix_cost": "14.31",
            "data_read_per_join": "928"
          },
          "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": 29,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "18.11",
            "eval_cost": "2.90",
            "prefix_cost": "35.32",
            "data_read_per_join": "108K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14693_6fe4ee0dccda_IMG-20231219-WA0017_k73i-i1_86n0-4i.webp 14693
https://s3.timeweb.cloud/482029f9-prod/products__images/14693_eb868790b1c8_IMG-20231219-WA0019_miqj-uk_75dx-x7.webp 14693
https://s3.timeweb.cloud/482029f9-prod/products__images/14693_84a918075887_IMG-20231219-WA0023_key8-wl_2xx7-el.webp 14693
https://s3.timeweb.cloud/482029f9-prod/products__images/14693_eb91851b4323_photo_2023-12-05_15-21-33_8dsb-xk_aft0-u2.webp 14693
https://s3.timeweb.cloud/482029f9-prod/products__images/14693_534cdd1eba14_photo_2023-12-05_15-21-23_ffs0-30_uv5w-t0.webp 14693
https://s3.timeweb.cloud/482029f9-prod/products__images/27392_b47f8b9edaad_1lmse8s56y4fmb3qhbkjs7ufz4v866j2_g6kz-ku_7pj0-oj_4clz-dd.webp 27392
https://s3.timeweb.cloud/482029f9-prod/products__images/27392_16352cccc72a_0qtgq2sfg33szmwovxbyviparvgen4t9_eqh7-jg_21ut-y2_6d6o-53.webp 27392
https://s3.timeweb.cloud/482029f9-prod/products__images/27392_0f8b01954a89_85k2i020xb6io94228ms2fkd7run8nn7_z5u4-ko_8bto-44_ouur-ga.webp 27392
https://s3.timeweb.cloud/482029f9-prod/products__images/27392_a6219ec3c63a_h4o4ww2wxmes7bo0fh1oobtd7jth7rjs_xrrk-2g_789o-wf_mq3f-00.webp 27392
https://s3.timeweb.cloud/482029f9-prod/products__images/27394_34e5245ca949_kp5igcke2973xxck8jbpqcuhrm55t5i7_9czf-6h_wmuh-ur_vlmv-17_wtwt-l8_i0of-xr.webp 27394
https://s3.timeweb.cloud/482029f9-prod/products__images/27394_8c6a1b376fa8_42i2290td35z603eigtvfgyeirdmr40u_vd3g-gx_ctor-8k_cmzf-bf_70cd-od_i0tj-d3.webp 27394
https://s3.timeweb.cloud/482029f9-prod/products__images/27394_ae0bffb0138b_j41mgr68439275tosjb6ew6hv5hilwwn_k4ca-0o_4asz-od_3un6-7b_c6zj-jp_dzq4-fu.webp 27394
https://s3.timeweb.cloud/482029f9-prod/products__images/27394_fea6d3967e4f_jspcblw9b12d3mui91lbb4x8xzhaea1k_d1g7-a1_1fqg-v1_gdj9-cy_em6q-08_wxav-22.webp 27394
https://s3.timeweb.cloud/482029f9-prod/products__images/27394_f1864f34556b_qftp5hzds5jg7q6bheuwcg68fqoqmrfl_co5z-rf_1vg3-6s_i7ei-cg_w1hw-py_47a2-9i.webp 27394
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_8795b454afee_33034_11534f857252_32429_8082cbe9bb75_32430_f4fa6992d541_0_bef9676081cd_c9b4576b-bd22-421b-989b-335d 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_808456d5cbab_33034_f370de03fcff_32429_b6816b74d088_32430_b5a716619000_0_03f53e4a04eb_e666e5d1-d1ac-4fa3-a76f-f1d6 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_695d0bbc6f3f_33034_44f79d010961_32429_12582f573aed_32430_ee16fff30c03_0_b2daa40f25c5_3bf191b1-28bb-4f91-84b0-8b5f 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_1694bda2089b_33034_5c0c07098edb_32429_85039057fa6a_32430_8ec7c6fb4ca9_0_1791857cbfcf_77bb1855-9dd9-45eb-a3ee-bd28 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_49600ad02c21_33034_97588103a9ab_32429_14997af6d666_32430_7d6ea0314d26_0_9cbb9b903593_3762b75d-db00-4fab-8aa8-276b 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32429_ac7e6a0c08dd_33034_663aed9abd70_32429_ae6019baa217_32430_61c0ad75dbdf_0_0b8f1b569468_d65952e4-011a-467e-90d2-94b5 32429
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_d3e42e02e814_32437_071a581a7d9d_0_f70457d50767_%2525D1%252580%2525D0%2525B5%2525D1%252584-%2525D1%252588%2525D0%2525BC%2525D0%2525B8%2525D1%252586.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_2f051463f976_32437_91870fca527d_0_3a115e1200c6_Schmitz-Cargobull-SKO-24L---COOL-V7-2.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_1f8e3b09eb2b_32437_de7ff8f56ada_0_ec7ce334a464_Schmitz-Cargobull-SKO-24L---COOL-V7-3.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_615240ef0a63_32437_38a319929988_0_484d4032f2ae_Schmitz-Cargobull-SKO-24L---COOL-V7-8.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_8d3d475f79fa_32437_19c5b4cbcf6c_0_825493001b44_Schmitz-Cargobull-SKO-24L---COOL-V7.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_9dbb8a5e1dc9_32437_65d681075702_0_4bb1b2ed5bdb_Schmitz-Cargobull-SKO-24L---COOL-V7-5.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_f19572891365_32437_46ed2617acfa_0_090b2d42b0a6_Schmitz-Cargobull-SKO-24L---COOL-V7-9.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_cb0ab4af6e92_32437_d46bb3ab9947_0_bdca67c14022_Schmitz-Cargobull-SKO-24L---COOL-V7-4.webp 32436
https://s3.timeweb.cloud/482029f9-prod/products__images/32436_62aec7341aa4_32437_f570d16bca30_0_765632967e5a_Schmitz-Cargobull-SKO-24L---COOL-V7-7.webp 32436