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

Query time 0.00075

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28785 363802 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_29557c3e2ee2_28842_28fe6bafa770_28785_1ae6e694c7a4_%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-14%252520012953.png 363803 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_851e39734553_28842_28fe6bafa770_28785_1ae6e694c7a4_%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-14%252520012953.webp 363804 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_d4e72ec0e0b7_28842_28fe6bafa770_28785_1ae6e694c7a4_%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-14%252520012953.webp
28785 363805 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_425f4f9cd12f_28842_b955291888c4_28785_7a34526b74eb_%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-14%252520013049.png 363806 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_7167944ec696_28842_b955291888c4_28785_7a34526b74eb_%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-14%252520013049.webp 363807 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_e005bb299d48_28842_b955291888c4_28785_7a34526b74eb_%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-14%252520013049.webp
28785 363808 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_8af19d660ef0_28842_29db610d1b14_28785_a1ff0dcbcf95_%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-14%252520013028.png 363809 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_3b39ff6aa370_28842_29db610d1b14_28785_a1ff0dcbcf95_%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-14%252520013028.webp 363810 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_1cfec9870bdc_28842_29db610d1b14_28785_a1ff0dcbcf95_%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-14%252520013028.webp
28785 363811 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_43b6fed63583_28842_f048784cebbd_28785_ae4b62b11ab9_%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-14%252520013114.png 363812 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_df7203851e57_28842_f048784cebbd_28785_ae4b62b11ab9_%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-14%252520013114.webp 363813 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_6f72f0f76528_28842_f048784cebbd_28785_ae4b62b11ab9_%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-14%252520013114.webp
28785 363814 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_b6c967b351bd_28842_34706fb3062c_28785_2d4a9f211da2_%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-14%252520013137.png 363815 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_c269c67e010f_28842_34706fb3062c_28785_2d4a9f211da2_%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-14%252520013137.webp 363816 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_41a3cb3b39c8_28842_34706fb3062c_28785_2d4a9f211da2_%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-14%252520013137.webp
28785 363817 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_95e58a9c3d12_28842_e8be758f06ee_28785_c73f4728a723_%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-14%252520013159.png 363818 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_8f72aaa27cd4_28842_e8be758f06ee_28785_c73f4728a723_%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-14%252520013159.webp 363819 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_1060dc7b4696_28842_e8be758f06ee_28785_c73f4728a723_%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-14%252520013159.webp
28785 363820 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_d813cc024de5_28842_b0b247e2d14f_28785_bee0dbb52215_%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-14%252520013238.png 363821 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_6cf3918bdf82_28842_b0b247e2d14f_28785_bee0dbb52215_%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-14%252520013238.webp 363822 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_3d9da3676567_28842_b0b247e2d14f_28785_bee0dbb52215_%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-14%252520013238.webp
28785 363823 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_dacd1c4f3d5f_28842_dacb0ce82bd8_28785_cc7c9e9abb2a_%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-14%252520013220.png 363824 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_47bc140c8e20_28842_dacb0ce82bd8_28785_cc7c9e9abb2a_%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-14%252520013220.webp 363825 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_57c5c888bf48_28842_dacb0ce82bd8_28785_cc7c9e9abb2a_%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-14%252520013220.webp
28785 363826 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_93709a282c60_28842_41ae381475fc_28785_46285dd3a7e7_%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-14%252520013253.png 363827 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_94c11969a177_28842_41ae381475fc_28785_46285dd3a7e7_%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-14%252520013253.webp 363828 https://s3.timeweb.cloud/482029f9-prod/products__images/28785_98e609118e93_28842_41ae381475fc_28785_46285dd3a7e7_%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-14%252520013253.webp