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

Query time 0.00089

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28946 366191 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_821d4be36599_28947_2fd366ac13f2_0_ec7fce1dcb21_%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%252520173403.png 366192 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_4f1f92ede95d_28947_2fd366ac13f2_0_ec7fce1dcb21_%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%252520173403.webp 366193 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_8ab1c049aba8_28947_2fd366ac13f2_0_ec7fce1dcb21_%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%252520173403.webp
28946 366194 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_40a88076e5dd_28947_fe64c121c2e3_0_a9cd963430ef_%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%252520173446.png 366195 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_1e01d96864a2_28947_fe64c121c2e3_0_a9cd963430ef_%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%252520173446.webp 366196 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_5035a56d00ed_28947_fe64c121c2e3_0_a9cd963430ef_%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%252520173446.webp
28946 366197 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_bca6d8313007_28947_359866b47854_0_dd44b045ce1c_%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%252520173430.png 366198 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_e3846f59ecf7_28947_359866b47854_0_dd44b045ce1c_%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%252520173430.webp 366199 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_3679561adb44_28947_359866b47854_0_dd44b045ce1c_%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%252520173430.webp
28946 366200 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_36171bb24300_28947_d793d06535c0_0_2fa9fae79c46_%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%252520174007.png 366201 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_5d6473bc6031_28947_d793d06535c0_0_2fa9fae79c46_%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%252520174007.webp 366202 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_695836ea13e5_28947_d793d06535c0_0_2fa9fae79c46_%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%252520174007.webp
28946 366203 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_a188c8d4be18_28947_9e3eed2cc53f_0_c8dda0614ba9_%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%252520174024.png 366204 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_97731c95d9ce_28947_9e3eed2cc53f_0_c8dda0614ba9_%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%252520174024.webp 366205 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_504455fb4153_28947_9e3eed2cc53f_0_c8dda0614ba9_%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%252520174024.webp
28946 366206 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_ea903a229fd4_28947_df32284cc48e_0_7806bd60f0ff_%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%252520174039.png 366207 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_e6b29ae635c4_28947_df32284cc48e_0_7806bd60f0ff_%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%252520174039.webp 366208 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_b0522c245351_28947_df32284cc48e_0_7806bd60f0ff_%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%252520174039.webp
28946 366209 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_10c29e72614b_28947_206d1ab28773_0_838150bd2102_%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%252520174150.png 366210 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_fc4cf072484a_28947_206d1ab28773_0_838150bd2102_%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%252520174150.webp 366211 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_ba13b165974e_28947_206d1ab28773_0_838150bd2102_%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%252520174150.webp
28946 366212 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_22ea9e2a337d_28947_c57d2cc2e240_0_2d93ee37eaea_%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%252520174206.png 366213 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_31aa5a5cb320_28947_c57d2cc2e240_0_2d93ee37eaea_%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%252520174206.webp 366214 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_c5674e10779d_28947_c57d2cc2e240_0_2d93ee37eaea_%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%252520174206.webp
28946 366215 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_d5a1766628ca_28947_8e81623db6c6_0_fadd934bcc05_%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%252520174057.png 366216 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_5a8863930102_28947_8e81623db6c6_0_fadd934bcc05_%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%252520174057.webp 366217 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_efc5d5449689_28947_8e81623db6c6_0_fadd934bcc05_%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%252520174057.webp
28946 366218 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_b6ee28ab9cc5_28947_5dee45ab11a4_0_f6444f04859c_%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%252520174135.png 366219 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_643a844eb763_28947_5dee45ab11a4_0_f6444f04859c_%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%252520174135.webp 366220 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_6cfbd6fba65f_28947_5dee45ab11a4_0_f6444f04859c_%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%252520174135.webp
28946 366221 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_850a6615690e_28947_fa61fa2e8548_0_b0cdfacdeb15_%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%252520174120.png 366222 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_128e5d44f2a4_28947_fa61fa2e8548_0_b0cdfacdeb15_%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%252520174120.webp 366223 https://s3.timeweb.cloud/482029f9-prod/products__images/28946_4befcebb3d61_28947_fa61fa2e8548_0_b0cdfacdeb15_%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%252520174120.webp