Форум

$rsList = CIBlockElement::GetList(
   array('NAME' => 'DESC'),
   array('IBLOCK_ID' => $arParams['IBLOCK_ID'], 'ACTIVE' => 'Y'),
   false,
   array('nPageSize' => '1', 'nElementID' => $arResult['ID']),
   array('ID')
);

while ($arItem = $rsList->Fetch()) {
   echo '<pre>';
   print_r($arItem);
   echo '</pre>';
}
 

                  SELECT @rank:=el1.rank
                  FROM (
                     SELECT @rank:=@rank+1 AS rank, el0.*
                     FROM (
                        SELECT  BE.ID as ID,BE.SORT as SORT 
         FROM 
         b_iblock B
         INNER JOIN b_lang L ON B.LID=L.LID
         INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
         
      
         WHERE 1=1 
         AND (
         
            ((((BE.IBLOCK_ID = '3'))))
            AND ((((BE.ACTIVE='Y'))))
         )
         AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
         
       ORDER BY BE.SORT asc 
                     ) el0
                  ) el1
                  WHERE el1.ID = 225 

$DB->Query("SET @rank=0");
               // $DB->Query("
               //    SELECT @rank:=el1.rank
               //    FROM (
               //       SELECT @rank:=@rank+1 AS rank, el0.*
               //       FROM (
               //          SELECT ".$sSelect.$strSql.$sOrderBy."
               //       ) el0
               //    ) el1
               //    WHERE el1.ID = ".$nElementID."
               // ");

               $DB->Query("
                  SELECT @rank:=el1.rank
                  FROM (
                     SELECT @rank:=@rank+1 AS rank, el0.*
                     FROM (
                        SELECT ".$sSelect.$strSql."
                     ) el0 " . str_replace('BE.', '', $sOrderBy) . "
                  ) el1
                  WHERE el1.ID = ".$nElementID."
               ");


               $DB->Query("SET @rank2=0");

               // $res = $DB->Query("
               //    SELECT *
               //    FROM (
               //       SELECT @rank2:=@rank2+1 AS RANK, el0.*
               //       FROM (
               //          SELECT ".$sSelect.$strSql.$sOrderBy."
               //       ) el0
               //    ) el1
               //    WHERE el1.RANK between @rank-$nPageSize and @rank+$nPageSize
               // ");
               $res = $DB->Query("
                  SELECT *
                  FROM (
                     SELECT @rank2:=@rank2+1 AS RANK, el0.*
                     FROM (
                        SELECT ".$sSelect.$strSql."
                     ) el0 " . str_replace('BE.', '', $sOrderBy) . "
                  ) el1
                  WHERE el1.RANK between @rank-$nPageSize and @rank+$nPageSize
               ");