count: 282, time: 0.03265118598938
, 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 (577953,579845,612953,629304,629305,629306,629307,629308,629309,629310,629311,629312,629313,629314,629315,629316,629317,657525,657536,662526,663918,663949,663950,664223,664224,664225,664226,664227,664228,664229,664785,664786,664787,664788,664789,665105,665265,666127,666949,667182,667763,667922,668834,668902,725240,668919,668956,669135,669136,669141,669612,669772,670973,670974,670976,671546,671679,671680,674343,674755,675075,676096,677164,678357,679416,679417,679930,680070,681907,682019,683374,684415,686648,687319,687320,689803,690256,690428,690727,695530,696141,697221,698096,698284,698362,698423,713906,713907,713908,713909,713910,713911,724860,578353,578354,578355,578356,578920,579330,625928,630778,630779,630780,630969,630970,631435,657537,662199,662748,663064,663065,663066,663067,663311,663605,663839,664322,664323,664324,664830,664912,664913,664914,665329,665868,666304,666690,666691,667218,667219,667220,667221,667222,667223,668512,668851,668852,668907,669586,669587,669588,670083,670645,671746,713994,714224,714225,714226,672853,714227,673945,714228,714229,674754,714230,714231,714232,714233,714234,675642,714235,675652,714236,714254,714255,676169,714605,676171,716392,676172,716393,677029,717141,717846,718760,678866,722928,678867,722993,678868,723081,678869,723082,726784,726785,679878,679879,680008,680103,681205,681239,681240,681432,681433,681434,681889,681890,682863,683558,683559,684262,685511,686646,686674,690095,698049,698886,698887,698888,699400,699773,699881,701123,702682,706959,707675,707676,707677,707678,707679,707680,707681,707682,707683,707684,707685,707686,707687,711293,711578,711642,711794,711883,712070,670316,689890,625255,714199,720342,723136,723323,725615,725808,726618,670730,670731,671775,671776,671777,674983,674984,676162,686783,690150,695537,695624,707331,709818,713807,698614,707500,709952,709953,700862,715177,716541,718146,718147,721489,722103,722665,725455,726635,671526,709436,702133,702136,702695,707028,708390,708391,708698,709623,710113,710130,710131,710132,711197,712020,713119,713840), array:
