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

Query time 0.00105

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
29136 367579 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_ea3d071cf68c_29139_71e57e1ff33c_0_d877506efab3_%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%252520175155.png 367580 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_2a8927d43d68_29139_71e57e1ff33c_0_d877506efab3_%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%252520175155.webp 367581 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_12584edf318b_29139_71e57e1ff33c_0_d877506efab3_%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%252520175155.webp
29136 367582 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_a42c7b4d861e_29139_f7fb173f3bb4_0_fb5a113efd12_%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%252520175222.png 367583 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_42d1fc4f1a8c_29139_f7fb173f3bb4_0_fb5a113efd12_%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%252520175222.webp 367584 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_dd8f20eda316_29139_f7fb173f3bb4_0_fb5a113efd12_%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%252520175222.webp
29136 367585 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_e60fe6b5982c_29139_2cead667fbb1_0_edc148cbc06b_%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%252520175240.png 367586 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_d06e1e58e7a9_29139_2cead667fbb1_0_edc148cbc06b_%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%252520175240.webp 367587 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_7bc90470faa0_29139_2cead667fbb1_0_edc148cbc06b_%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%252520175240.webp
29136 367588 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_1a714b86027a_29139_e0716b91be01_0_2db31a33d046_%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%252520175348.png 367589 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_2be5e950b87c_29139_e0716b91be01_0_2db31a33d046_%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%252520175348.webp 367590 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_384ae9753167_29139_e0716b91be01_0_2db31a33d046_%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%252520175348.webp
29136 367591 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_3739cad20e69_29139_830438b51e44_0_5d99e7655349_%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%252520175256.png 367592 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_fa3be4ed0eb4_29139_830438b51e44_0_5d99e7655349_%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%252520175256.webp 367593 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_505db9d57b52_29139_830438b51e44_0_5d99e7655349_%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%252520175256.webp
29136 367594 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_e38014f13dcb_29139_86edc8993924_0_78ee4e6c83d4_%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%252520175327.png 367595 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_ae427ebeac98_29139_86edc8993924_0_78ee4e6c83d4_%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%252520175327.webp 367596 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_21228c7fb391_29139_86edc8993924_0_78ee4e6c83d4_%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%252520175327.webp
29136 367597 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_cf229e4e271d_29139_090ac592539f_0_7817e3b92c3b_%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%252520175406.png 367598 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_d8ce68c2f78f_29139_090ac592539f_0_7817e3b92c3b_%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%252520175406.webp 367599 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_d29d8b524f69_29139_090ac592539f_0_7817e3b92c3b_%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%252520175406.webp
29136 367600 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_3aab062cc576_29139_b63c2b51ba18_0_95c0f1522551_%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%252520175425.png 367601 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_a1b3225bce9b_29139_b63c2b51ba18_0_95c0f1522551_%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%252520175425.webp 367602 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_8c0c781db000_29139_b63c2b51ba18_0_95c0f1522551_%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%252520175425.webp
29136 367603 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_0bb00b9b0ca9_29139_bcf91bd9b396_0_4729ab7c706a_%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%252520175442.png 367604 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_2e5abd089bd7_29139_bcf91bd9b396_0_4729ab7c706a_%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%252520175442.webp 367605 https://s3.timeweb.cloud/482029f9-prod/products__images/29136_b78578f67a29_29139_bcf91bd9b396_0_4729ab7c706a_%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%252520175442.webp