16:14:10 - IsConnectionValid True 16:14:10 - IsConnectionValid True 16:14:11 - IsConnectionValid True 16:14:16 - IsConnectionValid True 16:14:16 - IsConnectionValid True 16:14:19 - IsConnectionValid True 16:14:19 - IsConnectionValid True 16:14:20 - IsConnectionValid True 16:14:23 - IsConnectionValid True 16:14:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:14:25 - IsConnectionValid True 16:15:31 - IsConnectionValid True 16:15:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:15:42 - IsConnectionValid True 16:15:52 - IsConnectionValid True 16:15:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow