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` = 28610

Query time 0.00119

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28610 399563 https://s3.timeweb.cloud/482029f9-prod/products__images/28610_e121fc86f8a9_32298_4632fdbc370f_28610_757c0612974a_28773_7287716d223b_28610_6a1f1318599d_28767_430ed0f7f831_28610_ba0a18e9c0fb_28611_cce2f7251fdd_0_62446faa67c7_Dayun%252525252525252520Fassi%252525252525252520115.jpg 399564 https://s3.timeweb.cloud/482029f9-prod/products__images/28610_2636ec2a3349_32298_4632fdbc370f_28610_757c0612974a_28773_7287716d223b_28610_6a1f1318599d_28767_430ed0f7f831_28610_ba0a18e9c0fb_28611_cce2f7251fdd_0_62446faa67c7_Dayun%252525252525252520Fassi%252525252525252520115.webp 399565 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 399566 https://s3.timeweb.cloud/482029f9-prod/products__images/28610_ea9a62f160f1_32298_58a45970dbbd_28610_fcf1962e07d9_Dayun%252520Fassi%252520115-2.jpg 399567 https://s3.timeweb.cloud/482029f9-prod/products__images/28610_d59c566fae1f_32298_58a45970dbbd_28610_fcf1962e07d9_Dayun%252520Fassi%252520115-2.webp 399568 https://s3.timeweb.cloud/482029f9-prod/products__images/28610_3b0a16c3070e_32298_58a45970dbbd_28610_fcf1962e07d9_Dayun%252520Fassi%252520115-2.webp