count: 59, time: 0.016375780105591
, 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 (630471,630472,630473,630474,630475,630476,630477,630478,630479,630480,630481,630482,630483,630484,630485,630486,630487,630488,630489,630490,630491,630492,630493,630494,630495,630496,630497,630498,630499,630500,630501,630502,630503,630504,630505,630506,630507,630508,630509,630510,630511,630512,630513,630514,630515,630516,630517,630518,630519,680112,687174,698379,712468,715144,717684,717967,718017,718019,726650), array:
