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

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
32915 412411 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_833bea9e10ca_33326_e9358ee90b01_32915_25933e72faa8_32916_81542b7d10e6_0_f985ff4b44d2_WhatsApp252520Image252520202 412412 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_4f804a005bf4_33326_e9358ee90b01_32915_25933e72faa8_32916_81542b7d10e6_0_f985ff4b44d2_WhatsApp252520Image252520202 412413 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_78371ae0a57e_33326_e9358ee90b01_32915_25933e72faa8_32916_81542b7d10e6_0_f985ff4b44d2_WhatsApp252520Image252520202
32915 412414 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_1cd811ba3aef_33326_ecc342971696_32915_ab9bd3137f2b_32916_22a1cedce9a9_0_201407a9d3df_WhatsApp252520Image252520202 412415 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_3ebbf5fd5c9a_33326_ecc342971696_32915_ab9bd3137f2b_32916_22a1cedce9a9_0_201407a9d3df_WhatsApp252520Image252520202 412416 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_b6e690957c3d_33326_ecc342971696_32915_ab9bd3137f2b_32916_22a1cedce9a9_0_201407a9d3df_WhatsApp252520Image252520202
32915 412417 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_176fb082715c_33326_415c1db09f94_32915_12d072d04f61_32916_af5717153a9a_0_3e6878e1eabd_WhatsApp252520Image252520202 412418 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_95e1114cc45f_33326_415c1db09f94_32915_12d072d04f61_32916_af5717153a9a_0_3e6878e1eabd_WhatsApp252520Image252520202 412419 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_41a55d2b9a75_33326_415c1db09f94_32915_12d072d04f61_32916_af5717153a9a_0_3e6878e1eabd_WhatsApp252520Image252520202
32915 412420 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_11a67d83e694_33326_14540e8eb565_32915_45be20cbf373_32916_263dae995bf2_0_6d959686f3c7_WhatsApp252520Image252520202 412421 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_4cd0f23b553d_33326_14540e8eb565_32915_45be20cbf373_32916_263dae995bf2_0_6d959686f3c7_WhatsApp252520Image252520202 412422 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_0ac14a425472_33326_14540e8eb565_32915_45be20cbf373_32916_263dae995bf2_0_6d959686f3c7_WhatsApp252520Image252520202
32915 412423 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_5199ce5fb88a_33326_d75174559ebf_32915_d7230b638226_32916_75545d888414_0_8a68dcec0950_WhatsApp252520Image252520202 412424 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_076d8cfdd5de_33326_d75174559ebf_32915_d7230b638226_32916_75545d888414_0_8a68dcec0950_WhatsApp252520Image252520202 412425 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_aa66c1ade04b_33326_d75174559ebf_32915_d7230b638226_32916_75545d888414_0_8a68dcec0950_WhatsApp252520Image252520202
32915 412426 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_c57a2ad0dc18_33326_664b9811db25_32915_60aca029dee5_32916_6492f861ccd2_0_65bfeb8b49a7_WhatsApp252520Image252520202 412427 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_7336a18ace3b_33326_664b9811db25_32915_60aca029dee5_32916_6492f861ccd2_0_65bfeb8b49a7_WhatsApp252520Image252520202 412428 https://s3.timeweb.cloud/482029f9-prod/products__images/32915_8b1664a89230_33326_664b9811db25_32915_60aca029dee5_32916_6492f861ccd2_0_65bfeb8b49a7_WhatsApp252520Image252520202