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

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
28964 366940 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_a48096532632_28965_fa7bff4d6b09_0_5017248edfc6_%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%252520162553.png 366941 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_b801767822d0_28965_fa7bff4d6b09_0_5017248edfc6_%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%252520162553.webp 366942 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_6b34651e0ad9_28965_fa7bff4d6b09_0_5017248edfc6_%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%252520162553.webp
28964 366943 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_bf99928d0727_28965_48ac5eca719d_0_6ac664eff250_%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%252520162640.png 366944 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_4714992ca4c3_28965_48ac5eca719d_0_6ac664eff250_%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%252520162640.webp 366945 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_0735276ab99a_28965_48ac5eca719d_0_6ac664eff250_%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%252520162640.webp
28964 366946 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_5a527c9c0262_28965_42fd667088c4_0_78b7ffb941b3_%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%252520162658.png 366947 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_e6ec605b9a95_28965_42fd667088c4_0_78b7ffb941b3_%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%252520162658.webp 366948 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_35586fc6b5c7_28965_42fd667088c4_0_78b7ffb941b3_%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%252520162658.webp
28964 366949 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_059d2da8d557_28965_1efee0834cd8_0_e7cc5561bb83_%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%252520162732.png 366950 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_afb45f44a68d_28965_1efee0834cd8_0_e7cc5561bb83_%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%252520162732.webp 366951 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_906575884466_28965_1efee0834cd8_0_e7cc5561bb83_%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%252520162732.webp
28964 366952 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_e5a271310f22_28965_c369f3f1a285_0_0990b1c4c5bb_%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%252520162752.png 366953 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_30df142a47c8_28965_c369f3f1a285_0_0990b1c4c5bb_%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%252520162752.webp 366954 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_f4243122871a_28965_c369f3f1a285_0_0990b1c4c5bb_%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%252520162752.webp
28964 366955 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_23fe5454ec7f_28965_dfc9dc6a4b6a_0_b3036f3bb6b4_%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%252520162820.png 366956 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_a1374d9ca492_28965_dfc9dc6a4b6a_0_b3036f3bb6b4_%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%252520162820.webp 366957 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_51e2c78e2a94_28965_dfc9dc6a4b6a_0_b3036f3bb6b4_%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%252520162820.webp
28964 366958 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_ebdc5b048b04_28965_15ca37700a80_0_96e8c0d3d7e1_%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%252520162857.png 366959 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_73dd1021cfcc_28965_15ca37700a80_0_96e8c0d3d7e1_%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%252520162857.webp 366960 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_c91884188a79_28965_15ca37700a80_0_96e8c0d3d7e1_%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%252520162857.webp
28964 366961 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_5db5aefc547d_28965_9df6a59f467e_0_f455419f4e9f_%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%252520163001.png 366962 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_54e80264c758_28965_9df6a59f467e_0_f455419f4e9f_%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%252520163001.webp 366963 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_b07854d44ada_28965_9df6a59f467e_0_f455419f4e9f_%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%252520163001.webp
28964 366964 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_bd36b1a5bfe9_28965_6d596f2a8c3c_0_fc79c0b54008_%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%252520170813.png 366965 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_b4031f3a0337_28965_6d596f2a8c3c_0_fc79c0b54008_%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%252520170813.webp 366966 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_453b2f5b11f3_28965_6d596f2a8c3c_0_fc79c0b54008_%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%252520170813.webp
28964 366967 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_b7b0df46ad2f_28965_764f827748f7_0_211cf491047b_%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%252520170843.png 366968 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_ebae866fa7a4_28965_764f827748f7_0_211cf491047b_%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%252520170843.webp 366969 https://s3.timeweb.cloud/482029f9-prod/products__images/28964_96ffcc365ec0_28965_764f827748f7_0_211cf491047b_%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%252520170843.webp