slow.sql

SELECT DISTINCT agents.id AS id FROM agents
    LEFT JOIN users          ON agents.id = users.agent
    LEFT JOIN offices        ON agents.office_mui = offices.matrix_unique_id
    LEFT JOIN brands_offices ON offices.id = brands_offices.office
    LEFT JOIN brands_users   ON users.id = brands_users.user
  WHERE (
    (
      brands_offices.brand = '745e77aa-4ddf-11e6-a07d-f23c91b0d077'
    )
    OR
    (
      brands_users.brand = '745e77aa-4ddf-11e6-a07d-f23c91b0d077'
    )
  );