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

Query time 0.00545

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28783 363742 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_18e117b88c5c_28838_a42bc7fe570b_28783_06ce911d198a_%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%252520014238.png 363743 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_07bd0bbf8dd9_28838_a42bc7fe570b_28783_06ce911d198a_%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%252520014238.webp 363744 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_0c6803618294_28838_a42bc7fe570b_28783_06ce911d198a_%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%252520014238.webp
28783 363745 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_2eb9d4e064a4_28838_583ee2cf2989_28783_9f1f13e3de85_%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%252520014305.png 363746 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_d9d0ddf8b7de_28838_583ee2cf2989_28783_9f1f13e3de85_%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%252520014305.webp 363747 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_9955520dc4a6_28838_583ee2cf2989_28783_9f1f13e3de85_%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%252520014305.webp
28783 363748 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_dbc635d178a9_28838_9e41304e64cc_28783_02d328690227_%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%252520014324.png 363749 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_213767a88ce8_28838_9e41304e64cc_28783_02d328690227_%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%252520014324.webp 363750 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_0ee9d280e8eb_28838_9e41304e64cc_28783_02d328690227_%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%252520014324.webp
28783 363751 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_6118fffc70a8_28838_20b2e66b5d54_28783_b78d45b7c45b_%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%252520014341.png 363752 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_474c267c2705_28838_20b2e66b5d54_28783_b78d45b7c45b_%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%252520014341.webp 363753 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_b4570c23ea49_28838_20b2e66b5d54_28783_b78d45b7c45b_%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%252520014341.webp
28783 363754 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_b9751a816dd0_28838_ed413f5706d5_28783_be763082bec6_%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%252520014402.png 363755 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_1fb222be2319_28838_ed413f5706d5_28783_be763082bec6_%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%252520014402.webp 363756 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_46e2229a6e8b_28838_ed413f5706d5_28783_be763082bec6_%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%252520014402.webp
28783 363757 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_debde90cece9_28838_e9487830ae10_28783_e0aded7ba6c8_%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%252520014419.png 363758 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_f52ab7c8507d_28838_e9487830ae10_28783_e0aded7ba6c8_%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%252520014419.webp 363759 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_c8055e1702c3_28838_e9487830ae10_28783_e0aded7ba6c8_%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%252520014419.webp
28783 363760 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_7082c19dd5ed_28838_888252ea5056_28783_204d944d5337_%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%252520014440.png 363761 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_8639682418b4_28838_888252ea5056_28783_204d944d5337_%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%252520014440.webp 363762 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_1d492d99d607_28838_888252ea5056_28783_204d944d5337_%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%252520014440.webp
28783 363763 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_6bcfde66ced4_28838_81cdfdd7f0ed_28783_7835a3a94eb2_%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%252520014457.png 363764 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_df221eefc885_28838_81cdfdd7f0ed_28783_7835a3a94eb2_%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%252520014457.webp 363765 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_92d747c24577_28838_81cdfdd7f0ed_28783_7835a3a94eb2_%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%252520014457.webp
28783 363766 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_9ac6e1fee219_28838_854ef81fc14f_28783_19309435e200_%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%252520014530.png 363767 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_88811c185cdc_28838_854ef81fc14f_28783_19309435e200_%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%252520014530.webp 363768 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_a863f783da19_28838_854ef81fc14f_28783_19309435e200_%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%252520014530.webp
28783 363769 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_a5e945af4480_28838_ff53a7326665_28783_db5a3dad10df_%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%252520014515.png 363770 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_2d6eb8b4b409_28838_ff53a7326665_28783_db5a3dad10df_%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%252520014515.webp 363771 https://s3.timeweb.cloud/482029f9-prod/products__images/28783_b20dfbbec578_28838_ff53a7326665_28783_db5a3dad10df_%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%252520014515.webp