0 503097bd2206e44e7ccc1a80c4b1700a O:31:"Doctrine\ORM\Query\ParserResult":3:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";O:44:"Doctrine\ORM\Query\Exec\SingleSelectExecutor":2:{s:16:"*sqlStatements";s:433:"SELECT SUM(p0_.quantite) AS sclr_0, SUM(p0_.cout_en_USD) AS sclr_1, c1_.nom AS nom_2, f2_.unite AS unite_3, SUBSTRING(p0_.date_production FROM 6 FOR 2) AS sclr_4 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_.date_production BETWEEN ? AND ?) AND p0_.commodite_id = ? AND p0_.is_publish = 1 GROUP BY c1_.nom, f2_.unite, sclr_4 ORDER BY sclr_4 ASC";s:20:"*queryCacheProfile";N;}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";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:"quantite";s:6:"sclr_1";s:4:"cout";s:5:"nom_2";s:9:"commodite";s:7:"unite_3";s:5:"unite";s:6:"sclr_4";s:4:"mois";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:5:{s:6:"sclr_0";s:6:"string";s:6:"sclr_1";s:6:"string";s:5:"nom_2";s:6:"string";s:7:"unite_3";s:6:"string";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:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:3:{s:5:"debut";a:1:{i:0;i:0;}s:3:"fin";a:1:{i:0;i:1;}s:9:"commodite";a:1:{i:0;i:2;}}}