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 (
    '14253', '21422', '20475', '22120', 
    '18006', '26397', '26756', '26580', 
    '26375', '25823', '26725'
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.58"
    },
    "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": 22,
          "rows_produced_per_join": 22,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('14253','21422','20475','22120','18006','26397','26756','26580','26375','25823','26725'))",
          "cost_info": {
            "read_cost": "10.46",
            "eval_cost": "2.20",
            "prefix_cost": "12.66",
            "data_read_per_join": "704"
          },
          "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": 22,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "13.72",
            "eval_cost": "2.20",
            "prefix_cost": "28.58",
            "data_read_per_join": "81K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14253_52958afc5b0b_vax_3th7-zp_df5z-mf.webp 14253
https://s3.timeweb.cloud/482029f9-prod/products__images/18006_06a7110d465e_processed_f8793d7624465b93ab55eb4d1cb71830.webp 18006
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2bd5653ebcab_processed_cc259388cad280c41a2c6032bac68ffb.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2dae461ac696_processed_3b643522ff8969283a2b0a5dbed10adf.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_3a0c8b96d806_processed_e286ba04a9820b46a2b7c2dfcad5a663.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2b4a85efb4ed_processed_1fae9670ac9fab84658d97071e592e3b.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_0953d9c33bdc_processed_e3981b17e928c1b14332c6c0966fc50c.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/21422_578ccd911f2f_processed_493050fdee4290b438fe29d4855a2b07.webp 21422
https://s3.timeweb.cloud/482029f9-prod/products__images/21422_384ba9e81534_processed_b794739ef8c6858c6ff79352f1d14727.webp 21422
https://s3.timeweb.cloud/482029f9-prod/products__images/22120_8659a21021d3_processed_e4fc5fa41bbb6d165d4883739b90ea62.webp 22120
https://s3.timeweb.cloud/482029f9-prod/products__images/22120_c7568bb114f1_processed_12d4e27c0703b06fa2c379bc23c0c580.webp 22120
https://s3.timeweb.cloud/482029f9-prod/products__images/25823_be4789868f0d_processed_lot_82388_20160405163325_________________________.________.jpg.webp 25823
https://s3.timeweb.cloud/482029f9-prod/products__images/26375_0e9f31e4a934_processed_lot_104036_20180702092836_1.jpg.webp 26375
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_2836b8c24ad0_processed_lot_100220_20171130132648____________28___.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_d55cec4e3855_processed_lot_100220_20171130132654____________28_________.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_b94efc407c7a_processed_lot_100220_20171130132658_______________________28_________.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_e6ba2758a0b3_processed_lot_100220_20171130132702________________________28.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26580_22890ae4b3be_processed_lot_98774_20170829111459_IMG_2462-min.jpg.webp 26580
https://s3.timeweb.cloud/482029f9-prod/products__images/26580_b270ce1143e4_processed_lot_98774_20170829111523_IMG_2463-min.jpg.webp 26580
https://s3.timeweb.cloud/482029f9-prod/products__images/26580_6c034efc7c6f_processed_lot_98774_20170829111549_Ural-Next-Truck.jpg.webp 26580
https://s3.timeweb.cloud/482029f9-prod/products__images/26725_0648bb349309_processed_lot_97651_20170620132739_4208-431.jpg.webp 26725
https://s3.timeweb.cloud/482029f9-prod/products__images/26756_314f04cd7107_processed_lot_94769_20170424133737____________22.jpg.webp 26756