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

Query time 0.00034

Result

path
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