为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】：select r. from (select tmp.,rownum as rn from ( select log.,log.id as keyid,lt.datatype, CASE WHEN hrm.lastname IS NULL THEN hrmm.lastname ELSE hrm.lastname END AS operatorName, ll.labelname as logtypelabelname ,sm.labelname as logsmalltypelabelname ,tl.labelname as belongtypelabelname,gl.labelname as groupnamelabelname from ecology_biz_log log left join ECOLOGY_BIZ_LOG_TYPE lt on log.logtype=lt.id left join hrmresource hrm on log.userid = hrm.id LEFT JOIN hrmresourcemanager hrmm ON log.userid = hrmm.id left join htmllabelinfo ll on ll.indexid = log.logtypelabel and ll.languageid=7 left join htmllabelinfo sm on sm.indexid = log.logsmalltypelabel and sm.languageid=7 left join htmllabelinfo tl on tl.indexid = log.belongtypelabel and tl.languageid=7 left join htmllabelinfo gl on gl.indexid = log.groupNameLabel and gl.languageid=7 where (isdetail=0 or isdetail is null) and (( 1=1 and logType in ( 2 ) and logSmallType in ( 14 ) and belongTypeTargetId in ( '796522' ) ) or ( 1=1 and logType in ( 2 ) and belongType in ( 14 ) and belongTypeTargetId in ( '1086040','1086041','1086042','1086043','1086044','1086045','1086046','1086047','1086048','1086049','1086050','1086051','1086052','1086053','1086054','1086055','1086056','1086057','1086058' ) ) ) order by log.id desc ) tmp where rownum <= 100 ) r where 1=1 and r.rn>=1;
这个sql为什么不走索引 应该如何优化下