0 8fc3e0c7bda2cc20447490a0c01dc56b 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:570:"SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.user_name AS user_name_1, o0_.user_password AS user_password_2, o0_.deleted AS deleted_3, o0_.status AS status_4, o0_.date_entered AS date_entered_5, o0_.date_modified AS date_modified_6, o0_.modified_user_id AS modified_user_id_7, o0_.created_by AS created_by_8 FROM ohrm_user o0_ LEFT JOIN ohrm_user_role o1_ ON o0_.user_role_id = o1_.id LEFT JOIN hs_hr_employee h2_ ON o0_.emp_number = h2_.emp_number WHERE o0_.deleted = ? ORDER BY o0_.user_name 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:1:"u";s:21:"OrangeHRM\Entity\User";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:9:{s:4:"id_0";s:2:"id";s:11:"user_name_1";s:8:"userName";s:15:"user_password_2";s:12:"userPassword";s:9:"deleted_3";s:7:"deleted";s:8:"status_4";s:6:"status";s:14:"date_entered_5";s:11:"dateEntered";s:15:"date_modified_6";s:12:"dateModified";s:18:"modified_user_id_7";s:14:"modifiedUserId";s:12:"created_by_8";s:9:"createdBy";}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:1:"u";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:9:{s:4:"id_0";s:1:"u";s:11:"user_name_1";s:1:"u";s:15:"user_password_2";s:1:"u";s:9:"deleted_3";s:1:"u";s:8:"status_4";s:1:"u";s:14:"date_entered_5";s:1:"u";s:15:"date_modified_6";s:1:"u";s:18:"modified_user_id_7";s:1:"u";s:12:"created_by_8";s:1:"u";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:9:{s:4:"id_0";s:21:"OrangeHRM\Entity\User";s:11:"user_name_1";s:21:"OrangeHRM\Entity\User";s:15:"user_password_2";s:21:"OrangeHRM\Entity\User";s:9:"deleted_3";s:21:"OrangeHRM\Entity\User";s:8:"status_4";s:21:"OrangeHRM\Entity\User";s:14:"date_entered_5";s:21:"OrangeHRM\Entity\User";s:15:"date_modified_6";s:21:"OrangeHRM\Entity\User";s:18:"modified_user_id_7";s:21:"OrangeHRM\Entity\User";s:12:"created_by_8";s:21:"OrangeHRM\Entity\User";}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:7:"deleted";a:1:{i:0;i:0;}}}