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

Query time 0.00060

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28883 365125 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_7850e28a460f_28884_51801976b943_0_1e17747052dc_%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%252520191547.jpg 365126 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_6273fad63f93_28884_51801976b943_0_1e17747052dc_%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%252520191547.webp 365127 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_8618c287f046_28884_51801976b943_0_1e17747052dc_%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%252520191547.webp
28883 365128 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_0e57c3dc2237_28884_7ec512599866_0_e249e95d364c_%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%252520191628.png 365129 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_64a52145b0df_28884_7ec512599866_0_e249e95d364c_%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%252520191628.webp 365130 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_01fb29cae81c_28884_7ec512599866_0_e249e95d364c_%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%252520191628.webp
28883 365131 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_78bc8ac6908f_28884_c9b9e99cf9df_0_1ea74b2dabb8_%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%252520191613.png 365132 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_1a6ad6be2cf2_28884_c9b9e99cf9df_0_1ea74b2dabb8_%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%252520191613.webp 365133 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_8e90f49e137c_28884_c9b9e99cf9df_0_1ea74b2dabb8_%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%252520191613.webp
28883 365134 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_c895a874a062_28884_79d10fea9c48_0_9192f78591e0_%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%252520191724.png 365135 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_68fd0791b39b_28884_79d10fea9c48_0_9192f78591e0_%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%252520191724.webp 365136 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_5b9ce6c0bb33_28884_79d10fea9c48_0_9192f78591e0_%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%252520191724.webp
28883 365137 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_359797a1494c_28884_92692797bb6d_0_c45138cbe42a_%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%252520191651.png 365138 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_ec26b6bfe347_28884_92692797bb6d_0_c45138cbe42a_%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%252520191651.webp 365139 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_a79ecd44ff35_28884_92692797bb6d_0_c45138cbe42a_%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%252520191651.webp
28883 365140 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_854ef90c0377_28884_b936616e84d1_0_8d2244068866_%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%252520191707.png 365141 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_bcd294ffd4dd_28884_b936616e84d1_0_8d2244068866_%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%252520191707.webp 365142 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_305fcb83983c_28884_b936616e84d1_0_8d2244068866_%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%252520191707.webp
28883 365143 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_f160ea945208_28884_83d95f0d0397_0_f7c3de086890_%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%252520191752.png 365144 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_9f7d947207c9_28884_83d95f0d0397_0_f7c3de086890_%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%252520191752.webp 365145 https://s3.timeweb.cloud/482029f9-prod/products__images/28883_64a3a20eb466_28884_83d95f0d0397_0_f7c3de086890_%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%252520191752.webp