count: 209, time: 0.019641876220703
, 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 (579201,615806,615942,631578,632714,632715,651060,651166,651167,651477,651817,657368,657818,658409,658603,661152,661153,661507,661508,661802,661908,662800,663059,663253,663341,663348,664021,664022,664254,664286,664306,664307,664498,664803,664966,665211,665257,666023,666024,666025,666085,666214,666663,667073,667268,667586,667742,667960,667978,668157,668682,670080,670307,670501,670927,670967,671498,671981,672321,672665,672792,672793,673068,673183,673738,674791,675276,676871,676974,677967,678337,678391,678402,678552,678718,678830,679141,679449,679677,679801,679908,679909,680446,680766,681110,681237,681525,681528,681564,682125,682274,682346,682851,682941,683221,683317,683443,683587,683707,683797,684051,684310,684317,684665,684716,684804,684931,684954,685026,685142,685395,685520,687196,688435,688789,689009,689137,690033,690216,690350,690400,690406,690414,695294,695642,695953,696641,696653,696737,697110,697194,698263,698264,698265,698266,698267,698411,698557,698558,698642,699375,699506,700416,700484,700559,700673,701170,701332,701365,701614,701626,702094,702866,702903,706957,706973,707140,707206,707208,707385,708539,710450,708955,710667,709098,710693,709311,711255,709449,711259,709681,711396,711565,711874,713869,713870,714460,714798,714809,715064,715967,716026,716332,716812,718015,718024,718251,718492,718635,719744,719745,720940,721563,721601,721893,721973,723048,723886,724912,723918,725295,724072,725812,726710,727160,727538,727544,727624,727818), array:
