count: 178, time: 0.015557050704956
, 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 (617697,617698,617699,617700,617701,617702,617703,617704,617705,617706,617707,617708,617709,617710,617711,617712,617713,617714,617715,617716,617717,617718,617719,617720,617721,617722,617723,617724,617725,617726,617727,617728,617729,617730,617731,617732,617733,617734,617735,617736,617737,617738,617739,617740,617741,617742,617743,617744,617745,617746,617747,617748,617749,617750,617751,617752,617753,617754,617755,617756,617757,617758,617759,617760,617761,617762,617763,617764,617765,617766,617767,617768,617769,617770,617771,617772,617773,617774,617775,617776,617777,617778,617779,617780,617781,617782,617783,617784,617785,617786,617787,617788,617789,617790,617791,617792,617793,617794,617795,617796,617797,617798,617799,617800,617801,617802,617803,617804,617805,617806,617807,617808,617809,617810,617811,617812,617813,617814,617815,689194,696284,696285,696286,696287,696288,696289,696290,696291,696292,696293,696294,696295,698777,698778,699005,699988,700410,701040,701818,702088,702230,706848,706872,707075,707517,707519,707971,708077,713956,714119,719525,721374,724581,724582,637515,637516,661779,666069,666300,666301,666310,668032,670335,672202,672203,674044,676302,678062,678155,678593,678744,679171,680485,681941,682299,682501,684438,687018), array:
