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 (
    '28610', '28620', '28612', '28638', 
    '28792', '28629', '28614', '28684', 
    '28608'
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "30.44"
    },
    "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": 24,
          "rows_produced_per_join": 24,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('28610','28620','28612','28638','28792','28629','28614','28684','28608'))",
          "cost_info": {
            "read_cost": "10.66",
            "eval_cost": "2.40",
            "prefix_cost": "13.06",
            "data_read_per_join": "768"
          },
          "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": 24,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "14.98",
            "eval_cost": "2.40",
            "prefix_cost": "30.44",
            "data_read_per_join": "89K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/28608_67e478cfe2f0_28770_d49344c096f0_28608_e199bc0d8aab_28609_2592f84522b1_Dayun%25252520HKTC%252525205014.webp 28608
https://s3.timeweb.cloud/482029f9-prod/products__images/28610_cdcc68e1d1a5_32298_4632fdbc370f_28610_757c0612974a_28773_7287716d223b_28610_6a1f1318599d_28767_430ed0f7f831_28610_ba0a18e9c0fb_28611_cce2f7251fdd_0_62446faa67c7_Dayun%252525252525252520Fassi%252525252525252520115.webp 28610
https://s3.timeweb.cloud/482029f9-prod/products__images/28610_3b0a16c3070e_32298_58a45970dbbd_28610_fcf1962e07d9_Dayun%252520Fassi%252520115-2.webp 28610
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_c31ba573549d_32296_df5f0fb04fa5_28612_7eed05562e23_28768_efc05b60f87c_28612_79ef3cc3d74c_28686_97862b6ee760_28612_a09c221f400c_28613_c3298377c2a6_0_b0e96978d57e_Dayun%252525252525252520XCMG%252525252525252520125-4.webp 28612
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_89a1e6ebf29c_32296_6a80cc7de21b_28612_3c7042ad9bd8_Dayun%252520XCMG%252520125-4-1.webp 28612
https://s3.timeweb.cloud/482029f9-prod/products__images/28614_004390d897dd_28762_7aab5b9a2817_28614_75445ef909e1_28615_ffa7c65deec5_0_d7452607001c_Dayun%2525252520%25252525D1%2525252588%25252525D1%2525252582%25252525D0%25252525BE%25252525D1%2525252580%25252525D0%25252525B0%2525252520%25252525204.webp 28614
https://s3.timeweb.cloud/482029f9-prod/products__images/28614_3f3c2fbd9622_28762_7fbe5887a5ae_28614_442c96509905_28615_9e971818b3ca_0_29798e4008d3_Dayun%2525252520%25252525D1%2525252588%25252525D1%2525252582%25252525D0%25252525BE%25252525D1%2525252580%25252525D0%25252525B0%25252525201.webp 28614
https://s3.timeweb.cloud/482029f9-prod/products__images/28614_dd9a7f43a80e_28762_0f4f34473d27_28614_af010b1e72f0_28615_ec943eb26786_0_316645a9e05f_Dayun%2525252520%25252525D1%2525252588%25252525D1%2525252582%25252525D0%25252525BE%25252525D1%2525252580%25252525D0%25252525B0%2525252520%25252525202.webp 28614
https://s3.timeweb.cloud/482029f9-prod/products__images/28614_6ba25ca22459_28762_58c880181ece_28614_b13658d592bf_28615_6ded7fe9e91c_0_d2f8712f1a66_Dayun%2525252520%25252525D1%2525252588%25252525D1%2525252582%25252525D0%25252525BE%25252525D1%2525252580%25252525D0%25252525B0%2525252520%25252525203.webp 28614
https://s3.timeweb.cloud/482029f9-prod/products__images/28620_6354507884ec_32297_82e76284916c_28620_59393f986828_28769_83e571966774_28620_69a6a04ecb28_28621_504aa4214a80_0_0e604cb21914_Shachman%25252525252526Hydrolift2075.webp 28620
https://s3.timeweb.cloud/482029f9-prod/products__images/28620_cf7de70f398d_32297_8d748401fe94_28620_23c718361fc3_Shachman%252526Hydrolift2075-2.webp 28620
https://s3.timeweb.cloud/482029f9-prod/products__images/28629_5adbbb400e8a_28763_6b600ea35549_28629_b9f2accea58d_28630_ae18e334967f_%252525D0%252525A0%252525D0%252525B5%252525D1%25252584-1.webp 28629
https://s3.timeweb.cloud/482029f9-prod/products__images/28629_d8805b5979ac_28763_b6b1c6391420_28629_ae1522a69926_28630_cfb122609276_%252525D0%252525A0%252525D0%252525B5%252525D1%25252584-2.webp 28629
https://s3.timeweb.cloud/482029f9-prod/products__images/28638_44146d846d22_32295_e3afe8d2ac93_28638_edc03f30b05c_28771_77f0b70091d7_28638_715e5167923c_28639_6fc781f95713_0_5c66c395cadc_65115%25252525252520%252525252525D1%25252525252581%25252525252520Horyong%25252525252520HRS216%25252525252520real.webp 28638
https://s3.timeweb.cloud/482029f9-prod/products__images/28638_9803c32611fe_32295_9547d173553a_photo_2024-12-17_11-53-00.webp 28638
https://s3.timeweb.cloud/482029f9-prod/products__images/28638_61c3ff0c4270_32295_9547d173553a_photo_2024-12-17_11-52-54.webp 28638
https://s3.timeweb.cloud/482029f9-prod/products__images/28638_2b5396172087_32295_c316a3f9c8c8_photo_2024-12-17_11-50-54.webp 28638
https://s3.timeweb.cloud/482029f9-prod/products__images/28684_f76874d44587_28760_a86737764bd1_28684_65202866f593_28685_e7940afa2313_0_fc196dbcac8a_4.webp 28684
https://s3.timeweb.cloud/482029f9-prod/products__images/28684_0ffa6c52d2ee_28760_f6ba667c1769_28684_4693b31f0944_28685_7241ecd5a394_0_a62b5ad1fcbf_3.webp 28684
https://s3.timeweb.cloud/482029f9-prod/products__images/28684_1faa938434a9_28760_88fc85cb5655_28684_fe555b5259f2_28685_37949e3b5922_0_c060a4c25366_2.webp 28684
https://s3.timeweb.cloud/482029f9-prod/products__images/28684_47d58cc6e11c_28760_25c6ecf60cbb_28684_fd91b5c1e890_28685_8f5b545a5d79_0_38ba768b6cbf_1.webp 28684
https://s3.timeweb.cloud/482029f9-prod/products__images/28792_354025af323c_32294_f6d5ba1a0c4c_28792_49a1e75cd326_28793_d6f5ee803988_0_82e01d150872_11.webp 28792
https://s3.timeweb.cloud/482029f9-prod/products__images/28792_2ef2143649e9_32294_dc97ff6b0e1c_28792_2a2e7b292c88_28793_fbc1ff518739_0_5cef5e91590e_12.webp 28792
https://s3.timeweb.cloud/482029f9-prod/products__images/28792_cb8b15dc16ab_32294_640d0cebc639_28792_fda5bae61083_28793_cd61e58e4c5a_0_826101f04208_13.webp 28792