count: 122, time: 0.013866901397705
, 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 (576137,576286,577728,577896,577942,578037,578706,578708,578709,578710,578711,579202,615963,625237,625316,625317,625318,625319,625320,625321,625322,625323,625324,625325,625326,625327,625328,625329,625330,625331,625332,625333,625334,625335,625336,625337,625338,625339,637518,637520,650877,650878,651001,651741,658257,658994,659005,661142,661181,666165,668096,668189,668211,668240,669329,671258,671259,672589,673272,673298,676827,677814,678510,678919,681204,683334,683335,683543,684882,685231,687406,688569,688737,688767,689297,690570,690572,690579,697087,698755,699053,699214,700561,701050,701118,701265,701266,701367,702613,702614,702654,702981,707628,708491,708670,709067,709160,709278,710940,712174,712461,712781,714717,714799,715106,716028,718270,718934,719210,719238,719711,722951,722955,722956,723110,724172,725854,725916,725971,727190,727929,721822), array:
