SELECT 
  `F`.`path` 
FROM 
  `files` AS `F` 
  LEFT JOIN `files__images` AS `FI` ON `F`.`id` = `FI`.`file_id` 
WHERE 
  `FI`.`object_id` = 592 
  AND `FI`.`object_type` = 'company'

Query time 0.00074

Result

path
https://s3.timeweb.cloud/482029f9-prod/companies__images/592_adc6849a9955_%25D0%25BB%25D0%25BE%25D0%25B3%25D0%25BE_%25D0%25BC%25D0%25B0%25D1%2580%25D0%25BA%25D0%25B5%25D1%2582%25D0%25BF%25D0%25BB%25D0%25B5%25D0%25B9%25D1%2581_g4ox-pv.png
https://s3.timeweb.cloud/482029f9-prod/companies__images/592_a3cc606f2fc1_%D0%9B%D0%BE%D0%B3%D0%BE%D1%82%D0%B8%D0%BF.png