count: 50, time: 0.011293888092041
, 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 (721732,722245,722674,722675,723332,723594,726538,726539,726540,726541,726542,726543,726561,726562,726566,726567,726568,726569,726570,727700,720042,716804,716921,580750,662864,663557,667840,671044,721812,727204,700478,710338,711008,711042,711043,711055,711056,711057,711058,711059,711060,711061,711062,711063,711064,711094,711095,712464,713968,698932), array: