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

Query time 0.00049

Result

id name extension type path s3_id creator_id created_at updated_at object_id object_type file_id alt
359942 Изображение WhatsApp 2024-11-28 в 01.27.19_93bc391c jpeg image https://s3.timeweb.cloud/482029f9-prod/companies__images/696_c7213669e560_%D0%98%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5%20WhatsApp%202024-11-28%20%D0%B2%2001.27.19_93bc391c.jpeg companies__images/696_c7213669e560_Изображение WhatsApp 2024-11-28 в 01.27.19_93bc391c.jpeg 885 1733929862 1733929862 696 company 359942