Быстрый поиск по товарам

    $Shop_Controller_Show = new Shop_Controller_Show(
         Core_Entity::factory('Shop', 1)
      );
      
    $Shop_Controller_Show
         ->xsl(
            Core_Entity::factory('Xsl')->getByName('ПоискПоТоварам')
         )
         ->groupsMode('none')
         ->itemsForbiddenTags(array('text'))
         ->group(FALSE)
         ->limit(2);

    $Shop_Controller_Show
         ->shopItems()
         ->queryBuilder()
         ->where('name', 'LIKE','%'. Core_Array::getPost('textSearch').'%');

    $Shop_Controller_Show
        ->cache(FALSE)
        ->show();

    echo $Shop_Controller_Show->shopItems()->queryBuilder()->build();

SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` WHERE `shop_items`.`shop_id` = 1 AND ( `shop_items`.`start_datetime` < '2014-10-27 16:24:31' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2014-10-27 16:24:31' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `name` LIKE '%SUBARU%' AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 ORDER BY `shop_items`.`sorting` ASC, `shop_items`.`name` ASC LIMIT 2 OFFSET 0