count: 149, time: 0.042150974273682
, 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 (575570,575768,575769,575770,575917,576167,576225,576657,576658,576659,577726,577857,578936,578938,578942,578947,578977,578978,578979,578980,578981,579502,579814,579815,612842,612957,613791,615934,626905,626906,626907,626908,626909,626910,626911,626912,626913,626914,626915,626916,626917,626918,626919,626920,626921,626922,626923,626924,626925,626926,626927,626928,626929,626930,626931,626932,626933,626934,626935,626936,626937,626938,626939,626940,626941,626942,626943,626944,626945,626946,626947,626948,626949,626950,626951,626952,626953,626954,626955,626956,626957,626958,626959,626960,626961,626962,633059,650629,650689,650691,659130,659177,659178,659236,662308,662763,662764,662882,664399,665559,666511,668392,677271,677514,678127,678798,678975,679592,682279,683206,683439,684375,685223,685283,685420,686582,687028,687029,687030,687031,687032,687033,687034,687079,687397,688713,688729,690767,695336,698300,699335,699343,707596,714446,707754,714468,708524,717204,708875,717948,709223,718248,709299,722014,711566,723244,724791,725852,679172), array:
