count: 93, time: 0.019465923309326
, 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 (579047,580142,613632,615809,615915,615916,615918,615949,615951,627746,627747,627748,627749,627750,627751,627752,627753,627754,627755,627756,627757,627758,627759,627760,627761,627762,627763,627764,627765,627766,627767,627768,627769,627770,627771,627772,627773,627774,627775,627776,627777,627778,627779,627780,627781,627782,627783,627784,627785,627786,627787,627788,627789,627790,632916,651271,662823,663119,663167,663617,663618,663754,664965,666013,667791,667883,668772,670566,670725,671262,674003,675710,676041,676073,677308,677451,677492,677749,679367,679661,680015,680795,681385,683351,685401,698200,698201,698432,709586,714905,716152,723384,727598), array: