11:04:13 - IsConnectionValid True
11:04:18 - IsConnectionValid True
11:04:18 - IsConnectionValid True
11:04:26 - IsConnectionValid True
11:04:26 - IsConnectionValid True
11:04:27 - IsConnectionValid True
11:05:25 - IsConnectionValid True
11:18:09 - IsConnectionValid True
11:18:23 - IsConnectionValid True
11:18:23 - IsConnectionValid True
11:18:23 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption <> @val1 AND IsOtherOption <> @val2 ORDER BY ItemOrder  Query
11:18:23 - IsConnectionValid True
11:18:23 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:18:55 - IsConnectionValid True
11:18:57 - IsConnectionValid True
11:18:57 - IsConnectionValid True
11:18:57 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption <> @val1 AND IsOtherOption <> @val2 ORDER BY ItemOrder  Query
11:18:57 - IsConnectionValid True
11:18:57 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:29:52 - IsConnectionValid True
12:07:27 - IsConnectionValid True
12:07:27 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM CourseTypeDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:07:33 - IsConnectionValid True
12:07:38 - IsConnectionValid True
12:07:39 - IsConnectionValid True
12:07:44 - IsConnectionValid True
12:07:54 - IsConnectionValid True
12:07:58 - IsConnectionValid True
12:07:58 - IsConnectionValid True
12:07:58 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
12:07:58 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
12:07:58 - IsConnectionValid True
12:09:41 - IsConnectionValid True
12:10:33 - IsConnectionValid True
12:11:13 - IsConnectionValid True
12:11:18 - IsConnectionValid True
12:11:22 - IsConnectionValid True
12:28:45 - IsConnectionValid True
12:29:35 - IsConnectionValid True
12:29:46 - IsConnectionValid True
15:32:30 - IsConnectionValid True
15:32:30 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:37 - IsConnectionValid True
15:36:04 - IsConnectionValid True
15:36:04 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwVacationDays  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:09 - IsConnectionValid True
15:36:09 - 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, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:19 - IsConnectionValid True
15:36:19 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwVacationDays  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:22 - IsConnectionValid True
15:36:22 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwVacationDays  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:23 - IsConnectionValid True
15:36:25 - IsConnectionValid True
15:40:14 - IsConnectionValid True
15:40:14 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
15:40:14 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
15:40:22 - IsConnectionValid True
15:40:48 - IsConnectionValid True
15:40:48 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM DoctorDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:51 - IsConnectionValid True
15:40:54 - IsConnectionValid True
15:40:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM DoctorDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow