10:51:49 - IsConnectionValid True 10:51:50 - IsConnectionValid True 10:51:50 - IsConnectionValid True 10:51:55 - IsConnectionValid True 10:51:55 - IsConnectionValid True 10:51:57 - IsConnectionValid True 10:51:58 - IsConnectionValid True 10:52:04 - IsConnectionValid True 10:52:07 - IsConnectionValid True 10:52:07 - 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 15:03:19 - IsConnectionValid True 15:03:23 - IsConnectionValid True 15:03:41 - IsConnectionValid True 15:04:20 - IsConnectionValid True 15:04:21 - IsConnectionValid True 15:04:21 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:04:31 - IsConnectionValid True 15:04:36 - IsConnectionValid True 15:04:40 - IsConnectionValid True 15:04:45 - IsConnectionValid True 15:04:49 - IsConnectionValid True 15:04:49 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:07:17 - IsConnectionValid True 15:07:17 - IsConnectionValid True 15:07:17 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:00:07 - IsConnectionValid True 16:00:08 - IsConnectionValid True 16:00:08 - SELECT DISTINCT ID AS ID, Code AS Code, MonthName AS Name FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:01:08 - IsConnectionValid True 16:01:09 - IsConnectionValid True 16:01:09 - SELECT DISTINCT ID AS ID, Code AS Code, MonthName AS Name FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query