10:15:44 - IsConnectionValid True 10:15:44 - IsConnectionValid True 10:15:54 - IsConnectionValid True 10:15:54 - IsConnectionValid True 10:17:03 - IsConnectionValid True 10:17:08 - IsConnectionValid True 10:17:08 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 10:17:08 - IsConnectionValid True 10:17:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:14 - IsConnectionValid True 10:17:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:16 - IsConnectionValid True 10:17:17 - IsConnectionValid True 10:17:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:20 - IsConnectionValid True 10:17:24 - IsConnectionValid True 10:17:24 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:26 - IsConnectionValid True 10:17:27 - IsConnectionValid True 10:17:34 - IsConnectionValid True 10:17:34 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 10:17:34 - IsConnectionValid True 10:17:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:38 - IsConnectionValid True 10:17:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:40 - IsConnectionValid True 10:17:42 - IsConnectionValid True 10:17:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:17:44 - IsConnectionValid True 10:18:38 - IsConnectionValid True 10:18:38 - SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = @val0 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 10:18:38 - IsConnectionValid True 10:18:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, EnglishName AS EName, Name AS Name FROM vwemployees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:19:05 - IsConnectionValid True 10:19:08 - IsConnectionValid True 10:19:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:19:10 - IsConnectionValid True 10:19:18 - IsConnectionValid True 10:19:21 - IsConnectionValid True 10:19:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTransactions WHERE TenantID = 1 AND EmployeeID = @val0 AND TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:19:24 - IsConnectionValid True 10:19:26 - IsConnectionValid True 10:19:29 - IsConnectionValid True 10:19:29 - 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 10:19:42 - IsConnectionValid True 10:19:42 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=2 ) AND TenantID = @val1 ORDER BY ID asc Query 10:19:42 - IsConnectionValid True 10:19:42 - IsConnectionValid True 10:19:42 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:19:42 - IsConnectionValid True 10:19:42 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:19:42 - 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 10:19:42 - 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 10:19:42 - IsConnectionValid True 10:19:42 - 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 10:19:42 - IsConnectionValid True 10:19:42 - 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 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:19:49 - 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 10:19:49 - 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 10:19:49 - 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 10:19:49 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:19:49 - 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 10:19:49 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - 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 10:19:49 - 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 10:19:49 - IsConnectionValid True 10:19:49 - IsConnectionValid True 10:19:49 - 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 10:19:49 - 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 10:19:49 - IsConnectionValid True 10:19:49 - 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 10:20:01 - IsConnectionValid True 10:20:01 - IsConnectionValid True 10:20:01 - IsConnectionValid True 10:20:01 - IsConnectionValid True 10:20:01 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:01 - 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 10:20:01 - IsConnectionValid True 10:20:01 - IsConnectionValid True 10:20:01 - 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 10:20:01 - 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 10:20:01 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:01 - 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 10:20:01 - IsConnectionValid True 10:20:01 - 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 10:20:01 - IsConnectionValid True 10:20:01 - 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 10:20:04 - IsConnectionValid True 10:20:04 - IsConnectionValid True 10:20:04 - IsConnectionValid True 10:20:04 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:04 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:04 - 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 10:20:04 - 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 10:20:04 - IsConnectionValid True 10:20:04 - 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 10:20:07 - IsConnectionValid True 10:20:07 - IsConnectionValid True 10:20:07 - 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 10:20:09 - IsConnectionValid True 10:20:09 - 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 10:20:09 - IsConnectionValid True 10:20:09 - IsConnectionValid True 10:20:09 - IsConnectionValid True 10:20:09 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:09 - 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 10:20:09 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:20:09 - 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 10:20:09 - IsConnectionValid True 10:20:09 - 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 10:20:09 - IsConnectionValid True 10:20:09 - 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 10:20:12 - IsConnectionValid True 10:20:12 - 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 10:20:12 - IsConnectionValid True 10:20:12 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=2 ) AND TenantID = @val1 ORDER BY ID asc Query 10:20:13 - IsConnectionValid True 10:20:13 - IsConnectionValid True 10:20:13 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:20:13 - 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 10:20:13 - IsConnectionValid True 10:20:13 - 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 10:20:15 - IsConnectionValid True 10:20:15 - 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 10:20:24 - IsConnectionValid True 10:20:24 - 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 10:23:05 - IsConnectionValid True 10:23:05 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=2 ) AND TenantID = @val1 ORDER BY ID asc Query 10:23:05 - IsConnectionValid True 10:23:05 - IsConnectionValid True 10:23:05 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:23:05 - IsConnectionValid True 10:23:05 - 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 10:23:07 - IsConnectionValid True 10:23:07 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:23:07 - IsConnectionValid True 10:23:07 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:23:09 - IsConnectionValid True 10:23:09 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 10:23:09 - IsConnectionValid True 10:23:09 - 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 10:23:09 - IsConnectionValid True 10:23:09 - IsConnectionValid True 10:23:09 - IsConnectionValid True 10:23:09 - 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 10:23:09 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:23:09 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:23:09 - IsConnectionValid True 10:23:09 - IsConnectionValid True 10:23:09 - 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 10:23:09 - 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 10:23:11 - IsConnectionValid True 10:23:11 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:23:11 - IsConnectionValid True 10:23:11 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:23:12 - IsConnectionValid True 10:23:12 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 10:23:12 - IsConnectionValid True 10:23:12 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=1092 AND TypeID=2 ) AND TenantID = @val1 ORDER BY ID asc Query 10:23:12 - IsConnectionValid True 10:23:12 - 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 10:23:12 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:23:12 - IsConnectionValid True 10:23:12 - 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 10:23:13 - IsConnectionValid True 10:23:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:23:13 - IsConnectionValid True 10:23:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:26:19 - IsConnectionValid True 10:26:19 - IsConnectionValid True 10:26:19 - IsConnectionValid True 10:26:19 - IsConnectionValid True 10:26:19 - IsConnectionValid True 10:26:19 - IsConnectionValid True 10:26:19 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:26:19 - 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 10:26:19 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:26:19 - 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 10:26:19 - 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 10:26:19 - 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 10:26:19 - IsConnectionValid True 10:26:19 - 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 10:26:19 - IsConnectionValid True 10:26:19 - 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 10:26:21 - IsConnectionValid True 10:26:21 - IsConnectionValid True 10:26:21 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:26:21 - 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 10:26:21 - IsConnectionValid True 10:26:21 - 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 10:26:22 - IsConnectionValid True 10:26:22 - SELECT * FROM EmployeeDependents WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 10:26:22 - IsConnectionValid True 10:26:22 - 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 10:26:22 - IsConnectionValid True 10:26:22 - 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 10:26:23 - IsConnectionValid True 10:26: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 10:26:23 - IsConnectionValid True 10:26: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 10:26:30 - IsConnectionValid True 10:26:39 - IsConnectionValid True 10:26:39 - 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 10:26:41 - IsConnectionValid True 10:26:41 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 10:26:48 - IsConnectionValid True 10:26:48 - IsConnectionValid True 10:26:48 - 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 10:27:55 - IsConnectionValid True 10:31:40 - IsConnectionValid True 10:31:40 - 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 10:33:16 - IsConnectionValid True 10:41:29 - IsConnectionValid True 10:41:29 - IsConnectionValid True 10:41:38 - IsConnectionValid True 10:41:50 - IsConnectionValid True 10:41:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:41:53 - IsConnectionValid True 10:41:57 - IsConnectionValid True 10:41:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:02 - IsConnectionValid True 10:42:06 - IsConnectionValid True 10:42:06 - 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 10:42:12 - IsConnectionValid True 10:42:12 - IsConnectionValid True 10:42:12 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 10:42:19 - IsConnectionValid True 10:42:19 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:42:19 - IsConnectionValid True 10:42:19 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName FROM InsuranceCompanies WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:42:22 - IsConnectionValid True 10:42:22 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:42:22 - IsConnectionValid True 10:42:22 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:42:36 - IsConnectionValid True 10:42: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 10:42:37 - IsConnectionValid True 10:42:38 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 10:42:40 - IsConnectionValid True 10:42:40 - 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 10:45:00 - IsConnectionValid True 10:45:04 - IsConnectionValid True 10:45:04 - 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 10:45:08 - IsConnectionValid True 10:45:08 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 10:48:00 - IsConnectionValid True 10:48:00 - IsConnectionValid True 10:48:00 - 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 10:48:05 - IsConnectionValid True 10:48:05 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 10:48:23 - IsConnectionValid True 10:48:23 - IsConnectionValid True 10:48:24 - 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 10:48:30 - IsConnectionValid True 10:48:34 - IsConnectionValid True 10:48:34 - 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 10:48:37 - IsConnectionValid True 10:48:37 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=0 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 10:48:39 - IsConnectionValid True 10:48:39 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:48:39 - IsConnectionValid True 10:48:39 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, MARSTAT AS MARSTAT FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:48:47 - IsConnectionValid True 10:48:47 - SELECT * FROM vw_InsuranceEntry_Details WHERE InsuranceEntryID IN (select ID FROM InsuranceEntry where EmployeeID=298 AND TypeID=0 ) AND TenantID = @val1 ORDER BY ID asc Query 10:48:49 - IsConnectionValid True 10:48:49 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:48:49 - IsConnectionValid True 10:48:49 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, TransactionCode AS TransactionCode, TransactionName AS TransactionName FROM vw_InsuranceTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID DESC Query 10:48:55 - IsConnectionValid True 10:48:55 - SELECT * FROM InsuranceEntry WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 and TypeID = @val2 ORDER BY ID Query 10:48:57 - IsConnectionValid True 10:48:57 - IsConnectionValid True 10:48:57 - 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 10:48:57 - 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 10:48:57 - IsConnectionValid True 10:48:57 - 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 10:49:00 - IsConnectionValid True 10:49:00 - IsConnectionValid True 10:49:00 - 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 10:49:00 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49:00 - IsConnectionValid True 10:49:00 - 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 10:49:02 - IsConnectionValid True 10:49:02 - IsConnectionValid True 10:49:02 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49: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 10:49:02 - IsConnectionValid True 10:49: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 10:49:02 - IsConnectionValid True 10:49: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 <= 39 AND d.MaxAge > 39)) and m.TypeID = @val3 ORDER BY m.ID Query 10:49:04 - IsConnectionValid True 10:49:04 - 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 10:49:14 - IsConnectionValid True 10:49:14 - IsConnectionValid True 10:49:14 - IsConnectionValid True 10:49:14 - IsConnectionValid True 10:49:14 - IsConnectionValid True 10:49:14 - 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 10:49:14 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49:14 - 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 10:49:14 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49:14 - 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 10:49:14 - 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 10:49:14 - IsConnectionValid True 10:49:14 - 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 10:49:14 - IsConnectionValid True 10:49:14 - 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 10:49:16 - IsConnectionValid True 10:49:16 - IsConnectionValid True 10:49:16 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:49:16 - 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 10:49:16 - IsConnectionValid True 10:49:16 - 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 10:49:17 - IsConnectionValid True 10:49:17 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:49:17 - IsConnectionValid True 10:49:17 - 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 10:49:17 - IsConnectionValid True 10:49:17 - 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 10:49:18 - IsConnectionValid True 10:49:18 - 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 10:49:20 - IsConnectionValid True 10:49:20 - 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 10:49:35 - IsConnectionValid True 10:49:35 - IsConnectionValid True 10:49:35 - IsConnectionValid True 10:49:35 - 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 10:49:35 - IsConnectionValid True 10:49:35 - IsConnectionValid True 10:49:35 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:49:35 - 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 10:49:35 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49:35 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:49:35 - IsConnectionValid True 10:49:35 - IsConnectionValid True 10:49:35 - IsConnectionValid True 10:49:35 - 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 10:49:35 - 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 10:49:35 - 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 10:49:35 - IsConnectionValid True 10:49:35 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:49:35 - 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 10:49:35 - IsConnectionValid True 10:49:35 - 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 10:49:35 - IsConnectionValid True 10:49:35 - 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 10:49:35 - IsConnectionValid True 10:49:35 - 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 10:49:37 - IsConnectionValid True 10:49:37 - IsConnectionValid True 10:49:37 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:49:37 - 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 10:49:37 - IsConnectionValid True 10:49:37 - 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 10:49:38 - IsConnectionValid True 10:49:38 - IsConnectionValid True 10:49:38 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:49:38 - 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 10:49:39 - IsConnectionValid True 10:49:39 - 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 10:49:41 - IsConnectionValid True 10:49:41 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:49:50 - IsConnectionValid True 10:49:50 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - 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 10:50:15 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - 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 10:50:15 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:50:15 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:50:15 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:50:15 - 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 10:50:15 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 10:50:15 - IsConnectionValid True 10:50:15 - 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 10:50:15 - IsConnectionValid True 10:50:15 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:50:15 - 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 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:50:15 - 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 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - IsConnectionValid True 10:50:15 - 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 10:50:15 - 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 10:50:15 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:50:15 - 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 10:50:18 - IsConnectionValid True 10:50:18 - IsConnectionValid True 10:50:18 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:50:18 - 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 10:50:18 - IsConnectionValid True 10:50:18 - 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 10:50:19 - IsConnectionValid True 10:50:19 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:50:19 - IsConnectionValid True 10:50:19 - 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 10:50:19 - IsConnectionValid True 10:50:19 - 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 10:50:20 - IsConnectionValid True 10:50:20 - 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 10:50:21 - IsConnectionValid True 10:50:21 - 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 10:51:20 - IsConnectionValid True 10:51:20 - IsConnectionValid True 10:51:20 - 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 10:51:23 - IsConnectionValid True 10:51:23 - 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 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51:23 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 10:51: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 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51: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 10:51:23 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:51: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 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51:23 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 10:51: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 10:51:23 - IsConnectionValid True 10:51:23 - IsConnectionValid True 10:51: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 <= 39 AND d.MaxAge > 39)) and m.TypeID = @val3 ORDER BY m.ID Query 10:51: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 10:51:23 - IsConnectionValid True 10:51: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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 10:51:23 - IsConnectionValid True 10:51: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 <= 4 AND d.MaxAge > 4)) and m.TypeID = @val3 ORDER BY m.ID Query 11:17:43 - IsConnectionValid True 11:17:43 - 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 11:17:44 - IsConnectionValid True 11:17:44 - 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 11:17:44 - IsConnectionValid True 11:17:44 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 11:17:44 - IsConnectionValid True 11:17:44 - IsConnectionValid True 11:17:44 - IsConnectionValid True 11:17:44 - IsConnectionValid True 11:17:44 - IsConnectionValid True 11:17:44 - IsConnectionValid True 11:17:44 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 11:17:44 - 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 11:17:44 - 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 11:17:44 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:17:44 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:17:44 - 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 11:17:44 - IsConnectionValid True 11:17:44 - 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 11:17:44 - IsConnectionValid True 11:17:44 - 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 11:17:44 - IsConnectionValid True 11:17:44 - 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 11:17:44 - IsConnectionValid True 11:17:44 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 11:17:44 - IsConnectionValid True 11:17:44 - 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 11:17:48 - IsConnectionValid True 11:17:48 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 11:17:52 - IsConnectionValid True 11:17:52 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 11:17:52 - IsConnectionValid True 11:17:52 - 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 <= 10 AND d.MaxAge > 10)) and m.TypeID = @val3 ORDER BY m.ID Query 11:18:09 - IsConnectionValid True 11:18:09 - IsConnectionValid True 11:18:09 - 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 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - 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 11:18:10 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:18:10 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 11:18:10 - 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 11:18:10 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 11:18:10 - 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 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:18:10 - 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 11:18:10 - IsConnectionValid True 11:18:10 - 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 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - IsConnectionValid True 11:18:10 - 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 11:18:10 - 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 11:18:10 - 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 11:18:31 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 11:18:32 - 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 11:18:32 - 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 11:18:32 - IsConnectionValid True 11:18:32 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:18:32 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - IsConnectionValid True 11:18:32 - IsConnectionValid True 11:18:32 - 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 11:18:32 - 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 <= 17 AND d.MaxAge > 17)) and m.TypeID = @val3 ORDER BY m.ID Query 11:19:22 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - 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 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 11:19:23 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 11:19:23 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:19: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 11:19: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 11:19:23 - IsConnectionValid True 11:19:23 - IsConnectionValid True 11:19:23 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:19: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 11:19:23 - IsConnectionValid True 11:19: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 <= 39 AND d.MaxAge > 39)) and m.TypeID = @val3 ORDER BY m.ID Query 11:19:23 - IsConnectionValid True 11:19: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 11:19:23 - IsConnectionValid True 11:19: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 <= 17 AND d.MaxAge > 17)) and m.TypeID = @val3 ORDER BY m.ID Query 11:19:23 - IsConnectionValid True 11:19: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 <= 4 AND d.MaxAge > 4)) and m.TypeID = @val3 ORDER BY m.ID Query 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - 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 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - SELECT * FROM Employees WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 ORDER BY ID Query 11:19:37 - 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 11:19:37 - 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 11:19:37 - SELECT * FROM EmpWifeInfo WHERE TenantID = 1 AND TenantID = @val0 and EmpId = @val1 ORDER BY ID Query 11:19:37 - 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 11:19:37 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:19:37 - IsConnectionValid True 11:19:37 - SELECT * FROM EmployeeChild WHERE TenantID = 1 AND TenantID = @val0 and FatherID = @val1 ORDER BY ID Query 11:19:37 - IsConnectionValid True 11:19:37 - 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 11:19:37 - IsConnectionValid True 11:19:37 - 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 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - IsConnectionValid True 11:19:37 - 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 11:19:37 - 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 11:19:37 - 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 11:22:55 - IsConnectionValid True 11:22:59 - IsConnectionValid True 11:22:59 - 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 11:23:01 - IsConnectionValid True 11:23:01 - SELECT * FROM InsuranceDefinitionsDetails WHERE TenantID = 1 AND InsuranceDefinitionID = @val0 AND TenantID = @val1 ORDER BY ID asc Query 11:23:53 - IsConnectionValid True 11:27:02 - IsConnectionValid True 11:36:28 - IsConnectionValid True 11:36:45 - IsConnectionValid True 12:00:16 - IsConnectionValid True 12:00:18 - IsConnectionValid True 12:01:02 - IsConnectionValid True 13:20:31 - IsConnectionValid True 13:20:58 - IsConnectionValid True 13:21:00 - IsConnectionValid True 13:21:06 - IsConnectionValid True 13:21:10 - IsConnectionValid True 13:21:14 - IsConnectionValid True 13:21:56 - IsConnectionValid True 13:31:02 - IsConnectionValid True 13:31:04 - IsConnectionValid True