MySQL 查询优化性能答案

MySQL 查询优化性能答案

您能否帮我优化一下这个查询：

SELECT
  case when EXISTS (
    SELECT
      1
    FROM
      usergroups item_t1
    WHERE
      (item_t0.p_b2bunits = item_t1.p_uid)
      AND (item_t1.TypePkString = 8796095217746)
  ) THEN true ELSE false END as active,
  item_t0.p_b2bunits as code,
  item_t0.p_accountname as name1,
  item_t0.p_accountnameextension as name2,
  case when EXISTS (
    SELECT
      1
    FROM
      user2salreprelation item_t2
    WHERE
      (
        item_t2.SourcePK = item_t0.PK
        and item_t2.TargetPK = 8828959653892
      )
      AND (item_t2.TypePkString = 8796150399058)
  ) THEN true ELSE false END as isFav
FROM
  account2salesrep item_t0
WHERE
  (
    item_t0.p_showondashboard = 1
    AND item_t0.p_district = '4'
    AND (
      LOWER(item_t0.p_accountname) LIKE CONCAT('%', CONCAT('crampel alu', '%'))
      OR LOWER(item_t0.p_accountnameextension) LIKE CONCAT('%', CONCAT('crampel alu', '%'))
      OR LOWER(item_t0.p_b2bunits) LIKE CONCAT('%', CONCAT('crampel alu', '%'))
    )
  )
  AND (item_t0.TypePkString = 8796149842002)
order by
  item_t0.p_accountname
LIMIT
  0, 11;