0 edd254c6166cd1749c365dc33b8c6aad 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:350:"SELECT o0_.id AS sclr_0, o0_.name AS sclr_1, COUNT(h1_.emp_number) AS sclr_2 FROM hs_hr_emp_locations h2_ LEFT JOIN hs_hr_employee h1_ ON h2_.emp_number = h1_.emp_number LEFT JOIN ohrm_location o0_ ON h2_.location_id = o0_.id WHERE h1_.termination_id IS NULL AND h1_.purged_at IS NULL GROUP BY o0_.id ORDER BY COUNT(h1_.emp_number) DESC, o0_.name ASC";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:3:{s:6:"sclr_0";i:1;s:6:"sclr_1";i:2;s:6:"sclr_2";i:3;}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:3:{s:6:"sclr_0";s:7:"integer";s:6:"sclr_1";s:6:"string";s:6:"sclr_2";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:3:{s:6:"sclr_0";a:3:{s:9:"className";s:45:"OrangeHRM\Dashboard\Dto\LocationEmployeeCount";s:8:"objIndex";i:0;s:8:"argIndex";i:0;}s:6:"sclr_1";a:3:{s:9:"className";s:45:"OrangeHRM\Dashboard\Dto\LocationEmployeeCount";s:8:"objIndex";i:0;s:8:"argIndex";i:1;}s:6:"sclr_2";a:3:{s:9:"className";s:45:"OrangeHRM\Dashboard\Dto\LocationEmployeeCount";s:8:"objIndex";i:0;s:8:"argIndex";i:2;}}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:51:"Doctrine\ORM\Query\ParserResult_parameterMappings";a:0:{}}