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 (14051, 14067, 17191, 22035, 22732)

Query time 0.02666

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.75"
    },
    "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": 20,
          "rows_produced_per_join": 20,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (14051,14067,17191,22035,22732))",
          "cost_info": {
            "read_cost": "8.26",
            "eval_cost": "2.00",
            "prefix_cost": "10.26",
            "data_read_per_join": "640"
          },
          "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": 20,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "12.49",
            "eval_cost": "2.00",
            "prefix_cost": "24.75",
            "data_read_per_join": "74K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14051_923fa6b45993_unnamed_xcfg-x4_ibdx-ek_zozr-pe_qzqr-7a_o5g7-cq_huiq-vy.webp 14051
https://s3.timeweb.cloud/482029f9-prod/products__images/14067_132b44f39780_unnamed__4__1pok-nd_4bya-6x_ytul-wv_b20i-8j_nryj-py.webp 14067
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_d5629b5437d6_processed_b39620b2d473bf23e3aebdfaf85fd9f7.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_726cf061696f_processed_2d4b4bd17b2745039ecaac96cceab681.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_e36f57bdcad8_processed_29fb8716f5ebdb79e1803d914f94f47f.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_1467457f7e03_processed_e9bdb84a253a04f7e0f72477c5a796b0.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_084f2c7f31dc_processed_48b85054f340b38a690884fd40d32a77.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_1ce3cfa7cbd4_processed_d63b620111e22ccd0b8f00635f71446d.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_85fc07558781_processed_8a0fbbc7ea77e343240509ad8e997e3e.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_c3dd09acdcd9_processed_6e139f0ca6e49865c7b137c7bc1ca695.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_301ed9b8d314_processed_05bbfc5e10463705f4c88c5e8a164061.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_250e1787f138_processed_8f15209c8db9abf11b4fcdf957aa7be8.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/17191_b3b6d78f943d_processed_26b6f31fa465b88aa0de034aac5b76b9.webp 17191
https://s3.timeweb.cloud/482029f9-prod/products__images/22035_f78995f3c6d4_processed_0d4a22e2035cf91defff4afde3a24625.webp 22035
https://s3.timeweb.cloud/482029f9-prod/products__images/22035_b575d20f5133_processed_9e683f80814bfc25631bfa0c17b2a198.webp 22035
https://s3.timeweb.cloud/482029f9-prod/products__images/22035_d68e22acf354_processed_1a79aa2b7c7444bf87baf81e3453fe60.webp 22035
https://s3.timeweb.cloud/482029f9-prod/products__images/22035_05b1e814d365_processed_526464bb342132bf1736bd26dcf81ff7.webp 22035
https://s3.timeweb.cloud/482029f9-prod/products__images/22732_f9b78e7074e6_processed_d89de4d20f94fcd4468804f338146c92.webp 22732
https://s3.timeweb.cloud/482029f9-prod/products__images/22732_f018d888dc5d_processed_7d92776640422b603e1429cfd525bd4e.webp 22732
https://s3.timeweb.cloud/482029f9-prod/products__images/22732_7ffa057e4bef_processed_59a7e9b4d3d4bf386e23e15a6f14a30b.webp 22732