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

Query time 0.00066

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28894 365173 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_40270949f8ad_28895_f6d30ab7f922_0_8bf63bdb989b_%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%252520190518.png 365174 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_ae6da1a3a49a_28895_f6d30ab7f922_0_8bf63bdb989b_%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%252520190518.webp 365175 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_b7645988b1c4_28895_f6d30ab7f922_0_8bf63bdb989b_%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%252520190518.webp
28894 365176 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_7b2b170a5ec2_28895_c640b454b285_0_02906ae7244c_%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%252520190532.png 365177 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_9e58eb4449b1_28895_c640b454b285_0_02906ae7244c_%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%252520190532.webp 365178 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_70ebece0f198_28895_c640b454b285_0_02906ae7244c_%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%252520190532.webp
28894 365179 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_2183288bf60c_28895_d7fcd1e3e068_0_c47552817d8b_%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%252520190549.png 365180 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_1dbc456cf74a_28895_d7fcd1e3e068_0_c47552817d8b_%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%252520190549.webp 365181 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_0d917577f011_28895_d7fcd1e3e068_0_c47552817d8b_%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%252520190549.webp
28894 365182 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_ce3c575c7d4a_28895_12bbd366ab41_0_cff6f8fd666b_%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%252520190452.png 365183 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_45ce956cf365_28895_12bbd366ab41_0_cff6f8fd666b_%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%252520190452.webp 365184 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_6e2c60cd6506_28895_12bbd366ab41_0_cff6f8fd666b_%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%252520190452.webp
28894 365185 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_c12c46ee8acf_28895_130da97eba3b_0_2923c8338db4_%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%252520190735.png 365186 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_b171904665ee_28895_130da97eba3b_0_2923c8338db4_%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%252520190735.webp 365187 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_9ad7155c502c_28895_130da97eba3b_0_2923c8338db4_%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%252520190735.webp
28894 365188 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_33ded05ec273_28895_07954e7eb9d1_0_196898b39aaf_%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%252520190757.png 365189 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_6ecf4667a9fe_28895_07954e7eb9d1_0_196898b39aaf_%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%252520190757.webp 365190 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_bc4f493cbff5_28895_07954e7eb9d1_0_196898b39aaf_%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%252520190757.webp
28894 365191 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_4af6c80d093f_28895_eb3af077bebf_0_a56b6bd2c4b0_%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%252520190614.png 365192 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_f6cf5527107e_28895_eb3af077bebf_0_a56b6bd2c4b0_%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%252520190614.webp 365193 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_b52de2161bef_28895_eb3af077bebf_0_a56b6bd2c4b0_%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%252520190614.webp
28894 365194 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_7b944a413e68_28895_9b8b3c3ccc41_0_f19a6b664c33_%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%252520190633.png 365195 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_9130b24e4ca0_28895_9b8b3c3ccc41_0_f19a6b664c33_%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%252520190633.webp 365196 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_43618b4203d0_28895_9b8b3c3ccc41_0_f19a6b664c33_%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%252520190633.webp
28894 365197 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_ee806c60835d_28895_855c169b5a84_0_f1c317904986_%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%252520190704.png 365198 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_990a5ebd9263_28895_855c169b5a84_0_f1c317904986_%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%252520190704.webp 365199 https://s3.timeweb.cloud/482029f9-prod/products__images/28894_bcdc13a6f336_28895_855c169b5a84_0_f1c317904986_%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%252520190704.webp