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

Query time 0.00053

Result

id name extension type path s3_id creator_id created_at updated_at object_id object_type file_id alt
409416 Лого jpeg image https://s3.timeweb.cloud/482029f9-prod/companies/733_138d3f83d7b6_logojpeg companies/733_138d3f83d7b6_logojpeg 929 1741091898 1741091898 733 company 409416