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 (9075, 28876, 28905, 28907, 8861)

Query time 0.00062

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "23.66"
    },
    "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": 19,
          "rows_produced_per_join": 19,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (9075,28876,28905,28907,8861))",
          "cost_info": {
            "read_cost": "7.91",
            "eval_cost": "1.90",
            "prefix_cost": "9.81",
            "data_read_per_join": "608"
          },
          "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": 19,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "11.96",
            "eval_cost": "1.90",
            "prefix_cost": "23.67",
            "data_read_per_join": "70K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/8861_199ada47c50f_%D0%91%D0%BE%D1%80%D1%82%D0%BE%D0%B2%D0%BE%D0%B9_JAC_N90.webp 8861
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_67a1a74205ef_d7c2e8200af465c29a6da1160af81578_f6pk-h8.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_2125e97bf280_1527779699_227_difz-qk.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_788e48d63c06_1687209400_myskillsconnect-com-p-gazel-fermer-foto-salona-szadi-23_v0xu-d2.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/28876_36fd048ae43f_28939_057335ed2da7_28876_0fc059919d42_28877_72e54e2a7dce_28876_f9cc48c976ff_IMG_4430.webp 28876
https://s3.timeweb.cloud/482029f9-prod/products__images/28876_00f6d027fa85_28939_41941be72188_28876_f3786f399faa_28877_df7167f55240_28876_7f6505eaf593_IMG_4431.webp 28876
https://s3.timeweb.cloud/482029f9-prod/products__images/28876_6b9d4177c165_28939_7b4e2022664c_28876_63fdfcb2ea10_28877_aedf4fb7acdf_28876_14ffeaaace7e_IMG_4432.webp 28876
https://s3.timeweb.cloud/482029f9-prod/products__images/28876_25885e260f0f_28939_84f0cd27886f_28876_359cf828ba08_28877_9cedbda973ea_28876_62e7d5dc9527_IMG_4433.webp 28876
https://s3.timeweb.cloud/482029f9-prod/products__images/28876_bb1a55397762_28939_57609ce8d707_28876_eb167e5f1f9d_28877_baf8799d3e6a_28876_9e451a021d34_IMG_4434.webp 28876
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_ae52ff043546_28906_b17bba45d78e_0_f62d5948fd97_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520135724.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_c719120daa5b_28906_e90d7955aef3_0_abb75d361553_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520135821.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_df30a153cc00_28906_d4eacb9a12ff_0_2fef11f59a68_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520135747.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_f6f7675a1c74_28906_4cd6dbe7aaac_0_e3971c19eeb3_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-19%252520135805.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_e8e392420ae6_33422_ce98ad27b2c8_28907_c769b633457a_33420_e8f3b945da3b_28907_64b5f1696795_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_dcd8a0eab1fb_33422_f2a3aa986cba_28907_6b54ee5c6257_33420_53f5fe2a12e8_28907_c8c93761af26_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_d67d405528a7_33422_5cf7a8400930_28907_abc35684baa7_33420_0af8132fabe7_28907_3f2240821c39_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_7faec53be16a_33422_efc3388c76fc_28907_a87fd94fcad0_33420_2f105534c063_28907_63f3c5c974ca_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_b5f0b09c2d7a_33422_00e1b64e7e44_28907_326284d94bc2_33420_9cd96f7db25a_28907_6413c0232272_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_3d9b6ae2b3b5_33422_8396e1a0fa66_28907_fdf597e2a24b_33420_3d616e72184e_28907_c4c555c10cce_snimok-ekrana-2025-03-11 28907