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 (27386, 28608, 28610, 28612, 32915)

Query time 0.00062

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "29.41"
    },
    "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": 24,
          "rows_produced_per_join": 24,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (27386,28608,28610,28612,32915))",
          "cost_info": {
            "read_cost": "9.66",
            "eval_cost": "2.40",
            "prefix_cost": "12.06",
            "data_read_per_join": "768"
          },
          "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": 24,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "14.95",
            "eval_cost": "2.40",
            "prefix_cost": "29.41",
            "data_read_per_join": "89K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_c221abdd5b3d_WhatsApp_Image_2024-08-08_at_09.50.29__2__giix-hn_z6f0-8p.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_effccb643330_WhatsApp_Image_2024-08-08_at_09.50.28__1__di15-nn_dlni-5m.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_a6a3d02251a3_WhatsApp_Image_2024-08-08_at_09.50.29__1__3l4e-0c_352u-vp.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_18163124c074_WhatsApp_Image_2024-08-08_at_09.50.29__3__fa25-u3_0njy-yj.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_eabc0ed1b832_WhatsApp_Image_2024-08-08_at_09.50.29_pq0t-zu_cr81-9y.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_b6007af0ba79_WhatsApp_Image_2024-08-08_at_09.50.30__1__aj16-bb_kgqy-08.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_121c30a568f2_WhatsApp_Image_2024-08-08_at_09.50.31__2__zg27-4w_24ax-23.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_e31c21148faf_WhatsApp_Image_2024-08-08_at_09.50.31_pkap-ox_5tlu-l7.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_cc4a44d2eb7a_WhatsApp_Image_2024-08-08_at_09.50.32__1__w6sg-w4_njlb-pw.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_1a6f3a64d189_WhatsApp_Image_2024-08-08_at_09.50.32_wo16-02_xor7-qy.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_4a6e1d3a297a_WhatsApp_Image_2024-08-08_at_09.50.33_1lca-ou_ftqz-q3.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_3637c8849103_%D0%93%D1%80%D1%83%D0%B7%D0%BE%D0%B2%D0%B8%D0%BA_%D0%B1%D0%BE%D1%80%D1%82%D0%BE%D0%B2%D0%BE%D0%B9_%D1%81_%D0%9A%D0%9C%D0%A3_DAYUN_120_8kiy-jy_1hdh-nq.webp 27386
https://s3.timeweb.cloud/482029f9-prod/products__images/27386_a98c818f8ab4_%D0%93%D1%80%D1%83%D0%B7%D0%BE%D0%B2%D0%B8%D0%BA_%D0%B1%D0%BE%D1%80%D1%82%D0%BE%D0%B2%D0%BE%D0%B9_%D1%81_%D0%9A%D0%9C%D0%A3_Dayun_CGC1120D_ug6a-fc_zvru-br.webp 27386
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/28610_cdcc68e1d1a5_32298_4632fdbc370f_28610_757c0612974a_28773_7287716d223b_28610_6a1f1318599d_28767_430ed0f7f831_28610_ba0a18e9c0fb_28611_cce2f7251fdd_0_62446faa67c7_Dayun%252525252525252520Fassi%252525252525252520115.webp 28610
https://s3.timeweb.cloud/482029f9-prod/products__images/28610_3b0a16c3070e_32298_58a45970dbbd_28610_fcf1962e07d9_Dayun%252520Fassi%252520115-2.webp 28610
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