count: 132, time: 0.025970935821533
, 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 (575543,575951,576213,576462,576571,578020,625997,625999,628210,628211,628212,628213,628214,628215,628216,628217,628218,628219,720278,628220,628221,628222,628223,628224,628225,628226,628227,628228,628229,628230,628231,628232,628233,628234,628235,628236,628237,628238,628239,628240,628241,628242,628243,628244,628245,628246,628247,628248,628249,628250,628251,628252,628253,628254,628255,628256,628257,628258,628259,628260,628261,628262,628263,628264,628265,628266,628267,628268,628269,628270,628271,631050,631408,631958,632083,632084,632097,632098,632099,632100,632101,632102,632764,660665,661137,661138,661139,661140,661141,661623,662880,663786,663787,663840,663923,663924,664824,665138,665139,665140,665371,666046,666886,667161,674198,674199,675183,676461,678656,678672,680198,680441,680617,681901,683144,684901,685351,690493,690494,699274,695955,700761,711470,712778,713824,716813,716814,721724,721925,722797,723169,726610), array:
