select EventClass, TextData,ApplicationName,HostName,NTUserName,CPU,Reads,Writes,Duration/1000 as time,StartTime,EndTime,DatabaseName from dbo.TraceCMS_new where duration/1000>1000 and EventClass<>12 and EventClass<>15 order by starttime desc