MySQL Query Error:
SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.NAME as NAME,BE.ACTIVE as ACTIVE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y')) as DATE_ACTIVE_TO,BE.SORT as SORT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,BE.TAGS as TAGS,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID , PRD.QUANTITY as QUANTITY, PRD.TYPE as TYPE, PRD.AVAILABLE as AVAILABLE, PRD.BUNDLE as BUNDLE, IF (PRD.QUANTITY_TRACE = 'D', 'Y', PRD.QUANTITY_TRACE) as QUANTITY_TRACE, IF (PRD.CAN_BUY_ZERO = 'D', 'N', PRD.CAN_BUY_ZERO) as CAN_BUY_ZERO, PRD.MEASURE as MEASURE, IF (PRD.SUBSCRIBE = 'D', 'N', PRD.SUBSCRIBE) as SUBSCRIBE, PRD.VAT_ID as VAT_ID, PRD.VAT_INCLUDED as VAT_INCLUDED, PRD.WEIGHT as WEIGHT, PRD.WIDTH as WIDTH, PRD.LENGTH as LENGTH, PRD.HEIGHT as HEIGHT, PRD.PRICE_TYPE as PAYMENT_TYPE, PRD.RECUR_SCHEME_LENGTH as RECUR_SCHEME_LENGTH, PRD.RECUR_SCHEME_TYPE as RECUR_SCHEME_TYPE, PRD.TRIAL_PRICE_ID as TRIAL_PRICE_ID, PRD.QUANTITY_TRACE as QUANTITY_TRACE_RAW, PRD.CAN_BUY_ZERO as CAN_BUY_ZERO_RAW, PRD.SUBSCRIBE as SUBSCRIBE_RAW, PRD.PURCHASING_PRICE as PURCHASING_PRICE, PRD.PURCHASING_CURRENCY as PURCHASING_CURRENCY, PRD.BARCODE_MULTI as BARCODE_MULTI, PRD.WITHOUT_ORDER as WITHOUT_ORDER
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
INNER JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='PRIMENIMOST'
INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
left join b_catalog_product as PRD on (PRD.ID = BE.ID)
WHERE 1=1
AND (
(EXISTS (
SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID
AND (((SITE_ID='s1')))
))
AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
AND ((((BE.ACTIVE='Y'))))
AND ((((BE.IBLOCK_ID = '21'))))
AND ((((FPV0.VALUE LIKE '1220')) OR ((FPV0.VALUE LIKE '1226')) OR ((FPV0.VALUE LIKE '1228')) OR ((FPV0.VALUE LIKE '1229')) OR ((FPV0.VALUE LIKE '4814')) OR ((FPV0.VALUE LIKE '1232')) OR ((FPV0.VALUE LIKE '1233')) OR ((FPV0.VALUE LIKE '1234')) OR ((FPV0.VALUE LIKE '3642')) OR ((FPV0.VALUE LIKE '1235')) OR ((FPV0.VALUE LIKE '1237')) OR ((FPV0.VALUE LIKE '1238')) OR ((FPV0.VALUE LIKE '1241')) OR ((FPV0.VALUE LIKE '1242')) OR ((FPV0.VALUE LIKE '1243')) OR ((FPV0.VALUE LIKE '2794')) OR ((FPV0.VALUE LIKE '1245')) OR ((FPV0.VALUE LIKE '2773')) OR ((FPV0.VALUE LIKE '1248')) OR ((FPV0.VALUE LIKE '1249')) OR ((FPV0.VALUE LIKE '1250')) OR ((FPV0.VALUE LIKE '1252')) OR ((FPV0.VALUE LIKE '1253')) OR ((FPV0.VALUE LIKE '1254')) OR ((FPV0.VALUE LIKE '1255')) OR ((FPV0.VALUE LIKE '4435')) OR ((FPV0.VALUE LIKE '4082')) OR ((FPV0.VALUE LIKE '1259')) OR ((FPV0.VALUE LIKE '3053')) OR ((FPV0.VALUE LIKE '1261')) OR ((FPV0.VALUE LIKE '1262')) OR ((FPV0.VALUE LIKE '1264')) OR ((FPV0.VALUE LIKE '1265')) OR ((FPV0.VALUE LIKE '1257')) OR ((FPV0.VALUE LIKE '4655')) OR ((FPV0.VALUE LIKE '1267')) OR ((FPV0.VALUE LIKE '1269')) OR ((FPV0.VALUE LIKE '3641'))))
AND ((((PRD.AVAILABLE='Y'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
AND ((
B.ID IN (
SELECT IBLOCK_ID
FROM b_iblock_group IBG
WHERE IBG.GROUP_ID IN (2)
AND IBG.PERMISSION >= 'R'
AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
)
OR (B.RIGHTS_MODE = 'E' AND EXISTS (
SELECT ER.ELEMENT_ID
FROM b_iblock_element_right ER
INNER JOIN b_iblock_right IBR ON IBR.ID = ER.RIGHT_ID
INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
WHERE ER.ELEMENT_ID = BE.ID
AND IBR.OP_EREAD = 'Y'
))
))
ORDER BY PRD.QUANTITY desc ,BE.ID desc
LIMIT 0, 20[[2006] MySQL server has gone away]
DB query error.
Please try later.
|
|
Fatal error: Uncaught Bitrix\Main\DB\SqlQueryException: Mysql query error: (2006) MySQL server has gone away in /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/mysqliconnection.php:145
Stack trace:
#0 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/connection.php(330): Bitrix\Main\DB\MysqliConnection->queryInternal()
#1 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/query/query.php(3304): Bitrix\Main\DB\Connection->query()
#2 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/query/query.php(816): Bitrix\Main\ORM\Query\Query->query()
#3 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/orm/data/datamanager.php(500): Bitrix\Main\ORM\Query\Query->exec()
#4 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/analytics/sitespeed.php(95): Bitrix\Main\ORM\Data\DataManager::getList()
#5 /home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/analytics/counter.php(92): Bitrix\Main in
/home/bitrix/ext_www/xn--80apgbidj1a.xn--p1ai/bitrix/modules/main/lib/db/mysqliconnection.php on line
145