count: 54, time: 0.0090579986572266
, 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 (578937,579221,579222,579223,579224,579225,689167,698542,700506,707006,707401,708404,713925,718153,718594,718595,718718,719223,719660,719787,719788,719796,720240,720243,720500,720502,721951,722929,723651,724862,725798,725886,725906,726286,726800,726809,726843,726985,727138,711810,711811,711812,711813,711814,711815,711816,631241,631242,631243,631609,651260,666128,670802,681595), array:
