10:30:11 - IsConnectionValid True
10:30:12 - IsConnectionValid True
10:30:12 - IsConnectionValid True
10:30:17 - IsConnectionValid True
10:30:17 - IsConnectionValid True
10:30:20 - IsConnectionValid True
10:30:25 - IsConnectionValid True
10:30:25 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:30:31 - IsConnectionValid True
10:30:31 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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 EnglishName LIKE '%1%' ) ORDER BY ID ASC  Query
10:30:31 - IsConnectionValid True
10:30:31 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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
10:30:34 - IsConnectionValid True
10:30:34 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, 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
10:30:40 - IsConnectionValid True