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 (27289, 33018, 14430, 14655, 28608)

Query time 0.00050

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "15.34"
    },
    "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": 12,
          "rows_produced_per_join": 12,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (27289,33018,14430,14655,28608))",
          "cost_info": {
            "read_cost": "5.46",
            "eval_cost": "1.20",
            "prefix_cost": "6.66",
            "data_read_per_join": "384"
          },
          "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": 12,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "7.48",
            "eval_cost": "1.20",
            "prefix_cost": "15.34",
            "data_read_per_join": "44K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14430_e0fafde55d71_1_zyih-ap_t289-ti_s2g0-53.webp 14430
https://s3.timeweb.cloud/482029f9-prod/products__images/14655_fba9116374f3_20190920_084848_gm6s-mt_i0bp-5e.webp 14655
https://s3.timeweb.cloud/482029f9-prod/products__images/27289_09daabbd7013_385ef3a0-bacc-4178-a52f-0713df507061_s0lz-bi_f4iq-w0_c3ed-ab_gxii-qc.webp 27289
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/33018_62f64a34a01f_33021_f5b055b3fb3f_0_deae0d8a40eb_IMG-20241010-WA0023jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_4f3f06f581e0_33021_e6105945e46b_0_58b171faa5b5_IMG-20241010-WA0022jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_67440dda5985_33021_d429381181da_0_d21763fcd4a4_IMG-20241010-WA0024jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_86950a9fee14_33021_edd1aaca6be0_0_58b171faa5b5_IMG-20241010-WA0021jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_27848a00bad3_33021_c4eec3c703ab_0_10e224fd0656_IMG-20241010-WA0025jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_4bcefa2498d1_33021_2da385b38a01_0_10e224fd0656_IMG-20241010-WA0005jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_6c90cd4b01b5_33021_04782d61d7f7_0_ec52aaed44f4_izobraghenie-WhatsApp-2025-01-29-v-122707_aec771e3jpgwebp 33018
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_e806b26ddb84_33021_363707b994d6_0_3fe347f7d976_izobraghenie-WhatsApp-2025-01-29-v-122707_f0692a21jpgwebp 33018