Sandbox

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

Query time 0.00104

Result

product_id	file_id	file	big_file_id	big_file	small_file_id	small_file
28974	367630	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_6b9585a39afc_28975_2bb25901dafb_0_003ca094277b_%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-19%252520140949.png	367631	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_df0dcc8e1da2_28975_2bb25901dafb_0_003ca094277b_%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-19%252520140949.webp	367632	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_f9c682faf513_28975_2bb25901dafb_0_003ca094277b_%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-19%252520140949.webp
28974	367633	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_158fb9e0fad4_28975_6287d313af80_0_a7f6494ac261_%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-19%252520141034.png	367634	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_27f488aa0799_28975_6287d313af80_0_a7f6494ac261_%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-19%252520141034.webp	367635	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_a059ec353961_28975_6287d313af80_0_a7f6494ac261_%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-19%252520141034.webp
28974	367636	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_23c7f4169725_28975_a2b0552979d4_0_887125e1a697_%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-19%252520141059.png	367638	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_96ea5ca24d06_28975_a2b0552979d4_0_887125e1a697_%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-19%252520141059.webp	367640	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_4d4f7317cf13_28975_a2b0552979d4_0_887125e1a697_%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-19%252520141059.webp
28974	367643	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_71af279981a7_28975_0b26e904ded0_0_9fe71297bf0e_%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-19%252520141122.png	367645	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_54865be905c8_28975_0b26e904ded0_0_9fe71297bf0e_%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-19%252520141122.webp	367646	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_2969f5edf84b_28975_0b26e904ded0_0_9fe71297bf0e_%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-19%252520141122.webp
28974	367648	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_6be52e39731e_28975_2348ae91c71a_0_a5e6ac8389b9_%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-19%252520141205.png	367650	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_b9238c88518f_28975_2348ae91c71a_0_a5e6ac8389b9_%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-19%252520141205.webp	367652	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_11c5e39a2d86_28975_2348ae91c71a_0_a5e6ac8389b9_%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-19%252520141205.webp
28974	367654	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_db811b29a255_28975_9af6c69e3e27_0_82171a2e4244_%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-19%252520141330.png	367656	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_9bc1c55a41ed_28975_9af6c69e3e27_0_82171a2e4244_%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-19%252520141330.webp	367658	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_958411c4cbcc_28975_9af6c69e3e27_0_82171a2e4244_%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-19%252520141330.webp
28974	367675	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_dc4d9e361de3_28975_fa5808f02559_0_61be826a80ef_%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-19%252520141144.png	367676	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_7aa6e2a657dd_28975_fa5808f02559_0_61be826a80ef_%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-19%252520141144.webp	367677	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_42d621b94e60_28975_fa5808f02559_0_61be826a80ef_%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-19%252520141144.webp
28974	367678	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_dd9c84850a02_28975_c47ced63b0e2_0_cffa731113f7_%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-19%252520141230.png	367679	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_60dd701e7f74_28975_c47ced63b0e2_0_cffa731113f7_%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-19%252520141230.webp	367680	https://s3.timeweb.cloud/482029f9-prod/products__images/28974_e89e1cbe897d_28975_c47ced63b0e2_0_cffa731113f7_%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-19%252520141230.webp