10:10:39 - IsConnectionValid True
10:10:40 - IsConnectionValid True
10:10:41 - IsConnectionValid True
10:10:47 - IsConnectionValid True
10:10:47 - IsConnectionValid True
10:10:49 - IsConnectionValid True
10:10:53 - IsConnectionValid True
10:11:12 - IsConnectionValid True
10:11:12 - 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 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)  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:11:20 - IsConnectionValid True
10:11:37 - IsConnectionValid True
10:11:37 - 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 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)  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:11:39 - IsConnectionValid True
10:11:39 - 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 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 Code LIKE @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:11:40 - IsConnectionValid True
10:11:45 - IsConnectionValid True
10:11:47 - IsConnectionValid True
10:11:52 - IsConnectionValid True
10:12:17 - IsConnectionValid True
10:12:20 - IsConnectionValid True
10:12:25 - IsConnectionValid True
10:12:29 - IsConnectionValid True
10:12:32 - IsConnectionValid True
22:46:37 - IsConnectionValid True
22:46:38 - IsConnectionValid True
22:46:44 - IsConnectionValid True