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

Query time 0.00056

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.73"
    },
    "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 (28905,9075,28876,29040,8861))",
          "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.47",
            "eval_cost": "2.00",
            "prefix_cost": "24.73",
            "data_read_per_join": "74K"
          },
          "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/29040_5cc92bfc1a60_29043_8a3815b9e7b6_0_a8024aa9f904_%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-18%252520174821%2525D1%25258B%2525D0%2525B2%2525D1%252581%2525D1%25258B.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5fbfdb3bd185_29043_7e313a52d757_0_39b9b6a4f1ad_%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-18%252520174821.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_d6484153c292_29043_bc888fca20d6_0_43b15a0e5229_%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-18%252520175043.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5815ed56cb2e_29043_fab546919cc1_0_0de6b36ead7b_%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-18%252520175116.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_112358104e78_29043_6f86b8ecc4e7_0_a28f10ddfbf9_%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-18%252520175102.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_ec20583c3853_29043_25e4669214a0_0_6d4d3a047ace_%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-18%252520175009.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_21cc6fc31dfb_29043_fdf7f115bf7c_0_aa99ce9eccab_%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-18%252520175026.webp 29040