alekseikovrigin / qubixqueries
快速Bitrix查询
dev-master
2023-11-12 20:50 UTC
Requires
- php: ^7.1|^8.0
- illuminate/container: ^8.0
Requires (Dev)
- mockery/mockery: ^1.4
- phpstan/phpstan: ^1.10
- phpunit/phpunit: ^9.5
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();