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

Query time 0.00035

Result

id name extension type path s3_id creator_id created_at updated_at object_id object_type file_id alt
409780 логотип png image https://s3.timeweb.cloud/482029f9-prod/companies/740_943cc24c1156_logotippng companies/740_943cc24c1156_logotippng 937 1741136875 1741136875 740 company 409780