count: 540, time: 0.047261953353882
, 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 (575580,575837,575948,576204,576405,578164,578253,578261,578284,578836,579108,579116,579325,579904,580004,580148,580172,580173,580174,580175,580176,580177,580178,580180,580181,580182,580183,580184,580185,580186,580187,580188,580189,580191,580192,580193,580194,580195,580196,580197,580198,580199,580200,580201,580203,580204,580205,580206,715743,580512,580519,580526,580555,580590,714473,714912,715205,715984,715987,716021,716542,716543,716681,716689,716692,716829,716979,717063,717064,717699,717760,718050,718055,718686,718778,718835,718960,719024,719426,719671,720237,720266,720901,721386,721689,721693,721906,721907,721911,580816,722431,722673,722676,722677,722678,722679,722681,722683,722684,722688,722689,722690,722691,722692,722693,722694,722724,722927,723263,723337,723347,723525,723555,723563,723583,723613,723700,723799,723855,723862,723863,723999,724121,724809,724911,615379,724942,725312,725595,615392,725624,725636,725638,725650,725935,726045,726046,726209,726073,726281,615608,726094,726311,726517,726550,726609,726623,726687,615936,726808,727299,727786,727800,616537,625209,630708,631580,632002,632089,632124,632288,632604,632646,632647,632762,637500,651000,651370,651622,651776,657262,657299,657645,657724,658141,658276,658436,658745,660712,660713,660714,660716,661842,661948,662162,662414,662759,663051,663312,663558,664064,664127,664155,664418,664466,664592,664619,664984,665107,665189,665313,665520,665588,665599,665658,665659,665672,665833,666270,666902,666925,667200,667289,667297,667445,667478,667687,667723,667757,667911,667995,668228,668247,668248,668324,668385,668730,668735,668899,668900,669070,669081,669097,669216,669280,669401,669703,670373,670460,670695,670743,670744,670850,670851,670907,671213,671363,671468,671491,671647,671808,671956,672016,672017,672176,672221,672238,672239,672277,672464,672510,672538,672605,672617,672759,672875,672877,672878,672883,673036,673046,673047,673310,673546,673608,673772,673908,674082,674124,674180,674273,674626,674732,675033,675105,675377,675392,675448,675507,675570,675918,675934,675951,676018,676120,676535,676895,677529,677691,677712,677785,677813,677829,678076,678095,678284,678355,678434,678450,678568,678750,678758,678789,678834,679382,679410,679413,679812,679824,679843,679844,679850,680234,680434,680467,680653,680690,680696,680747,680750,680859,681176,681325,681326,681431,681754,681807,681844,681987,681995,682034,682167,682259,682762,682774,682775,683434,683465,683521,683616,683682,683716,683917,683924,683938,683977,684197,684337,684601,684620,684832,684834,685019,685219,686679,686921,687112,687173,687296,687401,687810,688048,688055,721813,688394,688404,688466,689029,689166,689255,689630,689714,724928,690253,690374,690387,695489,695652,695759,695850,696126,696134,696334,696355,696655,696667,696692,697240,697252,698024,698073,698222,698276,698420,698526,698756,698840,698909,699134,699154,699426,699714,699769,699831,699896,699904,699967,700000,700194,700248,700309,700364,700420,700551,700555,700857,700888,700913,701385,701450,701553,701784,701878,702027,702610,702620,702807,702809,702813,702867,703058,703096,706842,706858,707160,707423,707797,707838,707919,707988,708175,708208,708248,708365,709166,709568,710041,710111,710187,710188,710190,710201,710202,710203,710204,710205,710206,710343,710344,710345,710346,710347,710349,710350,710351,710352,710374,710375,710376,710378,710379,710434,710699,710725,710774,711025,711026,711027,711028,711029,711030,711031,711032,711033,711034,711035,711068,711070,711071,711072,711222,711243,711486,711519,711520,632040,711704,711778,711917,712008,712333,712335,712344,712408,712409,712465,712478,712772,712795,712831,712865,712866,712875,712876,712877,712890,712895,712896,712897,712898,713223,713261,713882,713989,714063,714269,714308,714384,714402,714417,661210), array:
