TYPO3 Extbase -仅查询特定uid范围内的记录

use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Utility\GeneralUtility;

// 获取数据库连接
$connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
$connection = $connectionPool->getConnectionForTable('your_table_name');

// 创建查询构建器
$queryBuilder = $connection->createQueryBuilder();

// 构建查询
$query = $queryBuilder
    ->select('*')
    ->from('your_table_name')
    ->where(
        $queryBuilder->expr()->between(
            'uid',
            $queryBuilder->createNamedParameter($startUid),
            $queryBuilder->createNamedParameter($endUid)
        )
    )
    ->execute();

// 处理查询结果
while ($row = $query->fetch()) {
    // 处理每一行记录
    // ...
}