count: 142, time: 0.020776987075806
, 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 (576031,578115,578237,578385,578386,578935,580002,612821,632256,632474,632616,651367,658445,659509,661430,661431,661432,661433,661434,661581,662749,663934,666826,667641,667998,668360,668811,668812,668813,668831,669477,672950,673173,673482,675390,675413,675840,675925,676504,676934,677241,677455,678432,678527,678754,679192,679912,681173,681842,681843,722042,722843,723667,724753,725491,685714,725596,686557,686885,686894,689176,689569,690582,695669,695735,695806,696577,696589,697264,698057,698678,699157,701081,701277,701508,701509,701552,702319,702575,707042,707915,708780,711863,713144,714974,714975,714977,714978,714979,714980,714981,714982,714983,714984,714985,714986,714987,714988,714989,714990,714991,714992,714994,714995,714996,714997,714998,714999,715000,715001,715002,715003,715004,715005,715006,715007,715008,715009,715010,715011,715012,715013,715014,715015,715016,715017,715018,715019,715020,715021,715022,715023,715024,715025,715026,715027,715028,715029,715030,715081,716303,719199), array:
