0 1f21a7319754bbb1704d8f640afbbf5e 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:634:"SELECT CONCAT(h0_.emp_firstname, ' ', h0_.emp_lastname) AS sclr_0, o1_.id AS id_1, h0_.termination_id AS sclr_2, h0_.emp_number AS emp_number_3, SUM(ROUND(TIME_TO_SEC(TIMEDIFF(COALESCE(o1_.punch_out_utc_time, 0), COALESCE(o1_.punch_in_utc_time, 0)))/1, 0)) AS sclr_4 FROM hs_hr_employee h0_ LEFT JOIN ohrm_job_title o2_ ON h0_.job_title_code = o2_.id LEFT JOIN ohrm_subunit o3_ ON h0_.work_station = o3_.id LEFT JOIN ohrm_employment_status o4_ ON h0_.emp_status = o4_.id LEFT JOIN ohrm_attendance_record o1_ ON h0_.emp_number = o1_.employee_id WHERE h0_.emp_number IN (?) GROUP BY h0_.emp_number ORDER BY h0_.emp_lastname ASC LIMIT 50";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:0:{}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:0:{}s:14:"scalarMappings";a:5:{s:6:"sclr_0";s:8:"fullName";s:4:"id_1";s:2:"id";s:6:"sclr_2";s:13:"terminationId";s:12:"emp_number_3";s:9:"empNumber";s:6:"sclr_4";s:5:"total";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:5:{s:6:"sclr_0";s:6:"string";s:4:"id_1";s:7:"integer";s:6:"sclr_2";s:6:"string";s:12:"emp_number_3";s:7:"integer";s:6:"sclr_4";s:6:"string";}s:14:"entityMappings";a:0:{}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:0:{}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:0:{}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;}}}