Symfony: doctrine custom sql order

    $this->data = Doctrine_Query::create()
            ->from('Category c')
            ->innerJoin('c.Product p')
            ->whereIn('c.slug', array('cpu', 'mainboards', 'ram', 'hdd', 'videocards', 'cases'))
            ->addWhere('p.is_published = ?', true)
            ->addOrderBy('FIELD(c.slug, "cpu", "mainboards", "ram", "hdd", "videocards", "cases")')
            ->execute()
    ;

Symfony: upload file, save original name

public function generatePicFilename($file = null)
{
  if (null === $file) {
    return null;
  }

 return $file->getOriginalName();
}

Symfony: Doctrine IndexBy field

    $posts = Doctrine_Query::create()
           ->from('Post p INDEXBY id')
           ->fetchArray()
    ;

на выходе получаем массив индексированный по реальным значениям id,
а не [0 => array(), 1 => array() ... ]

p.s. спасибо develop7 за наводку