count: 472, time: 0.027613878250122
, 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 (576034,577549,578349,578566,579548,616206,616207,625940,625941,625942,625943,625944,625945,625946,625947,576033,625948,625949,625951,657526,625952,625953,667626,625954,625955,625956,625957,625958,675592,625959,625960,625961,630891,680436,631097,631588,632705,632722,632723,632738,633114,633149,633150,637106,637499,650642,658399,658803,659256,661563,661700,661920,661998,662084,662602,662719,662992,663046,663222,663357,663380,663647,663806,664354,664355,665360,665468,666158,666200,666268,666700,666947,666962,667064,667135,667491,667522,667716,667845,667865,667961,667967,670342,667969,668009,668115,668116,668306,677482,668531,679574,669046,669065,669068,669079,669114,669275,669328,669471,669472,669635,669771,670062,670217,670262,670297,670360,670367,670433,670434,670476,670583,670808,671232,671250,671265,671283,671367,671462,671463,671742,671921,672475,672555,672556,672557,672558,672829,672830,672832,673107,673162,673251,673354,673464,673573,673804,674238,674261,674277,674417,674518,675482,675502,675533,675639,675658,675907,676098,676226,676462,677063,677204,677205,677206,677233,677278,677465,677528,677549,677579,677678,677841,677883,677992,678035,678356,678547,679223,679620,679624,679625,679626,711996,679739,711997,679900,711998,680060,711999,680163,712000,680351,712001,680917,712003,680931,712006,681286,712007,681358,681673,681712,681793,681806,681927,682020,682885,683393,683643,684012,684074,684085,684529,685288,685317,685454,685628,685629,685687,686603,686884,687010,687082,687090,687292,687918,688336,688397,688652,688658,688898,689048,689149,689192,689204,689298,689658,689662,689724,689787,689981,690227,690286,690472,690516,695350,695809,695951,695971,695972,695973,695974,695978,695991,696085,696103,696132,696153,696613,696704,697913,722074,698127,722075,698131,698466,722249,698479,698653,698738,698739,698740,698741,699124,699286,699292,699535,699799,699849,699962,699963,700023,700024,700032,700237,601174,700481,700963,700991,701141,701183,701636,701954,702072,702124,702138,702263,702386,702590,702704,702942,702956,706828,707458,707522,707581,707751,707962,708070,708223,708233,708267,708288,708354,708477,708571,708744,708853,709225,709536,709554,709618,709919,710063,710064,710717,710768,711425,711462,711613,711622,711688,711773,711796,615604,711827,711929,712015,711953,712613,712783,712870,713105,713259,714087,714101,714103,714104,714357,714455,714566,714722,715068,715075,715171,715244,715822,716868,721963,715830,717136,715881,717160,717161,717162,717228,717880,717986,718421,718528,718726,718733,718734,718735,718736,718737,718770,718771,718772,718773,718951,718956,718980,718983,718986,719270,719339,719626,719666,720035,720066,720339,720340,720341,720929,720955,721155,721381,721391,721392,721404,721414,721553,721571,721624,721681,721740,722798,722804,722911,723242,723266,723267,723268,723269,723270,723271,723272,723273,723274,723275,723276,723277,723278,723290,723880,723898,723927,727689,723962,727782,724774,727783,724811,727842,724888,726181,727843,725233,726182,727844,725316,726183,727845,725472,726184,727846,725640,726185,727847,725687,726186,727848,726189,727849,725960,726238,727850,726107,726718,727851,726138,727852,726807,727853,726893,727854,726962,727855,727040,727856,727128,727857,727858,727859,727927,680313,689656,700964,707776,710081,631596,632663,650669,651513,665227,667006,679991,721819), array:
