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 (32489, 33200, 28836, 28850, 8855)

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "35.41"
    },
    "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": 29,
          "rows_produced_per_join": 29,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (32489,33200,28836,28850,8855))",
          "cost_info": {
            "read_cost": "11.41",
            "eval_cost": "2.90",
            "prefix_cost": "14.31",
            "data_read_per_join": "928"
          },
          "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": 29,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "18.20",
            "eval_cost": "2.90",
            "prefix_cost": "35.41",
            "data_read_per_join": "108K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/8855_bb16a9b8c08e_%D0%93%D0%B8%D0%B4%D1%80%D0%BE%D0%B1%D0%BE%D1%80%D1%82_JAC_90.webp 8855
https://s3.timeweb.cloud/482029f9-prod/products__images/28836_cc2cbf83d67e_32818_98af5711b881_28836_69098594e1e2_32791_536ae9793aa3_28836_9bfedc2fbc4d_28837_48a9502f0c73_0_c46bc07ae78d_photo_2024-11-08_11-19-53.webp 28836
https://s3.timeweb.cloud/482029f9-prod/products__images/28836_7de1eb76a23c_32818_61df20b8c69f_28836_1b2aa9fff331_32791_a09de268af30_28836_e1827b29e35e_28837_094a7a5f7979_0_6f05a0d6fcdf_WhatsApp%25252525252520Image%252525252525202024-11-07%25252525252520at%2525252525252015.56.21%25252525252520%252525252525281%25252525252529.webp 28836
https://s3.timeweb.cloud/482029f9-prod/products__images/28836_45a0a5f21ff3_32818_f977e6a45349_28836_06cded995ac1_32791_7494e6eed9b2_28836_9dc4f0eafbf1_28837_2a75ca15ec47_0_1b38e7477fbb_photo_2024-11-08_11-26-51%25252525252520%252525252525282%25252525252529.webp 28836
https://s3.timeweb.cloud/482029f9-prod/products__images/28836_ad2485ad0024_32818_bb51a0d3de15_28836_5d8b78aecaef_32791_3a882d33c70c_28836_a56ea60ebc71_28837_62a6e2490d9f_0_2400a61f7d7f_photo_2024-11-08_11-26-53.webp 28836
https://s3.timeweb.cloud/482029f9-prod/products__images/28836_12bcd444fcdc_32818_2e07b156c2d9_28836_bb39e0053f7a_32791_2bf2661584e5_28836_9bf99134a123_28837_d1a2d4b758f1_0_6eb2fa574ddf_IMG_20241105_114747.webp 28836
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_a1dcb678784a_32808_445cfab290c2_28850_73cab6dfb9b1_28851_7315373b9d68_0_fb381fb5f9e3_IMG_20240124_104104.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_bb3038d0207d_32808_66be0588c3ec_28850_fef41d8c5ca5_28851_750476985ade_0_0f7b907e594e_IMG_20240124_104209.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_0bb38ba95929_32808_bdda38b0cc87_28850_1813247c09c6_28851_6e1cd27f75e0_0_e9a073f35544_IMG_20240124_104202.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_b00bc27cad00_32808_599256b26cc9_28850_fcf9b67a47df_28851_6f7b5ab22632_0_aceb71931c03_IMG_20240124_104151.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_223423b9a634_32808_e1388aa9d021_28850_4e1cb8547356_28851_92581b840ec9_0_531576eef64c_IMG_20240124_104110.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_4e716a236de6_32808_b231e5ea2cc3_28850_09c45ce8c321_28851_80924b48098e_0_801efa0d4078_WhatsApp%2525252520Image%25252525202024-12-17%2525252520at%252525252010.40.20%2525252520%25252525281%2525252529.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_7cd384e33fcb_32808_f0aa89a64d7f_28850_c493758b7591_28851_a9601e522b39_0_964ad0d0c8c9_WhatsApp%2525252520Image%25252525202024-12-17%2525252520at%252525252010.40.19%2525252520%25252525281%2525252529.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_8694487fcc6e_32808_f8c981f19bb2_28850_233640c53469_28851_348bac934a3e_0_c823257167d6_WhatsApp%2525252520Image%25252525202024-12-17%2525252520at%252525252010.40.20.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_62bc2b1754f0_32808_56bf6ddbb6f9_28850_10b3b9f4bc45_28851_9ff0a0b899f6_0_8893a0b9de93_WhatsApp%2525252520Image%25252525202024-12-17%2525252520at%252525252010.40.19.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_cab5be3955c4_32808_2896e559a625_28850_7f0765587bee_28851_28927dd183a6_0_d985202a823f_WhatsApp%2525252520Image%25252525202024-12-17%2525252520at%252525252010.40.17.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_4aa79c96a60d_32808_ece5403ff69a_28850_c6c738fdf0bf_28851_14719744f87f_0_85f507de016b_photo_2023-12-14_16-15-24.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/28850_4b517d4eafee_32808_3bb1e83e4ff6_28850_c419e26123e3_28851_6b9c917f59a1_0_5e42a01a6c68_photo_2023-12-14_16-15-15.webp 28850
https://s3.timeweb.cloud/482029f9-prod/products__images/32489_6a4a8d4729b8_32490_ec7756aa3639_0_cf328582fe1c_unnamed.webp 32489
https://s3.timeweb.cloud/482029f9-prod/products__images/32489_f193d676a039_32490_56f64198728d_0_9f68ca70014c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202024-04-16%252520%2525D0%2525B2%25252014.06.43_c978353c.webp 32489
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_be71db94347e_33201_5b4fb417a0db_0_c4c232babaf4_izobraghenie-WhatsApp-2024-08-02-v-150414_b2e6ad6bjpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_c103d698636e_33201_75547c801496_0_31a993bdae3d_izobraghenie-WhatsApp-2024-08-02-v-150414_07848550jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_7a71fd96ac68_33201_a8d4d00364a5_0_7be1a637b6c6_izobraghenie-WhatsApp-2024-08-02-v-150414_8b074b22jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_52d63f722a8d_33201_27a7e729b87b_0_35fce2bbc744_izobraghenie-WhatsApp-2024-08-02-v-150414_e1b1ca96jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_cdd43cca5930_33201_4a0ed3739c8a_0_96d5abfb136d_izobraghenie-WhatsApp-2024-08-02-v-150414_d73338fcjpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_6341ff4779df_33201_a725ae4cf8f7_0_15e5b763d7cd_izobraghenie-WhatsApp-2024-08-02-v-150414_f705feb1jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_a32635a8530c_33201_5ebac025a2bf_0_28e7060ce874_IMG-20241101-WA0027jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_3b79dca39597_33201_0339ed191eab_0_d4f5e4cc254f_IMG-20241114-WA0046jpgwebp 33200
https://s3.timeweb.cloud/482029f9-prod/products__images/33200_0d72ea306da2_33201_c8f994dac567_0_9aac5d53e2b5_IMG-20241114-WA0045jpgwebp 33200