11:49:25 - IsConnectionValid True
11:49:25 - IsConnectionValid True
11:49:25 - IsConnectionValid True
11:49:31 - IsConnectionValid True
11:49:31 - IsConnectionValid True
11:49:34 - IsConnectionValid True
11:49:34 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
11:49:34 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
11:49:34 - 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
11:49:34 - 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
11:49:34 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 15
11:49:34 - 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 1
11:49:34 - 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
11:49:34 - 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 2
11:49:34 - IsConnectionValid True
11:49:42 - IsConnectionValid True
11:49:42 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:29:13 - IsConnectionValid True
14:29:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:29:14 - IsConnectionValid True
14:29:18 - IsConnectionValid True
14:29:23 - IsConnectionValid True
14:29:23 - SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
14:29:23 - IsConnectionValid True
14:29:23 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:29:25 - IsConnectionValid True
14:29:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND Code LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:29:26 - IsConnectionValid True
14:29:32 - IsConnectionValid True
14:29:32 - IsConnectionValid True