11:54:08 - IsConnectionValid True
11:54:19 - IsConnectionValid True
11:54:19 - IsConnectionValid True
11:55:09 - IsConnectionValid True
11:55:10 - IsConnectionValid True
11:55:14 - IsConnectionValid True
11:55:16 - IsConnectionValid True
11:55:31 - IsConnectionValid True
11:55:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:55:33 - IsConnectionValid True
11:55:33 - SELECT * FROM HRMS_vwEmployees WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
11:55:43 - IsConnectionValid True
11:55:43 - SELECT * FROM HRMS_vwEmployees WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
11:58:32 - IsConnectionValid True
11:58:58 - IsConnectionValid True
11:58:58 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:34:10 - IsConnectionValid True
12:34:21 - IsConnectionValid True
12:34:28 - IsConnectionValid True
12:35:19 - IsConnectionValid True
12:35:27 - IsConnectionValid True
12:37:40 - IsConnectionValid True
12:37:46 - IsConnectionValid True
12:37:46 - IsConnectionValid True
12:37:52 - IsConnectionValid True
12:38:00 - IsConnectionValid True
12:38:00 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:38:06 - IsConnectionValid True
12:38:06 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:38:11 - IsConnectionValid True
12:38:11 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 AND Name LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:38:36 - IsConnectionValid True
12:38:36 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:44:40 - IsConnectionValid True
12:45:04 - IsConnectionValid True
12:45:04 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:45:09 - IsConnectionValid True
12:45:09 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 AND Name LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:47:01 - IsConnectionValid True
12:47:20 - IsConnectionValid True
12:47:20 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:47:24 - IsConnectionValid True
12:47:24 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 AND Name LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow