count: 239, time: 0.017224073410034
, 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 (612826,612827,612828,612829,612830,612831,612832,612833,612834,612835,612889,612890,612891,612892,612893,612894,612895,612896,612897,612898,612899,612900,613113,613114,613115,613116,613117,613118,613119,613120,613121,613122,613123,613124,613125,613126,613127,613128,613129,613130,613131,611429,613132,613133,613134,612901,613135,612902,613136,612903,613137,612904,613138,612905,613139,612906,613140,612907,613147,612908,613148,612909,613149,612910,613150,612911,613151,612912,613152,612913,613153,612914,613154,612915,613155,612932,613156,612933,613157,612934,613158,612935,613159,612936,613160,612937,613161,612938,613162,613163,613164,613165,613166,615424,615425,615426,615427,615428,613466,615429,613467,615430,613474,615431,613475,615432,613476,615433,613477,615434,613478,615435,613479,615443,613480,615444,613481,615445,613482,615446,613483,615447,613484,615448,613485,615449,613486,615451,613487,615660,613507,615661,613508,615662,613509,615663,613510,615664,613511,615665,613512,615666,613513,615667,613514,615668,613515,615669,613516,615676,613517,615677,615678,615679,615680,615681,615682,615683,615684,615685,615686,615687,615688,615469,615689,615470,615690,615471,615691,615472,615692,615693,615694,615695,615742,615743,615744,615745,615746,615747,615748,615749,615760,615750,615761,615751,615762,615752,615763,615753,615764,615754,615765,615757,658567,663626,665049,672483,615871,615872,615873,712487,687439,687440,687441,687442,687443,687444,687445,687446,687447,687448,687449,687450,687451,687452,687453,687455,687456,687457,687458,687459,687460,687461,687462,687463,687464,687465,687466,687467,687468,687469,687470,687471,687472,687473,687474,687475,687476), array:
