count: 49, time: 0.019659996032715
, 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 (575776,575777,579657,579796,579797,625262,632650,633133,651634,657642,657644,657741,658108,658331,658347,658348,658349,660336,660337,660338,661425,661904,662297,662482,663795,664897,664990,666645,668193,669062,670358,676758,682369,684387,684714,696580,699856,699893,700102,700131,700689,707234,707749,708705,712390,712731,714560,715969,718025,718026,718993,718994,718995,718996,719075,719308,721411,723168,723390,726326,726017,726490,726689,727654,632907), array:
