10:49:11 - IsConnectionValid True
10:49:11 - IsConnectionValid True
10:49:12 - IsConnectionValid True
10:50:26 - IsConnectionValid True
10:50:26 - IsConnectionValid True
10:50:29 - IsConnectionValid True
10:50:33 - IsConnectionValid True
10:50:33 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM CourseTypeDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:50:35 - IsConnectionValid True
10:51:07 - IsConnectionValid True
10:51:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM EmpWifeInfo WHERE  TenantID =1 and EmpId = @val1 ORDER BY Code  Query
10:51:09 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE  TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate))   Query
10:51:09 - SELECT  DISTINCT * FROM Projects WHERE  TenantID =1 and ID = @val1  Query
10:51:09 - SELECT  DISTINCT * FROM Jobs WHERE  TenantID =1 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM Section WHERE TenantID = 1 AND   TenantID = @val0 and ID = @val1  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Religion WHERE TenantID = 1 AND   TenantID = @val0 AND IsActive = @val1 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM EducationCity WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT * FROM vwEmployeeLanguages WHERE  TenantID =1 and EmployeeID = @val1  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Countries WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM Conservatism WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM JobType WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE  TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM Subjects WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM JobDegree WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM VwEmpEducations WHERE  TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=0) OR ExtensionsID=0)    ORDER BY ID  Query
10:51:09 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - SELECT  DISTINCT * FROM Banks WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM HRMS_vwVacTransType WHERE  TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM HRMS_vwVacTransType WHERE  TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM vwEmpDocumentDet WHERE  TenantID =1 and EmpID = @val1 ORDER BY ID  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 876 WHERE  LocationDef.TenantID =1  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 876 WHERE  CustodyItemsDef.TenantID =1  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE  Emp.TenantID =1 AND Emp.EmpID =876 AND Emp.MasterID =0  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM vwCoursesEntryDetails WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM vwThanksBooksEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM vwWarningEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - IsConnectionValid True
10:51:09 - SELECT * FROM vwInjuryEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Departments WHERE  TenantID =1 and ID = @val1  Query
10:51:09 - IsConnectionValid True
10:51:09 - SELECT  DISTINCT * FROM Section WHERE  TenantID =1 and ID = @val1  Query
10:51:20 - IsConnectionValid True
10:51:20 - IsConnectionValid True
10:51:20 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:51:20 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:51:21 - IsConnectionValid True
10:51:21 - SELECT  DISTINCT * FROM VwEmpEducations WHERE  TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0)    ORDER BY ID  Query
10:51:23 - IsConnectionValid True
10:51:23 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:51:23 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
14:43:43 - IsConnectionValid True