10:18:56 - IsConnectionValid True
10:18:58 - IsConnectionValid True
10:18:58 - IsConnectionValid True
10:18:58 - IsConnectionValid True
10:18:58 - IsConnectionValid True
10:18:58 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:18:59 - IsConnectionValid True
10:19:00 - IsConnectionValid True
10:19:06 - IsConnectionValid True
10:19:12 - IsConnectionValid True
10:19:12 - IsConnectionValid True
10:19:15 - IsConnectionValid True
10:19:24 - IsConnectionValid True
10:19:36 - IsConnectionValid True
10:19:36 - 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=123)  AND  CAST(FromDate AS Date) <= @val2 AND  CAST(ToDate AS Date) >= @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:19:59 - IsConnectionValid True
10:20:05 - IsConnectionValid True
10:20:10 - IsConnectionValid True
10:20:10 - 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
10:20:16 - IsConnectionValid True
10:20:18 - IsConnectionValid True
10:20:18 - 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=163)  AND  CAST(FromDate AS Date) <= @val2 AND  CAST(ToDate AS Date) >= @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:20:30 - IsConnectionValid True
10:20:30 - 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=143)  AND  CAST(FromDate AS Date) <= @val2 AND  CAST(ToDate AS Date) >= @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:35:50 - IsConnectionValid True
10:36:01 - IsConnectionValid True
10:36:04 - IsConnectionValid True
10:36:04 - 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=163)  AND  CAST(FromDate AS Date) <= @val2 AND  CAST(ToDate AS Date) >= @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow