count: 48, time: 0.0085198879241943
, 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 (700862,727821,727822,727823,727824,727825,727826,727827,727828,727829,727830,727831,727832,715177,727833,716541,727834,718146,727835,718147,727836,721489,727837,722103,727838,722665,727839,725455,727840,726635,727841,671526,709436,702133,702136,702695,707028,708390,708391,708698,709623,710113,710130,710131,710132,711197,712020,713119), array:
