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 (9075, 28905, 28907, 28927, 29040)

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "34.11"
    },
    "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": 28,
          "rows_produced_per_join": 28,
          "filtered": "100.00",
          "index_condition": "(`dev2`.`PI`.`product_id` in (9075,28905,28907,28927,29040))",
          "cost_info": {
            "read_cost": "11.06",
            "eval_cost": "2.80",
            "prefix_cost": "13.86",
            "data_read_per_join": "896"
          },
          "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": 28,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "17.45",
            "eval_cost": "2.80",
            "prefix_cost": "34.11",
            "data_read_per_join": "104K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_67a1a74205ef_d7c2e8200af465c29a6da1160af81578_f6pk-h8.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_2125e97bf280_1527779699_227_difz-qk.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/9075_788e48d63c06_1687209400_myskillsconnect-com-p-gazel-fermer-foto-salona-szadi-23_v0xu-d2.webp 9075
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_ae52ff043546_28906_b17bba45d78e_0_f62d5948fd97_%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-19%252520135724.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_c719120daa5b_28906_e90d7955aef3_0_abb75d361553_%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-19%252520135821.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_df30a153cc00_28906_d4eacb9a12ff_0_2fef11f59a68_%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-19%252520135747.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28905_f6f7675a1c74_28906_4cd6dbe7aaac_0_e3971c19eeb3_%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-19%252520135805.webp 28905
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_e8e392420ae6_33422_ce98ad27b2c8_28907_c769b633457a_33420_e8f3b945da3b_28907_64b5f1696795_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_dcd8a0eab1fb_33422_f2a3aa986cba_28907_6b54ee5c6257_33420_53f5fe2a12e8_28907_c8c93761af26_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_d67d405528a7_33422_5cf7a8400930_28907_abc35684baa7_33420_0af8132fabe7_28907_3f2240821c39_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_7faec53be16a_33422_efc3388c76fc_28907_a87fd94fcad0_33420_2f105534c063_28907_63f3c5c974ca_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_b5f0b09c2d7a_33422_00e1b64e7e44_28907_326284d94bc2_33420_9cd96f7db25a_28907_6413c0232272_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28907_3d9b6ae2b3b5_33422_8396e1a0fa66_28907_fdf597e2a24b_33420_3d616e72184e_28907_c4c555c10cce_snimok-ekrana-2025-03-11 28907
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_f2d4bd8be733_28928_9b59374360eb_0_8ff04ebf34f1_%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%252520174615.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_eb4935fc69f0_28928_4680764b65f2_0_00629c49c6a3_%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%252520174503.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_161b5ab1ff6b_28928_a0a99c5b326c_0_850096ce849b_%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%252520174600.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_034b215b6c58_28928_fabcffd4e968_0_219c3eba4c28_%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%252520174544.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_f1083206d64a_28928_9a68098d2549_0_e0d5ba21db75_%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%252520174525.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_717c1888de2c_28928_75a181a6cbd2_0_ad288121f551_%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%252520174632.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_36d0ff81e682_28928_af4f5e158b43_0_1fd9eb09402e_%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%252520174648.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/28927_8574205306bf_28928_b8ae2873eeed_0_f8d5a2d2ff27_%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%252520174702.webp 28927
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5cc92bfc1a60_29043_8a3815b9e7b6_0_a8024aa9f904_%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%252520174821%2525D1%25258B%2525D0%2525B2%2525D1%252581%2525D1%25258B.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5fbfdb3bd185_29043_7e313a52d757_0_39b9b6a4f1ad_%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%252520174821.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_d6484153c292_29043_bc888fca20d6_0_43b15a0e5229_%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%252520175043.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5815ed56cb2e_29043_fab546919cc1_0_0de6b36ead7b_%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%252520175116.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_112358104e78_29043_6f86b8ecc4e7_0_a28f10ddfbf9_%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%252520175102.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_ec20583c3853_29043_25e4669214a0_0_6d4d3a047ace_%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%252520175009.webp 29040
https://s3.timeweb.cloud/482029f9-prod/products__images/29040_21cc6fc31dfb_29043_fdf7f115bf7c_0_aa99ce9eccab_%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%252520175026.webp 29040