count: 190, time: 0.017606973648071
, 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 (615856,615857,615858,615859,615860,615861,615862,615863,615864,615865,615874,626350,626351,626352,626353,626354,626355,626356,626357,626358,626359,626360,626361,626362,629236,629237,629238,629239,629240,629241,629242,629243,629244,629245,629246,629247,629248,629249,629250,629251,629252,629253,629254,629255,629256,629257,629258,629259,629260,629261,629262,629263,629264,629265,629266,629267,629268,629269,629270,629271,629272,629273,629274,629275,629276,629277,629278,629279,629280,629281,629282,629283,629284,629285,629286,629287,629288,629289,629290,629291,629292,629293,629294,629295,629296,629297,629298,629299,629300,629301,629302,629303,637340,651786,659309,659500,662157,665303,665533,673511,673726,673870,676187,680925,685005,688579,697970,699036,702258,713372,713373,713374,713375,713376,713377,713378,713379,713380,713381,713382,713383,713384,713385,713386,713387,713388,713389,713390,713391,713392,713393,713394,713395,713396,713397,713398,713399,615886,713400,615887,713401,713402,713403,713404,713405,713406,713407,713408,713409,713410,713411,713412,713413,713414,713415,713486,713487,713488,713489,713490,713491,713492,713493,713494,713495,713496,713497,713498,713499,713500,713501,713502,713503,713504,713505,721920,687454,713363,713364,713365,713366,713367,713368,713369,713370,713371,673450,673722,674009,679701), array:
