00:00:07 - IsConnectionValid True
00:00:08 - IsConnectionValid True
00:00:08 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
00:00:10 - IsConnectionValid True
00:00:10 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees WHERE  TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE '%1%') ORDER BY Code ASC  Query
00:00:10 - IsConnectionValid True
00:00:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:00:18 - IsConnectionValid True
00:00:18 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val6  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:00:24 - IsConnectionValid True
00:00:26 - IsConnectionValid True
00:01:21 - IsConnectionValid True
00:01:21 - IsConnectionValid True
00:01:21 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
00:26:52 - IsConnectionValid True
00:26:52 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees WHERE  TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE '%1%') ORDER BY Code ASC  Query
00:26:52 - IsConnectionValid True
00:26:52 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:26:56 - IsConnectionValid True
00:26:56 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val6  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:26:59 - IsConnectionValid True
00:27:21 - IsConnectionValid True
00:29:20 - IsConnectionValid True
00:29:24 - IsConnectionValid True
00:29:24 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
00:29:26 - IsConnectionValid True
00:29:26 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees WHERE  TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND DateLeft ='01/01/1900' AND (Code LIKE '%1%'  OR Name LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY Code ASC  Query
00:29:26 - IsConnectionValid True
00:29:26 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND DateLeft ='01/01/1900'  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:29:30 - IsConnectionValid True
00:29:30 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND DateLeft ='01/01/1900' AND EnglishName LIKE @val6  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:29:46 - IsConnectionValid True
00:29:50 - IsConnectionValid True
00:29:50 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
00:30:04 - IsConnectionValid True
00:30:07 - IsConnectionValid True
00:30:08 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
00:30:09 - IsConnectionValid True
00:30:09 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees WHERE  TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND ISNULL(DateLeft,'01/01/1900') <>'01/01/1900' AND (Code LIKE '%1%'  OR Name LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY Code ASC  Query
00:30:10 - IsConnectionValid True
00:30:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND ISNULL(DateLeft,'01/01/1900') <>'01/01/1900'  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
00:30:13 - IsConnectionValid True
00:30:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM vwEmployees  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND ISNULL(DateLeft,'01/01/1900') <>'01/01/1900' AND EnglishName LIKE @val6  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow