15:35:33 - IsConnectionValid True
15:35:37 - IsConnectionValid True
15:35:41 - IsConnectionValid True
15:35:41 - IsConnectionValid True
15:35:46 - IsConnectionValid True
15:35:46 - IsConnectionValid True
15:35:47 - IsConnectionValid True
15:35:50 - IsConnectionValid True
15:35:52 - IsConnectionValid True
15:35:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:35:54 - IsConnectionValid True
15:35:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >07/05/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:35:56 - IsConnectionValid True
15:35:56 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:36:02 - IsConnectionValid True
15:36:04 - IsConnectionValid True
15:36:04 - 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, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:04 - IsConnectionValid True
15:36:04 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
15:36:05 - IsConnectionValid True
15:36:05 - IsConnectionValid True
15:36:06 - IsConnectionValid True
15:36:06 - IsConnectionValid True
15:36:06 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:36:08 - IsConnectionValid True
15:36:08 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >07/05/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:09 - IsConnectionValid True
15:36:09 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
15:36:10 - IsConnectionValid True
15:36:10 - 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, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:10 - IsConnectionValid True
15:36:10 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
15:36:36 - IsConnectionValid True
15:36:36 - IsConnectionValid True
15:36:36 - IsConnectionValid True
15:36:36 - SELECT  DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   ID = @val0 and TenantID = @val1  Query