count: 335, time: 0.023971796035767
, sql: SELECT `modx_site_content`.`id` as `cid`,`modx_site_content`.`parent`,`cats`.`pagetitle` as `category`,`modx_site_content_tmc`.`sku` as `tmcsku`,`modx_site_content_tmc`.`manuf`,`modx_site_content_params`.*,`modx_site_content_sklad`.* FROM `modx_site_content` JOIN `modx_site_content_tmc` ON `modx_site_content_tmc`.`resource` = `modx_site_content`.`id` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN (SELECT `modx_site_content`.`pagetitle`,`modx_site_content`.`parent`,`modx_site_content`.`id` FROM `modx_site_content` WHERE `template`=3) as `cats` ON `cats`.`id` = `modx_site_content`.`parent` WHERE `published`=1 AND `deleted`=0 AND `modx_site_content`.`id` IN (579549,615943,619998,619999,620000,620001,620002,620003,620004,620005,620006,620007,620008,620009,620010,620011,620012,620013,620014,620015,620016,620017,620018,620019,620020,620021,620022,620023,620024,620025,620026,620027,620028,620029,620030,620031,620032,620033,620034,620035,620036,620037,620038,620039,620040,620041,620042,620043,620044,620045,620046,620047,620048,620049,620050,620051,620052,620053,620054,620055,620056,620057,620058,620059,620060,620061,620062,620063,620064,620065,620066,620067,620068,620069,620070,620071,620072,620073,620074,620075,620076,620077,620078,620079,620080,620081,620082,620083,620084,620085,620086,620087,620088,620089,620090,620091,620092,620093,620094,620095,620096,620097,620098,620099,620100,620101,620102,620103,620104,620105,620106,620107,620108,620109,620110,620111,620112,620113,620114,620115,620116,620117,620118,620119,620120,620121,620122,620123,620124,620125,620126,620127,620128,620129,620130,620131,620132,620133,620134,620135,620136,620137,620138,620139,620140,620141,620142,620143,620144,620145,620146,620147,620148,620149,620150,620151,620152,620153,620154,620155,620156,620157,620158,620159,620160,620161,620162,620163,620164,620165,620166,620167,620168,620169,620170,620171,620172,620173,620174,620175,620176,631938,658602,661820,664388,665156,665157,665545,665546,665547,665548,665549,665550,665551,665552,665553,665554,665555,667434,667450,668040,669010,669333,672938,674601,675493,675700,676323,676324,676325,676326,676327,676328,676329,676330,676331,676332,676333,676334,676335,676336,676337,676438,676915,677006,677413,677756,677757,677758,677759,677760,677761,678928,679319,679586,679587,679612,679725,679726,680058,680123,680124,680349,680627,681185,681186,681201,681406,682773,683378,683541,684108,684321,684344,684399,684580,685293,687913,688124,688485,689236,689329,695543,696324,696509,696510,696511,696512,696513,696514,696515,696516,698237,698279,698698,698919,698960,699116,699117,699534,699820,699821,699822,700207,700339,700637,700927,701022,701403,701669,702219,702350,702354,702372,706874,707118,707330,707501,708334,708375,708423,708546,709972,710046,712484,714301,715175,716299,717209,717573,717588,717960,717961,718010,718018,718607,718923,718924,719389,720196,720212,721183,721362,721527,721733,721809,721858,721860,723292,723293,723294,724512,726142,726226,727942,680181), array:
