12:15:12 - IsConnectionValid True 12:15:13 - IsConnectionValid True 12:15:13 - IsConnectionValid True 12:15:22 - IsConnectionValid True 12:15:22 - IsConnectionValid True 12:15:26 - IsConnectionValid True 12:15:33 - IsConnectionValid True 12:15:52 - IsConnectionValid True 14:13:14 - IsConnectionValid True 14:14:05 - IsConnectionValid True 14:14:06 - IsConnectionValid True 14:16:12 - IsConnectionValid True 14:16:53 - IsConnectionValid True 14:33:04 - IsConnectionValid True 14:33:08 - IsConnectionValid True 14:33:17 - IsConnectionValid True 14:33:24 - IsConnectionValid True 14:33:33 - IsConnectionValid True 15:38:33 - IsConnectionValid True 15:38:37 - IsConnectionValid True 15:38:42 - IsConnectionValid True 15:39:35 - IsConnectionValid True 15:39:38 - IsConnectionValid True 15:40:20 - IsConnectionValid True 15:40:23 - IsConnectionValid True 15:40:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = 1 AND SectionID = @val0 AND CAST(FromDate AS Date) <= @val1 AND CAST(ToDate AS Date) >= @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:40:28 - IsConnectionValid True 15:40:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = 1 AND SectionID = @val0 AND CAST(FromDate AS Date) <= @val1 AND CAST(ToDate AS Date) >= @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:25 - IsConnectionValid True 15:41:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = 1 AND SectionID = @val0 AND CAST(FromDate AS Date) <= @val1 AND CAST(ToDate AS Date) >= @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:27 - IsConnectionValid True 15:41:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = 1 AND SectionID = @val0 AND CAST(FromDate AS Date) <= @val1 AND CAST(ToDate AS Date) >= @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:30 - IsConnectionValid True 15:41: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 = 1 AND SectionID = @val0 AND CAST(FromDate AS Date) <= @val1 AND CAST(ToDate AS Date) >= @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:42:46 - IsConnectionValid True 15:42:49 - IsConnectionValid True 15:42:51 - IsConnectionValid True 15:43:29 - IsConnectionValid True 15:43:31 - IsConnectionValid True 15:43:33 - IsConnectionValid True 15:43:33 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:43:35 - IsConnectionValid True 15:43:35 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:46:26 - IsConnectionValid True 15:46:26 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:47:28 - IsConnectionValid True 15:47:28 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:50:00 - IsConnectionValid True 15:50:02 - IsConnectionValid True 15:50:03 - IsConnectionValid True 15:50:03 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:50:16 - IsConnectionValid True 15:50:16 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:50:37 - IsConnectionValid True 15:50:38 - IsConnectionValid True 15:50:40 - IsConnectionValid True 15:50:41 - IsConnectionValid True 15:50:43 - IsConnectionValid True 15:50:46 - IsConnectionValid True 15:50:47 - IsConnectionValid True 15:50:47 - 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=130) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:51:15 - IsConnectionValid True 15:51:17 - IsConnectionValid True 15:51:25 - IsConnectionValid True 15:51:25 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:52:55 - IsConnectionValid True 15:58:15 - IsConnectionValid True 15:58:18 - IsConnectionValid True 15:58:22 - IsConnectionValid True 15:58:22 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:46 - IsConnectionValid True 15:58:46 - SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND (Code LIKE '%ffffff%') ORDER BY ID ASC Query 15:58:46 - IsConnectionValid True 15:58:46 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND Code LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:50 - IsConnectionValid True 15:58:50 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:53 - IsConnectionValid True 15:58:53 - SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND (Code LIKE '%ffffff%') ORDER BY ID ASC Query 15:58:53 - IsConnectionValid True 15:58:53 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND Code LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:02:41 - IsConnectionValid True 16:02:44 - IsConnectionValid True 16:02:46 - IsConnectionValid True 16:02:46 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:05:10 - IsConnectionValid True 16:05:12 - IsConnectionValid True 16:05:13 - IsConnectionValid True 16:05:13 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:05:28 - IsConnectionValid True 16:05:28 - SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND (Code LIKE '%ffffff%') ORDER BY ID ASC Query 16:05:28 - IsConnectionValid True 16:05:28 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND Code LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:05:32 - IsConnectionValid True 16:05:32 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:07:31 - IsConnectionValid True 16:07:35 - IsConnectionValid True 16:07:37 - IsConnectionValid True 16:07:37 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:07:48 - IsConnectionValid True 16:07:50 - IsConnectionValid True 16:07:54 - IsConnectionValid True 16:07:54 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:09:49 - IsConnectionValid True 16:09:52 - IsConnectionValid True 16:09:54 - IsConnectionValid True 16:09:54 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:11:03 - IsConnectionValid True 16:11:05 - IsConnectionValid True 16:11:07 - IsConnectionValid True 16:11:07 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:11:22 - IsConnectionValid True 16:11:22 - SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND (Code LIKE '%ffffff%') ORDER BY ID ASC Query 16:11:22 - IsConnectionValid True 16:11:22 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 AND Code LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:12:21 - IsConnectionValid True 16:12:24 - IsConnectionValid True 16:12:25 - IsConnectionValid True 16:12:25 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:12:27 - IsConnectionValid True 16:12:27 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:12:29 - IsConnectionValid True 16:12:29 - 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=130) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow