count: 94, time: 0.01826810836792
, 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 (575911,576298,578561,578565,613389,615591,627190,627191,627192,627193,627194,627195,627196,627197,627198,627199,627200,627201,627202,627203,627204,627205,627206,627207,627208,627209,627210,627211,632045,650836,651098,658663,662711,663087,663089,663866,665859,667931,667952,668460,668462,668769,669288,670389,670391,672514,672515,672516,674537,675047,679782,683562,684583,686883,686888,689239,696038,696049,696050,696051,720627,720628,720629,720630,720631,720632,720861,720862,720863,720864,720865,720866,720867,720868,720869,720870,720871,720872,720873,720874,720875,720876,720877,720878,720879,720880,720881,720882,720883,720884,720885,721399,721671,726091), array:
