count: 121, time: 0.013885974884033
, 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 (575931,575932,575933,575934,579926,628664,628665,628666,628667,628668,580105,628669,628670,628671,628672,628673,628674,628675,628676,628677,628678,628679,628680,628681,628682,628683,628684,628685,628686,628687,628688,628689,628690,628691,628692,628693,628694,628695,628696,628697,628698,628699,630734,630736,630737,630738,631450,651587,651791,651792,651793,651794,651795,657437,657438,657439,657440,657887,658033,658034,658065,658066,658067,658068,658069,658070,658071,658072,661921,661922,661923,661924,661925,661926,662495,662668,662669,662670,662671,662672,662673,662790,662791,662793,663325,664096,665839,665840,665841,665842,665863,665864,666061,669979,669981,674067,674672,674673,678217,678218,678219,678220,678836,678837,678838,678839,679281,681854,681855,681856,681857,681858,682365,684164,684972,684973,684974,684977,685424,685425,713286), array:
