0 d9c1fc0a9e7f03e1559bfe1c3cc250ee 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:448:"SELECT COUNT(*) AS dctrn_count FROM (SELECT o0_.id AS id_0, o0_.date_applied AS date_applied_1 FROM ohrm_leave_request o0_ LEFT JOIN ohrm_leave o1_ ON o0_.id = o1_.leave_request_id LEFT JOIN hs_hr_employee h2_ ON o0_.emp_number = h2_.emp_number WHERE o0_.emp_number IN (?) AND h2_.termination_id IS NULL AND o1_.status IN (?) AND h2_.purged_at IS NULL GROUP BY o0_.id ORDER BY o1_.date DESC, h2_.emp_lastname ASC, h2_.emp_firstname ASC) 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:12:"leaveRequest";s:29:"OrangeHRM\Entity\LeaveRequest";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:2:{s:4:"id_0";s:2:"id";s:14:"date_applied_1";s:11:"dateApplied";}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:12:"leaveRequest";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:2:{s:4:"id_0";s:12:"leaveRequest";s:14:"date_applied_1";s:12:"leaveRequest";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:2:{s:4:"id_0";s:29:"OrangeHRM\Entity\LeaveRequest";s:14:"date_applied_1";s:29:"OrangeHRM\Entity\LeaveRequest";}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:2:{s:10:"empNumbers";a:1:{i:0;i:0;}s:8:"statuses";a:1:{i:0;i:1;}}}