Каталог товаров
Меню
[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 LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='POD_ZAKAZ' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_price as CAT_P12 on (CAT_P12.PRODUCT_ID = BE.ID and CAT_P12.CATALOG_GROUP_ID = 12) left join b_catalog_product as CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock as CAT_IB on ((CAT_PR.VAT_ID IS NULL or CAT_PR.VAT_ID = 0) and CAT_IB.IBLOCK_ID = BE.IBLOCK_ID) left join b_catalog_vat as CAT_VAT on (CAT_VAT.ID = IF((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID)) left join b_catalog_store_product as CAT_SP20 on (CAT_SP20.PRODUCT_ID = BE.ID and CAT_SP20.STORE_ID = 20) left join b_catalog_store_product as CAT_SP16 on (CAT_SP16.PRODUCT_ID = BE.ID and CAT_SP16.STORE_ID = 16) left join b_catalog_store_product as CAT_SP17 on (CAT_SP17.PRODUCT_ID = BE.ID and CAT_SP17.STORE_ID = 17) left join b_catalog_store_product as CAT_SP8 on (CAT_SP8.PRODUCT_ID = BE.ID and CAT_SP8.STORE_ID = 8) left join b_catalog_store_product as CAT_SP13 on (CAT_SP13.PRODUCT_ID = BE.ID and CAT_SP13.STORE_ID = 13) left join b_catalog_store_product as CAT_SP14 on (CAT_SP14.PRODUCT_ID = BE.ID and CAT_SP14.STORE_ID = 14) left join b_catalog_store_product as CAT_SP15 on (CAT_SP15.PRODUCT_ID = BE.ID and CAT_SP15.STORE_ID = 15) left join b_catalog_store_product as CAT_SP10 on (CAT_SP10.PRODUCT_ID = BE.ID and CAT_SP10.STORE_ID = 10) left join b_catalog_store_product as CAT_SP11 on (CAT_SP11.PRODUCT_ID = BE.ID and CAT_SP11.STORE_ID = 11) left join b_catalog_product as PRD on (PRD.ID = BE.ID) INNER JOIN b_iblock_26_index F ON BE.ID = F.ELEMENT_ID WHERE F.SECTION_ID = 21717 and F.FACET_ID in (19458,19462,19464,19456,19466,22902,22904,22924,22926,19468,19470,19472,19474,19476,19478,19480,19482,19484,19488,19490,19492,19494,19496,19498,19500,19502,19504,19506,19508,19510,19512,19514,19516,19518,19520,19522,19524,19526,19528,19530,19532,19534,19536,19540,19546,19548,19550,19552,19554,19556,19558,19560,19562,19564,19566,19568,19570,19572,19574,19576,19578,19580,19582,19584,19586,19588,19592,19594,19596,19598,19600,19602,19604,19606,19608,19610,19612,19614,19616,19620,19622,19624,19626,19628,19630,19632,19634,19636,19638,19640,19644,19646,19648,19650,19652,19654,19656,19658,19660,19662,19664,19666,19670,19672,19674,19676,19680,19682,19684,19686,19688,19690,19692,19694,19696,19698,19700,19702,19704,19706,19708,19710,19712,19714,19716,19718,19722,19724,19726,19728,19730,19732,19734,19736,19738,19740,19742,19744,19746,19752,19754,19756,19758,19760,19762,19764,19768,19770,19772,19774,19776,19778,19780,19782,19788,19790,19794,19796,19798,19800,19804,19806,19808,19814,19818,19820,19822,19824,19826,19828,19830,19832,19834,19836,19838,19840,19842,19844,19846,19848,19850,19852,19854,19856,19858,19860,19862,19864,19866,19868,19870,19872,19874,19878,19880,19882,19884,19886,19888,19890,19894,19896,19898,19900,19902,19906,19908,19910,19912,19914,19916,19918,19920,19922,19924,19926,19928,19930,19932,19934,19936,19938,19940,19944,19946,19948,19950,19952,19954,19956,19958,19960,19962,19964,19966,19968,19970,19972,19974,19976,19978,19980,19982,19984,19986,19988,19990,19992,19994,19996,19998,20000,20002,20004,20006,20008,20010,20012,20014,20016,20018,20020,20024,20026,20028,20030,20032,20034,20036,20038,20040,20044,20046,20048,20050,20052,20054,20056,20058,20060,20062,20064,20066,20068,20070,20072,20074,20076,20078,20080,20082,20084,20086,20088,20090,20092,20094,20096,20098,20100,20102,20104,20106,20108,20110,20112,20114,20116,20120,20122,20124,20128,20130,20134,20136,20138,20140,20142,20144,20146,20148,20150,20152,20154,20156,20158,20160,20162,20164,20166,20168,20170,20172,20174,20176,20178,20180,20182,20184,20186,20188,20190,20192,20194,20196,20198,20200,20204,20206,20208,20210,20212,20214,20216,20220,20222,20224,20226,20228,20230,20232,20234,20236,20238,20240,20242,20244,20246,20248,20250,20252,20254,20256,20258,20260,20262,20264,20266,20268,20270,20272,20276,20278,20280,20282,20286,20288,20290,20292,20294,20296,20298,20300,20302,20304,20308,20310,20312,20314,20316,20318,20320,20322,20324,20326,20328,20330,20332,20334,20336,20338,20340,20342,20344,20346,20348,20350,20352,20354,20356,20358,20360,20362,20364,20366,20370,20372,20374,20376,20378,20380,20382,20384,20386,20388,20390,20392,20394,20396,20398,20400,20402,20404,20406,20408,20410,20412,20414,20416,20420,20422,20424,20426,20428,20430,20432,20434,20438,20442,20444,20446,20448,20450,20452,20454,20456,20458,20460,20462,20464,20466,20468,20470,20472,20474,20476,20478,20480,20482,20484,20486,20488,20490,20492,20494,20498,20500,20502,20504,20506,20508,20510,20512,20514,20516,20518,20522,20526,20528,20530,20532,20534,20536,20538,20542,20544,20546,20550,20552,20554,20556,20558,20560,20562,20564,20566,20570,20572,20574,20576,20578,20580,20582,20586,20588,20590,20592,20594,20596,20598,20600,20602,20604,20606,20608,20612,20614,20616,20618,20620,20622,20624,20626,20630,20634,20636,20638,20640,20642,20644,20646,20648,20650,20652,20654,20656,20658,20660,20662,20664,20666,20668,20670,20672,20674,20676,20678,20680,20682,20684,20686,20688,20690,20692,20694,20696,20698,20700,20702,20704,20706,20708,20710,20712,20714,20716,20718,20720,20722,20724,20726,20728,20732,20734,20736,20738,20740,20742,20744,20746,20748,20750,20754,20756,20758,20760,20762,20764,20766,20768,20770,20772,20774,20778,20780,20782,20784,20786,20788,20790,20792,20796,20798,20800,20802,20804,20806,20808,20810,20812,20814,20816,20818,20820,20822,20824,20826,20828,20830,20832,20834,20836,20838,20840,20842,20844,20846,20848,20850,20852,20854,20860,20862,20864,20866,20868,20870,20872,20876,20878,20880,20882,20884,20888,20890,20892,20894,20896,20898,20900,20902,20904,20908,20910,20912,20914,20916,20918,20920,20922,20924,20926,20928,20930,20932,20934,20936,20938,20940,20942,20944,20946,20948,20950,20952,20954,20956,20958,20960,20962,20964,20966,20970,20972,20974,20976,20978,20980,20982,20984,20986,20988,20990,20992,20994,20996,20998,21000,21004,21006,21008,21010,21012,21014,21016,21018,21020,21022,21024,21026,21028,21030,21032,21034,21036,21038,21040,21044,21046,21048,21050,21052,21054,21056,21058,21060,21062,21066,21070,21072,21074,21080,21082,21084,21088,21090,21092,21094,21096,21098,21100,21102,21104,21110,21112,21114,21116,21118,21122,21124,21126,21128,21130,21132,21134,21136,21138,21140,21142,21144,21146,21148,21150,21152,21154,21158,21160,21162,21164,21168,21170,21172,21176,21178,21180,21182,21184,21186,21188,21190,21192,21194,21198,21200,21202,21204,21206,21208,21210,21212,21214,21216,21218,21220,21222,21224,21226,21228,21230,21232,21236,21238,21240,21242,21244,21246,21248,21250,21252,21254,21256,21258,21260,21262,21266,21268,21270,21272,21274,21276,21278,21280,21282,21284,21286,21288,21290,21292,21296,21298,21300,21302,21304,21306,21308,21310,21312,21314,21316,21318,21320,21322,21324,21326,21328,21332,21334,21336,21338,21344,21346,21348,21350,21352,21354,21356,21358,21360,21362,21364,21366,21368,21370,21372,21374,21376,21378,21380,21382,21386,21390,21392,21394,21396,21398,21400,21402,21404,21406,21408,21410,21412,21414,21416,21418,21422,21424,21426,21428,21430,21436,21438,21440,21442,21444,21446,21448,21452,21454,21456,21458,21460,21462,21466,21468,21472,21474,21476,21478,21480,21482,21484,21486,21488,21490,21492,21494,21496,21498,21500,21502,21504,21506,21508,21510,21512,21514,21516,21518,21520,21522,21524,21526,21528,21530,21532,21534,21536,21538,21540,21542,21544,21546,21550,21552,21554,21556,21558,21560,21562,21564,21568,21570,21572,21574,21576,21578,21580,21582,21584,21586,21588,21590,21592,21594,21596,21598,21600,21602,21604,21606,21608,21610,21614,21616,21618,21620,21622,21624,21626,21628,21630,21632,21634,21636,21638,21640,21642,21644,21646,21648,25) AND ( ( ( ((((CAT_SP20.AMOUNT >= '1')))) ) OR ( ((((CAT_SP16.AMOUNT >= '1')))) ) OR ( ((((CAT_SP17.AMOUNT >= '1')))) ) OR ( ((((CAT_SP8.AMOUNT >= '1')))) ) OR ( ((((CAT_SP13.AMOUNT >= '1')))) ) OR ( ((((CAT_SP14.AMOUNT >= '1')))) ) OR ( ((((CAT_SP15.AMOUNT >= '1')))) ) OR ( ((((CAT_SP10.AMOUNT >= '1')))) ) OR ( ((((CAT_SP11.AMOUNT >= '1')))) ) ) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.IBLOCK_ID = '26')))) AND ((( FPV0.VALUE_NUM IS NULL OR NOT (FPV0.VALUE_NUM = '1')))) AND ((((CAT_P12.PRICE > '0')))) 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' )) )) GROUP BY F.FACET_ID, F.VALUE /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/lib/db/mysqliconnection.php:153 #0: Bitrix\Main\DB\MysqliConnection->queryInternal /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/lib/db/connection.php:327 #1: Bitrix\Main\DB\Connection->query /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/iblock/lib/propertyindex/facet.php:340 #2: Bitrix\Iblock\PropertyIndex\Facet->query /home/bitrix/ext_www/bober-stroy.ru/bitrix/components/bitrix/catalog.smart.filter/component.php:68 #3: include(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:607 #4: CBitrixComponent->__includeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:105 #5: CBitrixComponent->executeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/components/bitrix/catalog.smart.filter/class.php:149 #6: CBitrixCatalogSmartFilter->executeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:660 #7: CBitrixComponent->includeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/main.php:1072 #8: CAllMain->IncludeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/templates/.default/components/bitrix/catalog/catalog/section_lvl1.php:98 #9: include(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/templates/.default/components/bitrix/catalog/catalog/section.php:81 #10: include(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component_template.php:790 #11: CBitrixComponentTemplate->__IncludePHPTemplate /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component_template.php:885 #12: CBitrixComponentTemplate->IncludeTemplate /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:776 #13: CBitrixComponent->showComponentTemplate /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:716 #14: CBitrixComponent->includeComponentTemplate /home/bitrix/ext_www/bober-stroy.ru/bitrix/components/bitrix/catalog/component.php:323 #15: include(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:607 #16: CBitrixComponent->__includeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/component.php:684 #17: CBitrixComponent->includeComponent /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/classes/general/main.php:1072 #18: CAllMain->IncludeComponent /home/bitrix/ext_www/bober-stroy.ru/index.php:2175 #19: include_once(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/modules/main/include/urlrewrite.php:184 #20: include_once(string) /home/bitrix/ext_www/bober-stroy.ru/bitrix/urlrewrite.php:2 ----------