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 (
    '32465', '28881', '14714', '28163', 
    '9184', '14253', '21422', '20475', 
    '22120', '18006', '26397'
  )

Query time 0.00083

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "64.08"
    },
    "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": 52,
          "rows_produced_per_join": 52,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('32465','28881','14714','28163','9184','14253','21422','20475','22120','18006','26397'))",
          "cost_info": {
            "read_cost": "20.96",
            "eval_cost": "5.20",
            "prefix_cost": "26.16",
            "data_read_per_join": "1K"
          },
          "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": 52,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "32.72",
            "eval_cost": "5.20",
            "prefix_cost": "64.08",
            "data_read_per_join": "193K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/9184_0ec76b4d7173_%D0%B2%D0%B0%D1%85%D1%82%D0%BE%D0%B2%D1%8B%D0%B9_%D0%B0%D0%B2%D1%82%D0%BE%D0%B1%D1%83%D1%81_%D0%BD%D0%B5%D1%84%D0%B0%D0%B7_%D0%BA%D0%B0%D0%BC%D0%B0%D0%B7.webp 9184
https://s3.timeweb.cloud/482029f9-prod/products__images/14253_52958afc5b0b_vax_3th7-zp_df5z-mf.webp 14253
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_f9245866ab27_22165-95629_ro85-af_ohvx-8z.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_a759449e56ec_12206-95640_70sq-bb.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/14714_b111f79cb544_12206-95639_s4sv-qy.webp 14714
https://s3.timeweb.cloud/482029f9-prod/products__images/18006_06a7110d465e_processed_f8793d7624465b93ab55eb4d1cb71830.webp 18006
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2bd5653ebcab_processed_cc259388cad280c41a2c6032bac68ffb.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2dae461ac696_processed_3b643522ff8969283a2b0a5dbed10adf.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_3a0c8b96d806_processed_e286ba04a9820b46a2b7c2dfcad5a663.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_2b4a85efb4ed_processed_1fae9670ac9fab84658d97071e592e3b.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/20475_0953d9c33bdc_processed_e3981b17e928c1b14332c6c0966fc50c.webp 20475
https://s3.timeweb.cloud/482029f9-prod/products__images/21422_578ccd911f2f_processed_493050fdee4290b438fe29d4855a2b07.webp 21422
https://s3.timeweb.cloud/482029f9-prod/products__images/21422_384ba9e81534_processed_b794739ef8c6858c6ff79352f1d14727.webp 21422
https://s3.timeweb.cloud/482029f9-prod/products__images/22120_8659a21021d3_processed_e4fc5fa41bbb6d165d4883739b90ea62.webp 22120
https://s3.timeweb.cloud/482029f9-prod/products__images/22120_c7568bb114f1_processed_12d4e27c0703b06fa2c379bc23c0c580.webp 22120
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_2836b8c24ad0_processed_lot_100220_20171130132648____________28___.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_d55cec4e3855_processed_lot_100220_20171130132654____________28_________.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_b94efc407c7a_processed_lot_100220_20171130132658_______________________28_________.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/26397_e6ba2758a0b3_processed_lot_100220_20171130132702________________________28.JPG.webp 26397
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_8f43fe307e53_28259_b98329b8398d_28163_a0f8ffeaa34d_28218_ac48cc128e2c_28163_3470eff326b6_28164_49f8ae147078_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B2%2525252525202.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_09044fb900fc_28259_e0f04ecb79b3_28163_da560cde9d77_28218_a63c34e96f9b_28163_25f53c172c13_28164_e7baefebc79e_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B2%2525252525203.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_46ecd6642381_28259_1dec18084450_28163_52dedac0abf0_28218_12c57c029b2b_28163_7e157c1f3b38_28164_9cc3a7557443_%2525252525D0%25252525259A%2525252525D1%252525252583%2525252525D0%2525252525B7%2525252525D0%2525252525BE%2525252525D0%2525252525B21.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28163_c0300afdd7e1_28259_3b24ea45cd7e_28163_781d2aef5cfc_28218_4f2d5c88b33f_28163_005d671d02aa_28164_c73937b01d91_%2525252525D0%25252525259A%2525252525D0%2525252525B0%2525252525D0%2525252525B1%2525252525D0%2525252525B8%2525252525D0%2525252525BD%2525252525D0%2525252525B0.webp 28163
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f76f1fd44d7c_28882_cc0e691d6b6f_0_15aaf11079f4_%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-17%252520151719.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_d7b708ffdf5b_28882_49beb84dfeaf_0_9478772d5954_%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-17%252520151804.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_a7e1715af214_28882_432dcd286874_0_9b53f020f774_%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-17%252520151827.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_2fbb5dcdb63b_28882_35940a1265c5_0_7d31f2ea3677_%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-17%252520151849.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_1db0e4eca14a_28882_49a35f8ebe38_0_70f2b04770e6_%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-17%252520151913.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_ce45d7c24faf_28882_9bd5f8aec4cc_0_961f8e87a292_%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-17%252520151944.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_63443e53471e_28882_fef12c4d7d3b_0_42f9b1cfa71c_%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-17%252520151958.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_b2d4179c0e96_28882_aec22a43f640_0_0a757a206f7c_%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-17%252520152017.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f3f1210f62c7_28882_cb229211cc45_0_2c7340048d11_%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-17%252520152034.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_656e8f988e21_28882_0e4b7d584216_0_ba08eaa33074_%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-17%252520152049.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f7cd5bea5b0a_28882_96b692026cbe_0_a1ee6439d74b_%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-17%252520152106.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/28881_294a2f405582_28882_4dd4c9024374_0_3b6f2760f88a_%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-17%252520152123.webp 28881
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_7bf7d0322484_33249_bee48aa76d03_32465_9b0de993a56b_32466_bc325dced473_0_17a6a369ba2d_IMG_20250122_105641jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_7e229d6d8c83_33249_52a4bc94a4b9_32465_82c65769a7ba_32466_41b90a9f814a_0_cbd4eafdc871_IMG_20250122_105513jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_d4a2d6421821_33249_5e1e9f9b1d33_32465_f6edfec8abfa_32466_895b1f36ad14_0_6474b733e987_IMG_20250122_105317jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_37969e2d617b_33249_723e67453c57_32465_0af9dbf635a3_32466_d75ea5b49545_0_645123df55c6_IMG_20250122_105243jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_de0cd0c789ae_33249_46f8bcb5416d_32465_af10cdd00080_32466_46b4d10d0704_0_55c4dc2ed368_IMG_20250113_124428jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_7a70470ff901_33249_70aa93350b83_32465_244bd0a969e9_32466_b4053974bc9e_0_dc438e01f2b8_IMG_20250122_105326jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_9c48905bf28a_33249_fdd8b24c03f4_32465_6e97a2fffb85_32466_4d9ad13cbbdf_0_b953007b8677_IMG_20250122_105236jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_79f67b6e93b4_33249_f34ccdca015a_32465_7bb7cbbd337e_32466_2d0fddc64a15_0_73e15b4e1dec_IMG_20250122_105148jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_cd378969021a_33249_ae7e28c6f5ae_32465_debbcffafc7f_32466_fe938464e21e_0_3ff009f3f44e_IMG_20250122_105226jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_188dd4e33b92_33249_12deef537e8c_32465_51eaad053f9e_32466_f89781f2a5a0_0_31f90a420e6a_IMG_20250122_105256jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_3bbb8c22d43d_33249_88c3630a1d4f_32465_599be05c72cf_32466_618ec205ca78_0_f6b58146f984_IMG_20250122_105610jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_314f80a82058_33249_146966b57fbf_32465_5c05be14f60f_32466_6e7d13af0e46_0_263d3b184797_IMG_20250122_105648jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_dbd2b1eeba4f_33249_fae447fb5f5a_32465_c4c63f43d7f0_32466_cbd15a5a3820_0_2b0c5cdb2888_IMG_20250122_105530jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_2e084b29ba42_33249_324d7ec80fbb_32465_c9d6a31eeed1_32466_047f3ae606f5_0_3eabb8624080_IMG_20250122_105606jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_b99271ea1c03_33249_3bdc1de15fbf_32465_ddda1083fd1d_32466_1b51059e2aff_0_2b3c900321a1_IMG_20250122_105700jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_ca3d925d9448_33249_74c718ab2b3e_32465_dcdbc5d9b9be_32466_79ece776d49d_0_b45415f583e2_IMG_20250122_105540jpgwebp 32465
https://s3.timeweb.cloud/482029f9-prod/products__images/32465_fafd8e6c405d_33249_d0be66fdc0af_32465_07d154f51694_32466_0fe473d49be3_0_4bab728bb62f_IMG_20250122_105545jpgwebp 32465