count: 115, time: 0.0204918384552
, 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 (580027,580028,580037,580039,612922,628937,628938,628939,628940,628941,628942,628943,628944,628945,628946,628947,628948,628949,628950,628951,628952,628953,628954,628955,628956,628957,628958,628959,628960,628961,628962,628963,628964,628965,628966,628967,628968,628969,628970,628971,628972,628973,628974,628975,628976,628977,628978,628979,628980,628981,628982,628983,628984,628985,628986,628987,628988,628989,628990,628991,628992,628993,628994,628995,628996,628997,628998,628999,629000,629001,629002,629003,629004,629005,629006,629007,629008,629009,629010,629011,629012,629013,629014,631735,632643,651015,672384,674924,674925,674926,674927,674928,674929,674931,674933,674934,686773,686774,686775,686776,686777,686778,686779,686780,686781,686782,697298,697299,699986,703106,706869,707347,709465,709526,712779,718668,723678,726665), array:
