| 1 |
2.60 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = 'izab' LIMIT 1;
|
| 3 |
1.19 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = 'izab' LIMIT 1;
|
| 5 |
1.00 ms |
SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.title AS title_2, t0_.message AS message_3, t0_."isRead" AS isread_4, t0_."isHidden" AS ishidden_5, t0_."createdAt" AS createdat_6, t0_."userId" AS userid_7 FROM "CRM_Pro_Notifications" t0_ WHERE t0_."userId" = ? AND t0_."isHidden" = false ORDER BY t0_."createdAt" DESC LIMIT 50
SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.title AS title_2, t0_.message AS message_3, t0_."isRead" AS isread_4, t0_."isHidden" AS ishidden_5, t0_."createdAt" AS createdat_6, t0_."userId" AS userid_7 FROM "CRM_Pro_Notifications" t0_ WHERE t0_."userId" = 5 AND t0_."isHidden" = false ORDER BY t0_."createdAt" DESC LIMIT 50;
|