count: 68, time: 0.0090479850769043
, 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 (627687,627688,627689,627690,627691,627692,627693,627694,627695,627696,627697,627698,627699,627700,627701,627702,627703,627704,627705,627706,627707,627708,627709,627710,627711,627712,627713,627714,627715,627716,627717,627718,627719,627720,627721,627722,627723,627724,627725,627726,627727,627728,627729,627730,627731,627732,627733,627734,627735,627736,627737,627738,627739,627740,627741,627742,627743,627744,627745,663097,664549,698190,698376,708984,712508,714824,714825,717094), array: