I need reslove slow query in Camunda7

Camunda 7 Topics
,
1

I am using Camunda to start process, and I get some slow query in my database, how does it happen?

Here is my basic info
Camunda: 7.19.0
Spring boot starter: 2.2.6.RELEASE
MySQL 8.0

Slow Query cost 271 second, and reached 38016 line data

select
  distinct RES.*
from
  (
    SELECT
      SELF.*,
      DEF.NAME_,
      DEF.VERSION_,
      DEF.DEPLOYMENT_ID_
    FROM
      ACT_HI_PROCINST SELF
      LEFT JOIN ACT_RE_PROCDEF DEF ON SELF.PROC_DEF_ID_ = DEF.ID_
      LEFT JOIN ACT_HI_VARINST VI0 ON SELF.PROC_INST_ID_ = VI0.PROC_INST_ID_
    WHERE
      (
        1 = 1
        and DEF.KEY_ in (
          'storefront_apply_process',
          'point_position_challenge',
          'point_position_back'
        )
        and (
          VI0.ID_ IS NOT NULL
          AND VI0.NAME_ = 'COMPLETE_USER_ID'
          and (
            (
              VI0.VAR_TYPE_ is not null
              and VI0.VAR_TYPE_ = 'string'
              and VI0.TEXT_ is not null
              and VI0.TEXT_ = '18984137814'
            )
          )
        )
      )
      and (SELF.TENANT_ID_ is null)
  ) RES
order by
  RES.START_TIME_ desc
LIMIT
  10 OFFSET 0