← Все статьи

N+1 в выборках CRM

PHP
<?php

$companyIds = array_values(array_unique(array_filter(array_column($deals, 'COMPANY_ID'))));
$companies = [];

if ($companyIds) {
    $rs = \Bitrix\Crm\CompanyTable::getList([
        'filter' => ['@ID' => $companyIds],
        'select' => ['ID', 'TITLE'],
    ]);
    while ($row = $rs->fetch()) {
        $companies[(int) $row['ID']] = $row;
    }
}