sql server超时已过期

Question

SELECT a1.LogCard, a1.LogID, a1.LogName, a1.LogBm, a1.LogTime AS 第一次刷卡时间,
a1.clockID AS 门禁1, a2.LogTime AS 第二次刷卡时间, a2.clockID AS 门禁2
FROM LogTable a1 INNER JOIN
LogTable a2 ON a1.LogCard = a2.LogCard AND a1.clockID <> a2.clockID
WHERE (a1.LogTime BETWEEN '2015-01-03 11:00:00' AND '2015-1-03 13:00:00') AND
(a2.LogTime BETWEEN '2015-01-03 11:00:00' AND '2015-01-03 13:00:00') AND
(a2.LogTime =
(SELECT MIN(logtime)
FROM logtable
WHERE logcard = A1.logcard AND logtime > A1.logtime)) AND (DATEDIFF([MINUTE],
a1.LogTime, a2.LogTime) > 3)
从数据库中选出从3门禁到51门禁，或者从51到3门禁相近的两个之间的时间超过3分钟的，如上所示，在sql 2k中提示超时已过期，如何修改？

Answer 1

用sql profiler 监控一下查询语句