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 (30771, 28843, 28850, 12449, 14280)

Query time 0.00054

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.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": 31,
          "rows_produced_per_join": 31,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (30771,28843,28850,12449,14280))",
          "cost_info": {
            "read_cost": "12.11",
            "eval_cost": "3.10",
            "prefix_cost": "15.21",
            "data_read_per_join": "992"
          },
          "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": 31,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "19.35",
            "eval_cost": "3.10",
            "prefix_cost": "37.66",
            "data_read_per_join": "115K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/12449_c50a0b3e8d03_gaz.webp 12449
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_46ecc0bef909_WhatsApp_Image_2024-05-15_at_10.42.12__1__c4oc-4u_wyd9-hj.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_a74e4d69a2e7_WhatsApp_Image_2024-05-15_at_10.42.12_a90k-ug_ntl9-l6.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_1f577f9fd91d_WhatsApp_Image_2024-05-15_at_10.42.12__2__cedn-9y_175k-qt.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_cfaec5831af8_WhatsApp_Image_2024-05-15_at_10.42.12__3__dqy4-6n_s7vy-3a.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_8db29bcb0478_WhatsApp_Image_2024-05-15_at_10.42.13_rlqi-sx_n03x-uj.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/14280_a625120d3bb4_WhatsApp_Image_2024-05-15_at_10.42.13__1__vva1-hj_uf54-rc.webp 14280
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_68e68ede6357_32802_d0d6b8b26722_28843_89c77f94f026_28845_349828482975_0_19bf7c4a39b6_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.22.28%2525252520%25252525281%2525252529%2525252520%25252525E2%2525252580%2525252594%2525252520%25252525D0%25252525BA%25252525D0%25252525BE%25252525D0%25252525BF%25252525D0%25252525B8%25252525D1%252525258F.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_d74789f6cd42_32802_5d0a1e842af7_28843_3a3866abffc3_28845_54d44a0d1663_0_a3d311ba147e_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.34.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_df60166a39ba_32802_6e358475be9d_28843_4e494bb5e052_28845_bd713367862c_0_033d92313a5a_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.35%2525252520%25252525281%2525252529%2525252520%25252525E2%2525252580%2525252594%2525252520%25252525D0%25252525BA%25252525D0%25252525BE%25252525D0%25252525BF%25252525D0%25252525B8%25252525D1%252525258F.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_6d11d9fc1e63_32802_4aba40b70556_28843_6eff862bb790_28845_6e59a17b0c89_0_6d66a448d523_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.34%2525252520%25252525281%2525252529.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_ac93d464fe05_32802_c1a42e6eb736_28843_98918de517aa_28845_86217b9cc083_0_267c0c9849f4_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.35.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_465e84216882_32802_77858f8de125_28843_502e599122dc_28845_90e92302635b_0_9e7509d552a4_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.35%2525252520%25252525283%2525252529.webp 28843
https://s3.timeweb.cloud/482029f9-prod/products__images/28843_4d92eb300e69_32802_513d558ae72f_28843_7c03964661fe_28845_f1c204e2a20f_0_88da6093265e_WhatsApp%2525252520Image%25252525202024-09-20%2525252520at%252525252010.45.35%2525252520%25252525282%2525252529.webp 28843
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/30771_7a60932bfb2b_30931_8a70660eeabd_30771_f2837d2f022e_30828_838039eb6873_30771_036266890dce_30772_f2efda97d45d_0_12a472be5623_WhatsApp%25252525252520Image%252525252525202024-04-15%25252525252520at%2525252525252013.54.58%25252525252520%252525252525281%25252525252529.webp 30771
https://s3.timeweb.cloud/482029f9-prod/products__images/30771_97720d40c932_30931_414baa2e8c96_30771_df928b23bc44_30828_14cdfbd0491a_30771_37cae5ef8dd7_30772_0677488e99dd_0_fcd27a83b1c7_WhatsApp%25252525252520Image%252525252525202024-04-15%25252525252520at%2525252525252013.54.58.webp 30771
https://s3.timeweb.cloud/482029f9-prod/products__images/30771_cdfb67b4e412_30931_60df1ff17a27_30771_7ffbf7af3bf3_30828_66e225c54eab_30771_c511f7f620f6_30772_3db7c419fdce_0_4358643ca39c_WhatsApp%25252525252520Image%252525252525202024-04-15%25252525252520at%2525252525252013.54.57.webp 30771
https://s3.timeweb.cloud/482029f9-prod/products__images/30771_d221c5aa3e7e_30931_ece2073823b5_30771_2717486217e8_30828_718e0387d457_30771_8d556cdd9ee8_30772_96cc746a0679_0_76d6fca49ec6_WhatsApp%25252525252520Image%252525252525202024-04-15%25252525252520at%2525252525252013.54.57%25252525252520%252525252525281%25252525252529.webp 30771
https://s3.timeweb.cloud/482029f9-prod/products__images/30771_33e9cf8a6fbb_30931_6b1b827c7818_30771_ab0d820720ad_30828_6f0a09d6d5cd_30771_e8ddcf625fc8_30772_aa52db6f1558_0_462b09e8a9f1_photo_5348171368530828228_y.webp 30771