11:53:19 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
11:53:19 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
13:46:19 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
13:46:19 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
13:46:23 - web_get_moduleMenu 1Stc
13:48:16 - web_get_moduleMenu 1Stc
13:49:01 - web_get_moduleMenu 1Stc
13:49:33 - web_get_moduleMenu 1Stc
13:49:53 - web_get_moduleMenu 1Stc
13:53:57 - web_get_moduleMenu 1Stc
14:15:56 - web_get_moduleMenu 1Stc
14:18:19 - web_get_moduleMenu 1Stc
14:18:37 - web_get_moduleMenu 1Stc
14:19:31 - web_get_moduleMenu 1Stc
14:19:34 - web_get_moduleMenu 1Stc
14:19:38 - web_get_moduleMenu 1Stc
14:19:44 - web_get_moduleMenu 1Stc
14:19:52 - web_get_moduleMenu 1Stc
14:22:42 - web_get_moduleMenu 1Stc
14:22:49 - web_get_moduleMenu 1Stc
14:28:53 - web_get_moduleMenu 1Stc
14:29:00 - web_get_moduleMenu 1Stc
14:29:45 - web_get_moduleMenu 1Stc
14:30:04 - web_get_moduleMenu 1Stc
14:32:21 - web_get_moduleMenu 1Stc
14:36:30 - web_get_moduleMenu 1Stc
14:41:22 - web_get_moduleMenu 1Stc
14:41:40 - web_get_moduleMenu 1Stc
14:41:47 - web_get_moduleMenu 1Stc
15:05:07 - web_get_moduleMenu 1Stc
15:05:37 - web_get_moduleMenu 1Stc
15:06:02 - web_get_moduleMenu 1Stc
15:10:01 - web_get_moduleMenu 1Stc
15:10:15 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM JobType  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:10:20 - web_get_moduleMenu 1Stc
15:10:22 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:10:24 - web_get_moduleMenu 1Stc
15:10:30 - web_get_moduleMenu 1Stc
15:14:01 - web_get_moduleMenu 1Stc
15:14:05 - web_get_moduleMenu 1Stc
15:33:11 - web_get_moduleMenu 1Stc
15:33:48 - web_get_moduleMenu 1Stc
15:34:20 - web_get_moduleMenu 1Stc
15:38:28 - web_get_moduleMenu 1Stc
15:40:25 - web_get_moduleMenu 1Stc
15:40:46 - web_get_moduleMenu 1Stc
15:49:28 - web_get_moduleMenu 1Stc
15:49:43 - web_get_moduleMenu 1Stc
15:50:40 - web_get_moduleMenu 1Stc
15:55:06 - web_get_moduleMenu 1Stc
15:55:46 - web_get_moduleMenu 1Stc
15:56:24 - web_get_moduleMenu 1Stc