SELECT 
  PI.product_id, 
  F1.id AS file_id, 
  F1.path AS file, 
  (
    SELECT 
      PI1.alt 
    FROM 
      `cscart_products__images` PI1 
    WHERE 
      PI1.original_file_id = F1.id
  ) AS file_alt, 
  F2.id AS big_file_id, 
  F2.path AS big_file, 
  (
    SELECT 
      PI2.alt 
    FROM 
      `cscart_products__images` PI2 
    WHERE 
      PI2.watermark_big_file_id = F2.id
  ) AS big_file_alt, 
  F3.id AS small_file_id, 
  F3.path AS small_file, 
  (
    SELECT 
      PI3.alt 
    FROM 
      `cscart_products__images` PI3 
    WHERE 
      PI3.watermark_small_file_id = F3.id
  ) AS small_file_alt 
FROM 
  `cscart_products__images` AS `PI` 
  LEFT JOIN `files` AS `F1` ON `F1`.`id` = `PI`.`original_file_id` 
  LEFT JOIN `files` AS `F2` ON `F2`.`id` = `PI`.`watermark_big_file_id` 
  LEFT JOIN `files` AS `F3` ON `F3`.`id` = `PI`.`watermark_small_file_id` 
WHERE 
  `PI`.`product_id` = 28907

Query time 0.00082

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28907 414382 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_359a4993e600_33422_ce98ad27b2c8_28907_c769b633457a_33420_e8f3b945da3b_28907_64b5f1696795_snimok-ekrana-2025-03-11 414383 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_bf2466681d5f_33422_ce98ad27b2c8_28907_c769b633457a_33420_e8f3b945da3b_28907_64b5f1696795_snimok-ekrana-2025-03-11 414384 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_e8e392420ae6_33422_ce98ad27b2c8_28907_c769b633457a_33420_e8f3b945da3b_28907_64b5f1696795_snimok-ekrana-2025-03-11
28907 414385 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_51e1d1fd1d75_33422_f2a3aa986cba_28907_6b54ee5c6257_33420_53f5fe2a12e8_28907_c8c93761af26_snimok-ekrana-2025-03-11 414386 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_96ffb53410c1_33422_f2a3aa986cba_28907_6b54ee5c6257_33420_53f5fe2a12e8_28907_c8c93761af26_snimok-ekrana-2025-03-11 414387 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_dcd8a0eab1fb_33422_f2a3aa986cba_28907_6b54ee5c6257_33420_53f5fe2a12e8_28907_c8c93761af26_snimok-ekrana-2025-03-11
28907 414388 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_d9030e59c5a4_33422_5cf7a8400930_28907_abc35684baa7_33420_0af8132fabe7_28907_3f2240821c39_snimok-ekrana-2025-03-11 414389 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_5c7681f9341a_33422_5cf7a8400930_28907_abc35684baa7_33420_0af8132fabe7_28907_3f2240821c39_snimok-ekrana-2025-03-11 414390 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_d67d405528a7_33422_5cf7a8400930_28907_abc35684baa7_33420_0af8132fabe7_28907_3f2240821c39_snimok-ekrana-2025-03-11
28907 414391 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_fffa1c1236a9_33422_efc3388c76fc_28907_a87fd94fcad0_33420_2f105534c063_28907_63f3c5c974ca_snimok-ekrana-2025-03-11 414392 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_155152f24831_33422_efc3388c76fc_28907_a87fd94fcad0_33420_2f105534c063_28907_63f3c5c974ca_snimok-ekrana-2025-03-11 414393 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_7faec53be16a_33422_efc3388c76fc_28907_a87fd94fcad0_33420_2f105534c063_28907_63f3c5c974ca_snimok-ekrana-2025-03-11
28907 414394 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_147456959b3d_33422_00e1b64e7e44_28907_326284d94bc2_33420_9cd96f7db25a_28907_6413c0232272_snimok-ekrana-2025-03-11 414395 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_8bba057fccf4_33422_00e1b64e7e44_28907_326284d94bc2_33420_9cd96f7db25a_28907_6413c0232272_snimok-ekrana-2025-03-11 414396 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_b5f0b09c2d7a_33422_00e1b64e7e44_28907_326284d94bc2_33420_9cd96f7db25a_28907_6413c0232272_snimok-ekrana-2025-03-11
28907 414397 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_6be513fbdfcf_33422_8396e1a0fa66_28907_fdf597e2a24b_33420_3d616e72184e_28907_c4c555c10cce_snimok-ekrana-2025-03-11 414398 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_dbb73e1cb6f7_33422_8396e1a0fa66_28907_fdf597e2a24b_33420_3d616e72184e_28907_c4c555c10cce_snimok-ekrana-2025-03-11 414399 https://s3.timeweb.cloud/482029f9-prod/products__images/28907_3d9b6ae2b3b5_33422_8396e1a0fa66_28907_fdf597e2a24b_33420_3d616e72184e_28907_c4c555c10cce_snimok-ekrana-2025-03-11