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 (28946, 28966, 28843, 28954, 12449)

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.70"
    },
    "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 (28946,28966,28843,28954,12449))",
          "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.39",
            "eval_cost": "3.10",
            "prefix_cost": "37.70",
            "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/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/28946_8ab1c049aba8_28947_2fd366ac13f2_0_ec7fce1dcb21_%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%252520173403.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_5035a56d00ed_28947_fe64c121c2e3_0_a9cd963430ef_%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%252520173446.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_3679561adb44_28947_359866b47854_0_dd44b045ce1c_%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%252520173430.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_695836ea13e5_28947_d793d06535c0_0_2fa9fae79c46_%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%252520174007.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_504455fb4153_28947_9e3eed2cc53f_0_c8dda0614ba9_%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%252520174024.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_b0522c245351_28947_df32284cc48e_0_7806bd60f0ff_%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%252520174039.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_ba13b165974e_28947_206d1ab28773_0_838150bd2102_%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%252520174150.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_c5674e10779d_28947_c57d2cc2e240_0_2d93ee37eaea_%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%252520174206.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_efc5d5449689_28947_8e81623db6c6_0_fadd934bcc05_%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%252520174057.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_6cfbd6fba65f_28947_5dee45ab11a4_0_f6444f04859c_%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%252520174135.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28946_4befcebb3d61_28947_fa61fa2e8548_0_b0cdfacdeb15_%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%252520174120.webp 28946
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_e3f35d92dc06_28955_efc98e4ac628_0_15a5a82d86f8_%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%252520171017.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_44ae740e7bfa_28955_ea9aa06e5776_0_db4e233a9903_%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%252520171054.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_5e3b02d7a6a1_28955_d4e01babc83c_0_0c4040ecbbc3_%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%252520171133.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_a8abb3ee43c1_28955_0164ff96f09d_0_6fca1b5d456e_%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%252520171115.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_1ecec99b5dd8_28955_af2dcc495765_0_5fb86c426146_%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%252520171152.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28954_43a89114cadb_28955_5d1c777b4373_0_e722ff580d6b_%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%252520171213.webp 28954
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_2ccc609f8c2f_28967_9c0443de198f_0_f4255dd82e74_IMG_4462.webp 28966
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_ec3feba5e855_28967_dec21d1170ca_0_f4255dd82e74_IMG_4463.webp 28966
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_0526afbfdb17_28967_996ae9095653_0_ca72baff57d1_IMG_4469.webp 28966
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_dd9156d649ca_28967_67324e787956_0_cffd535b7630_IMG_4464.webp 28966
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_d1a1f0d6863c_28967_03fb728c77d0_0_27bf974ca99b_IMG_4465.webp 28966
https://s3.timeweb.cloud/482029f9-prod/products__images/28966_7dc499aaef11_28967_091f19f2f2cd_0_e06dbc3294e1_IMG_4468.webp 28966