alekseikovrigin/qubixqueries

快速Bitrix查询

dev-master 2023-11-12 20:50 UTC

This package is auto-updated.

Last update: 2024-09-04 19:43:37 UTC


README

用途:用于替换在性能要求严格的地方的元素选择查询

$result = Query::getList(array( 
    'select' => array('ISBN', 'TITLE', 'PUBLISH_DATE') 
    'filter' => array('IBLOCK_ID' => 1, '=ID' => 1) 
)); 
// или
$q = new Query(); 
$q->setSelect(array('ISBN', 'TITLE', 'PUBLISH_DATE')); 
$q-setFilter(array('IBLOCK_ID' => 1, '=ID' => 1 )); 
$result = $q->exec();
如果信息块id未知

如果信息块id未知(或者如果过滤器动态添加,例如),可以指定类名(不带getEntity()方法),但这会增加一个数据库查询

$result = Query::getList(array( 
   'select' => array('ISBN', 'TITLE', 'PUBLISH_DATE') 
   'filter' => array('=ID' => 1) 
),
   \ElementBookTable::class,
); 
// или
$q = new Query(\ElementBookTable::class); 
$q->setSelect(array('ISBN', 'TITLE', 'PUBLISH_DATE')); 
$q->setFilter(array('=ID' => 1)); 
$result = $q->exec();