| 1 |
1.70 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.force_password_change AS force_password_change_6, t0.totp_secret AS totp_secret_7, t0.username AS username_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.second_name AS second_name_12, t9.first_sur_name AS first_sur_name_13, t9.second_sur_name AS second_sur_name_14, t9.birthday AS birthday_15, t9.social_security_number AS social_security_number_16, t9.rfcnumber AS rfcnumber_17, t9.gender AS gender_18, t9.payroll_number AS payroll_number_19, t9.cellphone AS cellphone_20, t9.user_id AS user_id_21, t22.id AS id_23, t22.ingress_date AS ingress_date_24, t22.egress_date AS egress_date_25, t22.clave AS clave_26, t22.sindicalized AS sindicalized_27, t22.status AS status_28, t22.payroll_number AS payroll_number_29, t22.email AS email_30, t22.boss_payroll_number AS boss_payroll_number_31, t22.vacation_balance AS vacation_balance_32, t22.user_id AS user_id_33, t22.company_id AS company_id_34, t22.department_id AS department_id_35, t22.work_role_id AS work_role_id_36, t22.payroll_id AS payroll_id_37, t22.work_site_id AS work_site_id_38, t22.work_shift_id AS work_shift_id_39, t22.boss_id AS boss_id_40 FROM `user` t0 LEFT JOIN personal_data t9 ON t9.user_id = t0.id LEFT JOIN employee_data t22 ON t22.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: [
"nestorg"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.force_password_change AS force_password_change_6, t0.totp_secret AS totp_secret_7, t0.username AS username_8, t9.id AS id_10, t9.first_name AS first_name_11, t9.second_name AS second_name_12, t9.first_sur_name AS first_sur_name_13, t9.second_sur_name AS second_sur_name_14, t9.birthday AS birthday_15, t9.social_security_number AS social_security_number_16, t9.rfcnumber AS rfcnumber_17, t9.gender AS gender_18, t9.payroll_number AS payroll_number_19, t9.cellphone AS cellphone_20, t9.user_id AS user_id_21, t22.id AS id_23, t22.ingress_date AS ingress_date_24, t22.egress_date AS egress_date_25, t22.clave AS clave_26, t22.sindicalized AS sindicalized_27, t22.status AS status_28, t22.payroll_number AS payroll_number_29, t22.email AS email_30, t22.boss_payroll_number AS boss_payroll_number_31, t22.vacation_balance AS vacation_balance_32, t22.user_id AS user_id_33, t22.company_id AS company_id_34, t22.department_id AS department_id_35, t22.work_role_id AS work_role_id_36, t22.payroll_id AS payroll_id_37, t22.work_site_id AS work_site_id_38, t22.work_shift_id AS work_shift_id_39, t22.boss_id AS boss_id_40 FROM `user` t0 LEFT JOIN personal_data t9 ON t9.user_id = t0.id LEFT JOIN employee_data t22 ON t22.user_id = t0.id WHERE t0.username = 'nestorg' LIMIT 1;
|