count: 247, time: 0.01832389831543
, 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 (576100,576266,576331,576345,576573,578881,613038,616587,616588,616635,625283,625302,627791,627792,627793,627794,627795,627796,627797,627798,627799,627800,627801,627802,627803,627804,627805,627806,627807,627808,627809,627810,627811,627812,627813,627814,627815,627816,627817,627818,627819,627820,627821,627822,627823,627824,627825,627826,630947,630981,631960,632625,650971,651039,651040,651041,651042,651043,651044,651045,651046,651047,651048,651207,651208,657285,657444,657561,657562,658621,658657,658811,660609,660610,660611,660612,660613,660614,660615,660616,660617,660618,660619,660620,660621,660622,660623,660624,660625,660626,660627,662943,663280,663294,663947,663948,664255,664682,664696,664866,665369,668454,668459,669336,669581,669699,670855,672495,672587,673000,673696,674120,674367,674444,674528,675203,675429,675800,677729,678292,678549,678648,678832,679263,679282,679377,679664,679703,680171,680218,680219,680220,680221,680222,680361,680432,681507,681917,682531,682534,682535,682536,682537,682783,683230,683253,683401,683402,683581,683582,683583,683597,684073,684156,684382,684383,684407,684410,684984,685189,685190,685328,685334,686768,686934,687050,687241,578453,687766,687837,687923,687946,688147,689017,689295,690050,696182,696312,696411,698268,698549,698793,699225,699828,699869,699870,699873,699933,699939,699940,700362,700399,700502,700647,700893,701172,701376,701580,701736,702022,702220,702982,702983,703021,706928,707133,707386,707734,708709,708721,708969,709688,709689,709690,710112,710172,710483,710721,711555,711635,711686,712212,712423,715349,715884,717843,717963,718084,718658,719202,719422,719824,720244,721174,721831,723550,723579,723882,725635,725958,725961,726235,726651,727148,727535,727717,721818), array:
