count: 94, time: 0.012870788574219
, 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 (626363,626364,626365,626366,626367,626368,626369,626370,626371,626372,626373,626374,626375,626376,626377,626378,626379,626380,626381,626382,626383,626384,626385,626386,626387,626388,626389,626390,626391,626392,626393,626394,626395,626396,626397,626398,626399,626400,626401,626402,626403,626404,626405,626406,626407,626408,626409,626410,626411,626412,626413,626414,626415,626416,626417,626418,626419,626420,626421,626422,626423,626424,626425,626426,626427,626428,626429,626430,626431,626432,626433,626434,626435,626436,626437,626438,626439,626440,626441,626442,626443,626444,626445,626446,626447,626448,626449,651540,676907,676909,676923,682656,697981,717103), array: