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 (28950, 28972, 28974, 30273, 8856)

Query time 0.00085

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.62"
    },
    "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": 25,
          "rows_produced_per_join": 25,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (28950,28972,28974,30273,8856))",
          "cost_info": {
            "read_cost": "10.01",
            "eval_cost": "2.50",
            "prefix_cost": "12.51",
            "data_read_per_join": "800"
          },
          "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": 25,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "15.61",
            "eval_cost": "2.50",
            "prefix_cost": "30.62",
            "data_read_per_join": "93K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/8856_cdca71df96be_%D0%AD%D0%B2%D0%B0%D0%BA%D1%83%D0%B0%D1%82%D0%BE%D1%80_JAC_90.webp 8856
https://s3.timeweb.cloud/482029f9-prod/products__images/28950_05fd42d2740f_28951_2e3595609b68_0_5e73f8121e3a_%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%252520140749.webp 28950
https://s3.timeweb.cloud/482029f9-prod/products__images/28950_84d4f2443043_28951_46d23b937e34_0_51dffb457bdd_%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%252520140826.webp 28950
https://s3.timeweb.cloud/482029f9-prod/products__images/28950_ec2f503869f0_28951_0767a67627bb_0_ff9012bf0e73_%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%252520140914.webp 28950
https://s3.timeweb.cloud/482029f9-prod/products__images/28950_13e55b9bb579_28951_de59cc55689d_0_91cf26153bcb_%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%252520140852.webp 28950
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5e3cfbcabf9d_28973_90b4da3e31fc_0_0dcd5e69cc84_%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%252520195654.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_da48650af5c6_28973_30b2030493e7_0_5a8314c2ada3_%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%252520140546.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_fa43cc76adf3_28973_b50ff1206bcb_0_a6aee040dae7_%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%252520195724.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_7dc3598fa2ec_28973_77c289666446_0_4eb3fae71b78_%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%252520195740.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_4c472e125363_28973_6c95dac69007_0_9acde70c8968_%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%252520140613.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a928e6da79b6_28973_896100d4348b_0_97fd7fb02299_%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%252520195756.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a033c5f1e46c_28973_736a8028943b_0_ea408229f055_%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%252520195813.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5c84e9d18db2_28973_460e295f20c8_0_4cb94836b6db_%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%252520140650.webp 28972
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_f9c682faf513_28975_2bb25901dafb_0_003ca094277b_%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%252520140949.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_a059ec353961_28975_6287d313af80_0_a7f6494ac261_%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%252520141034.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_4d4f7317cf13_28975_a2b0552979d4_0_887125e1a697_%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%252520141059.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_2969f5edf84b_28975_0b26e904ded0_0_9fe71297bf0e_%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%252520141122.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_11c5e39a2d86_28975_2348ae91c71a_0_a5e6ac8389b9_%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%252520141205.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_958411c4cbcc_28975_9af6c69e3e27_0_82171a2e4244_%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%252520141330.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_42d621b94e60_28975_fa5808f02559_0_61be826a80ef_%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%252520141144.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/28974_e89e1cbe897d_28975_c47ced63b0e2_0_cffa731113f7_%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%252520141230.webp 28974
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_bc76f3baca92_30274_a89f5890367a_0_c480481191c5_%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%252520195841.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_2fc489d957c7_30274_0934e56faadd_0_e32b0e918716_%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%252520195916.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_0281c0330b00_30274_f1cee3d64ac3_0_9454244a8fa4_%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%252520195940.webp 30273
https://s3.timeweb.cloud/482029f9-prod/products__images/30273_49ddc432e754_30274_00ca0af9cd22_0_73dcc56b49ef_%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%252520200002.webp 30273