复制Count: 3276 Time=21.75s (71261s) Lock=0.00s (1s) Rows=0.9 (2785),优引还 xxxSELECT T.TASK_ID,T.xx,T.xx,...FROM T_xx_TASK TWHERE N=NAND T.STATUS IN (N,N,N)AND IFNULL(T.MAX_OPEN_TIMES,N) > IFNULL(T.OPEN_TIMES,N)AND (T.CLOSE_DATE IS NULL OR T.CLOSE_DATE >= SUBDATE(NOW(),INTERVAL S MINUTE))AND T.REL_DEVTYPE = NAND T.REL_DEVID = NAND T.TASK_DATE >= SAND T.TASK_DATE <= SORDER BY TASK_ID DESCLIMIT N,N1.

(责任编辑：IT科技)