0 72201069576c0fad575f2e4bcc77c8c2 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:392:"SELECT SUM(v0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_3 FROM vente_local v0_ INNER JOIN commodite c1_ ON v0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (v0_.date_vente BETWEEN ? AND ?) AND v0_.commodite_id = ? AND v0_.is_publish = 1 GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 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:4:{s:6:"sclr_0";s:8:"quantite";s:5:"nom_1";s:9:"commodite";s:7:"unite_2";s:5:"unite";s:6:"sclr_3";s:4:"mois";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:4:{s:6:"sclr_0";s:6:"string";s:5:"nom_1";s:6:"string";s:7:"unite_2";s:6:"string";s:6:"sclr_3";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;}}}