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 (
    '26315', '25964', '26040', '25912', 
    '27031', '26005', '27172', '27171', 
    '27173', '28881', '32465'
  )

Query time 0.00110

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "68.48"
    },
    "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": 56,
          "rows_produced_per_join": 56,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('26315','25964','26040','25912','27031','26005','27172','27171','27173','28881','32465'))",
          "cost_info": {
            "read_cost": "22.36",
            "eval_cost": "5.60",
            "prefix_cost": "27.96",
            "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": 56,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "34.92",
            "eval_cost": "5.60",
            "prefix_cost": "68.48",
            "data_read_per_join": "208K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/25912_1ac7d098f18d_processed_lot_109301_20191211091540_11.jpg.webp 25912
https://s3.timeweb.cloud/482029f9-prod/products__images/25912_cf4d92b42e1b_processed_lot_109301_20191211091544_22.jpg.webp 25912
https://s3.timeweb.cloud/482029f9-prod/products__images/25912_4b8f3bcbda1a_processed_lot_109301_20191211091546_33_.jpg.webp 25912
https://s3.timeweb.cloud/482029f9-prod/products__images/25912_b5a3d86cadf8_processed_lot_109301_20191211091549_44.jpg.webp 25912
https://s3.timeweb.cloud/482029f9-prod/products__images/25964_706420aa9d64_processed_lot_109259_20191204092145_1_0.jpg.webp 25964
https://s3.timeweb.cloud/482029f9-prod/products__images/25964_28e42f4aa39d_processed_lot_109259_20191204092150_2_0.jpg.webp 25964
https://s3.timeweb.cloud/482029f9-prod/products__images/26005_8037fa0b29db_processed_lot_36182_20140329143209.webp 26005
https://s3.timeweb.cloud/482029f9-prod/products__images/26005_fda0360b7e49_processed_lot_36182_20140329143225.webp 26005
https://s3.timeweb.cloud/482029f9-prod/products__images/26005_1111f71b5c6b_processed_lot_36182_20140329143243.webp 26005
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_6ceae61645c1_processed_lot_108787_20190911143904_DSCF2387.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_58e4d7cec385_processed_lot_108787_20190911143908_DSCF2388.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_b272f1d77c25_processed_lot_108787_20190911143912_DSCF2389.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_8a6c7a3fbcca_processed_lot_108787_20190911143916_DSCF2390.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_a3d3581878a3_processed_lot_108787_20190911143920_DSCF2391.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_f7f19ee0435d_processed_lot_108787_20190911143924_DSCF2392.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_15e483641687_processed_lot_108787_20190911143928_DSCF2393.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26040_5392e6246527_processed_lot_108787_20190911143931_DSCF2394.JPG.webp 26040
https://s3.timeweb.cloud/482029f9-prod/products__images/26315_e3e24c6e8b2d_processed_lot_102677_20180416182545_43118.jpg.webp 26315
https://s3.timeweb.cloud/482029f9-prod/products__images/27031_9f4a182f9949_processed_lot_85497_20160511145952_4208-111-30.jpg.webp 27031
https://s3.timeweb.cloud/482029f9-prod/products__images/27171_c61752a5813d_processed_lot_78906_20151110120004_IMG_0348__1__0.JPG.webp 27171
https://s3.timeweb.cloud/482029f9-prod/products__images/27171_2f59fd1c16da_processed_lot_78906_20151110120021_IMG_0347__1__0.JPG.webp 27171
https://s3.timeweb.cloud/482029f9-prod/products__images/27171_8cf82e39d72f_processed_lot_78906_20151110120035_IMG_0349_1.JPG.webp 27171
https://s3.timeweb.cloud/482029f9-prod/products__images/27171_52bac088f01d_processed_lot_78906_20151110120051_IMG_0350_1.JPG.webp 27171
https://s3.timeweb.cloud/482029f9-prod/products__images/27172_ccfb367bcde5_processed_lot_78909_20151110121609__D0_A3_D1_80_D0_B0_D0_BB_203255_0013_61_1_.jpg.webp 27172
https://s3.timeweb.cloud/482029f9-prod/products__images/27173_ec386cdfdee6_processed_lot_78901_20151110110043__D0_A3_D1_80_D0_B0_D0_BB_203255_0013_61_1_.jpg.webp 27173
https://s3.timeweb.cloud/482029f9-prod/products__images/27173_1e49ef83f99a_processed_lot_78901_20151110110052_SAM_2983.JPG.webp 27173
https://s3.timeweb.cloud/482029f9-prod/products__images/27173_0f6bb67722fb_processed_lot_78901_20151110110100_SAM_2990.JPG.webp 27173
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