16:26:07 - IsConnectionValid True
16:26:07 - IsConnectionValid True
16:26:08 - IsConnectionValid True
16:26:14 - IsConnectionValid True
16:26:17 - IsConnectionValid True
16:26:17 - IsConnectionValid True
16:26:20 - IsConnectionValid True
16:26:20 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
16:26:20 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
16:26:20 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
16:26:20 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
16:26:20 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 17
16:26:20 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 0
16:26:20 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
16:26:20 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 1
16:26:20 - IsConnectionValid True
16:26:22 - IsConnectionValid True
16:26:35 - IsConnectionValid True
16:26:35 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND   TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo  Query
16:26:37 - IsConnectionValid True
16:26:46 - IsConnectionValid True