SELECT 
  * 
FROM 
  `files` 
  LEFT JOIN `files__images` ON `files`.`id` = `files__images`.`file_id` 
WHERE 
  `files__images`.`object_id` = 692 
  AND `files__images`.`object_type` = 'company'

Query time 0.00042

Result

id name extension type path s3_id creator_id created_at updated_at object_id object_type file_id alt
358698 Лого горизонт jpeg image https://s3.timeweb.cloud/482029f9-prod/companies__images/692_98ce99ac1f0a_%D0%9B%D0%BE%D0%B3%D0%BE%20%D0%B3%D0%BE%D1%80%D0%B8%D0%B7%D0%BE%D0%BD%D1%82.jpeg companies__images/692_98ce99ac1f0a_Лого горизонт.jpeg 881 1733657250 1733657250 692 company 358698