File: /home/bitrix/ext_www/lubimchik.by/bitrix/modules/search/classes/general/search.php
Line: 265
MySQL Query Error: SELECT DISTINCT
sc.ID
,sc.MODULE_ID
,sc.ITEM_ID
,sc.TITLE
,sc.TAGS
,sc.PARAM1
,sc.PARAM2
,sc.UPD
,sc.DATE_FROM
,sc.DATE_TO
,sc.URL
,sc.CUSTOM_RANK
,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE
,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE
,sct.SEARCHABLE_CONTENT
,sc.USER_ID
,if(locate('WHISKAS', upper(sc.TITLE)) > 0, locate('WHISKAS', upper(sc.TITLE)), 250) as TITLE_RANK
,scsite.URL as SITE_URL
,scsite.SITE_ID
,1 as `RANK`
FROM
b_search_content_text sct
INNER JOIN b_search_content sc ON sc.ID = sct.SEARCH_CONTENT_ID
INNER JOIN b_search_content_site scsite ON sc.ID = scsite.SEARCH_CONTENT_ID
WHERE
((
EXISTS (
SELECT 1
FROM b_search_content_right scg
WHERE sc.ID = scg.SEARCH_CONTENT_ID
AND scg.GROUP_CODE = 'G2'
)))
AND (( (sct.searchable_content LIKE '%WHISKAS%') ))
AND (
(
scsite.SITE_ID = 's2'
AND (
(
(sc.DATE_FROM IS NULL)
OR sc.DATE_FROM <= '2026-03-22 03:02:00'
)
AND (
(sc.DATE_TO IS NULL)
OR sc.DATE_TO >= '2026-03-22 03:02:00'
)
)
AND (UPPER(sc.ITEM_ID) not like upper('226273') AND UPPER(sc.ITEM_ID) not like upper('209184') AND UPPER(sc.ITEM_ID) not like upper('209185') AND UPPER(sc.ITEM_ID) not like upper('209161') AND UPPER(sc.ITEM_ID) not like upper('209164') AND UPPER(sc.ITEM_ID) not like upper('209175') AND UPPER(sc.ITEM_ID) not like upper('209176') AND UPPER(sc.ITEM_ID) not like upper('209177') AND UPPER(sc.ITEM_ID) not like upper('209178') AND UPPER(sc.ITEM_ID) not like upper('209167') AND UPPER(sc.ITEM_ID) not like upper('209166') AND UPPER(sc.ITEM_ID) not like upper('226272') AND UPPER(sc.ITEM_ID) not like upper('226269') AND UPPER(sc.ITEM_ID) not like upper('226270') AND UPPER(sc.ITEM_ID) not like upper('226271') AND UPPER(sc.ITEM_ID) not like upper('209181') AND UPPER(sc.ITEM_ID) not like upper('209186') AND UPPER(sc.ITEM_ID) not like upper('209183') AND UPPER(sc.ITEM_ID) not like upper('209180') AND UPPER(sc.ITEM_ID) not like upper('209168') AND UPPER(sc.ITEM_ID) not like upper('207980') AND UPPER(sc.ITEM_ID) not like upper('207984') AND UPPER(sc.ITEM_ID) not like upper('213841') AND UPPER(sc.ITEM_ID) not like upper('213849') AND UPPER(sc.ITEM_ID) not like upper('209344') AND UPPER(sc.ITEM_ID) not like upper('225385') AND UPPER(sc.ITEM_ID) not like upper('207420') AND UPPER(sc.ITEM_ID) not like upper('207421') AND UPPER(sc.ITEM_ID) not like upper('207397') AND UPPER(sc.ITEM_ID) not like upper('207400') AND UPPER(sc.ITEM_ID) not like upper('207411') AND UPPER(sc.ITEM_ID) not like upper('207412') AND UPPER(sc.ITEM_ID) not like upper('207413') AND UPPER(sc.ITEM_ID) not like upper('207414') AND UPPER(sc.ITEM_ID) not like upper('207403') AND UPPER(sc.ITEM_ID) not like upper('207402') AND UPPER(sc.ITEM_ID) not like upper('225384') AND UPPER(sc.ITEM_ID) not like upper('225381') AND UPPER(sc.ITEM_ID) not like upper('225382') AND UPPER(sc.ITEM_ID) not like upper('225383') AND UPPER(sc.ITEM_ID) not like upper('207417') AND UPPER(sc.ITEM_ID) not like upper('207422') AND UPPER(sc.ITEM_ID) not like upper('207419') AND UPPER(sc.ITEM_ID) not like upper('207416') AND UPPER(sc.ITEM_ID) not like upper('207404') AND UPPER(sc.ITEM_ID) not like upper('206966') AND UPPER(sc.ITEM_ID) not like upper('213835') AND UPPER(sc.ITEM_ID) not like upper('213834') AND UPPER(sc.ITEM_ID) not like upper('207473') AND UPPER(sc.ITEM_ID) not like upper('208995') AND UPPER(sc.ITEM_ID) not like upper('207312') AND UPPER(sc.ITEM_ID) not like upper('209078') AND UPPER(sc.ITEM_ID) not like upper('207358') AND UPPER(sc.ITEM_ID) not like upper('207018') AND UPPER(sc.ITEM_ID) not like upper('208121') AND UPPER(sc.ITEM_ID) not like upper('207467') AND UPPER(sc.ITEM_ID) not like upper('209329') AND UPPER(sc.ITEM_ID) not like upper('206956') AND UPPER(sc.ITEM_ID) not like upper('207944') AND UPPER(sc.ITEM_ID) not like upper('206931') AND UPPER(sc.ITEM_ID) not like upper('207851') AND UPPER(sc.ITEM_ID) not like upper('207053') AND UPPER(sc.ITEM_ID) not like upper('208234') AND UPPER(sc.ITEM_ID) not like upper('208016') AND UPPER(sc.ITEM_ID) not like upper('206978') AND UPPER(sc.ITEM_ID) not like upper('207454') AND UPPER(sc.ITEM_ID) not like upper('209286') AND UPPER(sc.ITEM_ID) not like upper('206937') AND UPPER(sc.ITEM_ID) not like upper('207879') AND UPPER(sc.ITEM_ID) not like upper('206915') AND UPPER(sc.ITEM_ID) not like upper('207796') AND UPPER(sc.ITEM_ID) not like upper('207506') AND UPPER(sc.ITEM_ID) not like upper('209476') AND UPPER(sc.ITEM_ID) not like upper('207126') AND UPPER(sc.ITEM_ID) not like upper('208448') AND UPPER(sc.ITEM_ID) not like upper('206880') AND UPPER(sc.ITEM_ID) not like upper('207693') AND UPPER(sc.ITEM_ID) not like upper('207446') AND UPPER(sc.ITEM_ID) not like upper('209243') AND UPPER(sc.ITEM_ID) not like upper('207508') AND UPPER(sc.ITEM_ID) not like upper('209489') AND UPPER(sc.ITEM_ID) not like upper('206902') AND UPPER(sc.ITEM_ID) not like upper('207760') AND UPPER(sc.ITEM_ID) not like upper('209179') AND UPPER(sc.ITEM_ID) not like upper('207415') AND UPPER(sc.ITEM_ID) not like upper('209170') AND UPPER(sc.ITEM_ID) not like upper('207406') AND UPPER(sc.ITEM_ID) not like upper('209162') AND UPPER(sc.ITEM_ID) not like upper('207398') AND UPPER(sc.ITEM_ID) not like upper('209163') AND UPPER(sc.ITEM_ID) not like upper('207399') AND UPPER(sc.ITEM_ID) not like upper('209174') AND UPPER(sc.ITEM_ID) not like upper('207410') AND UPPER(sc.ITEM_ID) not like upper('209165') AND UPPER(sc.ITEM_ID) not like upper('207401') AND UPPER(sc.ITEM_ID) not like upper('209172') AND UPPER(sc.ITEM_ID) not like upper('207408') AND UPPER(sc.ITEM_ID) not like upper('209169') AND UPPER(sc.ITEM_ID) not like upper('207405') AND UPPER(sc.ITEM_ID) not like upper('209173') AND UPPER(sc.ITEM_ID) not like upper('207409') AND UPPER(sc.ITEM_ID) not like upper('209171') AND UPPER(sc.ITEM_ID) not like upper('207407') AND UPPER(sc.ITEM_ID) not like upper('209182') AND UPPER(sc.ITEM_ID) not like upper('207418') AND UPPER(sc.ITEM_ID) not like upper('209187') AND UPPER(sc.ITEM_ID) not like upper('207423') AND UPPER(sc.ITEM_ID) not like upper('226681') AND UPPER(sc.ITEM_ID) not like upper('209117') AND UPPER(sc.ITEM_ID) not like upper('209116') AND UPPER(sc.ITEM_ID) not like upper('209113') AND UPPER(sc.ITEM_ID) not like upper('209119') AND UPPER(sc.ITEM_ID) not like upper('209118') AND UPPER(sc.ITEM_ID) not like upper('207375') AND UPPER(sc.ITEM_ID) not like upper('208224') AND UPPER(sc.ITEM_ID) not like upper('208230') AND UPPER(sc.ITEM_ID) not like upper('208227') AND UPPER(sc.ITEM_ID) not like upper('208228') AND UPPER(sc.ITEM_ID) not like upper('208226') AND UPPER(sc.ITEM_ID) not like upper('207052') AND UPPER(sc.ITEM_ID) not like upper('208229') AND UPPER(sc.ITEM_ID) not like upper('221892') AND UPPER(sc.ITEM_ID) not like upper('207981') AND UPPER(sc.ITEM_ID) not like upper('213840') AND UPPER(sc.ITEM_ID) not like upper('213842') AND UPPER(sc.ITEM_ID) not like upper('220438') AND UPPER(sc.ITEM_ID) not like upper('213848') AND UPPER(sc.ITEM_ID) not like upper('213847') AND UPPER(sc.ITEM_ID) not like upper('214930') AND UPPER(sc.ITEM_ID) not like upper('209345') AND UPPER(sc.ITEM_ID) not like upper('215073') AND UPPER(sc.ITEM_ID) not like upper('215072') AND UPPER(sc.ITEM_ID) not like upper('215053')))
AND(
(
sc.MODULE_ID = 'iblock'
AND sc.PARAM1 = 'aspro_max_catalog'
AND sc.PARAM2 in ('73', '81')
))
)
ORDER BY CUSTOM_RANK DESC, TITLE_RANK ASC, TITLE
LIMIT 500[[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/lubimchik.by/bitrix/modules/main/lib/db/mysqliconnection.php:137
Stack trace:
#0 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/db/connection.php(330): Bitrix\Main\DB\MysqliConnection->queryInternal('SELECT \n\t`main_...', Array, NULL)
#1 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/orm/query/query.php(3357): Bitrix\Main\DB\Connection->query('SELECT \n\t`main_...')
#2 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/orm/query/query.php(825): Bitrix\Main\ORM\Query\Query->query('SELECT \n\t`main_...')
#3 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/orm/data/datamanager.php(500): Bitrix\Main\ORM\Query\Query->exec()
#4 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/analytics/sitespeed.php(95): Bitrix\Main\ORM\Data\DataManager::getList(Array)
#5 /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/analytics/counter.php(92): Bitrix\Main in /home/bitrix/ext_www/lubimchik.by/bitrix/modules/main/lib/db/mysqliconnection.php on line 137