count: 84, time: 0.017543077468872
, 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 (575808,575847,576339,576631,577502,577755,577842,578500,579723,616251,616528,626290,626291,626292,626293,626294,626295,626296,626297,626298,626299,626300,626301,626302,632613,651248,658838,659574,661878,664380,664579,666794,666833,668122,668339,668855,668903,669198,669636,669718,670129,670497,670498,671563,672071,672523,674973,675737,676562,677968,678226,680005,681902,682088,682130,682391,682659,682950,683049,683877,683926,685514,687885,689271,695331,701732,702304,702979,707349,707439,710022,710830,714616,714617,714619,714620,714621,719381,719761,720223,721865,724509,724901,726925,727632), array:
