Сортировка
Только товары в наличии
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (2006) MySQL server has gone away (400)
SELECT 
	`catalog_price`.`ID` AS `ID`,
	`catalog_price`.`PRODUCT_ID` AS `PRODUCT_ID`,
	`catalog_price`.`CATALOG_GROUP_ID` AS `CATALOG_GROUP_ID`,
	`catalog_price`.`PRICE` AS `PRICE`,
	`catalog_price`.`CURRENCY` AS `CURRENCY`,
	`catalog_price`.`QUANTITY_FROM` AS `QUANTITY_FROM`,
	`catalog_price`.`QUANTITY_TO` AS `QUANTITY_TO`,
	`catalog_price`.`EXTRA_ID` AS `EXTRA_ID`
FROM `b_catalog_price` `catalog_price` 

WHERE `catalog_price`.`PRODUCT_ID` IN (372477,372480,372483,372486,372492,372495,372498,372501,372504,372507,372510,372513,372516,372519,372525,372528,372535,372539,372551,372554,372558,372561,372565,372571,372574,372581,372584,372587,372590,372593,372934,434005,441103,441106,441109,441113,441151,441154,441158,441161,441164,441167,441170,441173,441177,441183,441186,441189)
AND `catalog_price`.`CATALOG_GROUP_ID` IN (4,5)
ORDER BY `PRODUCT_ID` ASC, `CATALOG_GROUP_ID` ASC
/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/query/query.php:3306
#2: Bitrix\Main\ORM\Query\Query->query(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/query/query.php:817
#3: Bitrix\Main\ORM\Query\Query->exec()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/data/datamanager.php:500
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:2664
#5: Bitrix\Iblock\Component\Base->loadPrices(array)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:3591
#6: Bitrix\Iblock\Component\Base->processProducts()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4100
#7: Bitrix\Iblock\Component\Base->prepareData()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4053
#8: Bitrix\Iblock\Component\Base->processResultData()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/components/bitrix/catalog.section/class.php:92
#9: CatalogSectionComponent->processResultData()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4551
#10: Bitrix\Iblock\Component\Base->loadData()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/elementlist.php:1232
#11: Bitrix\Iblock\Component\ElementList->loadData()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4540
#12: Bitrix\Iblock\Component\Base->initialLoadAction()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/components/bitrix/catalog.section/class.php:334
#13: CatalogSectionComponent->initialLoadAction()
	
#14: call_user_func(array)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4725
#15: Bitrix\Iblock\Component\Base->doAction()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/iblock/lib/component/base.php:4743
#16: Bitrix\Iblock\Component\Base->executeComponent()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component.php:649
#17: CBitrixComponent->includeComponent(string, array, object)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/main.php:1039
#18: CAllMain->IncludeComponent(string, string, array, object)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/templates/catalog-test/components/bitrix/catalog/pure/section_vertical.php:580
#19: include(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/templates/catalog-test/components/bitrix/catalog/pure/section.php:153
#20: include(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component_template.php:789
#21: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component_template.php:884
#22: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component.php:746
#23: CBitrixComponent->showComponentTemplate()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component.php:694
#24: CBitrixComponent->includeComponentTemplate(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/components/bitrix/catalog/component.php:171
#25: include(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component.php:605
#26: CBitrixComponent->__includeComponent()
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/component.php:664
#27: CBitrixComponent->includeComponent(string, array, boolean)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/classes/general/main.php:1039
#28: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/bitrix/ext_www/velomirshop.ru/catalog/index.php:750
#29: include_once(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/include/urlrewrite.php:159
#30: include_once(string)
	/home/bitrix/ext_www/velomirshop.ru/bitrix/urlrewrite.php:2

Fatal error: Uncaught Bitrix\Main\DB\SqlQueryException: Mysql query error: (2006) MySQL server has gone away in /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/db/mysqliconnection.php:137 Stack trace: #0 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/db/connection.php(330): Bitrix\Main\DB\MysqliConnection->queryInternal('SELECT \n\t`main_...', Array, NULL) #1 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/query/query.php(3306): Bitrix\Main\DB\Connection->query('SELECT \n\t`main_...') #2 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/query/query.php(817): Bitrix\Main\ORM\Query\Query->query('SELECT \n\t`main_...') #3 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/orm/data/datamanager.php(500): Bitrix\Main\ORM\Query\Query->exec() #4 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/analytics/sitespeed.php(95): Bitrix\Main\ORM\Data\DataManager::getList(Array) #5 /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/analytics/counter.php(92 in /home/bitrix/ext_www/velomirshop.ru/bitrix/modules/main/lib/db/mysqliconnection.php on line 137