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')

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "18.30"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "PI",
          "access_type": "ref",
          "possible_keys": [
            "product_id"
          ],
          "key": "product_id",
          "used_key_parts": [
            "product_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 17,
          "rows_produced_per_join": 17,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "4.25",
            "eval_cost": "1.70",
            "prefix_cost": "5.95",
            "data_read_per_join": "544"
          },
          "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": 17,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "10.65",
            "eval_cost": "1.70",
            "prefix_cost": "18.30",
            "data_read_per_join": "63K"
          },
          "used_columns": [
            "id",
            "path"
          ]
        }
      }
    ]
  }
}

Result

path product_id alt
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