09:35:46 - IsConnectionValid True
09:35:46 - IsConnectionValid True
09:35:47 - IsConnectionValid True
09:35:58 - IsConnectionValid True
09:35:58 - IsConnectionValid True
09:36:14 - IsConnectionValid True
09:36:15 - IsConnectionValid True
09:39:06 - IsConnectionValid True
09:39:07 - IsConnectionValid True
09:39:46 - IsConnectionValid True
09:39:47 - IsConnectionValid True
09:46:03 - IsConnectionValid True
09:46:03 - IsConnectionValid True
09:47:16 - IsConnectionValid True
09:47:23 - IsConnectionValid True
09:47:24 - IsConnectionValid True
09:48:05 - IsConnectionValid True
09:48:06 - IsConnectionValid True
09:49:06 - IsConnectionValid True
09:49:07 - IsConnectionValid True
10:34:51 - IsConnectionValid True
10:34:53 - IsConnectionValid True
10:34:58 - IsConnectionValid True
10:34:58 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:35:02 - IsConnectionValid True
10:35:02 - 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 = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE()))  and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:35:03 - IsConnectionValid True
10:35:03 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
10:35:04 - IsConnectionValid True
10:35:04 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:35:05 - IsConnectionValid True
10:35:05 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
10:35:05 - IsConnectionValid True
10:35:05 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
10:35:15 - IsConnectionValid True
10:35:15 - SELECT  DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
10:35:15 - IsConnectionValid True
10:35:15 - IsConnectionValid True
10:35:15 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
10:35:15 - SELECT  DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE  TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1)  Query
10:35:21 - IsConnectionValid True
11:23:33 - IsConnectionValid True
11:23:34 - IsConnectionValid True
11:23:34 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
11:23:36 - IsConnectionValid True
11:23:37 - IsConnectionValid True
11:24:22 - IsConnectionValid True
11:24:23 - IsConnectionValid True
11:25:34 - IsConnectionValid True
11:25:35 - IsConnectionValid True
11:25:48 - IsConnectionValid True
11:25:49 - IsConnectionValid True
11:26:42 - IsConnectionValid True
11:26:43 - IsConnectionValid True
11:27:51 - IsConnectionValid True
11:27:52 - IsConnectionValid True
11:31:11 - IsConnectionValid True
11:31:12 - IsConnectionValid True
11:32:30 - IsConnectionValid True
11:32:31 - IsConnectionValid True
11:33:34 - IsConnectionValid True
11:33:35 - IsConnectionValid True
11:34:43 - IsConnectionValid True
11:34:44 - IsConnectionValid True
11:36:28 - IsConnectionValid True
11:36:29 - IsConnectionValid True
11:38:02 - IsConnectionValid True
11:38:03 - IsConnectionValid True
11:38:38 - IsConnectionValid True
11:38:39 - IsConnectionValid True
11:38:50 - IsConnectionValid True
11:38:51 - IsConnectionValid True
11:39:02 - IsConnectionValid True
11:39:03 - IsConnectionValid True
11:40:45 - IsConnectionValid True
11:40:46 - IsConnectionValid True
11:41:30 - IsConnectionValid True
11:41:31 - IsConnectionValid True
11:45:49 - IsConnectionValid True
11:45:50 - IsConnectionValid True
11:46:44 - IsConnectionValid True
11:46:45 - IsConnectionValid True
11:47:25 - IsConnectionValid True
11:47:26 - IsConnectionValid True
11:48:21 - IsConnectionValid True
11:48:22 - IsConnectionValid True
11:49:06 - IsConnectionValid True
11:49:07 - IsConnectionValid True
11:49:35 - IsConnectionValid True
11:49:36 - IsConnectionValid True
11:52:34 - IsConnectionValid True
11:52:35 - IsConnectionValid True
11:59:08 - IsConnectionValid True
11:59:09 - IsConnectionValid True
12:00:21 - IsConnectionValid True
12:00:22 - IsConnectionValid True
12:01:23 - IsConnectionValid True
12:01:23 - IsConnectionValid True
13:05:53 - IsConnectionValid True
13:05:53 - IsConnectionValid True
13:06:03 - IsConnectionValid True
13:06:04 - IsConnectionValid True
13:07:48 - IsConnectionValid True
13:07:49 - IsConnectionValid True
13:08:39 - IsConnectionValid True
13:08:40 - IsConnectionValid True
13:10:32 - IsConnectionValid True
13:10:33 - IsConnectionValid True
13:14:12 - IsConnectionValid True
13:14:13 - IsConnectionValid True
13:14:37 - IsConnectionValid True
13:14:38 - IsConnectionValid True
13:15:10 - IsConnectionValid True
13:15:11 - IsConnectionValid True
13:24:12 - IsConnectionValid True
13:34:28 - IsConnectionValid True
13:34:29 - IsConnectionValid True
13:34:48 - IsConnectionValid True
13:34:49 - IsConnectionValid True