11:23:15 - IsConnectionValid True 11:23:16 - IsConnectionValid True 11:23:16 - IsConnectionValid True 11:23:22 - IsConnectionValid True 11:23:25 - IsConnectionValid True 11:23:25 - IsConnectionValid True 11:23:30 - IsConnectionValid True 11:24:57 - IsConnectionValid True 11:24:58 - IsConnectionValid True 11:24:59 - IsConnectionValid True 11:25:00 - IsConnectionValid True 11:26:47 - IsConnectionValid True 11:26:48 - IsConnectionValid True 11:26:54 - IsConnectionValid True 11:28:18 - IsConnectionValid True 11:28:19 - IsConnectionValid True 11:28:51 - IsConnectionValid True 11:28:57 - IsConnectionValid True 11:28:57 - IsConnectionValid True 11:29:00 - IsConnectionValid True 11:29:57 - IsConnectionValid True 11:29:57 - IsConnectionValid True 11:30:47 - IsConnectionValid True 11:31:54 - IsConnectionValid True 11:32:05 - IsConnectionValid True 11:33:22 - IsConnectionValid True 11:34:00 - IsConnectionValid True 11:34:06 - IsConnectionValid True 11:34:22 - IsConnectionValid True 11:34:27 - IsConnectionValid True 11:34:36 - IsConnectionValid True 11:34:41 - IsConnectionValid True 11:35:13 - IsConnectionValid True 11:35:19 - IsConnectionValid True 11:40:10 - IsConnectionValid True 11:41:52 - IsConnectionValid True 11:42:05 - IsConnectionValid True 11:43:25 - IsConnectionValid True 11:44:07 - IsConnectionValid True 11:44:20 - IsConnectionValid True 11:44:30 - IsConnectionValid True 11:44:40 - IsConnectionValid True 11:44:48 - IsConnectionValid True 11:44:56 - IsConnectionValid True 11:45:06 - IsConnectionValid True 11:45:15 - IsConnectionValid True 11:45:26 - IsConnectionValid True 11:45:32 - IsConnectionValid True 11:45:40 - IsConnectionValid True 11:46:12 - IsConnectionValid True 11:46:23 - IsConnectionValid True 11:46:43 - IsConnectionValid True 11:46:50 - IsConnectionValid True 11:47:19 - IsConnectionValid True 11:47:27 - IsConnectionValid True 11:47:56 - IsConnectionValid True 11:48:15 - IsConnectionValid True 11:51:55 - IsConnectionValid True 11:55:20 - IsConnectionValid True 12:07:55 - IsConnectionValid True 12:30:49 - IsConnectionValid True 12:32:14 - IsConnectionValid True 12:33:49 - IsConnectionValid True 12:34:23 - IsConnectionValid True 12:36:56 - IsConnectionValid True 12:42:35 - IsConnectionValid True 12:44:47 - IsConnectionValid True 12:45:29 - IsConnectionValid True 12:45:55 - IsConnectionValid True 12:46:32 - IsConnectionValid True 12:47:47 - IsConnectionValid True 12:49:36 - IsConnectionValid True 12:55:18 - IsConnectionValid True 12:57:17 - IsConnectionValid True 13:02:30 - IsConnectionValid True 13:02:45 - IsConnectionValid True 13:02:53 - IsConnectionValid True 13:03:18 - IsConnectionValid True 13:03:21 - IsConnectionValid True 13:03:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:03:23 - IsConnectionValid True 13:03:23 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 13:03:23 - IsConnectionValid True 13:03:23 - IsConnectionValid True 13:03:23 - IsConnectionValid True 13:03:23 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 13:03:23 - IsConnectionValid True 13:03:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:23 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:03:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:23 - IsConnectionValid True 13:03:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 20 AND d.MaxAge > 20)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:23 - IsConnectionValid True 13:03:23 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:25 - IsConnectionValid True 13:03:28 - IsConnectionValid True 13:03:28 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 13:03:29 - IsConnectionValid True 13:03:29 - IsConnectionValid True 13:03:29 - IsConnectionValid True 13:03:29 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 13:03:29 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:03:29 - IsConnectionValid True 13:03:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:29 - IsConnectionValid True 13:03:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 20 AND d.MaxAge > 20)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:29 - IsConnectionValid True 13:03:29 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:03:32 - IsConnectionValid True 13:03:36 - IsConnectionValid True 13:03:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceDefinitions WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:03:37 - IsConnectionValid True 13:03:37 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 13:03:40 - IsConnectionValid True 13:03:42 - IsConnectionValid True 13:03:42 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 13:03:49 - IsConnectionValid True 13:03:51 - IsConnectionValid True 13:03:51 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 13:03:55 - IsConnectionValid True 13:03:58 - IsConnectionValid True 13:04:00 - IsConnectionValid True 13:04:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:04:02 - IsConnectionValid True 13:04:02 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=298 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 13:04:02 - IsConnectionValid True 13:04:02 - IsConnectionValid True 13:04:02 - IsConnectionValid True 13:04:02 - IsConnectionValid True 13:04:02 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 13:04:02 - IsConnectionValid True 13:04:02 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:02 - IsConnectionValid True 13:04:02 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 13:04:02 - IsConnectionValid True 13:04:02 - IsConnectionValid True 13:04:02 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:02 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 13:04:02 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:02 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 13:04:03 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:03 - IsConnectionValid True 13:04:03 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:03 - IsConnectionValid True 13:04:03 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 4 AND d.MaxAge > 4)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:03 - IsConnectionValid True 13:04:03 - IsConnectionValid True 13:04:03 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 18 AND d.MaxAge > 18)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:03 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 39 AND d.MaxAge > 39)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:04 - IsConnectionValid True 13:04:06 - IsConnectionValid True 13:04:06 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=298 AND TypeID=1 ) AND TenantID = @val1 ORDER BY ID asc Query 13:04:07 - IsConnectionValid True 13:04:07 - IsConnectionValid True 13:04:07 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 13:04:07 - IsConnectionValid True 13:04:07 - IsConnectionValid True 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - IsConnectionValid True 13:04:07 - IsConnectionValid True 13:04:07 - IsConnectionValid True 13:04:07 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 13:04:07 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - IsConnectionValid True 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 39 AND d.MaxAge > 39)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - IsConnectionValid True 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 0 AND d.MaxAge > 0)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 18 AND d.MaxAge > 18)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:07 - IsConnectionValid True 13:04:07 - SELECT m.ID AS ID, m.Code AS Code, m.Name AS Name, m.EName AS EName, m.InsuranceCompanyID AS InsuranceCompanyID, m.TypeID AS TypeID, m.TenantID AS TenantID, d.RelevantPeopleID AS RelevantPeopleID, d.EmployeeDeductionAmount AS EmployeeDeductionAmount, d.CompanyDeductionAmount AS CompanyDeductionAmount, d.MinAge AS MinAge, d.MaxAge AS MaxAge FROM InsuranceDefinitions m inner join InsuranceDefinitionsDetails d on m.ID = d.InsuranceDefinitionID WHERE m.TenantID = @val0 and d.RelevantPeopleID = @val1 and ((d.MinAge = 0 AND d.MaxAge = 0) OR (d.MinAge <= 4 AND d.MaxAge > 4)) and m.TypeID = @val3 ORDER BY m.ID Query 13:04:23 - IsConnectionValid True 13:04:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:04:24 - IsConnectionValid True 13:04:27 - IsConnectionValid True 16:06:01 - IsConnectionValid True 16:06:02 - IsConnectionValid True 16:06:03 - IsConnectionValid True 16:06:58 - IsConnectionValid True 16:07:03 - IsConnectionValid True 16:07:03 - IsConnectionValid True 16:07:05 - IsConnectionValid True 16:07:06 - IsConnectionValid True 16:07:08 - IsConnectionValid True 16:07:10 - IsConnectionValid True 16:07:35 - IsConnectionValid True 16:07:39 - IsConnectionValid True 16:10:49 - IsConnectionValid True 16:10:49 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE()) COUNT Query 18 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 3 16:10:49 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=1 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 2 16:10:49 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=2 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=14 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND ((MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE()) ) OR EndContractDate BETWEEN GETDATE() AND EOMONTH(GETDATE(),1)) COUNT Query 69 16:10:49 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(MONTH, (COMPAREDATE), GETDATE()) /12)) >= CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 4 16:10:49 - select COUNT(*) from EmployeeChild C INNER JOIN EMPLOYEES E ON C.FatherID=E.ID WHERE E.DateLeft='01/01/1900' AND convert(date,C.BirthDate )>= convert(date,DATEADD(YEAR,-18,GETDATE())) AND MONTH(C.BirthDate)=MONTH(GETDATE()) AND YEAR(C.BirthDate)=YEAR(DATEADD(YEAR,-18,GETDATE())) COUNT Query 0 16:10:49 - SELECT COUNT(ID) AS count FROM dbo.Employees WHERE (DateLeft = '01/01/1900') AND (YEAR(DateBegin) = 2004) COUNT Query 5 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(EOMONTH(GETDATE(),1)) COUNT Query 26 16:10:49 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=1 and DateBegin<>'01/01/1900' and (DATEDIFF(MM,DateBegin,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 1 16:10:49 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=3 and ContractDate<>'01/01/1900' and (DATEDIFF(MM,ContractDate,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 0 16:10:49 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=6 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:10:49 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=5 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND YEAR(EndContractDate)=(SELECT currentYear from SysParam) COUNT Query 68 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 250 16:10:49 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 250 16:10:50 - IsConnectionValid True 16:10:51 - IsConnectionValid True 16:13:24 - IsConnectionValid True 16:13:24 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE()) COUNT Query 18 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 3 16:13:24 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=1 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 2 16:13:24 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=2 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=14 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND ((MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE()) ) OR EndContractDate BETWEEN GETDATE() AND EOMONTH(GETDATE(),1)) COUNT Query 69 16:13:24 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(MONTH, (COMPAREDATE), GETDATE()) /12)) >= CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 4 16:13:24 - select COUNT(*) from EmployeeChild C INNER JOIN EMPLOYEES E ON C.FatherID=E.ID WHERE E.DateLeft='01/01/1900' AND convert(date,C.BirthDate )>= convert(date,DATEADD(YEAR,-18,GETDATE())) AND MONTH(C.BirthDate)=MONTH(GETDATE()) AND YEAR(C.BirthDate)=YEAR(DATEADD(YEAR,-18,GETDATE())) COUNT Query 0 16:13:24 - SELECT COUNT(ID) AS count FROM dbo.Employees WHERE (DateLeft = '01/01/1900') AND (YEAR(DateBegin) = 2004) COUNT Query 5 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(EOMONTH(GETDATE(),1)) COUNT Query 26 16:13:24 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=1 and DateBegin<>'01/01/1900' and (DATEDIFF(MM,DateBegin,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 1 16:13:24 - SELECT COUNT(*) FROM Employees e WHERE employmenttype=3 and ContractDate<>'01/01/1900' and (DATEDIFF(MM,ContractDate,GETDATE()))>=3 and not exists(SELECT * from EmployeeTransactionsCondition C inner join DailyTransactionEntry d on c.EmployeeID=d.EmployeeId and c.TransactionID=d.TransactionID WHERE E.ID=C.Employeeid) and (DateLeft='01/01/1900' or ((MONTH(DateLeft)>=MONTH(GETDATE()) AND YEAR(DateLeft)=YEAR(GETDATE())) OR YEAR(DateLeft)>YEAR(GETDATE()))) COUNT Query 0 16:13:24 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=6 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:13:24 - SELECT COUNT(ID) AS TotalNum FROM VwEmpDocAlerts WHERE DocTypeID=5 AND ( DATEDIFF(DAY,GETDATE(),ToDate)<=30 AND DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND YEAR(EndContractDate)=(SELECT currentYear from SysParam) COUNT Query 68 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 250 16:13:24 - SELECT COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' COUNT Query 250 16:13:24 - IsConnectionValid True 16:13:26 - IsConnectionValid True 16:13:26 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:13:55 - IsConnectionValid True