count: 72, time: 0.011817932128906
, 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 (576663,630776,631192,631307,632300,632593,632639,632645,633161,650578,662305,663396,664253,664559,665186,665187,666146,666439,667318,667320,667321,667322,667323,667576,667983,669533,670469,670470,671723,672664,675321,675563,675629,675630,675791,675798,677701,678717,679376,679447,681378,682525,684040,685515,685586,686945,699639,699946,699977,700622,701264,707280,707429,707972,709092,711272,711937,711968,712292,712822,713170,714008,714878,716385,719390,720338,721487,721495,723183,725530,727548,720596), array:
