10:34:04 - IsConnectionValid True
10:34:04 - IsConnectionValid True
10:34:11 - IsConnectionValid True
10:34:11 - IsConnectionValid True
10:34:14 - IsConnectionValid True
10:34:19 - IsConnectionValid True
10:34:25 - IsConnectionValid True
10:34:25 - 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
10:34:28 - IsConnectionValid True