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

Query time 0.00052

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
32489 404335 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_367227c8a1f3_32490_ec7756aa3639_0_cf328582fe1c_unnamed.jpg 404336 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_77f3cf37ac42_32490_ec7756aa3639_0_cf328582fe1c_unnamed.webp 404337 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_6a4a8d4729b8_32490_ec7756aa3639_0_cf328582fe1c_unnamed.webp
32489 404338 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_74f4cb93bab9_32490_56f64198728d_0_9f68ca70014c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202024-04-16%252520%2525D0%2525B2%25252014.06.43_c978353c.jpg 404339 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_4775fb0d1bb0_32490_56f64198728d_0_9f68ca70014c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202024-04-16%252520%2525D0%2525B2%25252014.06.43_c978353c.webp 404340 https://s3.timeweb.cloud/482029f9-prod/products__images/32489_f193d676a039_32490_56f64198728d_0_9f68ca70014c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202024-04-16%252520%2525D0%2525B2%25252014.06.43_c978353c.webp