12:04:31 - IsConnectionValid True
12:04:40 - IsConnectionValid True
12:04:40 - IsConnectionValid True
12:04:45 - IsConnectionValid True
12:04:45 - IsConnectionValid True
12:04:48 - IsConnectionValid True
12:05:00 - IsConnectionValid True
12:05:16 - IsConnectionValid True
12:05:25 - IsConnectionValid True
12:07:59 - IsConnectionValid True
12:10:52 - IsConnectionValid True
12:15:12 - IsConnectionValid True
12:15:15 - IsConnectionValid True
12:15:17 - IsConnectionValid True
12:16:29 - IsConnectionValid True
12:21:39 - IsConnectionValid True
12:21:52 - IsConnectionValid True
12:21:55 - IsConnectionValid True
12:21:55 - IsConnectionValid True
12:23:04 - IsConnectionValid True
12:23:07 - IsConnectionValid True
12:28:37 - IsConnectionValid True
12:29:00 - IsConnectionValid True
12:29:00 - IsConnectionValid True
12:30:00 - IsConnectionValid True
12:30:15 - IsConnectionValid True
12:30:18 - IsConnectionValid True
12:52:22 - IsConnectionValid True
12:52:24 - IsConnectionValid True
12:52:25 - IsConnectionValid True
12:52:31 - IsConnectionValid True
12:52:39 - IsConnectionValid True
12:53:09 - IsConnectionValid True
13:17:40 - IsConnectionValid True
13:17:42 - IsConnectionValid True
13:17:50 - IsConnectionValid True
13:17:50 - IsConnectionValid True
13:18:57 - IsConnectionValid True
13:19:03 - IsConnectionValid True
14:53:38 - IsConnectionValid True
14:53:43 - IsConnectionValid True
14:53:45 - IsConnectionValid True
14:53:53 - IsConnectionValid True
14:54:24 - IsConnectionValid True
14:54:29 - IsConnectionValid True
14:55:50 - IsConnectionValid True
15:03:57 - IsConnectionValid True
15:04:04 - IsConnectionValid True
15:04:19 - IsConnectionValid True
15:05:09 - IsConnectionValid True
15:05:14 - IsConnectionValid True
15:05:20 - IsConnectionValid True
15:05:27 - IsConnectionValid True
15:05:28 - IsConnectionValid True
15:25:34 - IsConnectionValid True
15:27:12 - IsConnectionValid True
15:28:37 - IsConnectionValid True
15:28:48 - IsConnectionValid True
15:28:48 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM VWDEPARTMENTS  WHERE   TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0)  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:28:57 - IsConnectionValid True
15:29:15 - IsConnectionValid True
15:29:18 - IsConnectionValid True
15:29:27 - IsConnectionValid True
15:29:28 - IsConnectionValid True
15:29:32 - IsConnectionValid True
15:29:34 - IsConnectionValid True
15:29:46 - IsConnectionValid True
15:29:48 - IsConnectionValid True
15:31:33 - IsConnectionValid True
15:31:33 - IsConnectionValid True
15:31:38 - IsConnectionValid True
15:31:40 - IsConnectionValid True
15:31:46 - IsConnectionValid True
15:32:14 - IsConnectionValid True
15:32:18 - IsConnectionValid True
15:32:43 - IsConnectionValid True
15:32:46 - IsConnectionValid True
15:32:46 - IsConnectionValid True
15:32:46 - IsConnectionValid True
15:32:56 - IsConnectionValid True
15:33:00 - IsConnectionValid True
15:33:05 - IsConnectionValid True
15:33:05 - IsConnectionValid True
15:33:11 - IsConnectionValid True
15:33:43 - IsConnectionValid True
15:33:55 - IsConnectionValid True
15:36:28 - IsConnectionValid True
15:36:31 - IsConnectionValid True
15:36:46 - IsConnectionValid True
15:38:00 - IsConnectionValid True
15:39:12 - IsConnectionValid True
15:39:52 - IsConnectionValid True
15:39:54 - IsConnectionValid True
15:39:55 - IsConnectionValid True
15:39:56 - IsConnectionValid True
15:40:08 - IsConnectionValid True
15:40:13 - IsConnectionValid True
15:40:34 - IsConnectionValid True
15:40:39 - IsConnectionValid True
15:40:42 - IsConnectionValid True
15:40:47 - IsConnectionValid True
15:41:01 - IsConnectionValid True
15:42:06 - IsConnectionValid True
15:42:08 - IsConnectionValid True
15:43:07 - IsConnectionValid True
15:43:51 - IsConnectionValid True
15:43:52 - IsConnectionValid True
15:45:40 - IsConnectionValid True
15:45:40 - IsConnectionValid True
15:53:32 - IsConnectionValid True
15:53:33 - IsConnectionValid True
15:53:42 - IsConnectionValid True
15:53:48 - IsConnectionValid True
15:53:53 - IsConnectionValid True
15:53:57 - IsConnectionValid True
15:53:58 - IsConnectionValid True
15:55:16 - IsConnectionValid True
15:58:48 - IsConnectionValid True
15:58:48 - IsConnectionValid True
15:59:54 - IsConnectionValid True
15:59:54 - IsConnectionValid True