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 (
    '28923', '28921', '28917', '28915', 
    '28913', '28911', '28909', '28672'
  )

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.80"
    },
    "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": 16,
          "rows_produced_per_join": 16,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in ('28923','28921','28917','28915','28913','28911','28909','28672'))",
          "cost_info": {
            "read_cost": "7.61",
            "eval_cost": "1.60",
            "prefix_cost": "9.21",
            "data_read_per_join": "512"
          },
          "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": 16,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "9.99",
            "eval_cost": "1.60",
            "prefix_cost": "20.80",
            "data_read_per_join": "59K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/28672_fc5af1e5e9bf_28673_5ef6d496f99a_0_acbc3ec98bb0_22222.webp 28672
https://s3.timeweb.cloud/482029f9-prod/products__images/28909_66ae766ea4ad_28910_9f16c52e5b02_0_91dcb6eb5e96_2024-12-21_18-18-45.webp 28909
https://s3.timeweb.cloud/482029f9-prod/products__images/28911_926988cd0de6_28912_74ef0c35ff51_0_4480248437b6_2024-12-21_18-23-48.webp 28911
https://s3.timeweb.cloud/482029f9-prod/products__images/28913_75c9f8ed31c0_28914_d369b4504922_0_120f4f8fc8ad_9U1plUoffgg.webp 28913
https://s3.timeweb.cloud/482029f9-prod/products__images/28913_5257e01f6f7f_28914_eda2fb486ce8_0_c68a9f2c4bc9_v-BT2z_LlZs.webp 28913
https://s3.timeweb.cloud/482029f9-prod/products__images/28913_804bda184a26_28914_b6b60cc7bd65_0_822fd26e1c95_eNj5p845ajA.webp 28913
https://s3.timeweb.cloud/482029f9-prod/products__images/28915_d8cc594195ab_28916_2eb9fb114af3_0_21c27b12a959_2024-12-21_18-29-41.webp 28915
https://s3.timeweb.cloud/482029f9-prod/products__images/28917_31d7ed2b8756_28918_7cf920a4995d_0_a623104f0f56_jraacjglumI%252520%2525281%252529.webp 28917
https://s3.timeweb.cloud/482029f9-prod/products__images/28921_5d161157cb4b_28922_e351543b142d_0_c6d847fb09ac_dkvqbFh_rhw.webp 28921
https://s3.timeweb.cloud/482029f9-prod/products__images/28921_1b7f7f815702_28922_1732ee4415cc_0_8407e55f5678_RIrqKodL0zo.webp 28921
https://s3.timeweb.cloud/482029f9-prod/products__images/28921_ce1dec7f6257_28922_610cc92d3fa4_0_b599e595796b_MV2PSeZ6pmQ%252520%2525281%252529.webp 28921
https://s3.timeweb.cloud/482029f9-prod/products__images/28921_cd970c1cca51_28922_0a00f10a324a_0_cc6a5f86d14b_4HKhPH2z3wE.webp 28921
https://s3.timeweb.cloud/482029f9-prod/products__images/28921_7554690f0790_28922_dccd3915853b_0_cc5eb876996e_OrUXGt7QECo.webp 28921
https://s3.timeweb.cloud/482029f9-prod/products__images/28923_bde816eadad9_28924_a6c677e64753_0_1d97b4f991cf_%2525D0%252591%2525D0%2525B5%2525D0%2525B7%2525D1%25258B%2525D0%2525BC%2525D1%25258F%2525D0%2525BD%2525D0%2525BD%2525D1%25258B%2525D0%2525B9-1%252520%2525281%252529.webp 28923
https://s3.timeweb.cloud/482029f9-prod/products__images/28923_211d6b6da36e_28924_8e54457d04f5_0_a91f3b5c30d0_DeWatermark.ai_1734790201848.webp 28923
https://s3.timeweb.cloud/482029f9-prod/products__images/28923_7c380b4a362e_28924_638a61d57893_0_ee7a021d1786_DeWatermark.ai_1734790247743.webp 28923