count: 42, time: 0.0086660385131836
, 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 (577982,613613,615824,615825,615957,669498,674365,676209,680304,681914,682768,696517,696526,696527,696528,696529,696530,696533,696534,696535,697214,697269,697276,697277,697278,697279,697280,697968,700370,701334,701335,701837,702685,713292,716249,719589,719599,719663,721617,721953,721993,722996), array: