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

Query time 0.00072

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28972 367637 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_d3d8a566f677_28973_90b4da3e31fc_0_0dcd5e69cc84_%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%252520195654.png 367639 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_0bd742c8a4ad_28973_90b4da3e31fc_0_0dcd5e69cc84_%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%252520195654.webp 367641 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5e3cfbcabf9d_28973_90b4da3e31fc_0_0dcd5e69cc84_%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%252520195654.webp
28972 367642 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_6d30163e187e_28973_30b2030493e7_0_5a8314c2ada3_%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-19%252520140546.png 367644 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_af6098f781be_28973_30b2030493e7_0_5a8314c2ada3_%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-19%252520140546.webp 367647 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_da48650af5c6_28973_30b2030493e7_0_5a8314c2ada3_%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-19%252520140546.webp
28972 367649 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_df28fc1bc868_28973_b50ff1206bcb_0_a6aee040dae7_%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%252520195724.png 367651 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a683c1fb59e9_28973_b50ff1206bcb_0_a6aee040dae7_%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%252520195724.webp 367653 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_fa43cc76adf3_28973_b50ff1206bcb_0_a6aee040dae7_%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%252520195724.webp
28972 367655 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_3a79f78ff382_28973_77c289666446_0_4eb3fae71b78_%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%252520195740.png 367657 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_114cd601f4f0_28973_77c289666446_0_4eb3fae71b78_%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%252520195740.webp 367659 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_7dc3598fa2ec_28973_77c289666446_0_4eb3fae71b78_%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%252520195740.webp
28972 367660 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_b9926d4980ab_28973_6c95dac69007_0_9acde70c8968_%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-19%252520140613.png 367661 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_36135b32b9e0_28973_6c95dac69007_0_9acde70c8968_%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-19%252520140613.webp 367662 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_4c472e125363_28973_6c95dac69007_0_9acde70c8968_%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-19%252520140613.webp
28972 367663 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_14619f77fc5e_28973_896100d4348b_0_97fd7fb02299_%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%252520195756.png 367664 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_3cf831807082_28973_896100d4348b_0_97fd7fb02299_%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%252520195756.webp 367665 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a928e6da79b6_28973_896100d4348b_0_97fd7fb02299_%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%252520195756.webp
28972 367666 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_b72928577c00_28973_736a8028943b_0_ea408229f055_%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%252520195813.png 367667 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_51b804020147_28973_736a8028943b_0_ea408229f055_%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%252520195813.webp 367668 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_a033c5f1e46c_28973_736a8028943b_0_ea408229f055_%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%252520195813.webp
28972 367669 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_ab36b559626f_28973_460e295f20c8_0_4cb94836b6db_%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-19%252520140650.png 367670 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_aad8510781ce_28973_460e295f20c8_0_4cb94836b6db_%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-19%252520140650.webp 367672 https://s3.timeweb.cloud/482029f9-prod/products__images/28972_5c84e9d18db2_28973_460e295f20c8_0_4cb94836b6db_%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-19%252520140650.webp