0 ca249bb26e15441fcd93132d0c0b39cc O:31:"Doctrine\ORM\Query\ParserResult":3:{s:45:"Doctrine\ORM\Query\ParserResult_sqlExecutor";O:44:"Doctrine\ORM\Query\Exec\SingleSelectExecutor":2:{s:17:"*_sqlStatements";s:2014:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT emp_number_0 FROM (SELECT DISTINCT h0_.emp_number AS emp_number_0, h0_.employee_id AS employee_id_1, h0_.emp_lastname AS emp_lastname_2, h0_.emp_firstname AS emp_firstname_3, h0_.emp_middle_name AS emp_middle_name_4, h0_.emp_nick_name AS emp_nick_name_5, h0_.emp_smoker AS emp_smoker_6, h0_.ethnic_race_code AS ethnic_race_code_7, h0_.emp_birthday AS emp_birthday_8, h0_.emp_gender AS emp_gender_9, h0_.emp_marital_status AS emp_marital_status_10, h0_.emp_ssn_num AS emp_ssn_num_11, h0_.emp_sin_num AS emp_sin_num_12, h0_.emp_other_id AS emp_other_id_13, h0_.emp_dri_lice_num AS emp_dri_lice_num_14, h0_.emp_dri_lice_exp_date AS emp_dri_lice_exp_date_15, h0_.emp_military_service AS emp_military_service_16, h0_.emp_street1 AS emp_street1_17, h0_.emp_street2 AS emp_street2_18, h0_.city_code AS city_code_19, h0_.coun_code AS coun_code_20, h0_.provin_code AS provin_code_21, h0_.emp_zipcode AS emp_zipcode_22, h0_.emp_hm_telephone AS emp_hm_telephone_23, h0_.emp_mobile AS emp_mobile_24, h0_.emp_work_telephone AS emp_work_telephone_25, h0_.emp_work_email AS emp_work_email_26, h0_.sal_grd_code AS sal_grd_code_27, h0_.joined_date AS joined_date_28, h0_.emp_oth_email AS emp_oth_email_29, h0_.custom1 AS custom1_30, h0_.custom2 AS custom2_31, h0_.custom3 AS custom3_32, h0_.custom4 AS custom4_33, h0_.custom5 AS custom5_34, h0_.custom6 AS custom6_35, h0_.custom7 AS custom7_36, h0_.custom8 AS custom8_37, h0_.custom9 AS custom9_38, h0_.custom10 AS custom10_39, h0_.purged_at AS purged_at_40 FROM hs_hr_employee h0_ LEFT JOIN ohrm_job_title o1_ ON h0_.job_title_code = o1_.id LEFT JOIN ohrm_subunit o2_ ON h0_.work_station = o2_.id LEFT JOIN ohrm_employment_status o3_ ON h0_.emp_status = o3_.id LEFT JOIN hs_hr_emp_locations h5_ ON h0_.emp_number = h5_.emp_number LEFT JOIN ohrm_location o4_ ON o4_.id = h5_.location_id WHERE h0_.termination_id IS NULL AND h0_.emp_number IN (?) AND h0_.purged_at IS NULL ORDER BY h0_.emp_lastname ASC) dctrn_result) dctrn_table";s:20:"*queryCacheProfile";N;}s:50:"Doctrine\ORM\Query\ParserResult_resultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":19:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:8:"employee";s:25:"OrangeHRM\Entity\Employee";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:41:{s:12:"emp_number_0";s:9:"empNumber";s:13:"employee_id_1";s:10:"employeeId";s:14:"emp_lastname_2";s:8:"lastName";s:15:"emp_firstname_3";s:9:"firstName";s:17:"emp_middle_name_4";s:10:"middleName";s:15:"emp_nick_name_5";s:8:"nickName";s:12:"emp_smoker_6";s:6:"smoker";s:18:"ethnic_race_code_7";s:14:"ethnicRaceCode";s:14:"emp_birthday_8";s:8:"birthday";s:12:"emp_gender_9";s:6:"gender";s:21:"emp_marital_status_10";s:13:"maritalStatus";s:14:"emp_ssn_num_11";s:9:"ssnNumber";s:14:"emp_sin_num_12";s:9:"sinNumber";s:15:"emp_other_id_13";s:7:"otherId";s:19:"emp_dri_lice_num_14";s:16:"drivingLicenseNo";s:24:"emp_dri_lice_exp_date_15";s:25:"drivingLicenseExpiredDate";s:23:"emp_military_service_16";s:15:"militaryService";s:14:"emp_street1_17";s:7:"street1";s:14:"emp_street2_18";s:7:"street2";s:12:"city_code_19";s:4:"city";s:12:"coun_code_20";s:7:"country";s:14:"provin_code_21";s:8:"province";s:14:"emp_zipcode_22";s:7:"zipcode";s:19:"emp_hm_telephone_23";s:13:"homeTelephone";s:13:"emp_mobile_24";s:6:"mobile";s:21:"emp_work_telephone_25";s:13:"workTelephone";s:17:"emp_work_email_26";s:9:"workEmail";s:15:"sal_grd_code_27";s:15:"salaryGradeCode";s:14:"joined_date_28";s:10:"joinedDate";s:16:"emp_oth_email_29";s:10:"otherEmail";s:10:"custom1_30";s:7:"custom1";s:10:"custom2_31";s:7:"custom2";s:10:"custom3_32";s:7:"custom3";s:10:"custom4_33";s:7:"custom4";s:10:"custom5_34";s:7:"custom5";s:10:"custom6_35";s:7:"custom6";s:10:"custom7_36";s:7:"custom7";s:10:"custom8_37";s:7:"custom8";s:10:"custom9_38";s:7:"custom9";s:11:"custom10_39";s:8:"custom10";s:12:"purged_at_40";s:8:"purgedAt";}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:8:"employee";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:41:{s:12:"emp_number_0";s:8:"employee";s:13:"employee_id_1";s:8:"employee";s:14:"emp_lastname_2";s:8:"employee";s:15:"emp_firstname_3";s:8:"employee";s:17:"emp_middle_name_4";s:8:"employee";s:15:"emp_nick_name_5";s:8:"employee";s:12:"emp_smoker_6";s:8:"employee";s:18:"ethnic_race_code_7";s:8:"employee";s:14:"emp_birthday_8";s:8:"employee";s:12:"emp_gender_9";s:8:"employee";s:21:"emp_marital_status_10";s:8:"employee";s:14:"emp_ssn_num_11";s:8:"employee";s:14:"emp_sin_num_12";s:8:"employee";s:15:"emp_other_id_13";s:8:"employee";s:19:"emp_dri_lice_num_14";s:8:"employee";s:24:"emp_dri_lice_exp_date_15";s:8:"employee";s:23:"emp_military_service_16";s:8:"employee";s:14:"emp_street1_17";s:8:"employee";s:14:"emp_street2_18";s:8:"employee";s:12:"city_code_19";s:8:"employee";s:12:"coun_code_20";s:8:"employee";s:14:"provin_code_21";s:8:"employee";s:14:"emp_zipcode_22";s:8:"employee";s:19:"emp_hm_telephone_23";s:8:"employee";s:13:"emp_mobile_24";s:8:"employee";s:21:"emp_work_telephone_25";s:8:"employee";s:17:"emp_work_email_26";s:8:"employee";s:15:"sal_grd_code_27";s:8:"employee";s:14:"joined_date_28";s:8:"employee";s:16:"emp_oth_email_29";s:8:"employee";s:10:"custom1_30";s:8:"employee";s:10:"custom2_31";s:8:"employee";s:10:"custom3_32";s:8:"employee";s:10:"custom4_33";s:8:"employee";s:10:"custom5_34";s:8:"employee";s:10:"custom6_35";s:8:"employee";s:10:"custom7_36";s:8:"employee";s:10:"custom8_37";s:8:"employee";s:10:"custom9_38";s:8:"employee";s:11:"custom10_39";s:8:"employee";s:12:"purged_at_40";s:8:"employee";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:41:{s:12:"emp_number_0";s:25:"OrangeHRM\Entity\Employee";s:13:"employee_id_1";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_lastname_2";s:25:"OrangeHRM\Entity\Employee";s:15:"emp_firstname_3";s:25:"OrangeHRM\Entity\Employee";s:17:"emp_middle_name_4";s:25:"OrangeHRM\Entity\Employee";s:15:"emp_nick_name_5";s:25:"OrangeHRM\Entity\Employee";s:12:"emp_smoker_6";s:25:"OrangeHRM\Entity\Employee";s:18:"ethnic_race_code_7";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_birthday_8";s:25:"OrangeHRM\Entity\Employee";s:12:"emp_gender_9";s:25:"OrangeHRM\Entity\Employee";s:21:"emp_marital_status_10";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_ssn_num_11";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_sin_num_12";s:25:"OrangeHRM\Entity\Employee";s:15:"emp_other_id_13";s:25:"OrangeHRM\Entity\Employee";s:19:"emp_dri_lice_num_14";s:25:"OrangeHRM\Entity\Employee";s:24:"emp_dri_lice_exp_date_15";s:25:"OrangeHRM\Entity\Employee";s:23:"emp_military_service_16";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_street1_17";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_street2_18";s:25:"OrangeHRM\Entity\Employee";s:12:"city_code_19";s:25:"OrangeHRM\Entity\Employee";s:12:"coun_code_20";s:25:"OrangeHRM\Entity\Employee";s:14:"provin_code_21";s:25:"OrangeHRM\Entity\Employee";s:14:"emp_zipcode_22";s:25:"OrangeHRM\Entity\Employee";s:19:"emp_hm_telephone_23";s:25:"OrangeHRM\Entity\Employee";s:13:"emp_mobile_24";s:25:"OrangeHRM\Entity\Employee";s:21:"emp_work_telephone_25";s:25:"OrangeHRM\Entity\Employee";s:17:"emp_work_email_26";s:25:"OrangeHRM\Entity\Employee";s:15:"sal_grd_code_27";s:25:"OrangeHRM\Entity\Employee";s:14:"joined_date_28";s:25:"OrangeHRM\Entity\Employee";s:16:"emp_oth_email_29";s:25:"OrangeHRM\Entity\Employee";s:10:"custom1_30";s:25:"OrangeHRM\Entity\Employee";s:10:"custom2_31";s:25:"OrangeHRM\Entity\Employee";s:10:"custom3_32";s:25:"OrangeHRM\Entity\Employee";s:10:"custom4_33";s:25:"OrangeHRM\Entity\Employee";s:10:"custom5_34";s:25:"OrangeHRM\Entity\Employee";s:10:"custom6_35";s:25:"OrangeHRM\Entity\Employee";s:10:"custom7_36";s:25:"OrangeHRM\Entity\Employee";s:10:"custom8_37";s:25:"OrangeHRM\Entity\Employee";s:10:"custom9_38";s:25:"OrangeHRM\Entity\Employee";s:11:"custom10_39";s:25:"OrangeHRM\Entity\Employee";s:12:"purged_at_40";s:25:"OrangeHRM\Entity\Employee";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:51:"Doctrine\ORM\Query\ParserResult_parameterMappings";a:1:{s:10:"empNumbers";a:1:{i:0;i:0;}}}