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

Query time 0.00064

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
29040 367606 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_7e821051cd93_29043_8a3815b9e7b6_0_a8024aa9f904_%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%252520174821%2525D1%25258B%2525D0%2525B2%2525D1%252581%2525D1%25258B.png 367607 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_096259ad8796_29043_8a3815b9e7b6_0_a8024aa9f904_%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%252520174821%2525D1%25258B%2525D0%2525B2%2525D1%252581%2525D1%25258B.webp 367608 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5cc92bfc1a60_29043_8a3815b9e7b6_0_a8024aa9f904_%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%252520174821%2525D1%25258B%2525D0%2525B2%2525D1%252581%2525D1%25258B.webp
29040 367609 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_9a5c8f3c0713_29043_7e313a52d757_0_39b9b6a4f1ad_%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%252520174821.png 367610 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_99bfbe8f645e_29043_7e313a52d757_0_39b9b6a4f1ad_%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%252520174821.webp 367611 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5fbfdb3bd185_29043_7e313a52d757_0_39b9b6a4f1ad_%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%252520174821.webp
29040 367612 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_50bcba7399dd_29043_bc888fca20d6_0_43b15a0e5229_%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%252520175043.png 367613 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_cda89abed64d_29043_bc888fca20d6_0_43b15a0e5229_%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%252520175043.webp 367614 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_d6484153c292_29043_bc888fca20d6_0_43b15a0e5229_%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%252520175043.webp
29040 367615 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_38246ccfd4ab_29043_fab546919cc1_0_0de6b36ead7b_%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%252520175116.png 367616 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_9f4f1fd6975c_29043_fab546919cc1_0_0de6b36ead7b_%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%252520175116.webp 367617 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_5815ed56cb2e_29043_fab546919cc1_0_0de6b36ead7b_%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%252520175116.webp
29040 367618 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_0e48f177d606_29043_6f86b8ecc4e7_0_a28f10ddfbf9_%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%252520175102.png 367619 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_9450db2b555b_29043_6f86b8ecc4e7_0_a28f10ddfbf9_%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%252520175102.webp 367620 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_112358104e78_29043_6f86b8ecc4e7_0_a28f10ddfbf9_%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%252520175102.webp
29040 367621 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_d8ed1bb82299_29043_25e4669214a0_0_6d4d3a047ace_%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%252520175009.png 367622 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_6c4beeb7cf8d_29043_25e4669214a0_0_6d4d3a047ace_%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%252520175009.webp 367623 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_ec20583c3853_29043_25e4669214a0_0_6d4d3a047ace_%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%252520175009.webp
29040 367624 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_61f0623ded40_29043_fdf7f115bf7c_0_aa99ce9eccab_%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%252520175026.png 367625 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_f415e4f8880a_29043_fdf7f115bf7c_0_aa99ce9eccab_%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%252520175026.webp 367626 https://s3.timeweb.cloud/482029f9-prod/products__images/29040_21cc6fc31dfb_29043_fdf7f115bf7c_0_aa99ce9eccab_%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%252520175026.webp