0
a4629a165310339e2d9315a10093c303
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:442:"SELECT SUM(e0_.quantite) AS sclr_0, t1_.nom AS nom_1, SUM(e0_.prix_en_USD) AS sclr_2, SUBSTRING(e0_.date_exportation FROM 1 FOR 7) AS sclr_3, o2_.id AS id_4 FROM exportation e0_ INNER JOIN type_commodite t1_ ON e0_.type_commodite_id = t1_.id INNER JOIN operateur o2_ ON e0_.operateur_id = o2_.id INNER JOIN commodite c3_ ON e0_.commodite_id = c3_.id WHERE e0_.is_publish = 1 AND c3_.id = ? GROUP BY t1_.nom, o2_.id, sclr_3 ORDER BY sclr_3 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:5:{s:6:"sclr_0";s:8:"quantite";s:5:"nom_1";s:9:"commodite";s:6:"sclr_2";s:6:"valeur";s:6:"sclr_3";s:4:"mois";s:4:"id_4";s:9:"operateur";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:5:{s:6:"sclr_0";s:6:"string";s:5:"nom_1";s:6:"string";s:6:"sclr_2";s:6:"string";s:6:"sclr_3";s:6:"string";s:4:"id_4";s:7:"integer";}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:1:{s:9:"commodite";a:1:{i:0;i:0;}}}