0
f7eb5f819b06d9f0747d1cecb528b843
O:31:"Doctrine\ORM\Query\ParserResult":3:{s:44:" Doctrine\ORM\Query\ParserResult sqlExecutor";O:44:"Doctrine\ORM\Query\Exec\SingleSelectExecutor":2:{s:16:" * sqlStatements";s:353:"SELECT SUM(p0_.quantite) AS sclr_0, SUM(p0_.cout_en_USD) AS sclr_1, SUBSTRING(p0_.date_production FROM 1 FOR 4) AS sclr_2 FROM production p0_ INNER JOIN commodite c1_ ON p0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE p0_.commodite_id = ? AND p0_.projet_id = ? AND p0_.is_publish = 1 GROUP BY sclr_2 ORDER BY sclr_2 ASC";s:20:" * queryCacheProfile";N;}s:49:" 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";s:8:"quantite";s:6:"sclr_1";s:4:"cout";s:6:"sclr_2";s:5:"annee";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:3:{s:6:"sclr_0";s:6:"string";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:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:50:" Doctrine\ORM\Query\ParserResult parameterMappings";a:2:{s:9:"commodite";a:1:{i:0;i:0;}s:6:"projet";a:1:{i:0;i:1;}}}