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 (33006, 33187, 14737, 14739, 25261)

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.05"
    },
    "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": 16,
          "rows_produced_per_join": 16,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (33006,33187,14737,14739,25261))",
          "cost_info": {
            "read_cost": "6.86",
            "eval_cost": "1.60",
            "prefix_cost": "8.46",
            "data_read_per_join": "512"
          },
          "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": 16,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "9.99",
            "eval_cost": "1.60",
            "prefix_cost": "20.05",
            "data_read_per_join": "59K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/14737_3d3778bfb338_22148-95305_h3wh-m9_9nvr-dv.webp 14737
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_a008f0a9404a_22146-96196_ncs9-r9_u496-f4.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_c1e5e21d9a59_22146-96194_2fiq-wd_h529-e9.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_ee422e954946_22146-96193_qq23-fn_yfmi-bk.webp 14739
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdd16d637513_IMG-20240730-WA0032_2re7-99_wq5p-24.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_f6ac12f4b3c1_IMG-20240730-WA0028_5er0-bs_ggu2-ij.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ee52d4fbbf81_IMG-20240730-WA0029_cw65-se_trym-j0.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_9c79d34e8ef8_IMG-20240730-WA0030_m1bq-i6_pvc7-62.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ea1c58afee5c_IMG-20240730-WA0033_fw1g-0q_812t-z1.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_62d74536e8e1_IMG-20240730-WA0034_a4bq-yq_b8q9-un.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdaa21a18a0b_IMG-20240730-WA0035_zrri-3x_x8zl-e0.webp 25261
https://s3.timeweb.cloud/482029f9-prod/products__images/33006_a22cbc0cfb22_33011_e0c102b5b715_0_3375730d270b_Krone-SDP27webpwebp 33006
https://s3.timeweb.cloud/482029f9-prod/products__images/33187_2fcc94d9e424_33188_7569017a6bf0_0_ad8849258612_020fa981-6dd8-4520-9bb2-ea3b19bc3bc5JPGwebp 33187
https://s3.timeweb.cloud/482029f9-prod/products__images/33187_434db8c20d26_33188_7a690e2cf334_0_4814d095f1b5_0fa26ff0-483f-4ddf-bbb4-2b6bac562a8fJPGwebp 33187
https://s3.timeweb.cloud/482029f9-prod/products__images/33187_b9a0942872cb_33188_058d76eac384_0_246cb0003e26_a06ec5d2-228d-4578-936d-173614162159JPGwebp 33187
https://s3.timeweb.cloud/482029f9-prod/products__images/33187_8cf3e84468cb_33188_9676e5ead1f7_0_b292a6d070d4_a7f880a9-7589-49f9-ab77-b865f5ae291cJPGwebp 33187