Фильтр
По популярности По алфавиту По цене
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (2006) MySQL server has gone away (400)

					SELECT
						F.FACET_ID
						,F.VALUE
						,MIN(F.VALUE_NUM) MIN_VALUE_NUM
						,MAX(F.VALUE_NUM) MAX_VALUE_NUM
						,MAX(case when LOCATE('.', F.VALUE_NUM) > 0 then LENGTH(SUBSTRING_INDEX(F.VALUE_NUM, '.', -1)) else 0 end) VALUE_FRAC_LEN
						,COUNT(DISTINCT F.ELEMENT_ID) ELEMENT_COUNT
					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_41_index F ON BE.ID = F.ELEMENT_ID
					WHERE
						F.FACET_ID in (1126,1556,1126,1556,227)
						 AND F.ELEMENT_ID IN (734075,734190,734406,734976,734982,734996,735000,735005,735061,735116,735168,735745,735747,735761,735767,735779,735894,736052,736463,736467,736471,736875,736919,736929,737504,737523,737531,740226,740230,740263,740312,741202,741738,741744,741760,741765,741770,741782,741806,743260,744007,744558,744563,744577,744582,744586,744631,744633,744640,744678,745314,745318,745613,745661,745691,745742,746348,746364,746367,746457,746488,746489,746517,746565,746576,747181,747196,747204,749093,749094,749329,749938,749944,749958,749962,749966,750055,750157,750202,750793,750796,750812,750816,750851,751129,751514,751520,751540,751547,752018,752019,752202,752342,752545,752616,752687,752716,752807,752880,752881,752932,752987,752994,753609,753615,753627,753634,753640,755164,755179,755890,756561,756566,756579,756583,756587,756668,756669,756670,756671,757786,758837,758838,762490,762595,762619,763183,763187,763207,763210,763318,763400,763401,764166,764211,764268,764916,764921,764939,764943,764947,765181,765182,765184,765185,766046,766181,766202,766275,766827,766834,766852,766975,766999,769651,769657,769661,769677,769680,769685,770681,770682,771763,771770,771776,771787,771792,771796,772527,772528,772664,772706,773234,773260,773265,773267,773546,774168,775725,776268,776420,776627,776689,776755,776786,776810,776907,776908,776909,777457,777478,778041,778044,778064,778067,778112,778446,778741,779736,780458,780464,780470,780487,780492,780496,780848,781435,781439,781454,781459,781464,781754,781761,781763,783373,785506,786300,786448,787050,787064,787066,787071,787076,787106,787108,787538,787644,787724,788284,788289,788294,788311,788316,788467,788478,789077,789084,789088,789109,790839,790974,791114,791323,791461,791495,791533,792195,792200,792204,792223,792228,794318,794349,794980,794990,795010,795014,795874,797114,797206,797234,797237,797792,797815,798359,798464,799120,799124,799140,799144,799148,800701,801359,801365,801380,801384,801389,801394,801395,801396,801397,801449,801518,802073,802100,802104,802108,802756,802758,802773,802862,802937,803519,803525,803530,803549,804737,804776,805151,805152,805162,806121,806149,806200,806264,806268,806350,806924,806942,1381391,1381494,1381500,1386804,781466,781467,781468,1527913,1527914,1527915,1527923,1528080,1565068,1565073,1381496,1381497,1901907,1902053,1902055,1902057,1902059,1902065,1902067,1902069,1902394,1902471,1905805,738411,795044,1906200,1906230,1906324,1903163,1903165,2493588,2493590,2493592,2493594,2493596,2493598,2493600,2493602,2493604,2493606,2493608,2493610,1906210,1906352,1906212,1906214,1906216,1906218,1906220,1906222,1906224,1906354,1906356,1906358,1906360,1906362,1906364,2500623,2500625,2500627,2500629,2500631,2500633,2500635,2500637,2500651,2500653,2500655,2500657,2500659,2500661,2500663,1906228,1906366,2500641,2500665,2500669,1385829,1386129,1387591,1387719,1388146,1389032,1389710,1390028,2602444,2620813,2620815,2620819,2620825,2625420,784655,781512,1565072,2631441,2631471,2631515,2631525,1387364,3497968,2631261,2631291,746414)
					GROUP BY
						F.FACET_ID, F.VALUE
				
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
	/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
	/home/bitrix/www/bitrix/components/nextype/magnet.smart.filter/facet.php:375
#2: FacetMagnet->query(array)
	/home/bitrix/www/bitrix/components/nextype/magnet.smart.filter/component.php:60
#3: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:605
#4: CBitrixComponent->__includeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:103
#5: CBitrixComponent->executeComponent()
	/home/bitrix/www/bitrix/components/nextype/magnet.smart.filter/class.php:136
#6: CBitrixCatalogSmartFilter->executeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:656
#7: CBitrixComponent->includeComponent(string, array, object, boolean)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1039
#8: CAllMain->IncludeComponent(string, string, array, object, array)
	/home/bitrix/www/bitrix/templates/magnet_s2/components/nextype/magnet.landing/main/page_blocks/products.php:139
#9: include(string)
	/home/bitrix/www/bitrix/templates/magnet_s2/components/nextype/magnet.landing/main/template.php:10
#10: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:789
#11: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:884
#12: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:764
#13: CBitrixComponent->showComponentTemplate()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:712
#14: CBitrixComponent->includeComponentTemplate()
	/home/bitrix/www/bitrix/components/nextype/magnet.landing/component.php:167
#15: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:605
#16: CBitrixComponent->__includeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:680
#17: CBitrixComponent->includeComponent(string, array, boolean, boolean)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1039
#18: CAllMain->IncludeComponent(string, string, array, boolean, array)
	/home/bitrix/ext_www/s2/include/components/landing.php:77
#19: include_once(string)
	/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#20: include_once(string)
	/home/bitrix/www/bitrix/urlrewrite.php:2