count: 60, time: 0.013499975204468
, 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 (578596,579025,579641,651275,651557,651803,661788,664486,722931,725999,726742,668957,726932,669044,727801,669899,670343,670569,671900,673265,673629,674397,675672,675690,679136,681632,683366,683453,685285,687270,687368,690129,700312,702554,711168,714972,715031,715032,715033,715034,715035,715036,715037,715038,715039,715040,715041,715042,715043,715044,715045,715046,715047,715048,715049,715050,715051,715052,715161,723775), array:
