14:46:11 - IsConnectionValid True
14:46:16 - IsConnectionValid True
14:46:17 - IsConnectionValid True
14:46:19 - IsConnectionValid True
14:46:25 - IsConnectionValid True
14:46:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM EmploymentTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:46:40 - IsConnectionValid True
14:47:08 - IsConnectionValid True