SELECT A.FULLDPID FULLID,
A.EXTENDID,
A.ID,
A.OUTID,
A.NAME,
A.AREANAME,
A.TERMNAME,
A.EXTENDNAME,
A.OPERTIME,
A.UPLOADTIME,
A.RECORDTYPE,
A.TYPENAME,
A.CUSTDEPTID,
A.DEPTNAME,
A.POSCODE,
A.CARDSNR,
A.EXTENDID EXTENDTERMID,
A.DPID,
A.AREAID,
A.SYSTEMID,
0 ISTHIRD,
'系统' THIRDNAME,
A.PWDINFO,
0 AS CAPTUREID,
A.PHOTOGUID,
A.IDENTITYTYPE,
A.IOFLAG,
A.CERTIFICATEID1,
A.CERTIFICATENO1,
A.ACCCODE,
(
CASE `A`.`SEX`
WHEN 1 THEN
'男'
WHEN 0 THEN
'女'
END
) AS `SEX`,
A.USERID
FROM id_recordnew A where (A.Systemid = '48' ) and A.DPID=15 AND A.OPERTIME BETWEEN str_to_date('2019-11-01 00:00:00','%Y-%m-%d %H:%i:%s') AND str_to_date('2020-04-15 23:59:59','%Y-%m-%d %H:%i:%s') ORDER BY A.ID desc LIMIT 10000000,10
有索引