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

Query time 0.00076

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
33200 411088 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_8ab5f2b8ec1c_33201_5b4fb417a0db_0_c4c232babaf4_izobraghenie-WhatsApp-2024-08-02-v-150414_b2e6ad6bjpg 411089 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_1dda256cae49_33201_5b4fb417a0db_0_c4c232babaf4_izobraghenie-WhatsApp-2024-08-02-v-150414_b2e6ad6bjpgwebp 411090 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_be71db94347e_33201_5b4fb417a0db_0_c4c232babaf4_izobraghenie-WhatsApp-2024-08-02-v-150414_b2e6ad6bjpgwebp
33200 411091 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_e08d0996b008_33201_75547c801496_0_31a993bdae3d_izobraghenie-WhatsApp-2024-08-02-v-150414_07848550jpg 411092 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_6b2df88851f2_33201_75547c801496_0_31a993bdae3d_izobraghenie-WhatsApp-2024-08-02-v-150414_07848550jpgwebp 411093 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_c103d698636e_33201_75547c801496_0_31a993bdae3d_izobraghenie-WhatsApp-2024-08-02-v-150414_07848550jpgwebp
33200 411094 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_7706c3988a88_33201_a8d4d00364a5_0_7be1a637b6c6_izobraghenie-WhatsApp-2024-08-02-v-150414_8b074b22jpg 411095 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_45455a492a62_33201_a8d4d00364a5_0_7be1a637b6c6_izobraghenie-WhatsApp-2024-08-02-v-150414_8b074b22jpgwebp 411096 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_7a71fd96ac68_33201_a8d4d00364a5_0_7be1a637b6c6_izobraghenie-WhatsApp-2024-08-02-v-150414_8b074b22jpgwebp
33200 411097 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_a7153b9590ac_33201_27a7e729b87b_0_35fce2bbc744_izobraghenie-WhatsApp-2024-08-02-v-150414_e1b1ca96jpg 411098 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_d698c3e5bc08_33201_27a7e729b87b_0_35fce2bbc744_izobraghenie-WhatsApp-2024-08-02-v-150414_e1b1ca96jpgwebp 411099 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_52d63f722a8d_33201_27a7e729b87b_0_35fce2bbc744_izobraghenie-WhatsApp-2024-08-02-v-150414_e1b1ca96jpgwebp
33200 411100 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_6a8a0d9db470_33201_4a0ed3739c8a_0_96d5abfb136d_izobraghenie-WhatsApp-2024-08-02-v-150414_d73338fcjpg 411101 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_9ac7e617c56e_33201_4a0ed3739c8a_0_96d5abfb136d_izobraghenie-WhatsApp-2024-08-02-v-150414_d73338fcjpgwebp 411102 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_cdd43cca5930_33201_4a0ed3739c8a_0_96d5abfb136d_izobraghenie-WhatsApp-2024-08-02-v-150414_d73338fcjpgwebp
33200 411103 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_49f6fcb167e1_33201_a725ae4cf8f7_0_15e5b763d7cd_izobraghenie-WhatsApp-2024-08-02-v-150414_f705feb1jpg 411104 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_6c311ab4a0fd_33201_a725ae4cf8f7_0_15e5b763d7cd_izobraghenie-WhatsApp-2024-08-02-v-150414_f705feb1jpgwebp 411105 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_6341ff4779df_33201_a725ae4cf8f7_0_15e5b763d7cd_izobraghenie-WhatsApp-2024-08-02-v-150414_f705feb1jpgwebp
33200 411106 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_2cbac120d8f2_33201_5ebac025a2bf_0_28e7060ce874_IMG-20241101-WA0027jpg 411107 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_caa4ac8ebaac_33201_5ebac025a2bf_0_28e7060ce874_IMG-20241101-WA0027jpgwebp 411108 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_a32635a8530c_33201_5ebac025a2bf_0_28e7060ce874_IMG-20241101-WA0027jpgwebp
33200 411109 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_ff20aa4b4206_33201_0339ed191eab_0_d4f5e4cc254f_IMG-20241114-WA0046jpg 411110 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_d9df4d9aa982_33201_0339ed191eab_0_d4f5e4cc254f_IMG-20241114-WA0046jpgwebp 411111 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_3b79dca39597_33201_0339ed191eab_0_d4f5e4cc254f_IMG-20241114-WA0046jpgwebp
33200 411112 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_a0dedd3a1991_33201_c8f994dac567_0_9aac5d53e2b5_IMG-20241114-WA0045jpg 411113 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_8a34c3d89778_33201_c8f994dac567_0_9aac5d53e2b5_IMG-20241114-WA0045jpgwebp 411114 https://s3.timeweb.cloud/482029f9-prod/products__images/33200_0d72ea306da2_33201_c8f994dac567_0_9aac5d53e2b5_IMG-20241114-WA0045jpgwebp