15:20:25 - IsConnectionValid True 15:20:30 - IsConnectionValid True 15:20:30 - IsConnectionValid True 15:20:33 - IsConnectionValid True 15:20:38 - IsConnectionValid True 15:21:00 - IsConnectionValid True 15:25:42 - IsConnectionValid True 15:27:57 - IsConnectionValid True 15:40:11 - IsConnectionValid True 15:40:22 - IsConnectionValid True 15:42:15 - IsConnectionValid True 15:42:24 - IsConnectionValid True 15:45:47 - IsConnectionValid True 15:45:54 - IsConnectionValid True 15:46:18 - IsConnectionValid True 15:46:23 - IsConnectionValid True 15:48:25 - IsConnectionValid True 15:59:06 - IsConnectionValid True 15:59:11 - IsConnectionValid True 15:59:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=127) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow